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.

  

Transcribed Image Text:

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 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

Answer rating: 100% (QA)

Here is an Excel file with the analyses you requested Lone Star Lodging Flexible Budget and Variance ... View the full answer