complete the cash bidgeg for jan only

B) The units are expected to be sold for $9.50 with the following volumes: C) Variable manufacturing costs: D) Total fixed manufacturing costs per unit: EstimatedannualfixedmanufacturingoverheadIncludesannualdepreciationof$180,000$24,000 Applied based on direct labour hours (DLH) E) Desired minimum inventories: F) Selling \& administrative costs: Variable: \begin{tabular}{rlr} \hline Variable: & & $300,000 \\ Sales commissions: 3% of sales & if sales are > & $300,000 \end{tabular} Fixed: $26,000 monthly, including amortization of $6,000 G) Collection of sales: All sales are on account and are expected to be collected 30% in the month of sale and 70% in the month following the sale. H) Payment of direct material purchases: All direct material purchases are on account, and payments are: 40% in the month of purchase 60% in the month following the purchase All other operating expenses are paid in the month incurred (budgeted) D)Minimumcashbalancerequiredis:Interestiscalculatedatanannualrateof:$40,00012% \begin{tabular}{|l|c|} \hline & January \\ \hline Beginning cash balance & \\ \hline Add: Cash collections & \\ \hline Total cash available & \\ \hline Cash Disbursements: & \\ \hline Payment of purchases & \\ \hline Direct labour & \\ \hline Manufacturing overhead & \\ \hline Selling \& Admin & \\ \hline Total disbursements & \\ \hline Excess/Deficient Cash Balance & \\ \hline Financing: & \\ \hline Cash borrowed & \\ \hline Cash repaid & \\ \hline Interest & \\ \hline Total financing & \\ \hline Ending cash balance & \\ \hline \end{tabular}