Really need help with the excel spreadsheet

ESSAY. Write your answer in the space provided or on a separate sheet of paper. 39) Brilliant Accents Company manufactures and sells three styles of kitchen faucets: Brass, Chrome, and White Production takes 25, 25, and 10 machine hours to manufacture 1,000-unit batches of brass, chrome, and white faucets, respectively. The following additional data apply: BRASS CHROME WHITE Projected sales in units Selling price S20 530 Direct materials Direct labor Overhead cost based on direct labor hours 58 $15 S 4 S3 $8 $9 (traditional system) $12 S3 $9 Direct labor hours Machine hours Setup hours Inspection hours 25 0.5 1.0 30 1.0 Total overhead costs and activity levels for the year are estimated as follows: Direct labor hours Machine hours 2,900 hours 2,400 hours 96 setup hours a. Using the traditional system, determine the operating profit per unit for the brass style of faucet. b. Determine the activity-cost-driver rate for setup costs and inspection costs c. Using the ABC system, for the brass style of faucelt 1. compute the estimated overhead costs per unit. 2. compute the estimated operating profit per unit d. Explain the difference between the profits obtained from the traditional system and the ABC system. Which system provides a better estimate of profitability? Why? use Excel online to in the cloud using a link Create a spreadsheet in Microsoft Excel that has the ability to calculate the answers for a, b, and e for different given values. Design the spreadsheet to focus on the operating profit per unit while allowing a e to share an end user to change the given any of the given information Make your report professional. Specifically, make sure that (1)number formats use commas (2)dollar signs are used where appropriate, (3)printing is restricted to 1 I , (4)you take credit for your work (i.e., "prepared by xox"+ date) (S)the report is white printers to print on black and