Question: Wiglaf is a small - time, profit - maximizing blacksmith that produces armor for his local lord. His team only produces chain mail and plate
Wiglaf is a smalltime, profitmaximizing blacksmith that produces armor for his local lord. His team only produces chain mail and plate armor. Both items require steel, fabric and labor. He's collected the following data on these products:
tableItemProfit per Unit,Steel lbFabric lbLabor HrChain mail,Plate armor,
Wiglaf determines that he only has of steel, of fabric and of labor.
a Formulate this as an LP written math problem: state the decision variables, objective function, and list all the constraints. No need to solve it yet or make an Excel model.
b Now Wiglaf discovers that due to lackluster manufacturing, half of the total available fabric is unsuitable to be used in chain mail. Further Wiglaf learned there is a new law that at least of labor hours used must go towards plate armor. Create an Excel LP model including this new constraint. Solve the model using Excel Solver. Provide an image of your model, solver screen, and report the optimum solution. Round decimals to the nearest hundredth.
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
