Business Driven Technology 6th Edition by Paige Baltzan

Exercise 178

Competitive Pricing
Bill Schultz is thinking of starting a store that specializes in handmade cowboy boots. Bill is a longtime rancher in the town of Taos, New Mexico. Bill's reputation for honesty and integrity is well-known around town, and he is positive that his new store will be highly successful.
Project Focus
Before opening his store, Bill is curious about how his profit, revenue, and variable costs will change depending on the amount he charges for his boots. Bill would like you to perform the work required for this analysis and has given you the data file AYK12_Data.xlsx. Here are a few things to consider while you perform your analysis:
Current competitive prices for custom cowboy boots are between $225 and $275 a pair.
Variable costs will be either $100 or $150 a pair depending on the types of material Bill chooses to use.
Fixed costs are $10,000 a month.
Data File: AYK12_Data.xlsx