Question: Please explain how to do the following question in excel the same way as it was done with a different example (two questions have the
Please explain how to do the following question in excel the same way as it was done with a different example (two questions have the same LP model and ask the same thing)

Here's an example from a different question how it should be done: 
The Pigskin company will produce footballs over the next six months. Forecasted demand and production costs over this time period are: Pigskin has a monthly production capacity of 300 cases (each case includes 100 footballs). The company currently has 50 cases of footballs in inventory, and has enough capacity to store up to 100 cases. The holding cost of keeping a football in inventory for a month is estimated to be 10% of the cost of producing in that month. a) Formulate a Linear Programming model that minimizes the cost. b) Solve the model using Excel Solver
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
