Question

Problem 10: Browny Brad’s Beach Motel (BBBM), a forty-room lodging facility, has operated for the past three years. BBBM’s night auditor has kept accurate records over the past year but has not analyzed any of these data. The following is a summary of the rooms sold by month: Rooms sold: January 400 March 700 May 960 February 600 April 840 June 980 July. 992 September 800 November 650 August. 973 October 705 December 500 Assume that the motel is open 365 days per year for business purposes and that the motel considers its “summer months” to be May, June, July, and August. The off-season comprises of all other months. Required: Determine the Paid Occupancy percentage for the summer months, the off-season, and the entire year?

Answer 1

Month	No of Rooms Occupied during month	No Of Days occupancy each month
Jan	400	10.00
Mar	700	17.50
May	960	24.00
Feb	600	15.00
April	840	21.00
June	980	24.50
July	922	23.05
sep	800	20.00
Nov	650	16.25
Aug	973	24.33
Oct	705	17.63
Dec	500	12.50
	9030	225.75
1. Summer Months
Total No of Working Days'		123.00
Total Occupancy		95.88
% Occupancy		77.95
2. Off Season
Other than Summer Month		242.00
Total Occupancy		129.88
% Occupancy		53.67
3.Entire Year
Total Working days		365
Total Occupancy		225.75
% Occupancy		61.85