To prepare the Variable Costing Income Statement, let's first gather the data provided and then perform the necessary calculations step by step.
Step 1: Calculate Variable Cost of Goods Manufactured
Given:
- Total Cost of Goods Manufactured (Absorption Costing): $105,138
- Fixed Manufacturing Costs: $25,233.12
Variable Cost of Goods Manufactured can be calculated as follows: \[ \text{Variable Cost of Goods Manufactured} = \text{Total Cost of Goods Manufactured} - \text{Fixed Manufacturing Costs} \] \[ \text{Variable Cost of Goods Manufactured} = 105,138 - 25,233.12 = 79,904.88 \]
Step 2: Calculate Variable Cost of Goods Sold
To calculate the Total Variable Cost of Goods Sold, we need the ending inventory calculated using variable costing.
Calculate Variable Costing Ending Inventory: We have:
- Total Variable Cost of Goods Manufactured = $79,904.88
- Total Units Manufactured = 3,894 units
- Ending Inventory (Absorption Costing) = 594 units
Variable Costing Ending Inventory can be determined as follows: \[ \text{Variable Costing Ending Inventory} = \left( \frac{\text{Variable Cost of Goods Manufactured}}{\text{Total Units Manufactured}} \right) \times \text{Ending Inventory Units} \] \[ \text{Variable Costing Ending Inventory} = \left( \frac{79,904.88}{3,894} \right) \times 594 \approx \left( 20.49 \right) \times 594 \approx 12,194.10 \text{ (rounded to whole dollars: 12,194)} \]
Now, we can calculate Total Variable Cost of Goods Sold: \[ \text{Total Variable Cost of Goods Sold} = \text{Variable Cost of Goods Manufactured} - \text{Variable Costing Ending Inventory} \] \[ \text{Total Variable Cost of Goods Sold} = 79,904.88 - 12,194 \approx 67,710.88 \text{ (rounded to whole dollars: 67,711)} \]
Step 3: Variable Selling and Administrative Expenses
Given:
- Total Selling and Administrative Expenses (Absorption Costing): $21,480
- Fixed Selling and Administrative Expenses: $10,520
Variable Selling and Administrative Expenses can be calculated by subtracting fixed selling and administrative expenses from the total selling and admin expenses. Assuming all selling and administrative expenses apart from the fixed portion are variable: \[ \text{Variable Selling and Administrative Expenses} = \text{Total Selling and Administrative Expenses} - \text{Fixed Selling and Administrative Expenses} \] \[ \text{Variable Selling and Administrative Expenses} = 21,480 - 10,520 = 10,960 \]
Step 4: Prepare the Variable Costing Income Statement
Now we can prepare the Variable Costing Income Statement using the calculated values.
Joplin Company
Variable Costing Income Statement
For the Month Ended April 30
| Line Item Description | Amount | |------------------------------------------------|-----------| | Sales | $125,400 | | Variable cost of goods sold: | | | Variable Cost of Goods Manufactured | 79,905 | | Less: Inventory, April 30 (Variable) | (12,194) | | Total Variable Cost of Goods Sold | (67,711) | | Manufacturing Margin | 57,689 | | Variable Selling and Administrative Expenses | (10,960) | | Contribution Margin | 46,729 | | Fixed Costs: | | | Fixed Manufacturing Costs | (25,233) | | Fixed Selling and Administrative Expenses | (10,520) | | Total Fixed Costs | (35,753) | | Operating Income | $10,976 |
Final totals can be rounded as needed.