The above figures show a model (in both normal and formula view) used to allow a

Question

The above figures show a model (in both normal and formula view) used to allow a user to change the occupancy rate and see the effect on total revenue. There is an error in this spreadsheet. Which of the following is way to stop this error? NOTE: The room rate could be in dollars and cents

A.Change cell D6 to be =ROUND(SUM(D4:D5),0)
B. Change cell D4 to be =ROUND(C4*$C$1,0) and cell D5 to be =ROUND(C5*$C$1,0)
C. Change cell E6 to be =ROUND(SUM(E4:E5),2)
D. Change cell E4 to be =ROUND(B4*D4,2) and cell D5 to be =ROUND(B5*D5,2)

Occupancy % 21% Total Number Rooms Total 3 Room Type Room Rate of Rooms Occupied Revenue 5250.0 42 $10, 21 $7, 63 $17,850 200 4 Regular 5 Delux TOTAL Formula View Occupancy % 0.21 Total Number of Room Type Room Rate 4 Regular 5 Delux Rooms OccupiedTotal Revenue 200 100 #84"D4 85 DS SUM(E4:ES 250 350 TOTAL ·SUM(D4:D5)

Explanation / Answer

Solution:

B option is correct,

Since the percentage can be in decimal pointed so in this case we need to round the value of the number of rooms because 0.5 room cannot be allocated to anyone.

and if the number of rooms is rounded off there is no need to round off any other value in the spreadsheet.

Please, please upvote and ask your doubts in the comments.

Related Questions

Navigate

• Browse (All)
• Browse T
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.