Question

In: Finance

Please make a sales forecast for an all in one washer and dryer that costs $1020...

Please make a sales forecast for an all in one washer and dryer that costs $1020 I have no idea how to do this. Im supposed to create my own numbers because I "made" the product. You can make the numbers up just label it please. It says to put it in a table

Solutions

Expert Solution

The following are the various methods of sales forecasting:

1. Jury of Executive Opinion.

2. SalesForce Opinion.

3. Test Marketing Result.

4. Consumer’s Buying Plan.

5. Market Factor Analysis.

6. Expert Opinion.

7. Econometric Model Building.

8. Past Sales (Historical Method).

9. Statistical Methods.

1. Jury of Executive Opinion:

This method of sales forecasting is the oldest. One or more of the executives, who are experienced and have good knowledge of the market factors make out the expected sales. The executives are responsible while forecasting sales figures through estimates and experiences. All the factors-internal and external—are taken into account. This is a type of committee approach. This method is simple as experiences and judgment are pooled together in taking a sales forecast figure. If there are many executives, their estimates are averaged in drawing the sales forecast.

Merits:

(a) This method is simple and quick.

(b) Detailed data are not needed.

(c) There is the economy.

ADVERTISEMENTS:

Demerits:

(a) It is not based on factual data.

(b) It is difficult to draw a final decision.

(c) More or less, the method rests on guess-work and may lead to wrong forecasts.

(d) It is difficult to break down the forecasts into products, markets, etc.

2. SalesForce Opinion:

Under this method, salesmen, or intermediaries are required to make out an estimate sales in their respective territories for a given period. Salesmen are in close touch with the consumers and possess good knowledge about the future demand trend. Thus all the sales force estimates are processed, integrated, modified, and a sales volume estimate formed for the whole market, for the given period.

Merits:

(a) Specialized knowledge is utilized.

(b) Salesmen are confident and responsible to meet the quota fixed.

(c) This method facilitates to break down in terms of products, territories, customers, salesmen, etc.

Demerits:

(a) Success depends upon the competency of salesmen.

(b) A broad outlook is absent.

(c) The estimation may be unattainable or may to too low for the forecasts as the salesmen may be optimistic or pessimistic.

3. Test Marketing Result:

Under the market test method, products are introduced in a limited geographical area and the result is studied. Taking this result as a base, the sales forecast is made. This test is conducted as a sample on a pre-test basis to understand the market response.

Merits:

(a) The system is reliable as the forecast is based on the actual results.

(b) Management can understand the defects and take steps to rectify them.

(c) It is good for introducing new products, in a new territory, etc.

Demerits:

(a) All the markets are not homogeneous. But the study is made based on a part of a market.

(b) It is a time-consuming process.

(c) It is costly.

4. Consumers’ Buying Plan:

Consumers, as a source of information, are approached to know their likely purchases during the period under a given set of conditions. This method is suitable when there are few customers. This type of forecasting is generally adopted for industrial goods. It is suitable for industries, which produce costly goods to a limited number of buyers- wholesalers, retailers, potential consumers, etc. A survey is conducted on face to face basis or survey method. It is because changes are constant while buyer behavior and buying decisions change frequently.

Merits:

(a) First-hand information is possible.

(b) The user’s intention is known.

Demerits:

(a) Customer’s expectations cannot be measured exactly.

(b) It is difficult to identify actual buyers.

(c) It is good when users are few, but not practicable when consumers are many.

(d) Long run forecasting is not possible.

(e) The system is costly.

(f) Buyers may change their buying decisions.

5. Market Factor Analysis:

A company’s sales may depend on the behavior of certain market factors. The principal factors which affect the sales may be determined. By studying the behaviors of the factors, forecasting should be made. Correlation is the statistical analysis that analyses the degree of extent to which two variables fluctuate concerning each other.

The word ‘relationship’ is of importance and indicates that there is some connection between the variables under observation. In the same way, regression analysis is a statistical device, which helps us to estimate or predict the unknown values of one variable from the known values of another variable.

For instance, you publish a textbook on “Banking”, affiliated to different universities. The permitted intake capacity of each and the medium through which the students are taught are known. Is it a compulsory or an optional subject? By getting all these details and also by considering the sales activities of promotional work, you may be able to declare the probable copies to be printed.

