Using EXCEL

Using EXCEL

Using EXCEL

he 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.

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 Daily availability Leather (ft) 42 ft? Sewing (hr) 40 hr Finishing (hr) Selling price (8) 22 1 2 2 1 1 3 2 1 5 45 hr 24 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