***For University, Memorial, and Children's

1. Compute the Master Budget Gross Profit

2. Compute the Master Budget Segment Income

3. Compute the Flexible Budget Gross Profit

4. Compute the Flexible Budget Segment Income

5. Compute Actual Performance Gross Profit

6. Compute Actual Performance Segment Income

7. Compute Activity Variance -> Sales

8. Compute Activity Variance -> Cost of Surgical Supplies Sold

9. Compute Activity Variance -> Indirect Costs

10. Compute Revenue Variance -> Sales

11. Compute Spending Variance -> Cost of Surgical Supplies Sold

12. Compute Spending Variance -> Indirect Costs

Worley Surgical Supplies University Memorial Childrens Company Budgeted Data Sales (marked up of 20% over CGS) Budgeted Quantity Sold at Budgeted Cost 1.20 $20,000,000 $12,000,000 $8,000,000 $40,000,000 Indirect Costs Delivery Warehouse Depreciation & Utilities Warehouse Equipment Rental Warehouse Wages Operation Supervisor Salaries Administrative Office & Equipment Administrative Salaries & Expenses Marketing Expenses $216,000 $400,000 $110,000 $540,000 $300,000 $90,000 $350,000 $80,000 $2,086,000 Cubic Feet of Deliveries Predetermined Overhead Rate 1,000,000 400,000 800,000 2,200,000 $0.948200 1.22 Actual Performance Sales (marked up of 22% over CGS) Actual Quantity Sold at Actual Cost Actual Quantity Sold at Budgeted Cost $19,800,000 $21,500,000 $14,400,000 $11,500,000 $10,800,000 $9,000,000 $45,000,000 Indirect Costs Delivery Warehouse Depreciation & Utilities Warehouse Equipment Rental Warehouse Wages Operation Supervisor Salaries Administrative Office & Equipment Administrative Salaries & Expenses Marketing Expenses $336,600 $460,000 $101,200 $673,200 $270,000 $99,000 $420,000 $84,800 $2,444,800 1,402,500 981,750 420,750 2,805,000 Cubic Feet of Deliveries Actual Overhead Rate $0.871600