Management

Management NewGen Robotics            In relation to the financial statement at the left, construct a two-variable data table 2011 Income Statement            beginning in cell E10 showing net income for units sold from 50,000 to 250,000 units in increments of 50,000 and sales prices of $350 up to $500 in increments of $25. Revenue    Projected Units Sold    102,391 Price per Unit    $399.95 Total Revenue    $40,951,280.45 Variable Expenses    Projected Units Produced (1% Surplus)    103,415 Material Cost per Unit    $175.50 Total Material Cost    $18,149,316.71 Manufacturing Cost per Unit    $143.25 Total Manufacturing Cost    $14,814,185.86 Total Variable Expenses    $32,963,502.56 Fixed Expenses    Projected Salaries and Benefits    $3,450,000.00 Advertising    $775,000.00 Administrative    $520,000.00 Miscellaneous    $500,000.00 Total Fixed Expenses    $5,245,000.00