Any help to assist me in understanding how to fill out the "Contribution Margin Analysis" and Break-Even Analysis" tabs in the workbook (pictured below) is welcome! I have included some helpful information below.

Use information from Milestone One and the provided Milestone Two Market Research Data Appendix (copied below) to conduct a cost-volume profit analysis. Complete the "Contribution Margin Analysis" and "Break-Even Analysis" tabs in the Project Workbookthat you used for completing the Milestone One assignment.

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: Market Research Data:

?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

Milestone Two - Break-Even Analysis COLLARS LEASHES HARNESSES Sales Price S S S Fixed Costs S S S Contribution Margin S S Break-Even Units (round up) Target Profit S 300.00 S 400.00 S 500.00 Break-Even Units (round up) Target Profit S 500.00 S 600.00 S 650.00 Break-Even Units (round up)Milestone Two - Contribution Margin Analysis COLLARS LEASHES HARNESSES Sales Price per Unit Variable Cost per Unit Contribution MarginMilestone One - Variable and Fixed Costs Collars Item Variable Costtem Item Fined Costs Hightensile strength nylon webbing 5 4.00 Collar maker's salary [monthly] 5 2,??3.33 Polyesterfnylon ribbons 5 3m Depreciation on sewing machines 5 55m Buckles made of cast hardware 5 21!) Rent 5 2501):) Price tags 5 0.10 Utilities and insurance 5 200m Scissors, thread, and cording 5 4001):) Loan payment 5 133.33 Salary to self 5 156.6? Total Variable Costs per Collar 9.10 Total Fixed Costs 4,028.33 Leashes Item Variable CosUItem Item Fined Costs Hightensile strength nylon webbing 5 6m Leash maker's salary {monthly} 5 2,33429 Polyesterfnylon ribbons 5 4.50 Depreciation on sewing machines 5 55m Buckles made of cast hardware 5 1.50 Rent 5 250.01) Price tags 5 0.10 Utilities and insurance 5 200m Scissors, thread, and cording 5 40000 Loan payment 5 133.33 Salary to self 5 166.6?I Total Variable Costs per Leash 12.10 Total Fixed Costs 4,089.29 Harnesses Item Variable Costtem Item Fined Costs Hightensile strength nylon webbing 5 6m Harness maker's salary 5 3,011.43 Polyesterfnylon ribbons 5 4.50 Depreciation on sewing machines 5 55m Buckles made of cast hardware 5 41):) Rent 5 250.01) Price tags 5 0.10 Utilities and insurance 5 200m Scissors, thread, and cording 5 40000 Loan 5 153.33 Salary to self 5 166.6?I Total Variable Costs per Harness 5 14.60 Total Fined Costs 5 4,266.43