Purchase Solution

Forecast January sales sales for Telco Batteries, Inc.

Not what you're looking for?

Ask Custom Question

The monthly sales for Telco Batteries, Inc were as follows:

Month: Sales:
__________|______________
January 20
February 21
March 15
April 14
May 13
June 16
July 17
August 18
September 20
October 20
November 21
December 23

a) Plot the monthly sales data on a sheet of graph paper

b) Forecast January sales using each of the following:
1) Naïve method
2) A 3-month moving average
3) A 6-month weighted average using, .1, .1, .1, .2, .2, and .3, with the heaviest weights applied to the most recent months.
4) Exponential smoothing using an 0 =.3 and a September forecast of 18.
5) A trend projection

c) With the given data, which method would allow you to forecast next March's sales?

Purchase this Solution
Solution Summary

Computations shown for you in this solution.

Purchase this Solution
Free BrainMass Quizzes
Cost Concepts: Analyzing Costs in Managerial Accounting

This quiz gives students the opportunity to assess their knowledge of cost concepts used in managerial accounting such as opportunity costs, marginal costs, relevant costs and the benefits and relationships that derive from them.

Organizational Leadership Quiz

This quiz prepares a person to do well when it comes to studying organizational leadership in their studies.

Change and Resistance within Organizations

This quiz intended to help students understand change and resistance in organizations

Introduction to Finance

This quiz test introductory finance topics.

Writing Business Plans

This quiz will test your understanding of how to write good business plans, the usual components of a good plan, purposes, terms, and writing style tips.

View More Free Quizzes
Related BrainMass Solutions

  • Plotting and Trends

    (2) The monthly sales for Telco Batteries, Inc., were as follows: Month Sales January 20 February 21 March 15 April 14 May 13 June 16 July 17 August 18 September

  • Forecast revenue, production, direct materials budgets

    Exercise 9-4 Pletcher Company produces and sell automobile batteries, the heavy-duty HD-24. The 2011 sales forecast is as follows.

  • code of conduct at ECG

    From the perspective of consequential ethics if ECG manages to get the sales contract and because of the actions of the employee other more deserving firms are eliminated, it will mean a loss for X TelCo.

  • Forecast

    311480 Exponential Forecast - Simple and Trend (Holt's), Seasonal Forecast The management of American Auto Parts is having a meeting to plan the operating budgets for next year. The Senior Vice-President of Sales, Mr.

  • Value of equity and sales forecast

    80 X (1.09)^4 = $112.93 billion The solution explains how to calculate the value of equity the sales forecast for the coming year.

  • Budgeting, Dollie Inc.

    456328 Budgeting, Dollie Inc. The budget director of Dollie Inc., with the help of the finance department, has compiled the following information for use in creating the budgeted income statement for January 20xx: a.

  • Summary of Cash Payments

    48316 Summary of Cash Payments The Liston Inc. has forecast the following sales for the first seven months of the year: January $10,000 May $10,000 February 12,000 June 16,000 March 14,000 April 20,000 July 18,000 Monthly material purchases

  • Preparing a budget - Dollie Inc

    Prepare a sales budget for January. 15. Prepare a production budget for January. 16. Prepare a direct material budget for January. 17. Prepare a direct labor budget for January. 18. Prepare a factory overhead budget for January. 19.

  • Value of Equity

    The shares of Quanta, Inc. were traded at a total market capitalization of $145 billion on January 31, 2000. If profit margins and turnovers were to continue at their 2000 level, what sales is the market forecasting for Quanta, Inc. in 2004? 1.

View More Related Solutions