Need the answers for the following...

Home Insert Draw Design Layout References Mailings Review View Help File Home Insert Page Layout Formulas Data Calibri 12 A 1 E % Conditional Formatting ~ LA B I U ~ ab X, X Po Paragraph Styles Editing Undo Clipboard Font Alignment Number Format as Table Cells Paste A~ DA Aa A A 17 Cell Styles ~ Styles Clipboard Font Styles Is lign Left B8 VIX fx B D E G You have conducted some market research for style and size of products you want to use to launch your business. The market research has indicated the following sales price ranges will be optimal for 1 your area depending on style of products you choose to sell: 2 Collars Milestone Two - Contribution Margin Analysis o With pricing at $20 per collar, you can expect to sell 30 collars per day With pricing at $24 per collar, you can expect to sell 25 collars per day o With pricing at $28 per collar, you can expect to sell 20 collars per day COLLARS LEASHES HARNESSES Leashes With pricing at 522 per leash, you can expect to sell 28 leashes per day 8 Sales Price per Unit With pricing at $26 per leash, you can expect to sell 23 leashes per day 9 Variable Cost per Unit With pricing at 530 per leash, you can expect to sell 18 leashes per day. 11 Contribution Margin Harnesses 12 o With pricing at $25 per harness, you can expect to sell 25 harnesses per day With pricing at $30 per harr n expect to sell 22 harnesses per day o With pricing at $35 per hamness, you can expect to sell 20 hamesses per day. Additionally, you will need to compare your break-even points for the following target profits for each area of your business to determine your prices: Collars o Break even o $300 target profit each month $500 target profit each month Leashes D Break-even o $400 target profit each month o $600 target profit each month Harnesses a Break-even o $500 target profit each month 5650 target profit each month Remember that all break-even and target points must be in whole units (we cannot sell a partial unit). Round up when calculating partial units to ensure costs are covered. Excel tip - use ROUNDUP function Variable and Fixed Costs Contribution Margin Analysis Brea ... + 1 of 1 306 words Focus Ready Accessibility. Good to go 79'F Sunny W I G 26