Calculate Total Revenue from Production Cost and Margin

by Ian Roberts

JavaScript

var numberOfWorkHours = 6;
var numberOfShopHours = 4;
var shopRentalRate = 6;
var shopFee = numberOfShopHours*shopRentalRate;
var payRate = 20;
var numberOfBoards = 6;
var costOfMaterials = 45;
//var equalCostPerBoard = costOfMaterials/numberOfBoards
var desiredMargin = 80;
var boardsObj = [];
boardsObj.push(11*17);
boardsObj.push(8*14);
boardsObj.push(8*12);
boardsObj.push(8*12);
boardsObj.push(8*7);
boardsObj.push(6*10);
var totalBF = 0;
//**//
var totalProductionCost = shopFee+numberOfWorkHours*payRate+costOfMaterials;
//alert(totalProductionCost);
var sharedProductionCost = shopFee/numberOfBoards+numberOfWorkHours*payRate/numberOfBoards+costOfMaterials/numberOfBoards;
var marginFactor = desiredMargin/100;
var diff = 1 - marginFactor;
//**//
//alert(sharedProductionCost);
//var totalRevenue = totalProductionCost/diff;
var totalRevenue = sharedProductionCost/diff;
for (var i = 0; i <= boardsObj.length -1; i++ ) {
  totalBF += boardsObj[i];
}
for (var i = 0; i <= boardsObj.length -1; i++ ) {
	//alert(totalRevenue + '*' + boardsObj[i] + '/' + totalBF);
  var val = totalRevenue*boardsObj[i]/totalBF
  var h = document.createElement("p");
  var t = document.createTextNode("Board " + [i+1] + " $"+ Math.ceil(val));
  h.appendChild(t);
  document.body.appendChild(h);
}
function totalRevenueNeeded() {
  var h = document.createElement("H1");
  var t = document.createTextNode("Total Revenue needed is $"+totalRevenue);
  h.appendChild(t);
  document.body.appendChild(h);
}
totalRevenueNeeded();