Posted: May 8th, 2015

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