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). Adjusted Forecast Month Cheese Cheese Cheese Balls Nachos Total Monthly Sale Potato Chips January S $ $287,682 February $ SI $292,748 March SI S $297.815 April $ S 5 $302.881 May S $307,948 June $344,315 July SI $400,781 August S $441,095 September S $482,474 October SI $466,592 November S $473,685 December $ $480,778 Total s $4,578,793 More Info -X x Month Cheese Balls Total Sales January February March April May June July August September October November December $126,000 $119,900 $114,300 $128,000 $112,300 $114,900 $128,300 $124,800 $134,300 $144,400 $153,200 $143,300 Cheese Nachos $70,600 $68,700 $75,700 $62,300 $72,000 $77,400 $77,500 $83,300 $79,200 $77,100 $65,900 $93,800 Cheese Potato Chips $34,400 $36,400 $42,000 $54,700 $62,700 S59,700 $67,200 $58,900 $41,500 $46,500 $55,900 $49,900 $231,000 $225,000 $232,000 $245,000 $247,000 $252,000 $273,000 $267,000 $255,000 $268,000 $275,000 $287,000 $3,057,000 Print Done More Info - X Month January 2020 February March April May June July August September October November December Adjusted Forecast, Total Monthly Sale $287,682 $292,748 $297,815 $302.881 $307,948 $344,315 $400,781 $441,095 $482,474 $466,592 $473,685 $480,778 $4,578,793 Print Done