A clothing company is planning its winter pricing,

Develop a spreadsheet model on excel to evaluate their revenue under the following scenarios:

1. No price reductions at all until the after-Christmas clearance
2. A price reduction to $79 starting at Columbus Day until Black Friday and then a sale price of $59 until the after-Christmas clearance
3. A price reduction to $69 starting at Columbus Day until Black Friday and then a sale price of $59 until the after-Christmas clearance