Hi,
I'm working on a milestone and I was hoping someone could double check my calculations regarding contribution margin analysis and break-even analysis. Thank you for your time! :)
patihilit File Home Insert Draw Design Layout References Mailings Review View Help i Share 5' Comments ' bll'llll ' ' Milestone Two: Market Research Data ~r'ou 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: c Collars o 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, 0 with pricing at $28 per collar, you can expect to sell 20 collars per day c Leashes o With pricing at 522 per leash, you can expect to sell 28 leashes per day. o with pricing at 526 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. 1 Harnesses o 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 com pare your break-even points for the following target prots for each area ofyour business to delenoine your prices. I Collars o Break-even 0 5300 target prot each month 0 3500 target prot each month c Leashes o Break-even 0 $401] target prot each month 0 $600 target prot each month c Harnesses o Break-even 0 5500 target prot each month 0 3650 target prot each month o i Page1 of1 272words [U CD1 Focus ,0 Type here to search Racheal Carles X AutoSave On . ACC 202 Project Workboo... - Last Modified: Sat at 7:38 PM - Search RC Share Comments File Home Insert Draw Page Layout Formulas Data Review View Help F30 X V B C D E F G H A I J K L M N P Q Milestone Two - Contribution Margin Analysis COLLARS LEASHES HARNESSES 8 Sales Price per Unit S 20.00 S 22.00 S 25.00 9. Variable Cost per Unit 9.10 12.10 14.60 11 Contribution Margin S 10.90 9.90 10.40 12 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 COGS Variances + Cost Classification Variable and Fixed Costs Contribution Margin Analysis Break-Even Analysis Income Statement + 100% Ready 6:49 PM ? A Type here to search O W 70'F Mostly cloudy 9/20/2021ACC 202 Project Workboo... - Last Modified: Sat at 7:38 PM - Racheal Carles RC X AutoSave On Search Review Share File Home Insert Formulas Data View Help Comments Draw Page Layout G25 X V 466.54 C D E F G H K L M N O P Q R - A B Milestone Two - Break-Even Analysis COLLARS LEASHES HARNESSES Sales Price S 20.00 S 22.00 S 25.00 Fixed Costs 4,028 S 4,028 S 4,202 10 11 Contribution Margin S 10.90 S 9.90 S 10.40 12 Break-Even Units (round up) 369.54 406.87 404.04 13 14 16 17 Target Profit S 300.00 S 400.00 S 500.00 18 452.12 19 Break-Even Units (round up) 397.06 447.27 20 22 23 Target Profit S 500.00 S 600.00 S 650.00 24 Break-Even Units (round up) 415.41 467.47 466.54 25 26 28 29 30 31 OneDrive X 32 33 Screenshot saved 34 The screenshot was added to your 35 Variable and Fixed Costs Contribution Margin Analysis COGS Income Statement OneDrive. Cost Classification Break-Even Analysis Va Ready 6:49 PM O ? 70'F Mostly cloudy CX Type here to search W 9/20/2021
