Create various pivot tables to get the necessary subtotals

Assignment Help Financial Accounting

Reference no: EM13752044

Use the Excel file to answer the following questions. You will need to create various pivot tables to get the necessary subtotals to answer the questions. How does each salesperson's performance vary by quarter? I noticed that the quarter and year automatic options do not always appear when creating a pivot table. If they do, then you are set. If not, create extra columns such as =year() & month() first and then create a pivot table that subtotals by year and filters 3 months at a time to arrive at a subtotal by quarter. You can also sort the records and create three different subsets by year and use the automatic quarter subtotal in the pivot table. Use your creativity and get the subtotals. Finally, if you were the manager wishing to motivate your sales force, how would you distribute bonuses for the salespeople?

Reference no: EM13752044

Questions Cloud

Betty and charles were partners. : Albert, Betty and Charles were partners. The following circumstances applied:(a) CapitalAccording to the partnership agreement, Albert and Betty each contributed $20,000. Charles contributed no capital.(b) Advances

Complete journal entries : Complete journal entries: Jan. 1 Accepted Kent's 90 days, 10% note, as settlement of an outstanding. Received payment in full from Sam's. for outstanding note & interest

Evaluate the regression output of your regression model : Evaluate the regression output of your regression model. Is the output in good shape. Are there any modifications you would like to do. Is there any evidence of multicollinearity problem.

The devil gave me the opportunity to do it : Rational choice is a theory that is easy to understand and support. It is a natural child of the classical theory which is a natural progression from the religious or philosophical tenet of free will. Unlike the saying from an old television show "th..

Create various pivot tables to get the necessary subtotals : Use the Excel file to answer the following questions. You will need to create various pivot tables to get the necessary subtotals to answer the questions. How does each salesperson's performance vary by quarter? I noticed that the quarter and year au..

Deferred income tax expense : Harrison Corporation reported pretax book income of $627,500. Tax depreciation exceeded book depreciation by $490,000. In addition, the company received $290,000 of tax-exempt municipal bond interest. The company’s prior year tax return showed taxabl..

Make a recommendation for a government regulation : Make a recommendation for a government regulation, or law that you would like to see enacted. Think of the consequences (good and bad) of the proposed regulation or law that you have suggested to businesses, and to consumers. Consider any unintended ..

Determine the correct inventory amount : Columbia Bank and Trust is considering giving Gallup Company a loan. Before doing so, it decides that further discussions with Gallup’s accountant may be desirable. One area of particular concern is the Inventory account, which has a year-end balance..

Which assumed inventory cost flow method : Which assumed inventory cost flow method? Usually parallels the actual physical flow of merchandise? Assumes that goods available for sale during an accounting period are identical? Assumes that the latest units purchased are the first to be sold?

User Account

All Pages