1. The following data represent the quarterly sales by HCDIST, inc. a heavy construction equipment distributor, of HCE01 which is their top selling product. The manufacturer, HCMAN, always introduces its new model in December of each year and these models are available for sale by HCDIST on January 1 of the following year. HCMAN requires HCDIST to place its order for the entire year in the beginning of December of the previous year. For inventory and working capital planning purposes HCDIST needs quarterly forecasts.

YEAR SALES (units) 2018 1 st quarter 12 2nd quarter 3rd quarter 4th quarter 11 2019 1 st quarter 17 2nd quarter 12 3rd quarter 10 4th quarter 15 2020 1 st quarter 25 2nd quarter 23 3rd quarter 22 4th quarter 24 2021 1 st quarter 26 2nd quarter 22 3rd quarter 191 4th quarter 25 2022 1 st quarter 29 2nd quarter 25 3rd quarter 22 4th quarter 30Do the data exhibit any patterns? Please explain. Use an appropriate REGRESSIDN procedure to produce forecasts for the first, second, third and fourth quarters of 2023. HCDIST buys HCEU] from the manufacturer at a unit price of $200300 and pays another $5, for transportation. Each unit of HCEDI sells for $2,. HCDIST uses the sum of quarterly forecasts for 2022 (rounded up to the nearest integer] as the estimate of the mean of the normal distribution describing the annual demand for HCEU]. Standard deviation of the distribution is estimated as 10% of the mean. Any HCED] not sold by the year end [that is, before the new model is introduced] is sold at a 3% discount. How many units of HCEDI should HCDIST order to maximize its expected profits? If the transportation cost increases to MEMO, how will this change your answer to part [c] above? What is the optimal order size associated with [1.92 service level? What is the implied goodwill cost by the 0.92 service level given that the transportation cost is $5