Answer:
Explanation:
Known Variables A = max Daily Rentals
X = Damaged helmets %
lets find the formula to calculate Helmets per location :taking 1st row as an example.
412 = B - (B*13/100)
412 = (100B-13B)/100
412*100 = 87B
B= 412*100/87
Hence, the generic formula becomes : B= A*100/(100-X)
Applying the same formula for each row and then using ROUND function of excel to round off the digits
=ROUND(number,digits) where number is the number you would like to round off and the digits is the number of decimal digits for it to round off. Since we want natural numbers in our example, we will be using digits as 0.
Explanation:
See attached pictures also.
CVP Chart.
Source: "New Perspectives on Microsoft Excel 2010: Comprehensive" by June Parsons, Dan Oja, Roy Ageloff, Patrick Carey.
Widget is an item that appears in a programs graphical user interface.