Please do this problem in Excel & post the solution as an excel attchment.

Smartphones are produced on an automated assembly line process. The standard cost of smartphones is $150 perunit (abour $30; materials, S70, and overhead, 550). The sales price is $300 per unit 2. To achieve a 10 percent multifactor productivity inprovement by reducing materials costs only, by what percentage must these cost be reduced? b. To achieve a 10 percent multifactor productivity Improvement by reducing labour costs only, by what percentage must these costs be reduced? To achieve a 10 percent multifactor productivity improvement by reducing overhead costs only, by what percentage must these costs be reduced Question 2 (Module 2): Sales for the past 12 months at the Dalworth Company are given here Months Sales (5 millions) Month Sales (5 millions) January 20 July 53 Pelinary 24 August 62 Moech 27 September 54 April 31 October May 22 November 32 47 December 20 36 Use three month moving average to forecast the sales for the month April through December 1. Use exponential smoothing with a 0.6 to forecast the sales for the months April through Decerober. Assume that the initial forecast for January was $22 million. Start error measurement in April Compare the performance of the two methods by using the mean abroute deviation as the performance criterion, with error measurement beginning in April. Which method would you recommend