3 Fill in The Blanks A. ALISON MANUFACTURING SALES BUDGET FOR THE COMING YEAR Year 11,100 Expected Unit Sales Unit Selling Prices Budgeted Sales Quarter 1 2,000 $70,00 $140,000 Quarter 2 2,400 $70.00 $168,000 Quarter 3 3,000 $70.00 $210,000 Quarter 4 3,700 $70.00 $259,000 $777,000 B. ALISON MANUFACTURING PRODUCTION BUDGET FOR THE COMING YEAR Year Quarter 1 2.000 480 Expected Unit Sales Add: Desired ending finished goods unit Total required units Less: Beginning finished goods unit Required production units Quarter 2 2,400 600 3,000 LA Quarter 3 3,000 740 3,740 18 Quarter 4 3,700 800 4,500 1 11,100 2620 13,720 350 2,480 XXX XXX XXX XXX . ALISON MANUFACTURING DIRECT MATERIAL BUDGET FOR THE COMING YEAR Quarter 2,130 3 Quarter 2 2,520 Quarter 4 3,760 Year 11,550 3 Quarter 3 3.140 3 9,420 20 Units to be produced Direct materials per unit Total unit needed for production Add: Desired ending direct marenal 3 6.390 ZA 7,560 2B 11,280 2.500 XXX 1.300 XOOX Total materials required Less: Beginning direct materials Direct material purchases Cost per unit Total purchase cost metals xxx 1,512 xxx XXX XOOX 2,256 XOOX $8.00 3D 1,884 XOXX $8.00 30 $8.00 $8.00 3B xox D. ALISON MANUFACTURING DIRECT LABOR BUDGET FOR THE COMING YEAR Quarter 1 4A Quarter 2 48 Quarter 3 4C Year Quarter 4 4D 11,550 2 Units to be produced Direct labor time per unit in hours Total hours needed Average Wage per hour Total direct labor cost 2 4,260 2 5,040 $10.00 $50,400 $10.00 $42,600 6,280 $10.00 $62,800 2 7,520 $10.00 $75,200 $231,000 E. ALISON MANUFACTURING OVERHEAD BUDGET FOR THE COMING YEAR Quarter 1 Quarter 2 Quarter 3 Quarter 4 Year $3,300 Budgeted direct labor hours Variable overhead rate Supplies Power Maintenance Other Total variable overhead Budgeted variable overhead S3 000 $2.540 $2.690 $2.770 $11,000 $2,794 $2959 $3,04 $3,630 $3,073 $3,255 53,352 $13,310 $3,993 $3.381 $3,580 $3,687 $14,641 $12.100 SS1,051 om MEDYNIMDAT MEN Fixed overhead rate Maintenance Supervision Depreciation Taxes Other Budgeted fixed overhead Total overhead $5,500 $7,540 $8,700 $2,450 $1,950 $26,140 $37,140 $6,050 $8.294 $9,570 $2,695 $2,145 $28,754 $40,854 $6,655 $9,123 $10,527 $2.965 S2,360 $31,629 $44,939 $7,321 $10,036 $11,580 $3,261 $2,595 $34,792 $49,433 $121,316 $172,367 ALISON MANUFACTURING 5 F. FOR THE COMING YEAR Quarter 1 2.000 Quarter 2 2.400 Quarter 3 3,000 Quarter 4 3,700 Year 11,100 $3,000 $2,500 $1,000 $3,600 $3,000 $1,200 $7,800 $4,320 $3,600 $1,440 59,360 $5,184 $4,320 $1,728 $11,232 $6,500 $34,892 Planned Sales in Units Variable Selling and Administrative Expenses pel Commissions Shipping Other Total Variable Expenses Fixed Selling and Administrative Expenses: Salaries Depreciation Other Total Fixed Expenses Total Selling and Administrative Expenses $8.400 $4,800 $1,800 $15,000 $22,800 $7.000 $4,000 $1,500 $12,500 $19.000 $10,080 $5,760 $2,160 $18,000 $27,360 $12,096 $6,912 $2.592 $67.100 $21,600 $32,832 6 ALISON MANUFACTURING ENDING FINISHED GOODS INVENTORY BUDGET G FOR THE COMING YEAR Year Direct Material Direct Labor Manufacturing Overhead Unit Cost Quarter 1 $24 $20 $19 $63 Quarter 2 $24 $20 $17 $61 Quarter 3 $24 $20 $15 $59 Quarter 4 $24 $20 $13 $57 $240 480 Unit Total Ending Inventory 600 $36, 614 740 $43,645 800 $45,888 2,620 $628,624 $30,034 H. ALISON MANUFACTURING COST OF GOODS SOLD BUDGET FOR THE COMING YEAR I Quarter 1 $52,816 $42,600 537,140 Direct Materials Used Direct Labor Used Overhead Budgeted Manufacturing Costs Beginning Finished Goods Cost of Goods Available for Sale Less Ending Finished Goods Budgeted Cost of Goods Sold Quarter 2 $63,456 550,400 S40,854 $154,710 $30,034 $184,744 536,614 Quarter 3 $78,336 562.800 $44.939 $186,075 $36,614 $222,689 $132.556 $21.900 $154,456 $30,034 $124,422 Quarter 4 $92,192 $75,200 $49.433 $216,825 $43,645 $260,470 $45,888 $214,582 Year $286,800 $231,000 $172,367 $690.167 $21,900 $712,066 $45 888 $666,178 $43,645 $179,044 $148, 130 1 ALISON MANUFACTURING 7 FOR THE COMING YEAR Year Sales $277.000 sual TULUI IA JE .google.com/UMTUMIAYNIMDAWO/MESNEONXONDES/detalla Less: Cost of Goods Sold Gross Margin Less: Selling and Administrative expense Operating Income Less: Interest Expense Income Before Income Taxes Less: Income Taxes Net Income 8 $110,822 $101,992 $8,830 $0 $8,830 SO $8,830 1. ALISON MANUFACTURING BUDGETED CASH FLOW FOR THE COMING YEAR Year Quarter 1 $350,000 Quarter 2 $376,444 Quarter $412,534 Quarter 4 $463,819 $350,000 $140,000 $140,000 $490,000 $168.000 $168.000 $544,444 $210,000 $210,000 $622,534 $259,000 $259,000 $722,819 $777,000 $777,000 $1,127,000 90 Beginning cash balance Add: Receipts Collection from customer Total receipts Total available cash Less: Disbursements Direct materials Direct labor Manufacturing overhead Selling and administrative expenses Total disbursements Excess (deficienyl of available cash over cash disbursements 9A $42.600 10A $19.000 -$113,556 90 -$50.400 106 S22,800 -$131,910 90 -$62.800 100 527,360 -5158,715 -$75,200 100 532,832 -5183,993 -$286.800 $231.000 $172,367 -5101,992 $792,159 $412.534 $376,444 $334,841 $538,825 5463,819 K ALISON MANUFACTURING BUDGETED BALANCE SHEET FOR THE COMING YEAR Assets Current Assets Cash Accounts Receivables Raw Materials Inventory Finished Goods Inventory Total Current Assets Property, Plant, and Equipment (PPE) Land Equipment Less: Accumulated Depreciation - Equipment Total PPE Total Assets $334,841 11 $20,000 $45,888 $478.430 $300,000 $50,000 $10,000 $260,000 12 $46,096 $46,096 Liabilities & Equity Liability Current Liabilities Accounts Payables Total Liabilities Owner's Equity Owner's Equity Total Equity Total Liabitilites and Equity $692.334 $692,334 $738,430