After developing her 2013 forecast, Jamie Favre gets a visit from Cheeznaxs production manager, Mark Mobley. Mark says, I think the forecast is ne, but

After developing her 2013 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?” Jamie goes back to the
2012 sales results and finds the following figures:

Using this information and the 2013 adjusted forecast results shown in Figure 9.22, develop a forecast for each product in each month of 2013. The sum of the individual product forecasts should equal the monthly total sales forecast.

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