Question: Need Excel solution only with formulation. Note: If 5 more hours can be made available for swing or finishing, which one it should be allocated

Need Excel solution only with formulation. Note: If 5 more hours can be made available for swing or finishing, which one it should be allocated to. see image for details.

Need Excel solution only with formulation. Note:

3-31. The Gutchi Company manufactures purses, shaving bags, and backpacks. The construction includes leather and synthetics, leather being the scarce raw material. The production process requires two types of skilled labor: sewing and finishing. The following table gives the availability of the resources, their usage by the three products, and the profits per unit. Resource requirements per unit Resource Purse Bag Backpack 1 Daily availability 42 ft? 40 hr 45 hr Leather (ft) Sewing (hr) Finishing (hr) Selling price ($) 2 5 22 45 a. Formulate the problem as a linear program, and find the optimum solution (using TORA, Excel Solver, or AMPL). b. From the optimum solution, determine the status of each resource

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!