Homework _ C9, 10, 11 - E 9-1 Budgeted Sales From Apr Sales...

Info iconThis preview shows pages 1–2. Sign up to view the full content.

View Full Document Right Arrow Icon
E 9-1 February March April May June July August Total Budgeted Sales $230,000.00 $260,000.00 $300,000.00 $500,000.00 $200,000.00 $1,490,000.00 From Apr Sales 60,000.00 210,000.00 30,000.00 300,000.00 From May Sales - 100,000.00 350,000.00 50,000.00 450,000.00 From June Sales - - 40,000.00 140,000.00 20,000.00 40,000.00 From March Sales 52,000.00 182,000.00 26,000.00 208,000.00 From Feb Sales 46,000.00 161,000.00 23,000.00 23,000.00 $265,000.00 $336,000.00 $420,000.00 $1,021,000.00 2) The accounts receivable as of June 30 is: A/R 6/30 210,000.00 $1,021,000.00 E 9-2 April May June Total Qtr July Sales in units 50,000.00 75,000.00 90,000.00 215,000.00 80,000.00 End. Inv. 7,500.00 9,000.00 8,000.00 8,000.00 Total Needs 57,500.00 84,000.00 98,000.00 223,000.00 Beg. Inv (5,000.00) (7,500.00) (9,000.00) (5,000.00) Production budget (units) 52,500.00 76,500.00 89,000.00 218,000.00 218,000.00 E 9-3 _ Direct Materials 1st Qrt 2nd Qrt 3rd Qrt 4th Qrt Total yr 2 1st Qrt Production budget (bottles) 60,000.00 90,000.00 150,000.00 100,000.00 400,000.00 70,000.00 3 Grams/bottle 3 3 3 3 3 3 180,000.00 270,000.00 450,000.00 300,000.00 1,200,000.00 210,000.00 1000 grams/1 kilogram 1000 1000 1000 1000 1000 1000 Kilograms 180.00 270.00 450.00 300.00 1,200.00 210.00 End. Inventory 54.00 90.00 60.00 42.00 42.00 Total kilograms needed 234.00 360.00 510.00 342.00 1,242.00 Beg. Inv (36.00) (54.00) (90.00) (60.00) (36.00) To purchase, kg 198.00 306.00 420.00 282.00 1,206.00 150 roubles/kg 150 150 150 150 150 Purchase budget. Roubles 29,700.00 45,900.00 63,000.00 42,300.00 180,900.00 E 9-4 _ Direct Labor 1st Qrt 2nd Qrt 3rd Qrt 4th Qrt Total yr Production budget (units) 8,000.00 6,500.00 7,000.00 7,500.00 29,000.00 0.35 dlh/unit 0.35 0.35 0.35 0.35 0.35 Direct Labor Hours 2,800.00 2,275.00 2,450.00 2,625.00 10,150.00 $12/hr $12.00 $12.00 $12.00 $12.00 $12.00 Direct Labor Budget ($) $33,600.00 $27,300.00 $29,400.00 $31,500.00 $121,800.00 2) 1st Qrt 2nd Qrt 3rd Qrt 4th Qrt Total yr Production budget (units) 8,000.00 6,500.00 7,000.00 7,500.00 0.35 dlh/unit 0.35 0.35 0.35 0.35 Direct Labor Hours 2,800.00 2,275.00 2,450.00 2,625.00 $12/hr $12.00 $12.00 $12.00 $12.00 Direct Labor Budget ($) $34,800.00 $31,200.00 $31,200.00 $31,650.00 $128,850.00 E 9-5 _ Moh 1st Qrt 2nd Qrt 3rd Qrt 4th Qrt Total yr MOH rate Production budget (dlh) 8,000.00 8,200.00 8,500.00 7,800.00 32,500.00 Variable oh rate $3.25 $3.25 $3.25 $3.25 $3.25 VOH $26,000.00 $26,650.00 $27,625.00 $25,350.00 $105,625.00 $3.25 FOH $48,000.00 $48,000.00 $48,000.00 $48,000.00 $192,000.00 $5.91 For income statement $74,000.00 $74,650.00 $75,625.00 $73,350.00 $297,625.00 $9.16 Less: non-cash expenses $(16,000.00) $(16,000.00) $(16,000.00) $(16,000.00) $(64,000.00) Cash expenditures $58,000.00 $58,650.00 $59,625.00 $57,350.00 $233,625.00 E 9-6 _ 1st Qrt 2nd Qrt 3rd Qrt 4th Qrt Total yr 15,000.00 16,000.00 14,000.00 13,000.00 58,000.00 Variable oh rate $2.50 $2.50 $2.50 $2.50 $2.50 VOH $37,500.00
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Image of page 2
This is the end of the preview. Sign up to access the rest of the document.

Page1 / 3

Homework _ C9, 10, 11 - E 9-1 Budgeted Sales From Apr Sales...

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online