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

I need to solve yellow blanks using excel function.

planning to open a store in the local mall to sell gourmet

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

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 Finance Questions!