could you please do it on Excel so I could make reference of the formulae used

questions are stated in the requirements, which will require the use of the information contained in the graphics uploaded. Many thanks!

Olestion Two Avant Equipment Australa 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 The company has been analyszing its overhead accounts to determine faced and variable components for planning purposes. Below are data for the company's janitorial costs over the last two years. Year 2018 1.090 1.220 2019 1,100 Month January February March Apri May June JU August September October November December January February March April May June July August September October November December January February March April May June Number Janitorial Janitorial of units costs work days reduced $ 3,840 21 1,150 $ 3,648 20 $ 4,128 21 $ 3,456 19 950 $ 4320 21 1.250 $ 4,032 22 1,190 $ 2.784 17 770 $ 2.668 16 710 $ 3.840 21 1,080 $ 3.359 20 990 $ 2.584 16 710 $ 2.965 17 680 $ 3.764 20 $ 3.641 20 1,025 $ 3.899 21 1.220 $ 4.228 23 1,310 $ 4,696 23 1,390 S 4 116 21 1,080 $ 3.112 17 850 $ 3.287 19 790 $ 3.966 19 990 $ 3.265 18 840 $ 2.297 17 770 $ 2.666 16 750 17 1,010 16 950 20 1,210 14 1,350 21 1,280 22 1,120 2020 The number of janitorial work days varies from month to morth 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 other janitorial work days or number of units produced REQUIRED. A. Develop a regression that Avant Equipment should use ley= a + bc) and explain why it is the appropriate regression to use, using the appropriate statistical tools B Using the regression you developed in (A), predict the janitorial cost for the 6 months of 2020 (round your answer to whole numbers). 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 vears. 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 Number work of units days produced 21 1,150 20 1,090 21 1,220 19 950 21 1,250 22 1,190 17 770 16 710 21 1,080 20 990 16 710 17 680 20 1,100 20 1,025 21 1,220 23 1,310 23 1,390 21 1,060 17 850 19 790 19 990 18 840 17 770 16 750 17 1,010 16 950 20 1,210 14 1,350 21 1,280 22 1,120 2020 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. REQUIRED: A. 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. B. Using the regression you developed in (A), predict the janitorial cost for the 6 months Olestion Two Avant Equipment Australa 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 The company has been analyszing its overhead accounts to determine faced and variable components for planning purposes. Below are data for the company's janitorial costs over the last two years. Year 2018 1.090 1.220 2019 1,100 Month January February March Apri May June JU August September October November December January February March April May June July August September October November December January February March April May June Number Janitorial Janitorial of units costs work days reduced $ 3,840 21 1,150 $ 3,648 20 $ 4,128 21 $ 3,456 19 950 $ 4320 21 1.250 $ 4,032 22 1,190 $ 2.784 17 770 $ 2.668 16 710 $ 3.840 21 1,080 $ 3.359 20 990 $ 2.584 16 710 $ 2.965 17 680 $ 3.764 20 $ 3.641 20 1,025 $ 3.899 21 1.220 $ 4.228 23 1,310 $ 4,696 23 1,390 S 4 116 21 1,080 $ 3.112 17 850 $ 3.287 19 790 $ 3.966 19 990 $ 3.265 18 840 $ 2.297 17 770 $ 2.666 16 750 17 1,010 16 950 20 1,210 14 1,350 21 1,280 22 1,120 2020 The number of janitorial work days varies from month to morth 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 other janitorial work days or number of units produced REQUIRED. A. Develop a regression that Avant Equipment should use ley= a + bc) and explain why it is the appropriate regression to use, using the appropriate statistical tools B Using the regression you developed in (A), predict the janitorial cost for the 6 months of 2020 (round your answer to whole numbers). 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 vears. 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 Number work of units days produced 21 1,150 20 1,090 21 1,220 19 950 21 1,250 22 1,190 17 770 16 710 21 1,080 20 990 16 710 17 680 20 1,100 20 1,025 21 1,220 23 1,310 23 1,390 21 1,060 17 850 19 790 19 990 18 840 17 770 16 750 17 1,010 16 950 20 1,210 14 1,350 21 1,280 22 1,120 2020 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. REQUIRED: A. 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. B. Using the regression you developed in (A), predict the janitorial cost for the 6 months