Chapter 2, Problem 6R

The trial balance of Wikki Cleaners at December 31, 2012, the end of the current fiscal year, is as follows:

Information for the adjusting entries is as follows:

1. a. Cleaning supplies on hand on December 31, 2012, $18,750.
2. b. Insurance premiums expired during the year, $1,800.
3. c. Depreciation on equipment during the year, $21,600.
4. d. Wages accrued but not paid at December 31, 2012, $1,830.

With the F1WORK4 file open, click the Chart sheet tab. On the screen, a pie chart shows the percentage composition of the total expenses of Wikki Cleaners. Enter the percentages in the space provided. Compare the percentages of Wikki Cleaners with the national statistics provided.

Comment on the differences noted. Why might depreciation, utilities, and rent be so far off from the national percentages? When the assignment is complete, close the file without saving it again.

Worksheet. You prepared an income statement in requirement 6. Put a formal income statement somewhere on the F1WORK4 worksheet. Enter formulas in the income statement to reference the appropriate income statement cells in the worksheet. Use proper formats for all value cells. Enter your name above the income statement. Print your work (select and print just the income statement cells). Preview the printout to make sure that the income statement alone (not the whole worksheet) will print neatly on one page. Save the completed file as F1WORKT.

Chart. Using the F1WORK4 file, create a 3-D column chart showing the dollar total of each of the expenses of Wikki Cleaners. Use the Chart Data Table as a basis for preparing the chart. Use appropriate titles, legends, and formats. Enter your name somewhere on the chart. Save the file again as F1WORK4. Select the chart and then print it out.