Question

In: Statistics and Probability

QUESTION 11 Questions 11-12 Q11. The past demand data shown below can be regarded as having...

QUESTION 11

  1. Questions 11-12

    Q11. The past demand data shown below can be regarded as having a horizontal pattern. The naïve method ( Y't+1 = Y't ) was applied to make the forecasts for February – May.

    Month

    Demand

    January

    40

    February

    45

    March

    50

    April

    32

    Q11. What are the mean absolute errors (MAE) for February, March, and April forecasts?

    a.

    9.33

    b.

    25.0

    c.

    84.75

    d.

    8.47

    e.

    None of the above

1.5 points   

QUESTION 12

  1. Q12. What are the mean absolute percent errors (MAPE) for the February, March, and April forecasts?

    a.

    10.12%

    b.

    22.10%

    c.

    25.79%

    d.

    41.45%

    e.

    None of the above

Solutions

Expert Solution

Naive method is where the forecast for the current period is the same as previous period.

Eg: Forecast Feb = Actual Jan

Since we do not have any forecast for Jan, so we leave it lke that

Month Demand Forecast Error Abs Error Percent abs error
January 40
February 45 40 5 5 11.11%
March 50 45 5 5 10.00%
April 32 50 -18 18 56.25%
Total 28 77.36%
Mean 9.33 25.79%

Here the error = Actual - forecast

Absolute error = only the error without any +ve and -ve signs

Absolute percent error = abs error / actual demand

Q11.

What are the mean absolute errors (MAE) for February, March, and April forecasts?

MAE = .................there are 3 pairs of actual and forecast values

= 28 / 3

a. 9.33


Q12  

What are the mean absolute percent errors (MAPE) for the February, March, and April forecasts?

The absolute percent error = Abs error / Actual demand

eg: APE for April = 18 / 32

MAPE =

c.

25.79%


Related Solutions

1.      The demand data for a product over the past 5 months are shown below: MONTH...
1.      The demand data for a product over the past 5 months are shown below: MONTH DEMAND (number of units sold) Five months ago 51 Four months ago 58 Three months ago 63 Two months ago 71 Last month 77 a.      Plot the monthly demand data using a software OR on a sheet of graph paper. b.      Use TREND PROJECTIONS method to determine the equation of the trend line estimating the linear relationship between time (in months) and demand (in...
QUESTION 11 Garner-Wagner Manufacturing Inc. is considering some new equipment whose data are shown below. The...
QUESTION 11 Garner-Wagner Manufacturing Inc. is considering some new equipment whose data are shown below. The equipment has a 3-year tax life and would be fully depreciated by the straight-line method over 3 years, but it would have a positive pre-tax salvage value at the end of Year 3, when the project would be closed down. Also, some new working capital would be required, but it would be recovered at the end of the project's life. Revenues and other operating...
Questions 11 and 12 below are based on the following information and assumptions: AAA takes a...
Questions 11 and 12 below are based on the following information and assumptions: AAA takes a Long position in 1 futures contract on cheese. The cheese futures contract has contract size = 100 units (multiplier). BBB takes a Short position in 1 futures contract on cheese. The cheese futures contract has contract size = 100 units (multiplier). The value of 1 futures contract is $10,000 (= $100 *100). The Margin Account is 10% of the value of a futures contract,...
[The following information applies to the questions displayed below.] Data for Hermann Corporation are shown below:...
[The following information applies to the questions displayed below.] Data for Hermann Corporation are shown below:   Per Unit Percent of Sales   Selling price    $ 140 100%   Variable expenses 91   65%   Contribution margin    $ 49   35%     Fixed expenses are $88,000 per month and the company is selling 3,000 units per month. Required: 1-a. The marketing manager argues that a $9,300 increase in the monthly advertising budget would increase monthly sales by $21,500. Calculate the increase or decrease in net operating...
[The following information applies to the questions displayed below.] Data for Hermann Corporation are shown below:...
[The following information applies to the questions displayed below.] Data for Hermann Corporation are shown below:   Per Unit Percent of Sales   Selling price    $ 80 100%   Variable expenses 44   55%   Contribution margin    $ 36   45%     Fixed expenses are $76,000 per month and the company is selling 2,500 units per month. 2. value: 1.25 points Required information Required: 1-a. The marketing manager argues that a $8,100 increase in the monthly advertising budget would increase monthly sales by $15,500. Calculate the...
Question 1 (of 11)Question 2 (of 11)Question 3 (of 11)Question 4 (of 11)Questions 5 - 6...
Question 1 (of 11)Question 2 (of 11)Question 3 (of 11)Question 4 (of 11)Questions 5 - 6 (of 11)Questions 7 - 9 (of 11)Questions 10 - 11 (of 11)  Save & ExitSubmit   Time remaining: 0:51:30   Problem 7-5A Determine depreciation under three methods (LO7-4) [The following information applies to the questions displayed below.] University Car Wash built a deluxe car wash across the street from campus. The new machines cost $270,000 including installation. The company estimates that the equipment will have a residual...
QUESTION #45: Required information [The following information applies to the questions displayed below.] Shown below is...
QUESTION #45: Required information [The following information applies to the questions displayed below.] Shown below is information relating to the stockholders' equity of Reeve Corporation as of December 31, 2018: 3.5% cumulative preferred stock, $100 par $ 1,200,000 Common stock, $10 par, 400,000 shares authorized, 148,000 shares issued and outstanding 1,480,000 Additional paid-in capital: Common stock 444,000 Retained earnings (Deficit) (74,000 ) Dividends in arrears 42,000 PART A: How many shares of preferred stock are issued and outstanding? PART B:...
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...
For a highly repetitive operation, using the data shown below, answer the questions that follow: (10...
For a highly repetitive operation, using the data shown below, answer the questions that follow: (10 points) First unit (minutes) = 11 Learning curve = 90% Salary per hour = $10.50 What is the time required to produce the 20th unit? If steady state is achieved with 20 units,what is the labor cost per unit for this operation?
Below is collected data of the question "how many kisses have you eaten in the past...
Below is collected data of the question "how many kisses have you eaten in the past day?" This is between men and women. The tables are these: Male: 2, 4, 3, 1, 3, 3, 5, 3, 0, 0, 2, 0, 3, 1, 1, 4, 2, 3, 5, 4, 3, 1, 2, 3, 2, 0, 1, 3, 2,0    Female: 1, 2, 3, 0, 2, 4, 2, 1, 1, 5, 2, 1, 0, 1, 0, 0, 2, 1, 3, 0, 1,0, 2,...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT