Solve the following problem to find the maximum profit by creating a spreadsheet.

a. A company is making Boats and Motors. The boats sell for $22,000 and the motors sell for $15,000.
b. There are 3 factories available to make the products.
c. Factory 1 requires 9 hours to make a boat and is not capable of making motors. It has 84 hours available.
d. Factory 2 does not have the capability to make boats and requires 3 hours to make a motor. It has 40 hours available.
e. Factory 3 requires 16 hours to make a boat and 5 hours to make a motor. It has 120 hours available.

Respuesta :

Answer:

Maximum profit = $765,333.33

Explanation:

Note: See the attached excel file for the calculation of the maximum profit (in bold red color).

In the calculation, it is assumed that selling price per unit is the same thing as the profit per unit since we are not given the cost per unit.

Therefore, from the attached excel file, we have:

Maximum profit = $765,333.33

Ver imagen amcool