In: Accounting
All of the company's manufacturing overhead costs are fixed—it does not incur any variable manufacturing overhead costs. The predetermined overhead rate is based on a cost formula that estimated $2,882,000 of fixed manufacturing overhead for an estimated allocation base of 288,200 direct labor-hours. Wallis does not maintain any beginning or ending work in process inventory.The company’s beginning balance sheet is as follows:
Wallis Company | ||
Balance Sheet | ||
1/1/XX | ||
(dollars in thousands) | ||
Assets | ||
Cash | $ | 720 |
Raw materials inventory | 170 | |
Finished goods inventory | 290 | |
Property, plant, and equipment, net | 8,700 | |
Total assets | $ | 9,880 |
Liabilities and Equity | ||
Retained earnings | $ | 9,880 |
Total liabilities and equity | $ | 9,880 |
The company’s standard cost card for its only product is as follows:
Inputs | (1) Standard Quantity or Hours |
(2) Standard Price or Rate |
Standard Cost (1) × (2) |
||||
Direct materials | 2 pounds | $ | 30.40 | per pound | $ | 60.80 | |
Direct labor | 3.00 hours | $ | 13.00 | per hour | 39.00 | ||
Fixed manufacturing overhead | 3.00 hours | $ | 10.00 | per hour | 30.00 | ||
Total standard cost per unit | $ | 129.80 | |||||
During the year Wallis completed the following transactions:
Purchased (with cash) 231,000 pounds of raw material at a price of $29.70 per pound.
Added 215,500 pounds of raw material to work in process to produce 95,200 units.
Assigned direct labor costs to work in process. The direct laborers (who were paid in cash) worked 245,400 hours at an average cost of $16.00 per hour to manufacture 95,200 units.
Applied fixed overhead to work in process inventory using the predetermined overhead rate multiplied by the number of direct labor-hours allowed to manufacture 95,200 units. Actual fixed overhead costs for the year were $2,741,000. Of this total, $1,342,000 related to items such as insurance, utilities, and salaried indirect laborers that were all paid in cash and $1,399,000 related to depreciation of equipment.
Transferred 95,200 units from work in process to finished goods.
Sold (for cash) 92,200 units to customers at a price of $170 per unit.
Transferred the standard cost associated with the 92,200 units sold from finished goods to cost of goods sold.
Paid $2,121,000 of selling and administrative expenses. Closed all standard cost variances to cost of goods sold.
1. Compute all direct materials, direct labor, and fixed overhead variances for the year.
2. Record transactions a through i for Wallis Company.
3. Compute the ending balances for Wallis Company’s balance sheet.
4. Prepare Wallis Company’s income statement for the year.
Record transactions a through i for Wallis Company.
Wallis Company Income Statement For the Year Ended 12/31/XX (dollars in thousands)
Sales
Cost of goods sold at standard
Total variance adjustments
Cost of goods sold
Gross margin
Selling and administrative expenses
Net operating income
Material Variance | Labor Variance | ||||||||||
Raw Material Inventory | |||||||||||
Standard Material Price | $ 30.40 | SP | Standard Hour Rate | $13.00 | Debit | Credit | |||||
Standard Quantity | 95200*2 | 190400 | SQ | Standard Hour | 95200*3 | 285600 | Beginning | $ 170,000 | b | $ 6,400,350 | |
Actual Quantity | 231000 | AQ | Actual Hours | 245400 | a | $ 6,860,700 | |||||
Actual Quantity used | 215500 | AQ | |||||||||
Actual Matrial Price | $ 29.70 | AP | Actual Hour Rate | $16.00 | Ending | $ 630,350 | |||||
Material Price Variance | AQ(AP-SP) | Labor Rate Variance | AH(AR-SR) | Finished Goods Inventory | |||||||
231000*(29.70-30.40) | 245400*(16-13) | Debit | Credit | ||||||||
161700 Favorable | 736200 U | Beginning | $ 290,000 | h | $12,767,327 | ||||||
f | $13,182,750 | ||||||||||
Material Quantity Variance | SP(AQ-SQ) | Labor Efficiency Variance | SR(AH-SH) | ||||||||
30.40*(215500-190400) | 13*(245400-285600) | Ending | $ 705,423 | ||||||||
763040 Unfavorable | 522600 F | ||||||||||
Cash | |||||||||||
Debit | Credit | ||||||||||
Actual Cost Incurred | $ 2,741,000 | a | Beginning | $ 720,000 | a | $ 6,860,700 | |||||
Static Budget | $ 2,882,000 | b | g | $15,674,000 | |||||||
Budgeted Input For Actual Output*Budgeted Rate | 95200*3*10 | $ 2,856,000 | c | ||||||||
Ending | $ 9,533,300 | ||||||||||
Spending Variance | a-b | $ 141,000 | F | ||||||||
Production Volume Variance | b-c | $ 26,000 | U | Work in process Inventory | |||||||
Debit | Credit | ||||||||||
Account | Debit | Credit | b | $ 6,400,350 | f | $13,182,750 | |||||
c | $ 3,926,400 | ||||||||||
Raw Material Inventory | $ 6,860,700 | d | $ 2,856,000 | ||||||||
Cash | $ 6,860,700 | ||||||||||
Work in Process Inventory | $ 6,400,350 | Factory Overhead | |||||||||
Raw Material Inventory | $ 6,400,350 | Debit | Credit | ||||||||
e | $ 1,342,000 | d | $ 2,856,000 | ||||||||
Work in Process Inventory | $ 3,926,400 | e | $ 1,399,000 | ||||||||
Wages | $ 3,926,400 | ||||||||||
Ending | $ -115,000 | ||||||||||
Work in Process Inventory | $ 2,856,000 | ||||||||||
Factory Overhead (95200*3*10) | $ 2,856,000 | ||||||||||
Factory Overhead | $ 2,741,000 | ||||||||||
Cash | $ 1,342,000 | ||||||||||
Accumulated Depreciation | $ 1,399,000 | ||||||||||
Finished Goods Inventory | $ 13,182,750 | ||||||||||
Work in Process Inventory | $ 13,182,750 | ||||||||||
Cash | $ 15,674,000 | ||||||||||
Sales Revenue | $ 15,674,000 | ||||||||||
Cost of Goods Sold (13182750/95200*92200) | $ 12,767,327 | ||||||||||
Finished Goods Inventory | $ 12,767,327 | ||||||||||
Selling and Administrative Expense | $ 2,121,000 | ||||||||||
Cash | $ 2,121,000 | ||||||||||
Cost of Goods Sold: | |||||||||||
Beginning, Finished Goods | $ 290,000 | ||||||||||
Cost of Goods Manufactured: | |||||||||||
Direct Material, Beginning | $ 170,000 | ||||||||||
Add: Purchase | $ 6,860,700 | ||||||||||
Less: Direct Material, Ending | $ -630,350 | ||||||||||
Direct Material Cost | $ 6,400,350 | ||||||||||
Direct Labor | $ 3,926,400 | ||||||||||
Overhead-Applied | $ 2,856,000 | ||||||||||
Cost of Goods Manufactured: | $ 13,182,750 | ||||||||||
Cost of Goods Available | $ 13,472,750 | ||||||||||
Less: Finished Goods, Ending | $ 705,423 | ||||||||||
Cost of Goods Sold | $ 12,767,327 |