Loading...

Messages

Proposals

Stuck in your homework and missing deadline? Get urgent help in $10/Page with 24 hours deadline

Get Urgent Writing Help In Your Essays, Assignments, Homeworks, Dissertation, Thesis Or Coursework & Achieve A+ Grades.

Privacy Guaranteed - 100% Plagiarism Free Writing - Free Turnitin Report - Professional And Experienced Writers - 24/7 Online Support

4 quarter centered moving average

18/10/2021 Client: muhammad11 Deadline: 2 Day

Business Forecasting With Excel

4. In a time-series decomposition of sales (in millions of units), the following trend has been estimated:

CMAT = 4.7 * 0.37(T)

The seasonal indices have been found to be:

For the coming year the time index and cycle factors are:

a. From this information prepare a forecast for each quarter of the coming year.

b. Actual sales for the year you forecast in part (a) were 17.2, 13.2, 10.8, and 14.2 for quarters 1, 2, 3, and 4, respectively. Use these actual sales figures along with your forecasts to calculate the root-mean-squared error for the forecast period.

5. A tanning parlor located in a major shopping center near a large New England city has the following history of customers over the last four years (data are in hundreds of customers):

a. Construct a table in which you show the actual data (given in the table), the centered moving average, the centered moving-average trend, the seasonal factors, and the cycle factors for every quarter for which they can be calculated in years 1 through 4.

b. Determine the seasonal index for each quarter.

c. Do the best you can to project the cycle factor through 2008.

d. Make a forecast for each quarter of 2008.

e. The actual numbers of customers served per quarter in 2008 were 6.8, 5.1, 4.7, and 6.5 for quarters 1 through 4, respectively (numbers are in hundreds). Calculate the

RMSE for 2008.

f. Prepare a time-series plot of the actual data, the centered moving averages, the long-term trend, and the values predicted by your model for 2004 through 2008 (where data are available).

8. Kim Brite and Larry Short have developed a series of exclusive mobile-home parks in which each unit occupies a site at least 100  150 feet. Each site is well landscaped to provide privacy and a pleasant living environment. Kim and Larry are considering opening more such facilities, but to help manage their cash flow they need better forecasts of mobile-home shipments (MHS), since MHS appears to influence their vacancy rates and the rate at which they can fill newly opened parks. They have 16 years of data on mobile-home shipments, beginning with 1988Q1 and ending with 2003Q4, as shown:

Assuming that Kim Brite and Larry Short have hired you as a forecasting consultant:

a. Provide a time-series plot of the actual MHS data along with the deseasonalized data. Write a brief memo in which you report the nature and extent of the seasonality in the data. Include seasonal indices in your report.

b. Develop a long-term linear trend for the data, based on the centered moving averages. Let time equal 1 for 1988Q1 in your trend equation. On the basis of this trend, does the future look promising for Brite and Short?

c. One of the things Ms. Brite and Mr. Short are concerned about is the degree to which MHS is subject to cyclical fluctuations. Calculate cycle factors and plot them in a time-series graph, including projections of the cycle factor through 2004. In evaluating the cycle factor, see whether interest rates appear to have any effect on the cyclical pattern. The rate for 1988Q1 through 2003Q4 is provided in the following table, should you wish to use this measure of interest rates.

d. Demonstrate for Ms. Brite and Mr. Short how well your time-series decomposition model follows the historical pattern in the data by plotting the actual values of MHS and those estimated by the model in a single time-series plot.

e. Prepare a forecast for 2004 and calculate the root-mean-squared error (RMSE), given the actual values of MHS for 2004 shown:

13. a. Use the following data on millions of dollars of jewelry sales (JS) to prepare a time-series decomposition forecast of JS for the four quarters of 2005:

The actual data for 2005 are:

b. Evaluate your model in terms of fit and accuracy using RMSE.

c. Plot your forecast values of JS along with the actual values.

d. Look at the seasonal indices, and explain why you think they do or do not make sense.

e. Compare the results from your time-series decomposition model with those obtained using a Winters’ exponential smoothing model in terms of both fit and accuracy.

4. In a time-series decomposition of sales (in millions of units), the following trend has been estimated:

CMAT = 4.7 * 0.37(T)

The seasonal indices have been found to be:

For the coming year the time index and cycle factors are:

a. From this information prepare a forecast for each quarter of the coming year.

b. Actual sales for the year you forecast in part (a) were 17.2, 13.2, 10.8, and 14.2 for quarters 1, 2, 3, and 4, respectively. Use these actual sales figures along with your forecasts to calculate the root-mean-squared error for the forecast period.

5. A tanning parlor located in a major shopping center near a large New England city has the following history of customers over the last four years (data are in hundreds of customers):

