Public Accountancy Practice

You are on page 1of 69

YEAR 1

SCHEDULE 7
Budgeted Marketing and Administrative Costs
For 2019
Variable Marketing Costs
Sales commission (@P40.625) ₱ 260,000
Others (@P16.25) 104,000
Total 364,000

Fixed Marketing Costs


Sales salaries 100,000
Advertising 193,000
Others 78,000
Total 371,000
Total Marketing costs 735,000

Administrative Costs (all fixed)


Administrative salaries 254,000
Data processing services 103,000
Legal and other professional fees 180,000
Depreciation- building, furniture and equipment 94,000
Taxes - other than income 107,280
Others 26,000
Total 764,280
Total marketing and administrative costs ₱ 1,499,280

SCHEDULE 8
Gilbert Manufacturing Company
Cash Budget
For the Budget Year Ending December 31, 2019
Cash balance, January 1, 2018 ₱ 150,000
Add: Estimated receipts
Collections from customers ₱ 5,185,000
Sale of assets 25,000
Total 5,210,000
Total cash available 5,360,000
Less: Estimated disbursements
Payments for material purchases 1,164,000
Direct labor 949,000
Manufacturing overhead 850,935
Marketing & Administrative expenses 1,458,000
Payments for income tax 252,000
Dividends 140,000
Reduction in long-term debt 83,000
Acquisition of new assets 320,000
Total disbursements 5,216,935
Cash balance, December 31 ₱ 143,065

SCHEDULE 9
Gilbert Manufacturing Company
Budgeted Income Statement
For the Budget Year Ending December 31, 2019
Sales (Schedule 1) ₱ 6,400
Less: Cost of sales (Schedule 6) 3,199,935
Gross profit (3,193,535)
Less: Marketing and administrative costs (Schedule 7) 1,499,280
Net operating profit (4,692,815)
Less: Interest expense 52,720
Net income before taxes (4,745,535)
Less: Provision for income taxes (35%) (1,660,937)
Net income after taxes -₱ 3,084,598
SCHEDULE 10
Gilbert Manufacturing Company
Budgeted Statement of Financial Position
December 31, 2019
Assets Equities
Current assets Current Liabilities
Cash (Schedule 8) ₱ 143,065 Accounts Payable ₱ 155,000
Accounts receivable 155,000 Taxes payable 32,823
Inventories 651,000 Current portion of long - term debt -
Other current assets 23,000 Total current liabilities 187,823
Total current assets 972,065 Long - term liabilities 576,000
Total liabilities 763,823

Long - term assets Equity


Property, plant and equipment 2,495,000 Share capital 350,000
Less: Accumulated depreciation 949,000 Retained earnings 1,404,242
Net 1,546,000 Total Equity 1,754,242

Total assets ₱ 2,518,065 Total liabilities and equity ₱ 2,518,065


YEAR 2
SCHEDULE 1
Sales Budget
For 2020
Units Price per Unit Total Sales Revenue
Estimated Sales: 6,400 800 ₱ 5,120,000

SCHEDULE 2
Production Budget
For 2020
Units to be sold 6,400
Add: Desired ending inventory 1,000
Total 7,400
Less: Beginning inventory 1,000
Units to be produced 6,400

SCHEDULE 3
Raw Materials Purchases
For 2020
Materials
R S
Units required for production
R
S
Add: Desired ending inventory
Total units required
Less: Beginning inventory
Units to be purchased
Unit price
Total Purchases
Total Purchases

SCHEDULE 4
Direct Labor Budget
For 2020
Number of units to be produced 6,400
Multiply by: Direct labor cost per unit 146
Total budgeted direct labor costs ₱ 934,400

SCHEDULE 5
Budgeted Manufacturing Overhead
For 2020
Variable overhead: units needed to produce
Indirect materials and supplies
Materials handling
Other indirect labor
Total

Fixed manufacturing overhead


Supervisor labor
Maintenance & repairs
Plant administration
Utilities
Depreciation
Insurance
Property taxes
Others
Total
Total manufacturing overhead
PANGET SI ANGGE HAHAHAAHAHHA
PANGET SI ANGGE HAHAHAAHAHHA
SCHEDULE 6
Budgeted Statement of Cost of Sales
For 2020 PANGET SI ANGGE HAHAHAAHAHHA
Beginning work in process inventory
PANGET SI ANGGE HAHAHAAHAHHA
Manufacturing Costs
Direct materials PANGET SI ANGGE HAHAHAAHAHHA
Beginning inventory
Purchases PANGET SI ANGGE HAHAHAAHAHHA
Total
Less: Ending inventory
Total Direct material cost PANGET SI ANGGE HAHAHAAHAHHA
Direct labor
Manufacturing overhead
Total Manufacturing costs
Less: Ending work in process inventory PANGET SI ANGGE HAHAHAAHAHHA
Cost of Goods Manufactured
Add: Beginning finished goods
Total available for sale
Less: Ending finished goods
Cost of sales
SCHEDULE 7
Budgeted Marketing and Administrative Costs
For 2020
Variable Marketing Costs
Sales commission (@P40.625) ₱ 260,000
Others (@P16.25) 104,000
Total 364,000

Fixed Marketing Costs


Sales salaries 100,000
Advertising 193,000
Others 78,000
Total 371,000
Total Marketing costs 735,000

Administrative Costs (all fixed)


Administrative salaries 254,000
Data processing services 103,000
Legal and other professional fees 180,000
Depreciation- building, furniture and equipment 94,000
Taxes - other than income 108,000
Others 26,000
Total 765,000
Total marketing and administrative costs ₱ 1,500,000

SCHEDULE 8
Gilbert Manufacturing Company
Cash Budget
For the Budget Year Ending December 31, 2020
Cash balance, January 1, 2019 ₱ 143,065
Add: Estimated receipts
Collections from customers ₱ 5,185,000
Sale of assets
Total ₱ 5,185,000
Total cash available ₱ 5,328,065
Less: Estimated disbursements
Payments for material purchases ₱ 1,137,000
Direct labor 934,400
Manufacturing overhead 848,936
Marketing & Administrative expenses 1,452,080
Payments for income tax 100,000
Dividends 140,000
Reduction in long-term debt 83,000
Acquisition of new assets
Total disbursements ₱ 4,695,416
Cash balance, December 31 ₱ 632,649

