Formatting as Table Styles Clear G6 Revenue with Discount Cakes by Monica (a bakery under the umbrella of the Cafe Brul restaurant) in Vermilion, SD makes cupcakes for purchase from throe different kinds of custonmezs. Suppose you are the munagor for a bakary like Cakes by Monica with a similar pricing structurc. Type1: Customers who purchasc cupcakes at their individusl price in the store. Type 2: Customers who order cupcakes at least 3 days in advance in increments of 2 doaen of cach flavor. Discount: S.2S per cupcake. Type 3: Customers who onder cupeakeat least 2 weeks in advance but order at least 4 dozen ofeach flavor. Discount: S.30per cupeake. Customers ordering more cupeakes of the same kind are charged less per cupcake because there is less waste and les changeover costs for larger orders placed further in advance and because ingredients can be ordered in bulk from a less expensive supplier. Using the information provided, clcalate the total revenue your bakery will receive from each type of customer and in total from the sale of cupcakes at cach price. All relevant values are gathered below Discount (customer of type 2) Discount (customer of type 3) $0.25 S0.50 Weekly Sales Revenue Estimates Type 2 Price Price Sales Cindividual Type 2 Sales in dozens Type 3 Sales (in dazens TR Total Revenue 4.00 $3.75 $3.50 40 15 $2.00 $1.75 6 40 80 a) As price declines, do sales increase or decrease? b) As price declines, does revenue incase or decrcase? c If your bakery wants to make as much revenue as possible but keep the current discount structure (i.e, set the individual cupcake price, and then apply the discounts for customers of type 2 and 3 to the individual cupcake price), how much should you charge As price declines,salcs As price deelines, reveue for your cupcakes? Price (customer type 1) Price (eustomer type 2) Price (custoener type 3) d) Hoa much total revenue do you make? Discount (customer of type 2) $0.25 Discount (eustomer of type 3) $0.50 Weekly Sales Revenue Estimates l Sales (Individual Type 2 Sales in dozens 3 TR Total Revenue 3.75 40 45 50 $3.00 S2.75 20 24 60 2.25 $2.00 S1.75 36 40 a) As price declines, do sales increase or decrease? b) As price declines, does revenue increase or decreasc? e) If your bakery wants to make as much revenue as possible but keep the current discount structure (ie, set the individual cupcake price, and then apply the discounts for customers of type 2 and 3 to the individual cupcake price), how much should you charge As priee declines, sales for your cupcakes? Price (customer type 1)- Price (customer type 2) Price (customer type 3) d) How much total revenue do you make? Revenue eIf you can charge prices for differe types of customers independently Lo., if you can change the current discount structure to maximize revenue by customer), how much should you charge for your cupcakes? Price (customer type 1) Price (customer type 2) Price (customer type 3) 0 What is the sotal revenue your bakery will receive with these prices? Formatting as Table Styles Clear G6 Revenue with Discount Cakes by Monica (a bakery under the umbrella of the Cafe Brul restaurant) in Vermilion, SD makes cupcakes for purchase from throe different kinds of custonmezs. Suppose you are the munagor for a bakary like Cakes by Monica with a similar pricing structurc. Type1: Customers who purchasc cupcakes at their individusl price in the store. Type 2: Customers who order cupcakes at least 3 days in advance in increments of 2 doaen of cach flavor. Discount: S.2S per cupcake. Type 3: Customers who onder cupeakeat least 2 weeks in advance but order at least 4 dozen ofeach flavor. Discount: S.30per cupeake. Customers ordering more cupeakes of the same kind are charged less per cupcake because there is less waste and les changeover costs for larger orders placed further in advance and because ingredients can be ordered in bulk from a less expensive supplier. Using the information provided, clcalate the total revenue your bakery will receive from each type of customer and in total from the sale of cupcakes at cach price. All relevant values are gathered below Discount (customer of type 2) Discount (customer of type 3) $0.25 S0.50 Weekly Sales Revenue Estimates Type 2 Price Price Sales Cindividual Type 2 Sales in dozens Type 3 Sales (in dazens TR Total Revenue 4.00 $3.75 $3.50 40 15 $2.00 $1.75 6 40 80 a) As price declines, do sales increase or decrease? b) As price declines, does revenue incase or decrcase? c If your bakery wants to make as much revenue as possible but keep the current discount structure (i.e, set the individual cupcake price, and then apply the discounts for customers of type 2 and 3 to the individual cupcake price), how much should you charge As price declines,salcs As price deelines, reveue for your cupcakes? Price (customer type 1) Price (eustomer type 2) Price (custoener type 3) d) Hoa much total revenue do you make? Discount (customer of type 2) $0.25 Discount (eustomer of type 3) $0.50 Weekly Sales Revenue Estimates l Sales (Individual Type 2 Sales in dozens 3 TR Total Revenue 3.75 40 45 50 $3.00 S2.75 20 24 60 2.25 $2.00 S1.75 36 40 a) As price declines, do sales increase or decrease? b) As price declines, does revenue increase or decreasc? e) If your bakery wants to make as much revenue as possible but keep the current discount structure (ie, set the individual cupcake price, and then apply the discounts for customers of type 2 and 3 to the individual cupcake price), how much should you charge As priee declines, sales for your cupcakes? Price (customer type 1)- Price (customer type 2) Price (customer type 3) d) How much total revenue do you make? Revenue eIf you can charge prices for differe types of customers independently Lo., if you can change the current discount structure to maximize revenue by customer), how much should you charge for your cupcakes? Price (customer type 1) Price (customer type 2) Price (customer type 3) 0 What is the sotal revenue your bakery will receive with these prices