Business, 18.06.2020 21:57 ttorres013

The file taxdata contains information from federal tax returns filed in 2007 for all counties in the United States (3,142 counties in total). Create a PivotTable in Excel to answer the following questions. The PivotTable should have State Abbreviation as Row Labels. The Values in the PivotTable should be the sum of adjusted gross income for each state. a. Sort the PivotTable data to display the states with the smallest sum of adjusted gross income on top and the largest on the bottom. Which state had the smallest sum of adjusted gross income? What is the total adjusted gross income for federal tax returns filed in this state with the smallest total adjusted gross incomeb. Add the County Name to the Row Labels in the PivotTable. Sort the County Names by Sum of Adjusted Gross Income with the lowest values on top and the highest values on bottom. Filter the Row Labels so that only the state of Texas is displayed. Which county had the smallest sum of adjusted gross income in the state of Texas? Which county had the largest sum of adjusted gross income in the state of Texas?c. Click on Sum of Adjusted Gross Income in the Values area of the PivotTable in Excel. Click Value Field Settings . . . . Click the tab for Show Values As. In the Show values as box, choose % of Parent Row Total. Click OK. This displays the adjusted gross income reported by each county as a percentage of the total state adjusted gross income. Which county has the highest percentage adjusted gross income in the state of Texas? What is this percentage?d. Remove the filter on the Row Labels to display data for all states. What percentage of total adjusted gross income in the United States was provided by the state of New York?

Answers: 3

Show answers

Another question on Business

Business, 21.06.2019 21:30

The following account balances at the beginning of january were selected from the general ledger of fresh bagel manufacturing company: work in process inventory $0 raw materials inventory $ 28 comma 100 finished goods inventory $ 40 comma 600 additional data: 1. actual manufacturing overhead for january amounted to $ 65 comma 000. 2. total direct labor cost for january was $ 63 comma 400. 3. the predetermined manufacturing overhead rate is based on direct labor cost. the budget for the year called for $ 255 comma 000 of direct labor cost and $ 382 comma 500 of manufacturing overhead costs. 4. the only job unfinished on january 31 was job no. 151, for which total direct labor charges were $ 5 comma 200 (1 comma 300 direct labor hours) and total direct material charges were $ 14 comma 400. 5. cost of direct materials placed in production during january totaled $ 123 comma 700. there were no indirect material requisitions during january. 6. january 31 balance in raw materials inventory was $ 35 comma 300. 7. finished goods inventory balance on january 31 was $ 35 comma 400. what is the cost of goods manufactured for january?

Answers: 3

Answer

Business, 22.06.2019 06:30

Ummit record company is negotiating with two banks for a $157,000 loan. fidelity bank requires a compensating balance of 24 percent, discounts the loan, and wants to be paid back in four quarterly payments. southwest bank requires a compensating balance of 12 percent, does not discount the loan, but wants to be paid back in 12 monthly installments. the stated rate for both banks is 9 percent. compensating balances will be subtracted from the $157,000 in determining the available funds in part a. a-1. calculate the effective interest rate for fidelity bank and southwest bank. (do not round intermediate calculations. input your answers as a percent rounded to 2 decimal places.) a-2. which loan should summit accept? southwest bank fidelity bank b. recompute the effective cost of interest, assuming that summit ordinarily maintains $37,680 at each bank in deposits that will serve as compensating balances

Answers: 1

Answer

Business, 22.06.2019 19:20

The following information is from the 2019 records of albert book shop: accounts receivable, december 31, 2019 $ 42 comma 000 (debit) allowance for bad debts, december 31, 2019 prior to adjustment 2 comma 000 (debit) net credit sales for 2019 179 comma 000 accounts written off as uncollectible during 2017 15 comma 000 cash sales during 2019 28 comma 500 bad debts expense is estimated by the method. management estimates that $ 5 comma 300 of accounts receivable will be uncollectible. calculate the amount of bad debts expense for 2019.

Answers: 2

Answer

Business, 22.06.2019 21:10

Krier industries has just completed its sales forecasts and its marketing department estimates that the company will sell 43,800 units during the upcoming year. in the past, management has maintained inventories of finished goods at approximately 3 months' sales. however, the estimated inventory at the start of the year of the budget period is only 7,300 units. sales occur evenly throughout the year. what is the estimated production level (units) for the first month of the upcoming budget year?

Answers: 3

Answer

You know the right answer?

The file taxdata contains information from federal tax returns filed in 2007 for all counties in the...

Questions