Enter a formula in cell B1 using the SUMPRODUCT function to calculate the total value of the current leases by multiplying the c
1 answer:
You might be interested in
Solution :
The price per trip is given as
The number of trips is given as = 800
The total cost calculations are as follows :
Particulars Amount Calculations
Annual cost for automobile van $ 18,000
Cost of driver salary $ 80,000 45000 + 35000
Cost of fringe benefits $ 24,000 80000 x 30%
Cost of insurance $ 2,000
Fuel and maintenance $ 8,000
Total cost $ 132,000.00
Therefore the price per trip