Question

gaming lounge budget
the table represents a short - term budget for a local gaming lounge.
what is the amount in cell d15?
enter your answer in the box.
1 category description budgeted amount ($) actual amount ($) difference ($)
2 revenue
3 revenue video game sales $8,000 $7,500 -$500
4 revenue board game sales $3,650 $2,300 -$1,350
5 revenue snack sales $3,500 $1,800 -$1,700
6 revenue $15,150 $11,600
7
8 expenses
9 expenses rent $2,500 $2,500 $0
10 expenses utilities $1,000 $900 -$100
11 expenses staff salaries $6,500 $4,700 -$2,300
12 expenses gaming equipment $3,000 $3,300 $300
13 expenses marketing $700 $650 -$50
14 expenses miscellaneous $800 $850 $50
15 total expenses $14,200
16
17 profit or loss gaming lounge -$500 -$1,450

Explanation:

Step1: Identify relevant row

We look at row 15 which is for total expenses actual amount.

Step2: Sum actual expense amounts

Add up actual amounts in expense - related rows: $2500 (Rent)+$900 (Utilities)+$4700 (Staff salaries)+$3300 (Gaming equipment)+$650 (Marketing)+$550 (Miscellaneous).
$2500 + 900+4700 + 3300+650+550=12600$

Answer:

$12600$