Task: Variable Costing & Segmented Income Statement:
TYZ Company currently manufactures two products, Y and Z. The company has the capacity to make one additional product, with two (P1 and P2) currently under consideration. The forecasted annual sales and related costs for each "new" product are attached.
(I'd like to see formulas as well so that I can duplicate the process myself please)
- With the provided information, produce a variable costing income statement that inlcudes products Y, Z, and P1.
- With the provided information, produce a variable costing income statement that includes products Y, Z and P2.
- Reduce P2's variable production costs by 55% of sales. How does that income statement change?
- If I could add both products 1 and 2, by way of either product Y or Z being dropped from production. Would it make sense to? What does that look like numerically?
- Which product should be added into production?
- Which product would make me more money?
| Forecasted Annual Sales For Tentative New Products |
|
|
Product 1 |
Product 2 |
|
|
|
|
| Sales |
|
$320,000 |
$320,000 |
| Variable Costs |
|
|
|
| Production% |
|
50% |
70% |
| Selling and administrative % |
10% |
5% |
| Direct fixed expenses |
|
$25,000 |
$12,500 |
| Last years operations for TYZ company |
|
|
|
Product Y |
Product Z |
Total |
|
|
|
|
|
| Sales |
|
$275,000 |
$400,000 |
$675,000 |
| Less variable expenses |
|
|
|
|
| Production |
|
100,000 |
200,000 |
300,000 |
| Selling and administrative |
20,000 |
60,000 |
80,000 |
| Contribution margin |
|
$155,000 |
$140,000 |
$295,000 |
| Less direct fixed expenses |
10,000 |
55,000 |
65,000 |
| Segment margin |
|
$145,000 |
$85,000 |
$230,000 |
| Less common fixed expenses |
|
|
75,000 |
|
|
|
|
|
| Net income |
|
|
|
$155,000 |