User Account

All Pages

Calculate the projected demand for the test equipment

Assignment Help Applied Statistics
Reference no: EM131316755

Assignment - Forecasting Models

Scenario: Ajax Manufacturing is an electronic test equipment manufacturing firm that markets a certain piece of specialty test equipment. Ajax has several competitors who currently market similar pieces of equipment.  While customers have repeatedly indicated they prefer Ajax's test equipment, they have historically proven to be unwilling to wait for Ajax to manufacture this certain piece of equipment on demand and will purchase their test equipment from Ajax's competitors in the event Ajax does not have the equipment available in inventory for immediate delivery. Thus, the key to Ajax successfully maintaining market share for this particular piece of equipment has been to have it available in stock for immediate delivery. Unfortunately, it is a rather expensive piece of equipment to maintain in inventory. 

Period    Actual Number of Sold Units           Period   Actual Number of Sold Units

1             33                                                16           38

2             36                                                17           37

3             32                                                18           37

4             35                                                19           37

5             33                                                20           35

6             34                                                21           37

7             34                                                22           34

8             38                                                23           35

9             37                                                24           34

10           36                                                25           36

11           38                                                26           32

12           36                                                27           35

13           37                                                28           33

14           39                                                29           38

15           35                                                30           37

Thus, the president of Ajax Manufacturing is very interested in accurately forecasting market demand in order to ensure he has adequate inventory available to meet customer demand without incurring undue inventory costs.  His sales department has provided historical data (in the table above) regarding market demand for this certain piece of specialty electronics test equipment for the past 30 months.

Instructions for Homework Assignment: Use the provided Excel file to construct a spreadsheet for each of the four models then answer Questions 26 - 28 based upon your calculations.

Model 1: Answer the following questions.

Question 1: Calculate the projected demand for the test equipment for the time periods 4 - 31 based upon a 3-month moving average forecast model. What is the projected demand for period 31?

Question 2: Calculate the mean absolute deviation (MAD) for the 3-month moving average forecast for each of the time periods 4 through 30 and for the model.

Question 3: Calculate the mean squared error (MSE) for the 3-month moving average forecast for time periods 4 through 30 and for the model.

Question 4: Calculate the mean absolute percent error (MAPE) for the 3-month moving average forecast for time periods 4 through 30 and for the model.

Question 5: Calculate the Standard Error for the model.

Question 6: Calculate the Bias for the model.

Model 2: Answer the following questions.

Question 7: Calculate the projected demand for the test equipment for the time periods 4 - 31 based upon a 3-month moving average forecast model for which the weighting factor for actual demand one month ago is 3, the weighting factor for actual demand two months ago is 2, and the weighting factor for actual demand three months ago is 1. What is the projected demand for period 31?

Question 8: Calculate the mean absolute deviation (MAD) for the 3-month weighted moving average forecast for each of the time periods 4 through 30 and for the model.

Question 9: Calculate the mean squared error (MSE) for the 3-month weighted moving average forecast for time periods 4 through 30 and for the model.

Question 10: Calculate the mean absolute percent error (MAPE) for the 3-month weighted moving average forecast for time periods 4 through 30 and for the model.

Question 11: Calculate the Standard Error for the model.

Question 12: Calculate the Bias for the model.

Model 3: Answer the following questions.

Question 13: Calculate the projected demand for the test equipment for the time periods 1 - 31 based upon using an exponential smoothing forecast model for which alpha = 0.25. Assume the Forecast is equal to the Demand for period 1. What is the projected demand for period 31?

Question 14: Calculate the mean absolute deviation (MAD) for the exponential smoothing forecast for each of the time periods 1 through 30 and for the model.

Question 15: Calculate the mean squared error (MSE) for the exponential smoothing forecast for time periods 1 through 30 and for the model.

Question 16: Calculate the mean absolute percent error (MAPE) for the exponential smoothing forecast for time periods 1 through 30 and for the model.

Question 17: Calculate the Standard Error for the model.

Question 18: Calculate the Bias for the model.

Model 4: Answer the following questions.

Question 19: Calculate the projected demand for the test equipment for the time periods 1 - 31 based upon using a Regression forecast model. What is the projected demand for period 31?

Question 20: Calculate the mean absolute deviation (MAD) for the Regression forecast for each of the time periods 1 through 30 and for the model.

Question 21: Calculate the mean squared error (MSE) for the Regression forecast for time periods 1 through 30 and for the model.

Question 22: Calculate the mean absolute percent error (MAPE) for the Regression forecast for time periods 1 through 30 and for the model.

Question 23: Calculate the Standard Error for the model.

Question 24: Calculate the Bias for the model.

Question 25: Discuss the correlation between the two variables and is the relationship significant at the 95% level of confidence?

Question 26: Based upon using mean absolute deviation (MAD) as a measure of forecast accuracy, which of the preceding forecast models provides the greatest degree of forecasting accuracy, and which of the preceding forecast models provides the least degree of forecasting accuracy?

Question 27: Based upon using Bias as a measure of forecast accuracy, which of the preceding forecast models provides the greatest degree of forecasting accuracy, and which of the preceding forecast models provides the least degree of forecasting accuracy?

Question 28: Based upon using the Standard Error as a measure of forecast accuracy, which of the preceding forecast models provides the greatest degree of forecasting accuracy, and which of the preceding forecast models provides the least degree of forecasting accuracy?

Reference no: EM131316755

Questions Cloud

What effect would an increase in the prime rate : What effect would an increase in the prime rate to 4.75 percent for the entire year have on Matthews' effective borrowing rate (EBR) calculated in part (a)?
Prepare a report recommending job analysis and job design : Your boss has asked you to prepare a report recommending job analysis and job design, recruitment and selection strategies that can be adopted by the company to fulfill its staffing needs in view of overall PM strategies.
How large of a cash balance relative to total assets : How large of a cash balance relative to total assets do these companies have?- How has the cash balance (relative to total assets) changed over the last ten years?
What would be annual return on a similar japanese investment : An investor can purchase a U.S. T-bill that matures in six months and earns an annual rate of return of 3 percent. What would be the annual return on a similar Japanese investment?
Calculate the projected demand for the test equipment : Calculate the projected demand for the test equipment for the time periods 4 - 31 based upon a 3-month moving average forecast model. What is the projected demand for period 31
Define a multinational corporation : What additional factors must be considered by the manager of an MNC that a manager of a purely domestic firm is not forced to face?
Analyze the socio-demographics characteristics of country : Analyze the socio-demographics characteristics of your county.Identify three distinct statistical characteristics of your county and compare them to your observations;Explain how the actual socio-demographics contribution support or do not support y..
An exchange rate is quoted in terms of euros per pound : Explain how triangular arbitrage ensures that currency values are essentially the same in different markets around the world at any given moment.
Who benefits and who loses if yen appreciates against pound : In what sense is it a misnomer to refer to a currency as weak or strong? Who benefits and who loses if the yen appreciates against the pound?

Reviews

Write a Review

Applied Statistics Questions & Answers

  Find the standard deviation

Use the following sample data to find the standard deviation: -1, 0, 2, 3, 7, 7, 10 (Round answer to one decimal position.)

  1 the study you will evaluate for your assignment isbinge

1. the study you will evaluate for your assignment isbinge drinking and alcohol-related behaviours amongst pacific

  The percentages of satisfactory articles

It has been found from past experience that of the articles produced by a factory, 20% come from machine 1, 30% come from machine 2 and 50% come from machine 3. The percentages of satisfactory articles among those produced are 95% for machine 1, 85% ..

  Use descriptive statistics to summarize data

Collect data about hair salons clients vs. walk In's and product vs. services. Explain how you obtained a suitable sample of either qualitative or quantitative data. Review data for validity and reliability. Use descriptive statistics to summarize da..

  What is the correlation

Create and paste in a scatterplot that compares Final Exam Score and Project Score. What is the correlation (r-value)? How would you describe the correlation

  Construct a trend projection equation

Construct a trend projection equation that describes the changes in the student's GPA over time using the table below.

  Emergence of online social networks influences

The focus of the research will be in restaurant and coffee field, may you write this in the problem statement and must write it in the scope of the study.

  Is the test two-tailed left-tailed or right-tailed

Is the test two-tailed, left-tailed, or right-tailed? Explain. Which test statistic will you use for your hypothesis test; z-test or t-test? Explain. What is the value of the test-statistic? What is the P-value?

  What was change in percentile rank from the original plan

What was the change in percentile rank from the original plan to the actual home that was built?

  A quality control analyst measures the number of hours

A quality control analyst measures the number of hours a patient in a low-risk condition waits for care at the emergency room of a small hospital. The following data are obtained for 20 patients.

  What would be the appropriate hypotheses statements

Can you provide on when we might use each type? What would be the appropriate hypotheses statements for each example - comparing multiple sample means is simply an extension of what we covered last week.

  1consider the following scenario for object recognition

1.consider the following scenario for object recognition with two types of objects a and b where the ultimate goal is

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

Submit Assignment

Academics

Major Subjects

Majors

Get In Touch

whatsapp: +1-415-670-9521

Phone: +1-415-670-9521

Email: [email protected]

TERMS & POLICIES

HELP & SUPPORT

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd