Question

what is the breakeven levels of slaes in units and jn revenues ans what is the margin of safety?

Karmin manufacturing inc., (KMI), makes cars and has just decided to start manufacturing a new model, to be called the Queen Herbie (QH), based on the Karman Ghia and Vw bug, and is setting up a new division to make the new model. The budget for the first year for the new division follows. The two main parts of the new division will be the office administration run by Amy, and the factory plant run by Renee. Amy will have a monthly salary of $ 14,000 and the office building will be rented for a monthly rent of $ 4,000. The office and selling staff will receive a monthly salary of $ 22,000 total and the selling staff will also receive a $ 150 commission per each car sold. There will be a shipping cost of $ 450 per car. Since it is the first year of operations, there will be no beginning inventory, and the company is planning to produce only the units ordered, and thus there will be no ending inventory either. For simplicity, we can assume that the budgeted fixed costs for the plant will be the amounts paid out for the year, and that the normal capacity for the plant will be the expected order level. The factory will be rented for $ 60,000 annually, and the equipment (shifted from other parts of KMI) will have an annual depreciation of $ 45,000. Renee's salary for the year will be $152,000 and factory insurance for the year will be $ 8,000. Each unit of the new QH model will require $ 11,000 of metal, $ 2,000 of glass, and paint costing $ 800. The assembly line employees are paid by the hour $ 35 an hour, and the new QH model will require about 220 hours of labour time to assemble each car. The miscellaneous factory costs are made up of electricity and lubricants for the equipment of about $ 500 (electricity) and $ 300 (equipment lubricants) per car. The estimated sick pay and vacation pay for the assembly workers will be about $ 25,000 annually, and the wasted raw materials used in the production process should be about $ 100 per car manufactured The new QH model will sell for $ 34,000 each, and the estimated order quantity (the amount that is budgeted as sales for the first year) is 120 units.

Answer 1

Calculation of total fixed cost

Salary of Amy( $14,000 * 12)    $168,000

Office Building Rent($4,000*12) $48,000

Office and Selling staff salary($22,000*12)   $264,000

Factory Rent $60,000

Depreciation    $45,000

Renee's Salary $152,000

Factory Insurance $8,000

Sick and Vacation Pay $25,000

Total annual fixed cost    $770,000

Calculation of variable cost per unit

Metal $11,000

Glass    $2,000

Paint $800

Labor cost($35 * 220) $7,700

Miscellaneous Factory Cost-

Equipments     $500

Lubricants    $300

Wasted Raw materials $100

Selling Staff Commisison $150

Shipping cost $450

Variable cost per unit    $23,000

Selling Price Per unit = $34,000 per unit

Contribution per unit = Selling Price Per unit - Variable cost per unit

= $34,000 - $23,000

= $11,000

Break Even Point(units) = Fixed Cost / Contribution per unit

= $770,000 / $11,000

= 70 units

Break Even Point(sales) = 70 units * $34,000

= $23,80,000

Margin of safety sales = Total Sales - Break even point sales

= 120 units - 70 units

= 50 units