A1 xfx Accessibility tab summary: Information about Hardin Fabrications is provided in rows 2 to 20.5 data \begin{tabular}{|c|c|c|c|c|c|c|c|c|c|} \hline 4. & A & \multicolumn{2}{|r|}{ B } & \multicolumn{2}{|r|}{ c. } & \multicolumn{2}{|r|}{ D } & \multicolumn{2}{|r|}{ E. } \\ \hline 54 & Total Foxed Overhead & \multicolumn{2}{|r|}{9,139} & & 7,546 & & 8,122 & & 24,806 \\ \hline 55 & Total Overhead & $ & 104,339 & $ & 86,146 & s & 92,722 & s & 283,206 \\ \hline \multicolumn{2}{|l|}{56} & & & & & & & & \\ \hline 57 & \multicolumn{9}{|c|}{ Selling and Administrative Expense Budget } \\ \hline 58 & & \multicolumn{2}{|r|}{ July } & \multicolumn{2}{|c|}{ August } & \multicolumn{2}{|c|}{ September } & \multicolumn{2}{|r|}{ Total } \\ \hline 59 & Sales Units & $ & 2,250 & $ & 2,100 & $ & 1,650 & s & 6,000 \\ \hline 60 & Variable Selling Expense per Unit & s & 18 & \$ & 18 & s & 18 & s & 18 \\ \hline 61 & Total Variable Selling Expense & $ & 40,500 & s & 37,800 & $ & 29,700 & s & 108,000 \\ \hline 62 & Flxed Administrative Expense (for the month) & $ & 10,417 & s & 10,417 & $ & 10,417 & s & 31,250 \\ \hline 63 & Total Selling and Administrative Expense & s & 50,917 & $ & 48,217 & s & 40,117 & $ & 139,250 \\ \hline \end{tabular} 13 All expenses are paid for as they occur, with the exception of Direct Materials, which is all paid for with a revolving line of credit. Required: Prepare a Schedule of Cash Collections. Prepare a Schedule of Cash Disbursements. Prepare a Cash Budget. Note: All numbers should be shown as positive numbers. Schedule of Cash Collections June July August September Total A/R Balance September 30 Cost per Steel Ingot Total Cost of Direct Materials \begin{tabular}{|c|c|c|c|c|c|c|c|} \hline$ & 17.00 & $ & 17.00 & $ & 17.00 & $ & 17.00 \\ \hline$ & 153,839 & $ & 119,149 & $ & 133,949 & $ & 406,938 \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|c|c|c|c|c|} \hline= & Dire & or Budge & & & & & & \\ \hline & & & & August & & September & & Total \\ \hline Total Production & $ & 2,380 & $ & 1,965 & $ & 2,115 & $ & 6,460 \\ \hline Direct Labor Hours Per Unit & & 1.50 & & 1.50 & & 1.50 & & 1.50 \\ \hline Total Direct Labor Hours Needed for Production & & 3,570 & & 2,948 & & 3,173 & & 9,690 \\ \hline Cost per Direct Labor Hour & $ & 19.00 & s & 19.00 & $ & 19.00 & $ & 19,00 \\ \hline Totai Cost of Direct Labor & 5 & 60,690 & s & 50,108 & $ & 53,933 & $ & 264,730 \\ \hline \end{tabular} \begin{tabular}{|l|l|l|} \hline Amount of monthly overhead that is depreciation and amortization & $ & 15,000 \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|c|c|c|c|} \hline \multicolumn{8}{|c|}{ Sales Budget } \\ \hline & July & & August & & September & & Total \\ \hline & 2,250 & & 2,100 & & 1,650 & & 6,000 \\ \hline$ & 220.00 & $ & 220.00 & $ & 220.00 & $ & 220.00 \\ \hline$ & 495,000 & $ & 462,000 & $ & 363,000 & \$ & 1,320,000 \\ \hline & & & & & & & \\ \hline \multicolumn{8}{|c|}{ Direct Materials Purchases Budget } \\ \hline & July & & August & & September & & Total \\ \hline & 2,380 & & 1,965 & & 2,115 & & 6,460 \\ \hline & 3.50 & & 3.50 & & 3.50 & & 3.50 \\ \hline & 8,330 & & 6,878 & & 7,403 & & 22,610 \\ \hline & 1,719,38 & & 1,850,63 & & 2,327,50 & & 2,327.50 \\ \hline & 10,049.38 & & 8,728.13 & & 9.730 .00 & & 24,937.50 \\ \hline & 1.000 & & 1,719.38 & & 1,850.63 & & 1,000 \\ \hline & 9,049 & & 7,009 & & 7,879 & & 23,938 \\ \hlines & 17.00 & $ & 17.00 & s & 17,00 & s & 17.00 \\ \hline \end{tabular} Graded Worksheet