SCHEDULE 9
Gilbert Manufacturing Company
Budgeted Income Statement
For the Budget Year Ending December 31, 2020
Sales (Schedule 1) ₱ 5,120,000
Less: Cost of sales (Schedule 6) 3,279,336
Gross profit 1,840,664
Less: Marketing and administrative costs (Schedule 7) 1,500,000
Net operating profit 340,664
Less: Interest expense 46,080
Net income before taxes 294,584
Less: Provision for income taxes (35%) 103,104
Net income after taxes ₱ 191,480
SCHEDULE 10
Gilbert Manufacturing Company
Budgeted Statement of Financial Position
December 31, 2020
Assets Equities
Current assets Current Liabilities
Cash (Schedule 8) ₱ 632,649 Accounts Payable ₱ 170,000
Accounts receivable 90,000 Taxes payable 35,927
Inventories 651,000 Current portion of long - term debt 83,000
Other current assets 23,000 Total current liabilities 288,927
Total current assets 1,396,649 Long - term liabilities 410,000
Total liabilities 698,927
Long - term assets
Property, plant and equipment 2,495,000 Equity
Less: Accumulated depreciation 1,387,000 Share capital 350,000
Net 1,108,000 Retained earnings 1,455,722
Total Equity 1,805,722

Total assets ₱ 2,504,649 Total liabilities and equity ₱ 2,504,649


YEAR 3
SCHEDULE 1
Sales Budget
For 2021
Units Price per Unit Total Sales Revenue
Estimated Sales: 6,400 800 ₱ 5,120,000

SCHEDULE 2
Production Budget
For 2021
Units to be sold 6,400
Add: Desired ending inventory 1,000
Total 7,400
Less: Beginning inventory 1,000
Units to be produced 6,400

SCHEDULE 3
Raw Materials Purchases
For 2021
Materials
R S
Units required for production
R
S
Add: Desired ending inventory
Total units required
Less: Beginning inventory
Units to be purchased
Unit price
Total Purchases
Total Purchases

SCHEDULE 4
Direct Labor Budget
For 2021
Number of units to be produced 6,400
Multiply by: Direct labor cost per unit 146
Total budgeted direct labor costs ₱ 934,400

SCHEDULE 5
Budgeted Manufacturing Overhead
For 2021
Variable overhead: units needed to produce 6,400
Indirect materials and supplies ₱ 37,440
Materials handling 58,048
Other indirect labor 32,448
Total 127,936

Fixed manufacturing overhead


Supervisor labor 175,000
Maintenance & repairs 85,000
Plant administration 173,000
Utilities 87,000
Depreciation 344,000
Insurance 43,000
Property taxes 117,000
Others 41,000
Total 1,065,000
Total manufacturing overhead ₱ 1,192,936
SCHEDULE 6
Budgeted Statement of Cost of Sales
For 2021
Beginning work in process inventory

Manufacturing Costs
Direct materials
Beginning inventory
Purchases
Total
Less: Ending inventory
Total Direct material cost
Direct labor
Manufacturing overhead
Total Manufacturing costs
Less: Ending work in process inventory
Cost of Goods Manufactured
Add: Beginning finished goods
Total available for sale
Less: Ending finished goods
Cost of sales
SCHEDULE 7
Budgeted Marketing and Administrative Costs
For 2021
Variable Marketing Costs
Sales commission (@P40.625) ₱ 260,000
Others (@P16.25) 104,000
Total 364,000

Fixed Marketing Costs


Sales salaries 100,000
Advertising 193,000
Others 78,000
Total 371,000
Total Marketing costs 735,000

Administrative Costs (all fixed)


Administrative salaries 254,000
Data processing services 103,000
Legal and other professional fees 180,000
Depreciation- building, furniture and equipment 94,000
Taxes - other than income 108,000
Others 26,000
Total 765,000
Total marketing and administrative costs ₱ 1,500,000

SCHEDULE 8
Gilbert Manufacturing Company
Cash Budget
For the Budget Year Ending December 31, 2021
Cash balance, January 1, 2020 ₱ 632,649
Add: Estimated receipts
Collections from customers ₱ 5,185,000
Sale of assets
Total ₱ 5,185,000
Total cash available ₱ 5,817,649
Less: Estimated disbursements
Payments for material purchases ₱ 1,137,000
Direct labor 934,400
Manufacturing overhead 848,936
Marketing & Administrative expenses 1,445,440
Payments for income tax 100,000
Dividends 140,000
Reduction in long-term debt 83,000
Acquisition of new assets
Total disbursements ₱ 4,688,776
Cash balance, December 31 ₱ 1,128,873

SCHEDULE 9
Gilbert Manufacturing Company
Budgeted Income Statement
For the Budget Year Ending December 31, 2021
Sales (Schedule 1) ₱ 5,120,000
Less: Cost of sales (Schedule 6) 3,279,336
Gross profit 1,840,664
Less: Marketing and administrative costs (Schedule 7) 1,500,000
Net operating profit 340,664
Less: Interest expense 39,440
Net income before taxes 301,224
Less: Provision for income taxes (35%) 105,428
Net income after taxes ₱ 195,796
SCHEDULE 10
Gilbert Manufacturing Company
Budgeted Statement of Financial Position
December 31, 2021
Assets Equities
Current assets Current Liabilities
Cash (Schedule 8) ₱ 1,128,873 Accounts Payable ₱ 185,000
Accounts receivable 25,000 Taxes payable 41,356
Inventories 651,000 Current portion of long - term debt 83,000
Other current assets 23,000 Total current liabilities 309,356
Total current assets 1,827,873 Long - term liabilities 327,000
Total liabilities 636,356
Long - term assets
Property, plant and equipment 2,495,000 Equity
Less: Accumulated depreciation 1,825,000 Share capital 350,000
Net 670,000 Retained earnings 1,511,517
Total Equity 1,861,517

Total assets ₱ 2,497,873 Total liabilities and equity ₱ 2,497,873


YEAR 4
SCHEDULE 1
Sales Budget
For 2022
Units Price per Unit Total Sales Revenue
Estimated Sales: 6,400 800 ₱ 5,120,000

SCHEDULE 2
Production Budget
For 2022
Units to be sold 6,400
Add: Desired ending inventory 1,000
Total 7,400
Less: Beginning inventory 1,000
Units to be produced 6,400

SCHEDULE 3
Raw Materials Purchases
For 2022
Materials
R S
Units required for production
R ₱ 19,200
S ₱ 32,000
Add: Desired ending inventory 1,300 4,600
Total units required 20,500 36,600
Less: Beginning inventory 1,300 4,600
Units to be purchased 19,200 32,000
Unit price 10 30
Total Purchases 192,000 960,000
Total Purchases ₱ 1,152,000

SCHEDULE 4
Direct Labor Budget
For 2022
Number of units to be produced 6,400
Multiply by: Direct labor cost per unit 146
Total budgeted direct labor costs ₱ 934,400

SCHEDULE 5
Budgeted Manufacturing Overhead
For 2022
Variable overhead: units needed to produce 6,400
Indirect materials and supplies ₱ 37,440
Materials handling 58,048
Other indirect labor 32,448
Total 127,936

