Explore BrainMass

Maxwell Manufacturing makes two models of felt tip marking

1. The number of pizzas ordered on Friday evenings between 5:30 and 6:30 at a pizza delivery location for the last 10 weeks is shown below. Use exponential smoothing with smoothing constants of .2 and .8 to forecast a value for week 11 (i.e., prepare two forecasts using each of the alpha values). Compare your forecasts using MSE. Which smoothing constant does a better job using lower MSE as the criterion?

58, 46, 55, 39, 42, 63, 54, 55, 61, 52

2. A trend line for the attendance at a restaurant's Sunday brunch is given by
Number = 264 + .72(t)

How many guests would you expect in week 20?

(no catch here - it's a simple question ;-)> )

Maxwell Manufacturing makes two models of felt tip marking pens. Requirements for each lot of pens are given below.

Fliptop Model Tiptop Model Available
Plastic 3 4 36
Ink Assembly 5 4 40
Molding Time 5 2 30

The profit for either model is $1000 per lot.

a. What is the linear programming model for this problem?
b. Find the optimal solution.
c. Will there be excess capacity in any resource?


Solution Preview

See the attached file for complete solution. The text here may not be copied exactly as some of the symbols / tables may not print. Thanks
Week Number of Pizzas Ordered Exponential Smoothing with alpha=0.2 Forecast error Square of Forecast error Exponential Smoothing with alpha=0.8 Forecast error Absolute Forecast ...

Solution Summary

This post solves three problems. First is on exponential smoothing, second one on linear regression and third one on linear programming