• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 20. Using PivotTables and PivotC... > Analyzing Costs with PivotCharts

Analyzing Costs with PivotCharts

With PivotCharts, you can analyze your information from the table of employee costs. The two important characteristics to look at when analyzing costs are the base costs versus overtime costs, and the regular hours versus overtime hours. These are due to specific variables in the workplace as to why overtime occurs (but you may be able to minimize cost by implementing a checkpoint with a signoff sheet before overtime occurs, and also with proper planning and scheduling).

The PivotChart enables you to get a quick picture of your situation and also look at ratios. If you have a way to measure your company's performance in output, for example, you'll want to look at the ratio of overtime against output and see the trends that occur over time. Soon you'll be able to focus on inefficiencies that result from specific occurrences in the workplace or business environment. Notice the field placement in the PivotChart in Figure 20.57, which includes a secondary axis for the overtime. Look at your information in ratio form—how and where overtime stacks up against regular time, and why certain employees have massive amounts of overtime versus others who have minimal amounts of overtime. This is generally because of improper workload distribution and planning.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint