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
accurate.

Any help would be greatly appreciated. Thank you.

Purchase this Solution
Solution Summary

Forecasting for personal computers and printers sold.

Solution provided by:
Robert Reinhart, MBA
Education
  • 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.

View More Free Quizzes
Related BrainMass Solutions

  • Variable Cost/Fixed Costs

    It has considered the implications from the marketing and financial perspectives and estimates fixed costs to be $500,000. Variable costs are estimated at $200 per unit produced and sold: A.

  • Analyzing elasticities of demand

    It implies any increase in price of computer will decrease the demand for Dell laptop computers and vice versa. So, Dell laptop computers and printers are complements to each other.

  • Developing forecast models for demand

    It stocks a range of items including textbooks, trade books, logo apparel, drawing and educational supplies, and computers and related products including printers, modems, and software.

  • Business in Law Firms

    The desktop computers, servers, printers and notebook computers may actually be sold to repay the debt the company has incurred. In this case there can be a contractual agreement that is secured by a security interest in the items purchased.

  • Cash rebates: sound business practices? Ethical? What percentage are actually paid?

    Printers are an excellent example of a business where cash rebates are very useful. The printers themselves are sold as cheaply as possible to lock customers into purchasing proprietary supplies.

  • Break-even and Other CVP Analysis

    Problem 4: Slick Pads is a company that manufactures laptop notebook computers. It likes to add its own line of computers printers as well.

  • Forecasting sales

    178607 Forecasting of sales Please submit in the excel document. 1. The owner of a computer store rents printers to some of her preferred customers.

  • Bankruptcy

    In this some asset of the company and in this case the computers, printers, notebook computers and servers are pledged to the bank.

  • Capital Budgeting

    Please see attached document (2-6) Forecasting and Valuing Cash Flows 2-6) CT Computers is considering whether or not to begin offering customers the option to have their old personal computers recycled when they purchase a recycling system.

View More Related Solutions