d. Use the Susan Lewis florist shop data for Number of Deliveries and Delivery Cost in Exercise 3-56 in your textbook on page 137 to run a Regression on Excel WITH THE FOLLOWING NUMBER ADJUSTMENTS: Change the January Number of Deliveries to 180 and the December Delivery Cost of $1,780. You do NOT have to submit your Excel spreadsheet. Just use your Excel regression results and type up a Word document with your answers to these questions: #1 How much is the fixed cost of labor per month? #2 How much is the variable rate per delivery? #3 What would the cost formula be to use to predict future delivery cost? #4 Using that cost formula, calculate the budgeted cost for next month, assuming that 305 deliveries are expected. (The easiest way to do an Excel Regression is demonstrated in an Instructor YouTube Video within "Modules" OR you can use the longer approach using Regression within Excel's Analysis Toolpak that is described in the Appendix to Chapter 3 in your textbook.) Exercise 3-56 (Appendix 3A) Method of Least Squares Using Computer Spreadsheet Program Susan Lewis, owner of a florist shop, is interested in predicting the cost of delivering floral ar- rangements . She collected monthly data on the number of deliveries and the total monthly de- livery cost (depreciation on the van, wages of the driver, and fuel) for the past year. Month Number of Deliveries Delivery Cost January 100 $1.200 February 550 1,800 March 85 1,100 April 115 1,050 May 160 1,190 June 590 1,980 July 500 1,800 August 520 1,700 September 100 1,100 October 200 1,275 November 260 1,400 December 450 2,200 Required: 1. Using a computer spreadsheet program such as Excel, run a regression on these data. Print out your results. 2. Using your results from Requirement 1, write the cost formula for delivery cost. (Note: Round the fixed cost to the nearest dollar and the variable rate to the nearest cent.) 3. CONCEPTUAL CONNECTION What is R based on your results? Do you think that the number of direct labor hours is a good predictor of delivery cost? 4. Using the cost formula in Requirement 2, what would predicted delivery cost be for a month with 300 deliveries