Question: E3.4: Compute an index trend using Year 1 as the base period: Year 1 Year 2 Year 3 Average room rate $50.00 $48.00 $54.00 Index
| E3.4: Compute an index trend using Year 1 as the base period: | |||||||||||||
| Year 1 | Year 2 | Year 3 | | ||||||||||
| Average room rate | $50.00 | $48.00 | $54.00 | ||||||||||
| Index | |||||||||||||
| E3.5: Determine the average check per guest: | |||||||||||||
| Sales | Guests | Average | | ||||||||||
| Dining Room | $150,080 | 9,380 | |||||||||||
| Bar-Lounge | $68,050 | 5,444 | |||||||||||
| E3.8: Fill in the missing numbers and % on this comparative income statement: | |||||||||||||
| Year 07 | Year 08 | $ Change | % | ||||||||||
| Sales | $23,502 | $1,110.00 | | ||||||||||
| Cost of Sales | $9,208 | $9,438 | |||||||||||
| Gross margin | |||||||||||||
| Direct Costs | $10,202 | $1,420.00 | |||||||||||
| Contributory Income | $3,552 | ||||||||||||
| Indirect Costs | $2,477 | ||||||||||||
| Operating Income | $1,149 | ||||||||||||
| E3.9: Convert March, April, May to current (May) dollars: | |||||||||||||
| Sales | Index | Current $ | | ||||||||||
| March | $48,000 | 110 | |||||||||||
| April | $50,000 | 112 | |||||||||||
| May | $52,000 | 115 | |||||||||||
| Write formulas for each | |||||||||||||
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
Study Help