# Forecasting and Linear programming problems

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 ;-)> )

3. 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?

https://brainmass.com/math/linear-programming/forecasting-and-linear-programming-problems-119212

#### Solution Summary

This posting contains solution to following forecasting and Linear programming problems.

Linear Programming / Sensitivity Analysis / Optimization: Please solve in Excel using Solver add-in and also do Sensitivity Report to solve and support answers. The EnergyBoat Company

The Background

The EnergyBoat, Inc. produces and distributes high quality motor boat with highly seasonal demand. To handle this seasonality, the company has several options for its supply chain aggregated planning purposes: hiring an additional workers during peak seasons, outsourcing part of the demand to a third party manufacturer, building up inventory during the slow months, or backorder the demand which will be delivered in the following month.

To determine how to best use these options, the vice president of production and distribution started with the demand forecast over the next six months, as shown in the following table:

Month Demand forecast

May 2,000

June 3,200

July 4,000

August 5,200

September 2,500

October 2,500

EnergyBoat sells each product to retailer for $900. The company has a starting inventory at the beginning of May of 1,200 units. At the beginning of May the company has a workforce of 200 employees. The plant has a total of 20 working days in each month, and each employee earns $30 per regular hour. Each worker works 8 regular hours a day, if they work overtime, their hourly wage is $45/hour. The capacity of the plant is determined by the total labor hours worked. Therefore, machine capacities and raw materials do not limit the capacity of the production operation. Due to the labor rules, no employee will work more than 8 hours of overtime per month. The various costs are shown in the following table:

Item Cost

Material cost $120/unit

Inventory Holding cost $20/unit/month

Marginal cost of backorder $60/unit/month

Hiring & Training $2000/worker

Layoff cost $5000/worker

Labor hours required 15 hours/unit

Regular labor cost $30/hour

Overtime labor cost $45/hour

Cost of subcontracting $760/unit

EnergyBoat has no limits on subcontracting, inventory storage and backorder. All backorders are supplied from the following months' production. Inventory costs are incurred based on the ending inventory of each month. The supply chain manager's goal is to obtain the optimal aggregate plan that allows EnergyBoat to end October with at least 1800 units in inventory.

The Questions

1. The optimal aggregate plan is the one that results in the highest profits over the six-month planning period. Given EnergyBoat's desire to maintain high customer service, all demands must be satisfied. Formulate the optimization problem and solve it.

2. While the optimal production plan can be obtained, the vice president is concerned about several issues. One issue is the over-time labor cost, the union is considering raising the over-time wages from $45 to $47 in the coming contract. Given this becomes true, the vice president is wondering its impact on the optimal plan and the optimal profit, will the original optimal plan be still optimal? How much does the optimal profit change?

3. The second issue is demand forecast which is generated by actual sales of the past several years. From previous experience, the forecasts are subject to errors, the vice president wants to know the impact of the forecast errors on the optimal profits, i.e., suppose the actual sales is slightly higher (lower) than the forecast, how will the optimal profit change? And in what range of the forecast error the rates of changes are valid?

View Full Posting Details