answers start with = for correct answers

1. Prepare a sales budget, Including a schedule of expected cash collections. 2. Prepare a direct materlals budget, Including a schedule of expected cash disbursements for purchases of materlals. 3. Prepare a cash budget. All answers must be entered as a formula. Click OK to begin. 22 Budgeted selling \& administrative depreciation in March \begin{tabular}{l|l} 23 & \\ 24 & Other budgeted cash disbursements \\ 25 & Equipment purchases \\ 26 & Dividends to be paid \\ 27 & \\ 28 & Minimum cash balance to be main \\ 29 & March 1 cash balance \\ 30 & March 1 outstanding borrowings \\ 31 & March 1 interest due \end{tabular} 31 March 1 interest due 33 The company has a line of credit available to bolster the cash balance as needed. 34 35 When preparing budgets, the company maintains their data on a separate sheet from the actual budget and schedules. 36 37 Click the Schedules and Cash Budget tab to prepare the following: 38 1. Schedule of expected cash collections for March. 39 2. Schedule of expected cash disbursements for inventory purchases for March. 40 3. Cash budget for March. Indicate in the financing section any borrowing that will be needed in March. Assume that 41 any interest will not be paid until the following month. \begin{tabular}{|l|l|} \hline 1 & Expected cash collections: \\ \hline 2 & March cash collections \\ \hline 3 & March collections on account: \\ \hline 4 & January sales \\ \hline 5 & February sales \\ \hline 6 & March sales \\ \hline 7 & Total cash collections \\ \hline 8 & \\ \hline 9 & Payments to suppliers: \\ \hline 10 & Accounts payable for inventory purchases, beginning balance \\ \hline 11 & March purchases \\ \hline 12 & Total cash payments \\ \hline 13 & \\ \hline 14 & \\ \hline 15 & \\ \hline 16 & \\ \hline 17 & \\ \hline 18 & Cash balance, March 1 \\ \hline 19 & Add cash receipts: \\ \hline 20 & Collections from customers \\ \hline 21 & Total cash available \\ \hline 22 & Less disbursements: \\ \hline 23 & Payments to suppliers \\ \hline 24 & Selling and administrative exnenses \\ \hline \end{tabular}