Create a two-variable Data Table that shows what happens to Profit as the Annual Fixed Cost varies from $28,000 to $80,000, incrementing by $4,000 at a time; while Unit Variable Cost varies from $6.00 to $13.00, incrementing by $1.00 at a time. Put your Annual Fixed Cost values down the rows and put your Unit Variable Cost values across the columns.

B 1 U- A % Format as Table Paste A 60 .00 .00 .0 Cell Styles Clipboard Font Alignment Number Styles A1 ! fx Fast Feet Shoes B D E F G 1 2 3 A Fast Feet Shoes Profit/Loss Analysis 4 PARAMETERS 5 6 7 Unit Sales Price Annual Fixed Cost Unit Variable Cost $25.00 $52,000 $9.00 Quantity 2,500 8 9 DECISION 10 11 12 OUTPUT 13 C13: =C16-C18 Annual Profit (Loss) ($12,000) C16: = C5*C10 Annual Revenue Annual Variable Cost Annual Total Cost $62,500 $22,500 $74,500 C17: = C7*C10 C18: = C6+C17 14 15 CALCULATIONS 16 17 18 19 20 21 22 23 24 25 26 27 20