Prepare a flexible budget for Lone Star Lodging.

2. Calculate the difference between actual and budgeted revenue and expenses (i.e. p. 2 of Standard Costs and Variance Analysis). What do you infer about performance relative to expectations? What appears to have gone favorably vs. unfavorably?

3. Calculate price and quantity variances for the following labor line items and discuss what you infer:

a. General manager

b. Front desk staff

c. Head housekeeper

d. Housekeepers

e. Maintenance wages

Please submit an excel file with your analyses listed in To Prepare above.

  

Total Front Office Pays Head Houskeeper ALS F MA 35 Table 1 Table 2 Flex Mar Apr 885 BISA Table 3 - $109,296 $95.307 $89,319 $110,414 $93,264 $116,244 $111,727 $32 69 9 Table 4- *** 1 May Jun Jul Aug 3,906 as we we $6.516 $1,583 $1,3M4 $7,198 1- HEY. ww CO DO $10.00 $28.19 $1,583 $6,475 $50.00 $34.91 $160 $136,340 $138.127 *** 2 Sep Oct Ser pa $27.99 Laney wwwww $21.26 da $107.341 $84,143 *** 32 $300 www. $160 $86,022 22. 598,222 www.www 22. $150 $1.028 97 180 $2,400 $6.000 apar 626 76 $1,116,138 1114.036 54,52 B $3,250 $1.129. 089 $26.400 $65.000 $17,412 $18,975 12.820 $227,470 Sucs 50.1 $0.15 $44.67 513.20 7.52 $8.74 $0.10