In: Accounting
Inner Secret T Shirt Company produces and sells one product. The following information pertains to each of the company’s first three years of operations:
Variable costs per unit:
Manufacturing:
Direct materials $ 26
Direct labor $ 18
Variable manufacturing overhead $ 5
Variable selling and administrative $ 1
Fixed costs per year:
Fixed manufacturing overhead $ 540,000
Fixed selling and administrative expenses $ 100,000
During its first year of operations, O’Brien produced 94,000 units and sold 75,000 units. During its second year of operations, it produced 83,000 units and sold 97,000 units. In its third year, O’Brien produced 82,000 units and sold 77,000 units. The selling price of the company’s product is $80 per unit.
Required:
1. Assume the company uses variable costing and a FIFO inventory flow assumption (FIFO means first-in first-out. In other words, it assumes that the oldest units in inventory are sold first):
a. Compute the unit product cost for Year 1, Year 2, and Year 3.
b. Prepare an income statement for Year 1, Year 2, and Year 3.
Part A | |||
Year 1 | Year 2 | Year 3 | |
DM | $26.00 | $26.00 | $26.00 |
DL | $18.00 | $18.00 | $18.00 |
VMO | $5.00 | $5.00 | $5.00 |
FMO | $5.74 | $6.51 | $6.59 |
Unit Product Cost | $54.74 | $55.51 | $55.59 |
Calculation of ending inventory | |||
Year 1 | Year 2 | Year 3 | |
Opening | 0 | 19000 | 5000 |
Produced | 94000 | 83000 | 82000 |
Sold | -75000 | -97000 | -77000 |
Closing | 19000 | 5000 |
10000 |
Part B |
|||
Year 1 | Year 2 | Year 3 | |
Sales | $60,00,000.00 | $77,60,000.00 | $61,60,000.00 |
Less: | |||
Variable Cost | $46,06,000.00 | $46,06,000.00 | $46,06,000.00 |
Fixed Mfg Cost | $5,40,000.00 | $5,40,000.00 | $5,40,000.00 |
Beg. Inventory | $- | $10,40,148.94 | $2,77,530.12 |
Ending Inventory | $(10,40,148.94) | $(2,77,530.12) | $(5,55,853.66) |
COGS | $41,05,851.06 | $59,08,618.82 | $48,67,676.46 |
LESS: Variable S. OH | $(75,000.00) | $(97,000.00) | $(77,000.00) |
LESS: Fixed S.OH | $(1,00,000.00) | $(1,00,000.00) | $(1,00,000.00) |
Net Income | $39,30,851.06 | $57,11,618.82 | $46,90,676.46 |