Free Essay

Forecasting

In:

Submitted By stilldabadest
Words 1846
Pages 8
,

DEPARTMENT OF THE TR£ASURY
INTERNAL REVENUE SERVICE WASHINGTON, DC 20224
OFFice OF CHIEF COUNSEL

UiLC No.: 280A.06"()()

CC:ITA:2:MEBrookens COR-117177-00 March 19,2001 MEMORANDUM fOR MR. MICHAEL PERLMUITER LEAD CUSTOMER SERVICE REPRESENTATIVE ACCOUNTS MANAGEM£NT DIVISION III, GROUP S140 JACKSONVILLE, fL FROM: Heather C. Maloy Associate Chief Counsel (Income Tax & Accounting) Section 280A{c)(o)

SUBJECT:

This technical assistance memorandum responds to your inquiry concerning the effect of § 280A(.cX6) of the Internal Revenue Code on the deductibility by an individual taxpayer of expenses attributabie to the rental of a portion of a dwelling unit to his employer. The employer is an S corporation of which the empfoyee is the sole shareholder and sole employee. During the period of the rental the individual used the rented portion in performing services as an employee. The individual atso used the dwelling unit as a principal residence. Our discussion supplements previous oral advice we have given you on this subject. Your inquiry was prompted by an individual described above who was concerned because he could not find a place on the applicable forms -to claim 'Certain business expenses and depreciation attributable to the rental income. You asked for guidaooe concerning the appropriate form(s) to use in reporting the rental income and deductions. Please note that technical assistance <foes not relate to a specific -case and is not binding on audit or appeals offices. This document may not be cited as precedent. ISSUE: How should an individual who rents a portion of his.cfwelling uoiHo his employer and who uses the dwelling .unit in performing services as an..employee of that employer treat the ecpenses attributable to the rental of the -dwelling unit?

PMTA:00431

2
COR-117177-00

CONCLUSION: The individual described above may deduct home mortgage interest, Peal pr.operty taxes, and personal casualty losses to the extent permitted by §§ 163, 1'64, and 165(c)(3) and (h). However, the individual may not dedtlct other'Wfse aHowable trade or business expenses under § 162, business casualty losses under § 165(~)(1), or depreciation under § 167, to the extent those expenses and losses are attributable to the use by the employee of the dwelling unit in performing servioe~ for the employer. OVERVIEW: In general, § 280A applies to individuals who use their homes both for personal purposes and for the production of trade or business income. The section is designed both to insure that the business use of the home does not result in an inappropriate conversion of nondeductible personal, living, and family expenses into deductible expenses and to permit the deduction of legitimate business expenses incurred in using the home to earn income. Section 280A(a) generally disallows otherwise allowable deductions with respect to the business use of an individual's residence. However, § 280A{b) provides an exception to that disallowance rule by providing that § 280A{a) "shall not apply to any deduction allowable to the taxpayer without regard to its connection with his tra6e-Qr business {or with his income-producing activity)." In other wor{is, § 280A(b) provides that if an individual who uses his home entirely for personal purposes 'Could take a 1Ieduction related to that personal use, he may also take the deduction if he uses the home both for personal purposes and to carry 'On trade or business activities. Thus, '§ 280A(a) and (b), taken togettier, permit an individual who pays home mortgage interest e>Epense and state and local real property taxes to deduct those payments - if the rule'S found in §§ 163(h) and 164(a)(1) are met - regardless of whether that individual uses his residence solely for personal purposes or for both personal and business pUr:poses.1 Deductions for the business use of a home are potentially available only if the use faits into one of the four categories listed in § 2.BOA{c)(1) - L4). Those categories ar.e, respectively, specified home office uses {§ 280A(c)(1 ){A), {B), and ~-c)), sk>rage of inventory or product samples in the home (§ 280A{c)(2)), rental of the property

However, although the aggregate amount 'Of deductible home mortgage interest, real property taxes, and personal ~asualty Josses is not affected -by partial business use of the home, those -deductions must be allocated between business and personal use of the home to -prevent cir-cumvention of the gross income limitation <ur deduction limit) of"§ 2-8OA{c)('5).
1

..

3
COR-117177-00 (§ 280A(c)(3», and use of the home in providing day-care services {~200A(cX4». In general, the business expenses associated with those uses are deductible <>nly if the individual's business use of the home is r:egular (rather than occasional or incidental), and only to the extent the income earned from the business use of the home equals or exceeds the business expenses. Section 280A further requires both that expenses-be reasonably allocated between business and personal use and that expenses be ta+cen in a specified order. In addition to these general rules, particular rules apply to some of the business uses listed above. Publication 587, Business Use of Your Home (2000) contains a detailed description of the various § 280A rules. DISCUSSION: Your questions involve a corporate employee whose receipt of business income and whose incurring of business expenses relate to three of the § 280A~c) business uses listed above: the (c)(1)(A) and (B) home offICe use and the (c)(3) rental use. For ease of discussion, we will refer to two hypothetical employees - E-1 and E-2 - both of whom use part of their homes (but not a separate structure detached from the dwelling unit) in performing services for their employers and both of whom are the sole shareholders of their S corporations. Assume the following additional facts concerning these hypothetical employees: (1) E-1 receives a reasonable salary from her employer (includible in her gross income under § 61(a)(1» and seeks to claim a home offICe deduction. (2) E-2 receives a reasonable rent from his employer (includible in his gross income under § 61(a){4» and seeks to deduct business expenses related k> that rental. To claim a home office ded.uction, E-1 must satisfy both the general requirements of § 280A and the particular requirements of § 280A(c)(1)(A) or (c)(1)(B). Specifically, under § 280A(c)(1), € - 1 must show that she used her home office exclusively and regularly either as (A) her principal place of business in her trade or business of being an employee, or as (B) a place of business in which she meets or deals with patients, clients, or customers in the normal course of her business. In additton, E-1 must show that her exclusive use of the home office is for the convenience of her employer. Assuming E-1 can meet the general and specifIC rules <>f § 200A, she should -calculate her home offICe expense deduction by using the worksheet contained in Pub. 587. Such expenses are generally claimed on various lines of Schedule A, F<>rm 1.Q40 (2000). Pages 1'6 - 17 of Pub. 587 (2000) contain an example of how the expenses are calculated and reported and .pr<>vide inf<>rmation about additional fOfms which E-1 may be required in some circumstances to .prepare and file.

4
COR-117177"()() However, because E-2 is receiving rental rather than salary income fFOm his employer, E-2 will not be allowed to deduct business expenses attributable to the rental income. This result comes about not because it is more difficult to satisfy the rental use tests than the home office use tests -- indeed, ordinarily the opposite is true 2 -- but because of the particular disallowance rule of § 280A(c)(6). Section 280A(c)(6) was added to the Code in 1986 by § 143(b) of P.L. 99-514, 100 Stat. 2120, 1986-3 C.B. (Vol. 1) 37. Section 280A(cX6) pr()vides that: Treatment of rental to employer. Paragraphs [c](1) and [c](3) shall not apply to any item which is attributable to the rental of the dwelling unit ~or any portion thereof) by the taxpayer to his employer during any period in which the taxpayer uses the dwelling unit (or portion) in performing services as an employee of the employer. E-2 falls squarely within § 280A(c)(6), because E-2 is both renting to his employer (Y Co.) and using the rented portion of his dwelling unit to perform services as an Y Co. employee. Accordingly, § 280A(c)(6) will bar E-2 from deducting otherwise allowable § 162 trade or business expenses, § 165(c)(1) business casualty losses, and § 167 depreciation. That statutory bar, in turn, explains why there is no place on the forms to deduct those expenses. Congress added § 280A(c)(6) expressly to overturn the Tax Court's decision in Feldman v. Commissioner, 84 T.C. 1 (1985), aff'd, 791 F.2d 781 {9 th Cir. 1966). The taxpayer in Feldman, an employee, shareholder, and managing director of an accounting firm, not only had an office at the firm, but received an above-market rental payment from the firm to maintain an offIce (and related garage space) in his home. Because his home office did not meet the requirements of § 280A{c)(1), the taxpayer could not have claimed business expenses relating to its use. Despite the government's argument that the "lease" agreement in fact represented disguised compensation, however, the courts permitted the taxpayer to claim offsetting rental expenses under§ 2eOA(c)(3). In enacting § 280A(c)(6), Congress observed that the Tax Court's imerpretation of § 280A in Feldman could lead to the circumvention of statutory restrictions on the deduction of home offICe expenses. In particular, Congress was concerned that: (1) employers and employees could arrange sham transactions {whereby a portion of salary was paid in the form of rent), and {2) the employer-empioyee transactions would
2 The § 280A{{:)(3) rental use rules are usually easier for an tndividual to satisfy than are the (c)(1) home offICe use rutes, because the {c)(3) rules do notrontain the requirement of exclusive use found in the {c){1) rules.





t

~

5
COR-117177-00
not be negotiated at arm's length but would provide added tax deductions for the employee at no additional cost to the employer. Accordingly, Congress provided that no home offICe deductions were allowable (other than expenses such as home mortgage interest and real estate taxes that are deductible absent business use) jf the employee rents a portion of his or her home to the employer. H.R. No. 99-426, 1986-3 C.B. (Vol. 2) 133. It should be noted, however, that although § 280A applies to S corporations as well as to individuals, the only taxpayer to whom § 280A(c)(6) refers is the employee. Thus, for example, an S corporation's deduction under § 1ti2 for rent is not affected by § 280A{c)(6). We hope this memorandum is helpful. If you have further questions, please contact Ms. Marilyn E. Brookens at (202) 622-4920.

Similar Documents

Premium Essay

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 forecasting...

Words: 1639 - Pages: 7

Premium Essay

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 environment...

Words: 510 - Pages: 3

Premium Essay

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 example...

Words: 17426 - Pages: 70

Premium Essay

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 Series ...

Words: 630 - Pages: 3

Premium Essay

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 comprehensive...

Words: 684 - Pages: 3

Premium Essay

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

Free Essay

Forecasting

...Forecasting Why forecast? Features Common to all Forecasts • Conditions in the past will continue in the future • Rarely perfect • Forecasts for groups tend to be more accurate than forecasts for individuals • Forecast accuracy declines as time horizon increases Elements of a Good Forecast • Timely • Accurate • Reliable (should work consistently) • Forecast expressed in meaningful units • Communicated in writing • Simple to understand and use Steps in Forecasting Process • Determine purpose of the forecast • Establish a time horizon • Select forecasting technique • Gather and analyze the appropriate data • Prepare the forecast • Monitor the forecast Types of Forecasts • Qualitative o Judgment and opinion o Sales force o Consumer surveys o Delphi technique • Quantitative o Regression and Correlation (associative) o Time series Forecasts Based on Time Series Data • What is Time Series? • Components (behavior) of Time Series data o Trend o Cycle o Seasonal o Irregular o Random variations Naïve Methods Naïve Forecast – uses a single previous value of a time series as the basis of a forecast. [pic] Techniques for Averaging • What is the purpose of averaging? • Common Averaging Techniques ...

Words: 1209 - Pages: 5

Free Essay

Forecasting

...Forecasting LANCELOT PALMER HSM/260 July 5, 2015 Florence Wisn Forecasting 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 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. Forecast personnel expenses for fiscal year 20X5 using moving averages, weighted moving averages, exponential smoothing, and time series regression. Moving Averages Fiscal Year Expenses 20X2 $5,500,000 20X3 $6,000,000 20X4 $6,750,000 20X2-4 $18,250,000 20X5 $18,250,000/3 = $6,083,333 Weighted Averages Fiscal Year Expenses Weight Weighted Score 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 ...

Words: 908 - Pages: 4

Free Essay

Forecasting

...Forecasting Methods and Forecast Modeling Sources of Forecasting Errors Although larger samples improve forecasting precision, samples may be limited if older data are unavailable or not comparable. Data collected more frequently increases sample size but may not add much information. Because forecast inferences cannot be based on future data, extrapolation of past relationships results in an unknown amount of bias, especially if (1) explanatory variables move outside their historical range (2) some variables no longer are important while others become important (3) variable coefficients change substantially or switch signs Conditional forecasting occurs when one or more explanatory variables must be guessed because their values not known with certainty for the period forecast. Unconditional forecasting occurs when the future values of all explanatory variables are known with certainty. In conditional forecasting, errors may be huge because we first must forecast values of the explanatory variables. Only unconditional forecasts are free of these errors. Contingency forecasting involves generating several forecasts, one for each alternative set of circumstances, or "scenario," that is likely to arise. The estimation period is the time series data used to fit a forecasting model. Ex post forecasting involves "forecasting" the most recent observations after withholding them from the estimation period. By contrast, ex ante forecasting uses an estimation period...

Words: 477 - Pages: 2

Premium Essay

Forecasting

...Forecasting is described as, “the art and science of predicting future events” (Heizer, Render, & Griffen, 2014). It’s used a planning tool that helps management cope with the uncertainty of the future. Forecasting has many purposes within businesses and the purpose will vary depending on what type of organization you’re running or working for. Forecasting includes many different types of techniques that have the ability to give detailed information about future measurements, challenges of future events, and the changes in the environment. It can also analyze present data and effective planning in both the short run and the long run fully depends on the forecasts established for the company’s products. Forecasting gives confidence in those making important decisions due to the relevant and reliable information predicted. Forecasting may involve the use of historical data through mathematical equations to track future trends, which is known as quantitative forecasts. Quantitative methods of forecasting falls into two categories, the Time Series Models such as Naïve Approach, Moving Averages and Exponential Smoothing as well as the Associative Model that includes Trend Projection and Linear Regression. Forecasting may also be used in a more subjective or intuitive prediction if historical data is not present, which is known as qualitative forecasts. This category of forecasting involves four specific techniques used, Jury of executive opinion, Delphi Method, Sales Force Composite...

Words: 832 - Pages: 4

Premium Essay

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

Premium Essay

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. There are...

Words: 551 - Pages: 3

Free Essay

Forecasting

... $5,500,000 20X3 $6,000,000 20X4 $6,750,000 20X2-4 $18,250,000 20X5 $18,250,000/3 = $6,083,333 Weighted Expenses: Fiscal Year Expenses Weight Weighted Score 20X2 $5,500,000 x 1 = $5,500,000 20X3 $6,000,000 x 2 = $12,000,000 20X4 $6,750,000 x 3 = $20,250,000 6 $37,750,000 20X5 $37,750,000/6 = $6,291,667 Exponential Smoothing: Given The last forecasting (LF) = $6,300,000, the last data (LD) = $6,750,000, a = 0.95 I have used the 0.95 alpha because I believe the new forecast will be based on the last data. NF = LF + a (LD – LF) NF= $6,300,000 + 0.95 ($6,750,000 - $6,300,000) NF = $6,300,000 + 0.95 ($450,000) NF = $6,300,000 + $427,500 NF = $6,727,500 20X5 = $6,727,500 Time Series Regression: Computer Output Constant = 4625000 Variable = 500000 R-Square = 0.95 Y = A + BX Y = $462,500 + $500,000X Y = $462,500 + $500,000 (5) Y = $462,500 + $2,500,000 Y = $7,125,000 20X5 = $7,125,000 I choose to use the time series regression because it reveals that the expenses will continue to grow on 20X5 and the years after 20X5. Exercise 9.3 Moving Expenses: Fiscal Year Expenses ...

Words: 453 - Pages: 2

Free Essay

Forecasting

...Individual Week Two Practice Problems Resources: MyMathLab® Complete the Week Two Practice Problems in MyMathLab®. 04/25/2013 4 Individual Week Two Quiz Resources: MyMathLab® Complete the Week Two Quiz in MyMathLab®. 04/26/2013 3 Learning Team Inventory Systems Summary The purpose of this assignment is to prepare for subsequent assignments in this course. Research one inventory system per team member used in an organization with which you are familiar. (e.g. perpetual, periodic, FIFO, LIFO) Collect four years of inventory data from each organization. If you are not abel to find data, you may also use the University of Phoenix Material: Summer Historical Inventory Data or University of Phoenix Material: Winter Historical Inventory Data. Collaborate as a team to compare the inventory systems. Write a summary which includes: • 250- to 350-word description of each inventory system. • 350- to 700-word comparison describing the advantages and disadvantages of each system. Format your summary consistent with APA guidelines. 04/23/2013 5 Week Three: Visual Representation of Quantities Details Due Points Objectives 3.1 Construct histograms and bivariate plots. 3.2 Determine the value of a slope by using the slope-intercept formula. 3.3 Conduct a linear regression analysis. 04/30/2013 N/A Readings Read Ch. 6 & 9 of Quantitative Reasoning for Business. Read Topics 2–3 & 5 of Quantitative Reasoning. 04/30/2013 N/A In-Class Exercises 1. In-Class Team Exercise ...

Words: 534 - Pages: 3

Free Essay

Forecasting

...Complete the following case study and problems and submit the results in either a Microsoft Word document or a Microsoft Excel spreadsheet. If you choose to use an Excel spreadsheet, place each problem on a separate sheet and label the tab with problem number. Save your document with a descriptive file name, including the assignment and your name. | Chapter 4: * North-South Airline Case Study: In January 2008, Northern Airlines merged with Southeast Airlines . . . 3-1 Data collected on the yearly demand for 50-pound bags of fertilizer at Wallace Garden Supply are shown in the following table. Year Demand for fertilizer (1,000s of bags) 1 4 2 6 3 4 4 5 5 10 6 9 7 10 8 11 9 15 10 16 11 18 a. Develop a 3-year moving average to forecast sales. b. Then estimate demand again with a weighted moving average in which sales in the most recent year are given a weight of 3 and a weight of 2 for the second past year and sales in the other 2 years are each given a weight of 1. c. Which method do you think is best? In this case, the 3 year moving average is the better method as the Mean Absolute Deviation (MAD) is only 3.042 as compared to 3.347 for the weighted moving average method. What it actually means is that each forecast missed the actual value by 3.042 units instead of 3.347 units. d. Develop a trend line for the demand for fertilizer using any computer software. e. You have now developed...

Words: 837 - Pages: 4