Q2 plese provide excel formulas

File Home Insert Draw Page Layout Formulas Data Review View He Calibri Light | 11 BYMVA Av ... Thanks for using Office! We've made some updates to the privacy settings to give you more control. Your organization's admin allows yo nal cloud-backed services are provided to you under the Microsoft Services Agreement. Learn more V X V fx A B C b. INDEPENDENT FROM PART a. Assume you've calculated the target cost given below for the light fixture (cell 815). The company has provided the costs to make the product which is higher than the target cost. What could you recommend to them to help reduce their costs? This must be specific to Light Fixtures Plus and reference question data. (2 marks) Target Cost for product (assume this number; do not use your answer from part a) $ 200.00 Current production cost per unit: Direct materials 147.00 Direct labor 79.00 Manufacturing overhead S 66.00 Total production cost per unit. + 292.00 > = & Cover Sheet Q1 Q2 Q3 Q4 Q5 Formulas + ulation Mode: Automatic Workbook StatisticsExcel gsingh283 - Saved v Search (Alt + Q) File Home Insert Draw Page Layout Formulas Data Review View Calibri Light v / 11 v BEvv Av ... ab i Thanks for using Office! We've made some updates to the privacy settings to give you more control. Your organization's admin allows tional cloud-backed services are provided to you under the Microsoft Services Agreement. Learn more A23 V X V f* A B C Question: Target Costing (5 marks) Part A. Light Fixtures Plus, a manufacturer of light fixtures would like to introduce a new semi-flush ceiling light. The fixture could not be priced at more than the price shown below. The company has indicated their desired return on investment on all new products. The budgeted amount of sales in units is given below along with the required investment Maximum selling price S 237.00 Sales in units 2,686.00 Required return on investment 39% Total investment required 313,000 Required: Calculate the following: Total return on investment in dollars Return on investment per unit Target cost per unit b. INDEPENDENT FROM PART a. Assume you've calculated the target cost given below for the light fixture (cell 815). The company has provided the costs to make the product which is higher than the target cost. What could you recommend to them to help reduce their costs? This must be specific to Light Fixtures Plus and > = & Cover Sheet Q1 Q2 Q3 04 05 Formulas + Iculation Mode: Automatic Workbook Statistics