Preview

Foescasting Checkpoint

Satisfactory Essays
Open Document
Open Document
807 Words
Grammar
Grammar
Plagiarism
Plagiarism
Writing
Writing
Score
Score
Foescasting Checkpoint
CheckPoint: 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

Given:
Last Forecast (LF) = $6,300,000 Last Data (LD) = $6,750,000 α = 0.95
I used the 0.95 alpha because I strongly believe that the new forecast will be based on the last data.

NF = LF + α (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 = 4,625,000
Variable = 500,000
R-Square = 0.95

Y = 4,625,000 + 500,000X
20X5 = 4,625,000 + 500,000 (5)
20X5 = 4,625,000 + 2,500,000
20X5

You May Also Find These Documents Helpful

  • Satisfactory Essays

    ECO 550 Midterm Exam

    • 454 Words
    • 3 Pages

    2. The use of quarterly data to develop the forecasting model Yt = a +bYt−1 is an example of which forecasting technique?…

    • 454 Words
    • 3 Pages
    Satisfactory Essays
  • Satisfactory Essays

    Hsm 260 Case Study

    • 361 Words
    • 2 Pages

    Weighted moving averages and moving averages, just use the data for the past three fiscal years. This would look like this…

    • 361 Words
    • 2 Pages
    Satisfactory Essays
  • Satisfactory Essays

    Nt1330 Project 4

    • 395 Words
    • 2 Pages

    4. Go back to the data. Time Series Analysis/ Exponential Smoothing. Use alpha of .7.…

    • 395 Words
    • 2 Pages
    Satisfactory Essays
  • Satisfactory Essays

    Hsm/260 Week 5 Checkpoint

    • 376 Words
    • 2 Pages

    The following data represent total personnel expenses for the Palmdale Human Service Agency for past four fiscal years:…

    • 376 Words
    • 2 Pages
    Satisfactory Essays
  • Good Essays

    By forecasting Proforma statements are created to predict balances at a certain date followed by combining them with a financial statement format. Acquiring the forces that influence them, one can determined how account balances are forecasted and project how the accounts may be influenced. The following is used to illustrate the ProForma’s five year projection process for XYZ’s Company.…

    • 558 Words
    • 2 Pages
    Good Essays
  • Satisfactory Essays

    Refer to the University of Phoenix Material: Venture Budgeting and Forecasting Paper located on the student website.…

    • 390 Words
    • 2 Pages
    Satisfactory Essays
  • Satisfactory Essays

    Assignment1

    • 837 Words
    • 3 Pages

    2. In the Weekly Budget Forecast section of the spreadsheet calculate each revenue item and each expense item for the week as well as the Total Revenue, Total Expenses, Profit, Profit Margin, and Breakeven Quantity. All of these must be calculated and must contain cell references to the inputs and…

    • 837 Words
    • 3 Pages
    Satisfactory Essays
  • Good Essays

    Tanglewood Case 2

    • 712 Words
    • 3 Pages

    Based on the environmental scan, it has been concluded that Tanglewood may have a hard time filling their vacancies in the future. Even though the unemployment rate in the area is high, recent forecasts suggest that expansion in the professional and managerial sectors of the labor market may reduce the number of individuals available for these jobs. Since Tanglewood only promotes from within, the entry level position of store associates does not appeal to many applicants. College graduates with management degrees are hesitant to start at a low position and work their way up. Many want the managerial position without putting in the work.…

    • 712 Words
    • 3 Pages
    Good Essays
  • Good Essays

    Descriptive statistics is provided for each row and column, such as totals, row percent and column percent of the total. Inferential statistics includes procedures that allow one to draw conclusion or inference from data. For a human service agency choosing the appropriate web-based statistical program will be migrated from storage to the interface on the website. With free web-based statistics program a human service agency data can be saved in a word processing document, in a spreadsheet, or in a database. However, one disadvantage with free web-based statistical procedures cannot store data. Therefore, if a human service agency needs to produce data, a staff member of the agencies would need to reprocess the data for reanalyzes and reenter the data. Using a free web-based statistical procedure has it benefits. For example, there are several website that offer descriptive and inferential statistic for a human service agency. Next, many of the website contains information about the statistical procedures, which is a help to a human service agency. Finally, data can be copied and pasted into reports and other…

    • 656 Words
    • 3 Pages
    Good Essays
  • Satisfactory Essays

    Project Statement Year | 0 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | Sales | | 950,000 | 1,500,000 | 1,500,000 | 1,500,000 | 1,500,000 | 1,500,000 | 1,500,000 | 1,500,000 | Direct Cost55% of sales(Sales * 55% = DC) | | 522,500 | 825,000 | 825,000 | 825,000 | 825,000 | 825,000 | 825,000 | 825,000 | Indirect Incremental Costs | | 80,000 | 80,000 | 80,000 | 80,000 | 80,000 | 80,000 | 80,000 | 80,000 |…

    • 474 Words
    • 2 Pages
    Satisfactory Essays
  • Satisfactory Essays

    Checkpoint: Signals

    • 324 Words
    • 2 Pages

    Include a description comparing the differences between a private branch exchange (PBX) and Voice over Internet protocol (VoIP).…

    • 324 Words
    • 2 Pages
    Satisfactory Essays
  • Good Essays

    What is your opinion of the technological tools provided by Axia College, including audio appendixes, digital stories, and tutorials? Why do you feel this way?…

    • 331 Words
    • 2 Pages
    Good Essays
  • Satisfactory Essays

    A specific business requirement like detailed financial or managerial reporting would most definitely drive the need for the creation of a new system. When an old and outdated system performs at less than par, and does not meet the specific requirements of the business, it becomes more of a burden to the company than a helpful tool. An outdated system that does not meet requirements can slow business production to a crawl. For every detailed report necessary for the business to run, an alternative must be conceived. This consists of long man-hours being squandered to come up with an alternative retrieval method, or even worse, having to manually retrieve data and create reports. This senseless waste of company funds, productivity, and time creates drive to purchase or create a new system that is able to produce financial and managerial reports. These reports are vital to the sustainability of the company. They are used to gage progress on a monthly, quarterly, and annual basis. The information contained in the reports give executives and managers that needed informational edge when making important decisions, setting department and company goals, and reviewing processes to make necessary changes. Overall, having a system than can handle the needs and specific requirements of the business using it, is a must. This will save time, money, and the entire company from failure in some cases. A system that can produce the necessary financial and managerial reports along with any other needed information, will increase productivity across all departments, and create a positive atmosphere in the company because the employees will have the tools needed to accomplish the required tasks. A company that is willing to spend the necessary funds upfront to acquire a system of this caliber will save much more money in the…

    • 391 Words
    • 2 Pages
    Satisfactory Essays
  • Good Essays

    The company needs to create a training budget for the following year at the end of each year according to the forecast of future needs and the feedback of the past year. In order to make the budget more precise, not only do the headquarter controls the overall budget, but also each regional or district manager…

    • 434 Words
    • 2 Pages
    Good Essays
  • Good Essays

    Cost Driver

    • 568 Words
    • 3 Pages

    |Salaries/benefits of staff members who | |Time required of staff member |Hours spent by the staff member on each program / total hours worked by |…

    • 568 Words
    • 3 Pages
    Good Essays