6) Calculate the total cost per item in column H.

I need a help on Question 6 on this attached screenshot of the excel file.

Supply ChainExcelAssessment_Blank - Excel ? FILE HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW 118 : far H 1 Total Cost / item A B C D E F G 2 3 Instructions: 4 1) Populate the Quantity on Hand in column D using data from the QOH tab 5 2) Populate the quantity ordered not yet received in column E using data from the QO0 tab 6 3) Define the average monthly consumption for each item on the consumption tab. DO NOT CONSIDER March or April as part of the average 7 4) Populate the average monthly consumption in column F based on your results in the consumption tab 5) In column G, calculate the total to order. The total to order should be the average monthly consumption multipled by 6, minus the quantity on hand and 8 the quantity ordered not received. Round up to the nearest whole number. Replace negative results with a zero 9 6) Calculate the total cost per item in column H 10 Item Quantity Ordered not Average Monthly 11 Number Item Name Unit Cost Quantity on Hand yet Received Consumption Total to Order 12 10001 Mask, Oxygen, Nonrebreather, Pediatric $ 1.33 148 200 68.8 13 10002 Methyldopa 250mg, Film coated tablet $ 0.03 707 100 41.6 14 10003 Salbutamol, 100mcg/dose, 200 dose inhaler $ 1.50 396 50 30.6 15 10004 Magnesium trisilicate 250mg + Aluminium hydroxide 120m $ 0.01 401 10 253.6 16 10005 Suture, Polyglycolic acid, 0, 3/8 circle, 35mm needle, Absoi $ 0.71 717 6 288.8 17 10006 Printer paper roll, for Pima CD4 analyzer $ 4.10 685 70 180.6 18 (10007 Wax, Dental, Modeling, Pink, 500g (24 sheets) $ 0.46 63 10 340.4 19 10008 Arm sling, Medium $ 2.84 338 314.2 20 10009 Tape, Identification, for surgical instruments, Blue, 0.25in: $ 10.00 648 0 319 21 10010 Sleeve, for complete curing light $ 0.12 802 0 221 22 10011 Standard nail, Surgical implant, for SIGN system, 8mm x 38 $ 100.00 626 17 289.4 23 10012 Tape, Identification, for surgical instruments, Orange, 0.25 $ 10.00 972 1 190.8 24 10013 Pipette, Pasteur (transfer), Glass, Flint Soda Lime, 5.75in, 2 $ 0.03 828 222 203.2 25 10014 Tube, Feeding, Nasogastric, Sterile, 10Fr, 40cm $ 0.09 692 670 263.4 =: - - Instructions Executive Leadership Team Supply Chain Exercise 1 Item Roll Up Supply Chain Exercise 2 QOH QO0 Consumption 4 1420 AO + READY