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 forecast for period 7 using a four-period moving average.
Homework Answers
Add Answer to:
The Grand Bakery produces 60 special sourdough rolls every day.
Any rolls that are not sold...
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.
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.
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...
The details of the hard drive sales for the past 6 weeks are shown in the...
The details of the hard drive sales for the past 6 weeks are shown in the table below. The time series appears to be relatively stable, without trend, seasonal, or cyclical effects. You have been told to use 2 period weighted moving average estimation technique to help in forecasting the needs for next week. (k =2 with weights 0.8, 0.2) Week Units sold 88 44 54 65 572 6 85 You are being asked to help forecast for week 7,...
Masters Level work....all work must be shown. FORECASTING Forecasting ASSIgnment 1. Given the following data, use...
Masters Level work....all work must be shown. FORECASTING
Forecasting ASSIgnment 1. Given the following data, use a three-quarter moving average to forecast the demand for the third quarter of this year. Note, the first quarter is January, February, and March; the second quarter is April, May, and June; the third quarter is July, August, September, and the 4° quarter is October, November, and December ul ct 50 This year 235 245 255 295 305 295 Answer (Please show your work...
QUESTION 5 A carnival runs for 10 days a year. Attendance for each day in each of the past three years has been captured and is provided in the table below. sing the multiplicative seasonal met...
QUESTION 5 A carnival runs for 10 days a year. Attendance for each day in each of the past three years has been captured and is provided in the table below. sing the multiplicative seasonal method, determine the average seasonal index for Day 2. Year 1 Year 2 Year 3 Dayl 13,578 14,471 15,421 Day2 21,659 21,630 21,124 Day3 20,051 20,558 20,367 Day4 12,035 12,820 13,315 Day5 12,264 12,924 12,077 Day6 13,139 13,875 13,818 Day7 18,754 18,801 19,491 Day8 21,670...
Examples 1,2,3 1. Beyond Tea Inc. wants to forecast sales of its menthol green tea. The...
Examples 1,2,3
1. Beyond Tea Inc. wants to forecast sales of its menthol green
tea. The company is considering either using a simple mean or a
three-period moving average to forecast monthly sales. Given sales
data for the past 10 months use both forecasting methods to
forecast periods 7 to 10 and then evaluate each. Which method
should they use? Use the selected method to make a forecast for
month 11. (Show all calculations .... Please read Examples1, 2, 3...
CASE 7.1 Tires for You, Inc Tires for You, Inc. (TFY), founded in 1987, is an automotive repair shop specializing in re...
CASE 7.1 Tires for You, Inc Tires for You, Inc. (TFY), founded in 1987, is an automotive repair shop specializing in replacement tires. Located in Altoona, Pennsylvania, TFY has grown successfully over the past few years because of the addition of a new general manager, Ian Overbaugh. Since tire replacement is a major portion of TFY's business (it also performs oil changes, small mechanical repairs, etc.), Ian was surprised at the lack of forecasts for tire consumption for the company....
The Actual demands in the last 4 periods are given. Which of the following statement is...
The Actual demands in the last 4 periods are given. Which of the following statement is not true? Period Ai Weight 1 10 2 20 0.3 3 30 0.3 4 20 0.4 A. F5=23.33 using Moving Average and n=3 B. F5=20 using Naive Approach C. When the business environment is more dynamic, we tend to choose smaller smoothing constant value. D. F5=23 using Weighted Moving Average when n=3 and the weight is 0.4, 0.3, and 0.3 for period 4, 3,...
Quantitative Methods (STAT-201) Q3 . A manager is deciding whether or not to build a small...
Quantitative Methods (STAT-201) Q3 . A manager is deciding whether or not to build a small facility. Demand is uncertain and can be either at a high or low level. If the manager chooses a small facility and demand is low, the payoff is $30. If the manager chooses a small facility and demand is high, the payoff is $10. On the other hand, if the manager chooses a large facility and demand is low, the payoff is -$20, but...
The details of the hard drive sales for the past 6 weeks are shown in the table below. The time series appears to be relatively stable, without trend, seasonal, or cyclical effects. You have been told to use 2 period weighted moving average estimation technique to help in forecasting the needs for next week. (k =2 with weights 0.8, 0.2) Week Units sold 88 44 54 65 572 6 85 You are being asked to help forecast for week 7,...
Masters Level work....all work must be shown. FORECASTING
Forecasting ASSIgnment 1. Given the following data, use a three-quarter moving average to forecast the demand for the third quarter of this year. Note, the first quarter is January, February, and March; the second quarter is April, May, and June; the third quarter is July, August, September, and the 4° quarter is October, November, and December ul ct 50 This year 235 245 255 295 305 295 Answer (Please show your work...
QUESTION 5 A carnival runs for 10 days a year. Attendance for each day in each of the past three years has been captured and is provided in the table below. sing the multiplicative seasonal method, determine the average seasonal index for Day 2. Year 1 Year 2 Year 3 Dayl 13,578 14,471 15,421 Day2 21,659 21,630 21,124 Day3 20,051 20,558 20,367 Day4 12,035 12,820 13,315 Day5 12,264 12,924 12,077 Day6 13,139 13,875 13,818 Day7 18,754 18,801 19,491 Day8 21,670...
Examples 1,2,3
1. Beyond Tea Inc. wants to forecast sales of its menthol green
tea. The company is considering either using a simple mean or a
three-period moving average to forecast monthly sales. Given sales
data for the past 10 months use both forecasting methods to
forecast periods 7 to 10 and then evaluate each. Which method
should they use? Use the selected method to make a forecast for
month 11. (Show all calculations .... Please read Examples1, 2, 3...
CASE 7.1 Tires for You, Inc Tires for You, Inc. (TFY), founded in 1987, is an automotive repair shop specializing in replacement tires. Located in Altoona, Pennsylvania, TFY has grown successfully over the past few years because of the addition of a new general manager, Ian Overbaugh. Since tire replacement is a major portion of TFY's business (it also performs oil changes, small mechanical repairs, etc.), Ian was surprised at the lack of forecasts for tire consumption for the company....
Most questions answered within 3 hours.
-
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 5 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 7 hours ago -
In a study of the accuracy of fast food drive-through orders,
Restaurant A had 257 accurate...
asked 7 hours ago -
Identify and describe in detail the four categories of
institutions that could be included in a...
asked 7 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 7 hours ago -
What is an example of a limitation in implementing a new
ERP system and how it...
asked 7 hours ago -
In a section of 9.7cm of an artery with a radius of 2.6mm there
is a...
asked 7 hours ago -
the two carboxylic acid groups of aspartic acid have different
acidities with pKa values of 2.1...
asked 7 hours ago