On excel , and please explain how did you get the number by formulas..

1.sales budget

2. Cash collection

3 purchases budget

4 cash disbursements

5 operating expense budget

6. Cash buget

Advanced Managerial Accounting Budgeting Project Background Information Provided by Your Client: Four Seasons has a hotel in South Carolina. For this hotel, management expects occupancy rates to 95% in December, January and February: 85% in November, March and April; and 70% the rest of the year. This hotel has 325 rooms and the room rental is $250.00 per night of this, on average 10% is received as a deposit the month before the stay, 60% is received in the month of the stay, an d 28% is collected the month after. The remaining 2% is never collected. Most of the costs of running the hotel are fixed. The variable costs are only $30.00 per occup ed room, per night. Fixed salaries (including benefits) run $400,000 per month, depreciation is $350,000 a mon th, other fixed costs are $120,000 per month, and interest expense is $600,000 per month. Variable costs and salaries are paid in the month they are incurred, depreciation is recorded at the end of eac quarter, other fixed costs and salaries are paid in the month they are incurred, and interest is p aid semi- annually each June and December. Client's Concern: The client is aware that net income does not equal cash flow and wants to make sure that the business will generate enough cash to meet all of its obligations. Project Part 1: The client wants your accounting firm to prepare a monthly cash budget for this Four Seasons hotel for the entire year. For simplicity, assume that there are 30 days in each month