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

  Evaluate what aldos should expect for total variable cost

Evaluate what Aldo's should expect for total variable cost if 9,000 T-shirts are sold next month and prepare Aldo's contribution approach income statement for monthly sales volume level of 10,000 T-shirts.

  Standard mileage method

Jan receives no reimbursement from her employer. Jan has an AGI for year of $50,000 and no other itemized deductions.

  What amount of the proceeds from the issuance should

The market value of each detachable warrant was quoted at $25. What amount, if any, of the proceeds from the issuance should be accounted for as part of Gordon's stockholders' equity?

  Equity cost of capital

When measuring the cost of capital, many companies measure the cost of the common stock in the company. However, does common stock have a cost when there is no obligation to pay the stockholders except upon liquidation of the company?

  Used to offset passive activity income

Passive activity losses generally can only be used to offset passive activity income. However in certain circumstances activities that would generally be considered a passive activity may not be subject to the passive activity loss rules. What will t..

  Savings obtained by elevating present equipment-labor cost

The management of a private hospital is considering the installation of an automatic telephone switchboard, which would replace a manual switchboard and eliminate the attendant operator's position the class of service provided by the new equipment, i..

  What proportion of the population would score higher

what proportion of the population would score higher than Bob and what proportion of commutes would be longer than 80 minutes and less than 50 minutes?

  What is its profit margin

Franklin Bedding, Inc. has assets of $400,000 and turns over its assets 1.5 times per year. Return on assets is 12 percent. What is its profit margin (return on sales)?

  Prepare a pension worksheet the pension worksheet

Prepare a pension worksheet. On the pension worksheet, compute pension expense, pension asset/liability, projected benefit obligation, plan assets, prior service cost, and net gain or loss.

  Provide necessary journal entries to record transactions

Provide the necessary journal entries to record the transactions for Wilcox for the period January 2, 2011 through December 31, 2012.

  Illustrate what is the market rate of return on this stock

The firm has established a pattern of increasing its dividends by 3 percent annually and expects to continue doing so. Illustrate what is the market rate of return on this stock?

  Journal entry on partners books for the acquisition

Purpose the journal entry on Partner's books for the acquisition of Sizemic Corporation's net assets.

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