Purchase Solution

Business forecasting

Not what you're looking for?

Ask Custom Question

Dick Hoover, owner of Modern Office Equipment, is concerned about freight costs and clerical costs incurred on small orders. In an effort to reduce expenditures in this area, he has decided to introduce a discount policy rewarding orders over $40 in the hope that this will cause customers to consolidate a number of small orders into large orders. The folloqing data show the amount per transaction for a sample of 28 customers:

$10, $15, $20, $25, $15, $17, $41, $50, $5, $9, $12, $14, $35, $18, $17, $28, $29, $11, $11, $43,$54, $7
$8, $16, $13, $18.

Forecast the amount to the next customer transaction.

Average calculated to be: $21.41
Standard deviation was calculated to be: 13.61351.
Variance was calculated to be 185.3276.

QUESTION: If the policy is successful, will the mean of the distribution increase, decrease or remain unaffected? ANSWER: The goal is to decrease the amount of orders to increase amount of sales to $40, therefore, the mean of distribution would increase.

Question: If the policy is successful, will the standard deviation increase, decrease or remain unaffected. ANSWER: The standard deviation would increase.

I WOULD LIKE TO KNOW IF MY ANSWERS ARE CORRECT. I WOULD ALSO LIKE ASSISTANCE IN LEARNING HOW TO FORECAST THE AMOUNT OF THE NEXT CUSTOMER TRANSACTION. ALL OF THE CALCULATIONS HAVE TO BE DONE IN EXCEL.

Purchase this Solution
Solution Preview

Hi,
<br>
<br>From the data set that has been provided, there are only 26 values and the mean comes to @20.81 and Std dev of 13.51 ( see the attached Excel File).
<br>
<br>1)There are various ways of forecasting the amount of the next transaction , like Simple average ...

Purchase this Solution
Free BrainMass Quizzes
Measures of Central Tendency

This quiz evaluates the students understanding of the measures of central tendency seen in statistics. This quiz is specifically designed to incorporate the measures of central tendency as they relate to psychological research.

Know Your Statistical Concepts

Each question is a choice-summary multiple choice question that presents you with a statistical concept and then 4 numbered statements. You must decide which (if any) of the numbered statements is/are true as they relate to the statistical concept.

Measures of Central Tendency

Tests knowledge of the three main measures of central tendency, including some simple calculation questions.

Terms and Definitions for Statistics

This quiz covers basic terms and definitions of statistics.

View More Free Quizzes
Related BrainMass Solutions

  • How is business forecasting used?

    427589 How is business forecasting used? What is business forecasting? Describe the important uses of business forecasting. Describe the uses of business forecasting. There are many uses of business forecasting.

  • Planning tools for forecasting

    Business Dictionary.Com (2013). Forecasting.

  • Forecasting Methodologies

    A business has a strategic advantage if its operations make it more successful than others. When a business uses forecasting, it has methods that change data into useful and trustworthy insights.

  • Demand Management and Forecasting in Business

    Business Forecasting and Its Practical Application. USA: Kessinger Publishing. The demand management and forecasting in business is examined. The various techniques for forecasting is determined.

  • Forecasting as an Efficient Business Practice

    495434 Forecasting as an Efficient Business Practice In your opinion why do you think forecasting is an efficient business practice? One requisite of an efficient business practice is knowing when to produce and how much (quantity) to produce.

  • forecasting in planning and management

    Forecasting can have a positive effect on business operations.

  • Forecasting Methods used by Modern Corporations

    Hyndman (2009) identified three most common business forecasting used by modern corporations and these are: Time series methods, Explanatory models for forecasting, and Data mining methods for business forecasting.

  • Understanding Forecasting models as they apply to products

    Importance of Forecasting Models Introduction Scheduling for the future is the core of any business concern.

  • Abel Athletics Financial Forecast

    The process comprises the future of the business as a whole, the future of a product or product line and the future of the industry in which the business operates (Forecasting, 2008).

  • Value of sales plan

    Answer 2 Forecasting Forecasting is an important activity that plays a crucial role in the overall credibility of a business. It is used to determine the future aspects of the business.

View More Related Solutions