Answered step by step
Verified Expert Solution
Question
1 Approved Answer
What are the formulas to answer thd multiproduct target profit point in unitd and the sales at target profit. 300 Sales MIX ( Sola Contribution
What are the formulas to answer thd multiproduct target profit point in unitd and the sales at target profit. 300 Sales MIX ( Sola Contribution Margin Sales Mix % Overall CM per unit 200 $1,200.00 0.67 100 $1,200.00 0.33 $2,400.00 $8.00 Multiproduct Breakeven point: -in units Sales revenue at breakeven Product #1 125 $1,250.00 Product #2 63 $1,875.00 Total 188 $3,125.00 Product #1 Product #2 Total Multiproduct Target profit point: -in units Sales revenue at target profit Margin of Safety (in $) $1,875.00 Margin of Safety % 38% Operating Leverage Factor 2.7 Expected % change in operating income (%) 13.33% ungprod.replet.com El Preet Wys. One Ture Pro H! Excel Excel Project CVP . Saved Search Option le Home Insert Draw Page Layout Formulas De Review View Help Open in Desktop App Editing Share el come 9 Calib BE General A C D E F G H 1 Launch-it 1 2 3 4 5 6 7 Jake's Pet Supplies Pro Forma Contribution Margin income Statement For the month ending june 30 $6.00 6.OK ASSUMPTIONS Product 1 Launch Sales price per unit $10.00 Variable costs per unit: Supply Cost $1.00 Shipping and Handling $2.00 Comision $1.00 Total variable cost per un $4.00 Product 31 Unit CM ICM Breakeven point in units in sales revenue 13 250 2,500.00 Products $2.000.00 $830.00 $1,200.00 Product 2 $8.00000 $100,00 $120000 Sales Price LAS: Variable costs Contribution Martin Led Costs Operating income Total 55 000.00 2.00.00 37000.00 $100.00 $900.00 Target profit volume -in units in sales revenue 1583 15.83333 Monthly volume 200 IS 4 Overall CMS Treat time $10.00 Treat time $12.00 4 ON 10 11 12 13 14 15 16 12 18 15 20 21 22 21 24 25 Total Product 22 Sales price per un Variable costs per unit: Supply Coil Shipping and Marding Comission total variable cost per un Product ? lunit CM CM Breakeven point in units - sales revenue $7,00 SK.CO $1.00 STR00 125 $3.750.00 Pret 2 31200 100 $1.100.00 Calcun of Welshada CM Products OM/Unit $6.00 Sales Monach soldi 200 Contribuon Margin 200.00 Sales Mix 067 Overall CM DE 300 Monthly Ville 100 Target profit volume in its in sales revue 792 23.250.00 s Produ Filed costs per month Salary Trade booth fees Toted costs per month $1.000.00 $500.00 $1,500.00 nn Miproducten ont units Sales revenue bresleven Product 325 5125000 SLEDO 3312 22 $8.000.00 Tot Tarptat per month Product 20 Multiproduct ratt units 5.OOK Dupected chante in lume 31 Chedd Advising dient Starting file Business Directions w Code MacBook Pro 300 Sales MIX ( Sola Contribution Margin Sales Mix % Overall CM per unit 200 $1,200.00 0.67 100 $1,200.00 0.33 $2,400.00 $8.00 Multiproduct Breakeven point: -in units Sales revenue at breakeven Product #1 125 $1,250.00 Product #2 63 $1,875.00 Total 188 $3,125.00 Product #1 Product #2 Total Multiproduct Target profit point: -in units Sales revenue at target profit Margin of Safety (in $) $1,875.00 Margin of Safety % 38% Operating Leverage Factor 2.7 Expected % change in operating income (%) 13.33% ungprod.replet.com El Preet Wys. One Ture Pro H! Excel Excel Project CVP . Saved Search Option le Home Insert Draw Page Layout Formulas De Review View Help Open in Desktop App Editing Share el come 9 Calib BE General A C D E F G H 1 Launch-it 1 2 3 4 5 6 7 Jake's Pet Supplies Pro Forma Contribution Margin income Statement For the month ending june 30 $6.00 6.OK ASSUMPTIONS Product 1 Launch Sales price per unit $10.00 Variable costs per unit: Supply Cost $1.00 Shipping and Handling $2.00 Comision $1.00 Total variable cost per un $4.00 Product 31 Unit CM ICM Breakeven point in units in sales revenue 13 250 2,500.00 Products $2.000.00 $830.00 $1,200.00 Product 2 $8.00000 $100,00 $120000 Sales Price LAS: Variable costs Contribution Martin Led Costs Operating income Total 55 000.00 2.00.00 37000.00 $100.00 $900.00 Target profit volume -in units in sales revenue 1583 15.83333 Monthly volume 200 IS 4 Overall CMS Treat time $10.00 Treat time $12.00 4 ON 10 11 12 13 14 15 16 12 18 15 20 21 22 21 24 25 Total Product 22 Sales price per un Variable costs per unit: Supply Coil Shipping and Marding Comission total variable cost per un Product ? lunit CM CM Breakeven point in units - sales revenue $7,00 SK.CO $1.00 STR00 125 $3.750.00 Pret 2 31200 100 $1.100.00 Calcun of Welshada CM Products OM/Unit $6.00 Sales Monach soldi 200 Contribuon Margin 200.00 Sales Mix 067 Overall CM DE 300 Monthly Ville 100 Target profit volume in its in sales revue 792 23.250.00 s Produ Filed costs per month Salary Trade booth fees Toted costs per month $1.000.00 $500.00 $1,500.00 nn Miproducten ont units Sales revenue bresleven Product 325 5125000 SLEDO 3312 22 $8.000.00 Tot Tarptat per month Product 20 Multiproduct ratt units 5.OOK Dupected chante in lume 31 Chedd Advising dient Starting file Business Directions w Code MacBook Pro
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started