Purchase Solution

Projecting Monthly Computer Sales

Not what you're looking for?

Ask Custom Question

Ms. Winnie Lynn's company sells computers monthly sales for a six-month period are as follows.
January 18,000
February 22,000
March 16,000
April 18,000
May 20,000
June 24000

a.) Plot the monthly data
b.) Compute the sales forecast for July using the following approaches:
1.) 4 month moving average,
2.) A weighted three-month moving average (using .5 for June and .3 for May and .2 for April)
3.) A linear trend equation, simple exponential moving with smoothing constant equal to.4 and assuming February forecast of 18,000

c.) Which method do you think is least appropriate? Why?

Purchase this Solution
Solution Summary

The is a forecasting problem concerning a company that sells computers. Forecasting methods used are four (4) month moving average, a weighted three-month moving average, linear trend equation, and a simple exponential moving with smoothing constant.

Purchase this Solution
Free BrainMass Quizzes
Production and cost theory

Understanding production and cost phenomena will permit firms to make wise decisions concerning output volume.

Paradigms and Frameworks of Management Research

This quiz evaluates your understanding of the paradigm-based and epistimological frameworks of research. It is intended for advanced students.

Learning Lean

This quiz will help you understand the basic concepts of Lean.

Balance Sheet

The Fundamental Classified Balance Sheet. What to know to make it easy.

Motivation

This tests some key elements of major motivation theories.

View More Free Quizzes
Related BrainMass Solutions

  • Segment analysis; full costing

    (a) What is the break-even point per month in sales? (b) What level of sales is needed for a monthly profit of $24,000? (c) For the month of July, the company anticipates sales of $240,000. What is the expected level of profit?

  • Body language

    In the event a sales person needs to check on inventory or features, he or she should let the customer know the reason that he or she needs to check their phone or computer.

  • Management Information Reports

    This report can be made monthly. INFORMATION TECHNOLOGY DEPARTMENT Tommye Stevens, technical specialist (supervises computer programmers). The first process any company automates is the accounting process.

  • Statistics: factors in the process of distribution

    Predict the average monthly warehouse distribution cost when sales are $400,000 and the number of orders is 4,500. e.

  • Compare and contrast forecasting methods

    The sales manager may ask for input from each sales-person and aggregate their responses into a sales force composite forecast.

  • financial forecasting

    Over the last two decades, the marketing profession has developed many sophisticated techniques for analyzing and projecting future sales.

  • Sales Forecasting

    At this point, you should be able to estimate your sales on a monthly basis for a year. The basis for your sales forecast could be the average monthly sales of a few similar-sized competitors that are operating in a similar market.

  • Income Statement and Target Profit

    Increase in monthly sales Information for Part 3: Reduction in selling price Increase in monthly advertising budget Increase in monthly unit sales Information for Part 4: Increase in packaging cost per unit Targeted profit each

  • Classification and Reliability of Audit Evidence - Documentation

    Vendor monthly statements 3. Sales invoices 4. Shipping documents for sales 5. Bank statements 6. Employee payroll time cards 7. Receiving reports for goods received from vendors 8. Sales contracts 9. Purchase commitment contracts 10.

View More Related Solutions