Copy and Paste income statement below into an excel worksheet to create a one-variable data table. The one- variable data table has already been set up below, please complete the table by using the excel one-variable data table feature to fill in the missing data in cells F8:H19.

1. What is the input cell? Use the cell address from the income statement

2. Is it a column or a row input cell?

3. What is/are the result cells? (Write 'Y' to all that apply)

B6 (Y or N)

B14 (Y or N)

B24 (Y or N)

B5 (Y or N)

B25 (Y or N)

Creative Ventures For Test
2010 Income Statement
Revenue	Projected
Units Sold	24,000				One-Variable Data Table
Price per Unit	$26.00
Total Revenue	$624,000.00			Units Sold	Total Revenue	Total Expenses	Net Income
				24,000	$624,000.00	$519,560.00	$104,440.00
Variable Expenses	Projected			25,000
Units Produced	25,200			30,000
Material Cost per Unit	$6.20			35,000
Total Material Cost	$156,240.00			40,000
Manufacturing Cost per Unit	$4.10			45,000
Total Manufacturing Cost	$103,320.00			50,000
Total Variable Expenses	$259,560.00			55,000
				60,000
Fixed Expenses	Projected			65,000
Salaries and Benefits	$200,000.00			70,000
Advertising	$25,000.00			75,000
Administrative	$20,000.00			80,000
Miscellaneous	$15,000.00
Total Fixed Expenses	$260,000.00
Summary	Projected
Total Revenue	$624,000.00
Total Expenses	$519,560.00
Net Income	$104,440.00