Question 1: Smith Inn has 120 rooms, and the occupancy from January to March were as follows: Month Number of Rooms Occupied January 2,976 February 2,352 March 3,100 A. Find the moving average for the number of rooms occupied in first three months. The moving average for the first three months: (rounded to the nearest whole number) Total Marks (I Point) B. In April, the actual number of rooms occupied was 3,162, find the three-month moving average for the number of rooms occupied. The moving average for the first three months (rounded to the nearest whole number) Total Marks (1 Point) C. In May, the actual number of rooms occupied was 2,976, find the three-month moving average for the number of rooms occupied The moving average for the first three months (rounded to the nearest whole number) Total Marks (I Point) Question 2: Carla Motel has 50 rooms, with an average room rate of $60.00 on an 82% occupancy rate. Fixed costs are $500,000 and the VC per room sold is $10.00. What will be the anticipated annual before-tax operating income be in the coming year? (assume it operates 365 days a year) Sales Revenue Variable Cost Contribution Margin Fixed Cost $500,000 Operating Income Total marks (4 Points) Question 3: Complete the following (rounded to the nearest cent): Investment Interest Rate Compounded Years PV 6% Annually SS10,000.00 10% Annually 8 $5,820.00 3% Annually 12 S493.00 7.50% Annually 3S27,893.00 11.25% Annually 20 87,236,50 2.80% Annually 11 ? 385,000.00 5% Annually 7 ? 530,563.50 13.20% Annually 18 75259,000.00 8.90% Annually 23 25752,520.00 10 4.20% Annually 15 $160,500.00 Total Marks (10 points) Question 4: Based on the information provided, determine which machine should purchased? Fill in the blanks in the table below and answer the question at the bottom. Machine A Machine Cash Cost New Equipment Purchase Cost 550,000.00 542,300.00 Estimated Life 4 years Rexidunt Value $21.000.00 $17.580.00 4 years Anmal Depreciation Savings. Wates of Staff $18,000.00 $18,000.00 Expenses Maintenance Supplies Depreciation Total Expenses $1,230.00 $1,450.00 $1,000.00 $1,100.00 2 Net Savings before income tax) Income Tax (0%) Net Annual Savings Machine A Machine B What is the average investment? What is the Accounting Rate of Return? (Rounded to the nearest whole number) What is the payback period? (Rounded to the nearest hundredth place) Which machine should be purchased? Total Marks (19 Points) Question 5: With data from the five hotels provided below, conduct a supply and demand analysis. A. Calculate the current nightly demand and the average occupancy for the five hotels Hotel Average Rooms in Hotel Avenge Occupanga Curt Nightly Dad 150 125 85 195 105 What is the average occupancy for the five hot (rounded to the nearest hundredth place) Total Marks (8 Points) B. Calculate the composite growth for each source of travellers and the total rate. Rounded to the nearest hundredth place. Source Source of Demand Camp Growth Business Travellers Convention Delegates 35% Vacations 100% Total Marks (4 points) C. Apply the composite growth rate to the demand figures to obtain projected demand for each of the next 5 years. Rounded to the nearest whole number for Composite Demand and Rooms Demand; and rounded to the nearest hundredth place for Future Growth. Compoute Demand Futunew Total Marks (Is Points) D. Assume that a 70% average room occupancy for the hotels would be profitable. Calculate the future supply of rooms that could be supported for each of the next 5 years. New Room Cement Suppl Required Normal Year Rooms Demand Owency 70% 70% 70 70% 70% Total Marks (24 points)
