This Profit Maximizing analysis asks you to use excel to determine the best quantity and price to charge at Arnold's Can-Can-Go convenience store.Complete the second page of the attached form by printing it up,answering the questions,completely labeling the graph,and uploading a picture(or scan) by clicking on the word Upload in the title above

https://www.youtube.com/watch?v=oDxFKp5sAGY&t=13s

Energy Drinks at the Can-Can-Go! Arnold, the store manager, is trying to decide two things: 1) How many cans of Energy Drink to have on display in his store each week 2) What price to charge for the Energy Drink. Arnold thinks he should sell the drinks for $3. What do you say to him? Use the following information to advise him: Weekly Demand in the neighborhood: Qd=150-25P Wholesale Cost of Energy Drink (per unit): $0.90 each Cans that can be displayed on one linear foot: 20 cans Fixed cost per Linear Foot : $50 Opportunity Cost of displacing existing merchandise: ??? In order to make room for an Energy Drink Display, Arnold will need to reduce the current merchandise in his store. He can either cut into his candy aisle, his cigarette display, his lottery area, or the Novelty POS. Current Total Cost per Linear Current Display Foot Revenue Candy $500 $590 Cigarettes $3,500 $4,000 Lottery $880 $1,050 Novelty $525 $680 Quantity Demanded Retail Price Revenue Profit