Product mix and overtime decisions Excel Corporation manufactures three products at its plant. The plant capacity is limited to 120,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:

Required(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 operatingovertime?

Transcribed Image Text:

TOTAL UNIT DEMAND FOR SALES PRICH DIRECT MACHINE VARIABLE OVERHEAD HOURS PER UNIT DIRECT LABOR COST PER UNIT MATERIALS COST PER UNIT PRODUCT COST PER UNIT PER UNIT NEXT YEAR XL1 XL2 200,000 200,000 200,000 S10.00 14.00 12.00 $4.00 4.50 5.00 $2.00 $2.00 0.20 0.35 0.25 3.00 2.50 XL3