LORY SPRING WATER dispenses its product Natural Pure Water via vending machines with most current locations at food markets and pharmacy or chemist stores. The average monthly fixed cost per site is P 900, while each gallon costs 18¢ to purify and sells for 30¢. (a) Determine the monthly sales volume needed to break even. (b) LSW manager is negotiating for a sole-source contract with the city government where several sites will dispense larger amounts. The fixed cost and purification costs will be the same, but the sales price per gallon will be 30¢ for the first 5000 gallons per month and 20¢ for all above this threshold level. Determine the monthly breakeven volume at each site. Please show the solution. Solutions in excel are acceptable
LORY SPRING WATER dispenses its product Natural Pure Water via vending machines with most current locations at food markets and pharmacy or chemist stores. The average monthly fixed cost per site is P 900, while each gallon costs 18¢ to purify and sells for 30¢.
(a) Determine the monthly sales volume needed to break even.
(b) LSW manager is negotiating for a sole-source contract with the city government where several sites will dispense larger amounts. The fixed cost and purification costs will be the same, but the sales price per gallon will be 30¢ for the first 5000 gallons per month and 20¢ for all above this threshold level. Determine the monthly breakeven volume at each site.
Please show the solution. Solutions in excel are acceptable.
Step by step
Solved in 2 steps