Compute seasonal indices for each quarter based on a cma

Assignment Help Financial Accounting
Reference no: EM13867292

A major source of revenue in Texas is a state sales tax on certain types of goods and services. Data are compiled and the state comptroller uses them to project future revenues for the state budget. One particular category of goods is classified as Retail Trade. Four years of quarterly data (in $millions) for one particular area of southeast Texas follow:

Quarter

Year 1

Year 2

Year 3

Year 4

1

218

225

234

250

2

244

254

265

283

3

243

255

264

289

4

298

301

334

362

a. Compute seasonal indices for each quarter based on a CMA.

b. Deseasonalize the data and develop a trend line on the deseasonalized data.

c. Use the trend line to forecast the sales for each quarter of year 5.

d. Use the seasonal indices to adjust the forecasts found in part (c) to obtain the final forecasts.

Reference no: EM13867292

Questions Cloud

Will the network be peer to peer or server based? : Will the network be peer to peer or server based?
What topology used in the manufacturing area to solve : What topology and which type of device can be used in the manufacturing area to solve the cabling difficulties?
What strategies were used to start the profile : For this Discussion topic, before writing about the question above, consider Wilkinson's profile essay in the e-book just as you did for the first Discussion topic this week. How was the profile started? What was done in the introduction? What strate..
Additional devices might be needed to ensure efficient : what additional devices might be needed to ensure efficient network communication? Explain.
Compute seasonal indices for each quarter based on a cma : Compute seasonal indices for each quarter based on a CMA. Deseasonalize the data and develop a trend line on the deseasonalized data.
Prepare journal entries to record each transaction : Analyze the effects of each transaction on total assets, liabilities, and stockholders equity. Prepare journal entries to record each transaction. Enter the January 1 balances into T-accounts, post the journal entries from requirement 2, and determin..
Need for reporting on program efficiency and effectiveness : Accrual accounting is not necessary in governmental financial reporting Financial reporting alone is insufficient for measuring governmental performance there is also a need for reporting on program efficiency and effectiveness.
Give an explanation using the four classification criteria. : Use the information in RE21-3. Prepare the journal entries that Richie Company (the lessor) would make in the first year of the lease assuming the lease is classified as a sales type lease.
Sketch two alternative alignments : Sketch two alternative alignments. Choose one alignment for your design. Justify. Locate your alignment considering both vertical and horizontal controls. Coordinate both horizontal and vertical alignments.

Reviews

Write a Review

Financial Accounting Questions & Answers

  Prepare the journal entries for the transactions

Purchased a new piece of equipment for $75,000 signing a six month, 7% note payable. Received an invoice for their telephones for $375.00 that will be paid next month. Purchased 400 shares of Treasury stock at $7.00 per share. Prepare the journal ent..

  Town of dex recreation center construction balance sheet

How would these capital expenditures for recreation center appear on the Town of Dex's government-wide statements of net activities and assets and prepare journal entries to record preceding information in Town of Dex Recreation Center Construction ..

  What should be the carrying value of sullivan inventory

What should be the carrying value of Sullivan's inventory if the company prepares its financial statements according to International Financial Reporting Standards?

  What if you borrowed to invest a total

What would happen to the expected value and standard deviation of the investment if you borrowed an additional $1,000 and invested a total of $2,000? What if you borrowed $2,000 to invest a total of $3,000?

  Use the minus sign to enter favorable variances

Why are the standard amounts in part (1) based on the actual production for the year instead of the planned production for the year?

  What is the nominal dollar amount of your last withdrawal

What is the nominal dollar amount of your last withdrawal? (Do not round intermediate calculations and round your final answer to 2 decimal places and what is the HPY on your investment?

  Determine the weighted-average contribution margin

Cargo, Inc., has two products: Product D (unit sales price, $25; unit variable cost, $15) and Product J (unit sales price, $14; unit variable cost, $9). The company’s sales mix of Product D to Product J is 4:1 and fixed costs are $32,850. Determine t..

  Elucidate which accounting principle requires marian

Elucidate which accounting principle requires Marian to keep her personal financial information separate from the financial information of Mosely Accounting Services

  Determine the minimum transfer price

Evaluate the effect on Rapid Industries' operating profit if the transfer is made internally? Consider the 50,000 units Austin requires are either purchased 100% internally or 100% externally.

  Evaluate the internal rate of return

Calculate the payback period, calculate the Net Present Value and calculate the Internal Rate of Return.

  What is the amount of interest herman must pay bondholders

Herman uses the straight-line method of amortization. What is the amount of interest Herman must pay the bondholders in 2011?

  Income statement showing the byproduct as a cost reduction

income statement showing the byproduct as a cost reduction during production.the maryland company prepares lumber for

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