Question
In: Operations Management
Historical demand for a product is as follows: April 60 May 60 Jun
Historical demand for a product is as follows:
April 60
May 60
June 55
July 75
August 80
September 75
(a.) Using a simple four-month moving average, calculate a forecast for October.
(b.) Using single exponential smoothing with alpha=0.3 and a September forecast =70, calculate a forecast for October.
(c.) Using simple linear regression, calculate the trend line (Yt) for the historical data. The X-axis scale is: April = 1, May = 2, and so forth. Y-axis is Demand from above.
Yt = a + bx =
(d.) Using the linear regression model above, what is a forecast for October?
Solutions
keosha answered 1 year agoRelated Solutions
Historical demand for a product is as follows: DEMAND April 61 May 56 June 81 July...
Historical demand for
a product is as follows:
DEMAND
April
61
May
56
June
81
July
61
August
86
September
81
a.
Using a simple four-month moving average, calculate a forecast for
October. (Round your answer to 2 decimal
places.)
b.
Using single exponential smoothing with α = 0.30 and a
September forecast = 64, calculate a forecast for October.
(Round your answer to 2 decimal places.)
c.
Using simple linear regression, calculate the trend line for the
historical data....
Historical demand for a product is: DEMAND January 20 February 19 March 23 April 20 May...
Historical demand for a product is:
DEMAND
January 20
February 19
March 23
April 20
May 24
June 23
a. Using a weighted moving average with weights of 0.40 (June),
0.40 (May), and 0.20 (April), find the July forecast. (Round your
answer to 1 decimal place.) July forecast
b. Using a simple three-month moving average, find the July
forecast. (Round your answer to 1 decimal place.) July forecast
c. Using single exponential smoothing with ? = 0.30 and a June...
Historical demand for a product is DEMAND January 15 February 12 March 16 April 15 May...
Historical demand for a product is
DEMAND
January
15
February
12
March
16
April
15
May
17
June
16
a. Using a weighted moving average with weights
of 0.60 (June), 0.20 (May), and 0.20 (April), find the July
forecast. (Round your answer to 1 decimal
place.)
b. Using a simple three-month moving average,
find the July forecast. (Round your answer to 1 decimal
place.)
c. Using single exponential smoothing with
? = 0.30 and a June forecast = 11, find...
The stockholders’ equity section of Jun Company’s balance sheet as of April 1 follows. On April...
The stockholders’ equity section of Jun Company’s balance sheet
as of April 1 follows. On April 2, Jun declares and distributes a
10% stock dividend. The stock’s per share market value on April 2
is $25 (prior to the dividend).
Common stock—$5 par value, 455,000 shares
authorized, 240,000 shares issued and outstanding$1,200,000
Paid-in capital in excess of par value, common stock 570,000
Retained earnings 873,000
Total stockholders' equity$2,643,000
Prepare the stockholders’ equity section immediately after the
stock dividend.
The stockholders’ equity section of Jun Company’s balance sheet as of April 1 follows. On April...
The stockholders’ equity section of Jun Company’s balance sheet
as of April 1 follows. On April 2, Jun declares and distributes a
20% stock dividend. The stock’s per share market value on April 2
is $15 (prior to the dividend).
Common stock—$5 par value,
475,000 shares authorized, 250,000 shares issued and
outstanding
$
1,250,000
Paid-in capital in excess of par
value, common stock
590,000
Retained earnings
883,000
Total stockholders' equity
$
2,723,000
Prepare the stockholders’...
Historical demand for iphones in a retail store is as follows: Sales January 12 February...
Historical demand for iphones in a retail store is
as follows:
Sales
January
12
February
14
March
15
April
12
May
16
a) Using the simple mean method, find the June
forecast.
b) Using a simple exponential smoothing with alpha
= 0.1 and a January forecast = 13, find the June Forecast.
c) Use MAD to decide which method produced the
better forecast.
Suppose the Demand and supply curve for a particular product is as follows: D(p)=60-5p S(p)=5p+20 Suppose...
Suppose the Demand and supply curve for a particular product is
as follows:
D(p)=60-5p
S(p)=5p+20
Suppose city council considers implementing a small lump sum tax
of $T per unit traded (i.e. if the consumer pays p then the
producer receives p-T).
Question: What is the tax incidence on
consumers?
Hint 2: The derivative of demand and supply with respect to
price is just the slope of the curves, in this case -5, and 5
respectively.
Meredith Company has budgeted sales for the upcoming months as follows: April $ 458,000 May $...
Meredith Company has budgeted sales for the upcoming months as
follows: April $ 458,000 May $ 469,000 June $ 498,000 July $
517,000 August $ 501,000 September $ 482,000 40% of the sales are
credit sales, the remainder are made in cash. Credit sales are
collected 50% in the month of sale, 35% in the month following the
sale, and 6% in the second month following the sale. a. Compute
Meredith Company’s cash receipts for June. (Do not round
intermediate...
Stock XYZ is currently trading at $50. A JUN 60 call option on the stock is...
Stock XYZ is currently trading at $50. A JUN 60 call option on
the stock is quoted at $12.65. The delta on the call is 0.5866, and
its gamma is 0.0085. At the same time, a JUN 65 call option on this
stock is quoted at $17.75 with a delta of 0.5432 and gamma of
0.0089. You currently have a short position on the JUN 60 call for
60 contracts. The risk-free rate is 5%. (1) Construct a hedging
strategy...
For a newsvendor product the probability distribution of demand X (in units) is as follows: xi...
For a newsvendor product the probability distribution of demand
X (in units) is as follows:
xi 0 1 2 3 4 5 6
pi 0.05 0.1 0.2 0.3 0.2 0.1 0.05
The newsvendor orders Q = 4 units.
a) Derive the probability distributions and the cumulative
distribution functions of lost sales as well as leftover
inventory.
b) Knowing that the expected total cost function is convex in
the order quantity Q, demonstrate that Q = 4 gives the minimal
expected...
ADVERTISEMENT
ADVERTISEMENT
Latest Questions
- Draw a DFA for the following ( ∑ = {0,1}): Set of all strings with.
- In the article from Forbes notes that the goal of a leader is not to clone...
- Many people keep time using a 24 hour clock (11 is 11am and 23 is 11pm,...
- UNIX ONLY -- DIFFICULT LAB ASSIGNMENT This is an extremely difficult subject for me. Could you...
- Do you know why your credit card can be refused even though you are profitable?
- The Following Java expression: S/10 * 10 + 10 – S = C Show that this...
- Year Cash Flow 0 −$9,700 1 5,800 2 2,500 3 3,400 &nb
ADVERTISEMENT