Name:
Date:
Downtown Internet Cafe First Quarter Forecast
Sales
Jan
Feb
Mar
Total
% of total
Beverages
$13,000.00
$14,600.00
$16,500.00
$44,100.00
49.55%
Food
$7,100.00
$7,300.00
$8,000.00
$22,400.00
25.17%
Internet
$4,000.00
$4,200.00
$6,000.00
$14,200.00
15.96%
Merchandise
$3,100.00
$3,200.00
$2,000.00
$8,300.00
9.33%
Total Income
$27,200.00
$29,300.00
$32,500.00
$89,000.00
Expenses
Cost of Goods
$6,960.00
$7,300.00
$7,600.00
$21,860.00
24.97%
Payroll
$7,500.00
$7,500.00
$7,500.00
$22,500.00
25.70%
Computers
$6,400.00
$6,400.00
$6,400.00
$19,200.00
21.93%
Lease
$5,500.00
$5,500.00
$5,500.00
$16,500.00
18.84%
Marketing
$1,000.00
$1,000.00
$1,000.00
$3,000.00
3.43%
Misc.
$1,500.00
$1,500.00
$1,500.00
$4,500.00
5.14%
Total Expenses
$28,860.00
$29,200.00
$29,500.00
$87,560.00
Net Income
-$1,660.00
$100.00
$3,000.00
$1,440.00
|
|