# Probability Linear Programming and Demand Forecast

Please see attachment.

1. Roger's Regalia is a manufacturer of caps, gowns, and assorted party outfits, primarily for the commencement season. (80 percent of their yearly sales occur over a six-week period.) One of their popular products is a Parrot Head, sometimes worn by graduating college students as a sign of festive occasions. The Parrot Head is produced China, so Roger's Regalia must make a single order well in advance of the upcoming season. Roger, the owner, has prepared the following demand forecast.

Demand

(dozens) Relative

Frequency

5,000 0.0183

10,000 0.0733

15,000 0.1465

20,000 0.1954

25,000 0.1954

30,000 0.1563

35,000 0.1042

40,000 0.0595

45,000 0.0298

50,000 0.0132

55,000 0.0053

60,000 0.0019

65,000 0.0006

70,000 0.0002

75,000 0.0001

Roger's Regalia sell the Parrot Head for a wholesale price of $12. Their production cost, including the transportation, duty, and shipping, is $6 per Head. Leftover inventory is sold to discounters for $2.50. Due to production batch considerations, orders must be in multiples of 5000 units.

a. Suppose Roger's Regalia orders 40,000 Parrot Heads. What is the chance they have to liquidate 10,000 or more Heads with a discounter?

b. What order quantity maximizes Roger's Regalia's expected profit?

c. If Roger's Regalia wants to have a 90 percent in-stock probability, then how many Parrot Heads should be ordered?

d. If Roger's Regalia orders the quantity chosen in part c, what is Roger's Regalia's actual in-stock percentage?

2. A professor built an LP model to maximize profits for his client (a maker of fan club souvenirs), solved the model, and generated some output from the solver. Unfortunately, in his absent-mindedness, he deleted the Excel workbook and all other information from his computer. All that remains is a one-page printout with the following information:

Adjustable Cells

Cell Name Final Value Reduced

Cost Objective Coefficient Allowable Increase Allowable Decrease

$C$5 Parrot Heads 31.25 0 30 32.66666667 0.666666667

$D$5 Salt Shakers 125 0 22 0.5 14.5

$E$5 Fins 100 0 25 1E+30 24.5

Constraints

Cell Name Final Value Shadow Price Constraint R.H. Side Allowable Increase Allowable Decrease

$F$12 Molding LHS 900 0.125 900 100 166.6666667

$F$13 Cutting LHS 500 7.25 500 250 150

$F$14 Painting LHS 162.5 0 200 1E+30 37.5

$F$15 Sales Max LHS 100 24.5 100 41.66666667 75

Using the information in these tables, answer the following questions or state that "The answer can not be determined with the information given."

a. What is the profit (the optimal value) of the optimal solution?

b. Which constraints are binding?

c. If the available amount of painting capacity decreased by 25 hours, what would be the change in the optimal values of the decision variables and the optimal value of the objective function? Would anything else change?

d. If the available amount of molding capacity increased by 200 hours to 1100 hours, how would that affect the optimal value of the objective function?

e. If the available amount of cutting capacity increased by 20 hours to 520 hours, how would that affect the optimal value of the objective function?

© BrainMass Inc. brainmass.com October 9, 2019, 9:18 pm ad1c9bdddfhttps://brainmass.com/statistics/probability/probability-linear-programming-demand-forecast-180075