ACIS 2116 Chapter 10 Master Budget Example

ACIS 2116 Chapter 10 Master Budget Example - Budgeted sales...

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

View Full Document Right Arrow Icon
Sales Budget January February March April May Quarter Budgeted sales in units 30,000 60,000 40,000 35,000 25,000 130,000 Selling price per unit $20 $20 $20 $20 $20 $20 Total budgeted sales $600,000 $1,200,000 $800,000 $700,000 $500,000 $2,600,000 Cash Receipts Budget January February March Quarter Accounts Receivable 12/31 $40,000 $40,000 January Sales 75% x $600,000 $450,000 $450,000 20% x $600,000 $120,000 $120,000 February Sales 75% x $1,200,000 $900,000 $900,000 20% x $1,200,000 $240,000 $240,000 March Sales 75% x $800,000 $- $- $600,000 $600,000 Total Cash Collections $490,000 $1,020,000 $840,000 $2,350,000 Production Budget January February March April Quarter Budgeted Sales 30,000 60,000 40,000 35,000 130,000 Add: Desired ending inventory 6,000 4,000 3,500 2,500 3,500 Total Needs 36,000 64,000 43,500 37,500 133,500 Less: Beginning inventory 5,000 6,000 4,000 3,500 5,000 Required Production 31,000 58,000 39,500 34,000 128,500 Material Purchases Budget January February March Quarter Production 31,000 58,000 39,500 128,500 Materials per unit (yards) 2 2 2 2 Production needs 62,000 116,000 79,000 257,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
Image of page 2
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 09/25/2009 for the course ACIS 2116 taught by Professor Cmeasterwood during the Spring '08 term at Virginia Tech.

Page1 / 3

ACIS 2116 Chapter 10 Master Budget Example - Budgeted 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