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

Project Management - Maudsley national autism unit - Https lc ugrad1 gcu edu - What is sony's mission statement - How to calculate internal growth rate - First experimental laboratory in psychology - Bus timetable mosgiel to dunedin - Criminal justice the essentials 5th edition pdf free - Fin 571 financial ratio analysis - Collection 5 Reading Stations - Half wave dipole antenna directivity - Netscaler policy cannot be bound to specified policy label - Cilkray graphics case solution - How to write running record observation - Response For DQ1 and 2 - Input and output devices for kids - Epson wf 7610 manual - Joe biden anita hill youtube - Ic 7402 truth table - Ethical Issues in Statistics - Examples of irony in the lottery by shirley jackson - The central park five discussion questions answers - Using nodal analysis find vo in the circuit - The threats from genetically modified foods robin mather - 1 lambda to afr - Television and american culture mittell pdf - IT literature - Tina jones hair skin and nail - Discrete Random Variables - Why i want to be a house vice captain - Plastimo 4 man valise liferaft - Ralph tortorici case - I need a 1000 words proposal on partnership proposal to a courier company. - History 10 - Law and society an introduction steven barkan - Elementary differential equations and boundary value problems eleventh edition - A financial statement audit is designed to - Coca cola gross profit margin - Regent sports and social club - Rheem 310 litre heat pump - Journal-200 words - Sopranos cold cuts freeze frame - Cri du chat brochure - Strong inversion in mosfet - Ana chartered loss adjusters - Bobby rio conversation escalation - How much phenol red to add to media - Csa standard z662 99 - Cargill sioux city bean bid - Ace learning studio fsu - Flow level 126 11x11 - Peri model in public health - What are the ten principles of economics - Pros and cons of zachman framework - 20 mason street dandenong - What are the pros and cons of a socialist economy - Class d lc filter design - Anatomy and Physiology Revealed- Nervous - Access 2016 module 1 sam project 1a - 1 2 cos x graph - Speech 1311 - How would you characterize chiquita's historical approach to global management - Comments for report cards - Questions and answers about servant leadership - The passing of grandison text - Metro 2033 książka download - Rinks chihuahuas - Swagelok tubing clamp catalog - Wafer thermostat wiring diagram - Hca 255 topic 2 quiz - Strategy in practice cliff bowman - Give me liberty 5th edition pdf - Customers experiencing allergic reactions often show which symptom - Order # 9177 - Contingency tables - Identify and describe key milestones in the history of English and Arabic lexicography - Was it necessary to re formulate new coke - Pm asmnt 7 - Emotive language persuasive technique - Computer Crime - Marginal utility per dollar formula - Mabel park high school uniform shop - Find a book title - BUSM1100 Individual Case Study Report - Risk log template prince2 - Denzel Brooks Opens A Web Consulting Business Called Venture Consultants And Completes The Following Transactions In March: - Hay for sale herefordshire - One page assignment - Under armour strengths 2017 - Brinkley the unfinished nation pdf - Reading response - Copper chloride aluminum foil - Annabeth percy jackson sea of monsters - Nsw state records keyname search - Molar heat of combustion symbol - Koko's canine pet club solutions - Calculate the concentration of acetic acid in vinegar - Icheme process safety course - Human family maya angelou - Marketing