(9. Use the scenario data to fill in the raw data section)

Problem Traditional Costing Versus Activity-Based Costing Goal: Create an Excel spreadsheet to compare traditional costing versus activity-based costing. Use the results to answer questions about your findings Scenario: Suppose Sunstar Corporation is one of Dell's circuit board suppiers Sunstar currently uses traditional costing for making business decisions. At the urging of Del, however, the company has decided to move to activity-based costing for circuit board production related to products PCB124 and PCB136. As one of the company's accountants 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: Total Indirect Costs for the Quarter Assembly $630,000 Soldering $270,000 Inspection $160,000 PCB124 PCB136 Direct costs (materials, labor) 162,400 $178,240 Machine hours (assembly) 480 1,080