Chapter 3, Problem 6R

Open P2WORK4 and click the Chart sheet tab. On the screen, a pie chart shows the percentage composition of the total expenses of Sports Connection. Enter the percentages in the spaces provided.

Compare the percentages of Sports Connection with the national statistics provided. Comment on the differences noted. Why might depreciation, utilities, and rent (as a group) be so far off from the national percentages? Any explanation for salaries? Cost of goods sold? When the assignment is complete, close the file without saving it again.

TICKLERS (optional)

Worksheet. You prepared a balance sheet in requirement 5. Add a new sheet to P2WORK4 and prepare a balance sheet on it using the same format and values from requirement 5. Enter formulas in the balance sheet to reference the appropriate balance sheet cells in the worksheet. Use proper formats for all value cells. Enter your name above the balance sheet. Preview the balance sheet printout to make sure that it will print neatly on one page, and then print the worksheet. Save the completed file as P2WORKT.

Chart. Using the P2WORK4 file, create a column chart showing the dollar total of each of the expenses (except Cost of goods sold) of Sports Connection. 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 P2WORK4. Select the chart and then print it out.