Needed urgently bar graph or chart
ohaybelleo
1533250226818_countinformation.xlsx1st quarter 2017 warehouse 3
| WAREHOUSE STOCK COUNT VARIANCE REPORT 1ST QUARTER JUNE 2017 | |||||||||
| CATEGORIES | STOCK VALUE @ COST | $VARIANCE @ COUNT | NET ADJUSTMENTS | VARIANCE AFTER ADJUSTMENTS | % VARIANCE | # OF ITEM LINES | LINE VARIANCE | % LINE VARIANCE | |
| 1 | Vision | $ 170,414.39 | $ 3,276.37 | $ 2,792.93 | 6,069.30 | 3.56% | 50 | 20 | 40% |
| 2 | Audio | $ 65,123.19 | $ 391.27 | $ (814.32) | (423.05) | -0.65% | 59 | 12 | 20% |
| 3 | Major White | $ 110,527.16 | $ 3,622.41 | $ (2,446.44) | 1,175.97 | 1.06% | 76 | 7 | 9% |
| 4 | Business Equipment | $ 237,257.96 | $ 3,245.98 | $ - 0 | 3,245.98 | 1.37% | 42 | 7 | 17% |
| 5 | Small Appliances | $ 84,350.81 | $ (1,186.84) | $ 59.47 | (1,127.37) | -1.34% | 124 | 28 | 23% |
| 6 | Electrical Accessories | $ 9,019.38 | $ (74.64) | $ (18.07) | (92.71) | -1.03% | 32 | 13 | 41% |
| 14 | Free Gifts | $ 713.85 | $ (567.74) | $ - 0 | (567.74) | -79.53% | 4 | 3 | 75% |
| 15 | Electrical Repossession | $ 11,036.21 | $ (1,412.58) | $ - 0 | (1,412.58) | -12.80% | 16 | 5 | 31% |
| 16 | Essentials | $ 16,960.91 | $ (841.59) | $ (275.70) | (1,117.29) | 0.00% | 55 | 4 | 7% |
| 20 | Spare Parts | $ - 0 | $ - 0 | $ - 0 | - 0 | 0.00% | - 0 | - 0 | ERROR:#DIV/0! |
| 21 | PC's & Notebooks | $ 261,042.34 | $ 1,732.48 | $ - 0 | 1,732.48 | 0.66% | 46 | 14 | 30% |
| 22 | Computer Accessories | $ 12,816.25 | $ 443.55 | $ 22.41 | 465.96 | 3.64% | 34 | 10 | 29% |
| 25 | Second hand pc | $ (749.79) | $ (804.70) | $ - 0 | (804.70) | 0.00% | 2 | 1 | 50% |
| 50 | Lounge | $ 57,543.20 | $ 1,287.29 | $ 1,315.15 | 2,602.44 | 4.52% | 42 | 1 | 2% |
| 60 | Dining | $ 14,460.25 | - 0 | 0.00% | 16 | - 0 | 0% | ||
| 70 | Bedroom | $ 16,428.77 | $ 1,245.88 | $ - 0 | 1,245.88 | 7.58% | 28 | 3 | 11% |
| 75 | Bedding | $ 33,252.00 | $ (1,724.39) | $ 493.86 | (1,230.53) | -3.70% | 57 | 13 | 23% |
| 80 | Furniture Occasional | $ 56,211.07 | $ (3,188.55) | $ 2,054.63 | (1,133.92) | -2.02% | 150 | 21 | 14% |
| 81 | Floor Covering | $ 10,810.39 | $ (676.31) | $ 274.32 | (401.99) | -3.72% | 17 | 1 | 6% |
| 84 | Free Gifts-Electrical | $ - 0 | $ - 0 | $ - 0 | - 0 | ERROR:#DIV/0! | - 0 | - 0 | ERROR:#DIV/0! |
| 85 | Furniture Repossession | $ - 0 | $ 3,533.29 | $ - 0 | 3,533.29 | ERROR:#DIV/0! | 6 | 6 | 100% |
| totals | $ 1,167,218.34 | $ 8,301.18 | $ 3,458.24 | $ 11,759.42 | 1.01% | 856 | 169 | 20% | |
| Overall % variance | 1.01% | Grade: |
2nd quater 2017 warehouse 3
| CATEGORIES | STOCK VALUE @ COST | $VARIANCE @ COUNT | NET ADJUSTMENTS | VARIANCE AFTER ADJUSTMENTS | % VARIANCE | # OF ITEM LINES | LINE VARIANCE | % LINE VARIANCE | |
| 1 | Vision | $ 615,927.49 | $ (8,468.74) | $ 7,281.92 | (1,186.82) | -0.19% | 116 | 6 | 5% |
| 2 | Audio | $ 323,972.52 | $ 558.40 | $ 50.57 | 608.97 | 0.19% | 164 | 7 | 4% |
| 3 | Major White | $ 1,084,204.76 | $ (798.00) | $ 3,176.61 | 2,378.61 | 0.22% | 255 | 6 | 2% |
| 4 | Business Equipment | $ 498,679.65 | $ (27,032.63) | $ 2,566.31 | (24,466.32) | -4.91% | 95 | 20 | 21% |
| 5 | Small Appliances | $ 388,399.61 | $ (4,403.13) | $ 194.32 | (4,208.81) | -1.08% | 312 | 47 | 15% |
| 6 | Electrical Accessories | $ 33,583.53 | $ (58.17) | $ (143.98) | (202.15) | -0.60% | 79 | 5 | 6% |
| 8 | OPTICAL | $ 28,741.00 | $ (8,556.85) | $ 2,791.21 | $ (5,765.64) | -20.06% | 668 | 152 | 23% |
| 14 | Free Gifts | $ 2,443.52 | $ 1,513.56 | $ - 0 | 1,513.56 | 61.94% | 674 | 154 | 23% |
| 15 | Electrical Repossession | $ 54,017.28 | $ (6,454.35) | $ (1,818.01) | (8,272.36) | -15.31% | 58 | 6 | 10% |
| 16 | Essentials | $ 28,003.99 | $ (1,677.16) | $ 660.18 | (1,016.98) | 0.00% | 114 | 17 | 15% |
| 20 | Spare Parts | $ 150,321.00 | $ (2,863.88) | $ 1,905.74 | (958.14) | 0.00% | 114 | 20 | 18% |
| 21 | PC's & Notebooks | $ 601,321.59 | $ (14,092.65) | $ 7,027.41 | (7,065.24) | -1.17% | 108 | 22 | 20% |
| 22 | Computer Accessories | $ 49,744.69 | $ (628.39) | $ 628.39 | - 0 | 0.00% | 91 | 2 | 2% |
| 25 | Second hand pc | $ (1,250.04) | $ - 0 | $ - 0 | - 0 | 0.00% | - 0 | - 0 | ERROR:#DIV/0! |
| 50 | Lounge | $ 471,289.10 | $ 23,050.44 | $ (20,735.54) | 2,314.90 | 0.49% | 136 | 5 | 4% |
| 60 | Dining | $ 173,283.83 | $ (368.38) | $ - 0 | (368.38) | -0.21% | 49 | 1 | 2% |
| 70 | Bedroom | $ 205,477.43 | $ (1,054.27) | $ - 0 | (1,054.27) | -0.51% | 80 | 2 | 3% |
| 75 | Bedding | $ 535,503.61 | $ (6,938.39) | $ (1,381.40) | (8,319.79) | -1.55% | 197 | 21 | 11% |
| 80 | Furniture Occasional | $ 214,877.97 | $ 6,668.37 | $ - 0 | 6,668.37 | 3.10% | 1 | 1 | 100% |
| 81 | Floor Covering | $ 34,040.74 | $ - 0 | $ - 0 | - 0 | 0.00% | - 0 | - 0 | ERROR:#DIV/0! |
| 84 | Free Gifts-Electrical | $ - 0 | $ - 0 | $ - 0 | - 0 | ERROR:#DIV/0! | - 0 | - 0 | ERROR:#DIV/0! |
| 85 | Furniture Repossession | $ 40,142.97 | $ 17,111.26 | $ (15,670.00) | 1,441.26 | 3.59% | 1 | 1 | 100% |
| totals | $ 5,532,726.24 | $ (34,492.96) | $ (13,466.27) | $ (47,959.23) | -0.87% | 3312 | 495 | 15% | |
| Overall % variance | -0.87% | Grade: |
3rd quarter 2017 warehouse 3
| WAREHOUSE ALL LOCATIONS STOCK COUNT VARIANCE REPORT 3RD QUARTER JANUARY 2018 | |||||||||
| CATEGORIES | STOCK VALUE @ COST | $VARIANCE @ COUNT | NET ADJUSTMENTS | VARIANCE AFTER ADJUSTMENTS | % VARIANCE | # OF ITEM LINES | LINE VARIANCE | % LINE VARIANCE | |
| 1 | Vision | $ 387,390.54 | $ (11,338.22) | $ 10,742.30 | $ (595.92) | -0.15% | 114 | 9 | 8% |
| 2 | Audio | $ 235,929.88 | $ (5,056.05) | $ 1,617.87 | $ (3,438.18) | -1.46% | 152 | 15 | 10% |
| 3 | Major White | $ 950,824.32 | $ 22,390.30 | $ (23,989.64) | $ (1,599.34) | -0.17% | 251 | 25 | 10% |
| 4 | Business Equipment | $ 761,956.75 | $ 6,318.56 | $ (6,274.40) | $ 44.16 | 0.01% | 209 | 8 | 4% |
| 5 | Small Appliances | $ 242,507.61 | $ 17,870.06 | $ (18,622.00) | $ (751.94) | -0.31% | 145 | 57 | 39% |
| 6 | Electrical Accessories | $ 24,942.38 | $ (1,103.87) | $ 955.84 | $ (148.03) | -0.59% | 41 | 9 | 22% |
| 8 | OPTICAL | $ 114,916.18 | $ (28,821.08) | $ 28,605.00 | $ (216.08) | -0.19% | 674 | 148 | 22% |
| 10 | RADIO SHACK | $ 4,359.49 | $ (556.49) | $ 242.66 | $ (313.83) | -7.20% | 13 | 2 | 15% |
| 14 | Free Gifts | $ 64,380.44 | $ (4,027.02) | $ 2,680.06 | $ (1,346.96) | -2.09% | 64 | 3 | 5% |
| 15 | Electrical Repossession | $ 33,067.16 | $ (4,387.00) | $ 7,246.32 | $ 2,859.32 | 8.65% | 52 | 3 | 6% |
| 16 | Essentials | $ 184,150.38 | $ (5,811.15) | $ 5,978.36 | $ 167.21 | 0.00% | 453 | 84 | 19% |
| 20 | Spare Parts | $ 15,855.03 | $ (282.46) | $ 282.46 | $ - 0 | 0.00% | 9 | 2 | 2% |
| 21 | PC's & Notebooks | $ 449,495.22 | $ (10,800.76) | $ 2,237.00 | $ (8,563.76) | -1.91% | 97 | 10 | 18% |
| 22 | Computer Accessories | $ 32,203.48 | $ (1,475.13) | $ 1,495.38 | $ 20.25 | 0.06% | 56 | 8 | 36% |
| 25 | Second hand pc | $ 81,524.87 | $ - 0 | $ - 0 | $ - 0 | 0.00% | 22 | - 0 | 0% |
| 50 | Lounge | $ 101,397.33 | $ (19,233.98) | $ 17,212.82 | $ (2,021.16) | -1.99% | 134 | 5 | 4% |
| 60 | Dining | $ 116,884.02 | $ 69.49 | $ (69.49) | $ - 0 | 0.00% | 42 | 1 | 2% |
| 70 | Bedroom | $ 46,073.11 | $ (2,594.57) | $ 2,295.35 | $ (299.22) | -0.65% | 96 | 3 | 3% |
| 75 | Bedding | $ 150,685.39 | $ (1,855.50) | $ 3,342.05 | $ 1,486.55 | 0.99% | 201 | 29 | 14% |
| 80 | Furniture Occasional | $ 115,854.44 | $ (7,346.04) | $ 2,248.48 | $ (5,097.56) | -4.40% | 275 | 28 | 10% |
| 81 | Floor Covering | $ 22,153.44 | $ (4,429.27) | $ 2,375.83 | $ (2,053.44) | -9.27% | 21 | 13 | 62% |
| 84 | Free Gifts-Electrical | $ 25,564.74 | $ (8,296.35) | $ 7,640.93 | $ (655.42) | -2.56% | 36 | 5 | 14% |
| 85 | Furniture Repossession | $ 608,623.39 | $ (61,918.49) | $ 55,217.91 | $ (6,700.58) | -1.10% | 1,269 | 247 | 19% |
| totals | $ 4,770,739.59 | $ (132,685.01) | $ 103,461.07 | $ (29,223.94) | -0.61% | 4426 | 714 | 16% | |
| Overall % variance | -0.61% | Grade: |
4th quarter 2017 warehouse 3
| WAREHOUSE 3 STOCK COUNT VARIANCE REPORT 4TH QUARTER MARCH 2018 | |||||||||
| CATEGORIES | STOCK VALUE @ COST | $VARIANCE @ COUNT | NET ADJUSTMENTS | VARIANCE AFTER ADJUSTMENTS | % VARIANCE | # OF ITEM LINES | LINE VARIANCE | % LINE VARIANCE | |
| 1 | Vision | $ 157,244.57 | $ (2,449.26) | $ 2,555.55 | 106.29 | 0.07% | 44 | 4 | 9% |
| 2 | Audio | $ 66,794.44 | $ 1,829.02 | $ (1,935.92) | (106.90) | -0.16% | 56 | 5 | 9% |
| 3 | Major White | $ 120,597.54 | $ (218.71) | $ 218.71 | - 0 | 0.00% | 84 | - 0 | 0% |
| 4 | Business Equipment | $ 549,846.18 | $ (984.34) | $ (927.91) | (1,912.25) | -0.35% | 38 | 2 | 5% |
| 5 | Small Appliances | $ 59,131.30 | $ (108.69) | $ 2,754.60 | 2,645.92 | 4.47% | 102 | 15 | 15% |
| 6 | Electrical Accessories | $ 12,341.35 | $ 483.17 | $ 170.34 | 653.51 | 5.30% | 32 | 2 | 6% |
| 8 | OPTICAL | $ - 0 | - 0 | ERROR:#DIV/0! | ERROR:#DIV/0! | ||||
| 10 | RADIO SHACK | $ 2,293.47 | $ (145.86) | $ 17.66 | (128.20) | -5.59% | 7 | 2 | 29% |
| 14 | Free Gifts | $ 2,798.88 | $ - 0 | $ - 0 | - 0 | 0.00% | 6 | - 0 | 0% |
| 15 | Electrical Repossession | $ 33,560.93 | $ (6,712.06) | $ 6,712.06 | - 0 | 0.00% | 49 | - 0 | 0% |
| 16 | Essentials | $ 6,029.50 | $ 30.22 | $ (45.84) | (15.62) | 0.00% | 26 | 4 | 15% |
| 20 | Spare Parts | - 0 | 0.00% | 0% | |||||
| 21 | PC's & Notebooks | $ 267,146.24 | $ 1,085.76 | $ 197.25 | 1,283.01 | 0.48% | 55 | 2 | 9% |
| 22 | Computer Accessories | $ 14,330.14 | $ (386.55) | $ 145.66 | (240.89) | -1.68% | 23 | 5 | ERROR:#DIV/0! |
| 25 | Second hand pc | $ (1,554.49) | - 0 | 0.00% | 0% | ||||
| 50 | Lounge | $ 51,685.47 | $ (1,935.26) | $ 1,972.37 | 37.11 | 0.07% | 43 | 1 | 2% |
| 60 | Dining | $ 16,024.85 | $ - 0 | $ - 0 | - 0 | 0.00% | 16 | - 0 | 0% |
| 70 | Bedroom | $ 25,325.23 | $ - 0 | $ - 0 | - 0 | 0.00% | 36 | - 0 | 0% |
| 75 | Bedding | $ 60,276.85 | $ (652.39) | $ 1,204.09 | 551.70 | 0.92% | 76 | 6 | 8% |
| 80 | Furniture Occasional | $ 58,775.91 | $ (2,336.32) | $ 3,309.02 | 972.70 | 1.65% | 187 | 6 | 3% |
| 81 | Floor Covering | $ 11,677.32 | $ 402.45 | $ 872.50 | 1,274.95 | 10.92% | 28 | 5 | 18% |
| 84 | Free Gifts-Electrical | $ - 0 | - 0 | ERROR:#DIV/0! | ERROR:#DIV/0! | ||||
| 85 | Furniture Repossession | $ - 0 | ERROR:#DIV/0! | ERROR:#DIV/0! | |||||
| totals | $ 1,514,325.68 | $ (12,098.80) | $ 17,220.13 | $ 5,121.33 | 0.34% | 908 | 59 | 6% | |
| Overall % variance | 0.34% | Grade: |
1st quarter 2018 warehouse 3
| WHO3 STOCK COUNT VARIANCE REPORT 1ST QUARTER JUNE 2018 | |||||||||
| CATEGORIES | STOCK VALUE @ COST | $VARIANCE @ COUNT | NET ADJUSTMENTS | VARIANCE AFTER ADJUSTMENTS | % VARIANCE | # OF ITEM LINES | LINE VARIANCE | % LINE VARIANCE | |
| 1 | Vision | $ 129,446.65 | $ (1,787.19) | $ 1,787.19 | $ - 0 | 0.00% | 45 | 1 | 2% |
| 2 | Audio | $ 49,149.63 | $ 2.96 | $ (763.15) | $ (760.19) | -1.55% | 45 | 1 | 2% |
| 3 | Major White | $ 112,732.54 | $ 3,630.86 | $ (4,127.60) | $ (496.74) | -0.44% | 78 | 1 | 1% |
| 4 | Business Equipment | $ 876,851.17 | $ (5,001.81) | $ 2,879.56 | $ (2,122.25) | -0.24% | 45 | 1 | 2% |
| 5 | Small Appliances | $ 87,122.02 | $ (1,374.96) | $ 1,311.82 | $ (63.14) | -0.07% | 114 | 3 | 3% |
| 6 | Electrical Accessories | $ 9,959.84 | $ 81.25 | $ (86.23) | $ (4.98) | -0.05% | 31 | 6 | 19% |
| 8 | OPTICAL | $ 139.14 | $ (139.14) | $ 139.14 | $ - 0 | 0.00% | 1 | 0% | |
| 10 | RADIO SHACK | $ 845.40 | $ (740.79) | $ 699.65 | $ (41.14) | -4.87% | 3 | 3 | 100% |
| 14 | Free Gifts | $ 1,611.60 | $ (16.78) | $ - 0 | $ (16.78) | -1.04% | 3 | 1 | 33% |
| 15 | Electrical Repossession | $ 1,220.45 | $ (805.00) | $ 805.00 | $ - 0 | 0.00% | 2 | 0% | |
| 16 | Essentials | $ 4,708.78 | $ 464.00 | $ (115.88) | $ 348.12 | 7.39% | 19 | 6 | 32% |
| 20 | Spare Parts | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ERROR:#DIV/0! | 2 | 2 | 100% |
| 21 | PC's & Notebooks | $ 407,867.72 | $ (41,190.41) | $ 40,689.99 | $ (500.42) | -0.12% | 57 | 1 | 2% |
| 22 | Computer Accessories | $ 10,918.26 | $ 920.21 | $ (717.85) | $ 202.36 | 1.85% | 20 | 3 | 15% |
| 25 | Second hand pc | $ (1,554.49) | $ - 0 | 0.00% | ERROR:#DIV/0! | ||||
| 50 | Lounge | $ 63,678.13 | $ (1,485.91) | $ 1,485.91 | $ - 0 | 0.00% | 48 | 0% | |
| 60 | Dining | $ 12,252.80 | $ (256.76) | $ 256.76 | $ - 0 | 0.00% | 12 | 0% | |
| 70 | Bedroom | $ 23,415.33 | $ - 0 | $ - 0 | $ - 0 | 0.00% | 31 | 0% | |
| 75 | Bedding | $ 55,858.11 | $ (442.96) | $ 538.24 | $ 95.28 | 0.17% | 77 | 6 | 8% |
| 80 | Furniture Occasional | $ 54,871.07 | $ 1,405.91 | $ (1,292.15) | $ 113.76 | 0.21% | 182 | 4 | 2% |
| 81 | Floor Covering | $ 8,453.76 | $ (248.00) | $ 152.04 | $ (95.96) | -1.14% | 22 | 1 | 5% |
| 84 | Free Gifts-Electrical | $ - 0 | $ - 0 | ERROR:#DIV/0! | ERROR:#DIV/0! | ||||
| 85 | Furniture Repossession | $ 0.01 | $ 0.01 | $ 0.01 | 100.00% | 1 | 0% | ||
| totals | $ 1,909,547.92 | $ - 0 | $ - 0 | $ (3,342.07) | -0.18% | 838 | 40 | 5% | |
| Overall % variance | -0.18% | Grade: |
