Business, 29.01.2021 17:30, haleyllevsen

The demand for toys produced by the Miki Manufacturing Company has been collected in the Microsoft Excel Online file below. Use the Microsoft Excel Online file below to develop simple linear regression forecast and answer the following questions. Simple Linear Regression Forecast
Period Actual Demand Forecast Formulas
1 1,600 #N/A
2 2,000 #N/A
3 1,800 #N/A
4 1,200 #N/A
5 2,300 #N/A
6 3,600 #N/A
7 3,300 #N/A
8 3,200 #N/A
9 4,000 #N/A
10 4,900 #N/A
11 4,500 #N/A
12 4,400 #N/A
13 #N/A
Intercept #N/A
Slope #N/A
1. What is the trend line? Round your answers to two decimal places. Do not round intermediate calculations.
2. Calculate the linear trend forecast for the periods from 1 to 13. Round your answers to the nearest whole number. Use unrounded intercept and slope values.
Period Forecast
1
2
3
4
5
6
7
8
9
10
11
12
13

Answers: 1

Show answers

Other questions on the subject: Business

Business, 22.06.2019 13:30, starlodgb1971

Tom has brought $150,000 from his pension to a new job where his employer will match 401(k) contributions dollar for dollar. each year he contributes $3,000. after seven years, how much money would tom have in his 401(k)?

Answers: 3

continue

Business, 22.06.2019 15:40, aroman4511

Rachel died in 2014 and her executor is finalizing her estate tax return. the executor has determined that rachel’s adjusted gross estate is $10,120,000 and that her estate is entitled to a charitable deduction in the amount of $500,000. using 2014 rates, calculate the estate tax liability for rachel’s estate.

Answers: 1

continue

Business, 22.06.2019 17:50, hinokayleen5053

Which of the following is an element of inventory holding costs? a. material handling costs b. investment costs c. housing costs d. pilferage, scrap, and obsolescence e. all of the above are elements of inventory holding costs.

Answers: 1

continue

Business, 22.06.2019 20:20, Hi123the

Garcia industries has sales of $200,000 and accounts receivable of $18,500, and it gives its customers 25 days to pay. the industry average dso is 27 days, based on a 365-day year. if the company changes its credit and collection policy sufficiently to cause its dso to fall to the industry average, and if it earns 8.0% on any cash freed-up by this change, how would that affect its net income, assuming other things are held constant? a. $241.45b. $254.16c. $267.54d. $281.62e. $296.44

Answers: 2

continue

Do you know the correct answer?

The demand for toys produced by the Miki Manufacturing Company has been collected in the Microsoft E...