Insight inc.
Contribution per unit: ($)
W | X | Y | Z | |
Selling price | 80 | 60 | 95 | 103 |
Less: Variable cost | (59) | (36) | (72) | (87) |
Contribution per unit | 21 | 24 | 23 | 16 |
Sales mix:
W | X | Y | Z | Total | |
Budgeted production (units) | 7,600 | 6,800 | 9,300 | 5,800 | 29,500 |
Sales mix (%) |
(7,600/29,500) 25.76% |
(6,800/29,500) 23.05% |
(9,300/29,500) 31.53% |
(5,800/29,500) 19.66% |
100% |
Weighted average contribution per unit:
W | X | Y | Z | |
Contribution per unit ($) | 21 | 24 | 23 | 16 |
Sales mix (%) | 25.76% | 23.05% | 31.53% | 19.66% |
Contribution per unit × Sales mix |
(21×25.76%) 5.41 |
(24×23.05%) 5.53 |
(23×31.53%) 7.25 |
(16×19.66%) 3.14 |
Weighted average Contribution per unit = (5.41+5.53+7.25+3.15) = $ 21.34
Break even point (company) = Fixed cost / Weighted average contribution per unit
= $ 950,000/21.34 = 44,517 units (approximately)
W | X | Y | Z | Total | |
Break even point (Company)(in units) | 44,517 | 44,517 | 44,517 | 44,517 | |
Sales mix | 25.76% | 23.05% | 31.53% | 19.66% | 100% |
Product units @ BEP (BEP × Sales mix)(in units) | 11,467.58 | 10,261.17 | 14,036.21 | 8,752.04 | |
Selling price | $ 80 | $ 60 | $ 95 | $ 103 | |
Break even sales (BEP units × Selling price) |
(11,467.58×80) $ 917,406 |
(10,261.17×60) $ 615,670 |
(14,036.21×95) $ 13,33,440 |
(8,742.04×103) $ 901,406 |
37,67,976 |
Margin of safety = (Actual sale - Break even sales) / Actual sale
= (50,00,000-37,67,976)/50,00,000
= 12,32,024/50,00,000
Margin of safety is 24.64%
vineyard test laboratories does heat testing Problem 1: Insight Inc. deals in four different products with...
BUS 2083 Introduction to Managerial Accounting Learning Activity 2 Due Date: January 20, 2020 Time: 2:09 Problem 1: Insight Inc, deals in four different products with different manufacturing process, and specifications You, as the production head, has been asked to prepare a cost sheet specifying the minimum number of units that the company must produce and sell in the upcoming year to ensure that the company does not run into losses. You asked the production manager of each product to...
Vineyard Test Laboratories does heat testing (HT) and stress testing (ST) on materials and operates at capacity. Under its current simple costing system, Vineyard aggregates all operating costs of $ 1 comma 190 comma 000 into a single overhead cost pool. Vineyard calculates a rate per test-hour of $ 17 ($ 1 comma 190 comma 000 / 70 comma 000 total test-hours). HT uses 40 comma 000 test-hours, and ST uses 30 comma 000 test-hours. Gary Maloney, Vineyard's controller, believes...
Holliston Test Laboratories does heat testing (HT) and stress testing (ST) on materials and operates at capacity. Under its current simple costing system, Holliston aggregates all operating costs of $1,275,000 into a single overhead cost pool. Holliston calculates a rate per test-hour of $15 ($1,275,000 / 85,000 total test-hours). HT uses 60,000 test-hours, and ST uses 25,000 test-hours. Gary Sarsfield, Holliston's controller, believes that there is enough variation in test procedures and cost structures to establish separate costing and billing...
TAG Metallic Inc. deals in main products, Metallic Doors and Window Frames. There have been recent concerns about profit fluctuations, and there are concerns whether the products are appropriately costed and priced. TAG Metallic uses a cost margin pricing policy and uses a pre-determined overhead absorption rate based on direct labour hours for doors and machine hours for windows. The rate is calculated at the start of the year based on the following information: -Production overhead GHS 1,500,000Direct labour hours 60,000Machine hours 100,000Set up...
The Zealand Company is a publicly traded corporation that produces different types of commercial food processors. My name is Alan Smith and I have worked for this company for the last ten years in the controller’s office. I was both an accounting and finance major in university. The company currently produces 300 products and does not anticipate any new products coming out over the next three years. I have previously mentioned to my superiors that it is not appropriate for...
The Zealand Company is a publicly traded corporation that produces different types of commercial food processors. My name is Alan Smith and I have worked for this company for the last ten years in the controller’s office. I was both an accounting and finance major in university. The company currently produces 300 products and does not anticipate any new products coming out over the next three years. I have previously mentioned to my superiors that it is not appropriate for...
The Zealand Company is a publicly traded corporation that produces different types of commercial food processors. My name is Alan Smith and I have worked for this company for the last ten years in the controller’s office. I was both an accounting and finance major in university. The company currently produces 300 products and does not anticipate any new products coming out over the next three years. I have previously mentioned to my superiors that it is not appropriate for...
The Watts Company is a publicly traded corporation that produces different types of commercial food processors. My name is Alan Smith and I have worked for this company for the last ten years in the controller’s office. I was both an accounting and finance major in university. The company currently produces 300 products and does not anticipate any new products coming out over the next three years. I have previously mentioned to my superiors that it is not appropriate for...
The Watts Company is a publicly traded corporation that produces different types of commercial food processors. My name is Alan Smith and I have worked for this company for the last ten years in the controller’s office. I was both an accounting and finance major in university. The company currently produces 300 products and does not anticipate any new products coming out over the next three years. I have previously mentioned to my superiors that it is not appropriate for...
Instructions The demand for solvent, one of numerous products manufactured by Logan Industries Inc., has dropped sharply because of recent competition from a similar product. The company's chemists are currently completing tests of various new formulas, and it is anticipated that the manufacture of a superior product can be started on November 1, one month in the future No changes will be needed in the present production facilities to manufacture the new product because only the mixture of the various...