Come up with 5 new rates using activity based costing and revise the last page. Make a recommendation on what JBI should do. (Ignore the highlighting) thank you!

Johnson Beverage selbto Retail store customers-about 20 customers Last year Revenue was $12 ilin Sel Sport Drinks List price is $15.20 per case Cost is $13.10 per case Discounts vary by customer Customer Saver Superstore is not happy- they think they are paying too muckh In addition to COGS Johnson has Customer Service costs of $1.2 million per year -like overhead See Table 1 currently allocated based on % of revenue They Run a report of Profitability by Customer See Exhibit 1 2 Can you help them using Activity Based costing