Tylon's Hardware uses a flexible budget to develop planning information for its warehouse operations. For 20X3, the company used the following anticipated activity for budgeting purposes:
Sales in units 104,000 units
Customer shipments 742 shipments
Average storage bin usage 220 per day
The costs and cost drivers were determined to be as follows:
Cost Pool Fixed Variable Cost driver
Product handling $12,000 $1.50 per 100 units
Storage - $3.50 per storage bin
Utilities $3,000 $1.25 per 100 units
Shipping clerks $1,250 $1.20 per shipment
Supplies - $0.65 per shipment
During the year, the warehouse experienced the following actual activity:
Sales in units 128,000 units
Customer shipments 778 shipments
Average storage bin usage 235 per day
The actual costs for 20X3 were:
Cost Pool Actual costs
Product handling $13,827
Storage $808
Utilities $4,420
Shipping clerks $2,152
Supplies $528
Question 1: Determine the 20X3 static budget variances for each cost pool and in total.
Question 2: Determine the 20X3 flexible budget variances for each cost pool and in total.