Question: I need to solve yellow blanks using excel function. Grace is planning to open a store in the local mall to sell gourmet bubble tea.

I need to solve yellow blanks using excel function.

Grace is planning to open a store in the local mall to sell gourmet bubble tea. She is wondering how her revenue, variable costs and profit will be affected by the price she charges and the unit cost (1). Build a model to show how changes in prices will affect her unit sales, revenues, variable costs and profit. Show results based on price of $1.00 to $5.00 in $0.25 increments. Demand = 65000-9000*price. Assumptions Price $ 4.00 demand Unit cos $0.45 Fixed cost $ 45,000.00 Revenue Variable cost $0.00 Profit Demand Revenues Variable Costs Profits Price $1.00 $1.25 $1.50 $1.75 $2.00 $2.25 $2.50 $2.75 $3.00 $3.25 $3.50 $3.75 $4.00 $4.25 $4.50 $4.75 $5.00 (2). The profit-maximizing sale price per glass is
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