The key to the successful use of this method lies in the selection of the appropriate market factors. Minimizing the number of market factors is also important. Thus the demand decision-makers have to consider price, competitions, advertising, disposal income, buying habits, consumption habits, consumer price index, change in population, etc.

Merits:

(a) It is a sound method.

(b) The market factor is analyzed in detail.

Demerits:

(a) It is costly.

(b) It is time-consuming.

(c) It is a short-run process.

6. Expert Opinion:

Many types of consultancy agencies have entered into the field of sales. The consultancy agency has specialized experts in the respective field. This includes dealers, trade associations, etc. They may conduct market researches and possess ready-made statistical data. Firms may make use of the opinions of such experts. These opinions may be carefully analyzed by the company and a sound forecasting is made.

Merits:

(a) Forecasting is quick and inexpensive.

(b) It will be more accurate.

(c) Specialized knowledge is utilized.

Demerits:

(a) It may not be reliable.

(b) The success of forecasting depends upon the competency of experts.

(c) A broad outlook may be lacking.

7. Econometric Model Building:

This is a mathematical approach to study and is an ideal way to forecast sales. This method is more useful for marketing durable goods. It is in the form of equations, which represent a set of relationships among different demand determining market factors. By analyzing the market factors (independent variable) and sales (dependent variable), sales are forecast. This system does not entirely depend upon correlation analysis. It has a great scope, but the adoption of this method depends upon the availability of complete information. The market factors which are more accurate, quick and less costly may be selected for a sound forecasting.

8. Past Sales (Historical method):

Personal judgment of sales forecasting can be beneficially supplemented by the use of statistical and quantitative methods. Past sales are a good basis and on this basis future sales can be formulated and forecast. According to Kirkpatrick, today’s sales activity flows into tomorrow’s sales activities; that is last year’s sales extend into this year’s sales. This approach is adding or deducting a set of the percentage to the sales of the previous year(s). For new industries and new products, this method is not suitable.

(a) Simple Sales Percentage:

Under this method, sales forecast is made by adding simply a flat percentage of sales to forecast sales as given below:

Next year sales = Present year sales + This year sales/Last year sales

or = Present year sales + 10 or 5% of present sale

(b) Time Series Analysis:

A time-series analysis is a statistical method of studying historical data. It involves the isolation of long-time trends, cyclical changes, seasonal variations, and irregular fluctuations. Past sales figures are taken as a base, analyzed and adjusted to future trends. The records and reports enable us to interpret the information and forecast future trends and trade cycles too.

Merits:

(a) No guess-work creeps in.

(b) The method is simple and inexpensive.

(c) This is an objective method.

Demerits:

(a) ‘Market is dynamic’ is not considered.

(b) No provision is made for upswings and downswings in sales activities.

9. Statistical Methods:

Statistical methods are considered to be superior techniques of sales forecasting because their reliability is higher than that of other techniques.

They are:

(i) Trend Method

(ii) Graphical Method

(iii) Time-series Method:

(a) Freehand method

(b) Semi-average method

(c) Moving average method

(d) Method of least square

(iv) Correlation method

(v) Regression method.

NB:

The above statistical methods can easily be studies with the help of any statistics book.

Apart from the above, the following factors may also be considered:

1. Availability of raw materials

2. Plant capacity

3. Government policies

4. Buying habits of consumers

5. Fashion changes

6. Distribution system

7. Financial capacity

8. Market competition

9. National income movement

10. Sales promotions


Related Solutions

