Please show input/functions

Home Insert Draw Page Layout Formulas Data Review View Share Comments 12 A A = hy Paste 110 Calibri Bocy! BTU fa = s Wrap Taxt Merge a cantar Insert Delete - A Currency $ % E Conditione Former Cell Sort & Filter Find & Select Ideas Sensitivity Formatting as tabla Styes Formal X x INSTRUCTION: PARTI - Calculate the Rates for a Traditional/Volume Based system (that uses DL hours) and for an ABC system (which uses various cost drivers). Sand Surfers Corp. manufactures tires for dune buggies and has two different products; rugged tires and smooth tires. Volume (Traditional System) is based on direct labor hours. The ABC system uses various cost drivers. The following information is available: When cells are colored orange you MUST use the ROUND function with your formulas, Gray boxes are to be left blank. Buwd Asstivitate Cost Driver Esumated Smooth Estimates Driver Use Activity Rate for Volume Based System Driver Use MAAsures B Direct Labor Hours Materials handling Machine setups Quality inspections - Tai7. Estimated Overhead Costs $127,500 SG0.000 $54,296 557.000 5298,796 Direct Labor Hours Number of Requisitions Number of Setups Number of Inspections 500 200 32.000 GOD 300 per hour per requisition per setup per Inspection 1. Use the ROUND Function ta round the POHR and each of the Activity Rates; PARA round the rates to 2 decimal places. For cells 19 and 110. after using the ROUND function to round the rates to 2 decimal places, you will need to use the coc case decimal button to displey only 2 decimal places. 10 per hour INSTRUCTION: PART II - Assign Manufacturing Overhead cost to the Rugged Tires under a Traditional/Volume-Based system and under an ABC system. Assume this is the initial set up of the costing system, so please use the "estimated driver use from Part I as though it were "actual" driver used for the period. Rugged 74,800 450 Direet Labor Hours Number of Requisitions Number of Setups Number of Inspections 240 Round each of the applied/allocated MOH amounts using the ROUND function to round your answers to O decimal places 160 Applied MOH-Volume Based Applied MOH - ABC