excel assignment
rfeliz12
Support_EX19_EOM5-1_2021.xlsx2021 Summary
| Profit and Loss Statement | ||||
| For the year 2021 | ||||
| Stated in 000s | ||||
| Category | Total 2021 | Total Budget | % Change from Budget | |
| Revenue | $ 579,075 | $ 580,250 | -0.2% | |
| Cost of sales | 162,890 | 163,132 | -0.1% | |
| Payroll | ||||
| Salaries | 143,000 | 143,000 | 0.0% | |
| Benefits | 69,780 | 69,500 | 0.4% | |
| Taxes | 38,025 | 37,235 | 2.1% | |
| Operating Expenses | ||||
| Sales and marketing | 50,046 | 50,250 | -0.4% | |
| General and administrative | 64,128 | 65,245 | -1.7% | |
| Other operating | 41,754 | 42,057 | -0.7% | |
| Summary | ||||
| Gross profit | 416,185 | 417,118 | -0.2% | |
| Total expenses | 406,733 | 407,287 | -0.1% | |
| Net profit | $ 9,452 | $ 9,831 | -3.9% | |
