Table 3: Price of Club Sets
Men's: $225.00
Women's: $195.00
Junior's: $165.00
Table 4: Number of Club Sets Ordered
To/From: Sacramento, Denver, Pittsburgh
Men's: 700, 550, 900
Women's: 900, 1000, 1200
Junior's: 900, 1500, 1100
Table 1: Resources required per Club Set (in lbs)
Titanium: Men's 2.9, Women's 2.7, Junior's 2.5
Aluminum: Men's 4.5, Women's 4, Junior's 5
Wood: Men's 5.4, Women's 5, Junior's 4.8
Table 2: Estimated resource Availability (in lbs)
Daytona: Titanium 4500, Aluminum 6000, Wood 9500
Memphis: Titanium 8500, Aluminum 12000, Wood 16000
Tempe: Titanium 14500, Aluminum 19000, Wood 18000
Table 5: Shipping Costs
To/From: Sacramento, Denver, Pittsburgh
Daytona: Men's $51, Women's $49, Junior's $31
Memphis: Men's $10, Women's $33, Junior's $8
Tempe: Men's $10, Women's $9, Junior's $8
Daytona: Men's $28, Women's $27, Junior's $21
Memphis: Men's $42, Women's $22, Junior's $40
Tempe: Men's $43, Women's $42, Junior's $42
Daytona: Men's $36, Women's $34, Junior's $12
Memphis: Men's $66, Women's $13, Junior's $54
Tempe: Men's $56, Women's $54, Junior's $52
a. Formulate an LP model for this problem.
b. Create a spreadsheet model for this problem and solve it using Solver. What is the optimal solution?
c. If Rick wanted to improve this solution, what additional resources would be needed and where would they be needed? Explain.