1. Contribution margin ratio = contribution /sales
= 103200/258000 X100 = 40%
Break even point = 115200/0.40 = $288,000
Break even point in unis = 288000/20 = 14400 units
2. Revised operating statement
Sales (258000+88000) = $346000
Variable cost (40%) = ($138400)
Contribution margin = $138400
Fixed cost (115200+6700) = ($121900)
Net operating income = $16500
Existing Operating Loss = $12000
Net Operating income increase (16500+12000) = 28500
3. Revised Operating income statement as per sale manager prediction
Revised sales price (20-10%) = 18 per unit
Revised cost (115200+33000) = $148200
Sales (25800X18) = $464400
Contribution margin = $325080 (464400X0.70)
Fixed cost = $148200
Net operating income = $176880
Net operating income (176880+12000) = $188880 as per sales manager prediction
4. Calculation of desired sales unit if target profit is $4800
Existing variable cost per unit (154800/15480) = $10 per unit
Add: package cost = $0.50
Revised Variable cost per unit = $10.50
Revised contribution (20-10.50) = $9.50
Desired Sales = Fixed cost+desired profit/ contribution per unit
= (140000+4100)/9.50 = 15169 units
5. Revised variable cost (10-3) = 7 per unit
Revised fixed cost (115200+55000) = $170200
Revised contribution per unit(20-7) = $13 per unit
Contribution (13X10320) = $134160
a. CM ratio = 134160/258000 = 52%
BEP Sales in Unit = 170200/13 = 13092 units
BEP in Value (13092X20) = $261840
b. Operating income statement, if next sales is 20400 units (value in $)
if operation is not automated If operation is automated
SP 20 20
VC 10 7
Contribution margin 10 13
Fixed cost 115200 170200
Contribution(20400units) 204000 265200
Operating income 88800 94800
(contribution-fixed cost)
c. Comments: As we see if company is automating its system the operating income is increased too94800. we will recommend for automation.
Due to erratic sales of its sole product-a high-capacity battery for laptop computers—PEM, Inc., has been...
Due to erratic sales of its sole product-a high-capacity battery for laptop computers-PEM, Inc., has been experiencing financial difficulty for some time. The company's contribution format income statement for the most recent month is given below. Sales (12,800 units $30 per unit) Variable expenses Contribution margin Fixed expenses Net operating loss $ 384,000 192,000 192,000 214,500 $ (22,500) Required: 1. Compute the company's CM ratio and its break even point in unit sales and dollar sales. 2. The president believes...
Due to erratic sales of its sole product-a high-capacity battery for laptop computers- PEM, Inc., has been experiencing financial difficulty for some time. The company's contribution format income statement for the most recent month is given below: Sales (13,300 units X. $399,000 $30 per unit) Variable expenses 239,400 Contribution margin 159,600 Fixed expenses 177,600 Net operating loss $ (18,000) Required: 1. Compute the company's CM ratio and its break-even point in unit sales and dollar sales. 2. The president believes...
Due to erratic sales of its sole product—a high-capacity battery for laptop computers—PEM, Inc., has been experiencing financial difficulty for some time. The company’s contribution format income statement for the most recent month is given below: Sales (12,500 units × $30 per unit) $ 375,000 Variable expenses 187,500 Contribution margin 187,500 Fixed expenses 210,000 Net operating loss $ (22,500 ) Required: 1. Compute the company’s CM ratio and its break-even point in unit sales and dollar sales. 2. The...
Due to erratic sales of its sole product—a high-capacity battery for laptop computers—PEM, Inc., has been experiencing financial difficulty for some time. The company’s contribution format income statement for the most recent month is given below: Sales (12,800 units × $30 per unit) $ 384,000 Variable expenses 192,000 Contribution margin 192,000 Fixed expenses 214,500 Net operating loss $ (22,500 ) 1. figure the company’s CM ratio and its break-even point in unit sales and dollar sales. 2. The president believes...
Due to erratic sales of its sole product-a high-capacity battery for laptop computers—PEM, Inc., has been experiencing financial difficulty for some time. The company's contribution format income statement for the most recent month is given below: Sales (13,300 units * $30 per unit) Variable expenses Contribution margin Fixed expenses Net operating loss $ 399,000 199,500 199,500 222,000 $ (22,500) Required: 1. Compute the company's CM ratio and its break-even point in unit sales and dollar sales. 2. The president believes...
Due to erratic sales of its sole product-a high-capacity battery for laptop computers-PEM, Inc., has been experiencing financial difficulty for some time. The company's contribution format income statement for the most recent month is given below: Sales (12,800 units * $20 per unit) Variable expenses Contribution margin Fixed expenses Net operating loss $ 256,000 153,600 102,400 114,400 $ (12,000) Required: 1. Compute the company's CM ratio and its break-even point in unit sales and dollar sales. 2. The president believes...
Due to erratic sales of its sole product-a high-capacity battery for laptop computers-PEM, Inc., has been experiencing financial difficulty for some time. The company's contribution format income statement for the most recent month is given below: Sales (13,100 units X $20 per unit) Variable expenses Contribution margin Fixed expenses Net operating loss $ 262,000 131,000 131,000 146,000 $ (15,000) Required: 1. Compute the company's CM ratio and its break-even point in unit sales and dollar sales. 2. The president believes...
Due to erratic sales of its sole product-a high-capacity battery for laptop computers-PEM, Inc., has been experiencing financial difficulty for some time. The company's contribution format income statement for the most recent month is given below: Sales (12,700 units X $30 per unit) Variable expenses Contribution margin Fixed expenses Net operating loss $ 381,000 228,600 152,400 170,400 $ (18,000) Required: 1. Compute the company's CM ratio and its break-even point in unit sales and dollar sales. 2. The president believes...
Due to erratic sales of its sole product-a high-capacity battery for laptop computers-PEM, Inc., has been experiencing financial difficulty for some time. The company's contribution format income statement for the most recent month is given below: Sales (12,600 units X $30 per unit) Variable expenses Contribution margin Fixed expenses Net operating loss $ 378,000 226,800 151,200 169,200 $ (18,000) Required: 1. Compute the company's CM ratio and its break-even point in unit sales and dollar sales. 2. The president believes...
Due to erratic sales of its sole product-a high-capacity battery for laptop computers-PEM, Inc., has been experiencing financial difficulty for some time. The company's contribution format income statement for the most recent month is given below: Sales (13,000 units X $30 per unit) Variable expenses Contribution margin Fixed expenses Net operating loss $ 390,000 234,000 156,000 174,000 $ (18,000) Required: 1. Compute the company's CM ratio and its break-even point in unit sales and dollar sales. 2. The president believes...