QUARTER/YEAR ACTUAL NUMBER OF USERS IN MILLIONS FORECASTED DEMAND2-QUARTER MOVING AVERAGE ABSOLUTE FORECAST ERROR FORECASTED DEMAND3-QUARTER MOVING

Fantastic news! We've Found the answer you've been seeking!

Question:

QUARTER/YEAR	ACTUAL NUMBER OF USERS IN MILLIONS	FORECASTED DEMAND—2-QUARTER MOVING AVERAGE	ABSOLUTE FORECAST ERROR	FORECASTED DEMAND—3-QUARTER MOVING AVERAGE	ABSOLUTE FORECAST ERROR	EXPONENTIAL SMOOTHING WITH SMOOTHING CONSTANT OF 0.2	ABSOLUTE FORECAST ERROR	EXPONENTIAL SMOOTHING WITH SMOOTHING CONSTANT OF 0.9	ABSOLUTE FORECAST ERROR
Q1/2010	30
Q2/2010	40
Q3/2010	49
Q4/2010	54
Q1/2011	68
Q2/2011	85
Q3/2011	101
Q4/2011	117
Q1/2012		1A. Forecast demand using the two-quarter moving average and the three-quarter moving average. 1B. Forecast demand using exponential smoothing, one with the smoothing constant of 0.2 and the other with a smoothing constant of 0.9. Note: Set the forecast for Q1/2010 equal to the demand level for Q1/2010. 1C. Calculate the mean absolute deviation (MAD) of each forecasting method. Which forecasting method would you recommend Alvin Ortega use? Explain why.

Related Book For answer-question

answer-question

Business Statistics

Business Statistics

ISBN: 978-0321925831

3rd edition

Authors: Norean Sharpe, Richard Veaux, Paul Velleman

See More Books

Posted Date: Jan 17, 2020 09:19 AM

See More Questions

Which changeover alternative would you recommend for a B2B company if it introduces the new intranet-based virtual helpdesk described?
Which internal control(s) would you recommend to prevent the following situations from occurring? 1) Authorization of a credit memo for a customers account (on receivables) when the goods were never...
a. Create a 4-period moving average forecast, an exponential smoothing forecast with alpha=0.2, and a linear trend forecast for your data. b. Calculate the MSE and MAD for each. c. Plot the original...
A city starts a solid waste landfill in 2012. When the landfill was opened the city estimated that it would fill to capacity within 5 years and that the cost to cover the facility would be $1.5...
What are the similarities and differences between injection molding, metal injection molding, and ceramic injection molding?
Is Gary targeting a vulnerable market?
In September 2013, Ugo Mattera entered into a written construction contract with Baja Properties, LLC. Stephen Chad Golden, the sole owner of Baja Properties, signed the contract and addendums on...
Oscars Red Carpet Store maintains a checking account with Academy Bank. Oscars sells carpet each day but makes bank deposits only once per week. The following provides information from the companys...
Question 3.1 Create a class containing a method name createArray and a main method. The method createArray creates an array where each element contains the square of its index. The size of the array...
The slender rod AB of negligible weight is attached to two 10-lb blocks A and B that can move freely in the guides shown. Knowing that the constant of the springs is 1 lb/in. and that the unstretched...
Discuss a scenario in which a contract dispute could impact the employer/employee relationship. Give details of the scenario, the contract, the parties involved, and how the relationship is impacted.
In January 2017, UK retailer Tesco bought the wholesaler Booker. Why would they do this?
Diff Eyewear is a successful business built around a socially conscious mission. The company makes and sells stylish eyewear with comparable quality but a significantly lower price than luxury...
Local marketing is an effective tool used by marketers to reach intended market segments. Groupon has capitalized on this concept by tailoring brands and marketing to the needs and wants of local...
In a survey by brand strategy firm Lippincott, the most trusted brand in consumer electronics was not Apple. Nor was it Samsung, Sony, or Microsoft. It was Bose, the still relatively small, privately...
How does a French company successfully market an American version of a Korean skin beautifier under a French brand name in Australia? Ask LOral, which sells more than $30 billion worth of cosmetics,...
An agreement is reached for an American company to purchase a machine from a foreign vendor for 100,000 euros. At the time of the agreement, the exchange rate is 1.20 dollars per euro. At the time of...
Time Travel Publishing was recently organized. The company issued common stock to an attorney who provided legal services worth $25,000 to help organize the corporation. Time Travel also issued...
Bicycles arrive at a bike shop in boxes. Before they can be sold, they must be unpacked, assembled, and tuned (lubricated, adjusted, etc.). Based on past experience, the shop manager makes the...
Breakfast cereal manufacturers publish nutrition information on each box of their product. As we saw in Chapter 16, there is a long history of cereals being associated with nutrition. Heres a...
Do movies of different types have different rates of return on their budgets? Heres a scatterplot of Gross Revenue in US ($M) vs. Budget ($M) for recent movies whose MPAA Rating is either PG (blue)...
Oxford Corporation began operations in 2015 and reported pretax financial income of 225,000 for the year. Oxfords tax depreciation exceeded its book depreciation by 40,000. Oxfords tax rate for 2015...
At December 31, 2015, Suffolk Corporation had an estimated warranty liability of 105,000 for accounting purposes and 0 for tax purposes. (The warranty costs are not deductible until paid.) The...
State whether each of the following events will result in a movement along General Motors (GMs) demand curve for labor in their U.S. automobile factories or whether it will cause its demand curve for...