Create a Cost of Goods Manufactured using below information:
COST OF GOODS MANUFACTURED Year 2 QUANTITY (Units) AL NUM PRICE PROJECTED INGREDIENTS JAN FEB MAR APR MAY JUN JUL AUG SEP OCT NOV DEC items COST Papaya (kl) 33 24 27 21 21 19 24 27 24 15 21 15 271 35 9,485.00 Flour (kl) 66 48 54 42 42 38 48 54 48 30 42 30 542 15 8,130.00 Sugar (kl) 56 48 54 42 42 38 48 54 18 30 42 30 542 30 16,260.00 Salt (kl) 12 10 11 8 7 10 9 6 8 6 103 20 2,060.00 Oil (L) 12 10 11 7 10 9 6 8/ 6 103 90 9,270.00 Cinnamon (bottle) 12 10 1 7 8 10 9 6 8 6 103 50 5,150.00 Current consumption - deep fryer 1800 1500 1650 1200 1200 1050 1200 1500 1350 900 1050 900 15300 1 15,300.00 Packaging 1800 1500 1650 1200 1200 1050 1200 1500 1350 900 1050 900 15300 13 198,900.00 Direct Labor 3500 3500 3500 3500 3500 3500 3500 3500 3500 3500 3500 3500 42000 1 42.000.00 Total for CY 2019 306,555.00 units cost total cost Cost of goods manufactured 15300 20.04 306,555.00 Cost of sales (from FG end) 4200 19.97 83,860.00 Cost of sales (from produced) 8202 20.04 164,337.52 Finished goods inventory 7098 20.04 142,217.48A B C D E F G H Raw Materials Unit Price Quantity Cost/month Cost/Year All-Purpose Flour 50php/kilo 1 kilo 1000 12 12,000.00 lodized Salt 20php/pack 1pack 20 12 240.00 Cooking Oil 110php/1.5liter 1.5liters 110 12 1,320.00 Mayonnaise 350php/1kg 2kg 700 12 8,400.00 Peanuts 15php/pack 2packs 30 12 360.00 All Purpose Cream 58php 250ml 1160 12 13,920.00 Quickmelt Cheese 205php 440g 205 12 2,460.00 Banana Ketchup 95php/2kg 4kg 190 12 2,280.00 0 White Sugar 55php/1kg 1 kg 55 12 660.00 Dried Chili 10php/pack 2pack 20 12 240.00 Ginger 40php/ 1/2kl 1/2kl 40 12 480.00 3 Cornstarch 55php/pack 1pack 55 12 660.00 Garlic 50php/ 1kl 1 kl 50 12 600.00 5 Vinegar 40php/11 11 40 12 480.00 6 Chicken breast 150php/1kl 20kl 3000 12 36,000.00 7 Carrots 60php/1kl 10kl 600 12 7,200.00 8 Potatoes 60php/1kl 10kl 600 12 7,200.00 9 Red Belt Pepper 60php/1kl 5kl 300 12 3,600.00 0 Egg 160php/tray 2tray 320 12 3,840.00 Black Pepper 18php/pack 1pack 18 12 216.00 Paprika Powder 45/pack 1 pack 12 45.00 Rosemary 30php/pack 1pack 30 12 360.00 4 5 Total 102,561.00