File_latihan_budgeting.xlsx

THE PUTNAM COMPANY Sales Budget For The Year Ended December 31, 20X2 Quarter 1 Expected sales in units Unit sales price Total sales

$

2

-

$

3

-

$

Years as a whole

4

-

$

-

$

-

-

$ $ $ $ $ $

-

Schedule of Expected Cash Collections Accounts receivable 1st quarter sales 2nd quarter sales 3d quarter sales 4d quarter sales Total Cash Collections

$

$

-

-

$ $

$

-

-

$ $

-

$

-

$ $ $

THE PUTNAM COMPANY Production Budget For The Year Ended December 31, 20X2 Quarter 1 Planned sales (S1) Desired ending inventory Total needs Less: Beginning Inventory Unit to be produced

2 0 0 0 0

3 0 0 0 0 0

4 0 0 0 0 0

Years as a whole 0 0 0 0 0 0 0 0 0

THE PUTNAM COMPANY Direct Material Budget For The Year Ended December 31, 20X2 Quarter 1 Unit to be Produced (S2) Material needs per unit (lbs) Production needs (usage) Desired ending inventory of materials Total needs Less: beginning inv. of materials Material to be purchased Unit price Purchase cost

2

3

0 2 0 0 0

0 2 0 0 0 0 0

0 $

-

4

$ $

-

0 2 0 0 0 0 0 $ $

-

$ $

Years as a whole 0 0 2 2 0 0 0 0 0 0 0 0 0 - $ - $ -

Schedule of Expected Cash Disbursements Account payable 1st quarter purchases 2nd quarter purchases 3rd quarter purchases 4th quarter purchases

$

$

-

-

$ $

$

-

-

$ $

-

$

-

$ $ $

-

$ $ $ $ $ $

-

THE PUTNAM COMPANY Direct Labor Budget For The Year Ended December 31, 20X2 Quarter 1 Unit to be produced (S2) Direct labor hours per unit Total hours Direct labor cost per hours Total direct labor cost

2

3

0

0 0 0

0 $

-

$ $

-

Years as a whole

4 0 0 0

$ $

-

0 0 0 $ $

-

0 0 0 $ $

-

THE PUTNAM COMPANY Factory Overhead Budget For The Year Ended December 31, 20X2 Quarter 1 Budgeted direct labor hours (S4) Variable overhead rate Variable overhead budgeted Fix overhead budgeted Total budgeted overhead Less: depreciation Cash disbursements for factory overhead

2 0 2 0 0 $0

3 0 2 0 0 0 0 $0

Years as a whole

4 0 2 0 0 0 0 $0

0 2 0 0 0 0 $0

0 2 0 0 0 0 $0

THE PUTNAM COMPANY Ending Finished Goods Inventory Budget For The Year Ended December 31, 20X2 Ending Inventory Units

Unit Product Cost $ 82

0

Direct materials Direct labor Factory overhead Unit product cost

Predetermined factory overhead applied rate

Unit cost $ 5 $ 10 #DIV/0!

#DIV/0!

Units 2 5 5

Total $

Total

$ $

10 50 #DIV/0! #DIV/0!

THE PUTNAM COMPANY Selling and Administrative Expense Budget For The Year Ended December 31, 20X2 Quarter 1 Expected sales in unit Variable selling and administratice expense per unit Budgeted variable expense $ Fix selling and administrative expense a. Advertising b. Insurance c. Office Salaries d. Taxes Total Budgeted selling and administrative expense $

2

3

0

-

-

Years as a whole

4

0

0

0

0

$

-

$

-

$

-

$

-

$

-

$

-

$

-

$

-

$

-

$

-

$

-

$

-

$

-

$

-

$ $ $ $

-

$

-

$

-

$

-

$

-

THE PUTNAM COMPANY Cash Budget For The Year Ended December 31, 20X2 Quarter

From Schedule Cash Balance beginning Add: Receipt: Collection from customers Total cash available (a) Less: Disbursements: Direct materials Direct labor Factory overhead Selling and admin Equipment purchase Dividends Income tax Total disbursements (b) Minimum cash balance Total cash needed © Cash surplues (deficit) (a-c) Financing: Borrowing Repayment Interest Total effect of financing (d) Cash balance (a-b+d)

1

2

1

3 4 5 7 Given Given 9

3

4

$

-

$ $

-

$ $

-

$ $

-

$ $ $ $

-

$ $ $ $

-

$ $ $ $ $ $

-

$ $ $ $ $ $ $ $ $ $ $

-

$ $ $ $ $ $ $ $ $ $ $

-

$

-

$

-

$ $

-

$ $

-

$

-

$ $

-

$ $ $ $

-

$ $ $ $

-

Years as a whole $ $ $

-

$ $ $ $ $ $ $ $ $ $ $

-

$ $ $ $ $

-

THE PUTNAM COMPANY Budgeted Income Statement For The Year Ended December 31, 20X2

Sales (6.000 unit @ $150) Less: Cost of goods sold Beginning Finished goods inventory Add: Cost of goods manufactured (6.100 units @ $82) Cost of goods available for sale Less: Ending finished goods inventory Gross margin Less: Selling and administrative expense Operating income Less: interest expense Net income before taxes Less: Income taxes Net income after taxes

From Schedule 1

$

-

$ $

-

7

$

-

8

$ $ $

-

$

-

10 6 6

$ $

-

THE PUTNAM COMPANY Balance Sheet For the Year Ended December 31, 20X1 Assets Current Asset Cash Accounts Receivable Material Inventory (490 lbs) Finished goods inventory (200 units) Total current assets Plan and equipment Land Buildings and equipment Accumulated depreciation Plan and equipment, net Total assets

$ $ $ $

$ $ $

19,000 100,000 2,450 16,400 $

137,850

$ $

206,000 343,850

$

66,275

$ $

277,575 343,850

30,000 250,000 -74,000

Liabilities and Stockholders Equity Current liabilities Account payable (raw materials) Income tax payable Total current liabilities Stockholder's equity Common stock, no par Retained eranings Total stockholder's equity Total liabilities and stockholders equity

$ $

$ $

6,275 60,000

200,000 77,575

THE PUTNAM COMPANY Balance Sheet December 31, 20X2 Assets Current Asset Cash Accounts Receivable Material Inventory (520 lbs) Finished goods inventory (300 units) Total current assets Plan and equipment Land Buildings and equipment Accumulated depreciation Plan and equipment, net Total assets

$ $ $ $

$ $ $

100,000 $

100,000

$ $

206,000 306,000

30,000 250,000 -74,000

Liabilities and Stockholders Equity Current liabilities Account payable (raw materials) $ Income tax payable $ Total current liabilities Stockholder's equity Common stock, no par $ 200,000 Retained eranings $ 77,575 Total stockholder's equity Total liabilities and stockholders equity

$

$ $

-

277,575 277,575

Current ratio: [Current assets/Current liabilities] Return on Total Assets: [Net income after taxes/Total assets]

20X1

20X2

2.08

#DIV/0!

13.09%

0.00%