Question
Problem 7-16 Comparing Traditional and Activity-Based Product Margins [LO7-1, LO7-3, LO7-4, LO7-5] Hi-Tek Manufacturing, Inc., makes...
Problem 7-16 Comparing Traditional and Activity-Based Product Margins [LO7-1, LO7-3, LO7-4, LO7-5] Hi-Tek Manufacturing, Inc., makes two types of industrial component parts-the B300 and the T500. An absorption costing income statement for the most recent period is shown: Hi-Tek Manufacturing Inc. Income Statement Sales 1,749,600 1,233,208 516,392 590,000 (73,608) Cost of goods sold Gross margin Selling and administrative expenses Net operating loss Hi-Tek produced and sold 60,100 units of B300 at a price of $21 per unit and 12,500 units of T500 at a price of $39 per unit. The company's traditional cost system allocates manufacturing overhead to products using a plantwide overhead rate and direct labor dollars as the allocation base. Additional information relating to the company's two product lines is shown below: B300 T500 Total $ 400,000 $ 120,400 163,000 $ $42,400 Direct materials 563,000 162,800 Direct labor Manufacturing overhead 507,408 Cost of goods sold 1,233,208 The company has created an activity-based costing system to evaluate the profitability of its products. Hi-Tek's ABC implementation team concluded that $52,000 and $106,000 of the company's advertising expenses could be directly traced to B300 and T500 respectively. The remainder of the selling and administrative expenses was organization-sustaining in nature. The ABC team also distributed the company's manufacturing overhead to four activities as shown below:
Activity Manufacturing Activity Cost Pool (and Activity Measure) Machining (machine-hours) Setups (setup hours) Product-sustaining (number of products) Other (organization-sustaining costs) Overhead B300 T500 Total 208,488 136,920 101,200 90,600 62,700 153,300 76 250 326 1 1 60,800 NA NA NA 507,408 Total manufacturing overhead cost Required: 1. Compute the product margins for the B300 and T500 under the company's traditional costing system. 2. Compute the product margins for B300 and T500 under the activity-based costing system. 3. Prepare a quantitative comparison of the traditional and activity-based cost assignments Complete this question by entering your answers in the tabs below. Required 3 Required 1 Required 2 Compute the product margins for the B300 and T500 under the company's traditional costing system. (Round your intermediate calculations to 2 decimal places and final answers to the nearest whole dollar amount.) B300 T500 Total Product margin
Required 1 Required 2 Required 3 Compute the product margins for B300 and T500 under the activity-based costing system. (Negative product margins should be indicated by a minus sign. Round your intermediate calculations to 2 decimal places.) B300 T500 Total Product margin
Traditional Cost System % Total cost assigned to products Total cost в300 Т500 Total % of % of Amount Amount Total Amount Total Amount Amount Activity-Based Costing System Direct costs % % Indirect costs: Total cost assigned to products Costs not assigned to products
Answers
Answers 1 Product Margin under Traditional Costing B300 Product Margin 366052 2 Product Margin under Activity Based costing B300 Product Margin 483964 T500 149812 Total 515864 T500 Total -647724 191923. Quantitative Comparision of the Traditional and Activity Based Cost Assignments Quantitative comparsion of the Traditional Cost B300 T500 T otal Traditional Costing System Direct Material DirectLabor Manufacturing Overheads Total Cost Assigned to Products Selling and Administrative Expenses Total Cost Amount 400000 120400 375648 896048 % 71.0% 74.0% 74.0% Amount 163000 42400 132288 337688 % 29.0% 26.0% 26.0% 563000 1628001 507936 1233736 590000 1823736Total 563000 162800 158000 Quantitative Comparison of Acticity Based Cost Assignments B300 T500 Activty Based Costing System Amount % Amount % Direct Cost Direct Material 400000 71.0% 163000 29.0% Direct Labor 120400 74.0% 42400 26.0% Advertisements (Traced) 52000 32.9% 106000 67.1% Indirect Cost Machining 123216 59.1% 85272 40.9% Batch setup 31920 23.3% 105000 76.7% Prodcut Sustainind 50600 50.0% 50600 50.0% Total Cost Assigned to Products 778136 552272 Cost Not asigned to the Products Selling and Administrative Expenses Others 208488 136920 101200 1330408 432000 60800 Total Cost 176240821 Working Notes B300 T500 Total Selling Price 39 Direct Material 400000 163000| 563000 Direct Labor 120400 42400 162800 Production in Units 60100 1 2500 72600 Manufacturing Overheads 507408 Advertisements (Traced) 52000 106000 Selling and Administrative Expenses 590000 Maufacturing OH 507408 Estimated Labor Dollars 162800|| 2 Predetermined Overhead Rate 3.12 507408/162800 MOHD Activity B300 T500 Total Machining 208488 9 060062700 153300 Setups 136920 761 250 320 Prodcut sustaining 101200 Others 60800 507408 sales Direct Material Direct Labor Manufacturing Overheads Total Manufacturing Cost Product Margin Traditional Costing System B300 T500 12621001 487500 400000 163000 120400 42400 375648 132288 8960480 337688 366052 149812 Total 1749600 563000 162800 507936 1233736 515864Determination of Activity Rate Activty Pool Machining Batch setup Prodcut Sustaining Estimated OH 208488 136920 101200 Base Activity Rate 153300 1.36 420.00 2 50600 326 Activity Based Costing System sales Direct Material Direct Labor Advertisements (Traced) Matching ( Activity *Rate) Batch Setup (Activity *Rate) Prodcut Sustaining Total Cost Product Margin B300 1262100 400000 120400 52000 123216 31920 50600 778136 483964 T500 Total 487500 1749600 163000 563000 42400 162800 106000 158000 85272 208488 105000 136920 50600 101200 552272 1330408 -64772 419192 41
Similar Solved Questions
1 answers
Statement of Cash Flows (Direct Method) The Forrester Company’s income statement and comparative balance sheets as...
Statement of Cash Flows (Direct Method) The Forrester Company’s income statement and comparative balance sheets as of December 31 of 2019 and 2018 are shown below: FORRESTER COMPANY Income Statement For the Year Ended December 31, 2019 Sales Revenue $660,000 Cost of Goods Sold $376,0...
1 answers
6:31 @ . Indigo Corporation has one temporary difference at the end of 2020 that will...
6:31 @ . Indigo Corporation has one temporary difference at the end of 2020 that will reverse and cause taxable amounts of $49.800 in 2021. $54.700 in 2022, and $59,300 in 2023. Indigo's pretax financial income for 2020 is $285,000, and the tax rate is 30% for all years There are no deferred tax...
1 answers
Problem 3: 40 points) A square foundation was decided to be constructed to support the load...
Problem 3: 40 points) A square foundation was decided to be constructed to support the load of a column in a residential building construction project located in Claremont, CA. During the site investigation, only sandy soil (c'= 0) was encountered. The ground water was observed at the depth 1.2m...
1 answers
10) On March 31, Adolpha, Inc. reported the following information on its financial statements. Total current...
10) On March 31, Adolpha, Inc. reported the following information on its financial statements. Total current assets Total long-termassets Total current liabilities Total long-term debt 5421374 $212864 $675.218 $2005,286 What is the available net working capital for Adolpha, Inc.? (A) $253,844 B) -$1...
1 answers
Measures of Central Tendency
13. Hourly Compensation for Production Workers - The hourly compensation costs (in US dollars) for production workers in selected countries are represented below. Find the mean and modal class.CLASS FREQUENCY2.48-7.48 77.49-12.49 312.50-17.50 117.51-22.51 722.52-27.52 527.53-32.53 5 Compare the mean...
1 answers
If the mass that is oscillating on a spring is increased by a factor of 4...
If the mass that is oscillating on a spring is increased by a factor of 4 the frequency of the oscillation will:...
1 answers
Sarah Clemmons and Ben Adamson formed an LLC and named it Best Manufacturing, Inc. in 2012...
Sarah Clemmons and Ben Adamson formed an LLC and named it Best Manufacturing, Inc. in 2012 giving each founder a percentage of the company based upon their respective financial contribution. The LLC had articles of incorporation that authorized 50,000,000 shares of stock. Sarah contributed $750,000 ...
1 answers
1. How many moles of solute are in 2 L of 3 M NaOH solution? 6...
1. How many moles of solute are in 2 L of 3 M NaOH solution? 6 moles 1.5 moles 2 moles 3 moles Identify the soluble substance in water. 2. CaCO3(s) CCI4(I) 12(s) HCI(g) 3. Which of the following is an ionic compound? C6H12O6 H20 CaC12 CO2 Which one of the following solutions has the lowest pH? 4. ru...
1 answers
1. Consider the following: net operating profit after taxes = $450,000, total assets = $1,000,000, interest...
1. Consider the following: net operating profit after taxes = $450,000, total assets = $1,000,000, interest expenses = $100,000, book value (net worth) = $600,000, current liabilities = $150,000, short-term debt (notes payable) = $0, tax rate = 25%. [16 points] a. Calculate the interest coverage rat...
1 answers
2) Draw the equivalent circuit of Figure 3 based on the equivalent circuit in Fig. 2 showing all ...
2) Draw the equivalent circuit of Figure 3 based on the equivalent circuit in Fig. 2 showing all the appropriate impedances in per unit. Note: Since the transformer model has two windings on the secondary side, you can combine the impedances of the two windings to make a single equivalent winding on...
1 answers
500 lb 500 lb PVC Epvc = 450 ksi Escon E E = 160 ksi Bakelite...
500 lb 500 lb PVC Epvc = 450 ksi Escon E E = 160 ksi Bakelite EB = 800 ksi 3ft—th 4ft - 3ft- Prob. 6-139 (b) Determine the maximum shear stress on the interface between PVC and Escon....
1 answers
Required information The Foundational 15 [LO14-1, L014-2] The following information applies to th...
Required information The Foundational 15 [LO14-1, L014-2] The following information applies to the questions displayed below. Ravenna Company is a merchandiser that uses the indirect method to prepare the operating activities section of its statement of cash flows. Its balance sheet for this year is...
1 answers
As on the previous page, let Xi,...,Xn be i.i.d. with pdf where >0 2 points possible...
As on the previous page, let Xi,...,Xn be i.i.d. with pdf where >0 2 points possible (graded, results hidden) Assume we do not actually get to observe X, . . . , Xn. to estimate based on this new data. Instead let Yİ , . . . , Y, be our observations where Yi-l (X·S 0.5) . our goals Wh...
1 answers
[15pts) A lidless cardboard box with a volume 10m e material for the bottom of the box costs 5 oat and the materia dolla2. Find the dimensions of the box that es of the imize the cost of the bo...
[15pts) A lidless cardboard box with a volume 10m e material for the bottom of the box costs 5 oat and the materia dolla2. Find the dimensions of the box that es of the imize the cost of the box. mize the cost or do Draw the picture and identify the variables. entify the objective function. Write it...
1 answers
Exercise 14-11 Sunland Inc. has issued three types of debt on January 1, 2020, the start...
Exercise 14-11 Sunland Inc. has issued three types of debt on January 1, 2020, the start of the company’s fiscal year. (a) $11 million, 11-year, 15% unsecured bonds, interest payable quarterly. Bonds were priced to yield 12%. (b) $28 million par of 11-year, zero-coupon bonds at a price to yiel...