Question: 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

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

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!