Please provide with excel formulas.

Thank you

Marks Done Question Section F F1 3 O Instruction The following are to be completed in the Inventory Worksheet If a stock item falls below the minimum stock level in M3 (subject to change) and is not on backorder (value in column H is N), then we need to reorder it. In 14 create a calculation that will return Y if the item needs reordering and leave the cell blank if it does not. The quantity to reorder is determined by the price of the item as shown in the table in 16:M10, e.g. anything that costs between $5 and $49.99 we reorder 25 (these values can change). In J4 calculate the reorder quantity, return 0 if reorder not required. TOTAL MARKS F2 3 80 A B Inventory Reorder ? Reorder Qty Minimum Slock Level 5 Weight (g) 1155 444 6.4 49.2 In Stock On Backorder 2N 2 N Price Bracket Re-order Amount N 11 N 7.4 7.9 658 3.5 200 27.5 == N 31 N NI 9 N 26N 4 N 3 Part Code 4 FR1323 5 FR1235 6 FR2360 7 FR1934 8 FR1080 9 FR1081 10 WH1100 11 WH2373 12 WH2942 13 WH2856 14 WH1573 15 C02357 16 C01649 17 C02143 18 C02202 19 C01099 20 CO1469 21 C02904 22 GR2589 23 GR1322 24 GR1172 GR1836 26 GR1215 27 GR1751 28 GR2009 29 GR1406 30 GR1550 31 AC1508 32 AC1945 33 AC2733 34 AC2964 35 AC1914 36 GR1432 37 GR1770 38 GR1966 39 GR2655 40 AC2170 41 WH1260 42 WH2778 43 C01688 Product Description Nashbar Carbon Frame J&L Fork J&L Plug Headset J&L Top Cap & Screw Mr. Ride Seat Clamp XR-270/Bitex Wheel Veloplugs Rim tape Titanium QR Skewers Forte LCR Tyres Forte Light Tubes RockBros CrMo Saddle KCNC Scandium Seatpost Spacers Uno 7050 Stem Nashbar Carbon Bar Generic Foam Tape Tape Custom Bar Plugs Ultegra Levers Ultegra RD Ultegra FD Ultegra Cassette Dura Ace Chain CNC brakes 200g Brakes Ultegra Cranks Ultegra BB Ultegra Cables Fairing M5 Bolts Alloy CR Bolts Titanium Stem Bolts Generic FD Adapter Nashbar Alpe d Huez Pedals Nashbar Levers Nashbar RD Nashbar FD Nashbar Cassette RockBros S60 Pedals CNC V18 Ultra Wheels CNC V16 Super Slim Wheels Specialised Foam Tape Tape Category Frameset Frameset Frameset Frameset Frameset Frameset Wheels Wheels Wheels Wheels Wheels Contact Points Contact Points Contact Points Contact Points Contact Points Contact Points Contact Points Groupset Groupset Groupset Groupset Groupset Groupset Groupset Groupset Groupset Accessories and tuning Accessories and tuning Accessories and tuning Accessories and tuning Accessories and tuning Groupset Groupset Groupset Groupset Accessories and tuning Wheels Wheels Contact Points Supplier Nashbar Bikes Plus Bikes Plus Bikes Plus Cycle Warehouse Cycle Warehouse Cycle Warehouse LBS Cycle Warehouse Performance Performance Cycle Warehouse Cycle Warehouse Bikes Plus Cycle Warehouse Nashbar Cycle Warehouse Cycle Warehouse Nashbar Backcountry Nashbar Nashbar Nashbar Cycle Warehouse Nashbar Backcountry Nashbar Cycle Warehouse Cycle Warehouse Cycle Warehouse Cycle Warehouse Nashbar Nashbar Nashbar Nashbar Nashbar Cycle Warehouse Cycle Warehouse Cycle Warehouse Cycle Warehouse Price/Unit $393.60 $204.60 $10.40 $0.00 $4.10 $15.20 $118.28 $5.58 $4.45 $19.13 $4.68 $19.55 $85.44 $0.00 $16.40 $57.60 $0.20 $0.95 $104.86 $42.00 $24.65 $46.55 $24.32 $69.70 $125.61 $16.15 $0.00 $0.49 $2.18 $9.48 $2.31 $11.20 $97.20 $48.40 $24.96 $38.70 $25.76 $126.40 $178.20 $0.151 191 59.9 149.4 128 2.5 110 210 0.6 1.9 178.5 159.9 103.2 239.6 208.7 89 784.3 63 41.4 1.1 0.3 8.3 18.4 112.5 246.5 214.5 0N 4 N 17_ N 5 N 8 Y 8 N ON 11 Y 21 N 1 N 4N y 73 226.8 106.9 840 764.1 0. 4 0 41 23 N 26 Y 4 N 5. Y 7 N 31 N 31 N