Question: The Lockit Company manufactures door knobs for residential homes and apartments. Lockit is considering the use of simple (single-driver) and multiple regression analyses to forecast

The Lockit Company manufactures door knobs for residential homes and apartments. Lockit is considering the use of simple (single-driver) and multiple regression analyses to forecast annual sales because previous forecasts have been inaccurate. The new sales forecast will be used to initiate the budgeting process and to identify more completely the underlying process that generates sales. Larry Husky, the controller of Lockit, has considered many possible independent variables and equations to predict sales and has narrowed his choices to four equations. Husky used annual observations from 20 prior years to estimate each of the four equations. Following are a definition of the variables used in the four equations and a statistical summary of these equations:

St = Forecasted sales in dollars for Lockit in period t

St–1 = Actual sales in dollars for Lockit in period t – 1

Gt = Forecasted U.S. gross domestic product in period t

Gt–1 = Actual U.S. gross domestic product in period t – 1

Nt–1 = Lockit's net income in period t – 1


Required:

1. Write Equations 2 and 4 in the form Y = a + bx.

2. If actual sales are $1,500,000 in 2009, what would be the forecasted sales for Lockit in 2010?

3. Explain why Larry Husky might prefer Equation 3 to Equation 2.

4. Explain the advantages and disadvantages of using Equation 4 to forecast sales.


The Lockit Company manufactures door knobs for residential homes


Statistical Summary of Four Equations Dependent Independent Independent Standard Equation Variable Variable(s) Itercept Variable (Rate) Eror R Squan t Value S 500,000 1.10 $500,000 94 5.50 510,000 0.90 10.00 520,000 0.8 5.00 G. 1,000,000 0.00001 0.000012 900,000 600,000 4 490,000 0.96 10.00 0.000002 0.000003 4.00 1.50 3.00

Step by Step Solution

3.46 Rating (162 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock

1 Equation 2 S t 1000000 000001 G t Equation 4 S t 600000 1... View full answer

blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Document Format (1 attachment)

Word file Icon

101-B-M-A-C-B (492).docx

120 KBs Word File

Students Have Also Explored These Related Managerial Accounting Questions!