Create the Spreadsheets to compare traditional costing versus activity-based costing. Use the results to answer questions...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Create the Spreadsheets to compare traditional costing versus activity-based costing. Use the results to answer questions about the findings. Suppose Sunstar Corporation is one of Dell's circuit board suppliers. Sunstar currently uses traditional costing for making business decisions, where the direct costs are only a cost driver to allocate all the indirect production costs. At the urging of Dell, however, the company had decided to move to activity-based costing for circuit board production related to products PCB124 and PCB136. As one of the company's manager, you have been asked to prepare a spreadsheet comparing the two costing methods for the next company board meeting. Your supervisor has given you the following quarterly data: Table 1. Sales & Costs in quarter Total ($) РСB124 РСВ136 Sales 1,500,000 700,000 800,000 Direct Costs (materials, labor) 340,640 162,400 178,240 All Indirect Production Cost 1,060,000 All Unallocated Value Chain Cost 100,000 Requirement 1. Construct Income Statement and calculate gross profit and gross profit margin for each product based on Traditional Cost Allocation System. Sunstar Corp. Income Statement by Traditional Allocation Sys Total РСВ124 PCB136 Requirement 2. Construct Income Statement and calculate gross profit and gross profit margin for each product based on Activity-Based Costing Allocation System. ($) Table 2. Indirect Production Cost by activities Assembly activity Soldering activity Inspection activity 630,000 270,000 160,000 Total 1,060,000 Table 3. Indirect Production Cost Drivers by act Machine hours for assembly activity (Hours) Number of units produced for soldering activity (#) Total PCB124 РСВ136 1,560 480 1,080 10,000 6,000 4,000 Testing hours for inspection activity (Hours) 14,000 6,000 8,000 Sunstar Corp. Income Statemen by ABC Allocation System Total РСВ124 РСВ136 Requirement 3. (1) Explain why the results differ significantly between the traditional system and ABC system. (2) Plan production and marketing strategy based on the results. Create the Spreadsheets to compare traditional costing versus activity-based costing. Use the results to answer questions about the findings. Suppose Sunstar Corporation is one of Dell's circuit board suppliers. Sunstar currently uses traditional costing for making business decisions, where the direct costs are only a cost driver to allocate all the indirect production costs. At the urging of Dell, however, the company had decided to move to activity-based costing for circuit board production related to products PCB124 and PCB136. As one of the company's manager, you have been asked to prepare a spreadsheet comparing the two costing methods for the next company board meeting. Your supervisor has given you the following quarterly data: Table 1. Sales & Costs in quarter Total ($) РСB124 РСВ136 Sales 1,500,000 700,000 800,000 Direct Costs (materials, labor) 340,640 162,400 178,240 All Indirect Production Cost 1,060,000 All Unallocated Value Chain Cost 100,000 Requirement 1. Construct Income Statement and calculate gross profit and gross profit margin for each product based on Traditional Cost Allocation System. Sunstar Corp. Income Statement by Traditional Allocation Sys Total РСВ124 PCB136 Requirement 2. Construct Income Statement and calculate gross profit and gross profit margin for each product based on Activity-Based Costing Allocation System. ($) Table 2. Indirect Production Cost by activities Assembly activity Soldering activity Inspection activity 630,000 270,000 160,000 Total 1,060,000 Table 3. Indirect Production Cost Drivers by act Machine hours for assembly activity (Hours) Number of units produced for soldering activity (#) Total PCB124 РСВ136 1,560 480 1,080 10,000 6,000 4,000 Testing hours for inspection activity (Hours) 14,000 6,000 8,000 Sunstar Corp. Income Statemen by ABC Allocation System Total РСВ124 РСВ136 Requirement 3. (1) Explain why the results differ significantly between the traditional system and ABC system. (2) Plan production and marketing strategy based on the results.
Expert Answer:
Answer rating: 100% (QA)
Requirement 1 Traditional Costing Income Statement B124 PCB136 To... View the full answer
Related Book For
Managerial Economics Theory Applications and Cases
ISBN: 978-0393912777
8th edition
Authors: Bruce Allen, Keith Weigelt, Neil A. Doherty, Edwin Mansfield
Posted Date:
Students also viewed these accounting questions
-
Q.1 Set. (B) ARVIND FASHIONS LTD Profit and Loss Account (Amount in Rs. Crores) Particulars Sales Expenses Operating Profit Other Income The following are the financial statements for Arvind Fashion...
-
Based on your chosen activity based costing article, how useful was the cost information to the internal users in the organization? Discuss with examples from your costing article?
-
1. Calculate JW's CCE, Cash Ratio, DCH, and NLB, and interpret the 2-year trend in these mea- sures. How would you describe JW's liquidity position? 2. Suppose that the JW's treasurer has targeted a...
-
Displacement vector A(vector) points due east and has a magnitude of 2.00 km. Displacement vector B(vector) points due north and has a magnitude of 3.75 km. Displacement vector C(vector) points due...
-
The following example is from the book Introduction to Regression Modeling ( Abraham and Ledolter, 2006). The researchers were examining data on death penalty sentencing in Georgia. For each of 362...
-
Why can we be confident that the market for avocados is competitive and that a decrease in supply rather than the greed of avocado growers is the reason for the August 2018 rise in price?
-
Find two rational numbers between \(\frac{3}{10}\) and \(\frac{19}{45}\).
-
Par, Inc., produces a standard golf bag and a deluxe golf bag on a weekly basis. Each golf bag requires time for cutting and dyeing and time for sewing and finishing, as shown in the following table:...
-
It is important to recognize that audit sampling may be constructed on a nonstatistical basis. If the auditor uses statistical sampling, probability theory will be used to determine sample size and...
-
Effective financial statement analysis requires an understanding of a firms economic characteristics. The relations between various financial statement items provide evidence of many of these...
-
Cite examples of polymers
-
How do obsolescence concerns affect the decision on how long batch output can be retained on a storage medium?
-
If online output is obtained via the Internet, how can asymmetric cryptography be used to gain assurance about the authenticity of the source of the output?
-
In electronic messaging systems, why do organizations need policies to govern forwarding, "carbon" copying, and "blind" copying of messages?
-
Give two controls that might be used to ensure online output is received on a timely basis.
-
What are the nature and purposes of netiquette? Give four rules of netiquette.
-
Thank you for telling me that I forgot something! Background End of Chapter Case Study: Thermo Fisher Acquires Life Technologies Case Study Objectives: To Illustrate How Acquirers Utilize Financial...
-
Using the theoretical sampling strategy, how many samples of size 4 (n = 4) can be drawn from a population of size: (a) N = 5? (b) N = 8? (c) N = 16? (d) N = 50?
-
The Lone Star Transportation Company hauls coal and manufactured goods. The demand curve for its services by the coal producers is PC = 495 - 5QC where PC is the price (in dollars) per ton- mile of...
-
The Morrison Company produces tennis rackets, the marginal cost of a racket being $20. Because there are many substitutes for the firm's rackets, the price elasticity of demand for its rackets equals...
-
The 2012 sales and profits of seven clothes companies were as follows: a. Calculate the sample regression line, where t is the dependent variable and sales is the in de pen dent variable. b. Estimate...
-
Assume that the production manager at Alumafloat reminds you that four years ago sales skyrocketed for a while. Demand was so great that production increased to the limit of the companys capacity....
-
Tina Alberts is thinking about trading her car for a new one. Her present car is only three years old, completely paid for, but out of warranty. The cars original cost was $22,000. Lately, the car...
-
The production manager at Ace Manufacturing is contemplating whether he should upgrade some old production equipment. He is considering the following factors: Required: For each item listed, indicate...
Study smarter with the SolutionInn App