Part9 25 sten pith \begin{tabular}{|c|c|c|} \hline \\ \hline Salen & & 1,431,000 \\ \hline Cost of eoods sold. & & 1,141,005 \\ \hline Gross profit & & 240,000 \\ \hline \multicolumn{3}{|l|}{ Operating expenter } \\ \hline Soles comenission & 117,490 & \\ \hline Sales wataries & 9,000 & \\ \hline General adminitrative walares & 36,=0 & \\ \hline tons term note intertit: & 13.5% & \\ \hline intereit expense & 120 & 173,100 \\ \hline income before tukes & & 66,400 \\ \hline income tans & & 23,45 \\ \hline Net incone & & 43,445 \\ \hline \end{tabular} Part 10 eludgeted Balance Sheet tune 30, 20xx ASSETS Cash Accounts receivable Raw materiala imentory Finished goods imventory Total current assets Equipment Less accumulated depreciation Total arsets LIABtUTIES AND EQUTTY Accounts payable Bank loun payable Taxes payable Total current liabilities Long-term note payable Total tabilities Common stock Retained earnings Fotal stockholders' equity Total liabilities and equity ZiCEY MANUFACTUADWG Cash Budent April, May, and lune 20xx \begin{tabular}{|c|c|c|c|} \hline & ApritA.Say,and & 20xx & \\ \hline deginning cauch batance & \begin{tabular}{l} April \\ Ho, oto \end{tabular} & \begin{tabular}{l} May \\ 83,346 \end{tabular} & lune \\ \hline ceipts from customers & 4+41,125 & 411,120 & 464,653 \\ \hline Whasle. & 520,125 & & \\ \hline \end{tabular} LESS: Cash disbursements Part 4 \begin{tabular}{|c|c|c|c|c|} \hline \\ \hline Euflerted prochuction (unita) & & May & 22,400 & 60,000 \\ \hline Labor requitrments fer wort Dhoury & 0,5 & 0.5 & 0.5 & \\ \hline Total labor hovos neendent & 4450 & & 10,10 & 30,00 \\ \hline Labor rate (ber hour) & 15 & 15 & 15 & \\ \hline Total tsirect laber cost & 141,750 & 149,260 & 153,p & 450,0 \\ \hline \end{tabular} Part 5 \begin{tabular}{|c|c|c|c|c|} \hline \\ \hline Labor houn needed: & 4,58 & Moy & \begin{tabular}{l} June \\ 10,200 \end{tabular} & Total \\ \hline Variable factory overhend rate & 2.7 & 2.7 & 2.7 & \\ \hline Aludgetted variatle overitead & 26.575 & 26,465 & 27,590 & 1, 800 \\ \hline Add: Fiked overhead & 20,2= & 20,00 & 200=0 & cosoge. \\ \hline Eudpeted total overhead & 46.555 & 46,f605 & 47.540 & \\ \hline \end{tabular} Part 6 \begin{tabular}{|c|c|c|c|c|} \hline \\ \hline Budgeted sales & 4046,725 & \begin{tabular}{c} Mor \\ 4k5075 \end{tabular} & 477,000 & \begin{tabular}{l} Total \\ 1,430 \end{tabular} \\ \hline Sales comimission percent & 0.06 & 0.04 & 0.04 & \\ \hline Sales commissions expense & 31,n+1 & 37,225 & 34,160 & 114,440 \\ \hline Add: Sales salaries. & 3000 & & 3000 & a. 000 \\ \hline Budgeted selling erpenses & 41,144 & 40,106 & 4hiteo & 123,49 \\ \hline \end{tabular} Part 7 Sart 1 sind- 6ouk, 14.15, \begin{tabular}{|c|c|c|c|c|} \hline & \multirow{3}{*}{\begin{tabular}{l} Budpeted \\ Total Dollan \\ 445,725 \end{tabular}} \\ \hline & \begin{tabular}{l} Budented \\ Units \end{tabular} & & \begin{tabular}{l} Budgeted \\ Unit Price \end{tabular} & \\ \hline 4/1/20x & 20,500 & & 23.65 & \\ \hline 5/1/200x & (1,500) & * & 23.45. & =405,075 \\ \hline 6/1/200x & 20,aro & x & 23.45. & =477,000 \\ \hline Total for the second atr & 60,000 & & & 1431,000 \\ \hline \end{tabular} Part 2 \begin{tabular}{|c|c|c|c|c|} \hline \multicolumn{5}{|c|}{\begin{tabular}{l} ZiGBY MANUFACTURING \\ Production Budget \\ April, Mar, and June 200x \end{tabular}} \\ \hline & April & May & June & Total \\ \hline Current period budgeted sales & 20.5 .00 & 19.500 & 20,109 & \\ \hline Next month's budgeted sales & 19.5e0 & 20,000 & 20,500 & \\ \hline Ratio of inventory to future sales & 800% & 90% & 8%1 & \\ \hline Add: Budgeted ending inventory & 15,600 & 16000 & 16,400 & \\ \hline Required units to be produced & 36,100 & 35,500 & 36,400 & \\ \hline Less: beginning inwentory & 16,400 & 15,600 & 1l,000 & \\ \hline Total units to be produced & 11,200 & 19.900 & 20,400 & 2.6010 \\ \hline \end{tabular} Part 3 \begin{tabular}{|c|c|c|c|c|} \hline & \begin{tabular}{l} ZIGBY MANU \\ Raw Mater \\ April, May, an \end{tabular} & & & \\ \hline Budgeted Production (units) & IA, April & \begin{tabular}{l} May \\ 19,900 \end{tabular} & \begin{tabular}{l} fune \\ 20,400 \end{tabular} & Total \\ \hline Materials requirement per unit & 0.50 & 0.50 & 0.50 & \\ \hline Materials needed for production & 9,450 & 9950 & 10,000 & \\ \hline Idd: budgeted ending inventory & 4,475 & 5,100 & 4000 & \\ \hline otal materials requirements (units) & 14,4,25 & 15,050 & 14,200 & \\ \hline ss: beginning inventory & -4925 & 4,975 & 5,100 & \\ \hline aterials to be purchased & 9.900 & 10,075 & 9100 & 29,07 \\ \hline terial price per unit & 20 & 20 & 20 & \\ \hline al cost of direct material purchases & 196,000 & 201,500 & 142,800 & 541,50 \\ \hline \end{tabular} Part9 25 sten pith \begin{tabular}{|c|c|c|} \hline \\ \hline Salen & & 1,431,000 \\ \hline Cost of eoods sold. & & 1,141,005 \\ \hline Gross profit & & 240,000 \\ \hline \multicolumn{3}{|l|}{ Operating expenter } \\ \hline Soles comenission & 117,490 & \\ \hline Sales wataries & 9,000 & \\ \hline General adminitrative walares & 36,=0 & \\ \hline tons term note intertit: & 13.5% & \\ \hline intereit expense & 120 & 173,100 \\ \hline income before tukes & & 66,400 \\ \hline income tans & & 23,45 \\ \hline Net incone & & 43,445 \\ \hline \end{tabular} Part 10 eludgeted Balance Sheet tune 30, 20xx ASSETS Cash Accounts receivable Raw materiala imentory Finished goods imventory Total current assets Equipment Less accumulated depreciation Total arsets LIABtUTIES AND EQUTTY Accounts payable Bank loun payable Taxes payable Total current liabilities Long-term note payable Total tabilities Common stock Retained earnings Fotal stockholders' equity Total liabilities and equity ZiCEY MANUFACTUADWG Cash Budent April, May, and lune 20xx \begin{tabular}{|c|c|c|c|} \hline & ApritA.Say,and & 20xx & \\ \hline deginning cauch batance & \begin{tabular}{l} April \\ Ho, oto \end{tabular} & \begin{tabular}{l} May \\ 83,346 \end{tabular} & lune \\ \hline ceipts from customers & 4+41,125 & 411,120 & 464,653 \\ \hline Whasle. & 520,125 & & \\ \hline \end{tabular} LESS: Cash disbursements Part 4 \begin{tabular}{|c|c|c|c|c|} \hline \\ \hline Euflerted prochuction (unita) & & May & 22,400 & 60,000 \\ \hline Labor requitrments fer wort Dhoury & 0,5 & 0.5 & 0.5 & \\ \hline Total labor hovos neendent & 4450 & & 10,10 & 30,00 \\ \hline Labor rate (ber hour) & 15 & 15 & 15 & \\ \hline Total tsirect laber cost & 141,750 & 149,260 & 153,p & 450,0 \\ \hline \end{tabular} Part 5 \begin{tabular}{|c|c|c|c|c|} \hline \\ \hline Labor houn needed: & 4,58 & Moy & \begin{tabular}{l} June \\ 10,200 \end{tabular} & Total \\ \hline Variable factory overhend rate & 2.7 & 2.7 & 2.7 & \\ \hline Aludgetted variatle overitead & 26.575 & 26,465 & 27,590 & 1, 800 \\ \hline Add: Fiked overhead & 20,2= & 20,00 & 200=0 & cosoge. \\ \hline Eudpeted total overhead & 46.555 & 46,f605 & 47.540 & \\ \hline \end{tabular} Part 6 \begin{tabular}{|c|c|c|c|c|} \hline \\ \hline Budgeted sales & 4046,725 & \begin{tabular}{c} Mor \\ 4k5075 \end{tabular} & 477,000 & \begin{tabular}{l} Total \\ 1,430 \end{tabular} \\ \hline Sales comimission percent & 0.06 & 0.04 & 0.04 & \\ \hline Sales commissions expense & 31,n+1 & 37,225 & 34,160 & 114,440 \\ \hline Add: Sales salaries. & 3000 & & 3000 & a. 000 \\ \hline Budgeted selling erpenses & 41,144 & 40,106 & 4hiteo & 123,49 \\ \hline \end{tabular} Part 7 Sart 1 sind- 6ouk, 14.15, \begin{tabular}{|c|c|c|c|c|} \hline & \multirow{3}{*}{\begin{tabular}{l} Budpeted \\ Total Dollan \\ 445,725 \end{tabular}} \\ \hline & \begin{tabular}{l} Budented \\ Units \end{tabular} & & \begin{tabular}{l} Budgeted \\ Unit Price \end{tabular} & \\ \hline 4/1/20x & 20,500 & & 23.65 & \\ \hline 5/1/200x & (1,500) & * & 23.45. & =405,075 \\ \hline 6/1/200x & 20,aro & x & 23.45. & =477,000 \\ \hline Total for the second atr & 60,000 & & & 1431,000 \\ \hline \end{tabular} Part 2 \begin{tabular}{|c|c|c|c|c|} \hline \multicolumn{5}{|c|}{\begin{tabular}{l} ZiGBY MANUFACTURING \\ Production Budget \\ April, Mar, and June 200x \end{tabular}} \\ \hline & April & May & June & Total \\ \hline Current period budgeted sales & 20.5 .00 & 19.500 & 20,109 & \\ \hline Next month's budgeted sales & 19.5e0 & 20,000 & 20,500 & \\ \hline Ratio of inventory to future sales & 800% & 90% & 8%1 & \\ \hline Add: Budgeted ending inventory & 15,600 & 16000 & 16,400 & \\ \hline Required units to be produced & 36,100 & 35,500 & 36,400 & \\ \hline Less: beginning inwentory & 16,400 & 15,600 & 1l,000 & \\ \hline Total units to be produced & 11,200 & 19.900 & 20,400 & 2.6010 \\ \hline \end{tabular} Part 3 \begin{tabular}{|c|c|c|c|c|} \hline & \begin{tabular}{l} ZIGBY MANU \\ Raw Mater \\ April, May, an \end{tabular} & & & \\ \hline Budgeted Production (units) & IA, April & \begin{tabular}{l} May \\ 19,900 \end{tabular} & \begin{tabular}{l} fune \\ 20,400 \end{tabular} & Total \\ \hline Materials requirement per unit & 0.50 & 0.50 & 0.50 & \\ \hline Materials needed for production & 9,450 & 9950 & 10,000 & \\ \hline Idd: budgeted ending inventory & 4,475 & 5,100 & 4000 & \\ \hline otal materials requirements (units) & 14,4,25 & 15,050 & 14,200 & \\ \hline ss: beginning inventory & -4925 & 4,975 & 5,100 & \\ \hline aterials to be purchased & 9.900 & 10,075 & 9100 & 29,07 \\ \hline terial price per unit & 20 & 20 & 20 & \\ \hline al cost of direct material purchases & 196,000 & 201,500 & 142,800 & 541,50 \\ \hline \end{tabular}