StorSmart Company makes plastic organizing bins. The company has the following inventory balances at the beginning and end of March:
Beginning Inventory | Ending Inventory | |||||
Raw materials | $ | 29,100 | $ | 26,400 | ||
Work in process | 21,200 | 45,500 | ||||
Finished goods | 78,900 | 69,000 | ||||
Additional information for the month of March follows:
Raw materials purchases | $ | 41,800 |
Indirect materials used | 1,700 | |
Direct labor | 63,200 | |
Manufacturing overhead applied | 35,600 | |
Selling, general, and administrative expenses | 23,600 | |
Sales revenue | 236,400 | |
Required:
1. Based on the above information, prepare a cost of goods
manufactured report.
2. Based on the above information, prepare an income statement for the month of March.
Wheeler’s Bike Company manufactures custom racing bicycles. The
company uses a job order cost system to determine the cost of each
bike. Estimated costs and expenses for the coming year
follow:
Bike parts | $ | 340,800 | |
Factory machinery depreciation | 58,500 | ||
Factory supervisor salaries | 139,000 | ||
Factory direct labor | 212,963 | ||
Factory supplies | 39,900 | ||
Factory property tax | 34,750 | ||
Advertising cost | 24,500 | ||
Administrative salaries | 51,500 | ||
Administrative-related depreciation | 22,200 | ||
Total expected costs | $ | 924,113 | |
Required:
1. Calculate the predetermined overhead rate per direct labor hour if the average direct labor rate is $12.31 per hour.
2. Determine the amount of applied overhead if
17,600 actual hours are worked in the upcoming year.
1) Schedule of cost of goods manufactured
Direct material used | ||
Beginning raw material | 29100 | |
Raw material purchase | 41800 | |
Raw material available for use | 70900 | |
Less: Ending raw material | -26400 | |
Raw material used | 44500 | |
Less: Indirect material | -1700 | |
Direct material used | 42800 | |
Direct labor | 63200 | |
Manufacturing overhead applied | 35600 | |
Total manufacturing cost | 141600 | |
Beginning work in process | 21200 | |
Total cost of work in process | 162800 | |
Less: Ending work in process | -45500 | |
Cost of goods manufactured | 117300 |
b) Income statement
Sales revenue | 236400 | |
Cost of goods sold | ||
Beginning finished goods | 78900 | |
Cost of goods manufactured | 117300 | |
Cost of goods available for sale | 196200 | |
Less: Ending finished goods | -69000 | |
Cost of goods sold | 127200 | |
Gross profit | 109200 | |
Selling, general, and administrative expenses | -23600 | |
Net income | 85600 |
StorSmart Company makes plastic organizing bins. The company has the following inventory balances at the beginning...
StorSmart Company makes plastic organizing bins. The company has the following inventory balances at the beginning and end of March: Beginning Inventory Ending Inventory Raw materials $ 28,500 $ 25,600 Work in process 21,600 46,300 Finished goods 79,800 68,600 Additional information for the month of March follows: StorSmart Company makes plastic organizing bins. The company has the following inventory balances at the beginning and end of March: Raw materials purchases $ 40,300 Indirect materials used 1,900 Direct labor 63,200 Manufacturing...
StorSmart Company makes plastic organizing bins. The company has the following inventory balances at the beginning and end of March: Beginning Inventory Ending Inventory $22,000 44,000 58,000 $33,000 25,000 60,000 Raw materials Work in process Finished goods Additional information for the month of March follows: StorSmart Company makes plastic organizing bins. The company has the following inventory balances at the beginning and end of March: $ 84,000 10,000 55,000 85,000 58,000 450,000 Raw materials purchases Indirect materials used Direct labor...
StorSmart Company makes plastic organizing bins. The company has the following inventory balances at the beginning and end of March Beginning Inventory Ending Inventory Raw materials Work in process Finished goods $28,700 21,300 79,200 $25,900 46,900 69,800 Additional information for the month of March follows StorSmart Company makes plastic organizing bins. The company has the following inventory balances at the beginning and end of March Raw materials purchases Indirect materials used Direct labor Manufacturing overhead applied Selling, general, and administrative...
StorSmart Company makes plastic organizing bins. The company has the following inventory balances at the beginning and end of March: Beginning Inventory Ending Inventory Raw materials $ 29,800 $ 25,600 Work in process 21,900 46,000 Finished goods 78,500 68,800 Additional information for the month of March follows: StorSmart Company makes plastic organizing bins. The company has the following inventory balances at the beginning and end of March: Raw materials purchases $ 41,700 Indirect materials used 1,200 Direct labor 62,900 Manufacturing...
StorSmart Company makes plastic organizing bins. The company has the following inventory balances at the beginning and end of March: Raw materials Work in process Finished goods Beginning Inventory $33,000 25,000 60,000 Ending Inventory $22,000 এ4, 000 58,000 ces Additional information for the month of March follows: StorSmart Company makes plastic organizing bins. The company has the following inventory balances at the beginning and end of March: Raw materials purchases Indirect materials used Direct labor Manufacturing overhead applied Selling, general,...
StorSmart Company makes plastic organizing bins. The company has the following inventory balances at the beginning and end of March: Raw materials Work in process Finished goods Beginning Inventory $29,700 22,900 78,200 Ending Inventory $26,200 46,200 68,800 Additional information for the month of March follows: Raw materials purchases Indirect materials used Direct labor Manufacturing overhead applied Selling, general, and administrative expenses Sales revenue $ 41,700 1,800 64,000 36,400 24,800 236,700 Required: 1. Based on the above information, prepare a cost...
StorSmart Company makes plastic organizing bins. The company has the following inventory balances at the beginning and end of March: Raw materials Work in process Finished goods Beginning Inventory $ 28,300 22,400 78,100 Ending Inventory $26,800 46,200 69,500 Additional information for the month of March follows: Raw materials purchases Indirect materials used Direct labor Manufacturing overhead applied Selling, general, and administrative expenses Sales revenue $ 41,000 1,700 63,900 36,600 24,100 237,900 Required: 1. Based on the above information, prepare a...
StorSmart Company makes plastic organizing bins. The company has the following inventory balances at the beginning and end of March: Raw materials Work in process Finished goods Beginning Inventory $ 28, 200 21,300 78,800 Ending Inventory $26,200 46,200 68,800 Additional information for the month of March follows: Raw materials purchases Indirect materials used Direct labor Manufacturing overhead applied Selling, general, and administrative expenses Sales revenue $ 41,000 2,000 63,300 35,400 24,300 236,700 Required: 1. Based on the above information, prepare...
StorSmart Company makes plastic organizing bins. The company has the following inventory balances at the beginning and end of March: Raw materials Work in process Pinished goods Beginning Inventory $28.000 21,600 78,500 Ending Inventory $26.500 46,000 68,100 Additional information for the month of March follows: Raw materials purchases Indirect materials used Direct labor Manufacturing overhead applied Selling general, and administrative expenses Sales revenue $ 40,300 1.500 63.600 35,800 23,500 236,000 Required: 1. Based on the above information, prepare a cost...
StorSmart Company makes plastic organizing bins. The company has the following inventory balances at the beginning and end of March: Raw materials Work in process Finished goods Beginning Inventory $28, 4ee 22.000 79,400 Ending Inventory $26, 1ee 46, 10e 70, eee Additional information for the month of March follows: Raw materials purchases Indirect materials used Direct labor Manufacturing overhead applied Selling, general, and administrative expenses Sales revenue $ 41,900 1.2ee 64.ee 36,900 24,800 237, see Required: 1. Based on the...