After developing her 2017 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 2016 sales results and finds the following figures:

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

Transcribed Image Text:

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