Please answer using excel so that I can learn how to do it.

QUESTION TWO Avant Equipment Australia is a family business manufacturing replacement rotary sweeper brooms for the large sweeper trucks that clear leaves and rubbish from the city streets. The business is, to some degree, seasonal, with the largest demand during and just preceding the autumn and winter months. Since there are so many different kinds of sweeper brooms used by its customers, Avant Equipment makes all of its brooms to order. The company has been analyszing its overhead accounts to determine fixed and variable components for planning purposes. Below are data for the company's janitorial costs over the last two years. Year 2018 Janitorial costs $ 3,840 $ 3,648 $ 4,128 $ 3,456 $ 4,320 $ 4,032 $ 2,784 $ 2,688 $ 3,840 $ 3,359 $ 2,584 $ 2,965 $ 3,764 $ 3,641 $ 3,899 $ 4,226 $ 4,695 $ 4,116 $ 3,112 $ 3,287 $ 3,956 $ 3,265 $ 2,897 $ 2,666 Month January February March April May June July August September October November December January February March April May June July August September October November December January February March April May June 2019 Janitorial work days 21 20 21 19 21 22 17 16 21 20 16 17 20 20 21 23 23 21 17 19 19 18 17 16 17 16 20 14 21 22 Number of units produced 1,150 1,090 1,220 950 1,250 1,190 770 710 1,080 990 710 680 1,100 1,025 1,220 1,310 1,390 1,060 850 790 990 840 770 750 1,010 950 1,210 1,350 1,280 1,120 2020 QUESTION TWO (continued) The number of janitorial work days varies from month to month due to the number of weekdays, holidays, days of vacation and sick leave taken in the month. The number of units produced in a month varies depending on demand and the number of workdays in a month. Avant Equipment is in the process of budgeting monthly janitorial costs for 2020. The assumption is that in some way janitorial costs is related to either janitorial work days or number of units produced. A. REQUIRED: Develop a regression that Avant Equipment should use (ie y = a + bx) and explain why it is the appropriate regression to use, using the appropriate statistical tools. Using the regression you developed in (A), predict the janitorial cost for the 6 months of 2020 (round your answer to whole numbers). B