Acme Motorcycle Co has determined that the engine size (in cc) is the key cost driver for estimating the cost of a new model of a motorcycle. They plan to introduce two new motorcycles, Cadet XL with engine size 750 cc, and Mega1800 with engine size 1800 cc. Acme's historic cost model is as shown below: Engine cc Cost 50 $8001 250 $3,600 500 $4,900 1000 $6,250 1250 $6,700 1500 $7,000 Use Excel to develop a CER model to determine the most reliable model for estimating the cost of a new motorcycle (using Trendline and R). Then, predict the cost of Cadet XL and Mega1800 motorcycles. a) Develop then cut and paste the Excel model and chart below. b) Display the equation of the model and R on the chart. c) State the type of the model/trendline and its parameters. d) State the cost of Cadet XL and Mega1800. e) Provide a rationalization for the optimal cost estimation model. Acme Motorcycle Co has determined that the engine size (in cc) is the key cost driver for estimating the cost of a new model of a motorcycle. They plan to introduce two new motorcycles, Cadet XL with engine size 750 cc, and Mega1800 with engine size 1800 cc. Acme's historic cost model is as shown below: Engine cc Cost 50 $8001 250 $3,600 500 $4,900 1000 $6,250 1250 $6,700 1500 $7,000 Use Excel to develop a CER model to determine the most reliable model for estimating the cost of a new motorcycle (using Trendline and R). Then, predict the cost of Cadet XL and Mega1800 motorcycles. a) Develop then cut and paste the Excel model and chart below. b) Display the equation of the model and R on the chart. c) State the type of the model/trendline and its parameters. d) State the cost of Cadet XL and Mega1800. e) Provide a rationalization for the optimal cost estimation model