a. Construct a table in which you show the actual data (given in the table), the centered moving average, the centered moving-average trend, the seasonal factors, and the cycle factors for every quarter for which they can be calculated in years 1 through 4.

b. Determine the seasonal index for each quarter.

c. Do the best you can to project the cycle factor through 2008.

d. Make a forecast for each quarter of 2008.

e. The actual numbers of customers served per quarter in 2008 were 6.8, 5.1, 4.7, and 6.5 for quarters 1 through 4, respectively (numbers are in hundreds). Calculate the

RMSE for 2008.

f. Prepare a time-series plot of the actual data, the centered moving averages, the long-term trend, and the values predicted by your model for 2004 through 2008 (where data are available).

8. Kim Brite and Larry Short have developed a series of exclusive mobile-home parks in which each unit occupies a site at least 100  150 feet. Each site is well landscaped to provide privacy and a pleasant living environment. Kim and Larry are considering opening more such facilities, but to help manage their cash flow they need better forecasts of mobile-home shipments (MHS), since MHS appears to influence their vacancy rates and the rate at which they can fill newly opened parks. They have 16 years of data on mobile-home shipments, beginning with 1988Q1 and ending with 2003Q4, as shown:

Assuming that Kim Brite and Larry Short have hired you as a forecasting consultant:

a. Provide a time-series plot of the actual MHS data along with the deseasonalized data. Write a brief memo in which you report the nature and extent of the seasonality in the data. Include seasonal indices in your report.

b. Develop a long-term linear trend for the data, based on the centered moving averages. Let time equal 1 for 1988Q1 in your trend equation. On the basis of this trend, does the future look promising for Brite and Short?

c. One of the things Ms. Brite and Mr. Short are concerned about is the degree to which MHS is subject to cyclical fluctuations. Calculate cycle factors and plot them in a time-series graph, including projections of the cycle factor through 2004. In evaluating the cycle factor, see whether interest rates appear to have any effect on the cyclical pattern. The rate for 1988Q1 through 2003Q4 is provided in the following table, should you wish to use this measure of interest rates.

d. Demonstrate for Ms. Brite and Mr. Short how well your time-series decomposition model follows the historical pattern in the data by plotting the actual values of MHS and those estimated by the model in a single time-series plot.

e. Prepare a forecast for 2004 and calculate the root-mean-squared error (RMSE), given the actual values of MHS for 2004 shown:

13. a. Use the following data on millions of dollars of jewelry sales (JS) to prepare a time-series decomposition forecast of JS for the four quarters of 2005:

The actual data for 2005 are:

b. Evaluate your model in terms of fit and accuracy using RMSE.

c. Plot your forecast values of JS along with the actual values.

d. Look at the seasonal indices, and explain why you think they do or do not make sense.

e. Compare the results from your time-series decomposition model with those obtained using a Winters’ exponential smoothing model in terms of both fit and accuracy.

4. In a time

-

series decomposition of sales (in millions of

units), the following trend has

been

estimated:

CMAT

=

4.7

*

0.37(T)

The seasonal indices have been found to be:

For the coming year the time index and cycle factors are:

a. From this information prepare a forecast for each quarter of the coming year.

b. Actual sales for the year you forecast in part (a) were

17.2, 13.2, 10.8

, and 14.2 for

quarters 1, 2, 3, and 4, respectively. Use these actu

al sales

?

gures along with your

forecasts

to calculate the root

-

mean

-

squared error for the forecast period.

5. A tanning parlor located in a major shopping center ne

ar a large New England city has

the following history of customers over the last four

years (data are in hundreds of

custome

rs):

4. In a time-series decomposition of sales (in millions of units), the following trend has been

estimated:

CMAT = 4.7 * 0.37(T)

The seasonal indices have been found to be:

For the coming year the time index and cycle factors are:

a. From this information prepare a forecast for each quarter of the coming year.

b. Actual sales for the year you forecast in part (a) were 17.2, 13.2, 10.8, and 14.2 for

quarters 1, 2, 3, and 4, respectively. Use these actual sales ?gures along with your forecasts

to calculate the root-mean-squared error for the forecast period.

5. A tanning parlor located in a major shopping center near a large New England city has

the following history of customers over the last four years (data are in hundreds of

customers):

Homework is Completed By:

Writer Writer Name Amount Client Comments & Rating
Instant Homework Helper

ONLINE

Instant Homework Helper

$36

She helped me in last minute in a very reasonable price. She is a lifesaver, I got A+ grade in my homework, I will surely hire her again for my next assignments, Thumbs Up!

Order & Get This Solution Within 3 Hours in $25/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 3 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

Order & Get This Solution Within 6 Hours in $20/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 6 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

Order & Get This Solution Within 12 Hours in $15/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 12 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

6 writers have sent their proposals to do this homework:

