Need the answers to the following questions

B I Uv ab X x A Paragraph Styles Editing Undo Clipboard Font Alignment Number Format as Table ~ Cells Ed Paste A D A Aa~ A A Cell Styles Clipboard Font IS Styles Is Styles Left C7 vi XV fx =Contribution Margin Analysis'/B8 C D E F 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 your area depending on style of products you choose to sell Milestone Two - Break-Even Analysis Collars 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 528 per collar, you can expect to sell 20 collars per day COLLARS LEASHES HARNESSES . Leashes Sales Price S S With pricing at $22 per leash, you can expect to sell 28 leashes per day. o With pricing it $26 per leash, you can expect to sell 23 leashes per day With pricing at $30 per leash, you can expect to sell 18 leashes per day. Fixed Costs S $ S Harnesses 10 o With pricing at $25 per harness, you can expect to sell 25 harnesses per day 11 Contribution Margin S S o With pricing at $30 per hamess, you can expect to sell 22 harnesses per day o With pricing at $35 per harness, you can expect to sell 20 harnesses per day 12 13 Break-Even Units (round up) 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 14 Collars 16 Break-even 17 Target Profit S 300.00 S 400.00 S 500.00 0 5300 target profit each month o $500 target profit each month 18 19 Break-Even Units (round up) Leashes Q Break even 20 5400 target profit each month o $600 target profit each month 22 23 Target Profit 500.00 S 600.00 S 650.00 Harnesses Break-even 24 o $500 target profit each month 25 Break-Even Units (round up) 0 5650 target profit each month 26 member 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 28 ROUNDUP function 29 Contribution Margin Analysis Break-Even Analysis COGS of 1 306 words Focus + 55% Ready Accessibility Good to go 84 79"F 2 1) 0 9:47 Sunny OLD W G 5/25 /2