A1 1 2 16 X fx Accessibility tab summary: The financial information of Marider Industries are presented in rows 2 to 22. A statement for requirement 1 C A 3 4 5 6 Sales 7 Materials Cost 8 Labor Cost 9 Units Produced and Sold 10 Total Direct Labor Hours 11 12 Total Estimated Overhead Cost 13 Total Estimated Direct Labor Hours 14 15 Activity 17 Cutting 18 Sewing 19 Inspecting 20 Packing 21 Machine Setups 22 Material Moves 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. $ $ $ B $ Spring 378,000 $ 52,900 $ 41,400 $ 4,200 10,880 117,000 14,500 Activity Driver Activity-Based Costing Information Total Estimated Cost Cutting Hours Sewing Hours Number of Inpections Units Produced Number of Setups Number of Material Moves $ $ Winter $ $ 288,000 26,100 24,300 2,400 3,240 D 21,060 32,760 4,680 11,700 17,550 29,250 Spring Usage E 1,580 9,300 200 2,300 60 20 Winter Usage 740 2,500 50 900 150 90 F Total 2,320 11,800 250 3,200 210 110 G + H

help fill in the yellow blanks!!!!

help fill in the yellow blanks with the proper formula.

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. A) f. Accessibility tab summary: The financlal information of Marider industries are presented in rows 2 to 22 . A statement for requirement 1 to 6 is pres 49 Packing 50 Machine Setups 51 Material Moves B c D 11,700 17,550 52 29,250 E G 53 54 Cutting overhead cost 55. Sewing overhead cost 56 Inspecting overhead cost 5). Packing owerhead 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. Indicato whether the traditional costing system overcosted or undercosted the jackets. 70 \begin{tabular}{|c|c|c|} \hline & Spring & Winter \\ \hline Volume & High & \begin{tabular}{l} Low \\ Undercosted \end{tabular} \\ \hline Cost & Overcosted & \\ \hline \end{tabular} A) f. Accessibility tab summary: The financlal information of Marider industries are presented in rows 2 to 22 . A statement for requirement 1 to 6 is pres 49 Packing 50 Machine Setups 51 Material Moves B c D 11,700 17,550 52 29,250 E G 53 54 Cutting overhead cost 55. Sewing overhead cost 56 Inspecting overhead cost 5). Packing owerhead 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. Indicato whether the traditional costing system overcosted or undercosted the jackets. 70 \begin{tabular}{|c|c|c|} \hline & Spring & Winter \\ \hline Volume & High & \begin{tabular}{l} Low \\ Undercosted \end{tabular} \\ \hline Cost & Overcosted & \\ \hline \end{tabular} For an answer to 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: =B3+C3 A) f. Accessibility tab summary: The financlal information of Marider industries are presented in rows 2 to 22 . A statement for requirement 1 to 6 is pres 49 Packing 50 Machine Setups 51 Material Moves B c D 11,700 17,550 52 29,250 E G 53 54 Cutting overhead cost 55. Sewing overhead cost 56 Inspecting overhead cost 5). Packing owerhead 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. Indicato whether the traditional costing system overcosted or undercosted the jackets. 70 \begin{tabular}{|c|c|c|} \hline & Spring & Winter \\ \hline Volume & High & \begin{tabular}{l} Low \\ Undercosted \end{tabular} \\ \hline Cost & Overcosted & \\ \hline \end{tabular} 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. For an answer to 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: =B3+C3 For an answer to 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: =B3+C3 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