Ayunisa- excel project formula

# Ayunisa- excel project formula - Wages for Employees in...

This preview shows pages 1–5. Sign up to view the full content.

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

View Full Document

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

View Full Document
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: Wages for Employees in April \$ 3,000.00 \$ 2,500.00 \$ 2,000.00 \$ 1,500.00 \$ 1,000.00 \$ 500.00 \$- Aldi Fadillah Ryan Rinaldy Grace Sinaga Column L Abraham Donnie Elaf Hamid Wages for Employees in April Annisa Budiman; 12% Aldi Fadillah; 7% Audrey Zefanya; 9% Elaf Hamid; 12% Ryan Rinaldy; 8% Kezia Sinaga; 10% Aditya Utoyo; 12% Grace Sinaga; 10% Abraham Donnie; 10% Levy Suryadinata; 10% Hanifa Ayunisa 11/04/2011 PERMIAS RESTAURANT Wage for Employees in April Aldi Fadillah Audrey Zefanya Ryan Rinaldy Kezia Sinaga Grace Sinaga Levy Suryadinata Abraham Donnie Aditya Utoyo Elaf Hamid Annisa Budiman Total wage (\$) Average wage (\$) Maximun wage (\$) Minimun wage (\$) Total count number M F M F F M M M F F 3 3 4 4 5 5 6 6 7 7 ### \$2,082.00 \$2,600.00 \$1,530.00 10 7:30 AM 7:30 AM 9:00 AM 9:00 AM 10:00 AM 10:00 AM 11:00 AM 11:00 AM 1:00 PM 1:00 PM 12:30 PM 1:30 PM 2:30 PM 3:30 PM 4:30 PM 5:00 PM 6:00 PM 7:30 PM 9:00 PM 9:00 PM 100 120 110 130 130 140 140 170 160 160 5% 5% 5% 5% 5% 5% 5% 5% 5% 5% KEEP IT UP ! GOOD WORK :) **Every employee works 5 days a week. **There are 4 weeks in April. Hanifa Ayunisa 3% 3% 3% 3% 3% 3% 3% 3% 3% 3% 1,000.00 1,000.00 1,000.00 1,000.00 1,000.00 1,000.00 1,000.00 1,000.00 1,000.00 1,000.00 Reg wag ular (\$15 e /ho ur) Pro Sha fit Bon ring us Next date to prepare: 1,500.00 1,800.00 1,650.00 1,950.00 1,950.00 2,100.00 2,100.00 2,550.00 2,400.00 2,400.00 30.00 30.00 30.00 30.00 50.00 50.00 50.00 50.00 50.00 50.00 11-Oct-11 Tot a (Re l Wag gul wag ar e Bon e + us ) ### Tot a Mon l Wo thly r Hou k rs Bon ≥5 y us if ear s Bon <5 y us if ear s Yea Pro r End fit End of W Time ork Sta r of W t Time ork Yea Ser rs of vice er Gen d Em p loye e Date: \$1,530.00 \$1,830.00 \$1,680.00 \$1,980.00 \$2,000.00 \$2,150.00 \$2,150.00 \$2,600.00 \$2,450.00 \$2,450.00 Loan from Bank of America Interest Rate Term Loan Amount Monthly Payment 6.00% 30 \$500,000.00 (\$2,997.75) Total Loan Payment (\$1,079,190.95) ...
View Full Document

## This document was uploaded on 11/03/2011 for the course COMPUTER ca 120 at Montgomery.

### Page1 / 5

Ayunisa- excel project formula - Wages for Employees in...

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

View Full Document
Ask a homework question - tutors are online