Planning Budget Actual Results Revenue: Qty Price/Cost Total Qty Total Domestic Beer 7,500 6 45,000 8,330 46,980 Premium Beer 5,000 8 40,000 4,725 37,800 Wine 6,500 8 52,000 6,800 54,400 Mixed Drinks and Liqour 6,000 9 54,000 6,150 55,350 Total Revenue 191,000 194,530 Expenses: Domestic Beer 7,500 1 7,500 8,330 7,830 Premium Beer 5,000 1.5 7,500 4,725 7,888 Wine 6,500 2 13,000 6,800 15,430 Mixed Drinks and Liqour 6,000 2.5 15,000 6,150 18,525 Labor 2,025 hours 12 24,300 2,000 hours 21,220 Equipment Rental 5 months 1200 6,000 5 months 6,755 Rent to Harbor Park 5 months 6500 32,500 5 months 33,175 Temporary Liqour License fixed 12,500 fixed 15,000 Temporary Business License fixed 5,000 fixed 4,825 Insurance 5 months 600 3,000 5 months 2,750 Misc. Expenses fixed 13,000 fixed 12,465 Total Expenses 139,300 145,863 Operating Profit 51,700 48,668 Create a flexible budget for PBW using the actual levels of activity provided above