create a Selling & Admin and cash budget in Excel with the following info

Estimated selling price per unit Production Requirements \begin{tabular}{|l|c|c|} \hline Pounds of Raw Material Required (Per Unit) & \multicolumn{1}{|c|}{4.5} \\ \hline Raw Material Cost (Per Pound) & $ & 2.60 \\ \hline Beginning inventory (Pounds) & 130,000 \\ \hline Minimum Ending Raw Materials Inventory as a \% of Next Month's Need & 35% \\ \hline Required ending inventory at December & 105,000 \\ \hline & \\ \hline Beginning Accounts Payable & $1,320,000 \\ \hline & & \\ \hline & $600,000 & \\ \hline Estimated July Payments & $720,000 \\ \hline & $1,320,000 \\ \hline \end{tabular} Selling expenses Variable cost per unit sold Fixed annual cost $1,500,000 Administrative expenses Variable cost per unit sold Fixed annual cost (including depreciation of $90,000 ) depreciation portion $$$7.25450,00090,000 Beginning cash balance $550,000 Capital purchases: \begin{tabular}{|l|l|} \hline July-HYDRAULICS & $1,000,000 \\ \hline August - Compactor & $2,300,000 \\ \hline \end{tabular} Borrowing / repayment increment $100,000 Borrowing at beginning of month Repayments at end of month Minimum monthly cash balance $200,000 Line of credit interest rate per month 0.50% Months in a year 12 Incrementental Borrwings as a multiplier: \begin{tabular}{|c|} \hline 1 \\ \hline 2 \\ \hline 3 \\ \hline 4 \\ \hline 5 \\ \hline 6 \\ \hline 7 \\ \hline 8 \\ \hline 9 \\ \hline 10 \\ \hline 11 \\ \hline 12 \\ \hline 13 \\ \hline 14 \\ \hline 15 \\ \hline 16 \\ \hline \end{tabular} Estimated selling price per unit Production Requirements \begin{tabular}{|l|c|c|} \hline Pounds of Raw Material Required (Per Unit) & \multicolumn{1}{|c|}{4.5} \\ \hline Raw Material Cost (Per Pound) & $ & 2.60 \\ \hline Beginning inventory (Pounds) & 130,000 \\ \hline Minimum Ending Raw Materials Inventory as a \% of Next Month's Need & 35% \\ \hline Required ending inventory at December & 105,000 \\ \hline & \\ \hline Beginning Accounts Payable & $1,320,000 \\ \hline & & \\ \hline & $600,000 & \\ \hline Estimated July Payments & $720,000 \\ \hline & $1,320,000 \\ \hline \end{tabular} Selling expenses Variable cost per unit sold Fixed annual cost $1,500,000 Administrative expenses Variable cost per unit sold Fixed annual cost (including depreciation of $90,000 ) depreciation portion $$$7.25450,00090,000 Beginning cash balance $550,000 Capital purchases: \begin{tabular}{|l|l|} \hline July-HYDRAULICS & $1,000,000 \\ \hline August - Compactor & $2,300,000 \\ \hline \end{tabular} Borrowing / repayment increment $100,000 Borrowing at beginning of month Repayments at end of month Minimum monthly cash balance $200,000 Line of credit interest rate per month 0.50% Months in a year 12 Incrementental Borrwings as a multiplier: \begin{tabular}{|c|} \hline 1 \\ \hline 2 \\ \hline 3 \\ \hline 4 \\ \hline 5 \\ \hline 6 \\ \hline 7 \\ \hline 8 \\ \hline 9 \\ \hline 10 \\ \hline 11 \\ \hline 12 \\ \hline 13 \\ \hline 14 \\ \hline 15 \\ \hline 16 \\ \hline \end{tabular}