Question: A B D E F G H J L M N o 4 6 1 2 Question 1 A manufacturing plant makes two types of

A B D E F G H J L M N o 4 6 1 2 Question 1 A

A B D E F G H J L M N o 4 6 1 2 Question 1 A manufacturing plant makes two types of inflatable boatsa two-person boat and a four-person boat. 3 They usually sell twice as many two-person boats, so number of two-person boats needs to be twice the number of four-person boats. Each two-person boat requires 0.9 labor-hour in the cutting department and 0.8 labor-hour in the assembly department. 5 Each four-person boat requires 1.8 labor-hours in the cutting department and 1.2 labor-hours in the assembly department. The maximum labor-hours available each month in the cutting and assembly departments are 864 and 680 respectively. 7 The company makes $25 on each two-person boat and $40 on each four-person boat. How many boats do they need to produce for maximum profit? 9 10 Boats: 2-person 4-person 11 Profit per boat: $ 25.00 $ 40.00 12 Constraints Usage Constraint Available Left over 13 Double -2 0 0 0 14 8 a) List the constaints in the table to the left. You may also list them below if that's helpful for you. 1 = 0 0 15 16 17 b) Graph the constaints in desmos.com and save as a .png file. (Hit Share, Export Image, Save.) Attach it as a separate file in Blackboard, or include it in this Excel file. Graph must be zoomed in so I can see all of the details of where the constraints intersect the axes. 18 19 Production: 20 Two-persons 21 Four-persons 22 Profit= $ 23 24 25 26 27 28 c) Use Excel's Solver to find the maximum profit

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!