Question
Excel Corporation manufactures three products at its plant The plant capacity is limited to 100,000 machine hours per year on a single-shift basis Direct material
Excel Corporation manufactures three products at its plant The plant capacity is limited to 100,000 machine hours per year on a single-shift basis Direct material and direct labor costs are variable. The following data are available for planning purposes E (Click the icon to view the data.)
Product
Total unit demand for next year
Sales price per unit
Direct materials cost per unit
Direct labor cost per unit
Variable overhead cost per unit
Machine hours per unit
XL1
250000
12
4.4
3.3
3.3
0.1
XL2
250000
12.5
5
2.5
2.5
0.25
XL3
250000
12
5.2
2.4
2.4
0.25
Requirements
(a) Given the capacity constraint, determine the production levels for the three products that will maximize profits
(b) If the company authorizes overtime in order to produce more units of XL3, the direct labor cost per unit will be higher by 50% because of the overtime premium. Materials cost and variable overhead cost per unit will be the same for overtime production as regular production. Is it worthwhile operating overtime?
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started