Compute the exponentially smoothed forecast of calls

Assignment Help Business Management
Reference no: EM13849853

Problem 1:

Data collected on the yearly demand for 50 pound bags of fertilizer at Wallace Garden Supply are shown in the following table.

Develop a 3-year moving average to forecast sales. Then eastimate demand again with a wieghted moving average in which sales in the most recent year are given a weight of 2 and sales in the other 2 years are eac h given a wieght of 1.

which method do you think is best?

YEAR DEMAND FOR FERTILIZER 
(1,000s OF BAGS) 
1 4
2 6
3 4
4 5
5 10
6 8
7 7
8 9
9 12
10 14
11 15

Problem 2:

Sales of Cool-man air conditioners have grown steadily during the past 5 years:

YEAR   SALES 
1 450
2 495
3 518
4 563
5 584
6 ?

The sales manager had predicted, before the business started , that year 1's sales would be 410 air conditioners. Using exponential smoothing with a weight of Alpha(a) = 0.30, develop forecasts for years 2 through 6.

Problem 3:

Emergency calls to Winter Park, Florida's 911 system, for the past 24 weeks are as follows:

WEEK  CALLS  WEEK  CALLS  WEEK  CALLS 
1 50 9 35 17 55
2 35 10 20 18 40
3 25 11 15 19 35
4 40 12 40 20 60
5 45 13 55 21 75
6 35 14 35 22 50
7 20 15 25 23 40
8 30 16 55 24 65

(a) Compute the exponentially smoothed forecast of calls for each week. Assume an initial forecast of 50 calls in the first week and use Alpha(a)=0.1. What is the forecast for the 25th week?

(b) Reforecast each period using a(alpha)=0.6

Which smoothing constant provides a superior forecast?

Problem 4:

In the past, Judy Holmes's tire dealership sold an average of 1,000 radials each year. In the past two years, 200 and 250, respectively, were sold in fall, 350 and 300 in winter, 150 and 165 in spring, and 300 and 285 in summer. With a major expansion planned, judy projects sales next year to increase to 1,200 radials.

What will the demand be each season?

Reference no: EM13849853

How is walmart strategy perceived in international business

Use your information to discuss WalMart's entry strategy in different countries, their successes and their failures. How is WalMart's strategy perceived in the international b

Nine building blocks of detachable hood backpack

The idea of operating a business that deals with detachable hood backpack will be able to offer a unique experience to the customers. The detachable backpack hoods are integ

Choose an article from sage journal articles

For this assignment, choose an article from SAGE Journal Articles on www.sagepub.com/stanwick by clicking the Student Resources tab then selecting Journal Articles on the le

Recording changes in value during the measurement period

Parent Co. acquired 100% of subsidiary Co. on October 1, 2014, by paying $800,000 in cash. The price paid exceeds the fair value of the identifiable net assets by $95,000.

Learning tool and as a professional portfolio

This e-portfolio assessment is designed to be used as both a learning tool and as a professional portfolio that you can include in your resume or applications for jobs. You

The clandestine-small business management

The Clandestine is a retail business that sells personal care products to its customers. These products include soaps, lotions, bath products, etc. Customers will also be ab

Mobility of labour in the asia pacific region

The mobility of labour in the Asia Pacific region and the consequent impact on labour markets and labour conditions in host countries. Use two different countries to exempli

Environmental analysis and industry analysis

Using the Segments of the General Environment, write the environmental analysis for your organization (approximately 500-750 words). Refer to chapters 2 and 8 in the textboo

Reviews

Write a Review

 
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