MANAGERIAL ACCOUNTING CASE PREPARATION OF A MASTER BUDGET Point Value 70 points Required Based on the following information, prepare the following budgets for each month and the quarter ending March 31, 2011 (Hint First quarter consists of January, February and March ) Sales Budget, including a schedule of expected cash collections Production Budget (in units) Manufacturing Overhead Budget Selling and Administrative Expenses Budget Cash Budget (Note Even though you are not required to prepare Direct Materials and Direct Labor budgets, direct materials and direct labor information is necessary to prepare the Cash Budget ) Information 1 Sales forecast January 2,000 units February 1,700 units March 1,600 units April 1,500 units The unit sales price is $16 All sales are on credit and collections are 40 in the month of sale and 60 the following month Accounts receivable as of December 31, 2010 is $17,200 and this amount is expected to be collected in January 2011 2 End of month inventory must equal 70 of next month s sales The inventory at the end of December 2010 was 1,400 units 3 The following are the expected costs for direct materials, direct labor and manufacturing overhead DM DL Overhead January $14,800 $6,300 $5,610 $1 50 per unit produced February 8,600 5,700 $5,610 $1 50 per unit produced March 8,400 5,300 $5,610 $1 50 per unit produced A Direct materials are paid 25 in the month incurred and 75 in the following month Account payable for materials as of December 31, 2010 is $5,400 this amount will be paid in January 2011 B Direct labor is paid in the month incurred C Overhead costs are paid in the month incurred Fixed overhead includes depreciation of $1,500 per month 4 Selling costs are sales commissions $ 30 per unit sold shipping costs $ 14 per unit sold Administrative costs per month are salaries $1,200 rent $400 depreciation $800 All costs are paid in month incurred 5 The company plans to buy equipment costing $10,000 in January 6 The cash balance as of December 31, 2010 is $10,200 The company borrows money only if the cash balance falls below $2,000 at the end of the month MANAGERIAL ACCOUNTING CASE PREPARATION OF A MASTER BUDGET Point Value 70 points Required Based on the following information, prepare the following budgets for each month and the quarter ending March 31, 2011 (Hint First quarter consists of January, February and March ) Sales Budget, including a schedule of expected cash collections Production Budget (in units) Manufacturing Overhead Budget Selling and Administrative Expenses Budget Cash Budget (Note Even though you are not required to prepare Direct Materials and Direct Labor budgets, direct materials and direct labor information is necessary to prepare the Cash Budget ) Information 1 Sales forecast January 2,000 units February 1,700 units March 1,600 units April 1,500 units The unit sales price is $16 All sales are on credit and collections are 40 in the month of sale and 60 the following month Accounts receivable as of December 31, 2010 is $17,200 and this amount is expected to be collected in January 2011 2 End of month inventory must equal 70 of next month's sales The inventory at the end of December 2010 was 1,400 units 3 The following are the expected costs for direct materials, direct labor and manufacturing overhead DM DL Overhead January $14,800 $6,300 $5,610 $1 50 per unit produced February 8,600 5,700 $5,610 $1 50 per unit produced March 8,400 5,300 $5,610 $1 50 per unit produced A Direct materials are paid 25 in the month incurred and 75 in the following month Account payable for materials as of December 31, 2010 is $5,400 this amount will be paid in January 2011 B Direct labor is paid in the month incurred C Overhead costs are paid in the month incurred Fixed overhead includes depreciation of $1,500 per month 4 Selling costs are sales commissions $ 30 per unit sold shipping costs $ 14 per unit sold Administrative costs per month are salaries $1,200 rent $400 depreciation $800 All costs are paid in month incurred 5 The company plans to buy equipment costing $10,000 in January 6 The cash balance as of December 31, 2010 is $10,200 The company borrows money only if the cash balance falls below $2,000 at the end of the month

The Answer is in the image, click to view ...

Answered step by step

Verified Expert Solution

Link Copied!

Question

1 Approved Answer

Posted on Jun 28, 2024

MANAGERIAL ACCOUNTING CASE - PREPARATION OF A MASTER BUDGET Point Value ? 70 points Required: Based on the following information, prepare the following budgets for

