Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Attached to this assignment, you will find REAL LIFE data on two product shipments,for the overall industry manufacturing these products.One tab of the Excel spreadsheet

Attached to this assignment, you will find REAL LIFE data on two product shipments,for the overall industry manufacturing these products.One tab of the Excel spreadsheet deals with two kinds of lawn mowers: Walk-behind mowers, and zero-turn radius mowers. The other tab is dishwashers. imagine you have been hired as a consultant to a company that makes these products, to advise them on how many they can expect to sell over the next two years. (Which is exactly how *I* got this data, actually.)

use this data - PLUS any other data you feel it is appropriate to bring in to compare it to.

You might find this website very useful to download GDP, Consumer Price Index, Unemployment, and other stats to match this monthly shipment data I have provided:https://fred.stlouisfed.org/

(Hint: Here is FRED'schart of unemployment, monthly - just like the shipment data. Notice that "download" button there? Then you could theoretically match this up with the shipment months...https://fred.stlouisfed.org/series/UNRATE ) You could also use for other measures listed on the FRED site if you were so inclined.

Look at the forecasting techniques listed on chapter 5, and on page 145 in section 5-3 of the text.This is a time series of data for product sales over a series of years.

Using at least TWO DIFFERENT forecasting methods, I want you to forecast sales through 2016 and 2017 for the two types of mowers,and then for dishwashers. Clearly explain your forecasting methods, and why you chose that technique in your Excel spreadsheet. Analyze and explain your results, and tell why this could be very important to the manufacturer who hired you.

What would you tell them about demand patterns in the near future? Should the build a new factory, or scale back production? Why? What data and evidence do you have to back up your claims?

This one is pretty involved, so I'll put a lot of points on it.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Public Relations

Authors: Tom Kelleher

1st Edition

0190201479, 9780190201470

More Books

Students also viewed these Economics questions

Question

2. How do I perform this role?

Answered: 1 week ago