Question

1 Approved Answer

Posted on Jul 15, 2024

STUDY 12001. The Times Hotel has collected the following data, audit report, using the format shownin Figure 10-9 which represent the financial transactions in the

STUDY 12001. The Times Hotel has collected the following data, audit report, using the format shownin Figure 10-9 which represent the financial transactions in the (a blankworksheet for you to fill in, which follows hotel today. Assemble this information intoa night the data). DEPARTMENTAL DAILY SALES REPORT DATE Goal (%) $ Actual 299.57 500.00 1200.00 $ Budget 825.00 1500.00 1500.00 Restaurant 1 Restaurant2 Restaurant 3 SALES TAX (rate= 5%) Rest Tips 1 Rest Tips 2 Rest Tips 3 REST TIPS (rate = 15%) Room Sex 1 Room Sty 2 Room Sry 3 45.00 75.00 180.00 123.75 225.00 225.00 45.00 200.00 135.95 350.00 300.00 250.00 $Actual Call 400 20.00 9000 60.00 2719 3800 0.00 tr500 302145 0.00 12150 95000 380.00 900.00 tgao 90.00 1170.00 $5,00 200.00 40000 SALES TAX (rate = 5%) Room Sex 1 Tips Room Set 2 Tips Room Srx 3 Tips ROOM SRV TIPS (rate = 20%) Bang Bkfst Bang Lunch Bang Dinner Bang Ekfst Tips Bang Lunch Tips Bang Dinner Tips BANQ TIPS (rate = 188) Bang Bar Lunch Bang Bar Dinner ROOM RENTAL Lounge 1 Louage 2 Lounge 3 Lounge 4 Lounge Tips: Lounge Tips 2 Lounge Tips 3 Lounge Tips 4 LOUNGE TIPS (rate = 10%) VALET Tele Local Tele Long Dist GIFT SHOP SALES TAX (rate = 58) VENDING SPA PARKING Paid-outs Valet Tips Discounts Room Food 10000 165.00 346.75 25,00 120.00 1650 3468 85000 30,00 575.00 5.00 5760 4300 500 125.00 9000 125.00 150.68 753 Bebas 211.00 39750 1760 500.00 300.00 350.00 $5,00 0.00 0.00 15.00 cortiu $ ketual $ Budget Coal () 0.00 122.89 290698 12.513.56 43,900.11 7034.76 2098.63 47-279.76 75,000.00 Rooms Food Total Cash Sales Today's Ontstd.AR Yesterday's Ontstd.AR CREDIT CARD RECD AR CASH RECD AR BAL A/R ANALYSIS OF A/R City Ledger Direct Bill VISA MasterCard JCB BANK DEPOSIT Cash VISA MasterCard JCB 3078.00 5901.00 15,623.01 15540.45 7137-30 $5005.61 53532.98 $1656.69 581509 Cashier's Report ktual Amount POSAmount Difference $375421 527607 $9030.28 $3755.21 5276.07 $9031.28 $1001.12 $1406.95 $2408.07 $1002.50 1406.95 $2409-45 Shift: Cash a cd TOTAL 1 Shift2 Cash ad TOTAL 2 Shift Cash a ca TOTAL 3 TOTALS Anahsis Cash Report Cash Sls a CAR Cash AR TOTAL $250.28 $351.74 560202 $12,040.37 $250.28 $351.74 $602.02 $12.042.75 $2906.98 7034.76 209863 $12040.37 Manager's Report Budget Difference 0 Actual 125 60 65 85 ROOMS AVAIL ROOMS SOLD ROOMS VAC ROOMS 000 ROOMS COMP ROOM INCOME ROOM TAX NO. GUESTS RACK RATE NO-SHOWS BANK DEPOSIT 54500.00 $180.00 93 $80.00 $ 900.00 S90.00 95 $80.00 0 $3000.00 $300.00 2 $0.00 0 1 ANALYSIS OF BANK DEPOSIT Cash VISA MasterCard $5005.61 $3532.98 $1656.69 Total Cash Sales Credit Card Rec'dAR Cash Rec'dA/R JOB $184509 $2906.98 7034.76 209863 $12,040.37 FIGURE 10-9 Times Hotel night audit. Night Audit Date $ Actual Goal(s) ROOM TAX Restaurant 1 Restaurant 2 Restaurants TOTAL REST SALES SALES TAX Rest Tips: Rest Tips 2 Rest Tips 3 TOTAL REST TIPS Room Sex 1 Room Sex 2 Room Sex 3 TOTAL ROOM SRV $ Budget 7500.00 750.00 825.00 1500.00 1500.00 3825.00 191.25 123.75 225.00 225.00 573-75 350.00 300.00 250.00 900.00 continues FIGURE 10-4 (continued) $ Actual Goal (6) SALES TAX Room Sex : Tips Room Sex 2 Tips Room Sex 3 Tips TOTAL ROOM SRV TIPS Bang Bkfst Bang Lunch Bang Dinner TOTAL BANQ Bang Bkfst Tips Bang Lunch Tips Bang Dinner Tips TOTAL BANQ TIPS Bang Bar Lunch Bang Bar Dinner TOTAL BANQ BAR ROOM RENTAL Lounge : Lounge 2 Lounge 3 Lounge 4 TOTAL LOUNGE SALES Lounge Tips: Lounge Tips 2 Lounge Tips3 Lounge Tips4 TOTAL LOUNGE TIPS $ Budget 4500 70.00 60.00 30.00 180.00 350.00 500.00 650000 7350.00 63.00 90.00 1170.00 1323.00 200.00 400.00 600.00 250.00 85,00 950.00 450.00 575.00 2000.00 850 95.00 4500 57.50 20600 250.00 125.00 300.00 425.00 350.00 17.50 100.00 500.00 350.00 27,74650 VALET Tele Local Tele Long Distance TOTAL PHONE GIFT SHOP GIFT SHOP SALES TAX VENDING SPA PARKING TOTAL REVENUE Less Paid-outs Valet Tips TOTAL PAID-OUTS $Actual $ Budget Goal () Less Discounts Room Food TOTAL DISCOUNTS Less Write-offs Rooms Food TOTAL WRITE-OFFS Total Paid out and Noncollect Sales Total Cash Sales Today's Outstd.AR Total Revenue Yesterday's Outstd.AR TOTAL OUTSTDAR CREDIT CARD REC'DA/R Cash Rec'dAR BALAR ANALYSIS OF A/R City Ledger Direct Bill VISA MasterCard JCB Total AR BANK DEPOSIT Cash VISA MasterCard JCB TIL BANK DEP AMT TRAR Cashier's Report 75,000.00 ANALYSIS OF BANK DEPOSIT Total Cash Sales Credit Card Rec'dAR Cash Rec'dA/R III Atual Amount POS Amount Difference Cash a cd TOTAL: Shift2 Cash a cd TOTAL 2 FIGURE 10-9 (continued) Cashier's Report Actual Amount POS Amount Difference Shift 3 Cash Cr Ca TOTAL 3 TOTALS Analysis Cash Report Cash Sls Cr Cd A/R Cash A/R TOTAL Manager's Report Actual Budget Difference ROOMS AVAIL ROOMS SOLD ROOM VAC ROOMS 000 ROOMS COMP OCC % DBL OCC % YIELD % REVPAR ROOM INC NO. GUESTS AV. RATE RACK RATE NO-SHOWS STUDY 12001. The Times Hotel has collected the following data, audit report, using the format shownin Figure 10-9 which represent the financial transactions in the (a blankworksheet for you to fill in, which follows hotel today. Assemble this information intoa night the data). DEPARTMENTAL DAILY SALES REPORT DATE Goal (%) $ Actual 299.57 500.00 1200.00 $ Budget 825.00 1500.00 1500.00 Restaurant 1 Restaurant2 Restaurant 3 SALES TAX (rate= 5%) Rest Tips 1 Rest Tips 2 Rest Tips 3 REST TIPS (rate = 15%) Room Sex 1 Room Sty 2 Room Sry 3 45.00 75.00 180.00 123.75 225.00 225.00 45.00 200.00 135.95 350.00 300.00 250.00 $Actual Call 400 20.00 9000 60.00 2719 3800 0.00 tr500 302145 0.00 12150 95000 380.00 900.00 tgao 90.00 1170.00 $5,00 200.00 40000 SALES TAX (rate = 5%) Room Sex 1 Tips Room Set 2 Tips Room Srx 3 Tips ROOM SRV TIPS (rate = 20%) Bang Bkfst Bang Lunch Bang Dinner Bang Ekfst Tips Bang Lunch Tips Bang Dinner Tips BANQ TIPS (rate = 188) Bang Bar Lunch Bang Bar Dinner ROOM RENTAL Lounge 1 Louage 2 Lounge 3 Lounge 4 Lounge Tips: Lounge Tips 2 Lounge Tips 3 Lounge Tips 4 LOUNGE TIPS (rate = 10%) VALET Tele Local Tele Long Dist GIFT SHOP SALES TAX (rate = 58) VENDING SPA PARKING Paid-outs Valet Tips Discounts Room Food 10000 165.00 346.75 25,00 120.00 1650 3468 85000 30,00 575.00 5.00 5760 4300 500 125.00 9000 125.00 150.68 753 Bebas 211.00 39750 1760 500.00 300.00 350.00 $5,00 0.00 0.00 15.00 cortiu $ ketual $ Budget Coal () 0.00 122.89 290698 12.513.56 43,900.11 7034.76 2098.63 47-279.76 75,000.00 Rooms Food Total Cash Sales Today's Ontstd.AR Yesterday's Ontstd.AR CREDIT CARD RECD AR CASH RECD AR BAL A/R ANALYSIS OF A/R City Ledger Direct Bill VISA MasterCard JCB BANK DEPOSIT Cash VISA MasterCard JCB 3078.00 5901.00 15,623.01 15540.45 7137-30 $5005.61 53532.98 $1656.69 581509 Cashier's Report ktual Amount POSAmount Difference $375421 527607 $9030.28 $3755.21 5276.07 $9031.28 $1001.12 $1406.95 $2408.07 $1002.50 1406.95 $2409-45 Shift: Cash a cd TOTAL 1 Shift2 Cash ad TOTAL 2 Shift Cash a ca TOTAL 3 TOTALS Anahsis Cash Report Cash Sls a CAR Cash AR TOTAL $250.28 $351.74 560202 $12,040.37 $250.28 $351.74 $602.02 $12.042.75 $2906.98 7034.76 209863 $12040.37 Manager's Report Budget Difference 0 Actual 125 60 65 85 ROOMS AVAIL ROOMS SOLD ROOMS VAC ROOMS 000 ROOMS COMP ROOM INCOME ROOM TAX NO. GUESTS RACK RATE NO-SHOWS BANK DEPOSIT 54500.00 $180.00 93 $80.00 $ 900.00 S90.00 95 $80.00 0 $3000.00 $300.00 2 $0.00 0 1 ANALYSIS OF BANK DEPOSIT Cash VISA MasterCard $5005.61 $3532.98 $1656.69 Total Cash Sales Credit Card Rec'dAR Cash Rec'dA/R JOB $184509 $2906.98 7034.76 209863 $12,040.37 FIGURE 10-9 Times Hotel night audit. Night Audit Date $ Actual Goal(s) ROOM TAX Restaurant 1 Restaurant 2 Restaurants TOTAL REST SALES SALES TAX Rest Tips: Rest Tips 2 Rest Tips 3 TOTAL REST TIPS Room Sex 1 Room Sex 2 Room Sex 3 TOTAL ROOM SRV $ Budget 7500.00 750.00 825.00 1500.00 1500.00 3825.00 191.25 123.75 225.00 225.00 573-75 350.00 300.00 250.00 900.00 continues FIGURE 10-4 (continued) $ Actual Goal (6) SALES TAX Room Sex : Tips Room Sex 2 Tips Room Sex 3 Tips TOTAL ROOM SRV TIPS Bang Bkfst Bang Lunch Bang Dinner TOTAL BANQ Bang Bkfst Tips Bang Lunch Tips Bang Dinner Tips TOTAL BANQ TIPS Bang Bar Lunch Bang Bar Dinner TOTAL BANQ BAR ROOM RENTAL Lounge : Lounge 2 Lounge 3 Lounge 4 TOTAL LOUNGE SALES Lounge Tips: Lounge Tips 2 Lounge Tips3 Lounge Tips4 TOTAL LOUNGE TIPS $ Budget 4500 70.00 60.00 30.00 180.00 350.00 500.00 650000 7350.00 63.00 90.00 1170.00 1323.00 200.00 400.00 600.00 250.00 85,00 950.00 450.00 575.00 2000.00 850 95.00 4500 57.50 20600 250.00 125.00 300.00 425.00 350.00 17.50 100.00 500.00 350.00 27,74650 VALET Tele Local Tele Long Distance TOTAL PHONE GIFT SHOP GIFT SHOP SALES TAX VENDING SPA PARKING TOTAL REVENUE Less Paid-outs Valet Tips TOTAL PAID-OUTS $Actual $ Budget Goal () Less Discounts Room Food TOTAL DISCOUNTS Less Write-offs Rooms Food TOTAL WRITE-OFFS Total Paid out and Noncollect Sales Total Cash Sales Today's Outstd.AR Total Revenue Yesterday's Outstd.AR TOTAL OUTSTDAR CREDIT CARD REC'DA/R Cash Rec'dAR BALAR ANALYSIS OF A/R City Ledger Direct Bill VISA MasterCard JCB Total AR BANK DEPOSIT Cash VISA MasterCard JCB TIL BANK DEP AMT TRAR Cashier's Report 75,000.00 ANALYSIS OF BANK DEPOSIT Total Cash Sales Credit Card Rec'dAR Cash Rec'dA/R III Atual Amount POS Amount Difference Cash a cd TOTAL: Shift2 Cash a cd TOTAL 2 FIGURE 10-9 (continued) Cashier's Report Actual Amount POS Amount Difference Shift 3 Cash Cr Ca TOTAL 3 TOTALS Analysis Cash Report Cash Sls Cr Cd A/R Cash A/R TOTAL Manager's Report Actual Budget Difference ROOMS AVAIL ROOMS SOLD ROOM VAC ROOMS 000 ROOMS COMP OCC % DBL OCC % YIELD % REVPAR ROOM INC NO. GUESTS AV. RATE RACK RATE NO-SHOWS