Preview

Sales Forecast in a Foundry Fab- a Linear Time Series Approach

Powerful Essays
Open Document
Open Document
2598 Words
Grammar
Grammar
Plagiarism
Plagiarism
Writing
Writing
Score
Score
Sales Forecast in a Foundry Fab- a Linear Time Series Approach
|Sales Forecast in a Foundry Fab- A linear time series approach |
|D9516914/羅振宇 |

1. Introduction

Sales forecasting plays a crucial corporate role because it provides the basis for company-strategic decisions, including capacity preparation, inventory level, and capital expenditure budgets. Because of the uncertainty of sales forecasting errors, companies must increase costs to satisfy customer requirements and prepare a higher inventory level or capacity to avoid sales loss. Hence, sales forecasting accuracy has a considerable influence on company cost reduction.

In a foundry fab, the accuracy of sales forecasting is vital because the fab manufacturing cycle time is long, the lead time for capacity expansion requires considerable time and cost, and the capital investment is large. Therefore, sales forecasting is one of the most important jobs in a foundry fab.

Because of the importance of sales forecasting, it is crucial to establish a proper forecasting procedure to meet the accuracy requirement in a fab foundry. Hong-Sen [3] proposed that quantitative sales forecasting involves four stages: finding the main affecting factors, using the observational values of these factors within a certain period as the input of a certain regression model, determining the model parameters and structure by training, and providing forecasting results by extrapolation based on the trained model. Based on these four stages, the necessary cycles of sales forecasting include finding the affecting factors, choosing appropriate models, estimating the parameters of models with adequate methods, and evaluating the models. These four cycles are introduced in the following sections.

As the foundry fab industry is highly technological, Prior studies have

