Monthly Inventory Report

  • November 2019
  • PDF

This document was uploaded by user and they confirmed that they have the permission to share it. If you are author or own the copyright of this book, please report to us by using this DMCA report form. Report DMCA


Overview

Download & View Monthly Inventory Report as PDF for free.

More details

  • Words: 2,314
  • Pages: 7
January 1 Alturas Supermarket 2 Alturas Supermarket 3 Bloomingdales Dep't Store 4 Bohol Quality 5 Gaisano City Mall 6 Gaisano Country Mall 7 Island City Mall 8 Island City Mall 9 Island City Mall 10 Island City Mall 11 KCC Mall of Gensan 12 KCC Mall of Gensan 13 KCC Mall of Gensan 14 KCC Mall of Marbel 15 KCC Mall of Marbel 16 Lee Super Plaza 17 Lopues Mandalagan 18 New NCCC Mall 19 Plaza Marcela 20 Southway Square 21 Southway Square 22 Victoria Dep't Store 23 Victoria Dep't Store 24 Victoria Dep't Store 25 White Gold Club 26 White Gold Club 27 White Gold Club

HR SP HR MB HR HR HR HM SP FE HR MB HM HR MB HR HR HR HR MB SP HR MB HM HR MB FE

February

March 311 612 770 957 1,538 634 675 240 509 398 1,548 1,235 283 857 959 880 1,811 1,372 628

Php184,379.75 Php305,575.00 Php631,899.00 Php960,448.00 ### Php265,309.20 Php460,807.00 Php149,637.00 Php283,358.00 Php587,074.00 ### Php601,602.95 Php170,982.00 Php525,492.50 Php444,341.00 Php642,397.00 ### ### Php469,446.50

Total

343 779 1,475 1,527 1,564 774 718 221 607 283 1,581 1,450 174 1,226 1,236 635 1,958 1,485 711

Php203,778.25 Php378,262.00 ### Php944,625.00 ### Php325,454.50 Php405,118.00 Php146,991.00 Php348,747.00 Php476,207.00 ### Php696,278.90 Php101,431.00 Php813,977.00 Php564,853.00 Php503,651.00 ### Php977,344.30 Php514,208.00

329 706 870 1,020 1,568 688 741 235 563 380 1,532 1,298 162 1,004 1,147 730 1,904 1,393 695

Php198,786.25 Php342,443.00 Php680,447.00 ### ### Php304,393.00 Php522,284.90 Php160,101.00 Php315,782.00 Php586,695.00 ### Php837,838.95 Php101,967.00 Php612,689.00 Php535,489.00 Php581,016.00 ### Php989,222.00 Php505,062.50

983 2,097 3,115 3,504 4,670 2,096 2,134 696 1,679 1,061 4,661 3,983 619 3,087 3,342 2,245 5,673 4,250 2,034

### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ###

1,625 1,621 196 1,198 1,208 226

### Php845,031.40 Php128,631.00 Php945,867.00 Php615,677.50 Php357,247.00

1,383 1,574 191 1,190 955 396

Php902,516.50 1,224 Php894,747.50 4,232 Php772,159.40 975 Php496,483.20 4,170 Php128,295.00 286 Php176,605.00 673 Php831,081.00 1,124 Php746,450.50 3,512 Php528,607.50 1,160 Php603,481.00 3,323 Php571,126.00 458 Php534,081.00 1,080

### ### ### ### ### ###

April Alturas Supermarket Alturas Supermarket Bloomingdales Dep't Store Bohol Quality Gaisano City Mall Gaisano Country Mall Island City Mall Island City Mall Island City Mall Island City Mall KCC Mall of Gensan KCC Mall of Gensan KCC Mall of Gensan KCC Mall of Marbel KCC Mall of Marbel Lee Super Plaza Lopues Mandalagan New NCCC Mall Plaza Marcela Southway Square Southway Square Victoria Dep't Store Victoria Dep't Store Victoria Dep't Store White Gold Club White Gold Club White Gold Club

HR SP HR MB HR HR HR HM SP FE HR MB HM HR MB HR HR HR HR MB SP HR MB HM HR MB FE

May

359 942 749 938 1,517 517 707 269 566 456 1,413 1,224 270 808 889 872 2,037 1,336 423

