Academic Integrity: tutoring, explanations, and feedback — we don’t complete graded work or submit on a student’s behalf.

Jordan and Taylor are too busy baking brownies to schedule an appointment with y

ID: 2554712 • Letter: J

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)

Explanation / Answer

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