In: Accounting
Silven Industries, which manufactures and sells a highly successful line of summer lotions and insect repellents, has decided to diversify in order to stabilize sales throughout the year. A natural area for the company to consider is the production of winter lotions and creams to prevent dry and chapped skin. |
After considerable research, a winter products line has been developed. However, Silven’s president has decided to introduce only one of the new products for this coming winter. If the product is a success, further expansion in future years will be initiated. |
The product selected (called Chap-Off) is a lip balm that will be sold in a lipstick-type tube. The product will be sold to wholesalers in boxes of 8 tubes for $7.50 per box. Because of excess capacity, no additional fixed manufacturing overhead costs will be incurred to produce the product. However, a $80,000 charge for fixed manufacturing overhead will be absorbed by the product under the company’s absorption costing system. |
Using the estimated sales and production of 100,000 boxes of Chap-Off, the Accounting Department has developed the following cost per box: |
Direct materials | $ | 3.90 | |
Direct labor | 1.00 | ||
Manufacturing overhead | 1.40 | ||
Total cost | $ | 6.30 | |
The costs above include costs for producing both the lip balm and the tube that contains it. As an alternative to making the tubes, Silven has approached a supplier to discuss the possibility of purchasing the tubes for Chap-Off. The purchase price of the empty tubes from the supplier would be $1.20 per box of 8 tubes. If Silven Industries accepts the purchase proposal, direct labor and variable manufacturing overhead costs per box of Chap-Off would be reduced by 10% and direct materials costs would be reduced by 20%. |
Required: | |
1a. |
Calculate the total variable cost of producing one box of Chap-Off. (Do not round intermediate calculations. Round your answer to 2 decimal places.) |
1b. |
Assume that the tubes for the Chap-Off are purchased from the outside supplier, calculate the total variable cost of producing one box of Chap-Off. (Do not round intermediate calculations. Round your answer to 2 decimal places.) |
1c. | Should Silven Industries make or buy the tubes? | ||||
|
2. |
What would be the maximum purchase price acceptable to Silven Industries? (Do not round intermediate calculations. Round your answer to 2 decimal places.) |
3. |
Instead of sales of 100,000 boxes, revised estimates show a sales volume of 114,000 boxes. At this new volume, additional equipment must be acquired to manufacture the tubes at an annual rental of $46,000. Assume that the outside supplier will not accept an order for less than 114,000 boxes. |
a. |
Calculate the total relevant cost of making 114,000 boxes and total relevant cost of buying 114,000 boxes. (Do not round intermediate calculations.) |
b. | Based on the above calculations, should Silven Industries make or buy the boxes? | ||||
|
4. |
Refer to the data in (3) above. Assume that the outside supplier will accept an order of any size for the tubes at $1.20 per box. Which of these is the best alternative? |
||||||||
|
Answer | ||||
1(a) | Total variable cost of producing one box of Chap-Off | |||
Have excess capacity | ||||
$80,000 fixed manufacturing OH remains same whether the product produced or not | ||||
Hence It is not relevant | ||||
Total Manufacturing OH absorbed | 1.40 | (given) | ||
Fixed manufacturing OH absorbed | 0.80 | |||
(80000/100000) | ||||
Variable manufacturing OH | 0.60 | |||
Total variable Costs | ||||
Direct Material | 3.90 | (given) | ||
Direct Labour | 1.00 | (given) | ||
Manufacturing OH | 0.60 | (above calculation) | ||
5.50 | ||||
1(b) | Total variable cost of producing one box of Chap-Off | |||
Total variable Costs | ||||
Direct Material | 3.12 | (3.9*80%) | ||
Direct Labour | 0.90 | (1*90%) | ||
Manufacturing OH | 0.54 | (.6*90%) | ||
Cost of tube from outside | 1.20 | (given) | ||
5.76 | ||||
1( c ) | Silven Industries should Make the tubes. | |||
2 | Total variable cost per box when buy | 5.76 | ||
Total variable cost per box when make | 5.50 | |||
Difference | 0.26 | |||
Current purchase price | 1.20 | |||
Difference in cost | 0.26 | |||
Maximum Price Acceptable | 0.94 | |||
3 (a) | Total Variable costs for one box | 5.50 | ||
Total Variable cost for 114000 boxes | 6,27,000.00 | (5.5*114000) | ||
Total fixed cost for 114000 boxes | 46,000.00 | (given rent) | ||
Total cost for 114000 boxes(Making) | 6,73,000.00 | |||
Total Variable costs for one box | 5.76 | |||
Total Variable cost for 114000 boxes | 6,56,640.00 | (5.76*114000) | ||
Total cost for 114000 boxes(Buying) | 6,56,640.00 | |||
3(b) | Total cost for 114000 boxes(Making) | 6,73,000.00 | ||
Total cost for 114000 boxes(Buying) | 6,56,640.00 | |||
So should Silven industries should Buy the boxes | ||||
4 | ||||
Total making cost of 100000 boxes | 5,50,000.00 | (5.5*100000) | ||
Total Buying cost of 14000 boxes | 80,640.00 | (5.76*14000) | ||
Total cost when 100000 making and 14000 buying | 6,30,640.00 | |||
Total cost for 114000 boxes(Making) | 6,73,000.00 | |||
Total cost for 114000 boxes(Buying) | 6,56,640.00 | |||
Best alternative is Making 100000 boxes and Buying 14000 boxes. | ||||