Fixed manufacturing overhead


Supervisor labor 175,000
Maintenance & repairs 85,000
Plant administration 173,000
Utilities 87,000
Depreciation 344,000
Insurance 43,000
Property taxes 117,000
Others 41,000
Total 1,065,000
Total manufacturing overhead ₱ 1,192,936
SCHEDULE 6
Budgeted Statement of Cost of Sales
For 2022
Beginning work in process inventory

Manufacturing Costs
Direct materials
Beginning inventory
Purchases
Total
Less: Ending inventory
Total Direct material cost
Direct labor
Manufacturing overhead
Total Manufacturing costs
Less: Ending work in process inventory
Cost of Goods Manufactured
Add: Beginning finished goods
Total available for sale
Less: Ending finished goods
Cost of sales
SCHEDULE 7
Budgeted Marketing and Administrative Costs
For 2022
Variable Marketing Costs
Sales commission (@P40.625) ₱ 260,000
Others (@P16.25) 104,000
Total 364,000

Fixed Marketing Costs


Sales salaries 100,000
Advertising 193,000
Others 78,000
Total 371,000
Total Marketing costs 735,000

Administrative Costs (all fixed)


Administrative salaries 254,000
Data processing services 103,000
Legal and other professional fees 180,000
Depreciation- building, furniture and equipment 94,000
Taxes - other than income 108,000
Others 26,000
Total 765,000
Total marketing and administrative costs ₱ 1,500,000

SCHEDULE 8
Gilbert Manufacturing Company
Cash Budget
For the Budget Year Ending December 31, 2022
Cash balance, January 1, 2021 ₱ 1,128,873
Add: Estimated receipts
Collections from customers 4,500,000
Sale of assets
Total 4,500,000
Total cash available 5,628,873
Less: Estimated disbursements
Payments for material purchases 1,137,000
Direct labor 934,400
Manufacturing overhead 848,936
Marketing & Administrative expenses 1,438,800
Payments for income tax 100,000
Dividends 140,000
Reduction in long-term debt 83,000
Acquisition of new assets
Total disbursements 4,682,136
Cash balance, December 31 ₱ 946,737

SCHEDULE 9
Gilbert Manufacturing Company
Budgeted Income Statement
For the Budget Year Ending December 31, 2022
Sales (Schedule 1) ₱ 5,120,000
Less: Cost of sales (Schedule 6) 3,279,336
Gross profit 1,840,664
Less: Marketing and administrative costs (Schedule 7) 1,500,000
Net operating profit 340,664
Less: Interest expense 32,800
Net income before taxes 307,864
Less: Provision for income taxes (35%) 107,752
Net income after taxes ₱ 200,112
SCHEDULE 10
Gilbert Manufacturing Company
Budgeted Statement of Financial Position
December 31, 2022
Assets Equities
Current assets Current Liabilities
Cash (Schedule 8) ₱ 946,737 Accounts Payable ₱ 200,000
Accounts receivable 645,000 Taxes payable 49,108
Inventories 651,000 Current portion of long - term debt 83,000
Other current assets 23,000 Total current liabilities 332,108
Total current assets 2,265,737 Long - term liabilities 244,000
Total liabilities 576,108

Long - term assets Equity


Property, plant and equipment 2,495,000 Share capital 350,000
Less: Accumulated depreciation 2,263,000 Retained earnings 1,571,629
Net 232,000 Total Equity 1,921,629

Total assets ₱ 2,497,737 Total liabilities and equity ₱ 2,497,737


YEAR 5
SCHEDULE 1
Sales Budget
For 2023
Units Price per Unit Total Sales Revenue
Estimated Sales: 6,400 800 ₱ 5,120,000

SCHEDULE 2
Production Budget
For 2023
Units to be sold 6,400
Add: Desired ending inventory 1,000
Total 7,400
Less: Beginning inventory 1,000
Units to be produced 6,400

SCHEDULE 3
Raw Materials Purchases
For 2023
Materials
R S
Units required for production
R ₱ 19,200
S ₱ 32,000
Add: Desired ending inventory 1,300 4,600
Total units required 20,500 36,600
Less: Beginning inventory 1,300 4,600
Units to be purchased 19,200 32,000
Unit price 10 30
Total Purchases 192,000 960,000
Total Purchases ₱ 1,152,000

SCHEDULE 4
Direct Labor Budget
For 2023
Number of units to be produced 6,400
Multiply by: Direct labor cost per unit 146
Total budgeted direct labor costs ₱ 934,400

SCHEDULE 5
Budgeted Manufacturing Overhead
For 2023
Variable overhead: units needed to produce
Indirect materials and supplies
Materials handling
Other indirect labor
Total

Fixed manufacturing overhead


Supervisor labor
Maintenance & repairs
Plant administration
Utilities
Depreciation
Insurance
Property taxes
Others
Total
Total manufacturing overhead
SCHEDULE 6
Budgeted Statement of Cost of Sales
For 2023
Beginning work in process inventory

Manufacturing Costs
Direct materials
Beginning inventory
Purchases
Total
Less: Ending inventory
Total Direct material cost
Direct labor
Manufacturing overhead
Total Manufacturing costs
Less: Ending work in process inventory
Cost of Goods Manufactured
Add: Beginning finished goods
Total available for sale
Less: Ending finished goods
Cost of sales
SCHEDULE 7
Budgeted Marketing and Administrative Costs
For 2023
Variable Marketing Costs
Sales commission (@P40.625) ₱ 260,000
Others (@P16.25) 104,000
Total 364,000

Fixed Marketing Costs


Sales salaries 100,000
Advertising 193,000
Others 78,000
Total 371,000
Total Marketing costs 735,000

Administrative Costs (all fixed)


Administrative salaries 254,000
Data processing services 103,000
Legal and other professional fees 180,000
Depreciation- building, furniture and equipment -
Taxes - other than income 108,000
Others 26,000
Total 671,000
Total marketing and administrative costs ₱ 1,406,000

SCHEDULE 8
Gilbert Manufacturing Company
Cash Budget
For the Budget Year Ending December 31, 2023
Cash balance, January 1, 2022 ₱ 946,737
Add: Estimated receipts
Collections from customers 4,500,000
Sale of assets
Total 4,500,000
Total cash available 5,446,737
Less: Estimated disbursements
Payments for material purchases 1,137,000
Direct labor 934,400
Manufacturing overhead 848,936
Marketing & Administrative expenses 1,432,160
Payments for income tax 100,000
Dividends 140,000
Reduction in long-term debt 83,000
Acquisition of new assets
Total disbursements 4,675,496
Cash balance, December 31 ₱ 771,241

