UPDATED FINANCIAL SPREADSHEET 120909

UPDATED FINANCIAL SPREADSHEET 120909 - BASEDonExpectedDaily...

Info iconThis preview shows pages 1–2. Sign up to view the full content.

View Full Document Right Arrow Icon
GROSS INCOME DAY FOOD BAR PGI Mon $3,000.00 $1,500.00 $4,500.00 200 $15  Tue $3,000.00 $1,500.00 $4,500.00 FRI SAT SUN Wed $3,000.00 $1,500.00 $4,500.00 225 Thur $3,000.00 $1,500.00 $4,500.00 Fri $3,375.00 $4,000.00 $7,375.00 AVG TAB Sat $3,375.00 $4,000.00 $7,375.00 200 $20  Sun $3,375.00 $4,000.00 $7,375.00 WEEKS PER YEAR TOTALS $22,125.00 $18,000.00 $40,125.00 52 $2,086,500.00 SALARIES CATEGORY of Employees NAME HOURLY PAY WEEKS in year General Manager Andrew 1 SALARY - $50,000.00  $50,000.00  Assitant Manager Allyssa 1 SALARY - $40,000.00  $40,000.00  Marketing Manager Bonnie 1 SALARY - $30,000.00  $30,000.00  Finance Manager Tran 1 SALARY - $30,000.00  $30,000.00  AssistantNight Manager Roxanne 1 SALARY - $30,000.00  $30,000.00  Waitresses 25  $2.16  40 52 $4,492.80  $112,320.00  Bartenders 5  $4.00  40 52 $8,320.00  $41,600.00  Kitchen Staff 10  $8.50  40 52 $17,680.00  $176,800.00  TOTAL $510,720.00  BASED on Expected Daily  Customers Expected  Income from  
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Image of page 2
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 02/21/2010 for the course RR rr taught by Professor Rr during the Spring '10 term at American Academy of Art.

Page1 / 3

UPDATED FINANCIAL SPREADSHEET 120909 - BASEDonExpectedDaily...

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online