Please complete all work in excel. Use excel to make the calculations (cells can be clicked on to view any formulas used) and be sure to identify your answer, including units.

Gas Me Up is considering offering bagged ice sales through a self-service company that would locate a machine on the edge of the parking lot. IceBox would charge a monthly lease fee of $300 for setup and maintenance and there is a utilities cost Gas Me Up incurs of $0.07 for every bag of ice. KeepItCool would charge a monthly lease of only $200, but the added energy cost for every bag of ice is $0.11 due to the larger size of the machine. Customers purchase each bag of ice for $2.00, regardless of the company, and Gas Me Up earns 30% of the total revenue for each bag of ice sold.

a. What is the annual break-even point for each option?

b. At what volume in number of bags of ice would the two options have the same cost?

c. At what forecasted volume should Gas Me Up select IceBox and what volume should the company select KeepItCool and why?