Php216,799.25 Php464,931.00 Php603,822.00 Php941,514.50 ### Php227,737.50 Php486,131.40 Php171,118.00 Php281,665.00 Php657,576.00 ### Php596,954.95 Php169,529.00 Php513,933.50 Php430,124.50 Php668,117.00 ### Php996,672.00 Php249,282.50

332 853 822 951 1,413 423 660 229 493 390 1,508 1,197 246 853 874 1,131 1,918 1,310 768

Php170,739.50 Php397,074.50 Php673,674.00 Php951,012.00 ### Php180,365.00 Php383,636.50 Php157,800.00 Php269,300.00 Php548,344.75 ### Php583,979.95 Php161,982.00 Php599,221.50 Php423,667.00 Php807,754.00 ### Php842,606.00 Php564,129.50

1,158 974 275 1,032 961 476

Php964,962.00 1,104 Php832,444.60 Php495,657.60 924 Php490,545.20 Php167,969.00 263 Php160,220.00 Php659,306.50 856 Php563,119.50 Php477,089.00 1,102 Php498,278.00 Php656,095.00 370 Php451,367.00

June 317 915 911 949 1,474 779 616 206 496 326 1,465 1,138 213 892 856 1,196 1,906 1,089 784 596 154 1,031 819 233 922 1,121 592

Php169,608.00 Php418,532.50 Php697,812.00 Php931,360.00 Php997,463.00 Php105,584.50 Php380,488.00 Php130,980.00 Php374,051.00 Php417,151.50 ### Php553,715.95 Php135,800.00 Php592,429.50 Php417,157.00 Php804,230.50 ### Php758,206.00 Php606,535.50 Php430,702.00 Php97,796.00 Php754,666.00 Php445,814.00 Php150,968.00 Php571,043.50 Php591,135.00 Php673,676.00

Total 1,008 2,710 2,482 2,838 4,404 1,719 1,983 704 1,555 1,172 4,386 3,559 729 2,553 2,619 3,199 5,861 3,735 1,975 596 154 3,293 2,717 771 2,810 3,184 1,438

### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### Php97,796.00 ### ### ### ### ### ###

July Alturas Supermarket Alturas Supermarket Bloomingdales Dep't Store Bohol Quality Gaisano City Mall Gaisano Country Mall Island City Mall Island City Mall Island City Mall Island City Mall KCC Mall of Gensan KCC Mall of Gensan KCC Mall of Gensan KCC Mall of Marbel KCC Mall of Marbel Lee Super Plaza Lopues Mandalagan New NCCC Mall Plaza Marcela Southway Square Southway Square Victoria Dep't Store Victoria Dep't Store Victoria Dep't Store White Gold Club White Gold Club White Gold Club

HR SP HR MB HR HR HR HM SP FE HR MB HM HR MB HR HR HR HR MB SP HR MB HM HR MB FE

297 890 960 882 1,489 1,058 597 181 452 307 1,600 1,089 148 945 855 1,118 1,943 1,214 800 696 251 1,110 938 223 1,026 991 493

Php160,668.50 Php409,836.50 Php738,390.00 Php919,223.50 ### Php550,595.00 Php351,987.00 Php117,468.00 Php248,749.50 Php408,191.00 ### Php521,026.95 Php97,148.00 Php626,323.50 Php416,230.00 Php795,443.50 ### Php780,237.00 Php597,524.00 Php490,846.00 Php166,942.00 Php847,029.40 Php503,391.00 Php145,801.00 Php728,651.00 Php484,635.00 Php692,562.00

August 322 833 1,020 889 1,512 1,244 586 172 411 295 1,600 1,047 160 873 889 1,066 1,895 1,006 838 760 284 1,262 860 184 927 911 524

Php186,629.00 Php389,533.50 Php780,199.00 Php930,329.50 ### Php715,232.00 Php372,242.00 Php114,431.00 Php230,908.50 Php393,422.00 ### Php507,997.45 Php90,705.20 Php413,264.60 Php600,013.50 Php758,481.00 ### Php738,937.00 Php631,523.50 Php519,406.00 Php175,509.00 Php924,284.70 Php456,569.50 Php119,334.00 Php807,384.00 Php489,895.00 Php621,247.00

September 344 965 1,019 1,139 1,225 1,186 740 183 406 273 1,558 1,112 169 956 942 1,046 2,082 1,323 733 771 520 1,187 940 185 977 1,148 460

Php192,591.00 Php503,650.50 Php787,899.00 ### Php881,360.00 Php670,946.50 Php686,150.75 Php119,001.00 Php218,270.00 Php366,620.50 ### Php537,606.55 Php96,635.00 Php639,518.00 Php440,121.50 Php737,678.50 ### ### Php616,279.25 Php521,637.00 Php299,805.00 Php846,300.20 Php505,778.00 Php119,739.00 Php700,935.00 Php544,340.00 Php599,994.00

Total 963 2,688 2,999 2,910 4,226 3,488 1,923 536 1,269 875 4,758 3,248 477 2,774 2,686 3,230 5,920 3,543 2,371 2,227 1,055 3,559 2,738 592 2,930 3,050 1,477

### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ###

October Alturas Supermarket Alturas Supermarket Bloomingdales Dep't Store Bohol Quality Gaisano City Mall Gaisano Country Mall Island City Mall Island City Mall Island City Mall Island City Mall KCC Mall of Gensan KCC Mall of Gensan KCC Mall of Gensan KCC Mall of Marbel KCC Mall of Marbel Lee Super Plaza Lopues Mandalagan New NCCC Mall Plaza Marcela Southway Square Southway Square Victoria Dep't Store Victoria Dep't Store Victoria Dep't Store White Gold Club White Gold Club White Gold Club

HR SP HR MB HR HR HR HM SP FE HR MB HM HR MB HR HR HR HR MB SP HR MB HM HR MB FE

317 1,047 1,024 1,553 1,264 1,019 687 232 384 272 1,700 1,466 255 1,027 1,228 1,147 2,122 1,289 840 785 496 1,192 1,275 231 972 1,122 390

Php173,649.50 Php496,849.50 Php794,878.00 ### Php920,512.00 Php544,665.00 Php425,180.00 Php172,629.00 Php205,057.50 Php340,269.00 ### Php619,035.95 Php174,376.80 Php590,236.50 Php472,026.50 Php799,400.00 ### Php952,770.00 Php637,079.25 Php523,466.00 Php278,626.00 Php717,232.00 Php640,435.00 Php153,424.50 Php615,529.50 Php562,951.00 Php456,618.00

November 276 1,100 1,254 1,527 1,404 851 873 265 418 408 1,820 1,613 411 1,050 1,450 1,176 2,296 1,189 931 951 596 1,418 1,487 345 795 399

Php160,818.00 Php533,906.00 Php961,829.00 ### Php920,449.00 Php455,557.50 Php546,257.00 Php199,595.00 Php223,911.00 Php509,169.00 ### Php689,491.05 Php297,025.30 Php625,235.00 Php566,816.00 Php824,703.00 ### Php888,067.00 Php693,604.75 Php652,650.00 Php321,318.00 Php943,026.50 Php734,964.00 Php252,511.00 Php553,832.00

December

Total

284 Php166,236.00 877 1,098 Php540,799.00 3,245

### ###

1,250 1,091 1,414 792 280 515 447 1,863 1,275 362 965 1,137 1,143

1,158 677 851 743 1,334 1,320 349 1,126 912 Php429,224.50 429

Php606,060.50 Php698,132.00 Php802,409.50 Php500,900.00 Php203,400.00 Php308,625.00 Php571,227.00 ### Php552,243.45 Php265,381.00 Php593,596.00 Php479,345.30 Php841,139.00

4,330 3,759 3,284 2,352 777 1,317 1,127 5,383 4,354 1,028 3,042 3,815 3,466

### ### ### ### ### ### ### ### ### ### ### ### ###

Php860,360.00 Php432,702.50 Php580,997.00 Php405,868.00 Php911,188.90 Php667,387.00 Php247,438.00 Php762,972.00 Php433,534.00 Php561,915.00

3,636 2,448 2,587 1,835 3,944 4,082 925 2,893

### ### ### ### ### ### ### ###

1,218

###

1st Quarter Alturas Supermarket Alturas Supermarket Bloomingdales Dep't Store Bohol Quality Gaisano City Mall Gaisano Country Mall Island City Mall Island City Mall Island City Mall Island City Mall KCC Mall of Gensan KCC Mall of Gensan KCC Mall of Gensan KCC Mall of Marbel KCC Mall of Marbel Lee Super Plaza Lopues Mandalagan New NCCC Mall Plaza Marcela Southway Square Southway Square Victoria Dep't Store Victoria Dep't Store Victoria Dep't Store White Gold Club White Gold Club White Gold Club

