Excel 1

Download as xlsx, pdf, or txt
Download as xlsx, pdf, or txt
You are on page 1of 5

Coral Automall

Sales Date of
Sl. Num CarType New/Used Amount
Person transaction
111 Ali Honda New 22-Jan $ 19,000.00
112 Mohd Mercedes Used 3-Feb $ 24,200.00
113 Hussan BMW New 8-Feb $ 46,000.00
114 Saud Lexus New 15-Feb $ 45,000.00
115 Ahmed Honda Used 15-Feb $ 8,500.00
Nicholas 5/1/2023 +62 812-2302-0399

ABC STORE

Discount
Number Of Total
Product List Price Sales price Sales Tax
Units Price

Beauty Products 420 800 100 700 35 735


Handbage 150 789 43 746 37.3 783.3
Perfumes 200 890 88 802 40.1 842.1
Accessories 98 460 25 435 21.75 456.75
Summer Clothes 75 560 30 530 26.5 556.5

PAGE 1
Jassaim E.S.T
Quarterly Salary Report: April-June

EMP Employement Base Salary Sales Commission Quarterly Salary


NO. Name
100 Ahmed $ 1,250.00 $ 45,463.00 $ 1,818.52 $ 3,068.52
102 Sami $ 1,165.00 $ 56,643.00 $ 2,265.72 $ 3,430.72
104 Khalid $ 1,076.00 $ 64,623.00 $ 2,584.92 $ 3,660.92
106 Majid $ 1,340.00 $ 48,000.00 $ 1,920.00 $ 3,260.00
108 Hassan $ 1,220.00 $ 521,212.00 $ 20,848.48 $ 22,068.48

Totals $ 6,051.00 $ 735,941.00 $ 29,437.64 $ 35,488.64


Average $ 1,210.20 $ 147,188.20 $ 5,887.53 $ 7,097.73
Highest $ 1,340.00 $ 521,212.00 $ 20,848.48 $ 22,068.48
Lowest $ 1,076.00 $ 45,463.00 $ 1,818.52 $ 3,068.52
Count $ 9,677.20 $ 1,449,804.20 $ 57,992.17 $ 67,723.37
Nicholas

Civic Arena Ferret Frolic Results


Description This Year Last Year Change %Change
Pre-sold Tickets 8750 7000 1750 25.00%
Gate Receipts 100 8500 -8400 -98.82%
Concession
Percentage -91.30%
100 1150 -1050
Club Memberships 6500 6250 250 4.00%
Club Sales 1100 1100 0 0.00%

TOTAL 16550 24000 -7450 -161.13%


AVERAGE 3310 4800 -1490 -32.23%
LOWEST 100 1100 -8400 -98.82%
HIGHEST 8750 8500 1750 25.00%

You might also like