Master Budget Cost Accounting by afb95708

VIEWS: 0 PAGES: 5

More Info
									The Master Budget - worksheet - Chapter 9 - Accounting 230                                page 1

The Sales Budget:                              April                May            June   Quarter

Budgeted Sales (units)

SP/unit

Total Sales

The Production Budget:                         April                May            June   Quarter

Budgeted Sales (units)

Add: desired ending Inventory

Total needed

Less: Beg. Inventory

Required Production

Expected Cash Collections                      April                May            June   Quarter

Accounts Receivable 3/31

April Sales:




May Sales:




June Sales:




Total Cash collections:

The Direct Materials Budget:                   April                May            June   Quarter

Production (units)

Materials per unit

Production Needs

Add: desired ending Inventory

Total needed

Less: Beg. Inventory

Materials to be purchased


Accounting 230/jpaquette/ac0bfe05-3166-4fe8-958d-2978ec56489b.xls    Page 1 of 5                    5/5/2011/jpaquette
The Master Budget - worksheet - Chapter 9 - Accounting 230                               page 2

Expected Cast Disbursements                        April               May        June   Quarter

Accounts Payable 3/31

April Purchases:




May Purchases:




June Purchases:




Total Cash disbursements:

The Direct Labor Budget                            April               May        June   Quarter

Production (units)

Direct labor hours

Labor hours required

Guaranteed labor hours:

Labor hours paid

Wage rate

Total direct labor cost

Manufacturing Overhead Budget                      April               May        June   Quarter

Production (units)

Variable mfg OH rate

Variable mfg OH costs

Total mfg OH costs

Less: noncash costs

Cash disbursements for mfg. OH




Accounting 230/jpaquette/ac0bfe05-3166-4fe8-958d-2978ec56489b.xls   Page 2 of 5                    5/5/2011/jpaquette
The Master Budget - worksheet - Chapter 9 - Accounting 230                               page 3

Ending Finished Goods
Inventory Budget                                Quantity             Costs               Total

Production costs per unit:

  Direct Materials

  Direct Labor

  Manufacturing OH
Budgeted finished goods
inventory

  Ending inventory in units

  Unit product cost

  Ending finished goods inventory


Selling & Administration Budget April                                May          June   Quarter

Budgeted Sales (units)

Variable S&A rate per unit

Variable Expense

Fixed S&A Expense

Total Expense

Less: Non Cash Expenses

Cash Disbursements for S&A




Accounting 230/jpaquette/ac0bfe05-3166-4fe8-958d-2978ec56489b.xls   Page 3 of 5                    5/5/2011/jpaquette
                                                                                         page 4

The CASH Budget                                 April               May           June   Quarter

Beginning cash balance

Add: cash collections

Total available:

Less: Disbursements

  Materials

  Direct labor

  Mfg. Overhead

  S&A

  Equipment purchase

  Dividends

Total disbursements
Excess (deficiency) of cash
available over disbursements


Financing:

  Borrowing

  Repayments

  Interest

Total Financing

Ending cash balance:




Accounting 230/jpaquette/ac0bfe05-3166-4fe8-958d-2978ec56489b.xls   Page 4 of 5                    5/5/2011/jpaquette
The Master Budget - worksheet - Chapter 9 - Accounting 230                        page 5
The Budgeted Income Statement & Balance Sheet


______________________________________________________
______________________________________________________
______________________________________________________

Sales (100,000 @$10)                                                              $        1,000,000


Cost of goods sold

Gross margin

Selling & Administrative expenses

Operating Income

Interest expense

Net Income




______________________________________________________
______________________________________________________
______________________________________________________


Current Assets:

  Cash                                                                            $           43,000

  Accounts Receivable

  Raw materials inventory

  Finish Goods inventory

  Total current assets

Property and equipment

  Land

  Building

  Equipment

  Total property and equipment

Total Assets

Accounts Payable

Common stock

Retained earnings

Total Liabilities and Stockholders' Equity
Accounting 230/jpaquette/ac0bfe05-3166-4fe8-958d-2978ec56489b.xls   Page 5 of 5             5/5/2011/jpaquette

								
To top