Question

Jordan and Taylor are too busy baking brownies to schedule an appointment with you. They did send you the enclosed questions for you to answer.

1. Units to be produced annually: 200,000 tins
Direct labor: 1 hour per 100 tins
Variable overhead costs per direct labor hour:
Indirect materials $2.05
Indirect labor $1.20
Utilities $9.25
Maintenance $3.50
Fixed overhead costs per quarter:
Insurance $3,000
Depreciation $2,000
Rent $12,000

What is the budgeted total manufacturing overhead for the year? (5 points)

2. Sales: 60,000 tins per quarter
Variable costs per dollar of sales: sales commissions 5%, delivery expense .5%, and advertising 1.5%.
Fixed costs per quarter: sales salaries $40,000, office rent $1,500, utilities $1,200, and repairs expense $200.
Selling price: $10 per tin

What is the budgeted total selling and administrative expenses for the quarter? (5 points)

3. Sales are 30% cash and 70% on credit. Credit sales are collected 10% in the month of sale, 50% in the month following sale, and 36% in the second month following sale. Sales were December $180,000; January $220,000; February $250,000; and March $300,000.

What was total cash received in March? (5 points)

Answer 1

1. Computation of Total Budgeted Manufactuing Overhead					3. Computation of Total Cash Received
Particular	Amount	Amount	Calculation		Particular	December	January	February	March
Variable Cost					Total Sales	$180,000	$220,000	$250,000	$300,000
Indirect Material	$4,100.00		(2000*$2.05)		Cash Sales (30% (a)	$54,000	$66,000	$75,000	$90,000
Indirect Labour	$2,400.00		(2000*$1.20)		Credit Sales (70%)	$126,000	$154,000	$175,000	$210,000
Utilities	$18,500.00		(2000*$9.25)
Maintainance	$7,000.00		(2000*$3.5)		10% of Credit Sales in Same Month (b)	$12,600	$15,400	$17,500	$21,000
Total Variable Cost		$32,000.00			50% of Credit Sales in following Month ( C)		$63,000	$77,000	$87,500
Fixed Cost:					36% of Credit Sales in Second Month (d)			$45,360	$55,440
Insurance	$12,000.00		(3000*4)		Total Cash Received (A+B+C+D)	$66,600	$144,400	$214,860	$253,940
Depreciation	$80,000.00		(2000*4)
Rent	$48,000.00		(12000*4)
Total Fixed Cost		$140,000.00
Total Budgeted Manufacturing Overhead		$172,000.00
2. Computation of Budgeted Selling & Administration Expense
Particular	Amount	Amount	Calculation
Variable Cost
Sales Commission	$30,000		(60000*$10*5%)
Delivery Expense	$3,000		(60000*$10*0.5%)
Advertising	$9,000		(60000*$10*1.5%)
Total Variable Cost		$42,000
Fixed Cost
Sales Salaries	$160,000		($40000*4)
Office rent	$6,000		($1500*4)
Utilities	$4,800		($1200*4)
Repaired Expense	$800		($200*4)
Total Fixed Cost		$171,600
Total		$213,600