Math Specialist
Solution Provider
Financial Assignments
High Quality Assignments
Coursework Helper
Engineering Exam Guru
Writer Writer Name Offer Chat
Math Specialist

ONLINE

Math Specialist

I reckon that I can perfectly carry this project for you! I am a research writer and have been writing academic papers, business reports, plans, literature review, reports and others for the past 1 decade.

$40 Chat With Writer
Solution Provider

ONLINE

Solution Provider

I have done dissertations, thesis, reports related to these topics, and I cover all the CHAPTERS accordingly and provide proper updates on the project.

$48 Chat With Writer
Financial Assignments

ONLINE

Financial Assignments

This project is my strength and I can fulfill your requirements properly within your given deadline. I always give plagiarism-free work to my clients at very competitive prices.

$32 Chat With Writer
High Quality Assignments

ONLINE

High Quality Assignments

I have done dissertations, thesis, reports related to these topics, and I cover all the CHAPTERS accordingly and provide proper updates on the project.

$36 Chat With Writer
Coursework Helper

ONLINE

Coursework Helper

This project is my strength and I can fulfill your requirements properly within your given deadline. I always give plagiarism-free work to my clients at very competitive prices.

$50 Chat With Writer
Engineering Exam Guru

ONLINE

Engineering Exam Guru

I am an academic and research writer with having an MBA degree in business and finance. I have written many business reports on several topics and am well aware of all academic referencing styles.

$39 Chat With Writer

Let our expert academic writers to help you in achieving a+ grades in your homework, assignment, quiz or exam.

Similar Homework Questions

Penshurst girl high school history - Discussion - American Journal of Business Education - Anytime fitness oran park staffed hours - Discussion Board - Greek philosophy reflection. - What are positive risks in project management - Monkey on your back management - Agpt program 2021 eligibility guide - Introduction to java programming 11th edition - Humanities discussion - Disney world's management of waiting lines - Ucd timetable 2016 17 - Natural sources of light - Two way intercom system - Cultural diversity in correctional facilities - Which of the elements of this scenario represent a flow from a firm to a household - Sims metal management daventry - Personal Beliefs Essay - Picasso art gallery of nsw - Apa 7 referencing uwa - Average price for beyonce tickets - Ppt cloud computing architecture - Mufaro's beautiful daughters story pdf - Rutgers criminal justice major - Sex without love poem analysis - Leadership in Nursing - What does montag's description of the tv audience mean - Isolated system potential energy - Kempes engineers year book - Adrp 6 0 mission command - How to do independent t test in spss - Love letters electric maker - HA599 - A large software development firm recently relocated its facilities - Animal farm chapter 9 - Energy isn't created or destroyed - Assignment about finance - Love vashikaran specialist In lucknOw +91!#!#!#9928097710 Top And Best Tantrik Aghori Baba - Aviation hw help - Responding post - Rowlands gill medical centre - Need a rewrite on purchasing &Vendor Management week two - Burgerweeshuispad 54 1076 ep amsterdam - Question number 2 - Castle leazes halls map - Healthy eating informative speech outline - Google project oxygen case study pdf - Ethics of Counseling (Christian Counseling) - A researcher conducts an independent measures two factor study - We describe charitable donations by corporations to nonprofit organizations as - Week 4 - Nomenclature lab - Pr 7 5a bank reconciliation and entries - Kingfisher corporation tax return - Nurs561prompt1 - Dr ross dwyer radiologist - According to the rokeach value survey - Develop a Problem Statement for a Current Criminal Justice Issue - Writing a personal narrative essay - Wicked good cupcakes shark tank - Triangle tube smart 40 parts breakdown - Spiral model risk management - Shakespeare in the bush - Pacific cataract and laser institute case study - Assignment5 - Al2 so4 3 colour - Domain and range of square root functions worksheet - Hassan sheheryar yasin age - Alexander the great quote - Top yogh yaught - Norton intro to literature portable 12th edition - How much heat is evolved when hydrogen - Sanderson suite st helens hospital - Sociology perspectives worksheet - Stryker power pro xt stretcher - Central sterilization technician job description - Chemistry year 7 quiz - HELP! - Max bending moment formula - International benefits and compensation - Jo koy ex wife jennifer santillan - Benchmark - Electrical engineering - Penn foster argument essay - Enter the november balances in the ledger accounts - Our ladys prep school - Impact of rapid environmental changes on organizations - Discussion - Responses - Occupation and tools worksheet - Vce grade distribution 2020 - Picasso continuous line drawings - Great gatsby chapter 9 - Central phenomenon of the study - Module 05 Discussion - When Disaster Strikes - Gunned down the power of the nra worksheet - Ib english vocabulary list - First federal bank pawleys island sc - Matt shirvington 100m pb