All information is complete.

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 Sales Direct Costs (materials, labor) All Indirect Production Cost All Unallocated Value Chain Cost Total ($) 1,500,000 340,640 1,060,000 100,000 PCB124 700,000 162,400 PCB136 800,000 178,240 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 PCB124 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 Total ($) 630,000 270,000 160,000 1,060,000 Table 3. Indirect Production Cost Drivers by aci Machine hours for assembly activity (Hours) Number of units produced for soldering activity (#) Testing hours for inspection activity (Hours) Total 1,560 10,000 14,000 PCB124 480 6,000 6,000 PCB136 1,080 4,000 8,000 Sunstar Corp. Income Statemen by ABC Allocation System Total PCB124 PCB136 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