HR SP HR MB HR HR HR HM SP FE HR MB HM HR MB HR HR HR HR MB SP HR MB HM HR MB FE

983 2,097 3,115 3,504 4,670 2,096 2,134 696 1,679 1,061 4,661 3,983 619 3,087 3,342 2,245 5,673 4,250 2,034 0 0 4,232 4,170 673 3,512 3,323 1,080

Php586,944.25 ### ### ### ### Php895,156.70 ### Php456,729.00 Php947,887.00 ### ### ### Php374,380.00 ### ### ### ### ### ### PhpPhp### ### Php433,531.00 ### ### ###

2nd Quarter 1,008 2,710 2,482 2,838 4,404 1,719 1,983 704 1,555 1,172 4,386 3,559 729 2,553 2,619 3,199 5,861 3,735 1,975 596 154 3,293 2,717 771 2,810 3,184 1,438

Php557,146.75 ### ### ### ### Php513,687.00 ### Php459,898.00 Php925,016.00 ### ### ### Php467,311.00 ### ### ### ### ### ### Php430,702.00 Php97,796.00 ### ### Php479,157.00 ### ### ###

3rd Quarter 963 2,688 2,999 2,910 4,226 3,488 1,923 536 1,269 875 4,758 3,248 477 2,774 2,686 3,230 5,920 3,543 2,371 2,227 1,055 3,559 2,738 592 2,930 3,050 1,477

Php539,888.50 ### ### ### ### ### ### Php350,900.00 Php697,928.00 ### ### ### Php284,488.20 ### ### ### ### ### ### ### Php642,256.00 ### ### Php384,874.00 ### ### ###

4th Quarter 877 3,245 0 4,330 3,759 3,284 2,352 777 1,317 1,127 5,383 4,354 1,028 3,042 3,815 3,466 0 3,636 2,448 2,587 1,835 3,944 4,082 925 2,893 0 1,218

### ### Php### ### ### ### ### ### ### ### ### ### ### ### ### Php### ### ### ### ### ### ### ### Php###

O-Total 3,831 ### 8,596 ### ### ### 8,392 2,713 5,820 4,235 ### ### 2,853 ### ### ### ### ### 8,828 5,410 3,044 ### ### 2,961 ### 9,557 5,213

### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ###

January 1 Alturas Supermarket 2 Alturas Supermarket 3 Bloomingdales Dep't Store 4 Bohol Quality 5 Gaisano City Mall 6 Gaisano Country Mall 7 Island City Mall 8 Island City Mall 9 Island City Mall 10 Island City Mall 11 KCC Mall of Gensan 12 KCC Mall of Gensan 13 KCC Mall of Gensan 14 KCC Mall of Marbel 15 KCC Mall of Marbel 16 Lee Super Plaza 17 Lopues Mandalagan 18 New NCCC Mall 19 Plaza Marcela 20 Southway Square 21 Southway Square 22 Victoria Dep't Store 23 Victoria Dep't Store 24 Victoria Dep't Store 25 White Gold Club 26 White Gold Club 27 White Gold Club

HR SP HR MB HR HR HR HM SP FE HR MB HM HR MB HR HR HR HR MB SP HR MB HM HR MB FE

260 930 1,060 1,128 1,054 1,224 693 267 432 429 1,569 1,096 312 764 961 848 1,767 972 499 808 698 1,150 1,150 314 1,077 832 472

Php150,702.00 Php467,815.00 Php836,753.00 Php531,486.50 Php736,870.00 Php771,071.10 Php404,841.00 Php146,277.50 Php146,986.60 Php290,633.00 Php1,139,077.00 Php461,762.45 Php231,641.00 Php478,951.00 Php397,847.50 Php631,207.50 Php1,031,081.00 Php739,961.00 Php252,393.00 Php532,528.00 Php374,415.00 Php607,252.30 Php545,298.50 Php222,240.50 Php706,536.00 Php386,171.50 Php631,687.00

February 227 795 1,100 1,066 1,159 1,188 666 262 364 404 1,726 1,264 406 868 1,019 1,031