You May Also Find These Documents Helpful

  • Good Essays

    MBA 731 H1FF Brief 5

    • 597 Words
    • 2 Pages

    The marketing team creates the forecast by month for the next year. The forecast is always over inflated. They do not seem to have a scientific forecasting process. They marketing team, meets with the sales managers from the different regions to get an idea of the sales from last year. They take into account economic changes and shortages they had…

    • 597 Words
    • 2 Pages
    Good Essays
  • Good Essays

    Case Study: Nordstrom

    • 612 Words
    • 3 Pages

    According to Schermerhorn (2013), “forecasting is the ability to predict the future” (pg.123) which means that the process of forecasting can become an important tool to quantify the proper balance between supply and demand. Likewise, in order to maximize sales and its effectiveness, businesses have to work in predict the future customer demand and use this information to lead the business operations to distribution effectively. However, inaccurate forecasts happen and along with them there is a cost.…

    • 612 Words
    • 3 Pages
    Good Essays
  • Satisfactory Essays

    group15 wilkin case

    • 369 Words
    • 3 Pages

    •Lokesh Chandana FT152087 Case – Problems & Issues Problems : •To identify a forecasting technique so as to forecast the demand for existing products as well as new products. Issues : •Best fit model ?? •Problems associated with each forecasting model ?? •Performance of the used model ??…

    • 369 Words
    • 3 Pages
    Satisfactory Essays
  • Satisfactory Essays

    L.L.Bean case Study

    • 422 Words
    • 2 Pages

    2. The company determine their actual demand based on historical forecast errors. The historical forecast errors were computed for each item in the previous year and the frequency of these errors. The frequency of past forecast errors was used as a probability distribution for the future errors. For example, in the past year, if there were 50% of the forecast errors for “new” items were between 0.7 and 1.6. Then the company can assumed that the forecast errors for “new” item in the current year also would be between 0.7 and 1.6 with the possibility 50%. If the frozen forecast for an item is 1000 units, we can assume that with the probability 50%, the actual demand of the item would fall between 700 and 1600 units.…

    • 422 Words
    • 2 Pages
    Satisfactory Essays
  • Powerful Essays

    The heart of the sales forecasting system is the point-of-sale sys¬tem (FOS), which, in effect, captures transaction data on nearly every person who walks through a cafe's door. The sale of each entree repre¬sents one customer; the entrée sales data are…

    • 725 Words
    • 3 Pages
    Powerful Essays
  • Good Essays

    Walgreen's Billing Error

    • 681 Words
    • 3 Pages

    Forecasting is a preparation tool that helps a company figure out what might happen in the future; and to do so, the company will primarily rely on data from both the past and present to figure out possible trends. Forecasts can be made in short term, medium term or long term. When it comes to forecasting it is important for a company to look at all possible factors including fluctuation of prices and the market, possible declines in the economy, technological errors and so much more. In 2014 the well known pharmaceutical company Walgreens prepared to forecast the companies earning up to the year 2016. However, somewhere during their process an error occurred resulting in the company suffering from a billion dollar cut.…

    • 681 Words
    • 3 Pages
    Good Essays
  • Good Essays

    Aldi Forecasting

    • 793 Words
    • 4 Pages

    Forecasting is the methodology utilized in the translation of past experiences in an estimation of the future. The German market presents challenges for forecasting techniques especially for its retail segment. Commercially oriented organizations are used to help during forecasting as general works done by academic scientists are not easy to come across (Bonner, 2009).…

    • 793 Words
    • 4 Pages
    Good Essays
  • Good Essays

    When forecasting sales in the service industry, businesses must consider several factors related to their business. For restaurants like Hard Rock Café, taking into consideration the season, holidays, time of day, day of week, time of the month in relation to paydays, and meals served is necessary for effective forecasting of sales (2). Using historical data for the year prior is also effective, however, not 100% accurate (1). Events happening in the area can also contribute to the sales forecast if considered conservatively (1). Hoffman must understand these factors directly affect sales in the restaurant. Success can be achieved by accurate forecasting and giving the customer what they want.…

    • 724 Words
    • 3 Pages
    Good Essays
  • Better Essays

    Forecasting Best Practices

    • 2091 Words
    • 9 Pages

    To find the "best practices" for forecasting, our team researched many cases of forecasting success, and found five companies with a common theme. Rayovac, the Coca-Cola Bottling Company, AAi. FosterGrant, the Sara Lee Corporation, and the Scotts Company all had major problems with forecasting, some of them very similar. To address and solve these problems each of these companies made major improvements to their forecasting systems. Although some used similar methods and others very different, these companies found that the right people, process and information technology was the key to efficient and accurate forecasting.…

    • 2091 Words
    • 9 Pages
    Better Essays
  • Good Essays

    Case 5.1

    • 602 Words
    • 2 Pages

    2. Each division requires its own specific type of forecasting method because of all of their unique circumstances. For the industrial intermediaries division, polymers and detergents each need a different method. Since the polymer intermediates sales have risen by a high number of 40% over a two year period and are unpredictable, an exponential smoothing method would be most appropriate. This method weights highest on the most recent years sales history. For the detergent intermediates, a moving average method would be most appropriate because sales have been stable overall in the past years. There is no need to give the most recent periods a higher weight of importance. For the specialty chemicals division, it would be most effective to complete an econometric model. Determining how drastically a change in the oil market would affect the sales in this division would be very helpful for the overall sales forecast. Finally, the bromine division should be forecasted using the…

    • 602 Words
    • 2 Pages
    Good Essays
  • Better Essays

    Week 4 Acc 561

    • 982 Words
    • 4 Pages

    Guillermo Furniture Store will use sales forecasting to build the company’s sales budget. The sales budget is the foundation from which the master budget is created (Horngren and et. al., 2008). According to Horngren, et. al. (2008) sales forecast is defined as, “a prediction of sales under a given set of conditions.” Forecasting sales is usually done using many different techniques. The most popular technique involves using past history to predict the future demand. A major risk with this method is the mistaken assumption that relationships driving sales demand in the past will continue into the future (Chase, 1993). Guillermo Furniture Store’s risk in using this method is that past demand has changed. Mr. Guillermo must understand what the drivers of sales demand are for his furniture now, so that he can make predictions on the future. Other risks to consider when creating the sales forecast, involve evaluating the effects of increased competition and accounting for the increased costs in labor.…

    • 982 Words
    • 4 Pages
    Better Essays
  • Good Essays

    Market Outlooks Simbrand

    • 2336 Words
    • 10 Pages

    Finally, the group’s financial officers as well as executives of the production company have emphasized the importance of accurate sales forecasts. Budgets are useless if forecasted sales are far from reality, which usually decreases the quality of decisions significantly. In addition, production facilities’ output is preliminarily planned according to the forecasts. Large adjustments required in case of poor forecasts result in increased unit costs.…

    • 2336 Words
    • 10 Pages
    Good Essays
  • Good Essays

    Related to this problem there is an another problem which forecast accountability which is not strong enough since there is no downside for salespersons for overstating forecast , and so this make some problem about planning .…

    • 1458 Words
    • 6 Pages
    Good Essays
  • Powerful Essays

    Forecasting Techniques

    • 19309 Words
    • 78 Pages

    Every manager would like to know exact nature of future events to accordingly take action or plan his action when sufficient time is in hand to implement the plan. The effectiveness of his plan depends upon the level of accuracy with which future events are known to him. But every manager plans for future irrespective of the fact whether future events are exactly known or not. That implies, he does try to forecast future to the best of his Ability, Judgment and Experience. Virtually all management decisions depend on forecasts. Managers study sales forecasts, for example, to take decisions on working capital needs, the size of the work force, inventory levels, the scheduling of production runs, the location of facilities, the amount of advertising and sales promotion, the need to change prices, and many other problems. For our purpose forecasting can be defined as attempting to predict the future by using qualitative or quantitative methods. In an informal way, forecasting is an integral part of all human activity, but from the business point of view increasing attention is being given to formal forecasting systems which are…

    • 19309 Words
    • 78 Pages
    Powerful Essays
  • Powerful Essays

    BDM A2

    • 5186 Words
    • 36 Pages

    This report was set up in order to provide the knowledge about decision making in a business. In business world, it is essential for manager to set up an operating plan for their company. They need to know where they are aiming to. To do so, they need to know different way of forecasting method. This report provides the information about three main ways to forecast the sale: the additive method, the multiplicative method and the least square method. It illustrates the way to use this method and also suggest which method is efficiency and could give the best forecasting. Besides forecasting, managers also need to know the important of Management Information System (MIS) to business nowadays as well as the different type of information system. From that, they can apply the suitable information to their department. Only forecasting is not enough. A manager also needs to know how to create a…

    • 5186 Words
    • 36 Pages
    Powerful Essays