Budgeting

McGraw-Hill/Irwin © 2003 The McGraw-Hill Companies, Inc., All Rights Reserved.

15-2

Every enterprise has a set of goals

Profitability

Growth

PublicService

StrategicPlanning

Achieving and Maintaining

a Competitive Advantage

CRITICAL SUCCESS FACTORS

The key strengths that are most responsible

for making the organization successful

Strategic Planning

15-3

•Express the specific steps required to achieve the organization’s goals.

•Discuss the major capital investments required to:

MaintainPresent

Facilities

IncreaseCapacity

DiversifyProducts orProcesses

DevelopParticularMarkets

Strategic Long-Range Plans

15-4

A detailed plan, expressed in quantitative term, that specifies how an organization will acquire and use

resources during a particular period of time.

What is a budget?

What is a budgeting system?

The procedures used to develop a budget

What Are The Key Purposes Of Budgeting Systems?

15-5

Managing Financial & Operating Performance

Facilitating Communication

and Coordination

Evaluating Performance &

Providing IncentivesPlanning

AllocatingResources

What Are The Key Purposes Of Budgeting Systems?

15-6

MASTER BUDGET A comprehensive set of budgets covering all phases of the

organization’s operations for a period of time

PRO FORMA FINANCIAL STATEMENTS Show how the organization’s financial statements will appear at a

specified time if operations proceed according to plan

CAPITAL BUDGETA plan for the acquisition of capital asset

FINANCIAL BUDGET Shows how the organization will acquire its financial resources

ROLLING BUDGET Continually updated by periodically adding a new incremental time period, such as a quarter, and dropping the period just completed

Organizations Use Many Types Of Budgets

15-7

Sales Budget

Production Budget

Direct Material Budget

Budgeted schedulecost of goods

manufactured and sold

Capital Budget Budgeted balanceStatement

Direct Labor Budget

Mft. Overhead Budget

Cash budget

Budgeted incomeStatement

Budgeted Statement of Cash Flows

Sales Budget

Selling, Generaland Administrative

Budget

R&D Budget

Marketing Budget

Customer Service Budget

Operational Budget

Exh.15-1

Master Budget Components

15-8

Among the major factors considered when forecasting sales are:

Sales forecasting is the process of predicting sales of goods and services.

Sales Forecasting

1. Past sales levels and trends2. General economic trends3. Economic trends in the

company’s industry4. Other factors expected to

affect sales in the industry5. Political and legal events6. The intended pricing policy of

the company

7. Planned advertising and product promotion

8. Expected action of competitors

9. New products contemplated by the company or other firms

10. Market research studies

15-9

The sales level of the prior year

Sales staff

Market researchers

Delphi technique

Econometric models

StartingPoint

Sales Forecasting

15-10

OPERATIONAL BUDGETSSpecify how the company’s

operations will be carried out to meet the demand.

Prepared from the

sales budget

MANUFACTURINGProduction Budget

shows the number of product units to be

manufactured

MERCHANDISINGMerchandise

Purchases Budget used instead of a

production budget

SERVICE INDUSTRYSet of budgets that shows how

the firm will meet the demand for its

services

Operational Budgets: Meeting Demand For Goods & Services

15-11

OPERATIONAL BUDGETSSpecify how the company’s operations will be carried

out to meet the demand for its goods or services

CashBudget

Shows expected cash receipts from selling goods and services,

anddisbursements to pay

bills

CapitalBudget

Details plans formajor acquisitionsand disposals of

assets

Operationalbudgets

encompass a plan for using

the basic factors of production

(material, labor, and overhead)

to produce a product or

provide a service

Operational Budgets: Meeting Demand For Goods & Services

15-12

The sales budget displays the projected sales in units and the projected sales return

1st 2nd 3rd 4th YearSales in Units 15,000 5,000 10,000 20,000 50,000Unit sales price X $12 X $12 X $12 X $12 X $12Total sales revenue $180,000 $60,000 $120,000 $240,000 $600,000

Seasonal Pattern in Sales

Sales Budget

15-13

10% of next quarter’sexpected sales

10% of first quarter of nextyear’s expected sales of 15,000

Production Budget

Total units required - Expected beginning finished goods inventory = Units to be produced

Sales in units + Desired ending finished goods inventory = Total units required

15-14

Raw materials required for production +

Desired ending inventory = Total

raw material required

Shows the number of units and the cost of material to be purchased and used Total raw material

required - Expected beginning

inventory of raw material = Raw material to be

purchased

Direct Material Budget

15-15

Shows the number of hours and the cost of direct labor to be used during the budget period

For either strategic business reasons or ethical concerns, many companies try to maintain a relatively stable labor force. If production

employees are retained when production declines, the labor force will not be a unit-level cost.

Direct-Labor Budget

15-16

Shows the cost of overhead expected to be incurred in the production process during the budget period

Indirect material Electricity for machinery

Setup Purchasing & material handling

Inspection

Supervisory salariesInsurance and property

taxes MaintenanceUtilities Depreciation

Design

Manufacturing Overhead Budget

15-17

1st 2nd 3rd 4th YearUnit-level expenses $14,000 $5,500 $11,000 $19,500 $50,000Customer-level expenses $1,500 $1,500 $1,500 $1,500 $6,000Facility and general operations-level expenses $4,750 $4,750 $4,750 $4,750 $19,000Total expenses $20,250 $11,750 $17,250 $25,750 $75,000

Shows the planned amounts of expenditures for selling, general, and administrative expenses during a budget period

Sales commissionsFreight-out

Licensing fees for use ofuniversities’ names and logos

Sales salaries, Advertising,& Clerical wages

Selling, General, & Administration (SG&A) Expense Budget

15-18

Details the expected cash collections during a budget period

80% of revenue

18% x $240,000 (prior quarter’s revenue)

Cash Receipts Budget

15-19

2nd quarter

X 80%

$48,000

$32,400

$80,400

X 18%

$180,000 $60,000

1st quarter

Total cash receipts($48,000 + $32,400)

Collections in quarterfollowing sale (18% of

sales)

Collections in quarter of sale (80% of sales)

Total revenue

Uncollectible accounts2% X $60,000 = $1,200

Budgeting Cash Receipts

15-20

Details the expected cash payments during a budget period

1st 2nd 3rd 4th YearCost of raw material purchases $39,450 $18,150 $35,550 $56,850 $150,000

Cash payments for purchases made during the quarter $23,670 $10,890 $21,330 $34,110 $90,000Cash payments for prior quarter's purchases 22,740 15,780 7,260 14,220 60,000

Total cash payments for direct material purchases $46,410 $26,670 $28,590 $48,330 $150,000

Other cash disbursements $84,750 $50,750 $72,750 $106,750 $315,000Total cash disbursements $131,160 $77,420 $101,340 $155,080 $465,000

60% of current

quarter’spurchases

40% of prior

quarter’spurchases

Cash Disbursements Budget

15-21

2nd quarter

X 60%

$10,890

$15,780

$26,670

X 40%

$39,450 $18,150

1st quarter

Total($10,890 + $15,780)

Payments made during the quarter following

(40% of purchases)

Payments made during the same quarter as purchases (60% of

sales)

Total purchaseon account

Budgeting Cash Disbursements

15-22

1st 2nd 3rd 4th YearCash receipts $187,200 $80,400 $106,800 $213,600 $588,000Less cash disbursements (131,160) (77,420) (101,340) (155,080) (465,000)

Change in cash balance during quarter due to operations $56,040 $2,980 $5,460 $58,520 $123,000Proceeds from bank loan 100,000 100,000Payments for construction of plant addition (45,000) (15,000) (5,000) (35,000) (100,000)Repayment of principal on bank loan (25,000) (25,000) (25,000) (25,000) (100,000)Interest on bank loan (2,500) (1,875) (1,250) (625) (6,250)Change in cash balance during the period $83,540 ($38,895) ($25,790) ($2,105) $16,750Cash balance, beginning of period 10,000 93,540 54,645 28,855 10,000Cash balance, end of period $93,540 $54,645 $28,855 $26,750 $26,750

A short- term loan was taken

out on Jan. 2, 20x1

The loan was used for construction

Details the expected cash receipts and disbursements

Unpaidprincipalx 10%

Cash Budget: Combining Receipts And Disbursements

15-23

Details the direct material, direct labor, and manufacturing overheadcosts to be incurred and the cost of the goods to be sold

Direct material Raw material inventory, January 1 $4,200 Add: Purchases of raw material 150,000 Raw material available for use $154,200 Deduct: Raw-material, December 31 4,200 Direct material used $150,000Direct labor 100,000Manufacturing overhead 200,000Subtotal $450,000Add: Work-in-process inventory, Jan. 1 0Subtotal 450,000Deduct: Work-in-process inventory, Dec. 31 0Cost of goods manufactured 450,000Add: Finished goods inventory, Jan. 1 13,500Cost of goods available for sale $463,500Deduct: Finished goods inventory, Dec. 31 13,500Cost of goods sold $450,000

1,500 unitsx $9

absorptionmanufacturing

cost(direct material

= $3, direct labor = $2, andoverhead = $4)

Budgeted Schedule Of Cost Of Goods Manufactured & Sold

15-24

Shows the expected revenue and expenses for the budget period

Sales revenue $600,000Less: Cost of goods sold 450,000

Gross margin $150,000

Other expenses:Selling, general and administrative expenses $75,000Uncollectible accounts expense 12,000Interest expense 6,250

Total other expenses 93,250

Net income $56,750

$600,000x 2%

Budgeted Income Statement

15-25

Shows the expected end of period balances

for the company’s

assets, liabilities, and owner’s equity

Budgeted Balance Sheet

15-26

Shows the expected end of period balances for the company’s assets, liabilities, and owner’s equity

Current liabilitiesAccounts payable $22,740

Total current liabilities $22,740Long-term liabilitiesNote payable 200,000Total liabilities 222,740Owner's equity 386,910Total liabilities and owner's equity $609,650

Budgeted Balance Sheet

15-27

Designate a BUDGET

DIRECTOR (usually the

controller) who specifies the

process by which budget data will

be gathered, collects the

information, and prepares the

master budget

The BUDGET DIRECTOR develops

& disseminates a BUDGET MANUAL indicating who is responsible for

providing various types of budget

information, when the information is required, and what

form the information is to take

A BUDGET COMMITTEE,

consisting of key senior executives,often is appointed

to advise the budget director

during the preparation of the

budget

Responsibility For Budget Administration