Expected Sales in Units Unit Sales Price Total Sales

expected sales in units
unit sales price

total sales
From account receivable

1st quarter sales
2nd quarter sales
3rd quarter sales
4th quarter sales
total cash collection
SALES BUDGET
quarter 1
quarter 2
quarter 3
quarter 4
total
1,500
900
1,100
1,300
250,000
250,000
250,000
250,000
375,000,000
225,000,000
275,000,000
4,800
250,000
325,000,000
1,200,000,000
49,500,000
260,000,000
60,000,000
367,500,000
220,500,000
269,500,000
260,000,000
309,500,000
1,177,500,000
schedule expected cash collection

60,000,000
300,000,000
67,500,000
180,000,000
.
360,000,000
40,500,000
220,000,000
.
247,500,000
260,500,000
Production Budget
Planned sales
Desired ending inventory
quarter 1
1,500
90
quarter 2
900
110
quarter 3
1,100
130
quarter 4
1,300
130
Total needs
Less beginning inventory
1,590
100
1,010
90
1,230
110
1,430
130
Units to be produced
1,490
920
1,120
1,300
Total
4,800
130
4,930
100
4,830
quarter 1
Direct Material Budget

quarter
quarter 2
Materials needs per unit
1,490
5
920
5
Materials needs for production

Desired ending inventory
7,450
460
4,600
560
Total needs
Less beginning inventory
7,910
500
5,160
460
7,410
25,000
4,700
25,000
185,250,000
117,500,000
Materials to be purchased
Unit price
Purchase cost
From account payable

1st Quarter Purchases
2nd Quarter Purchases
3rd Quarter Purchases
4th Quarter Purchases
Total cash payment
0
7,410
7,410
7,410
4,700
12,110
Direct Material Budget

quarter
quarter 3
quarter 4
Total
1,120
5
1,300
5
4,830
5
5,600
650
6,500
650
24,150
650
6,250
560
7,150
650
24,800
500
5,690
25,000
6,500
25,000
24,300
25,000
142,250,000
162,500,000
607,500,000
schedule of expected cash payment
4,700
5,690
10,390
5,690
6,500
12,190
0
14,820
9,400
11,380
6,500
42,100
quarter 1
DIRECT LABOR BUDGET

quarter 2
quarter 3
Direct labor hours budget
1,490.00
1.00
920.00
1.00
1,120.00
1.00
Total hours
Direct labor cost per hour
1,490.00
2,000.00
920.00
2,000.00
1,120.00
2,000.00
2,980,000.00
1,840,000.00
2,240,000.00
Total direct labor cost
LABOR BUDGET
quarter 4
Total
1,300.00
1.00
4,830.00
1.00
1,300.00
2,000.00
4,830.00
2,000.00
2,600,000.00
9,660,000.00
quarter 1
FACTORY OVERHEAD BUDGET

quarter 2
quarter 3
Budgeted direct labor hours

Variable overhead rate
1,490.00
18,000.00
920.00
18,000.00
1,120.00
18,000.00
Variable overhead budgeted

Fixed overhead budgeted
26,820,000.00
200,000.00
16,560,000.00
200,000.00
20,160,000.00
200,000.00
Total budgeted overhead

less: depreciation
27,020,000.00
2,500,000.00
16,760,000.00
2,500,000.00
20,360,000.00
2,500,000.00
Cash disbursement for OH
24,520,000.00
14,260,000.00
17,860,000.00
VERHEAD BUDGET
quarter 4
Total
1,300.00
18,000.00
4,830.00
18,000.00
23,400,000.00
200,000.00
86,940,000.00
800,000.00
23,600,000.00
2,500,000.00
87,740,000.00
10,000,000.00
21,100,000.00
77,740,000.00
ENDING INVENTORY BUDGET
Direct materials
Finished goods
Ending inventory
quantity unit cost
total
650
25,000
16,250,000
130
163,000
21,190,000
unit
Direct materials
Direct labors
Variable overhead
Total variable manufacturing cost
5
1
2
unit cost
total
25,000
2,000
18,000
125,000
2,000
36,000
163,000
Selling and Administrative Budget
Expected Sales in Units

Var. selling and adm. Per unit
Budget variable expense
Fixed selling and adm. Exp :
advertising expense
office salaries
rent
insurance
taxes
Total fixed salling and adm. Exp
Total Butged S & A Exp
Quarter 1 Quarter 2 Quarter 3

1,500
900
1,100
30,000
30,000
30,000
45,000,000 27,000,000 33,000,000
7,000,000 7,000,000 7,000,000
20,000,000 20,000,000 20,000,000
5,000,000 5,000,000 5,000,000
10,000,000
8,000,000
42,000,000 40,000,000 32,000,000
87,000,000 67,000,000 65,000,000
dministrative Budget
Quarter 4
1,300
30,000
39,000,000
Total
4,800
30,000
144,000,000
7,000,000
20,000,000
5,000,000
28,000,000
80,000,000
20,000,000
10,000,000
8,000,000
146,000,000
290,000,000
32,000,000
71,000,000
Cash Budget
Cash balace beginning

add : Receipts
collection from custom
Total cash avalaible
Less : Disbursement :
Direct Materials
Direct Labors
Factory Overhead
Selling and Adm
Machinary purchase
Income tax payble
Total cash Disbursement
Cash surplus (deficit)
Financing:
Borrowing
Repayment
Interest
Total financing
Cash balance, ending
Sales
Less variable expenses
Cost of Good Sold
S & A exp
Contibution Margin
Less fixed expenses
Factory overhead
S & A exp
Net operating income
Less interest expense
Net income before tax
Less income tax (25%)
Net income
Quarter 1
Quarter 2
100,000,000
94,492,590
144,000,000
244,000,000
69,300,000
163,792,590
7,410
2,980,000
24,520,000
87,000,000
30,000,000
5,000,000
149,507,410
12,110
1,840,000
14,260,000
67,000,000
94,492,590
80,680,480
94,492,590
80,680,480
83,112,110
782,000,000
144,000,000
800,000
146,000,000
Quarter 3
Quarter 4
Total
80,680,480
68,510,090
100,000,000
72,940,000
153,620,480
86,660,000
155,170,090
372,900,000
472,900,000
10,390
2,240,000
17,860,000
65,000,000
12,190
2,600,000
21,100,000
71,000,000
85,110,390
94,712,190
376,842,100
68,510,090
60,457,900
60,457,900
68,510,090
60,457,900
60,457,900
Income Statement
1,200,000,000
926,000,000
274,000,000
146,800,000
127,200,000
127,200,000
31,800,000
95,400,000
42,100
9,660,000
77,140,000
290,000,000
BALANCE SHEET
Asset
Current assets
cash
acc.receivable
inventory: material
inventory: finished goods
Total current assets
60,457,900
60,000,000
16,250,000
21,190,000
157,897,900
Liabilities and Stockholder's Equity

Current Liabilities
accounts payable
income tax payable
Total current liabilities
Fixed assets
building
equipment
acc.depreciation
Total fixed assets
20,000,000
30,000,000
(10,000,000)
40,000,000
Stockholder's equity
preferred stock
common stock
retained earnings
Total S.E
Total assets
197,897,900
Total L & S.E
nd Stockholder's Equity
accounts payable
income tax payable
Total current liabilities
preferred stock
common stock
retained earnings
5,000,000
5,000,000
29,249,370
68,248,530
95,400,000
192,897,900
197,897,900

Expected Sales in Units Unit Sales Price Total Sales

Uploaded by

Copyright:

Available Formats

Expected Sales in Units Unit Sales Price Total Sales

Uploaded by

Document Information

Original Title

Copyright

Available Formats

Share this document

Share or Embed Document

Sharing Options

Did you find this document useful?

Is this content inappropriate?

Copyright:

Available Formats

Expected Sales in Units Unit Sales Price Total Sales

Uploaded by

Copyright:

Available Formats

expected sales in units

unit sales price

From account receivable

schedule expected cash collection

Direct Material Budget

Materials needs for production

From account payable

Direct Material Budget

schedule of expected cash payment

DIRECT LABOR BUDGET

Total direct labor cost

FACTORY OVERHEAD BUDGET

Budgeted direct labor hours

Variable overhead budgeted

Total budgeted overhead

Cash disbursement for OH

ENDING INVENTORY BUDGET

Selling and Administrative Budget

Expected Sales in Units

Quarter 1 Quarter 2 Quarter 3

Cash balace beginning

Liabilities and Stockholder's Equity

Total L & S.E

You might also like