Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Hardin Fabrications is preparing its cash budget for the third quarter. begin{tabular}{|c|c|c|c|c|} hline multicolumn{2}{|c|}{ Amount of monthly overhead that is depreciation and amortization } &
Hardin Fabrications is preparing its cash budget for the third quarter. \begin{tabular}{|c|c|c|c|c|} \hline \multicolumn{2}{|c|}{ Amount of monthly overhead that is depreciation and amortization } & $15,000 & & \\ \hline \multicolumn{5}{|c|}{ Sales Budget } \\ \hline & July & August & September & Total \\ \hline Unit Sales & 2,250 & 2,100 & 1,650 & 6,000 \\ \hline Price per Unit & $220.00 & $220.00 & $220.00 & $220.00 \\ \hline Total Sales & $495,000 & $462,000 & $363,000 & $1,320,000 \\ \hline \multicolumn{5}{|c|}{ Direct Materials Purchases Budget } \\ \hline & July & August & September & Total \\ \hline Total Production & 2,380 & 1,965 & 2,115 & 6,460 \\ \hline Direct Materials per Unit & 3.50 & 3.50 & 3.50 & 3.50 \\ \hline Materials Required for Production & 8,330 & 6,878 & 7,403 & 22,610 \\ \hline Add: Desired Ending Inventory & 1,719.38 & 1,850.63 & 2,327.50 & 2,327.50 \\ \hline Total Material Needs & 10,049.38 & 8,728.13 & 9,730.00 & 24,937.50 \\ \hline Less: Beginning Inventory & 1,000 & 1,719.38 & 1,850.63 & 1,000 \\ \hline Total Purchases & 9,049 & 7,009 & 7,879 & 23,938 \\ \hline Cost per Steel Ingot & $17.00 & $17.00 & $17.00 & $17.00 \\ \hline Total Cost of Direct Materials & $153,839 & $119,149 & $133,949 & $406,938 \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|c|} \hline \multicolumn{5}{|c|}{ Direct Labor Budget } \\ \hline & July & 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 & $19.00 & $19.00 & $19.00 \\ \hline Total Cost of Direct Labor & $60,690 & $50,108 & $53,933 & $164,730 \\ \hline \multicolumn{5}{|c|}{ Manufacturing Overhead Budget } \\ \hline & July & August & September & Total \\ \hline Total Production & 2,380 & 1,965 & 2,115 & 6,460 \\ \hline Variable Overhead per Unit Produced & $40 & $40 & $40 & $40 \\ \hline Total Variable Overhead & 95,200 & 78,600 & 84,600 & 258,400 \\ \hline Fixed Overhead per Unit & $3.84 & $3.84 & $3.84 & $3.84 \\ \hline Total Fixed Overhead & 9,139 & 7,546 & 8,122 & 24,806 \\ \hline Total Overhead & $104,339 & $86,146 & $92,722 & $283,206 \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|c|} \hline A/R Balance September 30 & $174,240 & & & \\ \hline \multicolumn{5}{|c|}{ Schedule of Cash Payments } \\ \hline & July & August & September & Total \\ \hline June & $95,000 & & & \\ \hline July & 107,6887 & $107,688 & & \\ \hline August & & 83,4047 & $83,404 & \\ \hline September & & & 93,765 & \\ \hline Total & $202,688 (! & $191,092 (1) & $177,1691 & $570,948(1) \\ \hline A/P Balance September 30 & & & & \\ \hline \multicolumn{5}{|c|}{ Cash Budget } \\ \hline & July & August & September & Total \\ \hline Beginning Balance & $116,500 & $665,588 (1) & $1,334,519 (G) & $2,116,607 \\ \hline Add: Cash Collections & 346,400 & 477,840 & 410,520 & 1,234,760 \\ \hline Less: Cash Disbursements & 202,68804 & 191,092) & 177,169) & 570,948 \\ \hline End Balance & $665,588 & $1,334,519 & $1,922,208 & $3,922,315 \\ \hline \end{tabular}
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started