0% found this document useful (0 votes)
34 views10 pages

Ice Plant Monthly Inventory

The document provides monthly inventory summaries for Iriga Ice Plant & Cold Storage from January to July 2023. It shows the beginning inventory, ice harvested, total available, ice sold, and ending inventory for each of the company's three Vilter machines. The May summary shows no harvesting or sales that month, with an ending inventory of 23 units for Vilter 3.

Uploaded by

bro chill
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
0% found this document useful (0 votes)
34 views10 pages

Ice Plant Monthly Inventory

The document provides monthly inventory summaries for Iriga Ice Plant & Cold Storage from January to July 2023. It shows the beginning inventory, ice harvested, total available, ice sold, and ending inventory for each of the company's three Vilter machines. The May summary shows no harvesting or sales that month, with an ending inventory of 23 units for Vilter 3.

Uploaded by

bro chill
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd

Iriga Ice Plant & Cold Storage, Inc.

Iriga City

Monthly Inventory
For the Month of January 2023

Summary
Vilter 1 Vilter 2 Vilter 3
Beg. Invty.(Stored at the start of the month) 34 0 0
Add: Harvested 1980 0 1600
Total Invty. Available for Sale 2014 0 1600
Less: Sold Ice 2014 0 1600
Ending Invt(Stored at the end of the month) 0 0 0
Iriga Ice Plant & Cold Storage, Inc.
Iriga City

Monthly Inventory
For the Month of February 2023

Summary
Vilter 1 Vilter 2 Vilter 3
Beg. Invty.(Stored at the start of the month) 0 0 0
Add: Harvested 3000 0 1860
Total Invty. Available for Sale 3000 0 1860
Less: Sold Ice 3000 0 1860
Ending Invt(Stored at the end of the month) 0 0 0
Iriga Ice Plant & Cold Storage, Inc.
Iriga City

Monthly Inventory
For the Month of March 2023

Summary
Vilter 1 Vilter 2 Vilter 3
Beg. Invty.(Stored at the start of the month) 0 0 0
Add: Harvested 3660 0 3100
Total Invty. Available for Sale 3660 0 3100
Less: Sold Ice 3603 0 3100
Ending Invt(Stored at the end of the month) 57 0 0
Iriga Ice Plant & Cold Storage, Inc.
Iriga City

Monthly Inventory
For the Month of April 2023

Summary
Vilter 1 Vilter 2 Vilter 3
Beg. Invty.(Stored at the start of the month) 57 0 0
Add: Harvested 3420 0 4100
Total Invty. Available for Sale 3477 0 4100
Less: Sold Ice 3477 0 4077
Ending Invt(Stored at the end of the month) 0 0 23
Iriga Ice Plant & Cold Storage, Inc.
Iriga City

Monthly Inventory
For the Month of May 2023

Summary
Vilter 1 Vilter 2 Vilter 3
Beg. Invty.(Stored at the start of the month) 0 0 23
Add: Harvested 3540 0 4800
Total Invty. Available for Sale 3540 0 4823
Less: Sold Ice 3465 0 4823
Ending Invt(Stored at the end of the month) 75 0 0
Iriga Ice Plant & Cold Storage, Inc.
Iriga City

Monthly Inventory
For the Month of June 2023

Summary
Vilter 1 Vilter 2 Vilter 3
Beg. Invty.(Stored at the start of the month) 75 0 0
Add: Harvested 6000 0 4100
Total Invty. Available for Sale 6075 0 4100
Less: Sold Ice 6031 0 4018
Ending Invt(Stored at the end of the month) 44 0 82
Iriga Ice Plant & Cold Storage, Inc.
Iriga City

Monthly Inventory
For the Month of July 2023

Summary
Vilter 1 Vilter 2 Vilter 3
Beg. Invty.(Stored at the start of the month) 44 0 82
Add: Harvested 1140 0 300
Total Invty. Available for Sale 1184 0 382
Less: Sold Ice 1184 0 314
Ending Invt(Stored at the end of the month) 0 0 68
IRIGA ICE PLANT & COLD STORAGE, INC.
Summary of Sales Per Blocks - Days Shift & Night Shift
March 13 to 21, 2023

Date Day Shift Night Shift Total Amount


03/13/2023 119.00 52.00 171.00 54,720.00
03/14/2023 99.00 214.00 313.00 100,160.00
03/15/2023 124.00 130.00 254.00 81,280.00
03/16/2023 253.00 206.00 459.00 146,880.00
03/17/2023 306.00 280.00 586.00 187,520.00
03/18/2023 243.00 334.00 577.00 184,640.00
03/19/2023 237.00 53.00 290.00 92,800.00
03/20/2023 123.00 149.00 272.00 87,040.00
03/21/2023 165.00 250.00 415.00 132,800.00
1,669.00 1,668.00 1,067,840.00
IRIGA ICE PLANT & COLD STORAGE, INC.
Summary of Sales Per Blocks - Days Shift & Night Shift
March 13 to 21, 2023

Date Day Shift Night Shift Total


03/13/2023 119.00 52.00 171.00
03/14/2023 99.00 214.00 313.00
03/15/2023 124.00 130.00 254.00
03/16/2023 253.00 206.00 459.00
03/17/2023 306.00 280.00 586.00
03/18/2023 243.00 334.00 577.00
03/19/2023 237.00 53.00 290.00
03/20/2023 123.00 149.00 272.00
03/21/2023 165.00 250.00 415.00
1,669.00 1,668.00 3,337.00

Day Shift Night Shift Total

Average Per Blocks 185.44 185.33 370.78


Iriga Ice Plant & Cold Storage, Inc.
Iriga City

Monthly Inventory
For the Month of May 2023

Summary
Vilter 1 Vilter 2 Vilter 3
Beg. Invty.(Stored at the start of the month) 0 0 23
Add: Harvested 0 0 0
Total Invty. Available for Sale 0 0 23
Less: Sold Ice 0 0 0
Ending Invt(Stored at the end of the month) 0 0 23

You might also like