Need help with Ratio need nto understand the math for this
melee8
itbudget..xlsoperating budget
| Information Technology | |||||||||||||
| Operating Budget - FY | |||||||||||||
| Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Total | |
| Compensation | |||||||||||||
| Wages | $ 38,333 | $ 38,333 | $ 38,333 | $ 38,333 | $ 38,333 | $ 38,333 | $ 38,333 | $ 38,333 | $ 38,333 | $ 38,333 | $ 38,333 | $ 38,333 | $ 459,996 |
| Benefits | $ 8,625 | $ 8,625 | $ 8,625 | $ 8,625 | $ 8,625 | $ 8,625 | $ 8,625 | $ 8,625 | $ 8,625 | $ 8,625 | $ 8,625 | $ 8,625 | $ 103,499 |
| Total | $ 46,958 | $ 46,958 | $ 46,958 | $ 46,958 | $ 46,958 | $ 46,958 | $ 46,958 | $ 46,958 | $ 46,958 | $ 46,958 | $ 46,958 | $ 46,958 | $ 563,495 |
| Travel | $ 2,500 | $ 2,500 | $ 2,500 | $ 2,500 | $ 2,500 | $ 2,500 | $ 2,500 | $ 2,500 | $ 2,500 | $ 2,500 | $ 2,500 | $ 2,500 | $ 30,000 |
| Postage | $ 150 | $ 150 | $ 150 | $ 150 | $ 150 | $ 150 | $ 150 | $ 150 | $ 150 | $ 150 | $ 150 | $ 150 | $ 1,800 |
| Subscriptions | $ 2,500 | $ 100 | $ 250 | $ 300 | $ 3,150 | ||||||||
| Seminars | $ 3,000 | $ 3,000 | $ 6,000 | ||||||||||
| Contracts (Smith Consulting) | $ 1,505,333 | $ 1,505,333 | $ 1,505,333 | $ 1,505,333 | $ 1,505,333 | $ 1,505,333 | $ 1,505,333 | $ 1,505,333 | $ 1,505,333 | $ 1,505,333 | $ 1,505,333 | $ 1,505,333 | $ 18,064,000 |
| Office Supplies | $ 75 | $ 75 | $ 75 | $ 75 | $ 75 | $ 75 | $ 75 | $ 75 | $ 75 | $ 75 | $ 75 | $ 75 | $ 900 |
| Total | $ 1,557,516 | $ 1,555,116 | $ 1,558,016 | $ 1,555,016 | $ 1,555,266 | $ 1,555,016 | $ 1,555,016 | $ 1,558,016 | $ 1,555,316 | $ 1,555,016 | $ 1,555,016 | $ 1,555,016 | $ 18,669,345 |
Wages and benefits
| Wages and Benefits Analysis - Drivers | ||||||||
| Wages | Rate | Avg. Miles Driven Per Year | Avg. Weekly Wage | Avg. Annual Wage | # of Drivers | Annual Cost for Drivers (000s) | % of Annual Wages | % of Sales ($620,000,000) |
| Wages (per mile driven) | $0.50 | 110,000 | $1,058 | $55,000 | 3,400 | $187,000 | 30.20% | |
| Paid Vacation (based on seniority) | $1,058 | $2,115 | $7,192 | 3.80% | 1.20% | |||
| Paid Holidays | $1,058 | $2,115 | $7,192 | 3.80% | 1.20% | |||
| Paid Sick Days | $1,058 | $1,058 | $3,596 | 1.90% | 0.60% | |||
| Health & Welfare Contributions | $9,194 | $31,258 | 16.70% | 5.00% | ||||
| Pension Fund Contributions | $8,840 | $30,056 | 16.10% | 4.80% | ||||
| FICA Match | $3,738 | $12,709 | 6.80% | 2.00% | ||||
| Medicare Match | $874 | $2,972 | 1.60% | 0.50% | ||||
| FUTA Contributions | $434 | $1,476 | 0.80% | 0.20% | ||||
| SUTA Contributions | $585 | $1,989 | 1.10% | 0.30% | ||||
| Workers' Compensation | $12,400 | 6.60% | 2.00% | |||||
| Average annual cost | $83,953 | $297,841 | 59.30% | 48.00% | ||||
| Total Payroll | Less Drivers | Remaining Salaries | # of remaining employees | Avg. per employee | ||||
| (000s) | (000s) | (000s) | ||||||
| $386,896 | $297,841 | $89,055 | 1,800 | $49,475 |
