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?

Reviews

Write a Review

 

Financial Accounting Questions & Answers

  Polar manufacturing is approached by a european customer to

polar manufacturing is approached by a european customer to complete a one-time-only special order for a product

  Maximum dpad tax savings for this c corporation

Katrina owns 100% of Money Corporation's stock.  Katrina's basis in the stock is $8,000.  Money Corporation has E&P of $40,000.  If Money Corporation redeems 60% of Katrina's stock for $50,000, Katrina must report dividend income of. Dodge Inc., has ..

  Develop critical skills by analyzing ethical and legal issue

Develop critical skills by analyzing ethical and legal issues and problems, recognizing and assessing such issues and recommending specific actions to implement your analyses

  Evaluate the depreciation expense for the second years

Evaluate the depreciation expense for the second years of operation using (a) straight-line method, (b) units of production, (c) declining balance method at twice the straight line rate and (d) sum of the years method.

  Finding capacity ratio liquidy ratio for forgetful

finding capacity ratio liquidy ratio for forgetful insurancebackground this project provides a set of annual statements

  Advise the board of cemer holdings

Advise the Board of Cemer Holdings Ltd about which of the two options would result in Cemer Holdings Ltd receiving the greater cash proceeds on disposal of its investment in Properties

  Illustrate what are some of the risks of the interviewer

Illustrate what are some of the risks of the interviewer basing their decisions on these interpretations? How can the interviewer minimize or avoid these risks?"

  What point will the inventory be transferred

Why do you think that this amount is not shown in a separate inventory account? In which of the accounts shown is the inventory likely to be? At what point will the inventory be transferred to a separate inventory account?

  Rolling budgets have the advantage of allowing a company to

rolling budgets have the advantage of allowing a company to adjust its annual forecasts in order to take into account

  Determine a budget variance

Determine a budget variance and a volume variance and determine a budget variance and a volume variance for fixed manufacturing overhead costs for the year

  Explain and give an example of assurance services

Please define, explain and give an example of assurance services. Please define, explain and give an example of an attestation engagement.

  Use the gross method of accounting for sales discounts

Make all journal entries necessary to record both the sales and the cash collections. Use the gross method of accounting for sales discounts.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd