accounting calculations in excel, can you make sure to tell me what cell to use for the equation for each box needed. thank you!

Time Period Used to Compute Indirect Cost Pate1 Capitola Manufacturing produces surfboards. The company uses a normal costing system and allocates manufacturing overhead on the basis of direct manufacturing labor-hours. Most of the company/s production and sales occur in the first and second quarters of the year. The company is in danger of losing one of its larger customers, Pacific Wholesale, due to large fluctuations in price. The owner of Copitola has requested an analysis of the mazufacturing cost per unit in the second and thiid quarters. You have been provided the following budested information for the coming year: Use the blue shaded areas on the ENTERANSWEHS tab for inputs. Always use cell references and formulas where appropriate to receive full credit. Cell references and formulas should be based on the original idata. If you copv/paste from the instructions tah or if you type the aumbers in, 8 vou will be marked wronic. Requirements. 1 Calculate the total manufacturing cost per unit for the second and thirif quarter assaming the carnpany allocates manufacturing overhead costs hased on the budpeted manufacturing owerhead rate determined tof Use the blue shaded areas on the ENTERANSWERS tab for inputs. Always use cell references and formulas where appropriate to receive full credit. Cell references and formulas should be based on the original data. If you copy/paste from the Insterctions tab or if you type the numbers in, you will be marked wrong. Requirements 1 Calculate the total manufacturing cost per unit for the second and third quarter assuming the company allocates manufacturing overhead costs based on the budgeted manufacturing overhead rate determined for each quarter. a. Check your spelling carefully and do not abbreviate. 2 Calculate the total manufacturing cost per unit for the second and third quarter assuming the company allocates manufacturing overhead costs based on an annual budgeted manufacturing overhead rate. a. Check your spelling carefully and do not abbreviate. Saving \& Submitting Solution 1 Save file to desktop. a. Create folder on desktop, and label COMPLETED EXCEL PROJECTS 2 Upload and submit your file to be graded. a. Navigate back to the activity window - screen where you downloaded the initial spreadsheet b. Click Choose button under step 3; locate the file you just saved and click Open c. Click Upload button under step 3 d. Click Submit button under step4 Viewing Results 1 Click on Results tab in MyAccountingLab 2 Click on the Assignment you were working on 1. Calculate the total manufacturing cost per unit for the second and third quarter assuming the company allocates manufacturing overhead costs based on the budgeted manufacturing overhead rate determined for each quarter. (Always use cell references and formulas where appropriate to receive full credit. Cell references and formulas should be based on the original data. If you copy/paste from the Instructions tab or if you type the numbers in, you will be marked wrong.) 2. Calculate the total manufacturing cost per unit for the second and third quarter assuming the company allocates manufacturing overhead costs based on an annual budgeted manufacturing overhead rate. (Always use cell references and formulas where appropriate to receive full credit. Cell references and formulas should be based on the original data. If you copy/paste from the Instructions tab or if you type the numbers in, you will be marked wrong.) 2. Calculate the total manufacturing cost per unit for the second and third quarter assuming the company allocates manufacturing overhead costs based on an annual budgeted manufacturing overhead rate. (Always use cell references and formulas where appropriate to receive full credit. Cell references and formulas should be based on the original data. If you copy/paste from the Instructions tab or if you type the numbers in, you will be marked wrong.)