Tread Mile produces two types of exercise treadmills: Regular and Deluxe. The exercise craze is such that Tread Mile could use all its available machine hours to produce either model. The two models are processed through the same production departments. Data for both models are as follows:

Per Unit

Deluxe Regular

Sales Price: $1,040 $570

Costs:

Direct Materials: 300 90

Direct Labor: 78 190

Variable Manufacturing Overhead: 276 92

Fixed Manufacturing Overhead * 120 40

Variable Operating Expenses: 115 67

Total Costs: 889 479

Operating Income: $ 151 $ 91

* Allocated on the basis of machine hours

Requirements:

1.) What is the Constraint?

2.) Which model should Tread Mile produce? (HINT: Use the allocation of fixed manufacturing overhead to determine the proportion of machine hours used by each product.)

3.) If Tread Mile should produce both models, compute the mix that will maximize operating income.

I have included a screenshot below of the spreadsheet I need to fill out to complete this question. Please explain how to do this. Thank you!

Requirement 1 Write narrative answer below Requirement 2 Contribution margin per treadmill: Deluxe Regular Proportion of machine hours used: Deluxe Regular Contribution margin per machine hour: Deluxe Regular Write narrative answer below Requirement 3 Write narrative answer below