Answer the following: (Please show your complete solutions)

• 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?

As soon as your analysis was shown to the top management team at CCCI, several managers argued about how direct labor costs should be treated when making this decision.

One manager argued that direct labor is always treated as a variable cost in textbooks and practice and has always been considered a variable cost of the firm. After all, direct means you can directly trace the cost of the products. If direct labor is not a variable cost, what is?

Another manager argued just as strenuously that direct labor costs should be considered fixed costs of the firm. No one had been laid off in over a decade, and for all practical purposes, everyone at the plant was on a monthly salary. Everyone classified as direct labor works on a regular 40-hour workweek, and overtime has been optional since the company adopted Lean Production techniques. Whether the welding machine is used to make drums or frames, the total payroll would be the same. There is enough slack, in the form of idle time, to accommodate any increase in total direct labor time that the bike frames would require.

Note: Please shower your solutions (preferably in Excel) so I can better understand how to solve the problem. Thank you!

The Accounting Department has provided the following data concerning the proposed new product: The classic-elite 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 factory building, but some of it is variable. The variable manufacturing overhead has been estimated at $73.75 per drum and $97.50 per bike frame. The variable manufaring 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 48.70 per drum and 77.10 per bike frame. All of the firm's employees - direct and indirect - are paid for full 40-hour workweeks and the company has a policy of laying off workers only in major recessions