You haye 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: o Collars 0 With pricing at $20 per collar, you can expect to sell 30 collars per day. 0 With pricing at $24 per collar, you can expect to sell 25 collars per day. (:1 With pricing at $28 per collar, you can expect to sell 20 collars per day In Leashes (:1 With pricing at $22 per leash, you can expect to sell 28 leashes per day. (:I With pricing at $25 per leash, you can expect to sell 23 leashes per day. 0 With pricing at $30 per leash, you can expect to sell 18 leashes per day. I Harnesses 0 With pricing at $25 per harness, you can expect to sell 25 harnesses per day. 0 With pricing at $30 per harness, you can expect to sell 22 harnesses per day. 0 With pricing at $35 per harness, you can expect to sell 20 harnesses per day. Additionally, you will need to compare your brea k-eyen points for the following target profits for each area of your business to determine your prices: 0 Collars (:1 Breakeven (:1 5300 target profit each month (3 S500 target profit each month I Leashes o Break-eyen 0 $400 target profit each month o $500 target profit each month I Harnesses o Breakeven o 5500 target profit each month 0 5650 target profit each month Remember that all breakeyen and target points must be in whole units (we cannot sell a partial unit}. Round up when calculating partial units to ensure costs are coyered. Excel tip use ROUNDUP function Milestone One - Cost Classification INSTRUCTIONS: Putting an X in the appropriate spot, classify the costs as: Direct Material, Direct Labor, Overhead, or Period Costs. The Fixed and Variable cost classifications have been provided for you. Direct Direct Item/Cost Material Labor Overhead Period Costs Fixed Variable Salary - Collar maker X Salary - Leash maker Salary - Harness maker X Salary - Receptionist High-tensile strength nylon webbing Polyesterylon ribbons X Buckles made of cast hardware X Depreciation on sewing machines X Rent X Utilities and insurance X Scissors, thread, and cording X ...... Price tags X Office supplies Other business equipment Loan payment X Salary to self XMilestone One - Variable and Fixed Costs Collars Item Variable Costfltem Item Fixed Costs Hightensile strength nylon webbing S 4.00 Collar maker's salary {monthly} 5 2,773.33 Polyester/\"nylon ribbons Depreciation on sewing machines Buckles made of cast hardware Rent Price tags Utilities and insurance Scissors, thread, and cording Loan payment 5 183.33 Salary to self 5 166.67 Total Variable Costs per Collar Total Fixed Costs Leashes Item Variable Costlltem Item Fixed Costs High-tensile strength nylon webbing Polyesterylon ribbons Buckles made of cast hardware Price tags Leash maker's salary {monthly} Depreciation on sewing machines Rent Utilities and insurance Scissors, thread, and cording Loan payment |:| Sala ry to self Total Variable Costs per Leash Total Fixed Costs Harnesses Item Variable to Item Item Fixed Costs Hightensile strength nylon webbing Polyesterfnylon ribbons Buckles made of cast hardware Price tags Total Variable Costs per Harness Harness maker's salary Depreciation on sewing machines Rent Utilities and insurance Scissors, thread, and cording Loan Salary to self Total Fixed Costs