Question

In: Operations Management

Patsy Ltd. produces ice-cream and would like to accurately forecast sales so that it can meet...

Patsy Ltd. produces ice-cream and would like to accurately forecast sales so that it can meet the demands of customers. In order to plan properly, the Operations Manager would like to forecast sales for the next 4 months and would need your assistance. Identify the quantitative techniques covered in this course. Choose any two techniques, describe them and use them to demonstrate how you will forecast sales for the next 4 months. [15 marks] Show how you will measure the accuracy of the quantitative forecast

Solutions

Expert Solution

ANS :

For forcasting sales of ice-cream for the next 4 months , quantitative techniques will be very useful but before going to the two techniques first of all it is necessary to know about quantitative techniques.

Quantitative techniques can be understood as a collection of mathematical and statistical tools that are used to provide powerful means of analysis using quantitative data for effective decision making in business. These tools help businesses in taking effective business decision and hence result in optimum utilization of limited resources.Now accurate sales forecasts enable companies to make informed business decisions and predict short-term and long-term performance. Companies can base their forecasts on past sales data, industry-wide comparisons, and economic trends and in this our two technoiques will be very helpful.

The major two quantitative methods of forecasting of sales for the next 4 mopnths are discussed below:

1. Test Marketing:

Test marketing is one of the popular methods for measuring consumer acceptance of new products. The results from a test market are extrapolated to make predictions about future sales. Companies select a limited number of cities with populations which are representative of the target customers in terms of demographic factors that include age, income, lifestyle and shopping behaviour.A product is made available at the retail outlets and the features are highlighted either through in-store promotion or through a small advertising campaign. Then the performance of the product is tracked through consumer research and modifications before taking it for a national launch.

2. Time Series Analysis:

In time series analysis, it is important to collect relevant past data for future projects. Time series analysis is a series of techniques that make forecasts based on past patterns of data. These data are collected, observed, and recorded at regular intervals of time. These methods are useful when the market forces are somehow stable and the market shows least erratic behaviour. Actions taken by the firm and the competitor’s move are not taken into account.

In a time series, time is the most important factor because the variable is related to time. The sales managers can undertake time series analysis in four ways. The changes that have occurred as a result of the general tendency of the data to increase or decrease are known as secular movements.Changes that have taken place during a period of 12 months as a result of change in climate, weather conditions, and festivals are termed as seasonal variations. Changes that have taken place as a result of booms and depressions are called cyclical variations. Changes that have taken place as a result of such unpredictable forces as floods, earthquakes, famines, etc. are classified as irregular or erratic variations.

In contrast, a time-series analysis is a versatile and more-accurate forecasting method. A time series is a time-ordered sequence of observations measured at consecutive points in time or over different periods, such as every hour, day, week, month or year.

The following four types of sales variations are separately analyzed:

(a) Long-term trends

(b) Business cyclical movements

(c) Seasonal variations

(d) Irregular and casual fluctuation

After the analysis, different time series mathematical models are formed; assumed values are applied with each of the models, to arrive at sales forecasts.

Advantages:

(a) This method compels the forecaster to consider the underlying trends, cycles, and seasonal variations in the sales.

(b) It takes into account the particular repetitive or continuing patterns exhibited by the sales in the past.

(c) It provides a systematic means of making quantitative projections.


Related Solutions

