• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Ticket Based Fixed and Variable Pricing

A

add7000

New Member
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 e.g. for S1 type 2 hrs for S2 6 hrs etc.


In a month, there are volume of tickets received with different types and this volume differs month to month.


So requirement is that there needs to be a baseline for Fixed price and then variable price if it goes beyond the baseline.


If anyone has developed such excel template then can you please share the same.
 
Hi Apruva,


What is your baseline? Are you taking it in terms of dollar amount or hours??


Faseeh
 
Hi Apurva,


This is what i have understood by reading


http://wiki.answers.com/Q/What_is_ticket_based_pricing


see this file:


http://dl.dropbox.com/u/60644346/Ticket%20Based%20Pricing.xlsx


Regards,


Faseeh
 
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 amount.


e.g. if Avg tickets per month are 800 where time spend to resolve is say suppose 3200 hrs. So multiple 3200 with Y amount per hour and arrive at Fixed price.


then for next 100 tickets Z amount will be charge in addition to Y which is a fixed price.
 
Hi Apurva,


There is a problem in your last post (or i am unable to understand it).


1. You have tickets as base line, eg. 800 for a customer.

2. You have an avg. hrs number attached to it lets say 3200 hrs.

3. If the Customer DONOT cross 800 tickets, it will be charged for 3200 hrs.

4. If the Customer Does Cross 800 tickets (lets say 900 tickets), it will be charged for 800 tickets (3200 hrs) fixed plus 100 tickets charged at corresponding hrs.


Is the above description correct?


Lastly i uploaded a file for your problem, have you checked it?? Please comment on that as well.


Regards,
 
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 (whatever value of that 3200 hrs) and for 100 tickets it will be variable fee.


Regards
 
Hi Apurva,


Please see this file, i suggest you to cross check formulas manually so that its result could be confirmed:


http://dl.dropbox.com/u/60644346/Ticket%20Based%20Pricing%20Revised.xlsx


Faseeh
 
You must log in or register to reply here.
Back
Top