(***) After developing her 2013 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 2012 sales results and finds the following figures:
Example 9.8:
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. (Hint: Use the 2012 figures to estimate what percentage of demand is accounted for by each product type.)
Figure 9.22:
