Refer to Problem 4.2. Develop a forecast for years 2 through 12 using exponential smoothing with a= .4 and a forecast for year 1 of 6

Problem 4.3 Refer to Problem 4.2. Develop a forecast for years 2 through 12 using exponential smoothing with a= .4 and a forecast for year 1 of 6. Plot your new forecast on a graph with the actual data and the naive forecast. Based on a visual inspection, which forecast is better
Year 1 2 3 4 5 6 7 8 9 10 11
Demand 7 9 5 9 13 8 12 13 9 11 7


Click here for the solution: Refer to Problem 4.2. Develop a forecast for years 2 through 12 using exponential smoothing with a= .4 and a forecast for year 1 of 6

Tylon's Hardware uses a flexible budget to develop planning information for its warehouse operations

Tylon's Hardware uses a flexible budget to develop planning information for its warehouse operations. For 20X2, the company anticipated that it would have 96,000 sales units for 664 customer shipments. Average storage bin usage for various inventories was estimated to be 200 per day. The costs and cost drivers were determined to be as follows:

Item Fixed Variable Cost driver

Product handling $10,000 $1.25 per 100 units

Storage - 3.00 per storage bin

Utilities 1,000 1.50 per 100 units

Shipping clerks 1,000 1.00 per shipment

Supplies - 0.50 per shipment

During the year, the warehouse processed 90,000 units for 600 customer shipments. The workers used 225 storage bins on average each day to sort, store, and process goods for shipment. The actual costs for 20X2 were:

Item Actual costs

Product handling $10,900

Storage 465

Utilities 2,020

Shipping clerks 1,400

Supplies 340

Question 1: Determine the 20X2 static budget variances.

Question 2: Determine the 20X2 flexible budget variances.

Click here for the solution: Tylon's Hardware uses a flexible budget to develop planning information for its warehouse operations