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 small-time, profit-maximizing 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 453524
Plate armor 758348
Wiglaf determines that he only has 60 lb. of steel, 48 lb. of fabric and 320 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 50% 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 blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!