Based on the current data, what date should you schedule the chemical delivery for, and when should you place the order? The customer requires the tank level not to go below $1000$ US Gallon and the order must be placed $3$ weeks before delivery. Plant was shut down on April $7$ and $11$ for holidays! Please complete question on google sheet$\mathrm{.}1$

Date

Tank Level $($Litre$)\backslash$

$2$

$01-$Apr$-23$

$7612$

$02-$Apr$-23$

$7537$

$03-$Apr$-23$

$7411$

$04-$Apr$-23$

$7349$

$05-$Apr$-23$

$7200$

$06-$Apr$-23$

$7100$

$07-$Apr$-23$

$6987$

$08-$Apr$-23$

$6982$

$09-$Apr$-23$

$6872$

$11$

$10-$Apr$-23$

$6711$

$12$

$11-$Apr$-236714$

$13$

$12-$Apr$-23$

$6333$

$14$

$13-$Apr$-23$

$6215$

$15$

$14-$Apr$-23$

$6111$

$16$

$15-$Apr$-23$

$6050$

$17$

$16-$Apr$-23$

$5987$

$18$

$17-$Apr$-23$

$5900$

$19$

$18-$Apr$-23$

$5831$

$20$

$19-$Apr$-2357455745$

$21$

$20-$Apr$-23$

$5612$

$22$

$21-$Apr$-23$

$5555$

$23$

$22-$Apr$-23$

$5500$

$24$

$23-$Apr$-23$

$5431$

$25$

$24-$Apr$-23$

$5341$

$26$

$25-$Apr$-23$

$5256$

$27$

$26-$Apr$-23$

$5190$

$28$

$27-$Apr$-23$

$5100$

$29$

$28-$Apr$-23$

$5035$

$30$

$29-$Apr$-23$

$4975$

$3130-$Apr$-23$

$4900$

$21$

$20-$Apr$-23$

$5612$

$22$

$21-$Apr$-23$

$5555$

$23$

$22-$Apr$-23$

$5500$

$24$

$23-$Apr$-23$

$5431$

$25$

$24-$Apr$-23$

$5341$

$26$

$25-$Apr$-23$

$5256$

$27$

$26-$Apr$-23$

$5190$

$28$

$27-$Apr$-23$

$5100$

$29$

$28-$Apr$-23$

$5035$

$30$

$29-$Apr$-23$

$4975$

$31$