Consider the following demand data for the Grand Bakery: Week Demand 1 230 2 170 3...
Consider the following demand data for the Grand Bakery: Week Demand 1 230 2 170 3 240 4 220 5 250
Use this data: Using weights W1 = 0.5, W2 = 0.3, and W3 = 0.2 with largest weight assigned to the recent period, a three-period weighted moving average forecast for period 6 is:
| A. 203 | |
| B. 216 | |
| C. 236 | |
| D. 239 | |
| E. none of the above. |
Homework Answers
Option D 239
Forecast for Week 6 = 0.50 * Week 5 Demand + 0.30 * Week 4 Demand + 0.20 * Week 3 Demand
Forecast for Week 6 = 0.50 * 250 + 0.30 * 220 + 0.20 * 240
Forecast for Week 6 = 239 Units
Add Answer to:
Consider the following demand data for the Grand Bakery: Week
Demand 1 230 2 170 3...
The Grand Bakery produces 60 special sourdough rolls every day. Any rolls that are not sold...
The Grand Bakery produces 60 special sourdough rolls every day. Any rolls that are not sold each day are given to the employees. They have collected sales data from the past week: Day Rolls sold 1 50 2 50 3 48 4 60 5 53 6 60 What is the value of F6 if they use a 3-day weighted moving average with W1 = 0.6, W2 = 0.2, and W3 = 0.2? Using the data from question 1, calculate the...
Question 2: A Chemical Company estimates the annual demand for a certain product as follows: Week...
Question 2: A Chemical Company estimates the annual demand for a certain product as follows: Week 1 2 3 4 5 6 Demand 649 524 561 738 511 590 Forecast the demand for week 7 using a five-period moving average? (Marks 0.5) (word count maximum:100) Forecast the demand for week 7 using a three-period weighted moving average. Use the following weights: W1 = 0.5, W2 = 0.3, W3 = 0.2.? (Marks 0.5) (word count maximum:100) Forecast the demand for week...
Data on personal consumption expenditures in the United States are shown in the table below. Date...
Data on personal consumption expenditures in the United States are shown in the table below. Date Expenditures May 11,605 June 12,620 July 12,738 August 12,814 Using the weights w1 = 0.70 for the oldest period, w2 = 0.20 for the next oldest period, and w3 = 0.10 for the most recent period, construct a weighted moving average forecast of order k = 3 (i.e., a WMA(3)) for September to the nearest whole number.
For problerms 7 througl use the following time serles data:l Th fol PERIOD DEMAND 221 247 228 233...
Use
excel, show excel commands. #8
For problerms 7 througl use the following time serles data:l Th fol PERIOD DEMAND 221 247 228 233 240 152 163 155 167 158 4 5 7 10 7. () Develop a last period forecast for periods 2 through 11. Calculate the MFE, MAD, and MAPE values for periods 2 through 10. Is this a good model? Why? 8. () Develop a three-period weighted moving average forecast for periods 4 through 11. Use weights...
Question 13 (15 points) Consider the following data concerning the performance of a forecasting method. 200...
Question 13 (15 points) Consider the following data concerning the performance of a forecasting method. 200 280 Month November December January February March Actual demand 300 270 250 310 Forecast 270 260 270 250 a. Forecast the demand for the month of April using three month moving average method. (5 points) b. Forecast the demand for the month of April using weighted moving average method. Weights for last three months (t-1, -2, and t-3) are 0.5, 0.3, and 0.2 respectively....
Please help with questions 7 - 10. PART IV Planning and Controling Operations and Supply Chains...
Please help with questions 7 - 10.
PART IV Planning and Controling Operations and Supply Chains 290 period 1 was 250. Plot the results. Which model appears to work better? Why? 10. After graduating from college, you and your friends start selling birdhouses made from recycled plast has caught on, as shown by the following sales figures For problems 4 through 6, use the following time series data: The idea DEMAND MONTH January 2012 February March April May June 119...
PART 1) USE A WEIGHTED MOING AVERAGE OF THE following data with weights of 3, 2...
PART 1) USE A WEIGHTED MOING AVERAGE OF THE following data with weights of 3, 2 (MOST RECENT TO OLDEST). PART 2) WHat is the MAPE value for your forecast? Month Actual DEMAND 1 15 2 10 3 30 4 25
please i need asap answer 1. Given the data below, compute for the following: a) Forecasts...
please i need asap
answer
1. Given the data below, compute for the following: a) Forecasts for P5 to P12 using a 4-period simple moving average b) Forecasts for P5 to P12 using a 4-month weighted moving average with the following weights: Most recent period = 0.40 2nd most recent period = 0.30 3rd most recent period = 0.20 4th most recent period = 0.10 Assuming a forecast of 5,000 units for Period 4 and a = 0.30, compute for...
Consider the following time series data. Week 1 2 3 4 5 6 Value 19 11 16 1017 15 (a) Construct a ...
Consider the following time series data. Week 1 2 3 4 5 6 Value 19 11 16 1017 15 (a) Construct a time series plot. 20 20 20 18 16 14 12 10 c 14 12 12 0 23 4 5 67 0 23 4 5 67 Week Weck Week 20 18 0 1 2345 6 7 Week What type of pattern exists in the data? The data appear to follow a seasonal pattern. The data appear to follow a...
Consider the following time series data. Week 1 2 3 4 5 6 Value 19 14...
Consider the following time series data. Week 1 2 3 4 5 6 Value 19 14 17 12 17 14 Develop a three-week moving average for this time series. Compute MSE and a forecast for week 7. Round your answers to two decimal places. Week Time Series Value Forecast 1 19 2 14 3 17 4 12 5 17 6 14 MSE: The forecast for week 7: Use = 0.2 to compute the exponential smoothing values for the time series....
Use
excel, show excel commands. #8
For problerms 7 througl use the following time serles data:l Th fol PERIOD DEMAND 221 247 228 233 240 152 163 155 167 158 4 5 7 10 7. () Develop a last period forecast for periods 2 through 11. Calculate the MFE, MAD, and MAPE values for periods 2 through 10. Is this a good model? Why? 8. () Develop a three-period weighted moving average forecast for periods 4 through 11. Use weights...
Question 13 (15 points) Consider the following data concerning the performance of a forecasting method. 200 280 Month November December January February March Actual demand 300 270 250 310 Forecast 270 260 270 250 a. Forecast the demand for the month of April using three month moving average method. (5 points) b. Forecast the demand for the month of April using weighted moving average method. Weights for last three months (t-1, -2, and t-3) are 0.5, 0.3, and 0.2 respectively....
Please help with questions 7 - 10.
PART IV Planning and Controling Operations and Supply Chains 290 period 1 was 250. Plot the results. Which model appears to work better? Why? 10. After graduating from college, you and your friends start selling birdhouses made from recycled plast has caught on, as shown by the following sales figures For problems 4 through 6, use the following time series data: The idea DEMAND MONTH January 2012 February March April May June 119...
please i need asap
answer
1. Given the data below, compute for the following: a) Forecasts for P5 to P12 using a 4-period simple moving average b) Forecasts for P5 to P12 using a 4-month weighted moving average with the following weights: Most recent period = 0.40 2nd most recent period = 0.30 3rd most recent period = 0.20 4th most recent period = 0.10 Assuming a forecast of 5,000 units for Period 4 and a = 0.30, compute for...
Consider the following time series data. Week 1 2 3 4 5 6 Value 19 11 16 1017 15 (a) Construct a time series plot. 20 20 20 18 16 14 12 10 c 14 12 12 0 23 4 5 67 0 23 4 5 67 Week Weck Week 20 18 0 1 2345 6 7 Week What type of pattern exists in the data? The data appear to follow a seasonal pattern. The data appear to follow a...
Most questions answered within 3 hours.
-
New Air Heating and Cooling, manufactures furnaces and central
air units. The company pride itself on...
asked 4 seconds from now -
A coach uses a new technique to train gymnasts. Seven
gymnasts were randomly selected and their...
asked 1 hour ago -
While rotating the tires on your car you notice a rock [mass =
0.1 Kg] stuck...
asked 3 hours ago -
Using MARS simulator, write MIPS programs according to
the following scenarios: Receive a positive integer number...
asked 5 hours ago -
An object in front of a concave mirror has a real image that is
11.5 cm...
asked 6 hours ago -
Consider the reaction, C3 H8 + O2 --> CO2 + H2O. How many
moles of O2...
asked 7 hours ago -
You and your opponent both roll a fair die. If you both roll the
same number,...
asked 8 hours ago -
In a study of the accuracy of fast food​ drive-through orders,
Restaurant A had 257 accurate...
asked 8 hours ago -
Identify and describe in detail the four categories of
institutions that could be included in a...
asked 8 hours ago -
In python
class Customer:
def __init__(self, customer_id, last_name, first_name, phone_number, address):
self._customer_id = int(customer_id)
self._last_name =...
asked 8 hours ago -
What is an example of a limitation in implementing a new
ERP system and how it...
asked 8 hours ago -
In a section of 9.7cm of an artery with a radius of 2.6mm there
is a...
asked 8 hours ago