Budget
Plan the year by account and by product, then compare it with what happened.
Demo: a budget made from last year + 10%. Sign up to build your own.
Original · ApprovedApproved on 2026-01-05
Approved budgets are locked. Add a revision to change it.
Year to date, profit is 18.6% above budget.
| Account | Month · Actual | Budget | Difference | Year to date · Actual | Budget | Difference | % | Full-year outlook | Full-year budget |
|---|---|---|---|---|---|---|---|---|---|
| Revenue | EGP 1.1M | EGP 952K | EGP 114K (better) | EGP 9.5M | EGP 9.0M | EGP 533K (better) | 5.94% (better) | EGP 12.7M | EGP 12.1M |
| Cost of Sales · Variable | EGP 581K | EGP 519K | EGP 62K (worse) | EGP 5.2M | EGP 4.8M | EGP 351K (worse) | 7.27% (worse) | EGP 6.9M | EGP 6.6M |
| 500900 Depreciation – Warehouse Equipment | EGP 5K | EGP 6K | -EGP 500 (better) | EGP 45K | EGP 46K | -EGP 1K (better) | -2.91% (better) | EGP 62K | EGP 63K |
| 610100 Sales Commissions | EGP 29K | EGP 26K | EGP 3K (worse) | EGP 262K | EGP 241K | EGP 21K (worse) | 8.77% (worse) | EGP 349K | EGP 328K |
| 610200 Delivery & Packaging | EGP 16K | EGP 15K | EGP 1K (worse) | EGP 142K | EGP 143K | -EGP 2K (better) | -1.08% (better) | EGP 189K | EGP 191K |
| 610300 Bank Charges & Card Fees | EGP 8K | EGP 7K | EGP 1K (worse) | EGP 71K | EGP 70K | EGP 2K (worse) | 2.27% (worse) | EGP 95K | EGP 93K |
| 620100 Salaries & Wages | EGP 142K | EGP 159K | -EGP 17K (better) | EGP 1.3M | EGP 1.2M | EGP 27K (worse) | 2.17% (worse) | EGP 1.7M | EGP 1.7M |
| 620200 Office Rent | EGP 39K | EGP 42K | -EGP 3K (better) | EGP 355K | EGP 375K | -EGP 19K (better) | -5.12% (better) | EGP 483K | EGP 502K |
| 620300 Marketing | EGP 22K | EGP 24K | -EGP 2K (better) | EGP 198K | EGP 204K | -EGP 6K (better) | -3.01% (better) | EGP 270K | EGP 276K |
| 620400 Professional Fees | EGP 15K | EGP 16K | -EGP 217 (better) | EGP 133K | EGP 129K | EGP 4K (worse) | 2.74% (worse) | EGP 181K | EGP 177K |
| 620500 Utilities | EGP 12K | EGP 13K | -EGP 897 (better) | EGP 110K | EGP 116K | -EGP 6K (better) | -5.45% (better) | EGP 149K | EGP 156K |
| 620600 Insurance | EGP 7K | EGP 8K | -EGP 651 (better) | EGP 67K | EGP 69K | -EGP 2K (better) | -2.47% (better) | EGP 91K | EGP 93K |
| 620700 IT & Software | EGP 7K | EGP 8K | -EGP 352 (better) | EGP 67K | EGP 64K | EGP 2K (worse) | 3.54% (worse) | EGP 91K | EGP 89K |
| 710100 Rental Income | EGP 10K | EGP 11K | -EGP 1K (worse) | EGP 90K | EGP 96K | -EGP 6K (worse) | -5.76% (worse) | EGP 123K | EGP 129K |
| 720100 Foreign Exchange Losses | EGP 18K | EGP 20K | -EGP 2K (better) | EGP 161K | EGP 166K | -EGP 6K (better) | -3.47% (better) | EGP 220K | EGP 225K |
| 720200 Bad Debts Written Off | EGP 12K | EGP 13K | -EGP 1K (better) | EGP 109K | EGP 106K | EGP 4K (worse) | 3.41% (worse) | EGP 149K | EGP 146K |
| 730100 Bank Interest Received | EGP 1K | EGP 1K | -EGP 100 (worse) | EGP 9K | EGP 10K | -EGP 550 (worse) | -5.76% (worse) | EGP 12K | EGP 13K |
| 740100 Loan Interest | EGP 21K | EGP 23K | -EGP 2K (better) | EGP 189K | EGP 195K | -EGP 6K (better) | -2.91% (better) | EGP 258K | EGP 264K |
| 750100 Income Tax Expense | EGP 25K | EGP 28K | -EGP 3K (better) | EGP 225K | EGP 220K | EGP 6K (worse) | 2.51% (worse) | EGP 308K | EGP 302K |
| Net profit | EGP 1.0M | EGP 853K | EGP 159K (better) | 18.65% (better) |
Products: volume and price
Volume: (actual units − budget units) × budget price. Price: (actual price − budget price) × actual units. Together they make the difference.
| Product | Units · Budget | Units · Actual | Budget | Actual | Volume effect | Price effect |
|---|---|---|---|---|---|---|
| Oxygen Concentrator 10L | 4.4 | 44 | EGP 150K | EGP 1.5M | EGP 1.3M | -EGP 4K |
| Hospital Bed Electric | 2.2 | 31 | EGP 78K | EGP 1.1M | EGP 1.0M | EGP 38K |
| Patient Monitor 7-inch | 6.6 | 43 | EGP 179K | EGP 1.2M | EGP 985K | EGP 40K |
| Oxygen Concentrator 5L | 22 | 68 | EGP 438K | EGP 1.4M | EGP 916K | EGP 68K |
| CPAP Machine | 5.5 | 41 | EGP 140K | EGP 1.1M | EGP 901K | EGP 10K |
| BiPAP Machine | 15.4 | 34 | EGP 601K | EGP 1.4M | EGP 726K | EGP 70K |
| Annual Maintenance Contract | 2.2 | 30 | EGP 24K | EGP 368K | EGP 303K | EGP 41K |
| Anti-Decubitus Mattress | 1.1 | 26 | EGP 8K | EGP 200K | EGP 180K | EGP 13K |
| Pulse Oximeter | 25.3 | 126 | EGP 43K | EGP 224K | EGP 170K | EGP 11K |
| Full Face Mask | 24.2 | 86 | EGP 58K | EGP 223K | EGP 149K | EGP 16K |
| Nasal Cannula (box of 50) | 0 | 108 | EGP 0 | EGP 162K | EGP 0 | EGP 162K |
| Wheelchair Standard | 9.9 | 33 | EGP 59K | EGP 218K | EGP 138K | EGP 21K |
| Blood Pressure Monitor | 37.4 | 81 | EGP 88K | EGP 191K | EGP 102K | EGP 464 |
| Device Rental (month) | 0 | 27 | EGP 0 | EGP 93K | EGP 0 | EGP 93K |
| Bacterial Filter (box of 25) | 17.6 | 48 | EGP 21K | EGP 56K | EGP 36K | -EGP 882 |
| Humidifier Chamber | 28.6 | 65 | EGP 25K | EGP 58K | EGP 32K | EGP 1K |