Checking to see if my answers are correct. Thanks
Align Left G47 v : XJx B E 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 Milestone One - Variable and Fixed Costs your area depending on style of products you choose to sell: 5 Collars Collars 7 Item riable Cost/item Item Fixed Costs With pricing at $20 per collar, you can expect to sell 30 collars per day 9 High-tensile strength melon webl S 4.00 Collar maker's salary (monthly) $ 2,773 33 10 Polyesterinylon ribbons 3.00 Depreciation on sewing machine $ 165.00 With pricing at $24 per collar, you can expect to sell 25 collars per day 11 Buckles made of cast hardware $ 200 Rent 250.00 With pricing at $28 per collar, you can expect to sell 20 collars per day 12 Price Lag's 0.10 Utilities and insurance 250.00 13 Scissors, thread and cording 400,00 . Leashes 14 Loan payment 183.33 15 Salary to self 156.68 o With pricing at $22 per leash, you can expect to sell 28 leashes per day. 16 With pricing at $26 per leash, you can expect to sell 23 leashes per day 17 With pricing at 530 per leash, you can expect to sell 18 leashes per day. Total Variable Costs per $ 3.10 Total Fixed Costs $ 4.188.32 20 Harnesses 22 o With pricing at $25 per harness, you can expect to sell 25 harnesses per day 23 Leashes o With pricing at 530 per harness, you can expect to sell 22 harnesses per day 25 Rem riable Costiltem Item Fixed Costs D With pricing at 535 per harness, you can expect to sell 20 harnesses per day 27 High-tensile strength nion webl + 6.00 Leash maker's salary (months] 1 2773.33 20 Polestrillon ribbons 450 Depreciation on sewing machin $ $65.00 29 Buckles made of cart hardware 150 Rent 250.00 200.00 Additionally, you will need to compare your break even points for the following target profits for 30 Price tags Utilities and insurance each area of your business to determine your prices 01 Scissors, thread, and cording 400.00 32 Loan payment 183.23 30 Salary to self 166.67 Collars 34 35 Q Break-even 36 5300 target profit each month Total Variable Costs per $ 12 10 Total Fixed Costs $4.138.33 $500 target profit each month 38 41 Leashes 42 Harnesses Break-even 44 Item riable Cost/item Rtem Fixed Costs 5400 target profit each month 16 High-tensile strength realon webl $ 6.00 Harness maker's salary 2946.67 D 47 Pohesterington ribbons 450 Depreciation on sewing machin $ 165.00 o 5600 target profit each month 49 Buckles made of east hardware # 4.00 Rent 250.00 49 Price tags 10.10 Utaities and insurance 200.00 50 Scissors, thread, and cording 400.00 Harnesses 51 Loan 183.33 Break-even 52 Salary to self 166.67 o $500 target profit each month 53 $650 target profit each month 54 57 Total Variable Costs per $ 14.60 Total Fixed Costs 4.31167 Remember that all break-even and target points must be in whole units (we cannot sell a partial 58 unit). Round up when calculating partial units to ensure costs are covered. Excel tip - use 60 ROUNDUP function Cost Classification Variable and Fixed Costs CO Page 1 of 1 D Focus + 55% Ready Accessibility: Good to go 79.F O