A production plant in Bromptom Ltd ("Bromptom") manufactures a particular component part for bicycles. The company's intern managed to come up following data for the past six months shown below. Month No. of Units Manufactured Total Manufacturing Cost Jan 2022 343 $6,580 Feb 2022 430 $6,864 Mar 2022 423 $7,043 Apr 2022 482 $7,335 May 2022 494 $7,171 Jun 2022 424 $5,055 a) Use Microsoft Excel to prepare a regression analysis and answer the following questions: a) Use Microsoft Excel to prepare a regression analysis and answer the following questions: AutoSave CO - - Book1 (version 1) - AutoRecovered . Search (Alt +Q) Muhammad razmy MR File Home Insert Page Layout Formulas a Review View Help Sha 08 X Y fr D E F G H I K L M N 0 P Q R S SUMMARY OUTPUT Regression Statistics Multiple R 0.363509 5 R Square 0.132139 6 Adjusted R Square -0.08483 7 Standard Error 55.91744 8 Observations 9 10 ANOVA 11 sS MS ignificance F 12 Regression 1 1904.293 1904.293 0.609031 0.478754 13 Residual 4 12507.04 3126.76 14 Total 5 14411.33 15 16 Coefficientsandard Ern t Stat P-value Lower 95%Upper 95Mower 95.0upper 95.0% 17 Intercept 276.6679 201.1941 1.375129 0.241085 -281.937 835.2723 -281.937 835.2723 18 Total Manufacturing Cost 0.023372 0.029948 0.780404 0.478754 -0.05978 0.106522 -0.05978 0.106522 19 20 21 22 23 24 i) State the regression equation in the form of y=mx+c.i} State the regression equation in the form of y=mx+c. ii} State clearly what y and x In the equation represents iii) State clearly the value of R2 Show your workings clearly and provide the Regression Analysis Summary Output Table together with your answers. b) Using the answers in part (a), determine the value of the (rounded to 3 significant gures): i) Total Fixed Cost ii) Unit Variable Cost iii) predicted Total Manufacturing Cost if the production capacity is 500 units for July 2022. Show your workings clearly [4 marks] c) The Production Manager of Bromptom said "I think the predicted Total Manufacturing Cost you have calculated is not valid. This is because Suggest three (31 possible reasons the management accountant may have in commenting that the predicted Total Manufacturing Cost is not valid. [3 marks] d) Based on the information provided and your understanding on Pricing Methods. Suggest 2 ways which Brompton can determine the selling price of their bicycles. Provide examples for each pricing method. [4 marks]