Question: Problem 3-20 Points: Complete the worksheet analysis table for Washington Integration Company. The company sells three products (code names: Routers, NIC Chips, CAT 6 Cable).


Problem 3-20 Points: Complete the worksheet analysis table for Washington Integration Company. The company sells three products (code names: Routers, NIC Chips, CAT 6 Cable). Total product sales are $4,000,000. A. Calculate the sales for each product and the variable cost for each product. B. Calculate the Contribution Margin (C/M) for each product and the total. C. Determine the net income or (loss) for the overall company. D. Indicate the percent of total (two decimal places XX.XX%) for each product for the sales, variable costs and contribution margin in the Total Products column. E. Calculate the overall sales dollars necessary to break-even. Suggest using the C/M ratio (%) formula. Product Routers Product NIC Chips Product CAT 6 Cable Total Products % of total sales 60% 15% 25% 100% Sales 100% 100% 100% $4,000,000 100.00% V/C 40% 50% 20% 0.00% C/M 60% 50% 80% 100.00% F/C $510,000 Net Income Fixed costs Contribution Margin % Break-even dollars
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
