///////////////////////////////////////////////////////////////////////////////
/////////////////////CUSTOMER AQUISITION CALCULATOR:///////////////////////////
/////////////////////javascript file:   calc.js      //////////////////////////
//////designed for: Tom Mackel by: Ian Lin of Jafty Interactive Designs////////
/////////////////////////////// www.jafty.com /////////////////////////////////
//////////////////////////// linian11@yahoo.com////////////////////////////////
////////////////////////////// (330)858-9743 //////////////////////////////////
///////////////////////////////////////////////////////////////////////////////
//THE CODE IN THIS JS SECT IS ALL FOR FIGURING RESULTS OF CALC OTHER JS IS BELOW THE HTML:
//Calc_js was created by: Ian Lin of Jafty Interactive Designs. www.jafty.com copyright 2009
//put the whole code block into a function to exec. when submited:
function docalc() {

//FIRST, GET ALL VALUES INTO VARS FROM CALC FORM and turn them into yearly values:

var avg_sale = document.cform.sale.value;
var repeat_visits = document.cform.visits.value; 
var yearly_repeat_visits = repeat_visits;         //yearly visits...
var customer_lifetime = document.cform.lifetime.value;
//var new_customers = document.cform.desired.value; //taken out on clients request!
var mail_pieces1 = document.cform.mail.value;
var mail_pieces = mail_pieces1 * 12;                   //yearly mail pieces.
var gifts_used1 = document.cform.gift.value;
var gifts_used = gifts_used1;                     //yearly gift cert. used.
var gift_cost = document.cform.cost.value;
var mail_cost = document.cform.postage.value;


//make sure all results are number types:
var avg_sale = avg_sale*1;
var repeat_visits = repeat_visits*1; 
var yearly_repeat_visits = yearly_repeat_visits*1;         //yearly visits...
var customer_lifetime = customer_lifetime*1;
//var new_customers = new_customers*1;
var mail_pieces1 = mail_pieces1*1;
var mail_pieces = mail_pieces*1;                   //yearly mail pieces.
var gifts_used1 = gifts_used1*1;
var gifts_used = gifts_used*1;                     //yearly gift cert. used.
var gift_cost = gift_cost*1;
var mail_cost = mail_cost*1;


//now get Your liftime sales of a cust.
//(average sale x # of repeat visits per year x customer lifetime (years)):
var life_sales = avg_sale * yearly_repeat_visits * customer_lifetime;

//Your investment in acquiring a new customer is only: 
//((mail pieces sent x cost of each mail piece) / # gift certificates redeemed) + 
//cost of one gift certificate 
//cost of 1 mail sent = $.50
//cost on 1 gift = $5.00
//pieces of mail sent = 100
//no of gifts used = 10
//100*.50 = $50/10 = 5 +2 =$ 7 //works out with addition
var new_customer_cost = mail_pieces1 * mail_cost/gifts_used1 + gift_cost;

if (typeof new_customer_cost == "string") {new_customer_cost = new_customer_cost-0;}

//Gross Profit per new customer:
// (lifetime sales value - cost to acquire new customer):
var customer_worth = life_sales - new_customer_cost; 

//Customer acquisition program after one year (lifetime): 
//(gross profit per new customer x number of gift certificates redeemed x 12):
var programs_yearly_profit = customer_worth * gifts_used;//add x12 only if not using yr amts.






//replace above 2 results with:
//"A" number of customers acquired at "B" per customer generates $A x B in restaurant sales.  
//(where A is "Desired gift cert redeemed" & where B is "lifetime sales revenue from a customer")
var restaurant_sales = gifts_used * life_sales;








//Lifetime value with additional customers per month 
//(gross profit per new customer x number of gift certificates redeemed);
//  x 110%, x 120%, x 130%:
var value_if_add10_customers = programs_yearly_profit * 1.1;  //if 10% more customers,
var value_if_add20_customers = programs_yearly_profit * 1.2;
var value_if_add30_customers = programs_yearly_profit * 1.3;  //if 30% more customers.
 

//Lifetime value if average ticket increases 
//((105%, 110%, 115%, 120%, 130% x average ticket) x # of repeat visits)
var value1 = avg_sale * 1.05 * yearly_repeat_visits * customer_lifetime;
var value2 = value1 - new_customer_cost;
var value3 = value2 * gifts_used;
var value_if_ticket_up_by5 = value3; //5%

var value1 = avg_sale * 1.1 * yearly_repeat_visits * customer_lifetime;
var value2 = value1 - new_customer_cost;
var value3 = value2 * gifts_used;
var value_if_ticket_up_by10 = value3; //10%

var value1 = avg_sale * 1.15 * yearly_repeat_visits * customer_lifetime;
var value2 = value1 - new_customer_cost;
var value3 = value2 * gifts_used;
var value_if_ticket_up_by15 = value3; //15%

var value1 = avg_sale * 1.2 * yearly_repeat_visits * customer_lifetime;
var value2 = value1 - new_customer_cost;
var value3 = value2 * gifts_used;
var value_if_ticket_up_by20 = value3; //20%

var value1 = avg_sale * 1.3 * yearly_repeat_visits * customer_lifetime;
var value2 = value1 - new_customer_cost;
var value3 = value2 * gifts_used;
var value_if_ticket_up_by30 = value3; //30%


//Lifetime value with more repeat visits: 10 20 30 40 50%:
var value1 = avg_sale * yearly_repeat_visits*1.1 * customer_lifetime;
var value2 = value1 - new_customer_cost;
var value3 = value2 * gifts_used;
var value_if_visit_up_by10 = value3; //10%

var value1 = avg_sale * yearly_repeat_visits*1.2 * customer_lifetime;
var value2 = value1 - new_customer_cost;
var value3 = value2 * gifts_used;
var value_if_visit_up_by20 = value3; //20%

var value1 = avg_sale * yearly_repeat_visits*1.3 * customer_lifetime;
var value2 = value1 - new_customer_cost;
var value3 = value2 * gifts_used;
var value_if_visit_up_by30 = value3; //30%

var value1 = avg_sale * yearly_repeat_visits*1.4 * customer_lifetime;
var value2 = value1 - new_customer_cost;
var value3 = value2 * gifts_used;
var value_if_visit_up_by40 = value3; //40%

var value1 = avg_sale * yearly_repeat_visits*1.5 * customer_lifetime;
var value2 = value1 - new_customer_cost;
var value3 = value2 * gifts_used;
var value_if_visit_up_by50 = value3; //50%



//get the results div and put all above values into it in a formatted manner:
var results = "<p>Your lifetime sales revenue from a customer: <font style='color:white;font-size:16px'>$";
results += life_sales.toFixed(2);
results += "</font></p><p>Your investment in acquiring a new customer is only: <font style='color:white;font-size:16px'>$";
results += new_customer_cost.toFixed(2);
results += "</font> per customer!</p>";


results += "<p><font style='color:white;font-size:16px'>";
results += gifts_used;
results += "</font> customers acquired at <font style='color:white;font-size:16px'>$";
results += life_sales.toFixed(2);
results += "</font> per customer generates <font style='color:white;font-size:16px'>$";
results += restaurant_sales.toFixed(2);
results += "</font> in restaurant sales.";


results += "</p>";


var resultsdiv = document.getElementById('results');
resultsdiv.innerHTML = results;

}//end docalc function.


