calculate these values to use excel.

D E F Year 2016 Produced (units) Revenue/unit Direct materials/unit Direct labor/unit Overhead/unit Info A 900,000 0.12 0.05 0.01 0.005 B 275,000 0.28 0.07 0.01 0.005 12,000 8.48 3.8 1 0.5 1 2. 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 *The fixed Overhead can be calculated as the 60% of varible overhead, based on 2016 production Selling/Admin Expenses 55,000 Tax rate 0 Income Statement Ot 0 Revenue: Cost of good sold: Direct materials Direct labor Variable OH Fixed OH Gross Profit: Selling/Admin Expenses: Profit Before Tax: Income Tax Expense: Net Income: -06