Please help, can someone provide the excel formulas for F2 to F5?

D F G H M N E Inventory Inventory Management Reorder? Reorder Q In Stock On Backorde 31 17 Min Slock Level Max Slock Level Reorder At Reorder Due 20 40 22 0 40 17 44 0 Price Bracket 0 50 100 200 Re-order Amount 25 20 15 10 30 32 41 1 1 16 17 On Backorder Over-Stocked Y Supplier Cyde Warehouse Nashbar Performance Bikes Plus Backcountry LBS 2 3 Supplier 4 Cycle Warehouse 5 Cycle Warehouse 6 Cycle Warehouse 7 Cycle Warehouse 8 Cycle Warehouse 9 Nashbar 10 Cycle Warehouse 11 Performance 12 Performance 13 Cycle Warehouse 14 Cycle Warehouse 15 Bikes Plus 16 Bikes Plus 17 Bikes Plus 18 Cycle Warehouse 19 Cycle Warehouse 20 Cycle Warehouse 21 Nashbar 22 Nashbar 23 Nashbar 24 Nashbar 25 Nashbar 26 Nashbar 27 Cycle Warehouse 28 Nashbar 29 Bikes Plus 30 Cycle Warehouse 31 Cycle Warehouse 32 Cycle Warehouse 33 Backcountry 34 Nashbar 35 Nashbar 36 Nashbar 37 Nashbar 38 Nashbar 39 Backcountry 40 Cycle Warehouse 41 LBS 42 Cycle Warehouse 43 Bikes Plus Price/Unit Weight (g $2.21 0.3 $56.10 84 S132.84 778.1 S259.45 588 $0.71 2.2 $27.72 217.6 $0.45 0.8 $18.23 228.9 $47.73 56.1 $2.64 23.6 $0.14 0.6 $24.84 60.6 S160.16 344 $11.55 6 $3.19 7.8 $78.32 180.1 $15.55 9.5 $56.77 189 S403.20 957 $34.06 197.2 $27.24 86.3 S105.73 199.8 $48.07 202.8 $20.45 210.6 $21.50 131.6 $26.32 2.4 $0.16 0.5 $4.42 26.8 $8.96 8.7 $16.52 51 $24.61 49.1 $49.05 176 S124.34 694.9 $25.35 91.7 $93.92 216.8 $42.33 204.8 $14.60 130.9 $4.70 4 S114.06 595 $24.75 131.6 Y 4 9 22 24 18 12 18 13 0 15 29 44 28 18 37 Y 1 43 19 23 11 18 43 11 44 43 6 20 F2 F3 The quantity to reorder is determined by the price of the item as shown in the table in L9:M12, e.g. anything that costs under $50 we reorder 25 (these values can change). In J4 calculate the reorder quantity, return 0 if reorder not required. The inventory manager prefers to wait until a certain number of parts require re- ordering before placing the orders. He has specified this value in M5 but does adjust it depending on production levels. In M6 create a calculation to count how many Part Codes are due to be re-ordered and return a Yes if it is equal or over the value in M5 and a No otherwise. In M15:M20 calculate how many Part Codes are on Backorder for each supplier (in column L). M4 shows the Maximum Stock Level. In N15:N20 calculate how many part codes are over-stocked for each supplier, remember that the value in M4 can change. (This is a challenge question.) a F4 F5 a