Please provide formulas when needed and help me solve for yellow parts

Loblaw Manufacturing has asked you to create a cash budget in order to determine its borrowing needs for the June to October period. You have gathered the following information. April and May sales were $327,031 and $383,906, respectively. The firm collects 20% of its sales during the month, 65% the following month, and 15% two months after the sale. Each month it purchases inventory equal to 55% of the next month's expected sales. The company pays for 40% of its inventory purchases in the same month and 60% in the following month. However, the firm's suppliers give it a 2% discount if it pays during the same month as the purchase. A minimum cash balance of $25,000 must be maintained each month, and the firm pays 4% annually for short-term borrowing from its bank. a) Create a cash budget for June to October 2022. The cash budget should account for short-term borrowing and payback of outstanding loans as well as the interest expense. The firm ended May with a $30,000 unadjusted cash balance (Analysis 8 pts) b) Bob Loblaw, the president, is considering stretching out its inventory payments. He believes that it may be less expensive to borrow from suppliers than from the bank. He has asked you to use the Scenario Manager to see what the total interest cost for this time period would be if the company paid for 0%, 10%,30%, or 40% of its inventory purchases in the same month. The remainder would be paid in the following month. Create a scenario summary, and describe whether the results support Bob's belief (Analysis, Identify and Access Needed Information \& Use Information Effectively to Accomplish a Specific Purpose 12 pts). Loblaw Manufactaring Cast Fudget June 2022 to October 2022 \begin{tabular}{|c|c|c|c|c|c|c|c|c|c|c|} \hline 5 & & & April & May & Iane & July & Augast & September. & October & November \\ \hline 6 & Sales & & 327,031 & 383,906 & 483,125 & 403,812 & 199,062 & 264,468 & 216,125 & 235,343 \\ \hline 7 & Collections: & & & & & & & & & \\ \hline 8 & Cash & 20% & & & & & & & & \\ \hline \begin{tabular}{c} 9 \\ 10 \end{tabular} & \begin{tabular}{l} Find Menth \\ Secood Menth \end{tabular} & 65% & & & & & & & & \\ \hline \begin{tabular}{l} 10. \\ 11 \end{tabular} & \begin{tabular}{l} Secobd Menth \\ Total Collections \end{tabular} & & & & & & & & & \\ \hline 12 & \begin{tabular}{l} Purchases \\ \end{tabular} & 55% & & & & & & & & \\ \hline 13 & Payments: & & & & & & & & & \\ \hline 14 & During Monds & 40% & & & & & & & & \\ \hline 25 & Mons After & 60% & & & & & & & & \\ \hline 16 & \begin{tabular}{l} Total Payments \\ Collections \end{tabular} & & & & & & & & & \\ \hline \begin{tabular}{l} 17 \\ 18 \end{tabular} & \begin{tabular}{l} Collections \\ Disbursereente: \end{tabular} & & & & & & & & & \\ \hline 19 & Investory Piryments & & & & & & & & & \\ \hline \begin{tabular}{l} 20 \\ 21 \end{tabular} & \begin{tabular}{l} Short-term Iaterest \\ Other Payments \end{tabular} & & & & & & & & & \\ \hline \begin{tabular}{l} 21 \\ 22 \end{tabular} & Total Disbursements & & & & & & & & & \\ \hline 23 & \begin{tabular}{l} Beginhiog Cavh Balance \\ Net Additions to Cach \end{tabular} & & & & & & & & & \\ \hline 25 & Unsdused Cah Nalasce & & & 30,000 & & & & & & \\ \hline 26 & Ada Carrent Dorrowing & & & & & & & & & \\ \hline 27 & Ending Cow Balance & & & & & & & & & \\ \hline2328 & Cumulative Byrrowing & & & & & & & & & \\ \hline \begin{tabular}{l} 23 \\ 30 \end{tabular} & & 25,000 & & & & & & & & \\ \hline 31 & Disceunt for Faying in Same Moses & 2.00% & & & & & & & & \\ \hline 12 & Ansual Interest Rale & 400% & & & & & & & & \\ \hline 33 & Monbly Istereat Rate & 0.33% & & & & & & & & \\ \hline 36 & Toul teicresul Cast & & & & & & & & & \\ \hline \begin{tabular}{l} 37 \\ is \end{tabular} & & & & & & & & & & \\ \hline \end{tabular}