MANAGERIAL ACCOUNTING CASE - PREPARATION OF A MASTER BUDGET Point Value ? 70 points Required: Based on the following information, prepare the following budgets for each month and the quarter ending March 31, 2011: (Hint: First quarter consists of January, February and March.) ? Sales Budget, including a schedule of expected cash collections ? Production Budget (in units) ? Manufacturing Overhead Budget ? Selling and Administrative Expenses Budget ? Cash Budget (Note: Even though you are not required to prepare Direct Materials and Direct Labor budgets, direct materials and direct labor information is necessary to prepare the Cash Budget.) Information: 1. Sales forecast: January: 2,000 units; February: 1,700 units; March: 1,600 units; April: 1,500 units. The unit sales price is $16. All sales are on credit and collections are 40% in the month of sale and 60% the following month. Accounts receivable as of December 31, 2010 is $17,200 and this amount is expected to be collected in January 2011. 2. End of month inventory must equal 70% of next month?s sales. The inventory at the end of December 2010 was 1,400 units. 3. The following are the expected costs for direct materials, direct labor and manufacturing overhead: DM DL Overhead January $14,800 $6,300 $5,610 + $1.50 per unit produced February 8,600 5,700 $5,610 + $1.50 per unit produced March 8,400 5,300 $5,610 + $1.50 per unit produced A. Direct materials are paid 25% in the month incurred and 75% in the following month. Account payable for materials as of December 31, 2010 is $5,400; this amount will be paid in January 2011. B. Direct labor is paid in the month incurred. C. Overhead costs are paid in the month incurred. Fixed overhead includes depreciation of $1,500 per month. 4. Selling costs are sales commissions: $.30 per unit sold; shipping costs: $.14 per unit sold. Administrative costs per month are: salaries: $1,200; rent: $400; depreciation: $800. All costs are paid in month incurred. 5. The company plans to buy equipment costing $10,000 in January. 6. The cash balance as of December 31, 2010 is $10,200. The company borrows money only if the cash balance falls below $2,000 at the end of the month. image text in transcribed

MANAGERIAL ACCOUNTING CASE - PREPARATION OF A MASTER BUDGET Point Value - 70 points Required: Based on the following information, prepare the following budgets for each month and the quarter ending March 31, 2011 : (Hint: First quarter consists of January, February and March.) Sales Budget, including a schedule of expected cash collections Production Budget (in units) Manufacturing Overhead Budget Selling and Administrative Expenses Budget Cash Budget (Note: Even though you are not required to prepare Direct Materials and Direct Labor budgets, direct materials and direct labor information is necessary to prepare the Cash Budget.) Information: 1. Sales forecast: January: 2,000 units; February: 1,700 units; March: 1,600 units; April: 1,500 units. The unit sales price is $16. All sales are on credit and collections are 40% in the month of sale and 60% the following month. Accounts receivable as of December 31, 2010 is $17,200 and this amount is expected to be collected in January 2011. 2. End of month inventory must equal 70% of next month's sales. The inventory at the end of December 2010 was 1,400 units. 3. The following are the expected costs for direct materials, direct labor and manufacturing overhead: DM DL Overhead January $14,800 $6,300 $5,610 + $1.50 per unit produced February 8,600 5,700 $5,610 + $1.50 per unit produced March 8,400 5,300 $5,610 + $1.50 per unit produced A. Direct materials are paid 25% in the month incurred and 75% in the following month. Account payable for materials as of December 31, 2010 is $5,400; this amount will be paid in January 2011. B. Direct labor is paid in the month incurred. C. Overhead costs are paid in the month incurred. Fixed overhead includes depreciation of $1,500 per month. 4. Selling costs are sales commissions: $.30 per unit sold; shipping costs: $.14 per unit sold. Administrative costs per month are: salaries: $1,200; rent: $400; depreciation: $800. All costs are paid in month incurred. 5. The company plans to buy equipment costing $10,000 in January. 6. The cash balance as of December 31, 2010 is $10,200. The company borrows money only if the cash balance falls below $2,000 at the end of the month