Question

In: Accounting

You are hired by a Danish distributor of consumer goods, Dicgø, to improve their forecasting capabilities....

You are hired by a Danish distributor of consumer goods, Dicgø, to improve their forecasting capabilities. You are tasked with coming up with quarterly forecasts for an item that appears to have level, seasonality, and trend. While the company does have an existing Holt-Winter forecasting model, no one knows what the parameters (Alpha, Beta, or Gamma) are.

You do have some information. For example, you know that historically, the demand in each quarter follows this distribution:

- Q1 (January through March) = 60% of average quarterly demand

- Q2 (April through June) = 80% of average quarterly demand

- Q3 (July through September) = 140% of average quarterly demand

- Q4 (October through December) = 120% of average quarterly demand.

You just ran the forecast at the end of September (end of 2014Q3) and you have the following estimates:

For level: a^2014Q3 = 1050 units

For trend: b^2014Q3= 41.9 units per quarter

Q1) What is your forecast for demand for 2014Q4? In other words, what is x^2014Q3,2014Q4?

Q2) Suppose the actual demand in 2014Q4 is 1050 units. What is the lowest possible value for your estimate for level, a^2014Q4?

Q3) The model was run at the end of 2014Q4. It provided you with the most recent estimates of each pattern. The estimate for level, a^2014Q4 was 1067.8. What is the value of alpha?

Q4) The model was run at the end of 2014Q4. The estimate for trend, b^2014Q4 was found to be 39.6. What is value of beta?

Q5) The model was run at the end of 2014Q4. The estimate for seasonality, F^2014Q4 was found to be 1.189, before any normalization was done. What is the value of gamma?

Solutions

Expert Solution

(1) Forecast Demand For Q4 2014:

                      

(I)

For Level:

Demand for Q3-2014   ----------   1050 Units Per Quarter

As per above given Information, Q3 demand Is equal to 140% of Average Quarterly demand.

Avg Quarterly demand for level = 1050 Units @ 140%

                                         How many units @ 100%

                            = 1050*100/140

                              =750 Units

Q4 demand is 120% of Avg. Quarterly demand = 750*120/100

                                                                     =900 Units for Level

For Trend:

Demand for Q3-2014   ----------   41.9 Units per Quarter

As per above given Information, Q3 demand Is equal to 140% of Average Quarterly demand.

Avg Quarterly demand for level = 41.9 Units @ 140%

                                                         How many units @ 100%

                                                             =41.9*100/140

                                                             =29.92 Units

Q4 demand is 120% of Avg. Quarterly demand = 29.92*120/100

                                                                                            =35.90 Units For trend


Related Solutions

