1.

ABC Medical Group wants to develop the quarterly forecast of sales revenue of 2020 with data of 2018 and 2019 together with the seasonality relatives.

Remark: The answers should demonstrate the process of how to obtain the results together with the graphics generated by Excel for constructing the linear regression models and the linear regression equations.

(1) Please deseasonalize the sales revenue of the eight quarters from 2018 to 2019 according to the given information.

(2)Based on the given data, please identify the linear regression equation for the relationship between the sales revenue and profit. According to the findings, please advise the sales revenue if the quarterly target profit is 800 million.

(3) Please plot the data, and visually check to see if a linear trend line would be appropriate for the sales revenue. Then determine the equation of the trend line and predict sales revenue for the last two quarters of 2020.

(4)Please incorporate seasonality to the forecast in Question (3).

2.A factory planned to construct a new production line in which 20 units of can be produced per hour. Though the machine can keep running without stopping, considering the workload of the workforce, the planning department decided to work with two shifts a day, each containing 8 hours. However, after the first day, some problems were encountered. Twenty defective parts were detected during the production. The production line stopped for 3 hours due to machine breakdowns. Please compute the daily efficiency and utilization related to the production line making product A. Remark: The answers should demonstrate the process of how to obtain the results.

3.The client of a electronic appliance factory wants to order 3,000 readyto-use components per day. Processing time per component is measured to be 2.5 min. The normal production line of the factory is arranged at 2 shifts with 8 hours in a day. Machine efficiency, from previous experience, is expected to be 80%. According to the record of past production, the percentage of defective parts is 8%. Please compute the required number of machines. Remark: The answers should demonstrate the process of how to obtain the results.

4.A bakers variable costs per loaf of bread are 40p. The daily fixed costs are 120. If 250 loaves are sold at 1 each, calculate the daily revenue, total cost, and profit.

Q/Y Sales (million) 3,128 2,680 Profit (million) 273 Seasonal Relatives 201801 0.63 2018Q2 235 0.46 2018Q3 1,746 131 0.38 201804 706 1.53 201901 7,798 3,128 2,835 288 0.63 2019Q2 227 0.46 2019Q3 1,973 149 0.38 201904 8,322 799 1.53 Q/Y Sales (million) 3,128 2,680 Profit (million) 273 Seasonal Relatives 201801 0.63 2018Q2 235 0.46 2018Q3 1,746 131 0.38 201804 706 1.53 201901 7,798 3,128 2,835 288 0.63 2019Q2 227 0.46 2019Q3 1,973 149 0.38 201904 8,322 799 1.53