1. Create a Variable or CVP Income Statement to the right or below for PEM, Inc

2. What is the break even in revenue $$?

PLEASE DO IT ON EXCEL. THANK YOU

PEM, Inc makes a single product. First year income statement is Variable costs per unit Material Labor Overhead Selling Fixed costs $ 6.00 Overhead $ 300,000.00 ($12/unit) $ 9.00 Selling $ 190,000.00 $ 3.00 $ 5.00 Units sold 25,000 Units Producer 25,000 End Inventory Sale price $ 50.00 Traditional Profit & Loss Statement 1,250,000 Sales (25,000 at $50) Cost of Goods Sold: Cost of Goods Sold (25000*30) 750,000 Gross Profit 500,000 Variable Selling (25000*5) Fixed selling 125,000 190,000 Net Income 185,000