using the work provided fill out and check the cash budget, income statement, and balance sheet
\begin{tabular}{|c|c|c|c|} \hline Direct Material Iter & Required Quantity & Cost per unit of measure & Estimated Cost (quantity cost) \\ \hline Wood & 3/4212 board of red oak wood & $5.00 per board & $5.00 \\ \hline Metal & 2.5 by 2.5 feet block of steel & $3.00 per block & $3.00 \\ \hline Paint & 1 can & $7.00 per can & $7.00 \\ \hline Screws & 2 screws & $0.50 per screw & $1.00 \\ \hline Total & & + & $16.00 \\ \hline \end{tabular} itr Eudenat unit said for the Yer Petentaer of Condit soles collectid in be avate of cile for at: Actiti number of unim Gudeant Productan fortice veer ForQt: Adid number of unin Heutr Wape Rate for oect Liber Find manufacuing ovethead far the Ye Veribit ielling ind atminitative osemse per unit sely 5m,50000 lew. Direct Materials List Assumptions Assign 2 Other Req. Sales Bt Ready Requirement 3a Requirement 3b \begin{tabular}{l|ll} Unit Product Cost & $ & 44.50 \end{tabular}=25+16+3.5 \begin{tabular}{|l|l|l|} \hline Manufacturing Overhead & $ & 3.50=(0.8100000+270000)/100000 \\ \hline Direct Labor & $ & 25.00=102.5 \\ \hline Direct Materials & $ & 16.00=16 \end{tabular} \begin{tabular}{|c|c|c|} \hline Requirement 3c & & \\ \hline Break-Even Point in Units & 19483,00 & \\ \hline & -19482.76 & =452000/820 \\ \hline Contribution Margin & -23.2 & =190.80.42516 \\ \hline \end{tabular} Requirement 3d \begin{tabular}{|c|c|c|} \hline Contribution Margin & 3.8 & =46160.80.425 \\ \hline & 118947.3684 & =452000/830 \\ \hline Break-Even Point in Units (Revised) & 118,948 & \\ \hline \end{tabular} Direct Materials List Assumptions Assign 2 Other Req. Sales Bud Sales Budget \begin{tabular}{|c|c|c|c|c|c|} \hline & Quarter 1 & Quarter 2 & Quarter 3 & Quarter 4 & Year \\ \hline Bospeted Unit swes & 26,600 & 28,500 & 28,500 & 11,400 & 95,000 \\ \hline Selling Price Fer Unit & 4600 & 46.00 & 46.00 & 46.00 & 46.00 \\ \hline Total Sales & 1,223,60000 & is 1,311,00000 & 51,311,000.00 & 5,524,400.00 & 54,370,000,00 \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|c|c|c|c|c|c|} \hline \multicolumn{10}{|c|}{ Schedule of Expected Cach Collections } \\ \hline & Quirter 1 & & & ater? & & Wter 3 & Ouarter 4 & Tot & \\ \hline Finst-Quirter sules & 5 & 917,70000 & 5 & 305.90000 & & & (. & 5 & 1,223,600.00 \\ \hline Second-Qourter Sales & & . & 5 & 981,25000 & 13 & 327,75000 & , & $ & 1,311,00000 \\ \hline Thind-Ouzter sades & &. & & & 5 & 983,25000 & 5327,75000 & 5 & 1,311,00000 \\ \hline rovith-ounersile & & & & & & . & 5393,300.00 & 3 & 393,30000 \\ \hline feraicas collectioni & 13 & 91270000 & & 1,283,150.00 & & 1,31100000 & 157105000 & 3. & 4,23180000 \\ \hline \end{tabular} Why arent these numbers the same? \begin{tabular}{|c|c|c|c|c|c|} \hline & \multicolumn{5}{|c|}{ Production Budget } \\ \hline & Quarter 1 & Quarter 2 & Quarter 3 & Quarter 4 & Year \\ \hline Budgeted Unit Sales & 26,600 & 28,500 & 28,500 & 11,400 & 95,000 \\ \hline Desired Units of Ending Finished Inventory & 2,850 & 2,850 & 1,140 & 5,000 & 5,000 \\ \hline Total Needs & 29,450 & 31,350 & 29,640 & 16,400 & 100,000 \\ \hline Units of Beginning Finished Goods Inventory &. & 2,850 & 2,850 & 1,140 & . \\ \hline Required Production in Units & 29,450 & 28,500 & 26,790 & 15,260 & 100,000 \\ \hline \end{tabular} A B C D t Direct Labor Budget \begin{tabular}{|c|c|c|c|c|c|c|} \hline \multicolumn{7}{|c|}{ Direct Labor Budget } \\ \hline & & Q1 & Q2 & Q3 & Q4 & Year \\ \hline Required production per can & & 29,450 & 28,500 & 26,790 & 15,260 & 100,000 \\ \hline Direct labor-hours per can & & 2.5 & 2,5 & 2.5 & 2.5 & 2.5 \\ \hline Total direct labor-hours needed & & 73,625 & 71,250 & 66,975 & 38,150 & 250,000 \\ \hline Direct Labor cost per hour & 5 & 10.00 & 10.00 & 10.00 & 10.00 & 10.00 \\ \hline Total direct labor cost & $ & 736,250.00 & $712,500.00 & $669,750.00 & $381,500.00 & $2,500,000.00 \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|c|c|c|} \hline & A & B & C & D & E & F \\ \hline 1 & Manufa & cturing Ov & verhead Bud & dget & & \\ \hline 2 & & Q1 & Q2. & Q3 & Q4 & Year \\ \hline 3 & Budgeted Production & 26,600 & 28,500 & 28,500 & 11,400 & 100,000 \\ \hline 4 & Variable manufacturing overhead rate & $0.80 & 0.80 & 0.80 & 0.80 & 0,80 \\ \hline 5 & Variablemanufacturing overhead. & $21,280 & 22,800 & 22,800 & 9,120 & 80,000 \\ \hline 6 & Fixed manufacturing overhead & $67,500 & 67,500 & 67,500 & 67,500 & 270,000 \\ \hline 7 & Total manufacturing overhead & 88,780 & 90,300 & 90,300 & 76,620 & 350,000 \\ \hline & Less depreciation & 3,000 & 3,000 & 3,000 & 3,000 & 12,000 \\ \hline 9 & Cash disbursements for manufacturing overhead & 85,780 & 87,300 & 87,300 & 73,620 & 338,000 \\ \hline \end{tabular} Selling and Administrative Expense Budget Cash Budget \begin{tabular}{|c|c|c|c|c|c|c|c|c|c|c|} \hline & \multicolumn{4}{|c|}{ Cash Budget } & \multirow{2}{*}{\multicolumn{4}{|c|}{ Quarter 4}} & \multicolumn{2}{|c|}{ Year 1} \\ \hline & & uarter 1 & & varter 2 & & & $ & 91,036 & $ & 400,000 \\ \hline \begin{tabular}{l} Cash Balance, Becinhins \\ Cath Receipts \end{tabular} & $ & 400,000 & $ & 83,570 & $ & \begin{tabular}{r} 20,000 \\ 1,311,000 \end{tabular} & $ & 721,050 & $ & 4,238,900 \\ \hline \begin{tabular}{l} Cath Receipts \\ Total Cash Avaliable \end{tabular} & $ & 917,700 & $ & 1,289,150 & $ & \begin{tabular}{l} 1,311,000 \\ 1,331,000 \end{tabular} & s & 812,086 & $ & 4,638,900 \\ \hline \begin{tabular}{l} Total Cash Avalible \\ Cash Otsburnments: \end{tabular} & $ & 1,317,700 & $ & 1,372,720 & $ & & & & & \\ \hline Oirect Materials & \begin{tabular}{l} s \\ 5 \end{tabular} & \begin{tabular}{l} 22,4,960 \\ 736,250 \end{tabular} & $ & 712,500 & $ & 669,750 & 5 & 381,500 & $ & 2,500,000 \\ \hline Direct Labor & $ & \begin{tabular}{r} 736,250 \\ 85,780 \end{tabular} & $ & 87,300 & $ & 87,300 & 5 & 73,620 & s & 338,000 \\ \hline Manufacturing Overthead & 5s & \begin{tabular}{r} 85,780 \\ 55,140 \end{tabular} & $ & 55,900 & 5 & 55,900 & $ & 49,060 & $ & 216,000 \\ \hline Selfing and Admicistrative & 5 & \begin{tabular}{r} 55,120 \\ 132,000 \end{tabular} & & & & & & & $ & 132,000 \\ \hline Equipment & \begin{tabular}{l} 5 \\ 5 \end{tabular} & 1,234,130 & $ & 1,373,351 & $ & 1,239,964 & $ & 817,358 & $ & 4,668,803 \\ \hline Total Disbunements & $ & 83,570 & s & (631) & $ & 91,036 & 5 & (5,272) & 5 & (29,903) \\ \hline Excess ideficiency of cash & 55 & 20,000 & 5 & 20,000 & \$ & 20,000 & 5 & 20,000 & $ & 20,000 \\ \hline & & & s & 20,631 & & & \$ & 25,272 & & \\ \hline \begin{tabular}{l} 6. Borrowines (at bes of guarter) \\ 7 Repayments lat end of quarten) \end{tabular} & & & & & & & & & & \\ \hline \begin{tabular}{l} 7 Repayments lat end of quarten \\ 8 Interest \end{tabular} & & & & & & & & & & \\ \hline Total Finanding & & & $ & 20,631 & s & . & $ & 25,272 & s & \\ \hline Cash Salance, Ending & 5 & 83,570 & 5 & 20,000 & 5 & 91,036 & 51 & 20,000 & s & (29,903) \\ \hline \end{tabular}