Answer the following: (Please show your complete solutions preferably in excel form)

• Determine the number of HVM drums (if any) that should be purchased and the number of HVM drums and/or bike frames (if any) that should be manufactured.
• What is the increase in net operating income that would result from this plan over the current operations?

The RVRCOB Holdings is a conglomerate that operates in multiple industries. Each firm it owns established a foothold and is among the leading players in the field. For the period, 3 of its major firms require study and major decisions, your Consultancy Services are engaged for: 1. Caryl Crates & Containers, Inc. (CCCI) 2. N & M Company 3. Fruitas Inc Caryl Crates & Containers, Inc. (CCCI) The firm sells a wide range of containers that are used in the chemical and laboratory industry. One of the company's products is a heavy-duty corrosion-resistant metal drum, called the HVM drum is used to store hazardous volatile materials (HVM) considered toxic wastes. Utilization of a Constrained Resource; Make or Buy Production of the HVM drum is constrained by the capacity of an automated welding machine that is used to make precision welds. A total of 2,000 hours of welding time is available annually on the machine. Because each drum requires 0.4 hours of welding time, annual production is limited to 5,000 drums. At present, the welding machine is used exclusively to make the HVM drum. The Accounting Department has provided the following financial data concerning the HVM drum: HVM Drums Selling Price per drum .........4. P 8,195.00 Cost per drum: Direct Materials . P 2,851.80 Direct Labor (P69.00 per hour) 196.80 Manufacturing Overhead ..... 245.80 Total unit manufacturing costs P 3,294.40 Unit Marketing & Admin Costs ..... 1,622.60 4,917.00 Margin per drum ......... 3,278.00 Management believes 6,000 HVM drums could be sold each year if the company had sufficient manufacturing capacity. As an alternative to adding another welding machine, management has considered buying additional drums from an outside supplier. Container Distributors Inc., a supplier of quality products, would be able to provide 4,000 HVM-type drums per year for P 7,621 per drum, which CCCI would resell to its customers at its normal selling after appropriate relabeling. Conchita Corazon, CCCI's production manager, has suggested that the company could make better use of the welding machine by manufacturing classic-elite bike frames, which would require only 0.5 hours of welding time per frame and yet sell for far more than the drums. Conchita believes that CCCI could sell up to 1,600 classic-elite bike frames per year to bike manufacturers for $ 13,112 each.The Aocou nting Department has provided the following data concerning the proposed new product: Selling Price perframe.................................... F 13,112 Cost per frame: Direct Materials F 5,42U Direct Labor [F6933 per hour} Lsoooo Manufacturing Overhead 1,950.01? Total unit manufacturing costs FF S,9?U.DD Unit Marketing E Admin IIZosts 2,5?U 11,54D Margin per drum F' 1.52.00 The classicelite bike frames could be produced with existing equipment and personnel. Manufacturing overhead is allocated to the products based on direct labor hours. Most of the manufacturing overhead consists of fixed common costs such as rent on the factorv building. but some of it is variable. The variable manufacturing overhead has been estimated at F TEE-'5 per drum and F SEED per bike frame. The variable manufacturing overhead cost would not be incurred on drums acquired from an outside supplier. Selling and administrative expenses are allocated to the products based on revenues. Almost all of the selling and administrative expenses are fixed common costs, but it has been estimated that variable selling and administrative expenses amount to P 43.10 per drum and F' T110 per bike frame. All ofthe firm's emplovees direct and indirect are paid for full milhour workweeks and the company has a policv of laving off workers only in major recessions. Purchased HVM Drums Selling Price P8,195 Less: Purchase of Additional Drums P7,621 Contribution Margin per unit P574 Manufactured HVM Drums Sellings Price P8,195 Less: Variable Costs Direct Materials P2851.8 Direct Labor P196.8 Manufacturing Overhead P73.75 Unit Marketing & Admin Costs P48.7 P3,171.05 Contribution Margin per unit P5,023.95 Manufactured Classic-Elite Bike Frames Sellings Price P13,112 Less: Variable Costs Direct Materials #2851.8 Direct Labor P2760 Manufacturing Overhead P97.5 Unit Marketing & Admin Costs #77.1 P5786 Contribution Margin per unit P7326