(show steps/screenshots on excel how you construct a two-way data table)
the gatson manufacturing company has estimated the following components for a new product.
fixed cost = $50,000
material cost per unit = $2.15
labor cost per unit = $2.00
revenue per unit = $7.50
construct a spreadsheet model and then use use a two-way data table to show how the profit changes as a function of different production volumes and different values of material cost per unit. vary the production volume from 0 to 100,000 in increments of 10,000. the five different material costs are $1.50, $1.95, $2.15, $2.85, and $3.25.