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

Expert Solution

keosha answered 10 months ago

Next > < Previous

Related 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’...

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...

The inverse demand curve for a product using resource X is given by P = 60...

The inverse demand curve for a product using resource X is given by P = 60 – 0.2Q and the cost of production is constant at MC = 10 1. Find the static equilibrium for this product (recall at equilibrium Supply equates Demand and in this case Supply = Marginal Cost) (call this t0). 2. Draw the static equilibrium. 3. What is the value of consumer surplus from consumption in t0? (recall, this is simply the area under the demand...

John knows that monthly demand for his product follows a normal distribution with a mean of...

John knows that monthly demand for his product follows a normal distribution with a mean of 2,500 units and a standard deviation of 425 units. Given this, please provide the following answers for John. a. What is the probability that in a given month demand is less than 3,000 units? b. What is the probability that in a given month demand is greater than 2,200 units? c. What is the probability that in a given month demand is between 2,200...

Subjects