Chapter 4, Problem 5R

The following information is for Bonnieʼs Buds, a nursery and floral shop, for the month ended May 31, 2012:

Click the Chart sheet tab on the FMERCH3 file. You will see a chart depicting the five-month trend in sales, gross profit, and net income. What favorable and unfavorable trends do you see in this month-to-month comparison? Comment on any unusual changes. When the assignment is complete, close the file without saving it again.

Worksheet. Your boss would prefer to have the balance sheet shown before the income statement and the statement of retained earnings. Please make this change on the FMERCH3 file. Preview the printout to make sure that the worksheet will print neatly on two or three pages, and then print the worksheet. Save the completed file as FMERCHT.

Chart. Using the FMERCH3 file, prepare a 3-D pie chart that shows the amount of each of the selling expenses in June. No Chart Data Table is needed. Select A57 to A62 as one range on the worksheet to be charted and then hold down the CTRL key and select E57 to E62 as the second range. Enter your name somewhere on the chart. Save the file again as FMERCH3. Select the chart and then print it out.