Question

In: Operations Management

You are asked to provide sales forecasts of several products for a large biscuit manufacturing company....

You are asked to provide sales forecasts of several products for a large biscuit manufacturing company. Define the steps to perform an effective forecasting in the context of this company.

Solutions

Expert Solution

The steps for effective forecasting are as follows:

1. Identify the Problem

The first step is to identify the problem regarding what has to be estimated and why. You could simply ask how the market is reacting for your biscuit or how the company's sales would look like in a few months to conduct the forecasting. You should have the knowledge about how the market works effectively, who are your competitors and what is your customer base for the product offered.

2. Collect Information

Information is collected as per the past data available with us to conduct the forecasting method. This data which has been effectively collected by the knowledge and research experts of the company is converted into information by the judgement and analysis by the experts. If the judgement is based on numbers, quantative forecasting would be performed, if not, qualitative would be performed. In our case, a quantative data forecasting for the sales forecast of biscuit would be performed as per the past data records.

3. Perform a Preliminary Analysis

A preliminary or early analysis would be performed to make sure if the data weare using is usable or not. Patters and trends would be effectiveky displayed for the past data records that can help for the future estimation for example one can also evaluate the data and also make rightful assumptions to reduce the amount of data to be more accurate for the forecast made.

4. Choose the Forecasting Model

Once the data is evaluated and the information is collected and treated, you can choose the model you think would work the best for the forecasting method. There are a no. of methods like regression method, exponential smoothing method which could be most effectively used in this case to forecast the no. of biscuits for the sales for the company as a quantitative forecasting.

5. Data analysis

This is a simple where after you choose the most suitable model for forecasting, the same method is implemented and the data is run through it.

6. Verify Model Performance

Finally, the forecasted data would then be compared with the actual data like the forecasted sales volume of the biscuit would be compared with the actual one when the right time comes to make sure if the method we used for forecasting was effective or not and how we can improve out forecasting.


Related Solutions

The Longmont company in Charlette, North Carolina, asked you to develop quarterly forecasts of combine sales...
The Longmont company in Charlette, North Carolina, asked you to develop quarterly forecasts of combine sales for next year. Combine sales are seasonal, and the data on the quarterly sales for the last four years are as follows: Quarter Year 1 Year 2 Year 3 Year 4 1 55 85 178 256 2 37 23 101 193 3 89 130 145 209 4 110 156 167 167 Chad Johnson estimates the total demand for the next year (Year 5) at...
College Products College Products is a division of a large manufacturing company. The company makes a...
College Products College Products is a division of a large manufacturing company. The company makes a variety of collegiate branded products, sold on campuses worldwide. Most employees are paid on an hourly basis. Employees receive yearly reviews to evaluate performance and to determine an appropriate pay increase. College’s payroll is processed by the corporate payroll department from input documents prepared by College. The following HR and payroll procedures are related to the hourly payroll employees at College. Department supervisors initiate...
The number of products sold for the past several months is given along with the forecasts...
The number of products sold for the past several months is given along with the forecasts using both 3-month moving average and exponential smoothing (α = .2). Determine the better forecast using the MSE. Month Sales 3-month moving average Error Exponential Smoothing Error Jan 13 Feb 18 March 15 Apr 12 May 14 June 15 July 10
Andy’s Co. is a manufacturing firm of a computer hardware device. Its sales forecasts for the...
Andy’s Co. is a manufacturing firm of a computer hardware device. Its sales forecasts for the year 2020 is as follows: Quarter Sales in units Price Revenue Q1, 2020 500 $              400 $     200,000 Q2, 2020 1000                  400          400,000 Q3, 2020 1000                  400          400,000 Q4, 2020 1000                  400          400,000 Q1, 2021 2000                  400          800,000 Q2, 2021 1500                  400          600,000 Q3, 2021 1000 $              400 $     400,000 The company will start its business this year with $30,000 of cash balance. As of Q4 of the...
Biscuit Company has developed the following standards for one of its products. Direct labor hours is...
Biscuit Company has developed the following standards for one of its products. Direct labor hours is the driver used to assign overhead costs to products. Direct materials: 10 pounds × $3 per pound Direct labor: 2.5 hours × $8 per hour Variable manufacturing overhead: 2.5 hours × $2 per hour The following activity occurred during the month of June: Materials purchased: 125,000 pounds at $2.60 per pound Materials used: 110,000 pounds Units produced: 10,000 units Direct labor: 24,000 hours at...
You are a CFO for a large manufacturing company. You are also a CMA and IMA...
You are a CFO for a large manufacturing company. You are also a CMA and IMA member. You own and manage two apartment buildings in the town where the company you work for is located. You have a vacant apartment for rent. A single mother with two small children has applied to live in the apartment. You decide not to rent to her stating that you do not want small children in the apartment. However, there are a number of...
Imagine you are CEO of a large company and your board has asked you to take...
Imagine you are CEO of a large company and your board has asked you to take a more sustainable approach to reporting firm performance Do you adopt Triple Bottom Line reporting or Balanced Scorecard? Why or why not? Now imagine you operate a large call centre in Bangalore, India. What social measures would you use for triple bottom line reporting?
Ace Household Products Inc. is a multi-product company with several manufacturing plants. The Shareport Plant manufactures...
Ace Household Products Inc. is a multi-product company with several manufacturing plants. The Shareport Plant manufactures and distributes two household cleaning and polishing compounds, standard and commercial, under the Clean & Bright label. The forecasted operating results for the first six months of the current year, when 100,000 cases of each compound are expected to be manufactured and sold, are presented in the following statement. CLEAN & BRIGHT COMPOUNDS - SHAREPORT PLANT Forecasted Results of Operations For the Six-Month Period...
The Addams Corporation is preparing to lease several large pieces of equipment. The president has asked...
The Addams Corporation is preparing to lease several large pieces of equipment. The president has asked the company’s accountant to respond to the following questions about lease accounting. a. How will Addams know if the lease is an operating lease or a capital lease? b. What is meant by off-balance sheet financing? How does off-balance sheet financing relate to the reporting of leases? c. Why is a discussion of substance over form often heard in connection with the financial reporting...
21) Sales Forecasting: You were asked at your new company to forecast sales for the coming...
21) Sales Forecasting: You were asked at your new company to forecast sales for the coming year. Utilizing the Compound Average Growth Rate, you have gone out and collected the data for the prior three years (noted below). Using this data, compute the a. compound growth rate for each of the years b. forecast next year’s sales by using the two-year average growth rate. Year Sales 2012 2,400,000 2013 2,750,000 2014 3,500,000 2015 ?
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT