crackers85
New Member
- Joined
- Apr 27, 2020
- Messages
- 5
- Office Version
- 365
- Platform
- Windows
Hi Everyone,
I have fairly basic excel knowledge and was looking for some help regarding new starters that would affect budgets. What i want to do is be able to select from a drop down a a job title and a month start. This would then generate a cost for the rest of the year based on the month start plus some additional costs. On one tab I have the drop downs for Job Role and Month created and then in another tab i have all the costs listed, looking like this:
If i have a cost column in the first tab beside job role and month start, what formula would i need to work out the annual cost, depending on start date. Everyone gets a laptop, however only some roles get phones.
Any help greatly appreciated.
I have fairly basic excel knowledge and was looking for some help regarding new starters that would affect budgets. What i want to do is be able to select from a drop down a a job title and a month start. This would then generate a cost for the rest of the year based on the month start plus some additional costs. On one tab I have the drop downs for Job Role and Month created and then in another tab i have all the costs listed, looking like this:
Employee Type | Salary + NI + Pension | Month Start | Additional Items Fixed | Cost | Oter Items Monthly | Annual Cost | Software Suscriptions | Cost |
Head of Business | £ 70,680.00 | January | Laptop | £ 850.00 | Phone | £ 600.00 | WebHR | £ 42.00 |
Implementation Manager | £ 38,285.00 | February | Tablet | £ 200.00 | Teamwork | £ 144.00 | ||
Senior Developer | £ 47,120.00 | March | Bag | £ 30.00 | Lucid Chart | £ 90.00 | ||
Junior Developer | £ 29,450.00 | April | Mouse | £ 15.00 | SmartSheets | £ 240.00 | ||
Business Graduate | £ 22,383.00 | May | Microsoft | £ 192.00 | ||||
Customer Support | £ 24,738.00 | June | Freshdesk / Freshchat | £ 612.00 | ||||
Australian Implementation Manager | £ 62,963.00 | July | ||||||
August | ||||||||
September | ||||||||
October | ||||||||
November | ||||||||
December |
If i have a cost column in the first tab beside job role and month start, what formula would i need to work out the annual cost, depending on start date. Everyone gets a laptop, however only some roles get phones.
Any help greatly appreciated.