Use information from Milestone One and the providedMilestone Two Market Research Data Appendix Word Documentto conduct a cost-volume profit analysis. Complete the "Contribution Margin Analysis" and "Break-Even Analysis" tabs in theProject Workbook Spreadsheetthat you used for completing the Milestone One assignment.

Specifically, you must address the following rubric criteria:

• Contribution Margin.Determine your contribution margin per unit in the "Contribution Margin Analysis" tab.
• Choose asales pricefor each product.
• Calculate thecontribution marginfor each product based on your sales price and the variable cost for that product. Show your work using calculations to the side of the table or using appropriate formulas in the table.
• Break-Even Analysis.Use cost-volume-profit (CVP) analysis to determine your break-even points for achieving your target profits in the "Break-Even Analysis" tab.
• Determine thebreak-even pointsfor each product. Show your work using calculations to the side of the table or using appropriate formulas in the table.
• Determine break-even units for the suggestedtarget profitsfor each product. Show your work using calculations to the side of the table or using appropriate formulas in the table.

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:

Collars

oWith pricing at $20 per collar, you can expect to sell 30 collars per day.

oWith pricing at $24 per collar, you can expect to sell 25 collars per day.

oWith pricing at $28 per collar, you can expect to sell 20 collars per day

Leashes

oWith pricing at $22 per leash, you can expect to sell 28 leashes per day.

oWith pricing at $26 per leash, you can expect to sell 23 leashes per day.

oWith pricing at $30 per leash, you can expect to sell 18 leashes per day.

Harnesses

oWith pricing at $25 per harness, you can expect to sell 25 harnesses per day.

oWith pricing at $30 per harness, you can expect to sell 22 harnesses per day.

oWith pricing at $35 per harness, you can expect to sell 20 harnesses 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

oBreak-even

o$300 target profit each month

o$500 target profit each month

Leashes

oBreak-even

o$400 target profit each month

o$600 target profit each month

Harnesses

oBreak-even

o$500 target profit each month

o$650 target profit each month

X AutoSave On . ACC 202 Project Workboo... - Last Modified: July 11 - Search A bassantessam98@gmail.com B Share File Home Insert Page Layout Formulas Data Review View Help Comments LO Calibri 10 A ab Wrap Text General AY O Conditional Format as Cell Insert Delete Format Sort & Find & Analyze Paste BIU E Merge & Center $ ~ % " Formatting * Table Styles v Filter * Select v Data Styles Cells Editing Analysis Clipboard Font Alignment Number F15 X V A B C D E F G H J K L M N P Q Milestone Two - Contribution Margin Analysis COLLARS LEASHES HARNESSES 8 Sales Price per Unit 9 Variable Cost per Unit 11 Contribution Margin 12 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 Cost Classification Variable and Fixed Costs Contribution Margin Analysis Break-Even Analysis COGS Income Statement Variances + + 100% Ready 10:51 PM Type here to search O 9 ? 7/24/2021ACC 202 Project Workboo... - Last Modified: July 11 + Search A bassantessam98@gmail.com B X AutoSave On . Share Comments File Home Insert Page Layout Formulas Data Review View Help X AY O LO Calibri 12 ~ AA ab Wrap Text General Conditional Format as Cell Insert Delete Format Sort & Find & Analyze Paste BIU ~ Merge & Center $ ~ % " Formatting " Table Styles Filter * Select v Data Alignment Number Styles Cells Editing Analysis Clipboard Font B2 X V Milestone Two - Break-Even Analysis O P R A A B C D E F G H K L M N Milestone Two - Break-Even Arlalysis COLLARS LEASHES HARNESSES S Sales Price S S Fixed Costs S S S 10 11 Contribution Margin S 12 13 Break-Even Units (round up) 14 16 Target Profit 300.00 S 400.00 S 500.00 17 18 19 Break-Even Units (round up) 20 22 23 Target Profit S 500.00 S 600.00 S 650.00 24 25 Break-Even Units (round up) 26 28 29 Cost Classification Variable and Fixed Costs Contribution Margin Analysis Break-Even Analysis COGS Income Statement Variances + + 100% Ready 10:51 PM Type here to search O 9 ? 7/24/2021