Can someone please help me with this? I need the formulas as well, thank you!

You are the cost accountant at Posey's Pet Emporium tasked with preparing quarterly budgets that determine the cash effects of the company's sales and production-related expenditures. The company uses a calendar year, and it is time to prepare the third-quarter budget. You have the following information: 1. The budgeted selling price for the year is $4.99 per unit. Sales volumes are budgeted as follows for the last month of quarter two, for all of quarter three, and for part of quarter four. 2. Historically, 20% of Posey's sales are cash sales. Of the remaining credit sales, 45% are collected in the month of sale, while 52% are collected the following month. The remainder is deemed uncollectible. 3. Management sets its ending finished goods inventory goal at 15% of the following month's sales volume. The accounting team expects this policy will be met at the beginning of the second quarter. 4. The target ending inventory for Posey's primary direct material is 20% of the following month's production needs. Each completed unit requires five pounds of direct materials at an expected cost of $0.25 per pound. The budgeted production for October is 34,000 . 5. Posey's pays for 40% of its purchases in the month of purchase and 60% the month after purchase. Total budgeted purchases in June are $20,000. 6. Posey's ending cash balance on June 30 was $57,950. 7. Posey's non-production cash disbursements are estimated at $80,000 per month. \begin{tabular}{|c|c|c|} \hline \multicolumn{3}{|c|}{PoseysPetEmporiumBudgetData} \\ \hline Budgeted selling price & 4.99 & \\ \hline \multicolumn{3}{|c|}{ Sales Volume Budgets } \\ \hline June & 33,500 & \\ \hline July & 32,000 & \\ \hline August & 35,200 & \\ \hline September & 35,000 & \\ \hline October & 34,000 & \\ \hline \multicolumn{3}{|c|}{ Percentage of Sales } \\ \hline Cash sales & [Insert value] & \\ \hline \multicolumn{3}{|l|}{ Credit collected in } \\ \hline Month of sale & [Insert value] & \\ \hline Following month & [Insert value] & \\ \hline Uncollectable & [Insert value] & \\ \hline \multicolumn{3}{|c|}{ [inserivalue] } \\ \hline FG (finished goods) inventory goal & [Insert value] & followingmonthssalesvolume \\ \hline Target ending inventory DM (direct materials) & [Insert value] & \\ \hline Pounds per completed unit of DM & [Insert value] & \\ \hline Expected cost per pound & [Insert value] & \\ \hline \multicolumn{3}{|c|}{ Percentage of Purchase Payments } \\ \hline Month of purchase & [Insert value] & \\ \hline Month after purchase & [Insert value] & \\ \hline Budgeted purchases - June & [insert value] & \\ \hline Other cash disbursements per month & [Insert value] & \\ \hline Other cash disbursements per month & & \\ \hline Beginning cash balance - July & [Insert value] & \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|c|} \hline \multicolumn{5}{|c|}{ Posey's Pet Emporium } \\ \hline Sales Forecast & July & August & September & Quarter \\ \hline Budgetedsalesvolume & 32,000 & 35,200 & 35,000 & 34,000 \\ \hline Budgetedsellingprice & 4.99 & 4.99 & 4.99 & 4.99 \\ \hline Budgetedsalesrevenue & 159680 & 175648 & 174650 & 169660 \\ \hline Cash Receipts Budget & July & August & September & Quarter \\ \hline BeginningA/R(Junecollections) & & & & [Insert formula] \\ \hline July cash sales & [Insert formula] & & & [Insert formula] \\ \hline July credit sales & [Insert formula] & [Insert formula] & & [Insert formula] \\ \hline August cash sales & & [Insert formula] & & [Insert formula] \\ \hline August credit sales & , & [Insert formula] & [Insert formula] & [Insert formula] \\ \hline September cash sales & & & [Insert formula] & [Insert formula] \\ \hline September credit sales & & & [Insert formula] & [Insert formula] \\ \hline Total cash receipts & [Insert formula] & [Insert formula] & [Insert formula] & [Insert formula] \\ \hline \end{tabular}