Chapter 6 - Budgeting worksheets

Chapter 6 - Budgeting worksheets - Chapter 6 - Exercise 14...

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

View Full Document Right Arrow Icon
Chapter 6 - Exercise 14 - Cash collections budget January February February May June July Budgeted Sales in units 33,000 50,000 59,000 65,000 70,000 55,000 Budgeted Sales in dollars $99,000 $150,000 $177,000 $195,000 $210,000 $165,000 Desired ending inventory of finished goods is 25% of the next months sales. All sales are on credit. 30% of sales are collected in the month of the sale. 50% of sales are collected in the month after the sale. 20 % of sales are collected in the second month after the sale PRODUCTION BUDGET Budgeted sales in units 59,000 65,000 70,000 + Ending inventory 14,750 16,250 17,500 13,750 Total Needed 75,250 82,500 83,750 - Beginning inventory (14,750) (16,250) (17,500) Units to be produced 60,500 66,250 66,250 CASH COLLECTIONS SCHEDULE Month of Cash Collection Sales $ April May June February 99,000 $19,800 $- $- March 150,000 75,000 30,000 - April 177,000 53,100 88,500 35,400 May 195,000 - 58,500 97,500 June 210,000 - - 63,000
Background image of page 1

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

View Full DocumentRight Arrow Icon
$000's J-10 F-10 M-10 A-10 M-10 J-10 J-10 A-10 S-10 O-10 N-10 D-10 J-11 F-11 Rev 54 66 66 84 90 90 96 96 144 132 108 72 60 65 VC 30 36 36 46 50 50 53 53 79 73 59 40 33 36 CM 24 30 30 38 41 41 43 43 65 59 49 32 27 29 FC 15 15 15 15 15 15 15 15 15 15 15 15 17 18 NI 9 15 15 23 26 26 28 28 50 44 34 17 10 11
Background image of page 2
Basic Black Ltd. Cutting Department Budget for November Production Level in units 4,000 units 3,500 4,000 4,500 Nov Per Unit Per Mth Direct material $8,000 $2.00 $- $7,000 $8,000 $9,000 Direct labour 9,200 2.30 - 8,050 9,200 10,350 Manufacturing Overhead Indirect material 1,000 0.10 $600 950 1,000 1,050 Indirect labour 800 0.20 - 700 800 900 Utilities 400 0.05 200 375 400 425 Depreciation 6,400 - 6,400 6,400 6,400 6,400 $23,475 $25,800 $28,125 $600 of the indirect labour is fixed, as is $200 of the utilities and 6,400 of the depreciation. These items occur on a monthly basis. Mixed Costs: Total Cost - Fixed Portion Units of Production Indirect material ($1000 - $600) / 4000 units Utilities ($400 - $200) / 4000 units
Background image of page 3

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

View Full DocumentRight Arrow Icon
BASIC BLACK LIMITED BASIC BLACK LIMITED FLEXIBLE BUDGET Units CUTTING DEPARTMENT - NOV 2009 Per Unit 3,500 4,000 4,500 Direct material $2.00 $7,000 $8,000 $9,000
Background image of page 4
Image of page 5
This is the end of the preview. Sign up to access the rest of the document.

Page1 / 8

Chapter 6 - Budgeting worksheets - Chapter 6 - Exercise 14...

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

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