a) Build a spreadsheet model that calculates profit or loss, using the principles of good spreadsheet design. If Harris makes 15,000 units, what is the resulting profit? b) Construct a one-way data table with production volume as the column input and profit as the output. Vary production volume from 0 to 100,000 in increments of 10,000. In which interval of production volume does breakeven occur? c) Construct a two-way data table with production volume as the column input and revenue per unit as the row input. Vary production volume from 0 to 100,000 in increments of 10,000. Input the revenue per units as $.75, $.85, $.95, $1.05. d) Use Goal Seek to find the exact breakeven point. Hint: To value: = 0.
a) Build a spreadsheet model that calculates profit or loss, using the principles of good spreadsheet design. If Harris makes 15,000 units, what is the resulting profit?
b) Construct a one-way data table with production volume as the column input and profit as the output. Vary production volume from 0 to 100,000 in increments of 10,000. In which interval of production volume does breakeven occur?
c) Construct a two-way data table with production volume as the column input and revenue per unit as the row input. Vary production volume from 0 to 100,000 in increments of 10,000. Input the revenue per units as $.75, $.85, $.95, $1.05.
d) Use Goal Seek to find the exact breakeven point. Hint: To value: = 0.
Step by step
Solved in 3 steps with 1 images
