HW 1 (50 pts) - 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. 2. 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 $350 for setup and maintenance and there is a utilities' cost Gas Me Up incurs of $0.07 for every bag of ice. KeepltCool would charge a monthly lease of only $200, but the added energy cost for every bag of ice is $0.10 due to the larger size of the machine. Customers purchase each bag of ice for $2.00, regardless of the company, but Gas Me Up only earns 40% of the total revenue for each bag of ice sold. a. What is the annual break-even point for each option? (10 pts) b. At what volume in number of bags of ice would the two options have the same cost? (10 pts) C. At what forecasted volume should Gas Me Up select IceBox and what volume should the company select KeepltCool and why? (5 pts)