Microsoft Office Tutorials and References
In Depth Information
projects monthly sales revenues, costs of goods sold, gross margin, expenses, and
operating income for the upcoming tourist season, based on gures from the previous
year. The owner requires an easy-to-read worksheet that shows nancial projections
for the upcoming season to use for procuring partial nancing and for determining
staffing needs. The worksheet should allow for quick analysis if projections for certain
numbers change, such as the percentage of expenses allocated to commission or
the cost of the kiosk rentals. In addition, a column chart is required that shows the
breakdown of expenses into categories for each month in the season.
(a) Worksheet
(b) Clustered Column Chart
Figure 3–1
EX 131
Search JabSto ::

Custom Search