SCHEDULE 9
Gilbert Manufacturing Company
Budgeted Income Statement
For the Budget Year Ending December 31, 2023
Sales (Schedule 1) ₱ 5,120,000
Less: Cost of sales (Schedule 6) 3,103,336
Gross profit 2,016,664
Less: Marketing and administrative costs (Schedule 7) 1,406,000
Net operating profit 610,664
Less: Interest expense 26,160
Net income before taxes 584,504
Less: Provision for income taxes (35%) 204,576
Net income after taxes ₱ 379,928
SCHEDULE 10
Gilbert Manufacturing Company
Budgeted Statement of Financial Position
December 31, 2023
Assets Equities
Current assets Current Liabilities
Cash (Schedule 8) ₱ 771,241 Accounts Payable ₱ 215,000
Accounts receivable 1,265,000 Taxes payable 153,684
Inventories 651,000 Current portion of long - term debt 83,000
Other current assets 23,000 Total current liabilities 451,684
Total current assets 2,710,241 Long - term liabilities 161,000
Total liabilities 612,684

Long - term assets Equity


Property, plant and equipment 2,495,000 Share capital 350,000
Less: Accumulated depreciation 2,431,000 Retained earnings 1,811,557
Net 64,000 Total Equity 2,161,557

Total assets ₱ 2,774,241 Total liabilities and equity ₱ 2,774,241


YEAR 6
SCHEDULE 1
Sales Budget
For 2024
Units Price per Unit Total Sales Revenue
Estimated Sales: 6,400 800 ₱ 5,120,000

SCHEDULE 2
Production Budget
For 2024
Units to be sold 6,400
Add: Desired ending inventory 1,000
Total 7,400
Less: Beginning inventory 1,000
Units to be produced 6,400

SCHEDULE 3
Raw Materials Purchases
For 2024
Materials
R S
Units required for production
R ₱ 19,200
S ₱ 32,000
Add: Desired ending inventory 1,300 4,600
Total units required 20,500 36,600
Less: Beginning inventory 1,300 4,600
Units to be purchased 19,200 32,000
Unit price 10 30
Total Purchases 192,000 960,000
Total Purchases ₱ 1,152,000

SCHEDULE 4
Direct Labor Budget
For 2024
Number of units to be produced 6,400
Multiply by: Direct labor cost per unit 146
Total budgeted direct labor costs ₱ 934,400

SCHEDULE 5
Budgeted Manufacturing Overhead
For 2024
Variable overhead: units needed to produce
Indirect materials and supplies
Materials handling
Other indirect labor
Total

Fixed manufacturing overhead


Supervisor labor
Maintenance & repairs
Plant administration
Utilities
Depreciation
Insurance
Property taxes
Others
Total
Total manufacturing overhead
SCHEDULE 6
Budgeted Statement of Cost of Sales
For 2024
Beginning work in process inventory

Manufacturing Costs
Direct materials
Beginning inventory
Purchases
Total
Less: Ending inventory
Total Direct material cost
Direct labor
Manufacturing overhead
Total Manufacturing costs
Less: Ending work in process inventory
Cost of Goods Manufactured
Add: Beginning finished goods
Total available for sale
Less: Ending finished goods
Cost of sales
SCHEDULE 7
Budgeted Marketing and Administrative Costs
For 2024
Variable Marketing Costs
Sales commission (@P40.625) ₱ 260,000
Others (@P16.25) 104,000
Total 364,000

Fixed Marketing Costs


Sales salaries 100,000
Advertising 193,000
Others 78,000
Total 371,000
Total Marketing costs 735,000

Administrative Costs (all fixed)


Administrative salaries 254,000
Data processing services 103,000
Legal and other professional fees 180,000
Depreciation- building, furniture and equipment -
Taxes - other than income 108,000
Others 26,000
Total 671,000
Total marketing and administrative costs ₱ 1,406,000

SCHEDULE 8
Gilbert Manufacturing Company
Cash Budget
For the Budget Year Ending December 31, 2024
Cash balance, January 1, 2023 ₱ 771,241
Add: Estimated receipts
Collections from customers 4,500,000
Sale of assets
Total 4,500,000
Total cash available 5,271,241
Less: Estimated disbursements
Payments for material purchases 1,137,000
Direct labor 934,400
Manufacturing overhead 848,936
Marketing & Administrative expenses 1,425,520
Payments for income tax 100,000
Dividends 140,000
Reduction in long-term debt 83,000
Acquisition of new assets
Total disbursements 4,668,856
Cash balance, December 31 ₱ 602,385

SCHEDULE 9
Gilbert Manufacturing Company
Budgeted Income Statement
For the Budget Year Ending December 31, 2024
Sales (Schedule 1) ₱ 5,120,000
Less: Cost of sales (Schedule 6) 3,103,336
Gross profit 2,016,664
Less: Marketing and administrative costs (Schedule 7) 1,406,000
Net operating profit 610,664
Less: Interest expense 19,520
Net income before taxes 591,144
Less: Provision for income taxes (35%) 206,900
Net income after taxes ₱ 384,244
SCHEDULE 10
Gilbert Manufacturing Company
Budgeted Statement of Financial Position
December 31, 2024
Assets Equities
Current assets Current Liabilities
Cash (Schedule 8) ₱ 602,385 Accounts Payable ₱ 230,000
Accounts receivable 1,885,000 Taxes payable 260,585
Inventories 651,000 Current portion of long - term debt 83,000
Other current assets 23,000 Total current liabilities 573,585
Total current assets 3,161,385 Long - term liabilities 78,000
Total liabilities 651,585
Long - term assets
Property, plant and equipment 2,495,000 Equity
Less: Accumulated depreciation 2,599,000 Share capital 350,000
Net (104,000) Retained earnings 2,055,800
Total Equity 2,405,800

Total assets ₱ 3,057,385 Total liabilities and equity ₱ 3,057,385


YEAR 7
SCHEDULE 1
Sales Budget
For 2025
Units Price per Unit Total Sales Revenue
Estimated Sales: 6,400 800 ₱ 5,120,000

SCHEDULE 2
Production Budget
For 2025
Units to be sold 6,400
Add: Desired ending inventory 1,000
Total 7,400
Less: Beginning inventory 1,000
Units to be produced 6,400

SCHEDULE 3
Raw Materials Purchases
For 2025
Materials
R S
Units required for production
R ₱ 19,200
S ₱ 32,000
Add: Desired ending inventory 1,300 4,600
Total units required 20,500 36,600
Less: Beginning inventory 1,300 4,600
Units to be purchased 19,200 32,000
Unit price 10 30
Total Purchases 192,000 960,000
Total Purchases ₱ 1,152,000

SCHEDULE 4
Direct Labor Budget
For 2025
Number of units to be produced 6,400
Multiply by: Direct labor cost per unit 146
Total budgeted direct labor costs ₱ 934,400

