Hi Chegg Team

Please help me resolve this problem to fix in the following Excel template file. Not sure how to name each cell

P22.3 (LO 3, 4, 5), AP Jorge Company bottles and distributes B-Lite, a diet soft drink. The beverage is sold for 50 cents per 16-ounce bottle to retailers. For the year 2022, management estimates the following revenues and costs. Instructions a. Prepare a CVP income statement for 2022 based on management's estimates. Include columns for per unit and percent of sales information. b. Compute the break-even point in (1) sales units and (2) sales dollars. c. Compute the contribution margin ratio and the margin of safety ratio. (Round to nearest full percent.) d. Determine the sales dollars required to earn net income of $180,000. (a) Jorge Company CVP Income Statement (Estimated) For the Year Ending December 31, 2020