Question: Please write formula not in excel for part a) thanks Homework #1: LP Math Modeling Due date: September 26th by Midnight Instructions: Please electronically submit

Please write formula not in excel for part a)

Please write formula not in excel for part a)

thanks

Homework #1: LP Math Modeling Due date: September 26th by Midnight Instructions: Please electronically submit your answers to the Course Web by the due date. For Part (a), you can either handwrite the formulation and scan it or use Microsoft Word to type it. EquiBags makes equipment bags for professional camera equipment, and it offers two models: regular and deluxe. The company has a prior pricing agreement with a distributor who is willing to buy as much of each kind of bag as it can make. There are three steps in making a bag: cutting, sewing, and finishing. Each regular bag requires hour in cutting, 1.25 hours in sewing, and 0.75 hours in finishing. Each deluxe bag needs 2 hours in cutting, 1.75 hours in sewing, and 0.5 hours in finishing. The profit obtained for each regular bag is $10, while that for each deluxe bag is $15. The director of manufacturing estimates that 630 hours for cutting, 600 hours for sewing, and 708 hours for finishing will be available during the next production cycle. To maximize the profit, the company needs to determine the optimal number of regular and deluxe bags to produce in the next production cycle. a) Mathematically formulate a linear programming model that determines the optimal number of regular and deluxe bags that EquiBags needs to produce in the next production cycle. (10 points) b) Formulate your linear program in Excel and use solver to solve it. (10 points)

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!