Need the formulas for the yellow areas based on question. TY

Marider Industries makes two types of windbreaker jackets: one for spring and one for winter. Marider uses a traditional costing system and is considering switching to an Activity-Based Costing system. Marider applies overhead on the basis of direct labor hours. Below is information about its production facility. Spring Winter Sales $ 378,000 $ 288,000 Materials Cost $ 52,900 $ 26, 100 Labor Cost $ 41,400 $ 24,300 Units Produced and Sold 4, 206 2,400 Total Direct Labor Hours 10, 880 3,240 Total Estimated Overhead Cost $ 117,000 Total Estimated Direct Labor Hours 14,500 Activity-Based Costing Information Total Estimated Spring Winter Activity Activity Driver Cost Usage Usage Total Cutting Cutting Hours $ 21, 060 1, 580 740 2,320 Sewing Sewing Hours $ 32,760 9,300 2,500 11, 800 Inspecting Number of Inpections $ 4,680 200 50 250 Packing Units Produced $ 11, 700 2,300 900 3,200 Machine Setups Number of Setups $ 17,550 60 150 210 Material Moves Number of Material Moves $ 29, 250 20 90 110 Required: 1. Calculate the Predetermined Overhead Rate. 2. Use the Predetermined Overhead Rate to calculate total overhead applied to each jacket type. 3. Calculate the Gross Profit per jacket type. 4. Calculate the Activity Rates for the Activity-Based Costing system. 5. Use the Activity Rates to calculate the total overhead applied to each jacket type. 6. Calculate the Gross Profit per jacket type. 7. Indicate whether the traditional costing system overcosted or undercosted the jackets. Navigation: 1. Use the Open Excel in New Tab button to launch this question. 2. When finished in Excel, use the Save and Return to Assignment button in the lower right to return to Connect. X E Open Excel in new tabIMPORTANT: Answer grading pclliqlr For an answerto be graded as correct, you must use an Excel formula: 1. Begin each formula with an = sign. 2. Reference cells, instead of entering values. Example: =BB+C3 A B C D E F G H Marider Industries makes two types of windbreaker jackets: one for spring and one for winter. Marider uses a traditional costing system and is considering switching to an Activity-Based Costing system. Marider applies overhead on the basis of direct labor 3 hours. Below is information about its production facility. 4 5 Spring Winter 6 Sales 378,000 $ 288,000 7 Materials Cost in in tor 52,900 -Ur 26,100 8 Labor Cost 41,400 $ 24,300 Units Produced and Sold 4,200 2,400 10 Total Direct Labor Hours 10,880 3,240 11 12 Total Estimated Overhead Cost 117,000 13 Total Estimated Direct Labor Hours 14,500 14 15 Activity-Based Costing Information Total Estimated Cost 16 Activity Activity Driver Spring Usage Winter Usage Total 17 Cutting Cutting Hours 21,060 1,580 740 2,320 18 Sewing Sewing Hours 32,760 9,300 2,500 11,800 19 Inspecting Number of Inpections 4,680 200 50 250 20 Packing Units Produced 11,700 2,300 900 3,200 21 Machine Setups Number of Setups 17,550 60 150 210 22 Material Moves Number of Material Moves 29,250 20 90 110 23 24 Required: 25 1. Calculate the Predetermined Overhead Rate. 26 2. Use the Predetermined Overhead Rate to calculate total overhead applied to each jacket tune.D A B C 24 Required: 25 1. Calculate the Predetermined Overhead Rate. 26 2. Use the Predetermined Overhead Rate to calculate total overhead applied to each jacket type. 27 3. Calculate the Gross Profit per jacket type. 28 4. Calculate the Activity Rates for the Activity-Based Costing system. 29 5. Use the Activity Rates to calculate the total overhead applied to each jacket type. 30 6. Calculate the Gross Profit per jacket type. 31 32 Traditional System 33 Predetemined Overhead Rate 34 Spring Winter 35 36 Total Overhead Applied 37 Direct Materials cost per unit 38 Direct Labor cost per unit 39 Overhead cost per unit 40 Total cost per unit 42 Gross Profit per unit 43 44 Activity-Based Costing System Activity Driver Activity Cost Amount Rate 45 46 Cutting 47 Sewing 48 Inspecting 49 Packing Machine CatuneFile Home Insert Draw Formulas Data Review View Help Calibri (Body) 11 B I Av ... Ev Me A1 X v fx Accessibility tab summary: The financial information of Marider Industries are presented A B C D E 50 Machine Setups 51 Material Moves 52 53 Spring Winter 54 Cutting overhead cost 55 Sewing overhead cost 56 Inspecting overhead cost 57 Packing overhead cost 58 Machine Setups overhead cost 59 Material Moves overhead cost 60 Total Overhead Cost 61 62 Direct Materials cost per unit 63 Direct Labor cost per unit 64 Overhead cost per unit 65 Total cost per unit 66 67 Gross Profit per unit 68 69 7. Indicate whether the traditional costing system overcosted or undercosted the jackets. 70 71 Spring Winter 72 Volume 73 Cost 74 75 76