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 formulasPlease 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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!