I'm after help with how to calculate these questions using formulas in excel. Help would be greatly appreciated!

in Stock On Backorde Over-Stocked Re-Order? Reorder Qly 28% 10 Cost Price (each $74.300 $129.80 $131.00 $1.416,201 $2,381.70 $2,458, 10 $3,029.30 Retail Price $95.10 $164.14 $167.66 $1.812.74 $3,048.se 5 3,146.37 53,877.50 % Markup Maximum Stock Level Minimum Stock Level No. Item Codes to re-order No. Item Codes Over-Stocked Total Inventory Value (ind VAT) 13 30 e llelelaleleleb Re-Order Qty 1 3 $3,194.80 $225.70 54,089.34 S2RR.00 Reorder Quantities: Item Cost so $100 $300 $500 $1,000 1 0 Yes $439.141 $1,356.67 $1,384.70 $2,284.80 $2.595.00 10 6 16 0 9 EE 3 $910.21 $1.006.64 $1,043.71 $1,012.10 3 Code 4 C1019 5 M1021 6 M1072 7 R1001 8 R1002 9 R1003 10 R1004 11 R1005 12 R1006 13 R1007 14 R1023 15 R1024 16 R1025 17 S1008 18 51009 19 S1010 20 S1011 21 S1012 22 51013 23 s1014 24 S1015 25 S1016 28 S1017 27 S1018 28 S1020 29 C1219 30 M1221 31 M1222 32 R1201 33 R1202 34 R1203 35 R1204 38 R1205 37 R1206 38 R120F 39 R1223 40 R1224 41 R1225 42 S1208 43 S1209 44 S1210 45 51211 48 S1212 47 S1213 48 S1214 49 51215 50 51216 51 S1217 52 51218 53 S1220 Description Connector Pock MGX 8025 Chip Set MOX 8066 Chip Sot Robot Motor KH Robor Kit 334 Robot Kit 3A Rabot Kit 310 Robot Kr SP3 Robor Kr 448 Robot 555 Relays - Small Pack Relays - Medium Pack Relays - Large Pock Serve Motors A21 14 pack) Servo Motors B21 41 pack) Servo Motors A21 18 pack) Servo Motors 21 pack) SMC Pneumatis Pori 244 SMC Pneumatic Part X- 22 SMC Pneumortie Part X-33 SMC Pneumatic Part 3-47 SMC Pneumatic Part 3.48 SMC Pneumatic X 200mm SMC Pneumatic X 2.50mm ISD Drive em Connector Pock em MGX 8025 Chip Ser em MGX 8066 Chip Ser me Robe Matar Kit LeBchi 33. emc Robor 1 344 eme Reber K 38G s Petek SP3 ek Bc K1 446 lenc Robot 101555 em Relays - Small Pack amc Relays - Medium Park am Relays - Large Park em Servo Motors A21 14 pack cmc Servo Motors B21 14 podk eme Servo Motors A21 18 pack ame Servo Motors 321 pack) Am SMC Pneumatic Part3- 44 em SMC Pneumatic Part X-22 em SMC Pneumatic Part X- 33 Jame SMC Prevmatis Porr 3. 47 Am SMC Pneumatic Part 3. 48 am SMC Pneumatic X 200 en SMC Pneumatic X 250mm em SD Drive 14 $342.21 $1,059.90 $1.081.80 $1,785.00 $2.020.00 1651.90 $711.10 $788.00 $815.40 $790.70 $537.80 $649.00 $92.70 $72.30 $138.00 $145,201 $1,141 201 $2,264,90 $2,484.20 $3,058.10 $2,294.00 $3.001.901 $3.357.eol $270.30 $313.20 $352,10 $896. Lol $1,010.401 $1,645.00 $2,160.00 $698.00 $703.80l $811.000 $815.40 $750.800 $616001 710.20 $88.901 $31.07 $118.66 $92.54 $177.41 $184.11 $1,719.30 $2.899.07 53,179.79 52914371 54.216.32 53.957.631 $4 297.901 $345.98 $400.90 | FFCT-IPTIFMOTTINETFL 9 7 18 0 0 2 1 3 $1,14701 $1.293.31 52, 105.00 52764.Al 5893441 $900 Bol $1,039.95 $1,043.71 $961.02 $788.48 $900.00 $113.79 0 4 2 0 12 18 C5 3 L4 indicates the maximum stock level. In G3:653 create a formula to check if the quantity in stock is over the maximum stock in L4 (this level can be adjusted). If it is over the stock level put Yes in the cell, otherwise leave it empty (do not put No or a space). Formula should copy down, check it is working correctly. L5 indicates the minimum stock level while column D indicates if an item is on back order (already been reordered). If a stock item is below the minimum and not on Backorder (is blank) we need to reorder it. In H3:53 create a formula to check if the item needs to be re-ordered. If it does put Yes in the cell, otherwise leave it empty (do not put No or a space). Formula should copy down, check it is working correctly. Reorder quantities are based on price as shown in the Reorder Quantities data (K11:L16), e.g. currently for items that cost from $100 up to (but not including) $300 we re-order 35. Create a calculation in 14 that will check if we need to reorder and if so return the correct reorder amount otherwise return 0. Ensure the formula is copied down for the whole table. Note stock levels and reorder quantities will change, you should have one consistent calculation for the column and the calculations should work regardless of values or sort order of the inventory data. In L6 calculate how many item codes require reordering. C6 4. O C7 2 O C8 In L7 calculate how many item codes are over stocked. Use Excel's built in help to investigate the SUMPRODUCT function. In L8 calculate the total cost of all inventory items currently in stock