Lost Sales Forecast Essay

Words: 2493

Pages: 10

Open Document

TERM- PAPER

Lost Sales Forecast

Table of Contents

Introduction 3
Carlson Department Store Sales data for September 1992 through August 1996 4
Countywide Department Stores Sales data for September 1992 through August 1996 5
Choosing the appropriate forecasting method 6
Trend and Seasonal Components in Forecasting 7
An estimate of lost sales for the Carlson Department Store 10
Conclusion 10

Introduction

The Carlson Department Store suffered heavy damage when a hurricane struck on August 31, 1996. The store was closed for four months (September 1996 through December 1996) causing our sales drop to $0. The task of this report is to analyze sales in …show more content…
Choosing the appropriate forecasting method

There are many different forecasting methods. One of the challenges we had to face was to choose the right technique. Smoothing methods are appropriate for a stable time series. When a time series consist of random fluctuations around a long-term trend line, a linear equation may be used to estimate the trend. When seasonal effects are present, seasonal indexes can be computed and used to deseasonalize the data and to develop forecasts. When both seasonal and long-term trend effects are present, which is also the case of Carlson Department Store as well as the case of all department stores in the county, a trend line is fitted to the deseasonalized data; the seasonal indexes are then used to adjust the trend projections.

Trend and Seasonal Components in Forecasting

The procedure of forecasting the sales for months September through December 1996 (had there been no hurricane) for The Carlson Department Store is summarized in Table 3.

Table 3: Procedure of forecasting sales for Sep.-Dec. 1996
| | |Sales |12-month |Centered |Seasonal |Deseasonalized |
| | | |Moving |Moving |Irregular |Sales |
| | | |Average |Average |Value | |
|1992 |Sept. |1.71 |- |- |-

Leitax Essays

camera delayed (cost: $19.5 million), another outsold its inventory (costs: $4.5million) and a third model reported sluggish sales ($2.5million). To compensate, Leitax extended the life of an existing model and made a mad scramble to find product and customers but the most costumers preferred to wait for the delayed camera. These…

Words 1973 - Pages 8

Supply Chain Simulation Results Report

miss-interpreting the “good” data can cause errors in the plan. In the case of this Supply Chain simulation, at least one of us miss-understood that we were given two years of historical data…including lost product data based upon a production and shipping plan. Miss-understanding that data lost time in having the opportunity to digest the data that we had! Another aspect of miss-understanding that data was that we didn’t realize that we had the option of NOT doing anything to our production or…

Words 660 - Pages 3

Standard Deviation and Seduced Anita Daphne Essay

10,000 units before show  Commit 10,000 units after show  Minimum of 600 units A First Approach  Ignore differences in  Profit margins  Salvage values  Ignore minimum lot sizes  Consider only first order cycle Sample Problem Style Mean Forecast Std Deviation in Demand Gail 1,017 388 Isis 1,042 646 Entice 1,358 496 Assault 2,525 680 Teri 1,100 762 Electra 2,150 807 Stephanie 1,113 1,048 Seduced 4,017 1,113 Anita 3,296 2,094 Daphne 2,383 1,394 Normal Distribution 0.45 0.4 0.35 0.3 0…

Words 887 - Pages 4

Essay about Value Line

Shareholders appear to have lost confidence that Home Depot can maintain its profit-and-growth trajectory. Some evidence of the company’s faltering performance lies in its lower existing-store growth. Given the magnitude of Home Depot’s retail space, investors may question the ability…

Words 2695 - Pages 11

Lawn King Case

Lawn King has a sales problem. Based on feedback from its best customers, it is apparent that Lawn King has missed out on some potential sales given a lack of inventory during months with peak demand. This lack of inventory results in back-order timelines that customers find unacceptable or cumbersome causing them to look for alternatives. Lawn King must come up with an aggregate plan for operations which will serve have the right amount of inventory on hand given the seasonal cycles of demand…

Words 1238 - Pages 5

Explain How Marketing Managers Position Products In The Target Market

organizational (business) markets. 4.Know how to develop a market-product grid to identify a target market and recommend resulting actions. 5.Explain how marketing managers position products in the marketplace. 6.Describe three approaches to developing a sales forecast for a company. © 2011 McGraw-Hill Ryerson Ltd. All rights reserved. Market Segmentation, Targeting, and Positioning ‣ Had a good night sleep lately? ‣ 73 percent of people sleep on their side ‣ 22 percent sleep on their back ‣ 5 percent sleep…

Words 907 - Pages 4

Bullwhip Effect in Supply Chain Essay

demand, between expected and actual delivery time, and unforeseen emergencies. From a positive standpoint, safety stock can help to potentially reduce stock out situations however is also contributes to the bullwhip effect. Specifically with demand forecast updating using exponential smoothing, ordering of safety stock will create larger swings for suppliers and even move for orders placed to the manufacturer (Lee, p 95). Furthermore, poorly ordered safety stock that becomes excess or obsolete can lead…

Words 2391 - Pages 10

How To Write A Business Plan For Barilla

inventory and distribution costs. Brando Vitali, Barilla’s ex-Director of Logistics, had proposed a Just-In-Time Distribution (JITD) system to resolve this demand variation. This system required the distributors to share their sales data with Barilla, who would then forecast and deliver appropriate amounts of products to the distributors at the right time in order to effectively meet demand. This system is a totally different concept than they presently have. This was a total change from the current…

Words 1510 - Pages 7

Inventory and Rim Jaber Essay

Operations Management Aggregate Planning Chapter 13 1 Outline  The Planning Process  Sales and Operations Planning (S&OP)  The Nature of Aggregate Planning  Aggregate Planning Strategies  Capacity Options  Demand Options 2  Mixing Options to Develop a Plan Outline – Continued  Methods for Aggregate Planning  Graphical Methods  Mathematical Approaches  Comparison of Aggregate Planning Methods  Aggregate Planning in Services  Restaurants, Hospitals, National Chains of Small Service…

Words 1802 - Pages 8

FSA notes Essay example

effect of the diversification, horizontal and vertical integration? Lecture 3: Accounting Analysis • Accounting analysis - evaluate how well accounting captures business reality. Look at: o Accounting rules & choices– introduce noise and bias o Forecast errors – conservatism and difficult to predict • Manipulation usually involves either bringing income forward or banking it for the future • Usually accounting manipulation done in the year end accounts. Also during: o Management change -…

Words 2247 - Pages 9