Php120,476.00 Php214,097.50 Php872,598.00 Php448,734.50 Php826,633.00 Php752,393.50 Php358,830.00 Php158,693.20 Php145,931.50 Php298,401.75 Php1,233,239.00 Php599,895.95 Php299,165.50 Php550,661.50 Php471,841.00 Php716,547.00

942 396 753 669 1,155 1,211 354 1,045 623 300

Php702,734.00 Php209,190.50 Php509,850.00 Php351,696.00 Php620,725.00 Php577,701.00

April 1 Alturas Supermarket 2 Alturas Supermarket 3 Bloomingdales Dep't Store 4 Bloomingdales Dep't Store 5 Bohol Quality 6 Gaisano City Mall 7 Gaisano Country Mall 8 Island City Mall 9 Island City Mall 10 Island City Mall 11 Island City Mall 12 KCC Mall of Gensan 13 KCC Mall of Gensan 14 KCC Mall of Gensan

HR SP HR HM MB HR HR HR HM SP FE HR MB HM

March

974

Php722,540.00

1,722 1,067 397 755 981

Php1,240,820.50 Php501,705.00 Php277,714.50 Php483,332.00 Php473,323.70

721 639 1,082 1,148 353

Php495,890.50 Php339,867.00 Php636,152.00 Php583,131.00 Php228,160.37

Php749,591.00 Php302,980.00 Php113,148.18

May

906 89

Php688,382.00 Php49,323.00

1,193

Php863,694.00

1,562 1,011 406

Php1,118,854.00 Php446,911.00 Php241,682.00

June

845 145

Php653,401.00 Php81,869.00

1,567 980 444

Php1,135,852.00 Php441,650.25 Php272,133.25

15 KCC Mall of Marbel 16 KCC Mall of Marbel 17 Lee Super Plaza 18 Lopues Mandalagan 19 New NCCC Mall 20 Plaza Marcela 21 Southway Square 22 Southway Square 23 Victoria Dep't Store 24 Victoria Dep't Store 25 Victoria Dep't Store 26 White Gold Club 27 White Gold Club 28 White Gold Club

HR MB HR HR HR HR MB SP HR MB HM HR MB FE

776 1,091

Php505,822.50 Php543,197.60

723 1,050

Php433,130.55 Php469,724.00

830

Php616,816.00

801

Php603,404.00

912 995 315

Php549,351.80 Php481,640.50 Php204,602.50

830 869

Php466,650.40 Php410,139.50

July 1 Alturas Supermarket 2 Alturas Supermarket 3 Bloomingdales Dep't Store 4 Bloomingdales Dep't Store 5 Bohol Quality 6 Gaisano City Mall 7 Gaisano Country Mall 8 Island City Mall 9 Island City Mall 10 Island City Mall 11 Island City Mall 12 KCC Mall of Gensan 13 KCC Mall of Gensan 14 KCC Mall of Gensan 15 KCC Mall of Marbel 16 KCC Mall of Marbel 17 Lee Super Plaza 18 Lopues Mandalagan 19 New NCCC Mall 20 Plaza Marcela 21 Southway Square 22 Southway Square 23 Victoria Dep't Store 24 Victoria Dep't Store 25 Victoria Dep't Store 26 White Gold Club 27 White Gold Club 28 White Gold Club

HR SP HR HM MB HR HR HR HM SP FE HR MB HM HR MB HR HR HR HR MB SP HR MB HM HR MB FE

August

September

885 218

Php685,066.00 Php135,226.00

877 371

Php681,730.00 Php242,061.00

1,082

Php791,980.00

1,072

Php703,952.00

1,036

Php708,694.00

1,562 996 397 705 1,101

Php1,129,193.50 Php447,492.25 Php241,311.50 Php417,067.75 Php464,039.75

1,499 1,185 421 775 1,240

Php1,048,005.50 Php518,809.25 Php257,384.00 Php476,578.25 Php550,906.00

667 1,203

Php419,647.25 Php474,320.50

800

Php601,250.00

756

Php558,645.00

821 898

Php508,048.10 Php425,756.25

709 843

Php441,035.25 Php407,639.15

Related Documents

Monthly Inventory Report
November 2019 22
Monthly End Inventory
November 2019 10
Report Inventory Ion 2003
November 2019 9
Monthly Uptime Report
November 2019 19
Monthly Report Oct
May 2020 9