Forecast Tickets using Budget

[jschena]

Hello,

I have my forecast for each month in 2014 of my budget. I want to forecast how many tickets I will be able to produce with that budget amount. I have the historical data from 2013 to use. I want to forecast how many tickets I will have February 2014 - December 2014. Is there any way to do this in excel?

For example:

[TABLE="class: outer_border, width: 299"]
<tbody>[TR]
[TD]Month[/TD]
[TD]Budget[/TD]
[TD]Tickets[/TD]
[/TR]
[TR]
[TD]Jan-13[/TD]
[TD="align: right"]$90[/TD]
[TD="align: right"]16[/TD]
[/TR]
[TR]
[TD]Feb-13[/TD]
[TD="align: right"]$67[/TD]
[TD="align: right"]13[/TD]
[/TR]
[TR]
[TD]Mar-13[/TD]
[TD="align: right"]$87[/TD]
[TD="align: right"]22[/TD]
[/TR]
[TR]
[TD]Apr-13[/TD]
[TD="align: right"]$83[/TD]
[TD="align: right"]15[/TD]
[/TR]
[TR]
[TD]May-13[/TD]
[TD="align: right"]$98[/TD]
[TD="align: right"]23[/TD]
[/TR]
[TR]
[TD]Jun-13[/TD]
[TD="align: right"]$75[/TD]
[TD="align: right"]9[/TD]
[/TR]
[TR]
[TD]Jul-13[/TD]
[TD="align: right"]$86[/TD]
[TD="align: right"]13[/TD]
[/TR]
[TR]
[TD]Aug-13[/TD]
[TD="align: right"]$70[/TD]
[TD="align: right"]23[/TD]
[/TR]
[TR]
[TD]Sep-13[/TD]
[TD="align: right"]$60[/TD]
[TD="align: right"]7[/TD]
[/TR]
[TR]
[TD]Oct-13[/TD]
[TD="align: right"]$62[/TD]
[TD="align: right"]3[/TD]
[/TR]
[TR]
[TD]Nov-13[/TD]
[TD="align: right"]$42[/TD]
[TD="align: right"]11[/TD]
[/TR]
[TR]
[TD]Dec-13[/TD]
[TD="align: right"]$47[/TD]
[TD="align: right"]12[/TD]
[/TR]
[TR]
[TD]Jan-14[/TD]
[TD="align: right"]$52[/TD]
[TD="align: right"]3[/TD]
[/TR]
[TR]
[TD]Feb-14[/TD]
[TD="align: right"]$67[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Mar-14[/TD]
[TD="align: right"]$71[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Apr-14[/TD]
[TD="align: right"]$75[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]May-14[/TD]
[TD="align: right"]$75[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Jun-14[/TD]
[TD="align: right"]$71[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Jul-14[/TD]
[TD="align: right"]$78[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Aug-14[/TD]
[TD="align: right"]$71[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Sep-14[/TD]
[TD="align: right"]$75[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Oct-14[/TD]
[TD="align: right"]$78[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Nov-14[/TD]
[TD="align: right"]$61[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Dec-14[/TD]
[TD="align: right"]$85[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[etaf]

do you have an average price of tickets
as looking at that table
the average ticket price per month varies from $20.67 to $3.04
and average of $7.45 for the year