Scribd
Upload
6 views5 pages

Order Summary and Profit Analysis

The document contains a detailed table of orders including Order ID, Customer ID, date, order status, revenue, cost, profit, and profit score. It summarizes key metrics such as total profit of 12175, number of orders at 10, and an average profit of 1217.5. Additionally, it highlights specific orders with high profit scores and their statuses.

Uploaded by

davearyan162
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
6 views5 pages

Order Summary and Profit Analysis

The document contains a detailed table of orders including Order ID, Customer ID, date, order status, revenue, cost, profit, and profit score. It summarizes key metrics such as total profit of 12175, number of orders at 10, and an average profit of 1217.5. Additionally, it highlights specific orders with high profit scores and their statuses.

Uploaded by

davearyan162
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

Order IDCustomer ID Date Order StatusRevenue Cost Profit Profit Score

577597 152689 - Y ### Ordered 1645 822.5 822.5 C


503658 985245 - Q ### Ordered 1750 875 875 C
797851 785432 - P ### Ordered 4905 2452.5 2452.5 A
552860 152689 - Y ### Ordered 4215 2107.5 2107.5 A
466725 985245 - Q ### Ordered 770 385 385 C
936967 785432 - P ### Ordered 4965 2482.5 2482.5 A
562749 152689 - Y ### Ordered 495 247.5 247.5 C
269983 325698 - C ### Ordered 3735 1867.5 1867.5 B
334598 985245 - Q ### Ordered 4085 2042.5 2042.5 A
956465 785432 - P ### Ordered 3990 1995 1995 B
279099 985245 - Q ### Shipped 385 192.5 192.5 C
221661 152689 - Y ### Shipped 4550 2275 2275 A
196228 325698 - C ### Shipped 1500 750 750 C
499944 325698 - C ### Shipped 2555 1277.5 1277.5 B
462194 985245 - Q ### Shipped 485 242.5 242.5 C
288845 785432 - P ### Shipped 4340 2170 2170 A
408539 452584 - A ### Shipped 1055 527.5 527.5 C
962242 985245 - Q ### Shipped 2745 1372.5 1372.5 B
559502 985245 - Q ### Shipped 2345 1172.5 1172.5 B
936106 152689 - Y ### Shipped 4390 2195 2195 A
135130 152689 - Y ### Processing 1180 590 590 C
611432 452584 - A ### Processing 365 182.5 182.5 C
908572 985245 - Q ### Processing 3680 1840 1840 B
484370 985245 - Q ### Processing 1300 650 650 C
864076 785432 - P ### Processing 2545 1272.5 1272.5 B
788950 785432 - P ### Processing 1905 952.5 952.5 C
687496 152689 - Y ### Processing 4810 2405 2405 A
271521 985245 - Q ### Processing 4870 2435 2435 A
383740 985245 - Q ### Processing 3635 1817.5 1817.5 B
637307 985245 - Q ### Processing 810 405 405 C
Metric Value
Total Profi 12175
Number of 10
Average Pro 1217.5
Order IDCustomer ID Date Order StatusRevenue Cost Profit Profit Score
221661 152689 - Y ### Shipped 4550 2275 2275 A
288845 785432 - P ### Shipped 4340 2170 2170 A
936106 152689 - Y ### Shipped 4390 2195 2195 A
Order IDCustomer ID Date Order StatusRevenue Cost Profit Profit Score
936967 785432 - P ### Ordered 4965 2482.5 2482.5 A
562749 152689 - Y ### Ordered 495 247.5 247.5 C
334598 985245 - Q ### Ordered 4085 2042.5 2042.5 A
687496 152689 - Y ### Processing 4810 2405 2405 A
271521 985245 - Q ### Processing 4870 2435 2435 A
383740 985245 - Q ### Processing 3635 1817.5 1817.5 B
637307 985245 - Q ### Processing 810 405 405 C
Order IDCustomer ID Date Order StatusRevenue Cost Profit Profit Score
797851 785432 - P ### Ordered 4905 2452.5 2452.5 A
936967 785432 - P ### Ordered 4965 2482.5 2482.5 A

You might also like