Question
In: Math
Using the demand data supplied in the below table, please calculate the following from your company's forecasting perspective.
Using the demand data supplied in the below table, please calculate the following from your company's forecasting perspective. Please use Excel to calculate your forecasting answers, so behind the cells in Excel, there has to be formulas for answering the below questions. Your company wants to forecast the demand for their product, based on the data below
a) Calculate the simple four-week moving average for weeks 5 through 12
b) Calculate the weighted three-week moving average using weights of 0.40, 0.40, and 0.20 for weeks 4 through 12
c) Calculate the exponential smoothing forecast for weeks 2 through 12 using an initial forecast of 4400 units and an alpha of 0.30
d) Calculate the exponential smoothing forecast plus trend for week2 through 12 using an alpha of 0.10, delta of 0.20, a previous forecast including trend of 4600 units, a previous trend of 120 units
e) Calculate the MAD and MAPE for all four of the forecasting models. Which forecast method do you recommend and why?
| Week | Demand |
|---|---|
| 1 | 4500 |
| 2 | 4750 |
| 3 | 5400 |
| 4 | 5800 |
| 5 | 6250 |
| 6 | 6500 |
| 7 | 7000 |
| 8 | 7500 |
| 9 | 7920 |
| 10 | 8200 |
| 11 | 8500 |
| 12 | 8800 |
Solutions
milcah answered 2 years agoRelated Solutions
Using the data in the table below, calculate the return for investing in the share from...
Using the data in the table below, calculate the return for
investing in the share from 1 January to 31 December. Prices are
after the dividend has been paid
Date
Price
Dividend
Jan 1
$31.53
−
Feb 5
$31.11
$0.22
May 14
$30.67
$0.18
Aug 13
$31.78
$0.21
Nov 12
$37.95
$0.22
Dec 31
$40.11
Return for the entire period is ................. %. (Enter
your response as a percent rounded to two decimal places.)
1. From the data shown in the table below about demand for smart phones, calculate the...
1. From the data shown in the table below about demand for smart
phones, calculate the price elasticity of demand (using the arc
method) from: 1.1. Point B to point C 1.2. Point D to
point E 1.3. Point G to point H Classify the
elasticity at each point as elastic, inelastic or unit elastic.
Points P Q A 60 3,000 B 70 2,800 C 80 2,600 D 90 2,400 E 100 2,200
F 110 2,000 G 120 1,800 H...
Using the data in the table below, estimate the demand function for cod. Price, dollars...
Using the data in the table below, estimate the demand function
for cod.
Price, dollars per pound
Quantity, thousand pounds per day
1.90
1.5
1.35
2.2
1.25
4.4
1.20
5.9
0.95
6.5
0.85
7.0
0.73
8.8
Using the Excel trendline option to estimate a linear demand
function, the linear demand function is
Qequals=12.53 minus 6.25 p12.53−6.25p.
Suppose the quantity in the first row of the table were
22
instead of 1.5.
The linear demand function would now be
Qequals=nothingminus−nothingp....
Using the data in the table, calculate the return for investing in the stock from January...
Using the data in the table, calculate the return for investing
in the stock from January 1 to December 31. Prices are after the
dividend has been paid. Date Price Dividend Jan 1 $ 34.96 minus
Feb 5 $ 30.19 $ 0.21 May 14 $ 28.61 $ 0.19 Aug 13 $ 32.06 $ 0.21
Nov 12 $ 37.48 $ 0.18 Dec 31 $ 42.57 minus Return for the entire
period is nothing%. (Round to two decimal places.
Using the following 8 weeks of demand data to determine the best forecasting method. Compare 3...
Using the following 8 weeks of demand data to determine the best
forecasting method. Compare 3 period simple moving average, 3
period weighted moving average and exponential smoothing. Week
Sales 1 133 2 137 3 145 4 146 5 150 6 124 7 135 8 130
a) What is the MAD using the 3 period simple moving average
(SMA) method
b) What is the forecast for Week 9 using the 3 period simple
moving average forecasting method?
c) What is...
Using the table below calculate the missing values.
Using the table below calculate the missing
values.YearNominal GDPReal GDPGDP Deflator1 (2007)3,753____________812 (2008)4,5515,009____________3 (2009)5,150____________100.004 (2010)5,6665,255____________5 (2011)____________6,175 158Enter the missing values : the inflation/growth rates as
indicated below.Inflation rate year 1-2 ____________Inflation rate year 3-4 ____________Real growth rate yr. 2-3 ____________Real growth rate yr. 4-5 ____________
3 - From the following data about the demand for dishwashers, calculate the elasticity of demand...
3 - From the following data about the demand for dishwashers,
calculate the elasticity of demand from point A to B, from point C
to D and from point E to point F. Classify the elasticity as
elastic, inelastic or unitary elastic. Also calculate the total
revenue of each point. What happens to total revenue as you
approach unitary elasticity? If cost were not an issue what price
would you choose for your selling price?
Point
Price
In Dollars
Quantity...
Use data from the table below to calculate the equilibrium constants at 25 ∘C for each...
Use data from the table below to calculate the equilibrium
constants at 25 ∘C for each reaction.
Standard Thermodynamic Quantities for Selected Substances
at 25∘C
Substance
ΔH∘f(kJ/mol)
ΔG∘f(kJ/mol)
S∘(J/mol⋅K)
H2(g)
0
0
130.7
N2(g)
0
0
191.6
Br2(g)
30.9
3.1
245.5
Cl2(g)
0
0
223.1
NO2(g)
33.2
51.3
240.1
N2O4(g)
9.16
99.8
304.4
NH3(g)
-45.9
-16.4
192.8
P4(g)
58.9
24.4
280.0
PH3(g)
5.4
13.5
210.2
Part A
2NO2(g)⇌N2O4(g)
Find K
Part B
Br2(g)+Cl2(g)⇌2BrCl(g)
ΔG∘f for BrCl(g) is -1.0 kJ/mol
Find...
The table below summarizes data from a survey of a sample of women. Using a 0.05...
The table below summarizes data from a survey of a sample of
women. Using a 0.05 significance level, and assuming that the
sample sizes of 900 men and 400 women are predetermined, test the
claim that the proportions of agree/disagree responses are the
same for subjects interviewed by men and the subjects interviewed
by women. Does it appear that the gender of the interviewer
affected the responses of women? Gender of Interviewer Man Woman
Women who agree 619 314 Women...
The table below summarizes data from a survey of a sample of women. Using a 0.01...
The table below summarizes data from a survey of a sample of
women. Using a 0.01 significance level, and assuming that the
sample sizes of 900men and 300 women are predetermined, test the
claim that the proportions of agree/disagree responses are the
same for subjects interviewed by men and the subjects interviewed
by women. Does it appear that the gender of the interviewer
affected the responses of women?
Man
Woman
Women who agree
617
235
Women who disagree
283
65...
ADVERTISEMENT
ADVERTISEMENT
Latest Questions
- K-NN and Perceptron theory question If we don’t care about the size of the TRAINING SET...
- Make a C program that simulates time-sharing in the operating system. Please follow the instructions provided:...
- What are some current challenges faced by food companies in reducing food waste?
- Arthur buys $2,200.00 worth of stock. Six months later, the value of the stock has risen...
- The Following table is based on a time study for a metal working operation Obs (minutes...
- Write a method that returns the percentage of the number of elements that have the value true...
- Jane is the financial manager for Alpha Corporation. She has been asked to perform a lease-versus-purchase...
ADVERTISEMENT