After developing her 2020 forecast (Example 9.8), 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?” Jamie goes back to the 2019 sales results and finds the following figures:

Using this information and the 2020 adjusted forecast results shown in Figure 9.22, 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.

CHEESE CHEESE CHEESE POTATO TOTAL MONTH BALLS NACHOS CHIPS SALES $230,000 $126,500 $69,000 $34,500 January $230,000 February $119,600 $73,600 $36,800 March $115,200 $81,600 $43,200 $240,000 April $125,000 $70,000 $55,000 $250,000 $112,800 $64,800 $62,400 $240,000 May $115,000 $75,000 $60,000 $250,000 June July $126,900 $75,600 $67,500 $270,000 $124,800 $75,400 $59,800 $260,000 August September $135,200 $83,200 $41,600 $260,000 October $135,200 $78,000 $46,800 $260,000 November $151,200 $72,800 $56,000 $280,000 December $142,100 $98,600 $49,300 $290,000 $3,060,000