Please give positive ratings so I can keep answering. It would help me a lot. Please comment if you have any query. Thanks! |
PEM Inc. | ||
Calculation of Variable expense per unit | Amount $ | Note |
Variable expenses | 192,000.00 | A |
Units sold | 12,800.00 | B |
Variable expense per unit | 15.00 | C=A/B |
Answer 1 | Amount $ | |
Sales | 384,000.00 | D |
Contribution margin | 192,000.00 | E |
CM ratio | 50.00% | F=E/D |
Units sold | 12,800.00 | See B |
Contribution margin per unit | 15.00 | G=E/B |
Fixed expense | 214,500.00 | H |
Break even units | 14,300.00 | I=H/G |
Sell price | 30.00 | J |
Break even $ | 429,000.00 | K=I*J |
Answer 2 | ||
Increase in sales | 90,000.00 | L |
CM ratio | 50.00% | See F |
Increase in Contribution margin | 45,000.00 | M=L*F |
Less: Advertising expense | 7,000.00 | |
Increase in net operating income | 38,000.00 | |
Answer 3 | ||
Current Sell price | 30.00 | See J |
Reduction by 10% | 3.00 | N=J*10% |
Revised Sell price | 27.00 | O=J-N |
Current Sales units | 12,800.00 | See B |
Increase by 100% | 12,800.00 | P=B*100% |
Revised Sales units | 25,600.00 | Q=B+P |
Income statement | Amount $ | |
Sell Price | 27.00 | See O |
Less: Variable expenses | 15.00 | See C |
Contribution per unit | 12.00 | R |
Units sold | 25,600.00 | See Q |
Contribution margin | 307,200.00 | S=R*Q |
Less: Fixed expense | 214,500.00 | |
Less: Advertising expense | 40,000.00 | |
Operating Income | 52,700.00 | |
Answer 4 | ||
Current Contribution per unit | 15.00 | |
Less: packaging costs | 0.70 | |
Revised Contribution per unit | 14.30 | T |
Target Profit | 4,500.00 | |
Add: Fixed expense | 214,500.00 | |
Target Contribution | 219,000.00 | U |
Revised Contribution per unit | 14.30 | See T |
Units to be sold | 15,314.69 | V=U/T |
Workings for Answer 5 | ||
Current Variable cost per unit | 15.00 | |
Reduction by | 3.00 | |
Revised Variable cost per unit | 12.00 | W |
Current Fixed costs | 214,500.00 | |
Increase by | 57,000.00 | |
Revised Fixed costs | 271,500.00 | X |
Answer 5 a | Amount $ | Note |
Sell price | 30.00 | See J |
Less: Variable expenses | 12.00 | See W |
Contribution margin per unit | 18.00 | Y |
CM ratio | 60.00% | Z=Y/J |
Fixed expense | 271,500.00 | See X |
Break even units | 15,083.33 | AA=X/Y |
Break even $ | 452,500.00 | AB=AA*J |
Answer 5 b | Not Automated | Automated | Note |
Sell Price | 30.00 | 30.00 | See J |
Less: Variable expenses | 15.00 | 12.00 | See C, W |
Contribution per unit | 15.00 | 18.00 | AC |
Units sold | 20,500.00 | 20,500.00 | AD |
Contribution margin | 307,500.00 | 369,000.00 | AE=AC*AD |
Less: Fixed expense | 214,500.00 | 271,500.00 | See H, X |
Operating Income | 93,000.00 | 97,500.00 | |
Increase in Operating Income by | 4,500.00 |
Answer 5 c |
If automation is done then operating income will increase by $ 4,500 so yes the company should automate its operations. |
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 (12,600 units × $30 per unit) $ 378,000 Variable expenses 226,800 Contribution margin 151,200 Fixed expenses 169,200 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...
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 × $20 per unit) $ 254,000 Variable expenses 127,000 Contribution margin 127,000 Fixed expenses 142,000 Net operating loss $ (15,000 ) 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 × $20 per unit) $ 256,000 Variable expenses 128,000 Contribution margin 128,000 Fixed expenses 143,000 Net operating loss $ (15,000 ) 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...
3 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 4.5 points Sales (13,300 units x $30 per unit) Variable expenses Contribution margin Fixed expenses Net operating los:s 399,000 199,500 199,500 222,000 (22,500) eBook 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 (19,500 units × $30 per unit) $ 585,000 Variable expenses 409,500 Contribution margin 175,500 Fixed expenses 180,000 Net operating loss $ (4,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 (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 (12,600 units × $20 per unit) $ 252,000 Variable expenses 126,000 Contribution margin 126,000 Fixed expenses 141,000 Net operating loss $ (15,000 ) Required: 1. Compute the company’s CM ratio and its break-even point in unit sales and dollar sales. 2. The president...