Selling and Administrative Expenses Budget

Sales 5,991,312,000 4,364,528,750 4,889,317,000

Marketing and Promotion 50,000,000 48,000,000 45,000,000
Sales Commissions 30,000,000 28,000,000 25,000,000
Salaries and Benefits 40,000,000 38,000,000 35,000,000
Office Supplies 2,000,000 1,800,000 1,600,000
Other Administrative Costs 10,000,000 9,000,000 8,000,000
Total Selling and Administrative Expenses 132,000,000 124,800,000 114,600,000

Cash Receipts Budget

2022 2021 2020
Cash Sales 2,395,656,000 1,745,811,500 1,955,727,600
Collections from Credit Sales 3,595,656,000 2,618,717,250 2,933,589,400
Other Income 200,000,000 200,000,000 200,000,000
Total Cash Receipts 6,191,312,000 4,564,528,750 5,089,317,000

Cash Disbursements Budget

2022 2021 2020
Rent 2,500,000 2,200,000 2,000,000
Utilities 1,000,000 900,000 800,000
Loan Repayments 5,000,000 4,500,000 4,000,000
Other Financial Obligations 2,500,000 2,300,000 2,200,000
Total Cash Disbursements 11,000,000 9,900,000 9,000,000

Cash Budget (Combined)

Budget 2022 2021 2020
Total Cash Receipts 6,191,312,000 4,564,528,750 5,089,317,000
Total Cash Disbursements -11,000,000 -9,900,000 -9,000,000

Indirect Material Budget

2022 2021 2020
Indirect Materials for
Production
Supplies 500,000 480,000 450,000
Lubricants 300,000 280,000 250,000
Other Indirect Materials 150,000 140,000 130,000
Total Indirect Material Costs 950,000 900,000 830,000
Total Indirect Labor Costs 2,000,000 1,910,000 1,800,000
 Sales Budget
2022 2021 2020

Budgeted Sales (units) 3,994,208 3,491,623 4,889,317

Selling price per unit 1500 1250 1000
Total Revenue 5,991,312,000 4,364,528,750 4,889,317,000

Indirect Labor Budget 2022 2021 2020

Indirect Labor Costs
Personnel Wages 1,200,000 1,150,000 1,100,000
Benefits 500,000 480,000 450,000
Other Indirect Labor Expenses 300,000 280,000 250,000
Total Indirect Labor Costs 2,000,000 1,910,000 1,800,000

Production Budget 2022 2021 2020

Sales 3,994,208 3,491,623 4,889,317

Add: Desired Ending
479,305 418,995 586,718
Inventory
Total Production Required 3,514,903 3,072,628 4,302,599
Less: Beginning Inventory 258,825 226,257 316,828
Units to be produced 3,256,078 2,846,371 3,985,771
Less: Beginning Inventory 258,825 226,257 316,828
Units to be produced 3,256,078 2,846,371 3,985,771
 Direct Material Budget 2022 2021 2020

Production in Units 3,256,078 2,846,371 3,985,771

Materials per Unit 625 550 350
Production Needs 2,035,048,750 1,565,504,050 1,395,019,850
Add: Desired Ending
479,305 418,995 586,718
Inventory
Total Needed 2,035,528,055 1,565,923,045 1,395,606,568
Less: Beginning Inventory 258,825 226,257 316,828
Material to be purchased 2,035,269,230 1,565,696,788 1,395,289,740

Direct Labor Budget 2022 2021 2020

Production in Units 3,256,078 2,846,371 3,985,771

Direct Labor Hours 0.75 0.75 0.75
Labor Hours Required 2,442,059 2,134,778 2,989,328
Wage Rate 200 185 170
Total Direct Labor
488,411,700 394,933,976 508,185,803
Cost

Overhead Budget 2022 2021 2020

Indirect Material 1,689,273,461 1,299,528,334 1,158,090,484

Indirect Labor 263,742,318 213,264,347 274,420,333
Travelling and Conveyance 5,274,846 4,265,287 5,488,407
Communication Expense 2,162,687 1,748,768 2,250,247
Fuel and Power 395,613,477 319,896,521 411,630,500
Freight 79,122,695 63,979,304 82,326,100
Processing Charges 188,707,629 152,590,640 196,347,748
Packing, Sizing and lubricants
consumed 326,464,197 263,981,808 339,681,604
Stationary Expense 100,000 85,000 73,000
Utilities 3,344,501 2,704,393 3,479,908
Miscellaneous Expense 754,895 641,660 551,073
Total Overhead Budget 2,974,341,380 2,338,680,887 2,494,920,929
Budgeted COGS 2022 2021 2020

Beginning Material Inventory 161,765,625 124,441,350 110,889,800

2,035,269,23 1,565,696,78 1,395,289,74
Add: Materials Purchased
0 8 0
2,197,034,85 1,690,138,13 1,506,179,54
Materials Available for use
5 8 0
Less: Ending Material Inventory 299,565,625 230,447,250 205,351,300
1,897,469,23 1,459,690,88 1,300,828,24
Direct Material Used
0 8 0
Direct Labor Used 488,411,700 394,933,976 508,185,803
2,974,341,38 2,338,680,88 2,494,920,92
Manufacturing Overhead
0 7 9
5,360,222,31 4,193,305,75 4,303,934,97
Total Manufacturing Costs
0 2 2
Add: Beginning Work in Process
95,669,862 119,369,187 138,176,521
Inventory
5,455,892,17 4,312,674,93 4,442,111,49
Subtotal
2 9 3
Less: Ending Work in Process 148,794,875 95,669,862 119,369,187
5,307,097,29 4,217,005,07 4,322,742,30
Cost of Goods Manufactured
7 7 6
Add: Beginning Finished Goods Inventory 919,095,641 564,063,316 760,315,911
6,226,192,93 4,781,068,39 5,083,058,21
Cost of Goods Available for Use
8 3 7
Less: Ending Finished Goods
972,457,856 919,095,641 564,063,316
Inventory
5,253,735,08 3,861,972,75 4,518,994,90
Cost of Goods Sold
2 2 1
Budgeted Income Statement 2022 2021 2020

Sales 5,991,312,000 4,364,528,750 4,889,317,000

Cost of Sales 5,253,735,082 3,861,972,752 4,518,994,901
Gross Profit 737,576,918 502,555,998 370,322,099
Distribution Cost 257,273,600 162,824,400 107,984,800
Administrative Expenses 109,214,400 82,712,000 62,150,000
Other Operating Expenses 39,114,000 21,952,000 8,044,200
Other Operating Income 16,065,000 29,971,500 5,400,000
Profit/Loss from Operations 348,039,918 265,039,098 197,543,099
Finance Cost 89,520,000 134,998,200 160,014,000
Profit/Loss before Taxation 258,519,918 130,040,898 37,529,099
Taxation 74,970,776 37,711,861 10,883,439
Profit/Loss after Taxation 183,549,142 92,329,038 26,645,661