17. (***) After developing her 2009 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, I need to see how much of each month’s demand will consist of cheese balls, cheese nachos, and cheese potato chips.” Jamie goes back to the 2008 sales results and finds the following figures:

Using this information and the 2009 adjusted forecast results shown in Figure 9.21, develop a forecast for each product in each month of 2009. The sum of the individual product forecasts should equal the monthly total sales forecast. (Hint: Use the 2008 figures to estimate what percentage of demand is accounted for by each product type.)

CHEESE MONTH CHEESE CHEESE BALLS NACHOS POTATO TOTAL CHIPS SALES January $126,500 $69,000 $34,500 $230,000 February $119,600 $73,600 $36,800 $230,000 March $115,200 $81,600 $43,200 $240,000 April $125,000 $70,000 $55,000 $250,000 May $112,800 $64,800 $62,400 $240,000 June July $115,000 $126,900 $75,600 August $124,800 $75,400 September $135,200 $83,200 October $135,200 $78,000 $75,000 $60,000 $250,000 $67,500 $270,000 $59,800 $260,000 $41,600 $260,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