Hi, I have this challenge question using excel formulas which I am stuck on. Any ideas?

F5 Challenge Question (limited help will be given) when we re-order we like to ensure we will have 25% more than the minimum stock level. Create a calculation that checks if we need to reorder, if we do, calculate the number we need to re-order to have an in stock value of 25% over the min stock level, return 0 if re-order not required. The suppliers also impose a minimum order quantity (see column 0). Modify your calculation so that if we need to re-order and the re-order quantity is less than the Min Order Qty for the supplier, it returns the appropriate Min Order Qty. (2 Marks will be given for doing just the rst part correctly). B C D E G M P Q S Inventory PART CODE IMAGE DESCRIPTION SUPPLIER SUPPLIER CODE COST EACH MIN STOCK IN STOCK BACKORDER CATEGORY RE-ORDER? RE-ORDER QTY Supplier Min Order Qty Parts Average Value Items on Backorder PX723541 DESCRIPTION White & Portico W529196/78 $1.66 200 239 H&W 25 $3.57 3 4 12 PX723542 DESCRIPTION Buggins 8557761/77 $1.99 200 198 A ABC White & Portico 30 $8.58 5 15 PX374561 IMAGE $2.74 A UNAVAILABLE DESCRIPTION White & Portico W664956/39 200 63 Buggins 55 $4.14 6 11 PX820261 DESCRIPTION White & Portico W771072/53 $12.99 100 292 B PX820262 DESCRIPTION Buggins B567350/21 $13.19 100 163 Reorder % over 25% Minimum PX1004683 DESCRIPTION White & Portico W701735/28 $13.19 100 256 B PX820266 DESCRIPTION Buggins B326854/81 $10.99 100 66 10 PX723593 DESCRIPTION H&W H448251/40 $1.91 200 268 A 11 PX374089 DESCRIPTION White & Portico W426061/24 $53.11 50 105 B y 12 PX723557 DESCRIPTION Buggins 3472237/18 $2.49 200 249 A y 13 PX723820 DESCRIPTION Buggins B420251/20 $2.49 200 138 A 14 PX807530 DESCRIPTION White & Portico W564399/34 $2.99 200 181 A 15 PX820728 DESCRIPTION White & Portico W591861/33 $2.19 200 272 A y 16 PX723594 DESCRIPTION H&W 1326781/31 $2.39 200 86 A 17 PX723206 DESCRIPTION Buggins B433191/70 $1.99 200 177 A 18 PX373195 DESCRIPTION White & Portico W592160/27 $2.49 200 231 A y 19 PX723745 DESCRIPTION Buggins B675073/41 $3.11 100 36 A 20