The following data relate to the operations of Shilow Company, a wholesale distributor of consumer goods:...
The following data relate to the operations of Shilow Company, a wholesale distributor of consumer goods: Current assets as of March 31: Cash $ 9,000 Accounts receivable $ 26,000 Inventory $ 48,600 Building and equipment, net $ 109,200 Accounts payable $ 29,175 Common stock $ 150,000 Retained earnings $ 13,625 The gross margin is 25% of sales. Actual and budgeted sales data: March (actual) $ 65,000 April $ 81,000 May $ 86,000 June $ 111,000 July $ 62,000 Sales are...
The following data relate to the operations of Shilow Company, a wholesale distributor of consumer goods:...
The following data relate to the operations of Shilow Company, a wholesale distributor of consumer goods:      Current assets as of March 31:      Cash $ 8,700      Accounts receivable $ 24,800      Inventory $ 46,800   Building and equipment, net $ 116,400   Accounts payable $ 28,050   Capital stock $ 150,000   Retained earnings $ 18,650    a. The gross margin is 25% of sales. b. Actual and budgeted sales data:      March (actual) $62,000   April $78,000   May $83,000   June $108,000   July $59,000    c....
The following data relate to the operations of Shilow Company, a wholesale distributor of consumer goods:...
The following data relate to the operations of Shilow Company, a wholesale distributor of consumer goods: Current assets as of March 31: Cash $ 7,700 Accounts receivable $ 20,800 Inventory $ 40,800 Building and equipment, net $ 129,600 Accounts payable $ 24,300 Common stock $ 150,000 Retained earnings $ 24,600 The gross margin is 25% of sales. Actual and budgeted sales data: March (actual) $ 52,000 April $ 68,000 May $ 73,000 June $ 98,000 July $ 49,000 Sales are...
The following data relate to the operations of Shilow Company, a wholesale distributor of consumer goods:...
The following data relate to the operations of Shilow Company, a wholesale distributor of consumer goods: Current assets as of March 31: Cash $ 7,800 Accounts receivable $ 21,200 Inventory $ 41,400 Building and equipment, net $ 130,800 Accounts payable $ 24,675 Common stock $ 150,000 Retained earnings $ 26,525 The gross margin is 25% of sales. Actual and budgeted sales data: March (actual) $ 53,000 April $ 69,000 May $ 74,000 June $ 99,000 July $ 50,000 Sales are...
The following data relate to the operations of Shilow Company, a wholesale distributor of consumer goods:...
The following data relate to the operations of Shilow Company, a wholesale distributor of consumer goods: Current assets as of March 31: Cash $ 7,800 Accounts receivable $ 21,200 Inventory $ 41,400 Building and equipment, net $ 130,800 Accounts payable $ 24,675 Common stock $ 150,000 Retained earnings $ 26,525 The gross margin is 25% of sales. Actual and budgeted sales data: March (actual) $ 53,000 April $ 69,000 May $ 74,000 June $ 99,000 July $ 50,000 Sales are...
The following data relate to the operations of Shilow Company, a wholesale distributor of consumer goods:...
The following data relate to the operations of Shilow Company, a wholesale distributor of consumer goods: Current assets as of March 31: Cash $ 8,400 Accounts receivable $ 23,600 Inventory $ 45,000 Building and equipment, net $ 123,600 Accounts payable $ 26,925 Capital stock $ 150,000 Retained earnings $ 23,675 The gross margin is 25% of sales. Actual and budgeted sales data:    March (actual) $ 59,000 April $ 75,000 May $ 80,000 June $ 105,000 July $ 56,000   ...
The following data relate to the operations of Shilow Company, a wholesale distributor of consumer goods:...
The following data relate to the operations of Shilow Company, a wholesale distributor of consumer goods: Current assets as of March 31: Cash $ 8,900 Accounts receivable $ 25,600 Inventory $ 48,000 Building and equipment, net $ 111,600 Accounts payable $ 28,800 Common stock $ 150,000 Retained earnings $ 15,300 The gross margin is 25% of sales. Actual and budgeted sales data: March (actual) $ 64,000 April $ 80,000 May $ 85,000 June $ 110,000 July $ 61,000 Sales are...
The following data relate to the operations of Shilow Company, a wholesale distributor of consumer goods:...
The following data relate to the operations of Shilow Company, a wholesale distributor of consumer goods: Current assets as of March 31: Cash $ 7,700 Accounts receivable $ 20,800 Inventory $ 40,800 Building and equipment, net $ 129,600 Accounts payable $ 24,300 Common stock $ 150,000 Retained earnings $ 24,600 The gross margin is 25% of sales. Actual and budgeted sales data: March (actual) $ 52,000 April $ 68,000 May $ 73,000 June $ 98,000 July $ 49,000 Sales are...
The following data relate to the operations of Shilow Company, a wholesale distributor of consumer goods:...
The following data relate to the operations of Shilow Company, a wholesale distributor of consumer goods: Current assets as of March 31: Cash $ 8,900 Accounts receivable $ 25,600 Inventory $ 48,000 Building and equipment, net $ 111,600 Accounts payable $ 28,800 Common stock $ 150,000 Retained earnings $ 15,300 The gross margin is 25% of sales. Actual and budgeted sales data: March (actual) $ 64,000 April $ 80,000 May $ 85,000 June $ 110,000 July $ 61,000 Sales are...
The following data relate to the operations of Shilow Company, a wholesale distributor of consumer goods:...
The following data relate to the operations of Shilow Company, a wholesale distributor of consumer goods: Current assets as of March 31: Cash $ 7,300 Accounts receivable $ 19,200 Inventory $ 38,400 Building and equipment, net $ 124,800 Accounts payable $ 22,800 Common stock $ 150,000 Retained earnings $ 16,900 The gross margin is 25% of sales. Actual and budgeted sales data: March (actual) $ 48,000 April $ 64,000 May $ 69,000 June $ 94,000 July $ 45,000 Sales are...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT