Cash Budget
Cash Budget
Cash Budget
SCHEDULE 14:
Variable overhead: units neede to produce 6,500.00
Accounts payable (2011) 7,147,000.00 Indirect Materials and supplies (@P5.85) 38,000.00
LESS: Accounts payable(2010) 3,795,500.00 Materials handling (@P9.07) 5,900.00
Increase in accounts payable 3,351,500.00 Other indirect labor (@P5.07) 33,000.00
TOTAL 13,000.00
Fixed manufacturing overhead
SCHEDULE 15:
Supervisor labor 175,000.00
Accrued liabilities (2011) 2,834,500.00 Maintenance and repairs 85,000.00
LESS: Accrued liabilities (2010) 2,656,500.00 Plant Administration 173,000.00
Increase in accrued liabilities 178,000.00 Utilities 87,000.00
Depreciation 280,000.00
Insurance 43,000.00
Property taxes 117,000.00
Others 54,000.00
TOTAL 1,001,000.00
TOTAL MANUFACTURING OVERHEAD 1,131,000.00
EBC Enterprise SCHEDULE 1:
Statement of Cash Flows Accounts Receivable (net) 2010 4,383,500.00
ADD: Net Sales (2011) 107,800,000.00
2011 LESS: Accounts Receivable (net) 2011 4,704,000.00
Cash Flow from the Operating Activities - Direct Method Cash received from the customers 107,479,500.00
Cash received from the customers (1) 107,495,000.00
Interest received 211,000.00 SCHEDULE 2:
Cash paid to suppliers for inventory (cash disbursement - MINUS) (2) -66,466,500.00 Accounts payable (2010) 3,795,500.00
ADD: Purchases
Cash paid to employees (S&A expense) 16,332,000.00 Cost of goods sold (COGS) (2011) 64,682,000.00
Cash paid for other operating expenses (cash disbursement - MINUS) (3) -14,864,000.00 ADD: Inventories (2011) 23,520,500.00
Interest paid 1,292,500.00 LESS: Inventories (2010) 18,384,500.00 69,818,000.00
Taxes paid (cash disbursement- MINUS) (4) -3,739,000.00 LESS: Accounts Payable (2011) 7,147,000.00
Net cash provided (used) by operating activities 5,012,000.00 Cash paid to suppliers for inventory 66,466,500.00
SCHEDULE 3:
Cash Flow from Investing Activities Advertising Expense 7,129,000.00
Purchase of property, plant and equipment (5) -7,050,000.00 Lease payments 6,529,000.00
Other investing activities (sale of other noncurrent asset) (ADD) (6) 147,500.00 Repairs and maintenance 1,507,000.00
Net cash provided (used) by investing activities -6,902,500.00 ADD: Accrued liabilities (2010) 2,656,500.00
LESS: Accrued liabilities (2011) 2,834,500.00
ADD: Prepaid expenses (2011) 256,000.00
LESS: Pepraid expenses (2010) 379,500.00
Cash flow from Financing Activities
Cash paid for other operating expenses 14,863,500.00
Sales of ordinary shares (cash receipt) (7) 128,000.00
Increase (decrease) in short-term borrowing (8) -15,000.00
SCHEDULE 4:
(includes current maturities of long term debt)
Deferred income tax (2010) 317,500.00
Additions to long-term borrowings (cash receipt) (9) 2,042,000.00 ADD: Income tax (2011) 3,843,000.00
Dividends paid -791,000.00
LESS: Deferred income tax (2011) 421,500.00
Net cash provided (used) by financing activities 1,364,000.00
Taxes Paid 3,739,000.00
Decrease in cash & market securities -526,500.00
Cash & Market securities balace, 2010 5,193,000.00
SCHEDULE 5:
Cash & Market securities balace, 2011 4,666,500.00
PPE (net) 2011 20,303,500.00
LESS: PPE (net) 2010 13,253,500.00
Cash flow from Operating activities- Indirect Method Increase in PPE 7,050,000.00
Net income 4,697,500.00
Noncash revenue and expense included in net income: SCHEDULE 6:
Depreciation 1,999,000.00 Other noncurrent assets (2011) 186,500.00
Deferred income taxes (10) 104,000.00 LESS: Other noncurrrent assets (2010) 334,000.00
Cash provided (used) by current assets and liabilities Decrease in other noncurrent assets -147,500.00
Accounts receivables increase -305,000.00
Inventories increase -5,136,000.00 SCHEDULE 7:
Prepaid expenses (decrease) 123,500.00 Ordinary shares (2011) 2,401,500.00
Accounts payable increase 3,351,500.00 LESS: Oridnary shares (2010) 2,297,000.00
Accrued liabilities increase 178,000.00 ADD: Share premium (2011) 478,500.00
Net cash provided (used) by operations 5,012,000.00 LESS: Share premium (2010) 455,000.00
Increase in sale of ordinary share 128,000.00
Total marekting and administrative costs 1,500,000.00
SCHEDULE 8:
Budgeted Statement of Cost of Sales Gilbert Manufacturing Company
Cash Budget
Beginning work in process inventory
Manufacturing costs For the Budget Year Ending December 31, 2011
Direct Materials
Beginning inventory Cash balance, January 1 150,000.00
(2200 R @ P10) + (4000 S @P30) 142,000.00
ADD: Estimated Receipts
Purchases (Schedule 3) 1,179,000.00
Total 1,321,000.00 Collections from customers 5,185,000.00
LESS: Ending Inventory Sales of Assets 25,000.00
(1,300 R @ P10) +(4,600 S @P30) 151,000.00 Total 5,210,000.00
Total direct materials cost 1,170,000.00
Total Cash Available 5,360,000.00
Direct Labor cost (6,500 @P146) 949,000.00
Manufacturing overhead (Schedule 5) 1,131,000.00 LESS: Estimated disbursements
Total manufacturing cost 3,250,000.00 Payments for Material Purchases 1,164,000.00
LESS: Ending work in process inventory - Direct Labor 949,000.00
Cost of goods manufactured 3,250,000.00
Manufacturing overhead 851,000.00
ADD: Beginning finished goods inventory
(900 @ P500) 450,000.00 Marketing & Administrative Expense 1,458,000.00
Total available for sale 3,700,000.00 Payments for Income Tax 252,000.00
LESS: Ending finished good inventory Dividends 140,000.00
(1,00 @ P500) 500,000.00
Reduction in long-term debt 83,000.00
COST OF SALES 3,200,000.00
Acquisition of New Assets 320,000.00
SCHEDULE 7: Total disbursements 5,217,000.00
Budgeted Marketing and Administrative Costs Cash balance, December 31 143,000.00
SCHEDULE 8:
Gilbert Manufacturing Company
Cash Budget
For the Budget Year Ending December 31, 2011
Unadjusted Trial Balance Adjustments Adjusted Trial Balance Income Statement Statement of Fin'l Position
Debit Credit Debit Credit Debit Credit Debit Credit Debit Credit
Cash 72,000 72,000 72,000
Accounts receivable 136,000 136,000 136,000
Office supplies 42,000 1) 17,000 25,000 25,000
Merchandise inventory 598,000 598,000 598,000 723,000 723,000
Prepaid advertising 75,000 2) 25,000 50,000 50,000
Land 400,000 400,000 400,000
Office building 1,600,000 1,600,000 1,600,000
Accum depreciation-OB 100,000 4) 15,000 115,000 115,000
Office equipment 570,000 570,000 570,000
Accum depreciation-OE 150,000 4) 20,000 170,000 170,000
Accounts payable 74,000 74,000 74,000
Notes payable, due in 2 yrs 200,000 200,000 200,000
Mortgage payable 1,100,000 1,100,000 1,100,000
Sousa, capital 1,510,000 1,510,000 1,510,000
Sousa, withdrawals 200,000 200,000 200,000
Sales 4,600,000 4,600,000 4,600,000
Sales discounts 161,000 161,000 161,000
Sales returns and allow 187,000 187,000 187,000
Purchases 2,643,000 2,643,000 2,643,000
Tramsportation in 72,000 72,000 72,000
Purchase discounts 172,000 172,000 172,000
Purchase returns and allow 133,000 133,000 133,000
Salaries expense 862,000 3) 21,000 883,000 883,000
Insurance expense 25,000 25,000 25,000
Travel expenses 188,000 188,000 188,000
Interest expense 208,000 208,000 208,000
Total 8,039,000 8,039,000
2011 2010 Amount Change Percentage Change 2011 common size 2010 common size
ASSETS
Current Assets
Cash and cash equivalents 2,030,500.00 1,191,000.00 839,500.00 70.49% 4.26% 3.14%
Marketable Securities 2,636,000.00 4,002,000.00 320,500.00 7.31% 9.87% 11.55%
Trade and other receivables (net) 4,704,000.00 4,383,500.00 - 15,500.00 7.43% -0.47% -0.55%
Allowance for doubtful accounts -224,000.00 -208,500.00 5,136,000.00 27.94% 49.36% 48.44%
Inventories 23,520,500.00 18,384,500.00 - 123,500.00 -32.54% 0.54% 1.00%
Prepaid expenses 256,000.00 379,500.00 - 1,366,000.00 -34.13% 5.53% 10.54%
Total current assets 32,923,000.00 28,132,000.00 - 28,132,000.00 -100.00% 0.00% 74.12%
Noncurrent assets
Property, plant and equipment (net) (1) 14,539,500.00 9,488,500.00 5,051,000.00 53.23% 30.51% 25.00%
Other assets 186,500.00 334,000.00 - 147,500.00 -44.16% 0.39% 0.88%
Total Assets 47,649,000.00 37,954,500.00 9,694,500.00 25.54% 100.00% 100.00%
2011 2010 2009 Amount Change Percantage Change 2011 common size 2010 common size