Project 12: 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. 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 AYK12_Data.xlsx data file. 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 Bill's Boots - Boot One Boot Price Variable Cost Revenue per Boot 225 100 Bill's Boots - Boot Two Boot Price Variable Cost Revenue per Boot Bill's Break-Even Point Revenue per Boot Number of Boots Sold Total Sales Fixed Cost 10.000 Total Revenue