BUS105 Midterm 1 Part 1 Latest 2022

Question 1

The actual monthly demand for a bike in a bike store from month 1 to month 3 is 192,102,165, respectively. The manager decided to use a weighted moving average forecasting model to forecast the demand for month 4 with weights 2.25,3.25,3.5, where the last weight is for the most recent actual demand. What is his forecast? (Do not round intermediate calculations. Round your final answer to the nearest whole number. Only enter a number. Do not enter any units.)(©aorsdemir. Copyrighted material)

 

Question 2 The actual monthly demand for a bike in a bike store from month 1 to month 3 is 212,124,147, respectively. The manager decided to use a weighted moving average forecasting model to forecast the demand for month 4 with weights 1.25,3.25,3.5, where the last weight is for the most recent actual demand. What is his forecast? (Do not round intermediate calculations. Round your final answer to the nearest whole number. Only enter a number. Do not enter any units.)(©aorsdemir. Copyrighted material)

 

Question 3

Week    Actual   Forecast

1              20.2        40.1

2              39.3        55.0

3              42.8        48.0

4              63.2        76.8

5              70.6        86.3

6              80.6        83.7

7              90.6        93.7

8              87.6        101.2

9              106.7     122.4

You are given the demand and forecast history for a toothbrush sold in a department store. According to this, what is the 2-period simple moving average forecast for Week 10? (Just enter a number without any units. Do not round intermediate calculations. Round your final answers to two decimal places)(©aorsdemir, Copyrighted content. Cannot be posted)

 

Question 4

Week    Actual   Forecast

1              24.1        44.0

2              44.5        49.7

3              49.3        52.4

4              52.8        64.3

5              73.2        82.6

6              74.1        77.2

7              90.6        97.9

8              103.2     108.4

9              95.0        108.6

You are given the demand and forecast history for a toothpaste sold at a department store. According to this, what is the 3-period weighted moving average forecast for Week 10 with weights 2,3,4? (Use the first weight for the oldest (the least relevant) demand value. Do not round intermediate calculations. Round your final answers to two decimal places.

 

Question 5

Week    Actual   Forecast

1              17.6        37.5

2              40.6        41.6

3              45.4        52.7

4              56.7        76.6

5              56.3        76.2

6              76.7        86.1

7              90.6        93.7

You are given the demand and forecast history for a laptop sold at an electronic store. According to this, what is the (single) exponential smoothing forecast for Week 8 if the smoothing constant is 0.15? (Do not round intermediate calculations. Round your final answers to two decimal places

 

Question 6

Week    Actual

1              12.5

2              28.1

3              23.6

4              39.5

5              40.1

6              42.5

7              45.5

8              64.7

A small printer sold at OfficeMax has the demand figures given in the table. According to this, what is the linear regression forecast for Week 12. (You need to use Excel to solve this problem. Do not round intermediate calculations. Round your final answers to two decimal places.