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
Get step-by-step solutions from verified subject matter experts
