please provide cell referencing as to how to solve the problem via excel if possible

Aubert Claes Problem ABC ABP. Drew Page Layout Home Insert Formules Date Review View Tell me Share Comments Can Body 12 AA 18. Test Accounting AA BEED AA Cando fue Chill For merteforme ter BE Are Dete G9 . M o retur What has seerde de terror w with the toneri bien Orade ty Hamm Darwe Allerede OLD M-TV Miss 1900 Alert- Chimni Bih wwws Cunile Called Etike . Cute Cle tor WC Grande tudies WOW Can we te ihiwa wwwrote the inten terrey Tried the Mater My Cute Overde Art edhe we M-1 Mi Alert Olemnice Cig Cologne Cute Cig Chedi itema re By does the traditie protection de CO Ready ON G9 1 2 Kragan Clothing Company manufactures its own designed and labeled athletic wear and sells its products through catalog sales and retail outlets. While Kragan has for years used activity based costing in its manufacturing activities, it has always used traditional costing in assigning its selling costs to its product lines Selling costs have traditionally been assigned to Kragan's product lines at a rate of 70% of direct materials costs. Its direct materials costs for the month of March for Kragan's "high-intensity line of athletic wear are $400,000. The company has decided to extend activity based costing to its selling costs (for internal decision-making only). Data relating to the "high-intensity" line of products for the month of March are as follows. 8 9 s 10 Number of Cost Drivers Used Per Activity 900,000 Dollar sales 250 Minutes 2,000 Column inches 60,000 Catalogs mailed 9,000 Catalog orders 900,000 Dollar sales 14 $ Activity Cost Pools Cost Drivers Overhead Rate Sales commissions Dollar sales $0.05 per dollar sales Advertising-TV Minutes $300 per minute 11 Advertising-Internet Column inches $10 per column inch 12 Catalogs Catalogs mailed $2.50 per catalog 13 Cost of catalog sales Catalog orders $1 per catalog order Credit and collection Dollar sales $0.03 per dollar sales 15 16 1) Compute the selling costs to be assigned to the "high-intensity" line of athletic 17 wear for the month of March (1) using the traditional product costing system 18 (direct materials cost is the cost driver), and (2) using activity-based costing. 19 20 Traditional Method 21 Overhead Rate = 70% Direct Material Cost = 22 23 Acivity Based Costing Method 24 Number of Cost Drivers 25 Activity Cost Pools Cost Drivers Used Per Activity 26 Sales commissions Dollar sales 27 Advertising-TV Minutes 28 Advertising-Internet Column inches 29 Catalogs Catalogs mailed 30 Cost of catalog sales Catalog orders 31 Credit and collection Dollar sales 32 33 34 2) By what amount does the traditional product costing system undercost or overcost 35 the "high-intensity product line relative to costing under ABC? 36 37 38 Overhead Rate Overhead Costs Assigned