Arial 12 AA == Wrap Text Ger Paste BLUE OASE Merge & Conter $ - F68 + x fx CDE 65 66 Labor Rate per Hour 67 Estimated Cost of Direct Labor $15.00 $44,400 $15.00 $45,045 $15.00 $47,29 68 70 5. Factory Overhead Budget January February March 72 Targeted Units to Be Produced 73 Variable Factory Overhead Rate 74 Budgeted Variable Overhead 75 Budgeted Fixed Overhead 76 Budgeted Total Overhead 79 6. Selling, General & Administrative Expense Budget January February March 1st 81 Total Budgeted Sales 82 Commission% 83 Sales Commissions 34 Manager's Salary 85 Budgeted Selling Expenses 87 Administrative Salaries as Interest on Long-Term Note Payable 89 Budgeted General & Administrative Expenses 00 Total Budgeted Selling, General & Admin Expense Budget 93 7. Schedule of Cash Receipts 95 Total Budgeted Sales January February March 1st Qua Lab 7 for Chapter 20 Template - ACC 214 (2) Home Review View LI Autofavet BE SU: Insert Draw Page Layout Formulas X Arial - 12 -A BTU A x v fx Data I E General Paste F68 1 Wrap Test Marge & Center E $ % & A! 87 Administrative Salaries 88 Interest on Long-Term Note Payable 89 Budgeted General & Administrative Expenses 90 Total Budgeted Selling. General & Admin. Expense Budget 93 7. Schedule of Cash Receipts January February March 1st Quarter 95 Total Budgeted Sales 96 Estimated Ending Accounts Receivable (credit sales) 97 Cash Receipts 98 - Cash Sales 99 - Collection of Prior Month's Receivables 100 Estimated Cash to Be Collected $175.000 102 103 8. Schedule of Cash Payments for Materials 104 105 Cash Payments for Prior Month's Materials' Purchases January $63,818 February March 1st Quarter 108 9. Cash Budget January $50,000 February March 110 Beginning Cash Balance 111 Add: Cash Receipts from Customers 112 Total Cash Available 113 Lens Cash Payments for 114 - Direct Materials 115 - Direct Labor 116 - Variable Overhead MacBook Air o. Home Lab 7 for Chapter 20 Template - ACC 210 AutoSaver & S UE Insert Draw Page Layout Formulas Arial - 12 -A A BIU A View LX Data Review == E Wrap Text Merge Center General F68 E x fx $ - % - DEF a 108 9. Cash Budget January $50,000 February March 110 Beginning Cash Balance 11 Add: Cash Receipts from Customers 112 Total Cash Available 13 Less: Cash Payments for 14 - Direct Materials 415 - Direct Labor 16 - Variable Overhead 117 - Sales Commissions 118 - Sales Salaries 1191 - Administrative Salaries 120 - Dividends 121 - Interest on Long-Term Note Payable 122 - Interest on Short-Term Note Payable 123 - Purchase of Equipment 124 Total Cash Payments 125 126 Preliminary Cash Balance 127 Borrowing repayments required to maintain minimum cash balance 126 Ending Cash Balance 129 Short-term nate balance, End of Month 130 133 134 LOOP #cold #9 MacBook Air % 20 Template ACC 214 21 La for C Home Dr Page Layout Form Dute Review View AW A == we Orvou.O.E EEE Oxfor $ real $% %, od Car De 1 Lab Template for Chapter 20 2 Master Budget for a Marvutacturer Budget Assumptions 1. Projected January unit Assumed month-over month noresuntas 7 - Selling priceperunt 2. Mor e lle 25cash sales and crea t ed in the month owing the 3. Ending t he goods Inventory show equal of the next more expected sales 104 Ending raw materials inventory should also of the next month's expected raw material needs. 11 5. The products manufacturing costs $12.65 per unit, including: - $7 35 per un formater 05 3 14.70 b) All purchases are on credit and paid the following month 1 - $3.75 per un for director (0.25 hour 515 per hour rate 14 - 31.10 per un for variatieverhead 15 - 0.45 per un tored overhead costing entry of $5.000 per month for depresion expense) 16 6. Becom e 10% of , and are paid in the month of these 17 7. The sales manager's mothy wary is 14,000 January, and $5,000 each month thereater 18 8. Monthly general d e expenses include $12.000 in salaries and 0.8% mothers on a long term 1.200.000 note de next year 10. Minimum m a nding cash balance should be 550,000.fecesary, the company borrows enough to reach the > minimum. Ary borrowed short-term notes require a W e payment of month and before any repayments borrowing. Ifanding cash exceeds 21 the minimum of $50,000, the excess is applied to repay any outstanding short term note. There are currently no outstanding short-term notes 22 10. Dividends of $120.000 are declared and paid in February 23 11 Equipment purchases of $75.000 e scheduled for March Required. Prepare the following budget schedules 2 1. Sales Budget January 11,000 February 11.550 March 12,128 Quarter 34.678 50 Proded Monthly Unit Sales 1 Sling PricePerU Total Budgeted Sales 5242.000 1254.100 1264,805 3762,805 3 2. Production Budget January February March 1st Quarter MacBook Air 5 6 7 W M A BE. Lab for Chapter 20 Template ACC 214 2) Home Imert Draw Page Layout Formulas Data Review View Pare BTU. . .A EE E E et S - % 1 Conditional Form PAS X 22 10. Ovidends of $120.000 are declared and paid in February 23 11. Equipment purchases of $75,000 are scheduled for March 25 Required. Prepare the following budget schedules: Sales Budget January 11.000 February 11,550 March 12,128 1st Quarter 34 678 30 Projected Monthly Unt Sales 31 Seling Price Per Unit 32 Total Budgeted Sales 5242,000 $254,100 $266,8053762,905 35 2. Production Budget January February 12,128 March 12.734 1st Quarter 37 Projected Next Month's Unit Sales 30 Targeted Ending Inventory 39 Desired Ending Inventory (units) 40 Current Period's Unit Sales 41 Estimated Units of Production 2 Less: Beginning inventory (units) 13 Targeted Units to be produced 34.678 11,000 20.240 11,550 21,252 12,128 22315 11,840 12,012 12,613 36.465 48 3. Direct Materials Budget January February March 12,613 38.465 5.920 48 Targeted Units to Be Produced 49 Materials Requirement per Unit (lbs) 50 Materials Needed for Production (bs) 51 Add: Targeted Ending Inventory (bs) 52 Total Materials Required (s) 53 Less: Beginning inventory (lbs) 54 Materials to Be Purchased (lbs) 2.100 2.100 3.000 6,156 3.153 5,253 2.425 17 907 56 Materials Price per Pound ST Estimated Cost of Direct Materials Purchases Ch 29 Template + $14.70 595,521 $14.70 590,493 $14.70 $77219 $14.70 $263,233 MacBook Air 3020 La Cha 20 Termolate - ACC 214 21 Home Insert Draw Page Layout Formulas Date Review View TU... A r e S. Co 188 xf 04. Direct Labor Budget January 11,840 2 Targeted Units to Be Produced 63 Labor Requirement per Uw hours) 64 Total Labor Hours Needed February 12.012 March 12,613 68 Labor Rate per Hour 67 Estimated Cost of Direct Labor $15.00 144,400 $15.00 145,045 $15.00 547 297 136,742 70 5. Factory Overhead Budget January February March 72 Targeted Units to Be Produced 73 Variable Factory Overhead Rate 74 Budgeted Variable Overhead 75 Budgeted Fixed Overhead 75 Budgeted Total Overhead 7 6. Selling. General & Administrative Expen January February March 1st Quarter * Total Budgeted Sales 12 Commission 83 Sales Commissions 84 Manager's Salary 85 Budgeted Selling Expenses 87 Administrative Salaries 18 Interest on Long-Term Note Payable 9 Budgeted General & Administrative Expenses 90 Total Budgeted Selling. General & Admin Expense Budget 17 Bhadanah baranta C 20 Template + MacBook Air Arial 12 AA == Wrap Text Ger Paste BLUE OASE Merge & Conter $ - F68 + x fx CDE 65 66 Labor Rate per Hour 67 Estimated Cost of Direct Labor $15.00 $44,400 $15.00 $45,045 $15.00 $47,29 68 70 5. Factory Overhead Budget January February March 72 Targeted Units to Be Produced 73 Variable Factory Overhead Rate 74 Budgeted Variable Overhead 75 Budgeted Fixed Overhead 76 Budgeted Total Overhead 79 6. Selling, General & Administrative Expense Budget January February March 1st 81 Total Budgeted Sales 82 Commission% 83 Sales Commissions 34 Manager's Salary 85 Budgeted Selling Expenses 87 Administrative Salaries as Interest on Long-Term Note Payable 89 Budgeted General & Administrative Expenses 00 Total Budgeted Selling, General & Admin Expense Budget 93 7. Schedule of Cash Receipts 95 Total Budgeted Sales January February March 1st Qua Lab 7 for Chapter 20 Template - ACC 214 (2) Home Review View LI Autofavet BE SU: Insert Draw Page Layout Formulas X Arial - 12 -A BTU A x v fx Data I E General Paste F68 1 Wrap Test Marge & Center E $ % & A! 87 Administrative Salaries 88 Interest on Long-Term Note Payable 89 Budgeted General & Administrative Expenses 90 Total Budgeted Selling. General & Admin. Expense Budget 93 7. Schedule of Cash Receipts January February March 1st Quarter 95 Total Budgeted Sales 96 Estimated Ending Accounts Receivable (credit sales) 97 Cash Receipts 98 - Cash Sales 99 - Collection of Prior Month's Receivables 100 Estimated Cash to Be Collected $175.000 102 103 8. Schedule of Cash Payments for Materials 104 105 Cash Payments for Prior Month's Materials' Purchases January $63,818 February March 1st Quarter 108 9. Cash Budget January $50,000 February March 110 Beginning Cash Balance 111 Add: Cash Receipts from Customers 112 Total Cash Available 113 Lens Cash Payments for 114 - Direct Materials 115 - Direct Labor 116 - Variable Overhead MacBook Air o. Home Lab 7 for Chapter 20 Template - ACC 210 AutoSaver & S UE Insert Draw Page Layout Formulas Arial - 12 -A A BIU A View LX Data Review == E Wrap Text Merge Center General F68 E x fx $ - % - DEF a 108 9. Cash Budget January $50,000 February March 110 Beginning Cash Balance 11 Add: Cash Receipts from Customers 112 Total Cash Available 13 Less: Cash Payments for 14 - Direct Materials 415 - Direct Labor 16 - Variable Overhead 117 - Sales Commissions 118 - Sales Salaries 1191 - Administrative Salaries 120 - Dividends 121 - Interest on Long-Term Note Payable 122 - Interest on Short-Term Note Payable 123 - Purchase of Equipment 124 Total Cash Payments 125 126 Preliminary Cash Balance 127 Borrowing repayments required to maintain minimum cash balance 126 Ending Cash Balance 129 Short-term nate balance, End of Month 130 133 134 LOOP #cold #9 MacBook Air % 20 Template ACC 214 21 La for C Home Dr Page Layout Form Dute Review View AW A == we Orvou.O.E EEE Oxfor $ real $% %, od Car De 1 Lab Template for Chapter 20 2 Master Budget for a Marvutacturer Budget Assumptions 1. Projected January unit Assumed month-over month noresuntas 7 - Selling priceperunt 2. Mor e lle 25cash sales and crea t ed in the month owing the 3. Ending t he goods Inventory show equal of the next more expected sales 104 Ending raw materials inventory should also of the next month's expected raw material needs. 11 5. The products manufacturing costs $12.65 per unit, including: - $7 35 per un formater 05 3 14.70 b) All purchases are on credit and paid the following month 1 - $3.75 per un for director (0.25 hour 515 per hour rate 14 - 31.10 per un for variatieverhead 15 - 0.45 per un tored overhead costing entry of $5.000 per month for depresion expense) 16 6. Becom e 10% of , and are paid in the month of these 17 7. The sales manager's mothy wary is 14,000 January, and $5,000 each month thereater 18 8. Monthly general d e expenses include $12.000 in salaries and 0.8% mothers on a long term 1.200.000 note de next year 10. Minimum m a nding cash balance should be 550,000.fecesary, the company borrows enough to reach the > minimum. Ary borrowed short-term notes require a W e payment of month and before any repayments borrowing. Ifanding cash exceeds 21 the minimum of $50,000, the excess is applied to repay any outstanding short term note. There are currently no outstanding short-term notes 22 10. Dividends of $120.000 are declared and paid in February 23 11 Equipment purchases of $75.000 e scheduled for March Required. Prepare the following budget schedules 2 1. Sales Budget January 11,000 February 11.550 March 12,128 Quarter 34.678 50 Proded Monthly Unit Sales 1 Sling PricePerU Total Budgeted Sales 5242.000 1254.100 1264,805 3762,805 3 2. Production Budget January February March 1st Quarter MacBook Air 5 6 7 W M A BE. Lab for Chapter 20 Template ACC 214 2) Home Imert Draw Page Layout Formulas Data Review View Pare BTU. . .A EE E E et S - % 1 Conditional Form PAS X 22 10. Ovidends of $120.000 are declared and paid in February 23 11. Equipment purchases of $75,000 are scheduled for March 25 Required. Prepare the following budget schedules: Sales Budget January 11.000 February 11,550 March 12,128 1st Quarter 34 678 30 Projected Monthly Unt Sales 31 Seling Price Per Unit 32 Total Budgeted Sales 5242,000 $254,100 $266,8053762,905 35 2. Production Budget January February 12,128 March 12.734 1st Quarter 37 Projected Next Month's Unit Sales 30 Targeted Ending Inventory 39 Desired Ending Inventory (units) 40 Current Period's Unit Sales 41 Estimated Units of Production 2 Less: Beginning inventory (units) 13 Targeted Units to be produced 34.678 11,000 20.240 11,550 21,252 12,128 22315 11,840 12,012 12,613 36.465 48 3. Direct Materials Budget January February March 12,613 38.465 5.920 48 Targeted Units to Be Produced 49 Materials Requirement per Unit (lbs) 50 Materials Needed for Production (bs) 51 Add: Targeted Ending Inventory (bs) 52 Total Materials Required (s) 53 Less: Beginning inventory (lbs) 54 Materials to Be Purchased (lbs) 2.100 2.100 3.000 6,156 3.153 5,253 2.425 17 907 56 Materials Price per Pound ST Estimated Cost of Direct Materials Purchases Ch 29 Template + $14.70 595,521 $14.70 590,493 $14.70 $77219 $14.70 $263,233 MacBook Air 3020 La Cha 20 Termolate - ACC 214 21 Home Insert Draw Page Layout Formulas Date Review View TU... A r e S. Co 188 xf 04. Direct Labor Budget January 11,840 2 Targeted Units to Be Produced 63 Labor Requirement per Uw hours) 64 Total Labor Hours Needed February 12.012 March 12,613 68 Labor Rate per Hour 67 Estimated Cost of Direct Labor $15.00 144,400 $15.00 145,045 $15.00 547 297 136,742 70 5. Factory Overhead Budget January February March 72 Targeted Units to Be Produced 73 Variable Factory Overhead Rate 74 Budgeted Variable Overhead 75 Budgeted Fixed Overhead 75 Budgeted Total Overhead 7 6. Selling. General & Administrative Expen January February March 1st Quarter * Total Budgeted Sales 12 Commission 83 Sales Commissions 84 Manager's Salary 85 Budgeted Selling Expenses 87 Administrative Salaries 18 Interest on Long-Term Note Payable 9 Budgeted General & Administrative Expenses 90 Total Budgeted Selling. General & Admin Expense Budget 17 Bhadanah baranta C 20 Template + MacBook Air
