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. Hes collected the following data on these products:
Item Profit per Unit Steel lb Fabric lb Labor Hr
Chain mail
Plate armor
Wiglaf determines that he only has lb of steel, lb of fabric and hr 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
Please solve using Excel Solver mine doesnt work but i know how to set up the problem
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
