Solved: Calculate regression equation for preceding demand data, Basic Statistics

+44 141 628 6080
[email protected]

Calculate regression equation for preceding demand data

Historical demand for a product is:

DEMAND
January    12
February   11
March 15
April         12
May          16
June         15

a. Using a weighted moving average with weights of 0.60, 0.30, and 0.10, find the July forecast.

b. Using a simple three-month moving average, find the July forecast.

c. Using single exponential smoothing with α = 0.2 and a June forecast = 13, find the July forecast. Make whatever assumptions you wish.

d. Using simple linear regression analysis, calculate the regression equation for the preceding demand data.

e. Using the regression equation in d, calculate the forecast for July.

View Complete Question

Solution Preview :

Prepared by a verified Expert

Basic Statistics: Calculate regression equation for preceding demand data

Reference No:- TGS01740160

Now Priced at $20 (50% Discount)

Recommended (98%)

Rated (4.3/5)

Have a Question? (oR Write a Review)

Write atleast 100 words!!

Recent Questions Asked Basic Statistics

Q : Compute basic earnings per share-diluted earnings per share

There were no changes during 2004 in the number of common shares, preferred shares, or convertible bonds outstanding. There is no treasury stock. Instructions: (a) Compute basic earnings per share for 2004. (b) Compute diluted earnings per share fo

Q : Journal entries to record the treasury stock transactions

(a) Prepare the journal entries to record the treasury stock transactions in 2004, assuming Jodz uses the cost method. (b) Prepare the stockholders' equity section as of April 30, 2004. Net income for the first 4 months of 2004 was $110,000.

Q : Transactions in general journal form for sun orthopedic

Record the following selected transactions in general journal form for Sun Orthopedic Clinic, Inc. Include a brief explanation of the transaction as part of each journal entry.

Q : Net income of department store

Why is Simon taking this action? Is her action ethical? Give your reason, identifying the parties helped and the parties harmed by Simon's action.

Q : Calculate regression equation for preceding demand data

Using simple linear regression analysis, calculate the regression equation for the preceding demand data. Using the regression equation in d, calculate the forecast for July.

Q : Depreciation expense-insurance expense-interest payable

Prepare the adjusting entries at March 31, assuming that adjusting entries are made quarterly. Additional accounts are: Depreciation Expense, Insurance Expense, Interest Payable, and Supplies Expense.

Q : Service revenue-accounts receivable-interest expense

Use the following account titles: Service Revenue, Accounts Receivable, Interest Expense, Interest Payable, Salaries Expense, and Salaries Payable.

Q : Zero balances in accumulated depreciation

At the end of its first year, the trial balance of Easton Company shows Equipment $30,000 and zero balances in Accumulated Depreciation Equipment and Depreciation Expense. Depreciation for the year is estimated to be $6,000.

Q : Write-off method to account for uncollected accounts

If Elburn uses the direct write-off method to account for uncollected accounts, journalize the adjusting entry at December 31, assuming Elburn determines that Copp's $1,400 balance is uncollected.

1926071

Questions
Asked

3,689

Active Tutors

1420443

Questions
Answered

Start Excelling in your courses, Ask a tutor for help and get answers for your problems !!

ask Question

Solution Preview :

Prepared by a verified Expert

Basic Statistics: Calculate regression equation for preceding demand data

Reference No:- TGS01740160

Have a Question? (oR Write a Review)

Recent Questions Asked Basic Statistics

Q : Compute basic earnings per share-diluted earnings per share

Q : Journal entries to record the treasury stock transactions

Q : Transactions in general journal form for sun orthopedic

Q : Net income of department store

Q : Calculate regression equation for preceding demand data

Q : Depreciation expense-insurance expense-interest payable

Q : Service revenue-accounts receivable-interest expense

Q : Zero balances in accumulated depreciation

Q : Write-off method to account for uncollected accounts

Discuss three ethical guidelines that are important

How ensure that the youth understand what study involves

How teenagers in an impoverished urban area spend their time

Discuss social worker working with foster children

How we perceive objects in the real world

Discussion about the nature versus nurture

Provide reasons why working from a person centred

Solution Preview :

Prepared by a verified Expert

Basic Statistics: Calculate regression equation for preceding demand data

Reference No:- TGS01740160

Recent Questions Asked Basic Statistics

Q : Compute basic earnings per share-diluted earnings per share

Q : Journal entries to record the treasury stock transactions

Q : Transactions in general journal form for sun orthopedic

Q : Net income of department store

Q : Calculate regression equation for preceding demand data

Q : Depreciation expense-insurance expense-interest payable

Q : Service revenue-accounts receivable-interest expense

Q : Zero balances in accumulated depreciation

Q : Write-off method to account for uncollected accounts

Asked Questions