An asset costs $490,000 and has an estimated salvage value of $40,000 after its 7-year depreciable life. Using the Sum-of-Years' Digits depreciation, the book value after depreciation is taken in year 2 is closest to...

Transcribed Image Text:

Chapter 10 Forecasting: A Very Important Management Tool 23 Problem Set 2 25 Points Week 3 of Period 1 Another Busy Week This problem set is worth 25 points and can be done individually or in a group. Follow the same steps as in fore- casting the second week. Following are the changes to be used in forecasting the third week: 1. Begin with the first week rooms sold forecast. All changes will be made to those numbers. 2. Increase the third weeks rooms sold forecast as follows: A. Increase weekday transient room reservations 30 per day. B. Increase weekday transient pickup reservations 15 per day. C. Increase weekend transient room reservations 20 per day. D. Increase weekend transient pickup reservations 10 per day. 3. Third week group room blocks are as follows: x 297 Sat Sun Mon Tue Wed Thurs Fri Total Definite #1 20 40 40 40 140 group # 2 30 30 20 80 Tentative #1 40 40 40 20 140 group 70 40 180 # 2 70 4. Complete the total rooms sold forecasting worksheet. 5. Enter the Week 3 rooms sold from the rooms sold worksheet onto the Week 3 room revenue forecasting worksheet. 6. Use the same daily average rates as Week 1 for both the transient and group rooms sold. 7. Calculate the total room revenue by day for Week 3 and complete the Week 3 room revenue forecasting worksheet. the daily and weekly totals from the room revenue forecasting worksheet. Turn ROOMS SOLD FORECASTING WORKSIET 25-POINT PROBLEM SIT WEEK 1 PERSOD Oet MARKET SEGMENT tridaat Satunda Sunday Monday Tesday Wdnesday Thunday Edday Tutal TRANSBNT ROOMS Meervati Booked ervation Pickup Toal Transent Nava GROUP OKOMS Definite Gup Definite Group 2 Tentative Goup Tentative Ciroup 2 Tetal Group Ramervation TOTAL ROOM RESERVATIONS OCCUPANCY PERCENTAGE Check-Ins Check-Outs KOOM REVENUEFORECANTING WORKSHEEY 25-POINT PROBLEM SET WEEK PERIOD MARKET SEGMENT Eriday Saturday Sunday Monday Tuesday Wednesday Thurnday Eriday Total TRANSIENT REVENUE Rooms Sold Average Rate Total Transient Revenue GROUP REVENUE Rooms Sold Average Rate Total Group Revenue TOTAL REVENUE Total Rooms Sold Occupancy Percentage Average Rate Total Room Revenue Indes 297 Chapter 10 Forecasting: A Very Important Management Tool 23 Problem Set 2 25 Points Week 3 of Period 1 Another Busy Week This problem set is worth 25 points and can be done individually or in a group. Follow the same steps as in fore- casting the second week. Following are the changes to be used in forecasting the third week: 1. Begin with the first week rooms sold forecast. All changes will be made to those numbers. 2. Increase the third weeks rooms sold forecast as follows: A. Increase weekday transient room reservations 30 per day. B. Increase weekday transient pickup reservations 15 per day. C. Increase weekend transient room reservations 20 per day. D. Increase weekend transient pickup reservations 10 per day. 3. Third week group room blocks are as follows: x 297 Sat Sun Mon Tue Wed Thurs Fri Total Definite #1 20 40 40 40 140 group # 2 30 30 20 80 Tentative #1 40 40 40 20 140 group 70 40 180 # 2 70 4. Complete the total rooms sold forecasting worksheet. 5. Enter the Week 3 rooms sold from the rooms sold worksheet onto the Week 3 room revenue forecasting worksheet. 6. Use the same daily average rates as Week 1 for both the transient and group rooms sold. 7. Calculate the total room revenue by day for Week 3 and complete the Week 3 room revenue forecasting worksheet. the daily and weekly totals from the room revenue forecasting worksheet. Turn ROOMS SOLD FORECASTING WORKSIET 25-POINT PROBLEM SIT WEEK 1 PERSOD Oet MARKET SEGMENT tridaat Satunda Sunday Monday Tesday Wdnesday Thunday Edday Tutal TRANSBNT ROOMS Meervati Booked ervation Pickup Toal Transent Nava GROUP OKOMS Definite Gup Definite Group 2 Tentative Goup Tentative Ciroup 2 Tetal Group Ramervation TOTAL ROOM RESERVATIONS OCCUPANCY PERCENTAGE Check-Ins Check-Outs KOOM REVENUEFORECANTING WORKSHEEY 25-POINT PROBLEM SET WEEK PERIOD MARKET SEGMENT Eriday Saturday Sunday Monday Tuesday Wednesday Thurnday Eriday Total TRANSIENT REVENUE Rooms Sold Average Rate Total Transient Revenue GROUP REVENUE Rooms Sold Average Rate Total Group Revenue TOTAL REVENUE Total Rooms Sold Occupancy Percentage Average Rate Total Room Revenue Indes 297

Answer rating: 100% (QA)

Depreciation for the year 1 Depreciable valueRemain... View the full answer