Question: please include excel solver solution ABC Manufacturing produces two models of bicycles (Models A & B). Both models use a slightly different frame, which is
please include excel solver solution
ABC Manufacturing produces two models of bicycles (Models A & B). Both models use a slightly different frame, which is manufactured at the Worthington Manufacturing facility. The frames require the following amounts of manufacturing time in the Fabricating Department: Model A requires 2.8 hours per frame and Model B requires 3.3 hours per frame. The Fabricating Department has 1,200 labor hours maximum available during the next production period. In addition, Model A requires 40 minutes per bicycle in the Final Assembly Department and Model B requires 55 minutes per bicycle in the Final Assembly Department. The Final Assembly Department has 1,100 labor hours maximum available during the next production period. The high-tech wheels for each model (2 per bicycle) are identical and are purchased from a sole supplier with limited capacity. This supplier can supply a maximum of 3,000 wheels next production period. The V.P. of Marketing has specified that the amount of Model B produced must be at least 20% more than the amount of Model A produced. Worthington earns the following profit from each bicycle sold: A - $300 & B = $350. Formulate a linear programming problem to maximize profits next period
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
