Question: Use the Markdown Pricing Decisions spreadhseet model and a two-way data table to find the total revenue if days at full retail vary from 15

Use the Markdown Pricing Decisions spreadhseet model and a two-way data table to find the total revenue if days at full retail vary from 15 to 35 in increments of 5 and the itnermediate markdown varies from 25% to 60% in increments of 5%.

I'm having trouble getting the answers for this two way variable data table. It keeps giving me the same answers.

Markdown Pricing Model

Days at full retail 15

25% 30% 35% 40% 45% 50% 55% 60%

_ _ _ _ _ _ _ _

Data
Retail price $70.00
Inventory 1000
Selling season (days) 50
Days at full retail 40
Intermediate markdown 30%
Clearance markdown 70%
Demand function
a 91
b -1.2
Model
Full Retail Sales
Retail price $70.00
Daily sales 7.00
Days at retail price 40
Units sold at retail 280
Retail revenue $19,600.00
Discount Sales
Discount 30%
Discount price $32.00
Daily sales 32.20
Unit sold 322
Discount revenue $15,778.00
Clearance Sales
Clearance price $21.00
Units sold at clearance 398
Clearance revenue $8358.00
Total revenue $43,736.00

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!