Question: Please solve all problems using EXCEL formulas and providing the exact formulas below. Thank you! Grace is planning to open a store in the local
Please solve all problems using EXCEL formulas and providing the exact formulas below. Thank you!
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 (4a). 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 cost $0.45 Fixed cost 45,000.00 Revenue Variable cost Profit (4b). 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 = 75000-9000"price Assumptions: Price $ 4.00 demand Unit cost $0.45 Fixed cost $ 45,000.00 Revenue Variable cost Profit S Demand Revenues Variable Costs Profits Demand Revenues Variable Costs Profits Price 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 $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 (2a). The profit-maximizing sale price per glass is (2b). 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
