I need to the below data to be put in excel to answer the questions. Not sure how to do it?

Prepare a segmented variable costing (behavioral) income statement for the company in good format.

Prepare a second variable costing statement assuming 90% of all the books in each category purchased were actually sold.

Prepare a third variable costing statement assuming that the price is increased by 50% for all five categories (use original sales information).

The owner enjoys the used-book business. Any suggestions as how to turn this into a full-time business venture so the owner can quit his other job? Prepare another income statement to support your idea.

Data Given.

Units Sold	2,000	1,000	500	400	400
Units Purchased	3,000	1,200	1,000	1,000	1,000
Resale Price	$4.00	$15.00	$25.00	$45.00	$40.00
Cost	$0.50	$5.00	$10.00	$20.00	$20.00
Variable operating expenses
	Shipping per book	$1.50
Fixed expenses
	Internet-related costs	$5,000
	Travel, etc.	2,000
	Advertising	1,000
	Other overhead	3,000