Question

The Municipal Government has asked you to forecast the sales tax revenue it will collect in...

The Municipal Government has asked you to forecast the sales tax revenue it will collect in 2017, 2018 and 2019. Data on revenue in recent years is presented below.

Year

Q1

Q2

Q3

Q4

TOTAL

2012

         695

         788

         809

      1,302

$3,594

2013

         896

         941

      1,018

      1,677

$4,532

2014

      1,037

         929

      1,353

      2,090

$5,409

2015

      1,067

      1,081

      1,574

      2,143

$5,865

2016

      1,147

      1,161

      1,683

      2,372

$6,362

*In thousands

You see an upward trend in the data, and you decide to try the moving average method or regression models to develop your forecast.

a. Estimate annual sales tax revenue for 2017, 2018 and 2019 using a moving average “3-day” (MA3) model. Please clearly show the process you use to come up with your estimates. (5 points)

b. Estimate annual sales tax revenue for 2017, 2018 and 2019 using a moving average “4-day” (MA4) model. Please clearly show the process you use to come up with your estimates. (5 points)

c. Using one of the methods, forecast the quarterly sales tax revenue for 2017. Clearly show the process you use to come up with your estimates. (Hint: consider average or moving average by quarter, or ratio / percent.) (5 points)

Homework Answers

