Question Completion Status: Breakfast Bar Variance Analysis Actual For U Price/Variable Cost per Results Flexible Budget Variance Flexible Budget Sales Volume Variance For U Static Budget Guest Guests 26,280 Served 21.353 Revenue $256,230.00 $341.640.00 Variable Costs Food $84,556.00 Server $43,800.00 Labour Kitchen Labour $56.940.00 Total Variable $185.296.00 Costs Contribution Margin $70.934.00 Fixed Costs Utilities $6,500.00 N/A N/A $6,000.00 Supervisor 542,000.00 N/A N/A $40,000.00 Income from $22.434.00 Operations Part B: Remember to use a negative sign if your variance is unfavourable. The Revenue Price Variance is this is a (Enter F for Favourable and U for Unfavourable) Variance. The Revenue Quantity Variance is this is a (Enter F for Favourable and U for Unfavourable) Variance. Click Save and Submit to save and submit. Click Save All Answers to save all answers.Question Completion Status; QUESTION 1 You have just been appointed General Manager of Spatial Suites, a small boutique hotel situated outside the downtown core of a major city. Spatial has 19 guest rooms and a small 42-seat cafe that serves breakfast only, called the Breakfast Bar. The Breakfast Bar has not been performing very well over the past few years and Sarah, the owner has asked you to determine why the results were not as planned in the prior year. She has asked you to prepare a Breakfast Bar Analysis. The Breakfast bar is open to Hotel guests and the public 7 days a week. The restaurant manager budgeted sales of $341,640.00 and 26,280 guests. The Chef is responsible for maintaining a 319% food cost. Server labour was budgeted at $48,180.00 and kitchen labour at $43,800.00. That require 2 servers everyday for 6 hours and 2 cooks everyday for 5 hours. The only costs incurred are utilities budgeted at $6,000.00 and the supervisor's salary of $40,000.00 Prepare a Flexible Budget Analysis for the Breakfast Bar for the Year, Fill in the the blanks as shown in the example below. Use the same formatting instructions from Question # 1 (Rounding dollar Values up or down to .00) with the exception for Price/Variable Cost per Unit. Notice the negative number in front of the $ sign in the variance column if needed. For that you must round to 2 decimal places. Use a capital F and Capital U to indicate Favourable or Unfavourable results. Example: Static Budget Actual results Flexible Budget Variance Flexible Budget|Sales Volume Variance Price/variable cost per guest Item $92,071.00 $1,627.00 $93,699.00 $21,622.00 $115 322.48 $4.03 Part A: Complete the Analysis by filling the blanks below. Breakfast Bar Variance Analysis Actual Sales Volume Variance For U Static Budget Results Flexible Budget Variance For U Flexible Budget Price/Variable Cost per Guest Guests 21,353 26,280 Served Revenue $256,230.00 $341,640.00 Variable Costs Food $84,556.00 Server $ Labour $43,800.00 Kitchen Labour $56,940.00