Hi,
Does anyone have IT Incident Status Dashboard in excel where it can display Incident Status by category, Priority, Support staff and also Top 5 incident etc.
Regards
ADD
Hi Faseeh,
Yes, I did check the file you have uploaded and it gave me some idea on calculation.
Your understanding of problem is right that if customer does not cross 800 tickets still it will be charged for 3200 hrs. And if it goes to 900 then he should be charged for 3200 hrs as fixed...
Baseline will be Tickets. Generally that gives flexibility to customer as Fixed price is based on Avg. Volume of ticket received and variable price will be the increase in volume which goes beyond fixed price.
So when pricing is done, it will definitely have to convert Ticket volume to dollar...
Hi,
Has anyone developed an excel template for calculating Ticket Based Fixed and Variable pricing.
Requirement is as below:
For any Application Support, user logs the ticket. Every ticket will have type of severity attached to it like S1, S2, S3.... For each type of ticket there are SLAs...