Millie and Milo Wermz are the owners and managers of a small bookstore, The Book Wermz, near a college campus. The store specializes in rare and out-of-print books. During September 2004, the company sold $40,000 of books. The books cost the company $28,000. The cost of other resources used during September included:

Wages .........$4,200

Supplies ......... 2,000

Rent ......... 1,500

Utilities ........ 300

Required Use a spreadsheet to prepare a report describing profit earned by The Book Wermz for September. The spreadsheet should contain the following heading:

The Book Wermz

Profit Earned

For September 2004

The merge and center button a can be used to center the heading in the first three rows of the spreadsheet. Select the cells that will contain the heading, and then click the merge button to combine these cells. The report should list each resource created or consumed during September and should include a formula to automatically calculate the profit earned as the difference between resources created and resources consumed. Use the appropriate format buttons to format the numbers to include commas. Show resources consumed as negative amounts. The first and last numbers in the column should include dollar signs.