A major producer of ice cream and would like to test the hypothesis that the average...
A major producer of ice cream and would like to test the hypothesis that the average American consumes more than 20 ounces of ice cream per month. A random sample of 19 Americans was found to consume an average of 20.5 ounces of ice cream last month. The standard deviation for this sample was 1.5 ounces. The producer would like to set α=0.10. The p-value for this hypothesis​ test is between_________ and__________ ?
An ice cream company collected data on their ice cream cones sales over a month in...
An ice cream company collected data on their ice cream cones sales over a month in July in a Chicago suburb, along with daily temperature and the weather. The company is interested to develop a correlation between ice cream sales to the hot weather. Market research showed that more people come out in certain neighborhoods, to either enjoy the nice weather, or venture out if they do not have air conditioning in their apartments. The Chicago Police also tracked crime...
An ice cream company collected data on their ice cream cones sales over a month in...
An ice cream company collected data on their ice cream cones sales over a month in July in a Chicago suburb, along with daily temperature and the weather. The company is interested to develop a correlation between ice cream sales to the hot weather. Market research showed that more people come out in certain neighborhoods, to either enjoy the nice weather, or venture out if they do not have air conditioning in their apartments. The Chicago Police also tracked crime...
At an Ice Cream Store, a single scoop of ice-cream can be modeled by a hemisphere...
At an Ice Cream Store, a single scoop of ice-cream can be modeled by a hemisphere which is 1 inch tall. The ice-cream fits perfectly on top of a cone that is 4 inches tall and has a 1 inch radius at the top. 1. Write one equation in Cartesian coordinates (x, y, z) to describe the scoop and one equation for the cone. 2. If the mass of one scoop of ice cream is 60 grams and that the...
Jerry’s Ice Cream Parlor is considering a marketing plan to increase sales of ice cream cones....
Jerry’s Ice Cream Parlor is considering a marketing plan to increase sales of ice cream cones. The plan will give customers a free ice cream cone if they buy 10 ice cream cones at regular prices. Customers will be issued a card that will be punched each time an ice cream cone is purchased. After 10 punches, the card can be turned in for a free ice cream cone. Jerry Donovna, the company’s owner, is not sure how the new...
A retail store serves a variety of ice cream flavors. The owner would like to add...
A retail store serves a variety of ice cream flavors. The owner would like to add a flavor to the menu and needs to decide between Blueberry Cheesecake and Lemon Custard. To help her​ decide, she randomly selects 10 customers and asks them to taste each flavor and rate them on a scale of 1 to 20. A rating of 1 indicates the taster does not like the​ flavor, and a rating of 20 indicates that the taster likes it...
IcyPop Inc. is an ice cream manufacturing company. It produces two major types of ice-cream products:...
IcyPop Inc. is an ice cream manufacturing company. It produces two major types of ice-cream products: FruityGo and BerryWafers. You have been brought on as an Analyst, with your first task being to ascertain the most appropriate method of assigning overhead costs to its FruityGo and BerryWafers products. The following information relates to these products for the year just ended for its two main production departments. Mixing Packaging Budgeted Overhead $400,000 $80,000 Budgeted Direct Labour Hours: FruityGo 1,000 5,000 BerryWafers...
Demand for walnut fudge ice cream at the Sweet Cream Dairy can be approximated by a...
Demand for walnut fudge ice cream at the Sweet Cream Dairy can be approximated by a normal distribution with a mean of 17 gallons per week and a standard deviation of 3.2 gallons per week. The new manager desires a service level of 90 percent. Lead time is two days, and the dairy is open seven days a week. (Hint: Work in terms of weeks.) a-1. If an ROP model is used, what ROP would be consistent with the desired...
Demand for walnut fudge ice cream at the Sweet Cream Dairy can be approximated by a...
Demand for walnut fudge ice cream at the Sweet Cream Dairy can be approximated by a normal distribution with a mean of 21 gallons per week and a standard deviation of 3.5 gallons per week. The new manager desires a service level of 98 percent. Lead time is two days, and the dairy is open seven days a week. If an ROP model is used, what ROP would be consistent with the desired service level? ( Hint: Work in terms...
The high temperature (in degrees Fahrenheit), x, and the ice cream sales (in dollars) for a...
The high temperature (in degrees Fahrenheit), x, and the ice cream sales (in dollars) for a local store, y, are related by the regression line equation y = -392.966 + 8.791x. Find the amount of sales predicted by the model if the high temperature is x = 94°F. Give your answer as a monetary amount rounded to the nearest cent.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT