Multi-channel line-item profitability analysis for office supplies retail
| Date | Order # | Channel | Items | Revenue | COGS | Shipping | Fees | GP | Margin % |
|---|---|---|---|---|---|---|---|---|---|
| 2024-01-10 | ORD-2024010001 | Amazon | 4 | $462.73 | $326.52 | $28.00 | $69.40 | $38.81 | 8.4% |
| 2024-01-08 | ORD-2024010002 | Magento | 5 | $495.04 | $346.46 | $46.50 | $11.14 | $90.94 | 18.4% |
| 2024-01-08 | ORD-2024010003 | Amazon | 2 | $281.43 | $189.96 | $19.50 | $42.21 | $29.76 | 10.6% |
| 2024-01-25 | ORD-2024010004 | Amazon | 5 | $205.15 | $136.97 | $56.00 | $30.77 | $-18.59 | -9.1% |
| 2024-01-22 | ORD-2024010005 | Amazon | 4 | $139.39 | $94.07 | $44.00 | $20.91 | $-19.59 | -14.1% |
| 2024-01-19 | ORD-2024010006 | Magento | 5 | $191.49 | $137.72 | $49.50 | $4.62 | $-0.35 | -0.2% |
| 2024-01-17 | ORD-2024010007 | Phone | 5 | $165.44 | $117.12 | $49.50 | $4.06 | $-5.24 | -3.2% |
| 2024-01-23 | ORD-2024010008 | Phone | 3 | $77.27 | $61.05 | $29.50 | $1.96 | $-15.24 | -19.7% |
| 2024-01-06 | ORD-2024010009 | Magento | 1 | $7.50 | $4.24 | $10.00 | $0.26 | $-7.00 | -93.3% |
| 2024-01-12 | ORD-2024010010 | Amazon | 4 | $258.03 | $157.26 | $37.00 | $38.70 | $25.07 | 9.7% |
| 2024-01-17 | ORD-2024010011 | Magento | 1 | $62.13 | $38.22 | $10.00 | $1.44 | $12.47 | 20.1% |
| 2024-01-14 | ORD-2024010012 | Amazon | 2 | $135.28 | $69.49 | $19.50 | $20.29 | $26.00 | 19.2% |
| 2024-01-02 | ORD-2024010013 | Amazon | 4 | $230.05 | $163.25 | $41.50 | $34.51 | $-9.21 | -4.0% |
| 2024-01-06 | ORD-2024010014 | Magento | 1 | $101.61 | $65.73 | $12.00 | $2.28 | $21.60 | 21.3% |
| 2024-01-23 | ORD-2024010015 | Amazon | 5 | $447.19 | $327.27 | $53.50 | $67.09 | $-0.67 | -0.1% |
| 2024-01-10 | ORD-2024010016 | Phone | 5 | $523.95 | $364.29 | $55.50 | $11.76 | $92.40 | 17.6% |
| 2024-01-18 | ORD-2024010017 | Amazon | 1 | $176.85 | $149.91 | $12.00 | $26.53 | $-11.59 | -6.5% |
| 2024-01-01 | ORD-2024010018 | Amazon | 1 | $57.24 | $32.54 | $12.00 | $8.59 | $4.11 | 7.2% |
| 2024-01-14 | ORD-2024010019 | Amazon | 4 | $513.10 | $315.67 | $39.00 | $76.96 | $81.47 | 15.9% |
| 2024-01-27 | ORD-2024010020 | Magento | 3 | $393.52 | $241.31 | $27.00 | $8.76 | $116.45 | 29.6% |
| SKU | Name | Category | Units | Revenue | COGS | Margin % |
|---|---|---|---|---|---|---|
| SKU-1201 | Binder Clips - Medium | Desk Accessories | 592 | $59,413.12 | $25,118.56 | 43.0% |
| SKU-1188 | Scissors - 8in | Desk Accessories | 468 | $51,709.32 | $22,361.04 | 41.9% |
| SKU-1187 | Tape Dispensers - Heavy Duty | Desk Accessories | 589 | $52,962.88 | $24,867.58 | 38.2% |
| SKU-1179 | Staplers - Electric | Desk Accessories | 473 | $47,200.67 | $22,316.14 | 39.5% |
| SKU-1177 | Staplers - Heavy Duty | Desk Accessories | 520 | $48,807.20 | $23,977.20 | 36.4% |
| SKU-1189 | Scissors - 5in | Desk Accessories | 445 | $38,301.15 | $15,677.35 | 46.1% |
| SKU-1204 | Binder Clips - Small | Desk Accessories | 549 | $44,304.30 | $21,712.95 | 39.0% |
| SKU-1186 | Tape Dispensers - Handheld | Desk Accessories | 520 | $41,080.00 | $17,321.20 | 40.7% |
| SKU-1202 | Binder Clips - Large | Desk Accessories | 526 | $40,002.30 | $17,263.32 | 40.4% |
| SKU-1176 | Staplers - Standard | Desk Accessories | 549 | $37,968.84 | $15,426.90 | 40.8% |
| SKU-1133 | Binders - 2in | Organization | 620 | $51,931.20 | $29,505.80 | 28.5% |
| SKU-1144 | Labels - Address | Organization | 523 | $46,128.60 | $25,804.82 | 31.0% |
| SKU-1178 | Staplers - Mini | Desk Accessories | 434 | $33,912.76 | $14,113.68 | 41.8% |
| SKU-1238 | Keyboard Covers - PC | Technology | 519 | $44,198.04 | $24,377.43 | 27.8% |
| SKU-1200 | Binder Clips - Small | Desk Accessories | 535 | $42,751.85 | $23,823.55 | 28.0% |
| SKU-1143 | File Organizers - Wall Mount | Organization | 477 | $40,640.40 | $22,404.69 | 29.2% |
| SKU-1185 | Tape Dispensers - Desktop | Desk Accessories | 547 | $43,027.02 | $24,511.07 | 26.7% |
| SKU-1197 | Paper Clips - Vinyl | Desk Accessories | 421 | $34,551.47 | $18,928.16 | 33.1% |
| SKU-1142 | File Organizers - Desktop | Organization | 483 | $41,571.81 | $23,947.14 | 26.3% |
| SKU-1217 | Push Pins - Color | Desk Accessories | 554 | $29,993.56 | $15,174.06 | 36.2% |