[go: up one dir, main page]
Scribd
Upload
423 views5 pages

Sales and Pricing Analysis

1. The document summarizes sales data from an ABC store, including product details, list prices, discounts, sales prices, sales taxes, and total prices for 5 products. 2. It also provides payroll information for 7 employees of Oscar Rent Company, including employee details, grades, sales, commissions, allowances, deductions, and monthly salaries. 3. Finally, it shows catalog sales data from J.J. Barney with product numbers, prices, zones, postages, tax rates, sales taxes, and total sales for 13 products. The postage and tax rates by zone are also displayed.

Uploaded by

mastura
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
423 views5 pages

Sales and Pricing Analysis

1. The document summarizes sales data from an ABC store, including product details, list prices, discounts, sales prices, sales taxes, and total prices for 5 products. 2. It also provides payroll information for 7 employees of Oscar Rent Company, including employee details, grades, sales, commissions, allowances, deductions, and monthly salaries. 3. Finally, it shows catalog sales data from J.J. Barney with product numbers, prices, zones, postages, tax rates, sales taxes, and total sales for 13 products. The postage and tax rates by zone are also displayed.

Uploaded by

mastura
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
You are on page 1/ 5

ABC STORE

Discount
Number
Product List Price Sales Price Sales Tax Total Price
of Units

Beauty Product 420 800 100 700 35 735


Handbags 150 789 43 746 37 783
Perfumes 200 890 88 802 40 842
Accessories 98 460 25 435 22 457
summer cloth 75 560 30 530 27 557
Mastura Md Jais
OSCAR RENT COMPANY
Commission rate 5.00%
Social Insurance rate 2.50%

Social
Emp No. Employee Basic Car Monthly
Grade Sales Commission Allowance Insurance
Name Salary Salary
Cut
001250 Nader A 600 16000 800 0 15 1385
001260 Isa B 400 11000 550 0 10 940
001270 Faizal A 550 20000 1000 0 13.75 1536.25
001280 Nadia D 320 13000 650 100 8 1062
001290 Eman C 400 15000 750 0 10 1140
001300 Hamad D 250 14000 700 100 6.25 1043.75
001310 A.Aziz B 450 17000 850 0 11.25 1288.75

TOTAL
AVERAGE
HIGHEST
LOWEST
NO. OF EMPLOYEES

Grade Table
A Senior
B Junior
C Executive
D Training
Position

Senior
Junior
Senior
Training
#N/A
#N/A
#N/A
J.J BARNEY CATALOG SALES
TAX SALES TOTAL
CAT. NO PRICE ZONE POSTAGE RATE TAX SALE
J43256 59.95 1.00 4 0.08 4.80 64.03
J43257 65.49 2.00 4.5 0.06 3.93 70.05 120
J43258 29.95 3.00 5 0 0.00 34.95
J43259 43.98 4.00 5.5 0.04 1.76 49.52 100

J43260 16.89 5.00 6 0.05 0.84 22.94 80


J43261 36.67 6.00 6.5 0.07 2.57 43.24
J43262 89.67 1.00 4 0.08 7.17 93.75 60
J43263 29.95 4.00 5.5 0.04 1.20 35.49
40
J43264 43.65 3.00 5 0 0.00 48.65
POSTAGE AND SALES TAX RATE 20
ZONE 1 2 3 4 5 6
0
POSTAGE 4 4.5 5 5.5 6 6.5
256 57 58 59 6
SALE TAX RATE 0.08 0.06 0 0.04 0.05 0.07 3 32 32 32 32
J4 J4 J4 J4 J4
TOTAL SALE
120

100

80

60 TOTAL
SALE
40

20

0
256 57 58 59 60 61 62 63 64
3 32 32 32 32 32 32 32 32
J4 J4 J4 J4 J4 J4 J4 J4 J4

You might also like