please provide steps for the Excel question and also answer just the questions i have not answered please.

Sheffield Consulting provides weekly payroll processing for a number of small businesses. Gia Sheffield, the company's owner, has been using an activity-based costing system for several years. She used the following information in preparing this year's budget Total Cost Expected Driver Volume 5 88.750 Activity Cost Pool Setting up new employees Processing weekly pabiroll Weekly reporting 500 Cost Driver Number of new employees Number of paychecks printed Number of clients $ 950.000 2.500.000 $ 371.000 200 Annual tax reporting $ 280,000 Number of W-25 printed 80.000 Your answer is correct. Calculate the cost rates for each activity cost pool. (Round answers to 2 decimal places, eg. 15.25.) Cost Pool Activity Rate Setting up new employees $ 177.5 ew employee Processing weekly payroll GA 0.38/check Weekly reporting $ 1855/client GA Annual tax reporting 35 W-2 Gia is preparing a proposal for a prospective client, Jason's Juice Bar. The client has 20 employees. What is the estimated cost of providing weekly payroll services to this client for the first year? (Round answers to 2 decimal places, es 15.25) Cost Pool Expected Annual Cost Setting up new employees $ Processing weekly payroll Weekly reporting Annual tax reporting Total D G H Student Work Area Required: Provide input into cells shaded in yellow in this template Use mathematica formulas with cell references to the Problemas indicated Formula: Divide: Cell Referencing 2 3E7.7 Using Excel to Calculate Overhead Rates 4 PROBLEM 5 Eric Parker has been studying his department's profitability reports for the past 6 six months He has just completed a managerial accounting course and is 7 beginning to question the company's approach to allocating overhead to products based on machine hours. The current department overhead budget is based on machine hours. In an initial analysis of overhead costs, Enchas identified the 10 following overhead budget amounts and activity cost pools 11 12 Estimated machine hours 45.340 13 14 Cost Pool Expected Expected Cos Expected Activities 15 Product assembly 5 680.000 40.000 machine hours 16 Machine setup and calibration 320 000 5.000 Setups 17 Product inspection 67.500 1.500 batches 18 Raw materials storage 66 000 300.000 pounds 19 $ 1133 500 a Calculate the company's traditional verhead rate based on Traditional overhead rate per Calculate the company's overhead rates using the proposed activity based costing pools Product assembly Machine setup and calibration Product inspection Raw maternal storage per per per per al Traditional Overhead rate 25 Per Machine Hours b] Cost Pool Activity Rate Product Assembly 17 Per Machine Hours Machine setup and calibration 64 Setups Product inspection 45 Batches Raw Material Storage 0.22 Pounds Cost Pool Activity Rate Setting up New Employees =88750/500 Per New Employhte Processing Weekly Payroll =950000/2500000 No. of Paychekc Printed Weekly Reporting =371000/200 No. of Clients Annual Tax Reporting =280000/80000 No. of W-2s Printed a] a Traditional Overhead rate =1133500/45340 Per Machine Hours =+E8 b] Cost Pool Activity Rate Product Assembly =680000/40000 Machine setup and calibration =320000/5000 Product inspection =67500/1500 Raw Material Storage =66000/300000 Setups Batches Pounds Oriole makes two products, Simple and Complex. As their names suggest, Simple is the more basic product, and Complex comes with all the bells and whistles. The company has always allocated overhead costs to products based on machine hours. Last year, the company implemented an activity-based costing system, and managers determined the following activity pools and rates based on total overhead of $ 2,400,000: Assembly Fabrication Setups Rate $0.80 per direct labor hour $15 per machine hour $ 20 per batch $ 178.000 direct to Complex Bonding Only the Complex product requires bonding, so all the costs of bonding should be allocated to complex. The following data relate to both products Simple Complex Units produced 100,000 40,000 Direct labor hours 230,000 160,000 Machine hours 80,000 40.000 Batches 1,500 4,000 Your answer is correct. Using the traditional method of allocating overhead costs, allocate overhead cost to the products. show that the overhead assigned to each product sums to the total company overhead. determine the overhead cost per unit for each product. . . (Round overhead rate and overhead per unit answers to 2 decimal places, e.g. 15.25.) Simple Complex Total Machine hours 80000 40000 Overhead rate 20 20 Total overhead to product $ 1600000 800000 $ 2400000 Simple Complex Total overhead to product $ 1600000 800000 Number of units produced 100000 40000 20 16 Overhead per unit (b) Using the activity-based costing rates, allocate overhead cost to the products. show that the overhead assigned to each product sums to the total company overhead. determine the overhead cost per unit for each product. (Round per unit answers to 2 decimal places, eg. 15.25.) 2 Simple Complex Total Assembly $ $ 1 Fabrication Setups I Bonding Total overhead $ GA $ Simple Complex Total overhead to product S $ Setups Bonding Total overhead $ $ Simple Complex Total overhead to product $ Number of units produced Overhead per unit $ S Bramble Industries manufactures several products including a basic case for a popular smartphone. The company is considering adopting an activity-based costing approach for setting its budget. The company's production activities, budgeted activity costs, and cost drivers for the coming year are as follows. Activity Machine setup Cost Driver Quantity Activity Overheads $ 148,200 129.200 Cost Driver #of setups # of quality tests 1.900 Inspection 380 Materials receiving 232,400 # of purchase orders 2.800 The budgeted data for smartphone case production are as follows. Machine setup $ 148,200 # of setups 1,900 Inspection 129,200 # of quality tests 380 Materials receiving 232,400 #of purchase orders 2,800 The budgeted data for smartphone case production are as follows. Direct materials $ 2.30 per unit N $ 0.57 per unit Direct labor Number of setups 190 Number of quality tests 390 Number of purchase orders 70 Production 278.600 units (a) Your answer is correct. Calculate the activity rate for each cost pool. $ Machine setup 78.00 / setup w $ $ 340.00/test Inspection $ 83.00 PO Materials receiving (b) Calculate the activity-based unit cost of the smartphone case. (Round answer to 2 decimal places, eg. 15.25.) $ Activity-based unit cost