M MHE Reader getproctorio.com I-Term Exam Fall 2020 i Saved Help Save & Exit Submit Pepsico Inc. sells bottled beverages. During the past year, 500,000 bottles were produced and sold at a price of $1.00 per bottle. Variable cost per unit was $0.40 and total fixed costs were $200,000. Pepsico would like to raise the price per unit to $1.15, but feels that this will reduce sales to 475,000 bottles per year. Required. Use the downloadable Excel template below to provide answers to the following questions: a) Perform the appropriate analysis of the current situation and the new alterative (rasing the price). Clearly label the differential revenues, costs, and profits. b) Should Pepsico raise its price? Provide numerical support for your answer. 26:09 c) Pepsico's tax rate is 21% and they would like to make $150,000 after taxes. How many bottles do they have to sell at the $1.00 per bottle price? upload a response file (15MB max) download reference file Choose File No file chosen XLS Problem 6 Pepsico Chp 7 save Problem.xisx