The Times Hotel has collected the following data, which represent the financial transactions in the hotel today. Assemble this information into a night audit report, using the format shown in Figure 10-9 (a blank worksheet for you to fill in, which follows the data). DEPARTMENTAL DAILY SALES REPORT DATE Atual Budget 8a50e 399.57 500.00 2500.00 Restaurant Restaurant Restaurants SALES TAX (rates) Rest Tips Rest Tips 2 Restips 3 REST TIPS (rate15) Room Seri Room Seva Room 45.00 75.00 123.75 225.00 200.00 $ Actual Budget Goal (%) 0. 001.00 50.00 SALES TAX (rates) Room Svi Tipe 9.00 Room Seva Tipe 40.00 Room Tips 7.19 ROOM SRV TIPS (rate 30N) Bang Bidst 0.00 Berganch 695.00 Bang Dim 02145 Rang Lanch Tip 11.50 Bang Dinner Tips 543.85 BANQ TIPS (rule) Bang Bar Lunch 85.00 Bang Bar Die 5.95 ROOM RENTAL 100.00 Lange 165.00 Luma 346.75 350.00 500.00 6900.00 63.00 90.00 1170.00 200.00 250.00 950.00 $ Actual $ Budget Goal (%) 70.00 60.00 50.00 350.00 500.00 6500.00 63.00 1170.00 2001400 250,00 $5.00 SALES TAX (rate=5%) Room Srv Tips 9.00 Room Seva Tip 40.00 Room Sy 3 Tipe 2019 ROOM SRV TIPS (rate=20%) Bang Bkst 0.00 Bang Lunch 695.00 Rang Die 1.45 Bam Tips 0.00 Bang lunch Tie 191.50 Bang Dinner Tips $13.8% RANQ TIPS (rate-18) Bang Bar Lunch 5.00 Bang Bar Die 5.95 ROOM RENTAL 100.00 Lounge 1 165.00 Long> 346-75 Lounge 3 295.00 Longe 4 420,00 Long Tips 16.30 LoungeTis 2346 Lounge Tips 29.50 Le Tips 4 42.00 LOUNGE TIPS (rate -10%) VALET 4500 Tele Local 125.00 Teleg 87,00 GIFT SHOP 150.66 SALES TAX (rate -5%) 783 VENDING 1.25 SPA 21.00 PARKING 397.39 575.00 830 95.00 59.50 125.00 300.00 350.00 300.00 500.00 Valet R500 Tips 0.00 Discounts Room 000 Food 15.00 (continues) Budget Geal() Write-offs Rooms Food Total Cash Sales Today's OutdA/R Yesterday's Outstd A/ CREDIT CARD RECAR CASH RCDAR BALAR ANALYSIS OF AR City Lediger Dirst Bill 122.89 0906.98 12.513.56 43.900.11 2098.63 47.279.96 75.000.00 3078.00 1901.00 LOMANTEL 3:42 PM 75% CASESTUDY10 O... 000 122.89 290698 19.519.56 7034.76 2098. Writet Rooms Food Total Cash Soler Today Out AR Yesterday's Out AR CREDIT CARD RECAR CASEIRECD AR BALAR ANALYSES OF A/R City Ledger Direct ITI VISA MasterCard JCB BANK DEPOSIT Cash VISA MasterCard 907.00 301.00 15.623.02 15.540.45 713730 $500561 8353248 $1656.64 $184509 Cashier's Report Actual Amount PosAmount Difference Shih $875.21 God TOTAL $3754 5270/07 $90 Shia Cash $1002.50 004 TOTAL $1001.12 $1406.05 $9408.417 $9409-45 $290.28 S1194 3600.00 1.045 CCM TOTAL $60.00 TOTALS $12.00 37 Analysis Cash Report Cashle CHCIAR 2034.76 Cash AR 20963 TOTAL $12.00:37 Manager's Report Difference Actual 125 60 65 O Bude 25 85 40 0 HOONES AVAIL ROOMS SOLD ROOMS VAC ROOMS 000 ROOMS COMP ROOM INCOME ROOM TAX NO, GUESTS $500.00 $7500.00 $750.00 95 0 0.00 0.00 93 $12,042,75 TOTALS Analysis Cash Report Cash CrOS AR Cash AR TOTAL $12,040 37 52906. 7034.76 2098.63 Manager's Report Actual Budget Difference BOOSES AVAIL 125 15 ROOMS SOLD 60 85 ROOMS VAC 65 ROOMS 000 0 ROOMS COMP ROOM INCOME $4500.00 $7800.00 000.00 ROOM TAX S. NO, GUESTS 95 2 RACK RATE $80.00 $80.00 $0.00 NO-SHOWS 1 0 BANK DEPOSIT ANALYSIS OF BANK DEPOSIT VISA $352,98 Mastercard $15. JCB $1845.00 Total Cash Sale $90065 Credit Card RNR 234.76 Cath Reed A/R 2098.69 $12,040,37 FIGURE 10-3 Times Hotell night audit. Date Night Audit 3 Actual Goal ( 7500.00 TAX Restaurant Restaurant Restaurants TOTAL REST SALES SALES TAX 1995 Rest Tips 123.75 Rest Tipsa 225.00 Rest Tips 3 225.00 TOTAL REST TIPS 573-75 FIGURE 105 Times Hotel night audit Night Audit Actual Budget Goal (*) ROOM TAX Restaurant 825.00 Restaurant 1500 Restaurants 1500.00 TOTAL REST SALES 3825.00 SALES TAX 1912 Rest Tips 123.75 Rest Tips 2 225.00 Rest Tips 225.00 TOTAI. REST TIPS Room Sers 390.00 Room Srv 2 Room Sev TOTAL ROOM SRV (continues) FIGURE 10-9 Actual Budget (continued Goal() SALES TAX Room Srv Tipe . Room Brya Tips 60.00 Home 3 Tip TOTAL ROOM SRV TIPS 0.000 Rach FIGURE 10- Actual Badpet 45.00 continued) Goal () SALES TAX Room Srv 1 Tips . Room Sra Tips 60.00 Room Srv Tipe 30.000 TOTAL ROOM SRY TIPS B.00 Ranglist 390.00 Rang Launch 500.00 Bang Dinner 6900.00 TOTAL RANO Bang BL Tips Bang Lunch Tipe 90.00 Bang Dinner Tipe TOTAL RANO TIPS Bang Bar Lumeh 300.00 Bang Bar Diner 400.00 TOTAL HANG HAR 600.00 ROOM RENTAL Lounge 5.00 La 950.00 Los 49. Low 575.00 TOTAL LOUNGE SALES 2000.00 Lounge Tips 8.50 Lounge Tips 95.00 Lang Ly 45.00 Lounge Tips 57.50 TOTAL LOUNGE TIPS 206.00 VALET 2. Tele La Lounge Lounge 40.00 575.00 TOTAL LOUNGE SALES 2000.00 8.50 Lounge Tips Lounge Tips Lounge 45.00 Lounge Tips 57.50 TOTAL LOUNGE TIPS 206.00 VALET 20.00 Tele Local 125.00 Tele Long Distance 300.00 TOTAL PHONE 25 GIFT SHOP 350.00 GIFT SHOP SALES TAX 17.90 VENDING SPA 500.00 PARKING TOTAL REVENUE 22.946.90 Les Paidos Valet TOTAL PAID-OUTS FIGURE 10-9 (continued) Actual Bugetal Les Discounts Food TOTAL DISCOUNTS Le Writeti FIGURE 166 (continued Actual Budget Goal) La Do Room TOTAL DISCOUNTS Less Write-offs Room Food TOTAL WRITE-OFFS Total Paid-out and Noncollert Sales Total Cash Sales Today's Outsi/ Total Revende Yesterday's Out TOTAL OUTSID AR CREDIT CARD RECD /R Cash Red 75.000.00 BALAR ANALYSIS OF A/R City Ledger Direct in - VISA MasterCard JCB Total / ANALYSIS OF BANK DEPOSIT Total C Sales Credit Card RedAR Cash Red BANK DEPOSIT Cash VISA MasterCard JCR TTL BANK DEP AMT TRAR Cashier's Report Actualment POSA Derence Shit Cash Crcd ANALYSIS OF BANK DEPOSIT Total Cash Sales Credit Card Read Cash Red BANK DEPOSIT Cash VISA MasterCard JCB TIL BANK DEP AMIT TXAR Cashier's Report Actual Amount POS Amount Difference Shift Cash cca TOTAL1 Shift a Cash CYCH TOTAL (continues) FIGURE 30- (continued) Cashier's Report Actual Amount POS Amount Difference Shis CYCH TOTAL 3 TOTALS Analysie Cash Report Cash COLAR Cu AR TOTAL Manager's Report Actual Budget Difference ROOMS AVAIL ROOMS SOLD ROOSEVAC ROOMS 000 ROOMS COMP OOC DRLOCC (continues) FIGURE 10- (continued) Cashier's Report Actuat Amount POS Amount Difference Shits Crcd TOTALS TUTALS Analysis Cash Report Ch CYCONR Cash AR TOTAL Manager's Report Actu Budget Difference ROOMS AVAIL ROOMS SOLD) ROOM VAC ROOMSOOO ROOMS COMP OOC DBLOCC YIELD KEVPAR ROOMING NO, GUESTS AV. RATE ILACK KATH NO-SHOWS The Times Hotel has collected the following data, which represent the financial transactions in the hotel today. Assemble this information into a night audit report, using the format shown in Figure 10-9 (a blank worksheet for you to fill in, which follows the data). DEPARTMENTAL DAILY SALES REPORT DATE Atual Budget 8a50e 399.57 500.00 2500.00 Restaurant Restaurant Restaurants SALES TAX (rates) Rest Tips Rest Tips 2 Restips 3 REST TIPS (rate15) Room Seri Room Seva Room 45.00 75.00 123.75 225.00 200.00 $ Actual Budget Goal (%) 0. 001.00 50.00 SALES TAX (rates) Room Svi Tipe 9.00 Room Seva Tipe 40.00 Room Tips 7.19 ROOM SRV TIPS (rate 30N) Bang Bidst 0.00 Berganch 695.00 Bang Dim 02145 Rang Lanch Tip 11.50 Bang Dinner Tips 543.85 BANQ TIPS (rule) Bang Bar Lunch 85.00 Bang Bar Die 5.95 ROOM RENTAL 100.00 Lange 165.00 Luma 346.75 350.00 500.00 6900.00 63.00 90.00 1170.00 200.00 250.00 950.00 $ Actual $ Budget Goal (%) 70.00 60.00 50.00 350.00 500.00 6500.00 63.00 1170.00 2001400 250,00 $5.00 SALES TAX (rate=5%) Room Srv Tips 9.00 Room Seva Tip 40.00 Room Sy 3 Tipe 2019 ROOM SRV TIPS (rate=20%) Bang Bkst 0.00 Bang Lunch 695.00 Rang Die 1.45 Bam Tips 0.00 Bang lunch Tie 191.50 Bang Dinner Tips $13.8% RANQ TIPS (rate-18) Bang Bar Lunch 5.00 Bang Bar Die 5.95 ROOM RENTAL 100.00 Lounge 1 165.00 Long> 346-75 Lounge 3 295.00 Longe 4 420,00 Long Tips 16.30 LoungeTis 2346 Lounge Tips 29.50 Le Tips 4 42.00 LOUNGE TIPS (rate -10%) VALET 4500 Tele Local 125.00 Teleg 87,00 GIFT SHOP 150.66 SALES TAX (rate -5%) 783 VENDING 1.25 SPA 21.00 PARKING 397.39 575.00 830 95.00 59.50 125.00 300.00 350.00 300.00 500.00 Valet R500 Tips 0.00 Discounts Room 000 Food 15.00 (continues) Budget Geal() Write-offs Rooms Food Total Cash Sales Today's OutdA/R Yesterday's Outstd A/ CREDIT CARD RECAR CASH RCDAR BALAR ANALYSIS OF AR City Lediger Dirst Bill 122.89 0906.98 12.513.56 43.900.11 2098.63 47.279.96 75.000.00 3078.00 1901.00 LOMANTEL 3:42 PM 75% CASESTUDY10 O... 000 122.89 290698 19.519.56 7034.76 2098. Writet Rooms Food Total Cash Soler Today Out AR Yesterday's Out AR CREDIT CARD RECAR CASEIRECD AR BALAR ANALYSES OF A/R City Ledger Direct ITI VISA MasterCard JCB BANK DEPOSIT Cash VISA MasterCard 907.00 301.00 15.623.02 15.540.45 713730 $500561 8353248 $1656.64 $184509 Cashier's Report Actual Amount PosAmount Difference Shih $875.21 God TOTAL $3754 5270/07 $90 Shia Cash $1002.50 004 TOTAL $1001.12 $1406.05 $9408.417 $9409-45 $290.28 S1194 3600.00 1.045 CCM TOTAL $60.00 TOTALS $12.00 37 Analysis Cash Report Cashle CHCIAR 2034.76 Cash AR 20963 TOTAL $12.00:37 Manager's Report Difference Actual 125 60 65 O Bude 25 85 40 0 HOONES AVAIL ROOMS SOLD ROOMS VAC ROOMS 000 ROOMS COMP ROOM INCOME ROOM TAX NO, GUESTS $500.00 $7500.00 $750.00 95 0 0.00 0.00 93 $12,042,75 TOTALS Analysis Cash Report Cash CrOS AR Cash AR TOTAL $12,040 37 52906. 7034.76 2098.63 Manager's Report Actual Budget Difference BOOSES AVAIL 125 15 ROOMS SOLD 60 85 ROOMS VAC 65 ROOMS 000 0 ROOMS COMP ROOM INCOME $4500.00 $7800.00 000.00 ROOM TAX S. NO, GUESTS 95 2 RACK RATE $80.00 $80.00 $0.00 NO-SHOWS 1 0 BANK DEPOSIT ANALYSIS OF BANK DEPOSIT VISA $352,98 Mastercard $15. JCB $1845.00 Total Cash Sale $90065 Credit Card RNR 234.76 Cath Reed A/R 2098.69 $12,040,37 FIGURE 10-3 Times Hotell night audit. Date Night Audit 3 Actual Goal ( 7500.00 TAX Restaurant Restaurant Restaurants TOTAL REST SALES SALES TAX 1995 Rest Tips 123.75 Rest Tipsa 225.00 Rest Tips 3 225.00 TOTAL REST TIPS 573-75 FIGURE 105 Times Hotel night audit Night Audit Actual Budget Goal (*) ROOM TAX Restaurant 825.00 Restaurant 1500 Restaurants 1500.00 TOTAL REST SALES 3825.00 SALES TAX 1912 Rest Tips 123.75 Rest Tips 2 225.00 Rest Tips 225.00 TOTAI. REST TIPS Room Sers 390.00 Room Srv 2 Room Sev TOTAL ROOM SRV (continues) FIGURE 10-9 Actual Budget (continued Goal() SALES TAX Room Srv Tipe . Room Brya Tips 60.00 Home 3 Tip TOTAL ROOM SRV TIPS 0.000 Rach FIGURE 10- Actual Badpet 45.00 continued) Goal () SALES TAX Room Srv 1 Tips . Room Sra Tips 60.00 Room Srv Tipe 30.000 TOTAL ROOM SRY TIPS B.00 Ranglist 390.00 Rang Launch 500.00 Bang Dinner 6900.00 TOTAL RANO Bang BL Tips Bang Lunch Tipe 90.00 Bang Dinner Tipe TOTAL RANO TIPS Bang Bar Lumeh 300.00 Bang Bar Diner 400.00 TOTAL HANG HAR 600.00 ROOM RENTAL Lounge 5.00 La 950.00 Los 49. Low 575.00 TOTAL LOUNGE SALES 2000.00 Lounge Tips 8.50 Lounge Tips 95.00 Lang Ly 45.00 Lounge Tips 57.50 TOTAL LOUNGE TIPS 206.00 VALET 2. Tele La Lounge Lounge 40.00 575.00 TOTAL LOUNGE SALES 2000.00 8.50 Lounge Tips Lounge Tips Lounge 45.00 Lounge Tips 57.50 TOTAL LOUNGE TIPS 206.00 VALET 20.00 Tele Local 125.00 Tele Long Distance 300.00 TOTAL PHONE 25 GIFT SHOP 350.00 GIFT SHOP SALES TAX 17.90 VENDING SPA 500.00 PARKING TOTAL REVENUE 22.946.90 Les Paidos Valet TOTAL PAID-OUTS FIGURE 10-9 (continued) Actual Bugetal Les Discounts Food TOTAL DISCOUNTS Le Writeti FIGURE 166 (continued Actual Budget Goal) La Do Room TOTAL DISCOUNTS Less Write-offs Room Food TOTAL WRITE-OFFS Total Paid-out and Noncollert Sales Total Cash Sales Today's Outsi/ Total Revende Yesterday's Out TOTAL OUTSID AR CREDIT CARD RECD /R Cash Red 75.000.00 BALAR ANALYSIS OF A/R City Ledger Direct in - VISA MasterCard JCB Total / ANALYSIS OF BANK DEPOSIT Total C Sales Credit Card RedAR Cash Red BANK DEPOSIT Cash VISA MasterCard JCR TTL BANK DEP AMT TRAR Cashier's Report Actualment POSA Derence Shit Cash Crcd ANALYSIS OF BANK DEPOSIT Total Cash Sales Credit Card Read Cash Red BANK DEPOSIT Cash VISA MasterCard JCB TIL BANK DEP AMIT TXAR Cashier's Report Actual Amount POS Amount Difference Shift Cash cca TOTAL1 Shift a Cash CYCH TOTAL (continues) FIGURE 30- (continued) Cashier's Report Actual Amount POS Amount Difference Shis CYCH TOTAL 3 TOTALS Analysie Cash Report Cash COLAR Cu AR TOTAL Manager's Report Actual Budget Difference ROOMS AVAIL ROOMS SOLD ROOSEVAC ROOMS 000 ROOMS COMP OOC DRLOCC (continues) FIGURE 10- (continued) Cashier's Report Actuat Amount POS Amount Difference Shits Crcd TOTALS TUTALS Analysis Cash Report Ch CYCONR Cash AR TOTAL Manager's Report Actu Budget Difference ROOMS AVAIL ROOMS SOLD) ROOM VAC ROOMSOOO ROOMS COMP OOC DBLOCC YIELD KEVPAR ROOMING NO, GUESTS AV. RATE ILACK KATH NO-SHOWS
