Philly Bar Works (PBW) is a catering company located in Philadelphia. Every year from May through September, they operate a beer garden at Spruce Street Harbor Park near Penns Landing. PBW pays for all expenses of operating the beer garden as well as rent to the Harbor Park. Their operating expenses include equipment rental, temporary liquor and business licenses, and insurance. They also have a number of small miscellaneous expenses that are typically not classified and are thought to be immaterial as individual expenses.

PBW offers four types of alcoholic beverages: domestic beer, premium beer, wine, and mixed drinks and liquor. PBWs planning budget and actual results for 2016 are presented in the PBW.xlxs file. PBWs planning budget includes estimated prices and volumes (qty), while the actuals provide actual volumes. Definitions of selected revenue and expense items are listed below. Items not listed are thought to be self-explanatory.

Additional Definitions

Domestic Beer: 16-ounce serving of domestic beer. The list of domestic beers is stable and includes a regular and light version of a single domestic brand.

Premium Beer: 16-ounce serving of premium beer. Beers are chosen from a rotating list, and while cost for the types of beer may vary, the estimated average cost per serving is estimated to be $1.50.

Wine: 5-ounce serving of house wine chosen by PBW. The list includes two red and two white varietals. Cost for the types of wine may vary, but average costs are expected to be $2 per serving.

Mixed Drinks and Liquor: 2-ounce serving of liquor that can either be served on its own, over ice, or combined with a mixer. Types of liquor served include one brand each of whiskey, Scotch whiskey, vodka, rum, tequila, and gin. Regardless of whether the customer orders a mixed drink or liquor by itself, the average cost of each serving is estimated to be about $2.5.

Labor: hourly employees hired to tend the bar. The beer garden is opened from 5 to 9PM on Monday-Friday and noon to 10PM on Saturday and Sunday. 2,025 hours are estimated to be needed at an average wage of $12 per hour. The estimated working hours includes time to set up and close down the beer garden, and is based on the assumption that an average of two people will work the beer garden at any given time.

Equipment Rental: an expense paid monthly, and consisting primarily of cost associated with renting tap and refrigeration systems.

Assignment

Instructions: Please embed your answers inside the document after each question. If you are unsure about something, feel free to email me for guidance.

1. Create a flexible budget for PBW using the actual levels of activity provided above.

2. For each budgeted revenue and expense item, calculate the master budget, volume and flexible budget variances. Label each variance favorable and unfavorable.

3. Are any of the variances calculated in part 2 cause for concern? List the variances that you think are material, and provide some possible explanations for why you think these variances occurred. You do not need to provide explanations for immaterial variances, but at least some of the variances should be material.

4. PBW was able to track the actual amount, in ounces, of each beverage used. Based on the standard amounts provided above, and the actual amounts provided below, calculate the price and volume variance of each type of beverage that PBW serves.

Beverage	Actual Ounces Used
Domestic Beer	134,710
Premium Beer	76,485
Wine	47,477
Mixed Drinks and Liquor	16,109

5. Based on the material variances that you found (in part 3 and 4), provide some advice to PBW on how to reduce each unfavorable variance and (possibly) take advantage of favorable variance.

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