Richard Leong
Data Management
Print Result Export Excel Reload Data|
|
No. | Category | Item Name | Status | Stock | Price | Cost /unit | 07/2024 | 08/2024 | 09/2024 | 10/2024 | 11/2024 | 12/2024 | Total Sales | Total Cost | Total Profit |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
|
1. | Mobile Phone | iPhone 14 Pro Max - 256gb - Deep Purple | Active | 25 | $999 | $899 | 5 sold | 6 sold | 10 sold | 4 sold | 5 sold | 25 sold | $49,950 | $44,950 | $5,000 |
|
|
2. | Mobile Phone | iPhone 14 Pro Max - 256gb - Space Black | Active | 50 | $999 | $899 | 10 sold | 16 sold | 20 sold | 14 sold | 10 sold | 55 sold | $124,875 | $112,375 | $12,500 |
|
|
3. | Mobile Phone | iPhone 14 - 256gb - Space Black | Inactive | 0 | $599 | $499 | 5 sold | 2 sold | 1 sold | 7 sold | 15 sold | 25 sold | $32,945 | $27,445 | $5,500 |
|
|
4. | Laptop | MacBook Pro with M2 Chip - 512gb - Space Grey | Inactive | 5 | $1,999 | $1,799 | 3 sold | 5 sold | 2 sold | 10 sold | 5 sold | 20 sold | $89,955 | $80,955 | $9,000 |
|
|
5. | Laptop | MacBook Air with M2 Chip - 256gb - Space Grey | Inactive | 10 | $1,099 | $899 | 11 sold | 9 sold | 15 sold | 15 sold | 5 sold | 20 sold | $82,425 | $67,425 | $15,000 |
|
|
6. | Desktop | iMac 24-inch - 1Tb - Silver | Active | 5 | $1,299 | $999 | 5 sold | 4 sold | 1 sold | 10 sold | 5 sold | 10 sold | $45,465 | $34,965 | $10,500 |
|
|
7. | Desktop | iMac 24-inch - 1Tb - Blue | Active | 10 | $1,299 | $999 | 5 sold | 4 sold | 1 sold | 10 sold | 5 sold | 10 sold | $45,465 | $34,965 | $10,500 |
|
|
8. | Desktop | iMac 24-inch - 1Tb - Purple | Inactive | 0 | $1,299 | $999 | 5 sold | 4 sold | 1 sold | 10 sold | 5 sold | 10 sold | $45,465 | $34,965 | $10,500 |
|
|
9. | Watch | Apple Watch Ultra | Active | 10 | $799 | $599 | 2 sold | 3 sold | 5 sold | 10 sold | 0 sold | 5 sold | $19,975 | $14,975 | $5,000 |
|
|
10. | Watch | Apple Watch Series 8 | Active | 10 | $399 | $299 | 1 sold | 5 sold | 4 sold | 0 sold | 0 sold | 10 sold | $7,980 | $5,980 | $2,000 |
|
|
11. | Watch | Apple Watch SE | Active | 10 | $249 | $149 | 1 sold | 2 sold | 4 sold | 8 sold | 0 sold | 10 sold | $6,225 | $3,725 | $2,500 |
|
|
12. | Watch | Apple Watch Hermès | Active | 2 | $1,229 | $1,029 | 1 sold | 0 sold | 2 sold | 3 sold | 0 sold | 4 sold | $12,290 | $10,290 | $2,000 |
|
|
13. | Desktop | Mac Mini | Active | 2 | $699 | $599 | 0 sold | 0 sold | 1 sold | 1 sold | 0 sold | 0 sold | $1,398 | $1,198 | $200 |
|
|
14. | Desktop | Mac Studio | Inactive | 0 | $1,999 | $1,599 | 1 sold | 0 sold | 0 sold | 0 sold | 0 sold | 0 sold | $1,999 | $1,599 | $400 |
|
|
15. | Desktop | Studio Display | Active | 2 | $1,599 | $1,099 | 0 sold | 0 sold | 0 sold | 0 sold | 0 sold | 0 sold | $0 | $0 | $0 |
|
|
16. | Desktop | Mac Pro | Active | 2 | $5,999 | $4,999 | 0 sold | 0 sold | 0 sold | 0 sold | 0 sold | 0 sold | $0 | $0 | $0 |
|
|
17. | Desktop | Pro Display XDR | Active | 2 | $4,999 | $3,999 | 0 sold | 0 sold | 0 sold | 0 sold | 0 sold | 0 sold | $0 | $0 | $0 |
|
|
18. | Tablet | iPad Pro 11-inch | Active | 10 | $799 | $699 | 5 sold | 1 sold | 2 sold | 2 sold | 5 sold | 15 sold | $23,970 | $20,970 | $3,000 |
|
|
19. | Tablet | iPad Pro 12.9-inch | Active | 5 | $1,099 | $899 | 2 sold | 1 sold | 0 sold | 1 sold | 0 sold | 1 sold | $5,495 | $4,495 | $1,000 |
|
|
20. | Tablet | iPad Air | Active | 33 | $599 | $499 | 12 sold | 18 sold | 15 sold | 25 sold | 10 sold | 30 sold | $65,890 | $54,890 | $11,000 |
|
|
21. | Tablet | iPad (10th gen.) | Active | 29 | $449 | $339 | 5 sold | 10 sold | 7 sold | 23 sold | 15 sold | 20 sold | $35,920 | $27,120 | $8,800 |
|
|
22. | Tablet | iPad (9th gen.) | Active | 52 | $329 | $219 | 51 sold | 23 sold | 43 sold | 23 sold | 30 sold | 15 sold | $60,865 | $40,515 | $20,350 |
|
|
23. | Tablet | iPad mini | Active | 26 | $499 | $399 | 5 sold | 10 sold | 3 sold | 2 sold | 10 sold | 15 sold | $22,455 | $17,955 | $4,500 |
|
|
24. | Earphones | AirPods (3rd generation) | Active | 55 | $169 | $129 | 129 sold | 91 sold | 55 sold | 67 sold | 85 sold | 73 sold | $84,500 | $64,500 | $20,000 |
|
|
25. | Earphones | AirPods (2ND generation) | Active | 182 | $129 | $99 | 43 sold | 26 sold | 74 sold | 55 sold | 25 sold | 67 sold | $37,410 | $28,710 | $8,700 |
|
|
26. | Earphones | AirPods Max | Active | 6 | $499 | $399 | 0 sold | 0 sold | 0 sold | 0 sold | 0 sold | 0 sold | $0 | $0 | $0 |
|
|
27. | Phone | iPhone 13 - 128gb - Space Grey | Active | 6 | $599 | $499 | 1 sold | 0 sold | 5 sold | 4 sold | 5 sold | 15 sold | $17,970 | $14,970 | $3,000 |
|
|
28. | Phone | iPhone 13 mini - 128gb - Red | Active | 2 | $499 | $399 | 1 sold | 0 sold | 0 sold | 0 sold | 0 sold | 2 sold | $1,497 | $1,197 | $300 |
|
|
29. | Phone | iPhone SE - 64gb - Red | Active | 5 | $429 | $329 | 0 sold | 1 sold | 0 sold | 0 sold | 0 sold | 0 sold | $429 | $329 | $100 |
|
|
30. | Phone | iPhone 12 - 128gb - Purple | Active | 3 | $649 | $329 | 0 sold | 0 sold | 0 sold | 0 sold | 1 sold | 0 sold | $649 | $329 | $320 |
| 309 sold | 241 sold | 271 sold | 304 sold | 241 sold | 457 sold | $923,462 | $751,792 | $171,670 |
