Develop a forecast of enrolment beginning

Assignment Help Financial Accounting
Reference no: EM133026977

Question - Suppose that the Perpetual Help College of Rizal had the following record of its growth of enrollment from 2011 -2020.

Year

Enrolment

Year

Enrolment

2011

5,200

2016

7,000

2012

5,500

2017

8,800

2013

6,000

2018

9,400

2014

6,500

2019

9,600

2015

6,800

2020

10,500

Required -

a) Develop a forecast of enrolment beginning 2014 to 2021 using 3-years moving average forecast model.

b) Using weights of .50 for the most recent data, .30 to the second recent data, and .20 to the 3 months old data, develop a forecast beginning 2014 to 2021 using 3 years weighted moving average forecast model.

c) Using exponential smoothing and smoothing constant of .30 and 2011 previous forecast of 5200, develop a forecast of enrolment from 2012 to 2021.

d) Forecast enrollment using Trend line Projection from 2011 to 2021.

e) Evaluate forecast accuracy of each forecast model using MSE. Which model should you recommend?

Reference no: EM133026977

Questions Cloud

Positive outcomes of delegation : In management what are some of the positive outcomes of delegation or advantages? Also, what are some of the key objectives in determining when to delegate work
Prepare sterling december year-end adjusting entry : Prepare Sterling's December 31 year-end adjusting entry to report its stock investments with insignificant influence at fair value
How much is the cost of the consigned goods : Finland Company consigned goods costing P100,000 to France Inc. Markup on consigned goods is 35% on cost. How much is the cost of the consigned goods
Employees paycheque without employee permission : 1) Which of the following may an employer deduct from an employee's paycheque without the employee's permission?
Develop a forecast of enrolment beginning : Develop a forecast of enrolment beginning 2014 to 2021 using 3-years moving average forecast model
Information weighed the heaviest in decision : You are newly hired FedEx employee. Based on what you know about FedEx and its competitors, would you sign a card to certify a union at FedEx?
Malaysia employment act 1955 : Mary has been working with an organisation for two years. She is now pregnant and want to know her benefits and entitlements.
Significant aspects of hidden patterns of success : What are the significant aspects of hidden patterns of success?
Which investment option is considered an independent project : The company can also recruit professional outsiders by offering attractive salary packages. Which investment option is considered an independent project

Reviews

Write a Review

Financial Accounting Questions & Answers

  Evaluate total variable cost per dozen pretzelsevaluate

evaluate total variable cost per dozen pretzelsevaluate sales price per dozen pretzels using 120 markup on variable

  What amount will the evanston company report

The Evanston Company acquired a 25% interest in Straw Enterprises for $8,000,000 and appropriately applied the equity method. During the first year, Straw reported net income of $1,060,000 and paid cash dividends totaling $100,000. What amount will T..

  Beginning inventory in mixing processing center consisted

Jolly Company uses the FIFO method in its process costing system. Beginning inventory in the mixing processing center consisted of 4,500 units, 75% complete with respect to conversion costs. Ending work in process inventory consisted of 3,500 units, ..

  What is the net realizable value of accounts receivable

It estimated that 10% of its accounts receivable would prove uncollectible. What is the net realizable value of accounts receivable?

  What is the net present value on the incremental cash flow

The XYZ Corporation is considering opening an office in a new market area that would allow it to increase its annual sales by $1.5 million. What is the net present value from opening the office building under the assumption that the corporation lease..

  How do calculate interest income

How do you calculate interest income? What is the journal entry when you receive interest from the Accounts Receivable related transactions.

  Code of professional conduct

Locate the AICPA's Code of Professional Conduct. Assume that you are a CPA in public practice. Explain how tihis Code affects your practice. Be sure to cite the sections which you are referencing.

  Prepare a balance sheet on the basis of trial balance

Can the financial positions of the two firms be compared assuming that the two firms fall in the same industry - analytical covering the syllabus till Analysis of Financial Statements.

  Cumulative effect of this accounting change

At the beginning of 2007, a decision was made to change to the straight-line method of depreciation for this machine. Assuming a 30% tax rate, the cumulative effect of this accounting change, net of tax is?

  Explain how these have an impact on the breakeven

explain how these have an impact on the breakeven (contribution margin, fixed costs, a combination, variable costs, etc.), and what happens if these factors increase or decrease.

  What would be the post-closing trial balance total

Conner Corporation's adjusted trial balance included the items. What would be the post-closing trial balance total? (Show work for partial credit)

  Prepare a classified balance sheet for the year ended

Flip Company's December 31, 2014 trial balance is as follows: Flip Corporation Trial Balance December 31, 2014 Account Debit Credit Cash $43,500 Accounts Receivable 54,500 Allowance for Doubtful Accounts 500 Notes Receivable 30,000 Merchandise Invent..

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd