Scenario Air United, Inc. manufactures two 50 range instruments and 300 pressure gauges were produced, and overhead costs of $85,160 were estimated. An analysis of estimated overhead costs reveals the following activities. products: missile range instruments and space pressure gauges. During April, Total Estimated Overhead Costs $58,622 26,538 $85,160 Activities Allocation Base 1. Materials handling 2. Machine setups Number of requisitions Number of setups The allocation base for each activity and the total quanity of each allocation base was as follows. Product Lines Instruments 400 200 Gauges 600 300 Total 1,000 500 Cost Drivers Number of requisitions Number of setups Instructions (a) Determine the predetermined overhead allocation rate for each activity. (b) Use the overhead rates for each activity to assign costs to each product line. Remember to scroll to the right so you can read the Notes From CarterlI In this assignment, we are working on the Rounding functions, Unless you are told otherwise,you should ROUND to two decimal places. Note: Cells with Value" in them need a basic Cell Reference formula, while cells with ?" need some sort of calculation or function Note from Carter: On t incorporate the ROUND division or multiplicatic you should enter the fo ROUND" tells Excel to numbers to the results (a) The overhead rates are: Predetermined of OverheadOverhead Allocation Rate Total Estimated Activity Cost Pools Materials Handling Machine Setups Overhead $ 58,622 $26,538 Allocation Base 1,000 500 requisition 58.62 53.08/ setup tells Excel to round the (b) Assign overhead costs to the Instruments line: Instruments Rate from (a) Actual Quanity of Base Cost Driver Cost Requisitions Setups 58.62 53.08 400 200 Total costs assigned # of units produced 50 Manufacturing Overhead Cost per Unit Assign overhead costs to the Gauges line: Gauges Cost Driver Rate from (a) Actual Quanity of Base Rost 58.62 Requisitions Setups 600 300 53.08 3 Total costs assigned 3001 5 56 57 58 of Units produced Manufacturing Overhead Cost per Unit 60