Function: SUMB Formula: Add, Divide, Subtract, Muliplyz Cell Referencing

Using Excel For Incremental Analysis for Elimination of a Product Line

PROBLEM

Cawley Company makes three models of tasers. Information on the three products is given below.

$\backslash$table$[[,$Tingler,Shocker,Stunner$],[$Sales$,$$$,300,000,$$$,500,000,$$$,200,000],[$Variable expenses,,$150,000,,200,000,,145,000],[$Contribution margin,,$150,000,,300,000,,55,000],[$Fixed expenses,,$120,000,,230,000,,95,000],[$Net income,$$,30,000,$$$,70,000,,(40,000)$