Assignment 1
Assignment 1
Assignment 1
D Computers
ITEM ITEM INVENTORY INVENTORY QUANTITY WHOLESALE RETAIL GROSS INSURANCE TAX NET
CODE NAME START END SOLD COST PER ITEM PRICE PROFIT PROFIT
ITM1 Pen 529 193 336 50 67.5 5880 294 1176 4410
Drive
ITM2 Mouse 300 27 273 20 27 1911 95.55 382.2 1433.25
ITM3 Keyboard 650 278 372 23 31.05 2994.6 149.73 598.92 2245.95
ITM4 Speaker 90 6 84 34 45.9 999.6 49.98 199.92 749.7
ITM5 Hard disk 590 250 340 150 202.5 17850 892.5 5355 11602.5
ITM6 UPS 127 89 38 120 162 1596 79.8 319.2 1197
ITM7 SMPS 652 467 185 60 81 3885 194.25 777 2913.75
ITM8 RAM 634 358 276 80 108 7728 386.4 1545.6 5796
ITM9 Data Cable 583 427 156 30 40.5 1638 81.9 327.6 1228.5
ITM10 HDMI Cable 348 296 52 45 60.75 819 40.95 163.8 614.25
TOTAL 4503 2391 2112 612 826.2 45301.2 2265.06 10845.24 32190.9
GROSS PROFIT Pen
Drive
Mouse
Keyboard
Speaker
Hard disk
UPS
SMPS
RAM
Data Cable
HDMI Cable