Purchase Solution

Forecasting Personal Computers and Printers Sold

Not what you're looking for?

Ask Custom Question

I need some assistance in completing the following assignment:

Infoworks is a large computer discount store that sells computers and ancillary equipment and software in the town where State University is located. Infoworks has collected historical data on computer sales and printer sales for the past 10 years, as follows:

Year Personal Computers Sold Printers Sold
1 1,045 326
2 1,610 510
3 860 296
4 1,211 478
5 975 305
6 1,117 506
7 1,066 612
8 1,310 560
9 1,517 590
10 1,246 676

a. Develop a linear trend line forecast to forecast printer demand in year 11.
b. Develop a linear regression model relating printer sales to computer sales in order to forecast printer demand in year 11 if 1,300 computers are sold.
c. Compare the forecasts developed in (a) and (b) and indicate which one appears to be more

Any help would be greatly appreciated. Thank you.

Purchase this Solution

Solution Summary

Forecasting for personal computers and printers sold.

Solution provided by:
  • MBA, Merage School of Business, Univ of Cal, Irvine
  • BA, Univ of Cal, Irvine
Recent Feedback
  • "Thank you so much for your help, it was very helpful to see how you did it in excel. Thanks again!"
  • "Awesome review. Thank you!!!!!"
  • "Wow - Amazing - Thanks"
  • "Thanks"
  • "Thanks for your help. Your solution helps me understand the problem and its solution."
Purchase this Solution

Free BrainMass Quizzes
Elementary Microeconomics

This quiz reviews the basic concept of supply and demand analysis.

Economic Issues and Concepts

This quiz provides a review of the basic microeconomic concepts. Students can test their understanding of major economic issues.

Basics of Economics

Quiz will help you to review some basics of microeconomics and macroeconomics which are often not understood.

Pricing Strategies

Discussion about various pricing techniques of profit-seeking firms.

Economics, Basic Concepts, Demand-Supply-Equilibrium

The quiz tests the basic concepts of demand, supply, and equilibrium in a free market.