Calculate the forecast for 2015 quarter

Assignment Help Business Management
Reference no: EM131659852

1. Below showing sales for the past 7 quarters.

Sales

2013 Quarter 4 → 153

2014 Quarter 1 → 117

2014 Quarter 2 → 162

2014 Quarter 3 → 108

2014 Quarter 4 → 144

2015 Quarter 1 → 171

2015 Quarter 2 → 153

a. Using a three-quarter moving average model, calculate the forecast for 2015 Quarter 3 sales.

b. Use the last four quarters as the basis for determining the historical MAD assuming that a three-quarter moving average model was used to forecast sales. For example, the forecast for 2014Q3 would be 144 resulting in an absolute deviation of 36 (now, calculate the forecasts and absolute deviations for 2014Q4, 2015Q1, and 2015Q2, then average the four absolute deviations to get your MAD). 

c. Predict the range of 2015 Quarter 3 sales using your forecast and your MAD. The range should include actual sales with 95% confidence. 

And for each question my answers are as follows:

a. Forecast for 2015 Quarter 3 sales is  156

b. MAD is 24.

c. Range of uncertainty is from 96 to 216 for 2015 Q3.

Does my answers seems accurate?

If not, can you please guide me how to approach the questions?

Reference no: EM131659852

Questions Cloud

Consider president harry truman executive decision : Consider President Harry Truman's executive decision to seize the steel mills in the Youngstown Sheet & Tube, Co. v. Sawyer case.
Discuss the epidemiology of thalassemia : Discuss the epidemiology of thalassemia and share evidence-based practice guidelines necessary for chronic management.
Does structure follow strategy-strategy follow structure : Does Structure follow Strategy or does Strategy follow Structure? Why do organizations struggle to implement strategies at times?
Discuss strengths are high qualified health staff : Strengths are high qualified health staff, Good reputation, high respect for patients, willingness for elderly to be cared for, advertising through
Calculate the forecast for 2015 quarter : a. Using a three-quarter moving average model, calculate the forecast for 2015 Quarter 3 sales.
Should the court hold the defendant liable for the pollution : Parks Hiway filed a suit in an Alaska state court against Petroleum Sales, among others. Should the court hold the defendant liable for the pollution?
Some industries are more suited to a matrix environment : Some industries are more suited to a Matrix Environment. What industries are they and why does it suit them.
Name two different methods for evaluating evidence : Name two different methods for evaluating evidence. Compare and contrast these two methods.
Is overall welfare improved or reduced by the tax : a. Is overall welfare improved or reduced by the tax? b. Would social welfare in the industry be larger or smaller if it were monopolized and the tax were drop

Reviews

Write a Review

Business Management Questions & Answers

  What are maximum profit and the corresponding buy levels

What are the maximum profit and the corresponding make/buy levels?- Compare the maximum profit in (a) to the maximum profit achievable without integer constraints.

  Possible conflict between an industry

Is there a possible conflict between an industry that sells a product that can have negative consequences from the use of its product and the industry's.

  Excellent restaurant management abilities

David's good friend Oliver owns and operates a chain of sandwich shops, which have also thrived due to Oliver's excellent restaurant management abilities.

  Why is the balanced scorecard an important topic

Why is the Balanced Scorecard an important topic both in devising objectives and in evaluating strategies

  Responsibility of working with your organization

You have been given the responsibility of working with your organization's CEO to do a competitive market analysis of the potential success of one of their existing products. Select your organization and a product produced by that organization from..

  Find the annual cost of holding cycle inventory

Find the Safety Stock (SS). -  Find the annual cost of holding cycle inventory and placing orders. - how much should be ordered?

  Consumption of a product

Identify the different situations that might involve the consumption of a product. Determine which products or brands are most likely to be purchased or consumed across those situations.

  Acres to clear when the price of labor

Suppose Woody Chuck's is one of many firms clearing land (hint: competitive market) and that the market price per cleared lot is $4000. What's the profit maximizing number of acres to clear when the price of labor is $4?

  Profitability being synonymous with happy employees

What are they doing right that other entities haven't quite figured out yet in terms of profitability being synonymous with happy employees?

  Problem regarding the pay for performance method

Choose a pay for performance method from the following categories: Individual, Group, or Organizational performance and use the Internet to locate the website of a company which has recently introduced a new pay system.

  Decision making model

Please refer to the bottom of page 287 in Accounting in a Nutshell.  Read Self Test Question 4.  I would like you to use the information from this question to respond to the following: What decision making model would you use to make this decision (P..

  Detailed specific on the services provided by the business

Detailed specific on the services provided by the business

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!

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