4. A 24-hour coffee/donut shop makes donuts every eight hours. The manager must forecast donut demand so that the bakers have the fresh ingredients they need. Listed below is the actual number of glazed donuts (in dozens) sold in each of the preceding 13 eight-hour shifts. Date Shift Demand(dozens) June 3 Day 59 Evening 47 Night 40 June 4 Day 64 Evening 43 Night 39 June 5 Day 62 Evening 46 Night 42 June 6 Day 60 Evening 45 Night 40 June 7 Day 58 a. Produce a line chart b. Develop the optimization model that finds the estimated regression equation that minimize the sum of squared error. c. Solve for the estimated regression equation. d. Forecast the demand for glazed donuts for the Day, Evening, and Night shifts of June 8.