\fManagerial Accounting Project 5 Flexible Budgets and Variance Analysisl 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 Penn's 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 classied 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. PBW's planning budget and actual results for 2016 are presented in the W ler PBW's planning budget includes estimated prices and volumes (qty), while the actuals provide actual volumes. Denitions of selected revenue and expense items are listed below. Items not listed are thought to be self-explanatory. Additional Denitions Domestic Beer: lG-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 sewing 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 Liguor: 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 ordeIs 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 ban 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. Eguipment Rental: an expense paid monthly, and consisting primarily of cost associated with renting tap and refrigeration systemst Assignment QUESTIONS 1-3 BASED OFF 1ST LECTURE Instructions: Please embed your answers inside the document aer each question. If you are unsure about something, feel free to email me for guidance. 1: 2: 5: Create a exible budget for PBW using the actual levels of activity provided above: For each budgeted revenue and expense item, calculate the master budget, volume and exible budget variances Label each variance favorable and unfavorable 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. 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. Use standard costing from beginning of video. USE SLmE 9-11 CALCIILATIONS*** Beverage Actual Ounces Used Domestic Beer 134,710 Premium Beer 76,485 Wine 47,477 Mixed Drinks and Liquor 16,109 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