A major souce of revenue in Texas is the state sales tax on certain goods and services. The state comptroller compiles these data and uses them to project future revenues for the state budget. One particular category of goods is classified as Retail Trade. The file below contains four years of quarterly data for one particular city in southeast Texas: Texas Sales Tax Use these data to project the sales tax collected for the next 4 quarters using optimized parameters. What is your forecast for 2014 Q1? O a. 357.7 O b.303.1 O c. 305.1 O d. 271.7 O e. none of the above

Practical Management Science
6th Edition
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:WINSTON, Wayne L.
Chapter2: Introduction To Spreadsheet Modeling
Section: Chapter Questions
Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...
icon
Related questions
Question

If possible, use R. Studio....

C
1
1 Year-Qtr SalesTax
2 2010 Q1
215
3 2010 Q2
246
4 2010 Q3
245
5 2010 Q4
290
6 2011 Q1
227
7 2011 Q2
253
8 2011 Q3
256
9 2011 Q4
297
10 2012 Q1
236
11 2012 Q2
266
12 2012 Q3
265
13 2012 04
325
14 2013 Q1
249
15 2013 Q2
284
16 2013 Q3
291
17 2013 04
358
著
Transcribed Image Text:C 1 1 Year-Qtr SalesTax 2 2010 Q1 215 3 2010 Q2 246 4 2010 Q3 245 5 2010 Q4 290 6 2011 Q1 227 7 2011 Q2 253 8 2011 Q3 256 9 2011 Q4 297 10 2012 Q1 236 11 2012 Q2 266 12 2012 Q3 265 13 2012 04 325 14 2013 Q1 249 15 2013 Q2 284 16 2013 Q3 291 17 2013 04 358 著
A major souce of revenue in Texas is the state sales tax on certain goods and services. The state comptroller compiles these data and
uses them to project future revenues for the state budget. One particular category of goods is classified as Retail Trade. The file below
contains four years of quarterly data for one particular city in southeast Texas:
Texas Sales Tax
Use these data to project the sales tax collected for the next 4 quarters using optimized parameters. What is your forecast for 2014 Q1?
O a. 357.7
O b.303.1
O c. 305.1
O d. 271.7
O e. none of the above
Transcribed Image Text:A major souce of revenue in Texas is the state sales tax on certain goods and services. The state comptroller compiles these data and uses them to project future revenues for the state budget. One particular category of goods is classified as Retail Trade. The file below contains four years of quarterly data for one particular city in southeast Texas: Texas Sales Tax Use these data to project the sales tax collected for the next 4 quarters using optimized parameters. What is your forecast for 2014 Q1? O a. 357.7 O b.303.1 O c. 305.1 O d. 271.7 O e. none of the above
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps with 1 images

Blurred answer
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Practical Management Science
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,
Operations Management
Operations Management
Operations Management
ISBN:
9781259667473
Author:
William J Stevenson
Publisher:
McGraw-Hill Education
Operations and Supply Chain Management (Mcgraw-hi…
Operations and Supply Chain Management (Mcgraw-hi…
Operations Management
ISBN:
9781259666100
Author:
F. Robert Jacobs, Richard B Chase
Publisher:
McGraw-Hill Education
Business in Action
Business in Action
Operations Management
ISBN:
9780135198100
Author:
BOVEE
Publisher:
PEARSON CO
Purchasing and Supply Chain Management
Purchasing and Supply Chain Management
Operations Management
ISBN:
9781285869681
Author:
Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson
Publisher:
Cengage Learning
Production and Operations Analysis, Seventh Editi…
Production and Operations Analysis, Seventh Editi…
Operations Management
ISBN:
9781478623069
Author:
Steven Nahmias, Tava Lennon Olsen
Publisher:
Waveland Press, Inc.