Table 2.
Revenue | ||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Number of applications for emptying | 208 | |||||||||||||
Average trips required per emptying (application) | 3.5 | |||||||||||||
Emptying fee per trip | 1000 | |||||||||||||
Revenue | 728,000 | |||||||||||||
No. | Description | February 2018 | March 2018 | April 2018 | May 2018 | June 2018 | July 2018 | August 2018 | September 2018 | October 2018 | November 2018 | December 2018 | January 2019 | Cumulative |
1 | Revenue | 60,667 | 60,667 | 60,667 | 60,667 | 60,667 | 60,667 | 60,667 | 60,667 | 60,667 | 60,667 | 60,667 | 60,667 | 728,000 |
Expenses | ||||||||||||||
Driver per trip | 300 | |||||||||||||
Helper per trip | 150 | |||||||||||||
Total personnel expenses (1 driver and 2 helpers) | 436,800 | |||||||||||||
No. | Description | February 2018 | March 2018 | April 2018 | May 2018 | June 2018 | July 2018 | August 2018 | September 2018 | October 2018 | November 2018 | December 2018 | January 2019 | Cumulative |
1 | Personal expenses | 36,400 | 36,400 | 36,400 | 36,400 | 36,400 | 36,400 | 36,400 | 36,400 | 36,400 | 36,400 | 36,400 | 36,400 | 436,800 |
2 | Fuel expenses | 7100 | 7750 | 8550 | 6150 | 3200 | 5150 | 3700 | 4800 | 1100 | 4950 | 4700 | 2400 | 59,550 |
3 | Maintenance expenses | 5150 | 2700 | 12,200 | 9,000 | 4,000 | 5,850 | 600 | 3,000 | 500 | 24,550 | 10,220 | 77,770 | |
4 | Other expenses—communication | 300 | 300 | 300 | 300 | 300 | 300 | 300 | 300 | 300 | 300 | 300 | 300 | 3600 |
5 | Other expenses—protective gears | 1500 | 1500 | 1500 | 4500 | |||||||||
Total cost | 50,450 | 48,650 | 58,950 | 51,850 | 43,900 | 47,700 | 41,000 | 44,500 | 38,300 | 66,200 | 41,400 | 49,320 | 582,220 | |
Cash Flows | ||||||||||||||
No. | Description | February 2018 | March 2018 | April 2018 | May 2018 | June 2018 | July 2018 | August 2018 | September 2018 | October 2018 | November 2018 | December 2018 | January 2019 | Cumulative |
1 | Revenue | 60,667 | 60,667 | 60,667 | 60,667 | 60,667 | 60,667 | 60,667 | 60,667 | 60,667 | 60,667 | 60,667 | 60,667 | 728,000 |
2 | Expenses | 50,450 | 48,650 | 58,950 | 51,850 | 43,900 | 47,700 | 41,000 | 44,500 | 38,300 | 66,200 | 41,400 | 49,320 | 582,220 |
3 | Profit/loss | 10,217 | 12,017 | 1717 | 8817 | 16,767 | 12,967 | 19,667 | 16,167 | 22,367 | −5533 | 19,267 | 11,347 | 145,780 |