[go: up one dir, main page]
Scribd
Upload
9 views3 pages

Basics of Data Entry

The document contains a summary of sales orders including order IDs, dates, products, quantities, unit prices, and total costs. It also provides details on payment methods, regions, discounts, shipping costs, and profits. The total sales amount to $2,116.00 with an average quantity of 8 per order.

Uploaded by

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

Basics of Data Entry

The document contains a summary of sales orders including order IDs, dates, products, quantities, unit prices, and total costs. It also provides details on payment methods, regions, discounts, shipping costs, and profits. The total sales amount to $2,116.00 with an average quantity of 8 per order.

Uploaded by

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

Order ID Date Product Quantity Unit Price

1001 1/1/2024 Product A 10 $20.00


1002 1/2/2024 Product B 5 $30.00
1003 1/3/2024 Product A 8 $18.00
1004 1/4/2024 Product C 12 $15.00
1005 1/5/2024 Product B 6 $32.00
1006 2/15/2024 Product D 7 $25.00
1007 2/16/2024 Product A 9 $22.00
1008 2/17/2024 Product B 4 $28.00
1009 2/18/2024 Product C 10 $16.00
1010 2/19/2024 Product D 7 $25.00
1012 2/22/2024 Product D 5 $50.00
1011 2/22/2024 Product A 10 $18.00

Total 93
Average 8
Unit Cost Total Price Total Cost Category Customer Name
$8.00 $200.00 $80.00 Electronics Customer 1
$12.00 $150.00 $60.00 Clothing Customer 2
$6.00 $144.00 $48.00 Electronics Customer 3
$5.00 $180.00 $60.00 Home Customer 4
$8.00 $192.00 $48.00 Clothing Customer 5
$5.00 $175.00 $35.00 Home Customer 46
$4.00 $198.00 $36.00 Electronics Customer 47
$6.00 $112.00 $24.00 Clothing Customer 48
$4.00 $160.00 $40.00 Home Customer 49
$5.00 $175.00 $35.00 Home Customer 50
$6.00 $250.00 $30.00 Electronics Customer 53
$5.00 $180.00 $50.00 Electronics Customer 51

$2,116.00 $546.00
Payment Method Region Discount Shipping Cost Profit
Credit Card North 5% $8 $112.00
Cash South 0% $5 $85.00
Debit Card East 10% $10 $86.00
Cash West 8% $12 $108.00
Credit Card North 15% $15 $129.00
Debit Card East 12% $10 $130.00
Credit Card West 8% $8 $154.00
Cash South 5% $6 $82.00
Debit Card North 10% $12 $108.00
Debit Card South 12% $10 $130.00
Debit Card East 5% $5 $215.00
Cash East 8% $10 $120.00

$111 $1,459.00
$9 $122

You might also like