09_Sales_Dashboard.xlsx

	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P
1	SALES TRANSACTIONS
2	Order No	Order Date	Customer	Product	Category	Qty	Unit Price ($)	Sales Amount ($)	Unit Cost ($)	Cost ($)	Gross Profit ($)	Profit Margin %	Salesperson	Region	Payment Method	Order Status

3	ORD-0001	2024-05-04	Daniel Hernandez	Project Management	Books	31	14.72	456.32	7.14	221.34	234.98	51.5%	Daniel Miller	North	Bank Transfer	Completed
4	ORD-0002	2024-11-01	Abigail Thompson	Whiteboard Markers	Office Supplies	27	425.07	11,476.89	242.77	6,554.79	4,922.10	42.9%	David Jones	North	PayPal	Pending
5	ORD-0003	2024-09-06	Sophia Lewis	HR Essentials	Books	38	363.68	13,819.84	229.33	8,714.54	5,105.30	36.9%	James Anderson	Central	Credit Card	Pending
6	ORD-0004	2024-08-01	Aaron Martin	Organic Honey	Food & Beverage	36	36.44	1,311.84	22.51	810.36	501.48	38.2%	Sarah Johnson	West	Cash	Completed
7	ORD-0005	2024-08-28	Isabella Jackson	Excel Mastery	Books	2	84.86	169.72	48.19	96.38	73.34	43.2%	Emma Brown	Central	Debit Card	Cancelled
8	ORD-0006	2024-05-30	Abigail Lewis	Facial Mask	Beauty	46	330.19	15,188.74	128.56	5,913.76	9,274.98	61.1%	Daniel Miller	West	Check	Completed
9	ORD-0007	2024-02-14	Evelyn Martin	Leadership Handbook	Books	40	107.57	4,302.80	59.94	2,397.60	1,905.20	44.3%	Michael Williams	South	Debit Card	Completed
10	ORD-0008	2024-09-09	Ava Davis	Mixed Nuts	Food & Beverage	7	397.77	2,784.39	251.76	1,762.32	1,022.07	36.7%	Emma Brown	Central	Credit Card	Completed
11	ORD-0009	2024-09-14	Sarah Young	Conditioner	Beauty	23	340.08	7,821.84	136.85	3,147.55	4,674.29	59.8%	Sarah Johnson	East	PayPal	Completed
12	ORD-0010	2024-06-23	Emily Wilson	Energy Drink	Food & Beverage	8	283.18	2,265.44	140.43	1,123.44	1,142.00	50.4%	James Anderson	Central	Bank Transfer	Completed
13	ORD-0011	2024-08-12	Emily Jackson	Musical Toy	Toys	43	56.55	2,431.65	20.65	887.95	1,543.70	63.5%	Sarah Johnson	North	Cash	Cancelled
14	ORD-0012	2024-03-01	Madison Miller	Shredder	Office Supplies	3	256.12	768.36	102.48	307.44	460.92	60.0%	Olivia Garcia	South	Check	Completed
15	ORD-0013	2024-11-27	Isabella Lopez	HR Essentials	Books	32	367.61	11,763.52	139.61	4,467.52	7,296.00	62.0%	Michael Williams	North	Debit Card	Pending
16	ORD-0014	2024-05-26	Nathan Garcia	Car Organizer	Automotive	16	418.23	6,691.68	205.81	3,292.96	3,398.72	50.8%	Sarah Johnson	East	Bank Transfer	Pending
17	ORD-0015	2024-04-26	David Young	Shampoo	Beauty	10	377.84	3,778.40	192.28	1,922.80	1,855.60	49.1%	Daniel Miller	West	PayPal	Pending
18	ORD-0016	2024-09-21	Michael Williams	Craft Kit	Toys	2	224.08	448.16	130.20	260.40	187.76	41.9%	Olivia Garcia	East	PayPal	Completed
19	ORD-0017	2024-11-24	David Wright	Car Organizer	Automotive	26	380.80	9,900.80	208.70	5,426.20	4,474.60	45.2%	James Anderson	International	Check	Cancelled
20	ORD-0018	2024-06-04	Abigail Robinson	Knee Brace	Sports	26	443.46	11,529.96	248.44	6,459.44	5,070.52	44.0%	Olivia Garcia	East	Credit Card	Completed
21	ORD-0019	2024-04-15	Aaron Thompson	Musical Toy	Toys	10	351.65	3,516.50	170.15	1,701.50	1,815.00	51.6%	Sophia Davis	International	Bank Transfer	Pending
22	ORD-0020	2024-03-05	Nathan Thompson	Sneakers	Apparel	6	23.30	139.80	10.49	62.94	76.86	55.0%	David Jones	South	Credit Card	Cancelled
23	ORD-0021	2024-01-12	James Wright	Stuffed Animal	Toys	34	173.65	5,904.10	93.89	3,192.26	2,711.84	45.9%	David Jones	South	Bank Transfer	Pending
24	ORD-0022	2024-11-17	Nathan Wilson	Remote Car	Toys	47	34.67	1,629.49	16.01	752.47	877.02	53.8%	Sarah Johnson	North	Check	Completed
25	ORD-0023	2024-04-30	Emily Robinson	Data Science	Books	37	369.75	13,680.75	179.68	6,648.16	7,032.59	51.4%	Emma Brown	East	Bank Transfer	Completed
26	ORD-0024	2024-02-23	Andrew Lee	Protein Bar	Food & Beverage	46	191.94	8,829.24	109.65	5,043.90	3,785.34	42.9%	Emma Brown	East	PayPal	Completed
27	ORD-0025	2024-03-07	Charlotte Miller	Air Purifier	Home & Living	27	45.56	1,230.12	16.80	453.60	776.52	63.1%	Sophia Davis	North	Bank Transfer	Cancelled
28	ORD-0026	2024-05-15	Tyler Martin	Steering Cover	Automotive	36	261.88	9,427.68	122.67	4,416.12	5,011.56	53.2%	Daniel Miller	West	Check	Pending
29	ORD-0027	2024-08-22	David Lewis	Seat Cover	Automotive	10	255.36	2,553.60	126.51	1,265.10	1,288.50	50.5%	Sarah Johnson	International	Debit Card	Pending
30	ORD-0028	2024-03-01	Harper King	Business Guide	Books	48	82.64	3,966.72	42.78	2,053.44	1,913.28	48.2%	Daniel Miller	North	Credit Card	Completed
31	ORD-0029	2024-06-05	Isabella Hernandez	Granola	Food & Beverage	3	263.77	791.31	101.64	304.92	486.39	61.5%	David Jones	West	Credit Card	Completed
32	ORD-0030	2024-05-25	Daniel Garcia	Towel Set	Home & Living	27	29.08	785.16	17.98	485.46	299.70	38.2%	Sophia Davis	North	Credit Card	Cancelled
33	ORD-0031	2024-10-16	Ryan Wright	Moisturizer	Beauty	3	211.70	635.10	110.49	331.47	303.63	47.8%	Olivia Garcia	West	PayPal	Cancelled
34	ORD-0032	2024-12-07	Ryan Jones	Wall Clock	Home & Living	33	320.05	10,561.65	185.15	6,109.95	4,451.70	42.1%	Olivia Garcia	North	Cash	Cancelled
35	ORD-0033	2024-01-24	Evelyn Wright	Tire Gauge	Automotive	15	450.62	6,759.30	203.54	3,053.10	3,706.20	54.8%	Sophia Davis	International	Bank Transfer	Completed
36	ORD-0034	2024-06-07	Amelia Sanchez	Throw Pillow	Home & Living	37	316.90	11,725.30	184.27	6,817.99	4,907.31	41.9%	Sarah Johnson	International	Cash	Completed
37	ORD-0035	2024-10-18	Nathan Miller	Leather Belt	Apparel	35	290.54	10,168.90	106.30	3,720.50	6,448.40	63.4%	Sophia Davis	Central	Credit Card	Completed
38	ORD-0036	2024-12-27	Nicholas Wright	Puzzle Set	Toys	2	141.11	282.22	58.10	116.20	166.02	58.8%	Sophia Davis	North	Cash	Cancelled
39	ORD-0037	2024-01-12	Andrew Taylor	Eye Cream	Beauty	38	27.27	1,036.26	16.60	630.80	405.46	39.1%	Michael Williams	West	Credit Card	Cancelled
40	ORD-0038	2024-10-04	Olivia Hernandez	Eye Cream	Beauty	17	50.06	851.02	32.24	548.08	302.94	35.6%	Michael Williams	South	Bank Transfer	Completed
41	ORD-0039	2024-06-15	Olivia Anderson	Picture Frame	Home & Living	27	340.91	9,204.57	125.34	3,384.18	5,820.39	63.2%	James Anderson	East	PayPal	Completed
42	ORD-0040	2024-03-02	Sarah Miller	Lip Balm	Beauty	27	447.04	12,070.08	191.06	5,158.62	6,911.46	57.3%	Emma Brown	Central	Cash	Completed
43	ORD-0041	2024-05-17	Sarah Lopez	HR Essentials	Books	49	254.69	12,479.81	161.68	7,922.32	4,557.49	36.5%	Sophia Davis	Central	PayPal	Completed
44	ORD-0042	2024-01-10	Matthew Thompson	Business Guide	Books	27	318.60	8,602.20	198.84	5,368.68	3,233.52	37.6%	Sarah Johnson	South	Cash	Completed
45	ORD-0043	2024-09-13	Daniel Young	Gym Gloves	Sports	27	225.76	6,095.52	136.33	3,680.91	2,414.61	39.6%	Michael Williams	East	Cash	Completed
46	ORD-0044	2024-01-22	James Allen	Sunglasses	Apparel	28	480.87	13,464.36	248.39	6,954.92	6,509.44	48.3%	Sophia Davis	Central	Bank Transfer	Completed
47	ORD-0045	2024-12-14	Joshua Wilson	Wireless Mouse	Electronics	31	140.28	4,348.68	59.66	1,849.46	2,499.22	57.5%	Emma Brown	Central	Cash	Completed
48	ORD-0046	2024-02-15	Joshua Lewis	Laptop Stand	Electronics	48	269.37	12,929.76	99.93	4,796.64	8,133.12	62.9%	Sarah Johnson	South	Check	Cancelled
49	ORD-0047	2024-06-11	Aaron Clark	Knee Brace	Sports	14	307.17	4,300.38	195.74	2,740.36	1,560.02	36.3%	Olivia Garcia	International	Bank Transfer	Pending
50	ORD-0048	2024-08-23	Harper Lopez	Jump Rope	Sports	43	491.60	21,138.80	222.44	9,564.92	11,573.88	54.8%	James Anderson	International	Debit Card	Completed
51	ORD-0049	2024-07-30	Amelia Wright	Mixed Nuts	Food & Beverage	1	451.22	451.22	248.99	248.99	202.23	44.8%	Sophia Davis	West	Cash	Completed
52	ORD-0050	2024-08-15	Evelyn Brown	Shredder	Office Supplies	2	446.82	893.64	265.78	531.56	362.08	40.5%	Olivia Garcia	West	Cash	Completed
53	ORD-0051	2024-03-04	Ryan Wilson	Seat Cover	Automotive	50	406.88	20,344.00	262.49	13,124.50	7,219.50	35.5%	Emma Brown	West	Credit Card	Completed
54	ORD-0052	2024-02-16	Nicholas Harris	Keyboard	Electronics	44	461.09	20,287.96	210.88	9,278.72	11,009.24	54.3%	David Jones	International	Debit Card	Completed
55	ORD-0053	2024-12-27	Harper Miller	Python Cookbook	Books	3	143.97	431.91	89.46	268.38	163.53	37.9%	James Anderson	South	Check	Pending
56	ORD-0054	2024-04-09	Evelyn Robinson	Binder Clips	Office Supplies	37	252.66	9,348.42	101.35	3,749.95	5,598.47	59.9%	Michael Williams	North	Cash	Completed
57	ORD-0055	2024-09-24	Abigail Young	File Folders	Office Supplies	17	467.11	7,940.87	283.37	4,817.29	3,123.58	39.3%	David Jones	South	Check	Completed
58	ORD-0056	2024-01-02	Mia Sanchez	Musical Toy	Toys	17	341.94	5,812.98	210.27	3,574.59	2,238.39	38.5%	James Anderson	East	PayPal	Pending
59	ORD-0057	2024-09-21	Justin Johnson	Resistance Bands	Sports	44	261.56	11,508.64	130.43	5,738.92	5,769.72	50.1%	Emma Brown	North	Bank Transfer	Pending
60	ORD-0058	2024-02-11	Aaron White	Water Gun	Toys	21	7.55	158.55	3.08	64.68	93.87	59.2%	James Anderson	International	Debit Card	Pending
61	ORD-0059	2024-11-16	Brandon Brown	Stapler	Office Supplies	13	86.42	1,123.46	38.30	497.90	625.56	55.7%	James Anderson	West	PayPal	Completed
62	ORD-0060	2024-06-23	Nicholas Johnson	Organic Honey	Food & Beverage	17	127.34	2,164.78	62.66	1,065.22	1,099.56	50.8%	Olivia Garcia	Central	Debit Card	Completed
63	ORD-0061	2024-10-23	Emma Williams	Pasta Set	Food & Beverage	29	383.23	11,113.67	206.03	5,974.87	5,138.80	46.2%	James Anderson	North	PayPal	Completed
64	ORD-0062	2024-06-03	Harper Sanchez	File Folders	Office Supplies	4	459.96	1,839.84	221.97	887.88	951.96	51.7%	Daniel Miller	North	Credit Card	Completed
65	ORD-0063	2024-11-12	Justin Taylor	Building Blocks	Toys	19	425.72	8,088.68	200.30	3,805.70	4,282.98	53.0%	Emma Brown	Central	Check	Cancelled
66	ORD-0064	2024-11-13	Harper Brown	Power Bank	Electronics	25	234.78	5,869.50	112.33	2,808.25	3,061.25	52.2%	Olivia Garcia	International	Check	Completed
67	ORD-0065	2024-01-07	Harper Lewis	HR Essentials	Books	22	295.97	6,511.34	113.18	2,489.96	4,021.38	61.8%	Sarah Johnson	Central	Debit Card	Cancelled
68	ORD-0066	2024-11-13	Ryan Garcia	Blender	Home & Living	17	180.92	3,075.64	89.45	1,520.65	1,554.99	50.6%	Emma Brown	South	Credit Card	Completed
69	ORD-0067	2024-07-02	Ava White	Picture Frame	Home & Living	38	220.74	8,388.12	140.81	5,350.78	3,037.34	36.2%	Michael Williams	South	PayPal	Completed
70	ORD-0068	2024-10-27	Evelyn Clark	Organic Honey	Food & Beverage	19	187.57	3,563.83	66.10	1,255.90	2,307.93	64.8%	Michael Williams	North	Debit Card	Cancelled
71	ORD-0069	2024-11-23	Elizabeth Miller	Building Blocks	Toys	28	175.19	4,905.32	112.64	3,153.92	1,751.40	35.7%	Sarah Johnson	East	Debit Card	Pending
72	ORD-0070	2024-06-20	Harper Hernandez	Accounting Basics	Books	45	168.92	7,601.40	88.43	3,979.35	3,622.05	47.6%	Daniel Miller	East	Debit Card	Completed
73	ORD-0071	2024-04-24	Kevin Davis	Business Guide	Books	32	113.61	3,635.52	39.89	1,276.48	2,359.04	64.9%	Sophia Davis	Central	Debit Card	Completed
74	ORD-0072	2024-01-04	Isabella Anderson	Python Cookbook	Books	48	191.08	9,171.84	89.83	4,311.84	4,860.00	53.0%	Sarah Johnson	East	Credit Card	Cancelled
75	ORD-0073	2024-07-03	Sarah Anderson	File Folders	Office Supplies	19	223.00	4,237.00	120.29	2,285.51	1,951.49	46.1%	Emma Brown	South	Bank Transfer	Completed
76	ORD-0074	2024-05-05	Olivia Miller	Sneakers	Apparel	47	91.27	4,289.69	55.15	2,592.05	1,697.64	39.6%	James Anderson	South	Bank Transfer	Completed
77	ORD-0075	2024-06-22	Elizabeth Miller	Laptop Stand	Electronics	25	329.16	8,229.00	202.60	5,065.00	3,164.00	38.4%	David Jones	West	Debit Card	Completed
78	ORD-0076	2024-08-10	Aaron Lewis	Lip Balm	Beauty	34	488.67	16,614.78	317.30	10,788.20	5,826.58	35.1%	Sarah Johnson	North	Debit Card	Completed
79	ORD-0077	2024-11-02	Mia Sanchez	Baseball Cap	Apparel	35	192.21	6,727.35	88.85	3,109.75	3,617.60	53.8%	Emma Brown	North	Cash	Cancelled
80	ORD-0078	2024-01-28	Brandon Young	Sunglasses	Apparel	19	395.85	7,521.15	177.46	3,371.74	4,149.41	55.2%	David Jones	South	Cash	Cancelled
81	ORD-0079	2024-12-05	Harper Williams	Marketing Bible	Books	47	45.30	2,129.10	22.25	1,045.75	1,083.35	50.9%	Michael Williams	Central	PayPal	Cancelled
82	ORD-0080	2024-07-10	Nathan Lewis	Sunscreen	Beauty	34	234.81	7,983.54	104.85	3,564.90	4,418.64	55.3%	Sophia Davis	International	PayPal	Pending
83	ORD-0081	2024-11-28	Sarah Miller	Gym Gloves	Sports	26	320.86	8,342.36	188.40	4,898.40	3,443.96	41.3%	Emma Brown	South	PayPal	Completed
84	ORD-0082	2024-03-21	Elizabeth Allen	Air Freshener	Automotive	20	215.39	4,307.80	99.75	1,995.00	2,312.80	53.7%	Olivia Garcia	East	Cash	Completed
85	ORD-0083	2024-10-25	Sarah Jackson	Scented Candle	Home & Living	19	225.03	4,275.57	102.49	1,947.31	2,328.26	54.5%	Olivia Garcia	West	PayPal	Pending
86	ORD-0084	2024-07-14	James Garcia	Tire Gauge	Automotive	24	403.23	9,677.52	179.48	4,307.52	5,370.00	55.5%	Sophia Davis	South	Bank Transfer	Completed
87	ORD-0085	2024-11-25	Michael Young	Moisturizer	Beauty	19	422.09	8,019.71	212.66	4,040.54	3,979.17	49.6%	David Jones	South	Credit Card	Completed
88	ORD-0086	2024-12-11	Andrew Martinez	Desk Organizer	Office Supplies	3	275.28	825.84	123.91	371.73	454.11	55.0%	David Jones	International	Check	Completed
89	ORD-0087	2024-10-05	Elizabeth Martinez	Leather Belt	Apparel	9	499.21	4,492.89	287.40	2,586.60	1,906.29	42.4%	James Anderson	East	Bank Transfer	Completed
90	ORD-0088	2024-11-30	Nathan Walker	Tire Gauge	Automotive	38	380.11	14,444.18	134.39	5,106.82	9,337.36	64.6%	Michael Williams	West	Debit Card	Completed
91	ORD-0089	2024-08-27	Abigail Allen	Winter Scarf	Apparel	15	260.33	3,904.95	152.50	2,287.50	1,617.45	41.4%	Sophia Davis	East	Credit Card	Completed
92	ORD-0090	2024-08-12	Ryan King	Yoga Pants	Apparel	50	471.26	23,563.00	223.99	11,199.50	12,363.50	52.5%	James Anderson	East	Debit Card	Cancelled
93	ORD-0091	2024-06-30	Andrew Davis	Picture Frame	Home & Living	48	9.79	469.92	5.81	278.88	191.04	40.7%	Daniel Miller	West	Check	Pending
94	ORD-0092	2024-01-17	Elizabeth Jones	Stuffed Animal	Toys	21	295.54	6,206.34	153.76	3,228.96	2,977.38	48.0%	Michael Williams	East	Cash	Cancelled
95	ORD-0093	2024-07-19	Michael Thompson	Pasta Set	Food & Beverage	26	490.19	12,744.94	201.60	5,241.60	7,503.34	58.9%	Daniel Miller	South	PayPal	Completed
96	ORD-0094	2024-03-28	Emma Clark	Facial Mask	Beauty	29	321.31	9,317.99	141.82	4,112.78	5,205.21	55.9%	Michael Williams	North	Check	Cancelled
97	ORD-0095	2024-07-16	Ava Miller	Business Guide	Books	12	103.50	1,242.00	64.52	774.24	467.76	37.7%	Emma Brown	East	Check	Cancelled
98	ORD-0096	2024-06-16	Madison Scott	Label Maker	Office Supplies	4	187.48	749.92	66.24	264.96	484.96	64.7%	Daniel Miller	West	Debit Card	Completed
99	ORD-0097	2024-04-15	David King	Blender	Home & Living	27	241.73	6,526.71	89.59	2,418.93	4,107.78	62.9%	Emma Brown	East	PayPal	Pending
100	ORD-0098	2024-09-14	Kevin Clark	Towel Set	Home & Living	37	469.88	17,385.56	247.27	9,148.99	8,236.57	47.4%	Sophia Davis	East	Debit Card	Completed