Post the inventories received and issued to the following

a. Supplies Ledger Card

(if possible can you do it in excel and provide some explanation)

Purchases on Account Date Particulars Quantity Unit Cost Amount 3/1/2015 Bond Paper, A4 200 ream 165.00 33,000.00 Ink, HP # 22 50 pcs 1,250.00 62,500.00 Ink, Samsung 2850D 50 pcs 1,560.00 78,000.00 Ink Samsung 2250 50 pcs 1,600.00 80,000.00 3/20/2015 Acer desktop 10 pcs 14,500.00 145,000.00 Carrier, airconditioning unit 5 pcs 12,800.00 64,000.00 Samsung Laptop 5 pcs 12,000.00 60,000.00 Ink, HP # 22 20 pcs 1,560.00 31,200.00 Samsung 2850D 30 pcs 1,500.00 45,000.00 3/25/2015 Official Receipt (OR) 100 booklets 100.00 10,000.00 3/30/2015 Printed application forms 4 reams 150.00 600.00 Canned goods, blankets, mats, kitchen utensils, 3/30/2015 flashlights and others. 40 bxs 500.00 20,000.00ISSUE Date Particulars Quantity Unit Cost Amount End User 3/11/2015 Band Paper,A4 25 roam: 165.00 5,775.00 Office of the Secretary 15 reams 165.00 2,475.00 Admin & Technical Service 30 ream: 3,250.00 Ink, HP # 22 1,250.00 6,250.00 Office of the Secretary 5 1,250.00 6,250.00 Admin & Technical Service 5 1,250.00 5,250.00 Pol5 15 pCE 18,750.00 Ink, Samsung 28500 10 pcs 1,560.00 15,600.00 Admin & Technical Service 10 pcs 1,560.00 15,600.00 Pol5 1,560.00 7,800.00 Reg 25 pcs 39,000.00 Ink, Samsung 2250 10 pcs 1,500.00 16,000.00 Mans 3/30/2015 Samsung 28500 1,527.27 7,636.35 Osec 4 OCE 1,527.27 6,109.08 Admin & Technical Service 1,527.27 12,218.16 Pol5 1,527.27 12,218.16 Mans 5 OCE 1,527.27 7,636.35 Regs 45,816.10 Acer desktop 2 pcs 14,500.00 29,000.00 Osec - name 2 PCS 14,500.00 29,000.00 |Man5 - name 1 pc 14,500.00 14,500.00 LFPS - name 5 pCE 72,500.00 Carrier, airconditioning unit 1 pc 12,600.00 12,800.00 Osec - name 1 pc 12,800.00 12,600.00 Admin and Technical Service 1 pc 12,600.00 12,600.00 Pol5 2 PCE 12,800.00 25,500.00 Mans 5 pcz 64,000.00 Samsung Laptop 1 pc 12,000.00 12,000.00 Osec - name 12,000.00 48,000.00 Mans 60.000.00 3/30/2015 Official Receipt (OR) 30 booklets 100.00 3,000.00 0sec 10 booklets 100.00 1,000.00 Admin and Technical Service 5 booklets 100.00 600.00 Pol5 50 booklets 100.00 5,000.00 Mans 5 booklets 100.00 600.00 Regs 10,000.00ISSUE Date Particulars Quantity Unit Cost Amount End User Printed application forms 3 reams 150.00 450.00 Osec 1 ream 150.00 150.00 ManS 4 reams 600.00 Canned goods, blankets, mats, kitchen utensils, flashlights and others. 500.00 4,000.00 Osec 500.00 4,000.00 Admin and Technical Service 500.00 12,000.00 Regs 40 bxs 20,000.00 Canned goods, blankets, mats, kitchen utensils, flashlights and others. 40 bxs 500.00 20,000.00 HRMO