Accounting and Forecasting

In: Business and Management

Submitted By whymenow
Words 615
Pages 3
Micro Chip Computer Corporation
Consolidated Statements of Operations For the period September 26, 2007 through September 25, 2008 Sales

Sales $8,334.00
Cost of Sales $5,458.00
Gross Margin $2,876.00
Operating expenses:
R & D $525.00
Selling, General, and Administrative $691.00
In-process R & D ---------
Restructuring costs ---------
Total Operating Exp $1,216.00
Operating income $1,660.00
Total interest and other Income net $194.00
Income before provision for Income taxes $1,854.00
Provision for income Taxes (15%) $278.10
Net income $1,575.90

Answer questions 1 and 2 below based on the financial data.
1. Determine the year-to-year percentage annual growth in total net sales.
2. Based only on your answers to question #1, do you think the company will hit its sales goal of +10% annual revenue growth in 2009? Determine the target revenue figure, and explain why you do or do not feel that the company can hit this target.

1. Determine the year-to-year percentage annual growth in total net sales.
|Micro Chip Computer Corporation |
|Fiscal Years |2008 |2007 |2006 |2005 |2004 |
|Net Sales |$8,334 |$6,141 |$9,181 |$11,933 |$11,062 |
|% Change |35.71% |-33.11% |-23.06% |7.87% | |

*To calculate Percentage Change, the following formula is used: [pic][pic][pic][pic] 2. Based only on your answers to question #1, do you think the company will hit its sales goal of +10% annual revenue growth in 2009? Determine the target revenue figure, and explain…...

Similar Documents

Forecasting

...Introduction Forecasting is a difficult task, no matter if it involves a weather forecast or forecasting the potential of a local small business all the way up to large international corporations. Forecasting, on the basis of an inventory, is formed by statistical data of previous months, years and seasons. Patterns will emerge, allowing a company to be able to determine how to handle on hand inventories which will allow them to keep overhead costs low while still allowing customers maximum access to goods and products. Predicting future needs on the basis of history should give a company a good foundation, but at the end of the day, depending on the industry, it would be counterproductive to solely base judgement on the past. Market fluctuations, change in the value of the dollar and the desires of the consumers may be impossible to judge yet directly affect inventories and profits. Rite Aid has over 4,700 retail pharmacies throughout the country. To simplify the inventory data, a chart has been constructed to indicate the average inventory value of a pharmacy over the course of an entire year. Year 2012 2011 2010 2009 Inventory $3,138.455 $3,158,145 $3,164,239 $3,184,531 The dollar amounts listed for each year represent the average amount, in dollars, of inventory kept at each of the approximately 4,700 stores. Having stated this fact, it is important to recognize that with all statistical data, it must be noted that some stores will have......

Words: 1057 - Pages: 5

Forecastings

...Forecasting Methods Genius forecasting - This method is based on a combination of intuition, insight, and luck. Psychics and crystal ball readers are the most extreme case of genius forecasting. Their forecasts are based exclusively on intuition. Science fiction writers have sometimes described new technologies with uncanny accuracy. There are many examples where men and women have been remarkable successful at predicting the future. There are also many examples of wrong forecasts. The weakness in genius forecasting is that its impossible to recognize a good forecast until the forecast has come to pass. Some psychic individuals are capable of producing consistently accurate forecasts. Mainstream science generally ignores this fact because the implications are simply to difficult to accept. Our current understanding of reality is not adequate to explain this phenomena. Trend extrapolation - These methods examine trends and cycles in historical data, and then use mathematical techniques to extrapolate to the future. The assumption of all these techniques is that the forces responsible for creating the past, will continue to operate in the future. This is often a valid assumption when forecasting short term horizons, but it falls short when creating medium and long term forecasts. The further out we attempt to forecast, the less certain we become of the forecast. The stability of the environment is the key factor in determining whether trend extrapolation is an appropriate......

Words: 1639 - Pages: 7

Forecasting

...Forecasting HSM/260 University of Phoenix 06/20/2013 Exercise 9.1 The following data represent total personnel expenses for the Palmdale Human Service Agency for past four fiscal years: 20X1 $5,250,000 20X2 $5,500,000 20X3 $6,000,000 20X4 $6,750,000 Forecast personnel expenses for fiscal year 20X5 using moving averages, weighted moving averages, exponential smoothing, and time series regression. For moving averages and weighted moving averages, use only the data for the past three fiscal years. For weighted moving averages, assign a value of 1 to the data for 20X2, a value of 2 to the data for 20X3, and a value of 3 to the data for 20X4. For exponential smoothing, assume that the last forecast for fiscal year 20X4 was $6,300,000. You decide on the alpha to be used for exponential smoothing. For time series regression, use the data for all four fiscal years. Which forecast will you use? Why Moving Averages Fiscal Year Expenses 20X2 $ 5,500,000 20X3 6,000,000 20X4 6,750,000 20X2-X4 6,083,333 20X5 6,083,333 = $2,277,776 3 I followed Rule 3. Older data are less important than more recent data. I decided to only go back three years so I......

Words: 707 - Pages: 3

Forecasting

...TOPIC 1. FUNDAMENTALS OF ECONOMIC FORECASTING TOPIC I TOPIC I. FUNDAMENTALS OF ECONOMIC FORECASTING   Contents 1. Meaning of forecasting 2. Features, importance and limitations of forecasting 3. Forecast types   1. Meaning of forecasting Forecast is a likely, scientifically well-grounded opinion about the possible state of the events, objects or processes in the future. Forecasting is a process of making statements about events whose actual outcomes (typically) have not yet been observed. Forecasting is a process of predicting or estimating the future based on past and present data. Economic Forecasting is a process of making forecasts based on analysis of past trends and regularities of the economic processes. Economic forecasts can be carried out at a high level of aggregation – for example for GDP, inflation, unemployment or the fiscal deficit – or at a more disaggregated level, for specific sectors of the economy or even specific companies. Economic forecasting provides information about the potential future events and their consequences for the organization. It may not reduce the complications and uncertainty of the future. However, it increases the confidence of the management to make important decisions.   Economic forecasting includes the following steps: 1. Identifying items to be forecast. The items of socio-economic forecasting are the economic processes (for example, inflation, demand, supply), any indicator describing the company activity (for......

Words: 17426 - Pages: 70

Forecasting

...FORECASTING FUNDAMENTALS Forecast: A prediction, projection, or estimate of some future activity, event, or occurrence. Types of Forecasts * Economic forecasts * Predict a variety of economic indicators, like money supply, inflation rates, interest rates, etc. * Technological forecasts * Predict rates of technological progress and innovation. * Demand forecasts * Predict the future demand for a company’s products or services. Since virtually all the operations management decisions (in both the strategic category and the tactical category) require as input a good estimate of future demand, this is the type of forecasting that is emphasized in our textbook and in this course. TYPES OF FORECASTING METHODS Qualitative methods: These types of forecasting methods are based on judgments, opinions, intuition, emotions, or personal experiences and are subjective in nature. They do not rely on any rigorous mathematical computations. Quantitative methods: These types of forecasting methods are based on mathematical (quantitative) models, and are objective in nature. They rely heavily on mathematical computations. QUALITATIVE FORECASTING METHODS Qualitative Methods ...

Words: 8098 - Pages: 33

Forecasting

...companies on a daily basis. Forecasting allows managers to plan according to future events and be prepared to use the system accordingly. With a prediction of the future managers reduce uncertainty and develop plans. The historical data is put together and analyzed to determine forecast events. All large companies use forecasting to make important strategic business decision. This helps them save costs and manage their resources effectively. A firm that is prepared for future occurences will have a healthy financial position. Forecast is of great use to a company because it affects several departments throughout the company. Some of the departments affected are: accounting and finance, marketing, operations, human resources, and information systems. Budgeting, sales, production, inventory control, capacity planning, and purchasing make use of forecasting. Accounting and finance use the data collected to estimate future costs, predict profit or loss, and identify resources available. The marketing department uses forecasting to predict prices and create promotions. The operations of a company is able to run smoothly because job schedules, production schedules, capacity planning, inventory planning, and detecting outsourcing needs are predicted ahead of time. Human resources also benefits from forecasting because seasonal or cyclical hiring is scheduled ahead of time. The company’s information systems are being monitored and revised to keep up with the forecasting results.......

Words: 551 - Pages: 3

Forecasting

...Forecasting Brandman University Operations Management September 19, 2014 Introduction Forecasting is a necessary task in the world of business, but which method works best? Now there might not be a one size fits all for forecasting, but there are methods that work best for particular situations. Throughout this paper a scenario will be picked for the qualitative and quantitative methods, this will show merits and shortcomings of both techniques and procedures. Analysis First to be examined is the qualitative method of forecasting. According to BusinessDictionary.com, the qualitative forecasting technique is defined as an “estimating method that relies on expert human judgment combined with a rating scale, instead of on hard (measurable and verifiable) data” (BusinessDictionary, 2014). In the maintenance world of the Air Force, the use of qualitative forecasting is used on a daily basis. For example, with a new fiscal year coming the upper echelon of management will be trying to predict where to allocate funds, more specifically at the base I am stationed at, Travis Air Force Base. Working directly with the Air Force Reserve I see how money is spread amongst the squadrons, which then is allocated to the flights. Working in a maintenance shop, damage airplanes are what secure funding. However, we can really predict how heavily damaged a jet will be when it rolls in, this is when qualitative forecasting comes into play. Many factor can come into play when......

Words: 653 - Pages: 3

Forecasting

...FORECASTING - a method for translating past experience into estimates of the future. Forecasting is the process of making statements about events whose actual outcomes (typically) have not yet been observed. A commonplace example might be estimation of the expected value for some variable of interest at some specified future date. Prediction is a similar, but more general term. Both might refer to formal statistical methods employing time series, cross-sectional or longitudinal data, or alternatively to less formal judgemental methods. Usage can differ between areas of application: for example in hydrology, the terms "forecast" and "forecasting" are sometimes reserved for estimates of values at certain specific future times, while the term "prediction" is used for more general estimates, such as the number of times floods will occur over a long period. Risk and uncertainty are central to forecasting and prediction; it is generally considered good practice to indicate the degree of uncertainty attaching to forecasts. The process of climate change and increasing energy prices has led to the usage of Egain Forecasting of buildings. The method uses Forecasting to reduce the energy needed to heat the building, thus reducing the emission of greenhouse gases. Forecasting is used in the practice of Customer Demand Planning in every day business forecasting for manufacturing companies. The discipline of demand planning, also sometimes referred to as supply chain forecasting, embraces...

Words: 3665 - Pages: 15

Forecasting

...4/13/2015 Forecasting ­ Research Papers ­ Hapikampr Login Join The Research Paper Factory Join Search Browse Saved Papers Search over 100,000 Essays Home Page  »  Business and Management Forecasting In: Business and Management Forecasting Forecasting HSM/260 University of Phoenix 06/20/2013 Exercise 9.1 The following data represent total personnel expenses for the Palmdale Human Service Agency for past four fiscal years: 20X1 $5,250,000 20X2 $5,500,000 20X3 $6,000,000 20X4 $6,750,000 Forecast personnel expenses for fiscal year 20X5 using moving averages, weighted moving averages, exponential smoothing, and time series regression. For moving averages and weighted moving averages, use only the data for the past three fiscal years. For weighted moving averages, assign a value of 1 to the data for 20X2, a value of 2 to the data for 20X3, and a value of 3 to the data for 20X4. For exponential smoothing, assume that the last forecast for fiscal year 20X4 was $6,300,000. You decide on the alpha to be used for exponential smoothing. For time series regression, use the data for all four fiscal years. Which forecast will you use? Why                         Moving Averages Fiscal Year                           Expenses          Please login to view the full essay... Essay's Statistics Submitted by: hapikampr Date shared: 08/07/2013 10:35 AM Words: 707 Pages: 3 20X2                                     $ 5,500,000           ......

Words: 400 - Pages: 2

Forecasting

...Forecasting Tammy Powell HSM/260 December 19, 2014 Adrianne Franklin Exercise 9.3 Moving Averages 20X2-20X4 $18,250,000 / 3 = $6,083,333 Weighted Moving Averages 20X2 $5,500,000 1 $5,500,000 20X3 $6,000,000 2 $12,000,000 20X4 $6,750,000 3 $20,250,000 __ ___________ 6 $37,750,000 20X5 $37,750,000 /6 = $6,291,667 Exponential Smoothing NF = LF + a (LD – LF) NF = $6,300,000 + 0.95($6,750,000 - $6,300,000) = $6,300,000 + 0.95(45,000) = $6,300,000 + (42,750) = $6,342,750 Exercise 9.3 Moving Averages 20X2-20X4 $41,750,000 / 3 = $13,916,667 Weighted Moving Averages 20X2 $14,250,000 1 $14,250,000 20X3 $14,000,000 2 $28,000,000 20X4 $13,500,000 3 $40,500,000 __ ___________ 6 $82,750,000 20X5 $82,750,000/6 = $13,791,667 Exponential Smoothing NF = $13,000,000 + 0.95($13,500,000 - $13,000,000) = $13,000,000 + 0.95(500,000) = $13,000,000 + (475,000) = $13,475,000 Moving averages are the easiest to do without a computer and is fast, but less accurate. Add the three most recent years, and divide by three. Weighted moving averages are simple, but require more time. The most recent year gets the highest weight. The oldest data is one and one multiplies the total. The next year is two, and two multiplies the total. The most current data weight is three, and multiplied by three. Finally, use the total of all years, and dived by...

Words: 291 - Pages: 2

Forecasting

...Forecasting is an important aspect in today’s business world. Every day businesses strive or lose, depending on the successfulness and accurateness of their forecasting. For successful forecasting, the forecaster needs to have a clear understanding of the current business activities, past trends, and the company’s business strategy. Case 5 exhibits key principles on the way financial forecasting is done. Understanding the Financial Relationships of the Business Enterprise Forecasters use current information to predict the future business activities of the company. This information is found on the financial statements of the company. For example, the balance sheet provides a snapshot of the business’ assets, liabilities and equity at a specific point in time, whereas the incomes statement provides a view of the flow of costs during a specific time frame. Financial ratios measure the relationships between various items on the financial statements. By comparing various ratios with those of previous years, trends can be identified. Because many financial ratios tend to be perserved over time, these ratios are very valuable for the forcaster. The forecaster can estimate only one financial statement line item and, by applying this number to the various ratios, he can make a complete forecast. Grounding Business Forecasts in the Reality of the Industry and Macroenvironment An accurate forecast is made by recognizing not only internal data, but also external data. The......

Words: 510 - Pages: 3

Forecasting

... Forecasting Student name Institution Forecasting Explain how forecasting is used in the real world. Provide a specific example from your own line of work, or a line of work that you find particularly interesting For humankind, the estimation of the future is a task that has to be done on a daily basis. The economic world issues the forecasting to assisting in the planning and making accurate decision concerning an economic activity. This is because resources are scarce and therefore they have to spend in the most beneficial way. Besides economic forecasting is used in the daily weather reports to determine what the weather will be. Forecasting also assist in the transport sector to schedule flights based on the said weather forecast. In the investment world, the potential investors rely heavily on the forecast concerning their intended investor form. These forecasts are usually made by the investment experts as well as the government concerning the expected behavior of the stock market as well as the financial markets. The analysis depends on the past performance to help predict the future. This data is carefully analyzed to help project into the future of the business. It is believed that the future and the past share common similarities as the future are heavily dependent on the past. However, for the investors to make accurate decisions, they must have ala the relevant information concerning the firm they are focusing on. The data has to be accurate and......

Words: 684 - Pages: 3

Forecasting

...Forecasting Accurate forecasting was the key element for our company’s success. We were able to forecast the demand and avoid overproduction. Even though all our products were stocked out at the end of the year, we did not lose much sales because the forecast was accurate and our plant utilization was maximized to the complete second shift. The pricing of the products was another major factor for our forecasting. We priced our products by looking at our sales revenue, income statement, R&D spending and the competition in each segment. Our product Cake for example, was dominating the traditional segment in the last few years. We sold almost 4000 units in 2016. We could use the revenue that generated from sales and spend portion of it on R&D. Since this product was dominating the segment and high awareness, we believe we could receive more sales if we increase the price. At the end of 2007, we sold 500 more units than the year before. However, we decreased the price of our products that are in more competitive markets. In the high end segment, we spent more R&D cost on Cid and Cid2. Cid was the segment leader, and we tried to make Cid2 a close competitor within the company. We also decreased the price since the competitors had listed lower prices for their products. By doing that, we gained more customers awareness and helped us gain more sales. When we make decision for unit sales forecast, we looked for the growth rate in each segment. This number shows......

Words: 436 - Pages: 2

Forecasting

...Between a Causal Model And a Time- Series Model? In: Business and Management Choose One Of The Forecasting Methods And Explain The Rationale Behind Using It In Real Life. What Is The Difference Between a Causal Model And a Time- Series Model? Choose one of the forecasting methods and explain the rationale behind using it in real life. I would choose to use the exponential smoothing forecast method because it weighs the most recent past data more strongly than more distant past data. This makes it so that the forecast will react more strongly to immediate changes in the data. This is good to examine when dealing with seasonal patterns and trends that may be taking place. I would find this information very useful when examining the increased production of a product that appears to be in higher demand in recent times than past. Describe how a domestic fast food chain with plans for expanding into China would be able to use a forecasting model. By looking at the data of other companies the fast food chain would be able to put together a forecast to determine if their business venture was viable. They could examine the sales data and determine through a exponential smoothing forecast if it made sense for them to enter into the market. This would show the trends and changes in the data more recently rather than in past time. What is the difference between a causal model and a time- series model? Give an example of when each would be used. The time–series model is based......

Words: 7505 - Pages: 31

Forecasting -

...What is Forecasting? Forecasting is the process of making statements about events whose actual outcomes have not yet been observed. Forecasting can be seen as a planning tool for managers to attempt to cope with the uncertainty of the future. Managers are constantly trying to predict the future, making decisions in the present that will ensure the continued success of their firms. Managers use forecasts for budgeting purposes. A forecast aids in determining volume of production, inventory needs, labor hours required, cash requirements, and financing needs. A variety of forecasting methods are available. However, consideration has to be given to cost, preparation time, accuracy, and time period. The manager must understand clearly the assumptions on which a particular forecast method is based to obtain maximum benefit. 1 Types of Forecasts Short Term Short-range forecasts typically encompass the immediate future and concern the day to day operations of a firm. A short-term forecast usually only covers a period of a few months and can be considered an “operating” forecast. Medium Term Medium-range forecasts typically span a few months up to a year. A forecast of this length can be considered “tactical” in nature. Long Term Long-range forecasts typically encompass a period longer than 1 to 2 years. These forecasts are considered strategic and are generally related to management’s attempt to plan new products or build new facilities. 2 Forecasting Methods Time......

Words: 630 - Pages: 3