Question: **********PLEASE MAKE SURE THAT YOU ANSWER FOR EVERY MONTH NOT JUST JANUARY********* THANK YOU This is all of the information given in the question After

 **********PLEASE MAKE SURE THAT YOU ANSWER FOR EVERY MONTH NOT JUSTJANUARY********* THANK YOU This is all of the information given in thequestion After developing her 2020 forecast, Jamie Favre gets a visit from

**********PLEASE MAKE SURE THAT YOU ANSWER FOR EVERY MONTH NOT JUST JANUARY********* THANK YOU

This is all of the information given in the question

After developing her 2020 forecast, Jamie Favre gets a visit from Cheeznax's production manager, Mark Mobley. Mark says, "I think the forecast is fine, but I really need estimates of demand broken out by product type. In other words, how much of each month's demand do we think will consist of cheese balls, cheese nachos, and cheese potato chips?" Using the 2019 sales results and the 2020 adjusted forecast results, develop a forecast for each product in each month of 2020. The sum of the individual product forecasts should equal the monthly total sales forecast. (Hint: Use the 2019 figures to estimate what percentage of demand is accounted for by each product type.) Click the icon to view the 2019 sales results. Click the icon to view the adjusted forecast results for 2020. Calculate the forecasts for each product in each month of 2020 and fill in the table below (enter your responses rounded to the nearest dollar). NOTE: Be sure to round all calculations for percentage of demand accounted for by each product type to at least one decimal place before proceeding. Also, be sure to calculate each adjusted forecast using these percentage of demand values (as opposed to subtracting from the given total monthly sales). \begin{tabular}{lcccc} \hline \multicolumn{1}{c}{ Month } & Cheese Balls & CheeseNachos & CheesePotatoChips & Total Sales \\ \hline January & $125,100 & $62,900 & $37,000 & $225,000 \\ February & $118,800 & $81,000 & $35,200 & $235,000 \\ March & $115,000 & $80,800 & $42,200 & $238,000 \\ April & $126,700 & $57,000 & $56,300 & $240,000 \\ May & $111,500 & $65,800 & $61,700 & $239,000 \\ June & $115,300 & $73,500 & $59,200 & $248,000 \\ July & $128,200 & $74,900 & $67,900 & $271,000 \\ August & $124,300 & $75,700 & $59,000 & $259,000 \\ September & $135,600 & $90,900 & $41,500 & $268,000 \\ October & $134,200 & $78,900 & $45,900 & $259,000 \\ November & $152,700 & $77,000 & $55,300 & $285,000 \\ December & $139,900 & $108,700 & $48,400 & $297,000 \\ \hline \end{tabular} \begin{tabular}{lc} \hline \multicolumn{1}{c}{ Month } & AdjustedForecast,TotalMonthlySale \\ \hline January 2020 & $291,970 \\ February & $297,606 \\ March & $303,242 \\ April & $308,879 \\ May & $314,515 \\ June & $352,167 \\ July & $410,493 \\ August & $452,394 \\ September & $495,479 \\ October & $479,776 \\ November & $487,667 \\ December & $495,558 \\ \cline { 2 - 2 } & $4,689,745 \\ \hline \end{tabular}

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!