Answer #1
a. Estimate of annual sales tax revenue for 2017, 2018 and 2019 using
“3-day” (MA3) model
2014 5409
2015 5865
2016 6363
2017 5879 (5409+5865+6363)/3
2018 6036 (5865+6363+5879)/3
2019 6093 (6363+5879+6036)/3
b.Estimate of annual sales tax revenue for 2017, 2018 and 2019 using
“4-day” (MA4) model
2013 4532
2014 5409
2015 5865
2016 6363
2017 5542 (4532+5409+5865+6363)/4
2018 5795 (5409+5865+6363+5542)/4
2019 5891 (5865+6363+5542+5795)/4
c. Forecast the quarterly sales tax revenue for 201forecast the quarterly sales tax revenue for 2017
Moving average by Quarter Workings
2016 Q2 1161
Q3 1683
Q4 2372
2017 Q1 1739 (1161+1683+2372)/3
Q2 1931 (1683+2372+1739)/3
Q3 2014 (2372+1739+1931)/3
Q4 1895 (1739+1931+2014)/3
Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
States that rely on sales tax for revenue to fund​ education, public​ safety, and other programs...
States that rely on sales tax for revenue to fund​ education, public​ safety, and other programs often end up with budget surpluses during economic growth periods​ (when people spend more on consumer​ goods) and budget deficits during recessions​ (when people spend less on consumer​ goods).50 small retailers in a state with a growing economy were recently sampled. The sample showed a mean increase of ​$323 in additional sales tax revenue collected per retailer compared to the previous quarter. The sample...
Year Quarter Sales (in Billions) 2009 1 2.62 2009 2 2.33 2009 3 2.4 2009 4...
Year Quarter Sales (in Billions) 2009 1 2.62 2009 2 2.33 2009 3 2.4 2009 4 2.42 2010 1 2.72 2010 2 2.53 2010 3 2.61 2010 4 2.84 2011 1 2.95 2011 2 2.79 2011 3 2.93 2011 4 3.03 2012 1 3.44 2012 2 3.2 2012 3 3.3 2012 4 3.36 2013 1 3.79 2013 2 3.56 2013 3 3.74 2013 4 3.8 2014 1 4.24 2014 2 3.87 2014 3 4.15 2014 4 4.18 2015 1 4.8...
YOU MUST SHOW ALL CALCULATIONS TO EARN CREDIT.                                    
YOU MUST SHOW ALL CALCULATIONS TO EARN CREDIT.                                                                                     2017                            2018 BALANCE SHEETS: Assets:                         Cash                                                    74,181                         66,301                         Accounts Receivable                          35,673                         48,995                         Inventory                                            4,855                           3,986                         Other Current Assets                          13,936                         12,057                         Fixed Assets, net                                 33,783                         41,304                         Investments                                         212,891                       233,082                         Total Assets                                        375,319                       405,725 Liabilities and Equity:                         Accounts Payable                              ...
REQUIREMENTS:   1)    Sales Budget   2)    Production Budget Budgets should be for the individual three (3) months of the...
REQUIREMENTS:   1)    Sales Budget   2)    Production Budget Budgets should be for the individual three (3) months of the first quarter of 2019. Include a quarterly total column on the right side. Each budget/requirement should be in a separate tab within one spreadsheet. All pages should be in portrait format using the same font. Use proper rounding and show two (2) decimal places of accuracy on dollar amounts. Round up and show whole amounts on all other figures. (Hint) Excel provides functions for...
Prepare, in good form, a Sales Budget, and Production Budget. Please show work. I am just...
Prepare, in good form, a Sales Budget, and Production Budget. Please show work. I am just trying to make sure I have the correct answers. Balance Sheet Bottas Manufacturing, Inc. Balance Sheet December 31, 2018 ASSETS Cash $           25,711.00 Marketable securities                20,000.00 Accounts receivable             565,844.43 Inventories:    Finished goods $           86,385.60    Work in process                          0.00    Direct materials                  7,193.94                93,579.54 Total Current Assets             705,134.97 Property, plant and equipment $         844,200.00    Less: Accumulated...
Asia’s e-commerce landscape has been booming in recent years. The swift adoption of smartphones and greater...
Asia’s e-commerce landscape has been booming in recent years. The swift adoption of smartphones and greater access to the internet has allowed consumers in the region to be a major force in the global digital economy. The expansion looks set to continue at a rapid pace. According to a November 2018 report by Fitch Solutions, e-commerce sales in the region are forecast to increase by 14.2% this year, with an estimated average annual increase of 14% over the medium term...
CASE STUDY – Jacobson Carpet Company In January 2002, Ms. Mary Lewis was preparing to meet...
CASE STUDY – Jacobson Carpet Company In January 2002, Ms. Mary Lewis was preparing to meet with Mr. Carpenter, President of Jacobson Carpet Company. Ms. Lewis assumed that the meeting was related to the recent Board of directors of the company. As a direct assistant to the President, she knew from experience that this type of meeting often resulted in a project to be studied. Her expectation was confirmed as soon as Mr. Carpenter began to inform her of the...
Wal-Mart Online Wal-Mart is one of the largest companies in America. It is definitely the largest...
Wal-Mart Online Wal-Mart is one of the largest companies in America. It is definitely the largest retailer, both in terms of the number of stores (8,970 worldwide in 2011) and the level of sales ($419 billion from the 2011 Annual Report). By pushing suppliers to continually reduce costs, Wal-Mart is known for pursuing low prices and the stores often attract customers solely in-terested in lower prices. With Wal-Mart’s expansion into groceries, the company has be-come the largest retail grocer in...
Please read the article and answear about questions. Determining the Value of the Business After you...
Please read the article and answear about questions. Determining the Value of the Business After you have completed a thorough and exacting investigation, you need to analyze all the infor- mation you have gathered. This is the time to consult with your business, financial, and legal advis- ers to arrive at an estimate of the value of the business. Outside advisers are impartial and are more likely to see the bad things about the business than are you. You should...
Please answer the following Case analysis questions 1-How is New Balance performing compared to its primary...
Please answer the following Case analysis questions 1-How is New Balance performing compared to its primary rivals? How will the acquisition of Reebok by Adidas impact the structure of the athletic shoe industry? Is this likely to be favorable or unfavorable for New Balance? 2- What issues does New Balance management need to address? 3-What recommendations would you make to New Balance Management? What does New Balance need to do to continue to be successful? Should management continue to invest...
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT