Whitestone Company produces two subassemblies, JR-14 and RM-13, used in manufact
ID: 340494 • Letter: W
Question
Whitestone Company produces two subassemblies, JR-14 and RM-13, used in manufacturing trucks. The company is currently using an absorption costing system that applies overhead based on direct-labor hours. The budget for the current year ending December 31, 20x1, is as follows:
*Applied on the basis of direct-labor hours:
Mark Ward, Whitestone’s president, has been reading about a product-costing method called activity-based costing. Ward is convinced that activity-based costing will cast a new light on future profits. As a result, Brian Walters, Whitestone’s director of cost management, has accumulated cost pool information for this year shown on the following chart. This information is based on a product mix of 5,000 units of JR-14 and 5,000 units of RM-13.
In addition, the following information is projected for the next calendar year, 20x2.
On January 1, 20x2, Whitestone is planning to increase the prices of JR-14 to $355 and RM-13 to $455. Material costs are not expected to increase in 20x2, but direct labor will increase by 8 percent, and all manufacturing overhead costs will increase by 6 percent. Due to the nature of the manufacturing process, the company does not have any beginning or ending work-in-process inventories.
Whitestone uses a just-in-time inventory system and has materials delivered to the production facility directly from the vendors. The raw-material inventory at both the beginning and the end of the month is immaterial and can be ignored for the purposes of a budgeted income statement. The company uses the first-in, first-out (FIFO) inventory method.
Required:
2. Using activity-based costing, calculate the total cost for the following activity cost pools: machining, assembly, material handling, and inspection. (Round to the nearest dollar.) Then, calculate the pool rate per unit of the appropriate cost driver for each of the four activities.
3. Prepare a table showing for each product line the estimated 20x2 cost for each of the following cost elements: direct material, direct labor, machining, assembly, material handling, and inspection.
4. Prepare a budgeted statement showing the gross margin for Whitestone Company for 20x2, using activity-based costing.
WHITESTONE COMPANY Budgeted Statement of Gross Margin for 20x1 JR-14 RM-13 Total Sales in units 5,000 5,000 10,000 Sales revenue $ 1,700,000 $ 2,200,000 $ 3,900,000 Cost of goods manufactured and sold: Beginning finished-goods inventory $ 240,000 $ 300,000 $ 540,000 Add: Direct material 1,000,000 1,750,000 2,750,000 Direct labor 185,185 92,593 277,778 Applied manufacturing overhead* 544,025 272,013 816,038 Cost of goods available for sale $ 1,969,210 $ 2,414,606 $ 4,383,816 Less: Ending finished-goods inventory 240,000 300,000 540,000 Cost of goods sold $ 1,729,210 $ 2,114,606 $ 3,843,816 Gross margin $ (29,210 ) $ 85,394 $ 56,184Explanation / Answer
2 Required to prepare total cost for the Activity Pools Activity Total Cost (A) Cost Driver Total Hours (JR-14 and RM-13) [B] Activity Rate Machining 424,528 Machine Hours 45000 9.43 Assembly 216,981 Assembly Hours 11500 18.87 Material Handling 56,604 Number of Parts 15 3,773.60 Inspection 117,925 Inspection Hours 12500 9.43 Assumption: I have calculated the rates by combining the Cost Drivers for JR-14 and RM-13 as end results would be the same even if I break down the costs to JR-14 and RM-13 because the product mix is equal 3 Statement of Estimated Costs (20x2) Particulars Increase Amount (20x1) Cost P.u. Amount (20x2) Cost P.u./Cost Per Hour Direct Material No Change 2,750,000 275 2,750,000 275 Direct Labour 8% 277,778 300,000 Machining 6% 424,528 450,000 Assembly 6% 216,981 230,000 Material Handling 6% 56,604 60,000 Inspetion 6% 117,925 125,001 4 Budgeted Statement of Gross Margin JR-14 RM-13 Sales (Units) 5100 4900 SP P.U 355 455 Total Sales 1,810,500 2,229,500 Direct Material 1,402,500 1,347,500 275 x 5100 275 x 4900 Direct Labour 202,649 97351 300000 x 10200/(10200+4900) Machining 154027 295973 450000 x 15300/ (15300+29400) Assembly 122294 107706 230000 x 6120/ (6120+5390) Material Handling 20537 39463 60000 x 5.1/ (5.1+9.8) Inspetion 51205 73796 125001 x 5100/ (5100+7350) Gross Margin (142,712) 267,711 Note: I have recomputed the Number of Hours according to Number of Units. For Example, For JR-14, In 20x1 for 5000 units 10,000 Labour Hours were worked but in 20x2 for 5100 units hours worked is 10,200. see details above. Then just put balance on RM-13. Let me know if you need further clarification
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.