The company manufactures three products. Profit computations for these three products for the most recent year are as follows:
Product X Product Y Product Z Total
Sales $ 300,000 $ 700,000 $ 800,000 $ 1,800,000
Direct materials (70,000) (150,000) (200,000) (420,000)
Direct labor (50,000) (200,000) (250,000) (500,000)
Manufacturing overhead(100,000)(400,000) (500,000) (1,000,000)
Profit $ 80,000 $ (50,000) $(150,000) $ (120,000)
The company traditionally allocates manufacturing overhead based on the level of direct labor cost?$2 of manufacturing overhead are allocated for each $1 of direct labor cost. However, of the company's $1,000,000 in manufacturing overhead costs, $700,000 is directly related to the number of product batches produced during the year. The number of batches of the three products for the year was as follows: Product X, 20 batches; Product Y, 30 batches; Product Z, 50 batches. The remaining $300,000 in overhead is for facility support (property taxes, security costs, general administration, and so forth). As you can see, the total company loss is $120,000. In an effort to reduce or eliminate this loss, the company has decided to drop Product Z. What would total company profit (or loss) have been in the most recent year if Product Z had been dropped at the beginning of the year?
Since, of the company's $1,000,000 in manufacturing overhead costs, $700,000 is directly related to the number of product batches produced during the year. We need to calculate the manufacturing overhead costs that directly relate for each product as follows: -
Total number of batches produced = Product X (20) + Product Y (30) + ...
This solution is comprised of a detailed explanation and calculation to answer the new net profit (loss) after dropping a product line.