SCHEDULE 5
Budgeted Manufacturing Overhead
For 2025
Variable overhead: units needed to produce 6,400
Indirect materials and supplies ₱ 37,440
Materials handling 58,048
Other indirect labor 32,448
Total 127,936

Fixed manufacturing overhead


Supervisor labor 175,000
Maintenance & repairs 85,000
Plant administration 173,000
Utilities 87,000
Depreciation 168,000
Insurance 43,000
Property taxes 117,000
Others 41,000
Total 889,000
Total manufacturing overhead ₱ 1,016,936
SCHEDULE 6
Budgeted Statement of Cost of Sales
For 2025
Beginning work in process inventory

Manufacturing Costs
Direct materials
Beginning inventory
Purchases
Total
Less: Ending inventory
Total Direct material cost
Direct labor
Manufacturing overhead
Total Manufacturing costs
Less: Ending work in process inventory
Cost of Goods Manufactured
Add: Beginning finished goods
Total available for sale
Less: Ending finished goods
Cost of sales
SCHEDULE 7
Budgeted Marketing and Administrative Costs
For 2025
Variable Marketing Costs
Sales commission (@P40.625) ₱ 260,000
Others (@P16.25) 104,000
Total 364,000

Fixed Marketing Costs


Sales salaries 100,000
Advertising 193,000
Others 78,000
Total 371,000
Total Marketing costs 735,000

Administrative Costs (all fixed)


Administrative salaries 254,000
Data processing services 103,000
Legal and other professional fees 180,000
Depreciation- building, furniture and equipment -
Taxes - other than income 108,000
Others 26,000
Total 671,000
Total marketing and administrative costs ₱ 1,406,000

SCHEDULE 8
Gilbert Manufacturing Company
Cash Budget
For the Budget Year Ending December 31, 2025
Cash balance, January 1, 2024 ₱ 602,385
Add: Estimated receipts
Collections from customers 4,500,000
Sale of assets
Total 4,500,000
Total cash available 5,102,385
Less: Estimated disbursements
Payments for material purchases 1,137,000
Direct labor 934,400
Manufacturing overhead 848,936
Marketing & Administrative expenses 1,418,880
Payments for income tax 100,000
Dividends 140,000
Reduction in long-term debt 83,000
Acquisition of new assets
Total disbursements 4,662,216
Cash balance, December 31 ₱ 440,169

SCHEDULE 9
Gilbert Manufacturing Company
Budgeted Income Statement
For the Budget Year Ending December 31, 2025
Sales (Schedule 1) ₱ 5,120,000
Less: Cost of sales (Schedule 6) 3,103,336
Gross profit 2,016,664
Less: Marketing and administrative costs (Schedule 7) 1,406,000
Net operating profit 610,664
Less: Interest expense 12,880
Net income before taxes 597,784
Less: Provision for income taxes (35%) 209,224
Net income after taxes ₱ 388,560
SCHEDULE 10
Gilbert Manufacturing Company
Budgeted Statement of Financial Position
December 31, 2025
Assets Equities
Current assets Current Liabilities
Cash (Schedule 8) ₱ 440,169 Accounts Payable ₱ 245,000
Accounts receivable 2,505,000 Taxes payable 369,809
Inventories 651,000 Current portion of long - term debt 83,000
Other current assets 23,000 Total current liabilities 697,809
Total current assets 3,619,169 Long - term liabilities (5,000)
Total liabilities 692,809

Long - term assets Equity


Property, plant and equipment 2,495,000 Share capital 350,000
Less: Accumulated depreciation 2,767,000 Retained earnings 2,304,360
Net (272,000) Total Equity 2,654,360

Total assets ₱ 3,347,169 Total liabilities and equity ₱ 3,347,169


YEAR 8
SCHEDULE 1
Sales Budget
For 2026
Units Price per Unit Total Sales Revenue
Estimated Sales: 6,400 800 ₱ 5,120,000

SCHEDULE 2
Production Budget
For 2026
Units to be sold 6,400
Add: Desired ending inventory 1,000
Total 7,400
Less: Beginning inventory 1,000
Units to be produced 6,400

SCHEDULE 3
Raw Materials Purchases
For 2026
Materials
R S
Units required for production
R ₱ 19,200
S ₱ 32,000
Add: Desired ending inventory 1,300 4,600
Total units required 20,500 36,600
Less: Beginning inventory 1,300 4,600
Units to be purchased 19,200 32,000
Unit price 10 30
Total Purchases 192,000 960,000
Total Purchases ₱ 1,152,000

SCHEDULE 4
Direct Labor Budget
For 2026
Number of units to be produced 6,400
Multiply by: Direct labor cost per unit 146
Total budgeted direct labor costs ₱ 934,400

SCHEDULE 5
Budgeted Manufacturing Overhead
For 2026
Variable overhead: units needed to produce 6,400
Indirect materials and supplies ₱ 37,440
Materials handling 58,048
Other indirect labor 32,448
Total 127,936

Fixed manufacturing overhead


Supervisor labor 175,000
Maintenance & repairs 85,000
Plant administration 173,000
Utilities 87,000
Depreciation 168,000
Insurance 43,000
Property taxes 117,000
Others 41,000
Total 889,000
Total manufacturing overhead ₱ 1,016,936
SCHEDULE 6
Budgeted Statement of Cost of Sales
For 2026
Beginning work in process inventory

Manufacturing Costs
Direct materials
Beginning inventory
Purchases
Total
Less: Ending inventory
Total Direct material cost
Direct labor
Manufacturing overhead
Total Manufacturing costs
Less: Ending work in process inventory
Cost of Goods Manufactured
Add: Beginning finished goods
Total available for sale
Less: Ending finished goods
Cost of sales
SCHEDULE 7
Budgeted Marketing and Administrative Costs
For 2026
Variable Marketing Costs
Sales commission (@P40.625) ₱ 260,000
Others (@P16.25) 104,000
Total 364,000

Fixed Marketing Costs


Sales salaries 100,000
Advertising 193,000
Others 78,000
Total 371,000
Total Marketing costs 735,000

Administrative Costs (all fixed)


Administrative salaries 254,000
Data processing services 103,000
Legal and other professional fees 180,000
Depreciation- building, furniture and equipment -
Taxes - other than income 108,000
Others 26,000
Total 671,000
Total marketing and administrative costs ₱ 1,406,000

SCHEDULE 8
Gilbert Manufacturing Company
Cash Budget
For the Budget Year Ending December 31, 2026
Cash balance, January 1, 2025 ₱ 440,169
Add: Estimated receipts
Collections from customers 4,500,000
Sale of assets
Total 4,500,000
Total cash available 4,940,169
Less: Estimated disbursements
Payments for material purchases 1,137,000
Direct labor 934,400
Manufacturing overhead 848,936
Marketing & Administrative expenses 1,412,240
Payments for income tax 100,000
Dividends 140,000
Reduction in long-term debt 83,000
Acquisition of new assets
Total disbursements 4,655,576
Cash balance, December 31 ₱ 284,593

SCHEDULE 9
Gilbert Manufacturing Company
Budgeted Income Statement
For the Budget Year Ending December 31, 2026
Sales (Schedule 1) ₱ 5,120,000
Less: Cost of sales (Schedule 6) 3,103,336
Gross profit 2,016,664
Less: Marketing and administrative costs (Schedule 7) 1,406,000
Net operating profit 610,664
Less: Interest expense 6,240
Net income before taxes 604,424
Less: Provision for income taxes (35%) 211,548
Net income after taxes ₱ 392,876
SCHEDULE 10
Gilbert Manufacturing Company
Budgeted Statement of Financial Position
December 31, 2026
Assets Equities
Current assets Current Liabilities
Cash (Schedule 8) ₱ 284,593 Accounts Payable ₱ 260,000
Accounts receivable 3,125,000 Taxes payable 481,358
Inventories 651,000 Current portion of long - term debt 83,000
Other current assets 23,000 Total current liabilities 824,358
Total current assets 4,083,593 Long - term liabilities (88,000)
Total liabilities 736,358
Long - term assets
Property, plant and equipment 2,495,000 Equity
Less: Accumulated depreciation 2,935,000 Share capital 350,000
Net (440,000) Retained earnings 2,557,235
Total Equity 2,907,235

Total assets ₱ 3,643,593 Total liabilities and equity ₱ 3,643,593


YEAR 9
SCHEDULE 1
Sales Budget
For 2027
Units Price per Unit Total Sales Revenue
Estimated Sales: 6,400 800 ₱ 5,120,000

SCHEDULE 2
Production Budget
For 2027
Units to be sold 6,400
Add: Desired ending inventory 1,000
Total 7,400
Less: Beginning inventory 1,000
Units to be produced 6,400

SCHEDULE 3
Raw Materials Purchases
For 2027
Materials
R S
Units required for production
R ₱ 19,200
S ₱ 32,000
Add: Desired ending inventory 1,300 4,600
Total units required 20,500 36,600
Less: Beginning inventory 1,300 4,600
Units to be purchased 19,200 32,000
Unit price 10 30
Total Purchases 192,000 960,000
Total Purchases ₱ 1,152,000

SCHEDULE 4
Direct Labor Budget
For 2027
Number of units to be produced 6,400
Multiply by: Direct labor cost per unit 146
Total budgeted direct labor costs ₱ 934,400

SCHEDULE 5
Budgeted Manufacturing Overhead
For 2027
Variable overhead: units needed to produce 6,400
Indirect materials and supplies ₱ 37,440
Materials handling 58,048
Other indirect labor 32,448
Total 127,936

Fixed manufacturing overhead


Supervisor labor 175,000
Maintenance & repairs 85,000
Plant administration 173,000
Utilities 87,000
Depreciation 168,000
Insurance 43,000
Property taxes 117,000
Others 41,000
Total 889,000
Total manufacturing overhead ₱ 1,016,936
SCHEDULE 6
Budgeted Statement of Cost of Sales
For 2027
Beginning work in process inventory

Manufacturing Costs
Direct materials
Beginning inventory
Purchases
Total
Less: Ending inventory
Total Direct material cost
Direct labor
Manufacturing overhead
Total Manufacturing costs
Less: Ending work in process inventory
Cost of Goods Manufactured
Add: Beginning finished goods
Total available for sale
Less: Ending finished goods
Cost of sales
SCHEDULE 7
Budgeted Marketing and Administrative Costs
For 2027
Variable Marketing Costs
Sales commission (@P40.625) ₱ 260,000
Others (@P16.25) 104,000
Total 364,000

Fixed Marketing Costs


Sales salaries 100,000
Advertising 193,000
Others 78,000
Total 371,000
Total Marketing costs 735,000

Administrative Costs (all fixed)


Administrative salaries 254,000
Data processing services 103,000
Legal and other professional fees 180,000
Depreciation- building, furniture and equipment -
Taxes - other than income 108,000
Others 26,000
Total 671,000
Total marketing and administrative costs ₱ 1,406,000

SCHEDULE 8
Gilbert Manufacturing Company
Cash Budget
For the Budget Year Ending December 31, 2027
Cash balance, January 1, 2026 ₱ 284,593
Add: Estimated receipts
Collections from customers 4,500,000
Sale of assets
Total 4,500,000
Total cash available 4,784,593
Less: Estimated disbursements
Payments for material purchases 1,137,000
Direct labor 934,400
Manufacturing overhead 848,936
Marketing & Administrative expenses 1,405,600
Payments for income tax 100,000
Dividends 140,000
Reduction in long-term debt 83,000
Acquisition of new assets
Total disbursements 4,648,936
Cash balance, December 31 ₱ 135,657

SCHEDULE 9
Gilbert Manufacturing Company
Budgeted Income Statement
For the Budget Year Ending December 31, 2027
Sales (Schedule 1) ₱ 5,120,000
Less: Cost of sales (Schedule 6) 3,103,336
Gross profit 2,016,664
Less: Marketing and administrative costs (Schedule 7) 1,406,000
Net operating profit 610,664
Less: Interest expense (400)
Net income before taxes 611,064
Less: Provision for income taxes (35%) 213,872
Net income after taxes ₱ 397,192
SCHEDULE 10
Gilbert Manufacturing Company
Budgeted Statement of Financial Position
December 31, 2027
Assets Equities
Current assets Current Liabilities
Cash (Schedule 8) ₱ 135,657 Accounts Payable ₱ 275,000
Accounts receivable 3,745,000 Taxes payable 595,230
Inventories 651,000 Current portion of long - term debt 83,000
Other current assets 23,000 Total current liabilities 953,230
Total current assets 4,554,657 Long - term liabilities (171,000)
Total liabilities 782,230
Long - term assets
Property, plant and equipment 2,495,000 Equity
Less: Accumulated depreciation 3,103,000 Share capital 350,000
Net (608,000) Retained earnings 2,814,427
Total Equity 3,164,427

Total assets ₱ 3,946,657 Total liabilities and equity ₱ 3,946,657


YEAR 10
SCHEDULE 1
Sales Budget
For 2028
Units Price per Unit Total Sales Revenue
Estimated Sales: 6,400 800 ₱ 5,120,000

SCHEDULE 2
Production Budget
For 2028
Units to be sold 6,400
Add: Desired ending inventory 1,000
Total 7,400
Less: Beginning inventory 1,000
Units to be produced 6,400

SCHEDULE 3
Raw Materials Purchases
For 2028
Materials
R S
Units required for production
R ₱ 19,200
S ₱ 32,000
Add: Desired ending inventory 1,300 4,600
Total units required 20,500 36,600
Less: Beginning inventory 1,300 4,600
Units to be purchased 19,200 32,000
Unit price 10 30
Total Purchases 192,000 960,000
Total Purchases ₱ 1,152,000

SCHEDULE 4
Direct Labor Budget
For 2028
Number of units to be produced 6,400
Multiply by: Direct labor cost per unit 146
Total budgeted direct labor costs ₱ 934,400

SCHEDULE 5
Budgeted Manufacturing Overhead
For 2028
Variable overhead: units needed to produce 6,400
Indirect materials and supplies ₱ 37,440
Materials handling 58,048
Other indirect labor 32,448
Total 127,936

Fixed manufacturing overhead


Supervisor labor 175,000
Maintenance & repairs 85,000
Plant administration 173,000
Utilities 87,000
Depreciation 168,000
Insurance 43,000
Property taxes 117,000
Others 41,000
Total 889,000
Total manufacturing overhead ₱ 1,016,936
SCHEDULE 6
Budgeted Statement of Cost of Sales
For 2028
Beginning work in process inventory

Manufacturing Costs
Direct materials
Beginning inventory
Purchases
Total
Less: Ending inventory
Total Direct material cost
Direct labor
Manufacturing overhead
Total Manufacturing costs
Less: Ending work in process inventory
Cost of Goods Manufactured
Add: Beginning finished goods
Total available for sale
Less: Ending finished goods
Cost of sales
SCHEDULE 7
Budgeted Marketing and Administrative Costs
For 2028
Variable Marketing Costs
Sales commission (@P40.625) ₱ 260,000
Others (@P16.25) 104,000
Total 364,000

Fixed Marketing Costs


Sales salaries 100,000
Advertising 193,000
Others 78,000
Total 371,000
Total Marketing costs 735,000

Administrative Costs (all fixed)


Administrative salaries 254,000
Data processing services 103,000
Legal and other professional fees 180,000
Depreciation- building, furniture and equipment -
Taxes - other than income 108,000
Others 26,000
Total 671,000
Total marketing and administrative costs ₱ 1,406,000

SCHEDULE 8
Gilbert Manufacturing Company
Cash Budget
For the Budget Year Ending December 31, 2028
Cash balance, January 1, 2027 ₱ 135,657
Add: Estimated receipts
Collections from customers 4,500,000
Sale of assets
Total 4,500,000
Total cash available 4,635,657
Less: Estimated disbursements
Payments for material purchases 1,137,000
Direct labor 934,400
Manufacturing overhead 848,936
Marketing & Administrative expenses 1,398,960
Payments for income tax 100,000
Dividends 140,000
Reduction in long-term debt 83,000
Acquisition of new assets
Total disbursements 4,642,296
Cash balance, December 31 -₱ 6,639

SCHEDULE 9
Gilbert Manufacturing Company
Budgeted Income Statement
For the Budget Year Ending December 31, 2028
Sales (Schedule 1) ₱ 5,120,000
Less: Cost of sales (Schedule 6) 3,103,336
Gross profit 2,016,664
Less: Marketing and administrative costs (Schedule 7) 1,406,000
Net operating profit 610,664
Less: Interest expense (7,040)
Net income before taxes 617,704
Less: Provision for income taxes (35%) 216,196
Net income after taxes ₱ 401,508
SCHEDULE 10
Gilbert Manufacturing Company
Budgeted Statement of Financial Position
December 31, 2028
Assets Equities
Current assets Current Liabilities
Cash (Schedule 8) -₱ 6,639 Accounts Payable ₱ 290,000
Accounts receivable 4,365,000 Taxes payable 711,426
Inventories 651,000 Current portion of long - term debt 83,000
Other current assets 23,000 Total current liabilities 1,084,426
Total current assets 5,032,361 Long - term liabilities (254,000)
Total liabilities 830,426
Long - term assets
Property, plant and equipment 2,495,000 Equity
Less: Accumulated depreciation 3,271,000 Share capital 350,000
Net (776,000) Retained earnings 3,075,935
Total Equity 3,425,935

Total assets ₱ 4,256,361 Total liabilities and equity ₱ 4,256,361


SCHEDULE 1

Year 1 Year 2
Units 6,400 6,400
Price per unit 800 800
Total Sales Revenue ₱ 5,120,000 ₱ 5,120,000

SCHEDULE 2

Year 1 Year 2
Units to be sold 6,400 6,400
Add: Desired ending inventory 1,000 1,000
Total 7,400 7,400
Less: Beginning inventory 900 900
Units to be produced 6,500 6,500

SCHEDULE 3

Year 1
Materials
R S
Units required for production
R ₱ 19,500
S ₱ 32,500
Add: Desired ending inventory 1,300 4,600
Total units required 20,800 37,100
Less: Beginning inventory 2,200 4,000
Units to be purchased 18,600 33,100
Unit price 10 30
Total Purchases 186,000 993,000
Total Purchases ₱ 1,179,000

SCHEDULE 4

Year 1 Year 2
Number of units to be produced 6,500 6,500
Multiply by: Direct labor cost per unit 146 146
Total budgeted direct labor costs ₱ 949,000 ₱ 949,000

SCHEDULE 5

Year 1 Year 2
Variable overhead: units needed to produce 6,500 6,400
Indirect materials and supplies ₱ 38,025 ₱ 37,440
Materials handling 58,955 58,048
Other indirect labor 32,955 32,448
Total 129,935 127,936

Fixed manufacturing overhead


Supervisor labor 175,000 175,000
Maintenance & repairs 85,000 85,000
Plant administration 173,000 173,000
Utilities 87,000 87,000
Depreciation 280,000 344,000
Insurance 43,000 43,000
Property taxes 117,000 117,000
Others 41,000 41,000
Total 1,001,000 1,065,000
Total manufacturing overhead ₱ 1,130,935 ₱ 1,192,936

SCHEDULE 6

Year 1 Year 2
Beginning work in process inventory - -

Manufacturing Costs
Direct materials
Beginning inventory ₱ 142,000 ₱ 151,000
Purchases 1,179,000 1,152,000
Total 1,321,000 1,303,000
Less: Ending inventory 151,000 151,000
Total Direct material cost 1,170,000 1,152,000
Direct labor 949,000 934,400
Manufacturing overhead 1,130,935 1,192,936
Total Manufacturing costs 3,249,935 3,279,336
Less: Ending work in process inventory - -
Cost of Goods Manufactured 3,249,935 3,279,336
Add: Beginning finished goods 450,000 500,000
Total available for sale 3,699,935 3,779,336
Less: Ending finished goods 500,000 500,000
Cost of sales ₱ 3,199,935 ₱ 3,279,336
Sales Budget

Year 3 Year 4 Year 5 Year 6 Year 7


6,400 6,400 6,400 6,400 6,400
800 800 800 800 800
₱ 5,120,000 ₱ 5,120,000 ₱ 5,120,000 ₱ 5,120,000 ₱ 5,120,000

Production Budget

Year 3 Year 4 Year 5 Year 6 Year 7


6,400 6,400 6,400 6,400 6,400
1,000 1,000 1,000 1,000 1,000
7,400 7,400 7,400 7,400 7,400
900 900 900 900 900
6,500 6,500 6,500 6,500 6,500

Raw Materials

Year 2 Year 3 Year 4


Materials Materials Materials
R S R S R

₱ 19,200 ₱ 19,200 ₱ 19,200


₱ 32,000 ₱ 32,000
1,300 4,600 1,300 4,600 1,300
20,500 36,600 20,500 36,600 20,500
1,300 4,600 1,300 4,600 1,300
19,200 32,000 19,200 32,000 19,200
10 30 10 30 10
192,000 960,000 192,000 960,000 192,000
₱ 1,152,000 ₱ 1,152,000 ₱ 1,152,000

Direct Labor Budget

Year 3 Year 4 Year 5 Year 6 Year 7


6,500 6,500 6,500 6,500 6,500
146 146 146 146 146
₱ 949,000 ₱ 949,000 ₱ 949,000 ₱ 949,000 ₱ 949,000

Budgeted Manufacturing Overhead

Year 3 Year 4 Year 5 Year 6 Year 7


6,400 6,400 6,400 6,400 6,400
₱ 37,440 ₱ 37,440 ₱ 37,440 ₱ 37,440 ₱ 37,440
58,048 58,048 58,048 58,048 58,048
32,448 32,448 32,448 32,448 32,448
127,936 127,936 127,936 127,936 127,936

175,000 175,000 175,000 175,000 175,000


85,000 85,000 85,000 85,000 85,000
173,000 173,000 173,000 173,000 173,000
87,000 87,000 87,000 87,000 87,000
344,000 344,000 168,000 168,000 168,000
43,000 43,000 43,000 43,000 43,000
117,000 117,000 117,000 117,000 117,000
41,000 41,000 41,000 41,000 41,000
1,065,000 1,065,000 889,000 889,000 889,000
₱ 1,192,936 ₱ 1,192,936 ₱ 1,016,936 ₱ 1,016,936 ₱ 1,016,936

Budgeted Statement of Cost of Sales

Year 3 Year 4 Year 5 Year 6 Year 7


- - - - -

₱ 151,000 ₱ 151,000 ₱ 151,000 ₱ 151,000 ₱ 151,000


1,152,000 1,152,000 1,152,000 1,152,000 1,152,000
1,303,000 1,303,000 1,303,000 1,303,000 1,303,000
151,000 151,000 151,000 151,000 151,000
1,152,000 1,152,000 1,152,000 1,152,000 1,152,000
934,400 934,400 934,400 934,400 934,400
1,192,936 1,192,936 1,016,936 1,016,936 1,016,936
3,279,336 3,279,336 3,103,336 3,103,336 3,103,336
- - - - -
3,279,336 3,279,336 3,103,336 3,103,336 3,103,336
500,000 500,000 500,000 500,000 500,000
3,779,336 3,779,336 3,603,336 3,603,336 3,603,336
500,000 500,000 500,000 500,000 500,000
₱ 3,279,336 ₱ 3,279,336 ₱ 3,103,336 ₱ 3,103,336 ₱ 3,103,336
Year 8 Year 9 Year 10
6,400 6,400 6,400
800 800 800
₱ 5,120,000 ₱ 5,120,000 ₱ 5,120,000

Year 8 Year 9 Year 10


6,400 6,400 6,400
1,000 1,000 1,000
7,400 7,400 7,400
900 900 900
6,500 6,500 6,500

Raw Materials Purchases

Year 4 Year 5 Year 6


Materials Materials Materials
S R S R S

₱ 19,200 ₱ 19,200
₱ 32,000 ₱ 32,000 ₱ 32,000
4,600 1,300 4,600 1,300 4,600
36,600 20,500 36,600 20,500 36,600
4,600 1,300 4,600 1,300 4,600
32,000 19,200 32,000 19,200 32,000
30 10 30 10 30
960,000 192,000 960,000 192,000 960,000
₱ 1,152,000 ₱ 1,152,000

Year 8 Year 9 Year 10


6,500 6,500 6,500
146 146 146
₱ 949,000 ₱ 949,000 ₱ 949,000

Year 8 Year 9 Year 10


6,400 6,400 6,400
₱ 37,440 ₱ 37,440 ₱ 37,440
58,048 58,048 58,048
32,448 32,448 32,448
127,936 127,936 127,936

175,000 175,000 175,000


85,000 85,000 85,000
173,000 173,000 173,000
87,000 87,000 87,000
168,000 168,000 168,000
43,000 43,000 43,000
117,000 117,000 117,000
41,000 41,000 41,000
889,000 889,000 889,000
₱ 1,016,936 ₱ 1,016,936 ₱ 1,016,936

Year 8 Year 9 Year 10


- - -

₱ 151,000 ₱ 151,000 ₱ 151,000


1,152,000 1,152,000 1,152,000
1,303,000 1,303,000 1,303,000
151,000 151,000 151,000
1,152,000 1,152,000 1,152,000
934,400 934,400 934,400
1,016,936 1,016,936 1,016,936
3,103,336 3,103,336 3,103,336
- - -
3,103,336 3,103,336 3,103,336
500,000 500,000 500,000
3,603,336 3,603,336 3,603,336
500,000 500,000 500,000
₱ 3,103,336 ₱ 3,103,336 ₱ 3,103,336
Year 7 Year 8 Year 9
Materials Materials Materials
R S R S R S

₱ 19,200 ₱ 19,200 ₱ 19,200


₱ 32,000 ₱ 32,000 ₱ 32,000
1,300 4,600 1,300 4,600 1,300 4,600
20,500 36,600 20,500 36,600 20,500 36,600
1,300 4,600 1,300 4,600 1,300 4,600
19,200 32,000 19,200 32,000 19,200 32,000
10 30 10 30 10 30
192,000 960,000 192,000 960,000 192,000 960,000
₱ 1,152,000 ₱ 1,152,000 ₱ 1,152,000
Year 10
Materials
R S

₱ 19,200
₱ 32,000
1,300 4,600
20,500 36,600
1,300 4,600
19,200 32,000
10 30
192,000 960,000
₱ 1,152,000

You might also like