Review the Problem Omelet Pans

Short Description
However, the formulas for Quantity for each of the three scenarios are more complex. They’re best built using either Excel’s MAX and MIN or IF functions. …

Website: faculty.fuqua.duke.edu | Filesize: 77kb

Content
Gila Shoes Exercise:
IF, MAX, & MIN Step-by-Step
EXCEL REVIEW
2001-20021
Gila Shoes
The Exercise Background
Rob owns a Fast Feet running store in Carrboro. For a month-long promotion for his
store’s new location in Carr Mill Mall, Rob plans to offer the new Gila “marathon trainer
XT” women’s’ running shoe to his customers at a discounted price. For a limited time,
Rob can order the shoes directly from a wholesaler at $40 a pair. During his store
promotion Rob plans to make this popular shoe available to his customers for $65 a pair,
an attractive discount from the MSRP of $84, leaving Rob a profit of $25 each. To get the
$40 price Rob must place his order two months in advance.
If customer demand exceeds the quantity Rob orders in advance, he must meet the excess
demand by obtaining Gila shoes from another supplier at a higher cost, $55 a pair.
However, if after the month-long promotion period is over, customer demand has fallen
short of the quantity he ordered in advance, he’ll be forced to list the over-stocked shoes
on his store’s website sale page at $35 a pair.
What to Build
Build a spreadsheet that…