All Clean is the only company selling all-in-one washer–dryer machines. The price of a machine is...
All Clean is the only company selling all-in-one washer–dryer machines. The price of a machine is P, while Q is the quantity of machines sold per quarter. The following equations describe the market for All Clean's machines: Demand: P = 600 – 5Q ♦ Marginal Revenue: MR = 600 – 10Q Total Cost: TC = 2000 + 60Q + 2.5Q2 ♦ Marginal Cost: MC = 60 + 5Q _____________________________________________________ What is All Clean's profit at the profit-maximizing quantity?
All-Clean is the only company selling all-in-one washer-dryer machines. The price of a machine is P...
All-Clean is the only company selling all-in-one washer-dryer machines. The price of a machine is P while Q is the quantity of machines sold per quarter. The following equations describe the market for All Clean Machines: Demand: P = 600 - 5Q ♦ Marginal Revenue: MR = 600 - 10Q Total Cost: TC = 2000 + 60Q + 2.5Q2 ♦ Marginal Cost: MC = 60 + 5Q 1. What is All-Clean's profit maximizing quantity? 36 2. What is All-Clean's profit...
One of the leading washer and dryer manufactures has estimated the following demand equation based on...
One of the leading washer and dryer manufactures has estimated the following demand equation based on the data from its 47 branch offices and dealerships across the country: Q = 12,000 - 20P + 120A + 15Pc - 100Ac + 80I - 20Pd (64000 (9) (80) (7) (64) (52) (9) R2 = 0.72 F = 20.15 The variables and their assumed values are Q= Quantity P = Price of basic model = 500 A = Advertising expenditures = 50 Pc...
Please calculate the values needed to forecast the sales, variable costs, fixed costs, and net income...
Please calculate the values needed to forecast the sales, variable costs, fixed costs, and net income for the next year using the forecasting assumptions provided. Then, determine the impact on the balance sheet by projecting the dividends paid and resulting impact on other components of the balance sheet. Finally, determine the amount of Additional Funds needed in the next year.       This year          Next Year        Forecasting Assumption   Sales                          100                    _____                Sales will grow 20% ‑ Variable Costs             50                     _____               Constant % of Sales ‑ Fixed Costs                 40                     ______            Remains same...
Sales Forecast Almost all financial plans require an externally supplied sales forecast. In our models that...
Sales Forecast Almost all financial plans require an externally supplied sales forecast. In our models that follow, for example, the sales forecast will be the “driver,” meaning that the user of the planning model will supply this value, and most other values will be calculated based on it. This arrangement is common for many types of business; planning will focus on projected future sales and the assets and financing needed to support those sales. Frequently, the sales forecast will be...
1) A new washer costs $13,000. The old one is fully depreciated and can be sold...
1) A new washer costs $13,000. The old one is fully depreciated and can be sold for $4,000. The new washer will last 10 years and save $5,000 per year in expenses. The new washer will be depreciated on a straight line basis to zero. The tax rate is 26% and the required return is 15%. What is the NPV of this project? Answer to 2 decimals places, for example 543.12. 2) Two years ago, your firm bought a new...
Why is the preparation of a sales forecast one of the earliest steps in preparing a...
Why is the preparation of a sales forecast one of the earliest steps in preparing a master budget? Explain at least three ways a company can benefit from preparing a formal budget.
The sales forecast is based on projected levels of demand. All the numbers are expressed in...
The sales forecast is based on projected levels of demand. All the numbers are expressed in today’s dollars. Price per bus $220,000 Units sold per year 12,250 Labor cost per bus $32,500 Components & Parts $86,500 Selling General & Administrative $200,000,000 The average warranty cost per year per bus for the first five years is $2,000. The present value of this cost will be used as a cost figure for each bus. Afterwards, the bus operator will become responsible the...
Forecast Sales Volume and One of the major elements of the income statement budget that indicates...
Forecast Sales Volume and One of the major elements of the income statement budget that indicates the quantity of estimated sales and the expected unit selling price.Sales Budget For 20Y6, Raphael Frame Company prepared the sales budget that follows. At the end of December 20Y6, the following unit sales data were reported for the year: Unit Sales 8" × 10" Frame 12" × 16" Frame East 20,055 11,978 Central 4,944 4,018 West 4,224 3,296 Raphael Frame Company Sales Budget For...
Forecast Sales Volume and One of the major elements of the income statement budget that indicates...
Forecast Sales Volume and One of the major elements of the income statement budget that indicates the quantity of estimated sales and the expected unit selling price.Sales Budget For 20Y6, Raphael Frame Company prepared the sales budget that follows. At the end of December 20Y6, the following unit sales data were reported for the year: Unit Sales 8" × 10" Frame 12" × 16" Frame East 31,106 15,080 Central 7,676 6,076 West 6,693 5,202 Raphael Frame Company Sales Budget For...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT