In the Filter Analysis worksheet: a. Select Economy ONLY and Quarter 1 ONLY in their respective columns.
b. In row 34, the next blank row after the data, in the revenue and number of cars columns, calculate the sum of that column by adding the contents of the addresses of the cells resulting from the filter action (should be two values for Revenue and two values for NumCars).
c. Format the two values to match the data above in the particular respective column.
Year Quarter Location CarClass Revenue NumCars
2019 Q2 Airport Economy $368,286 2153
2019 Q4 Downtown Premium $431,761 2562
2019 Q4 Downtown Hybrid $431,140 2620
2019 Q1 Downtown Premium $424,833 2661
2019 Q4 Downtown SUV $431,029 2708
2019 Q1 Downtown Hybrid $425,127 2729
2019 Q1 Downtown SUV $424,718 2799
2019 Q3 Downtown Premium $494,587 3006
2019 Q3 Downtown Hybrid $494,669 3065
2019 Q4 Airport Premium $540,411 3082
2019 Q2 Downtown Premium $500,347 3101
2019 Q4 Airport Hybrid $541,112 3115
2019 Q2 Downtown Hybrid $500,601 3172
2019 Q3 Downtown SUV $495,372 3197
2019 Q4 Airport SUV $540,599 3231
2019 Q2 Downtown SUV $500,494 3251
2019 Q1 Airport Economy $499,117 3296
2019 Q1 Airport Premium $565,965 3418
2019 Q1 Airport Hybrid $565,721 3515
2019 Q3 Airport Economy $593,981 3555
2019 Q2 Airport Premium $599,690 3556
2019 Q1 Airport SUV $565,749 3623
2019 Q2 Airport Hybrid $599,005 3650
2019 Q2 Airport SUV $599,382 3783
2019 Q3 Airport Premium $658,374 3883
2019 Q3 Airport Hybrid $658,702 3927
2019 Q3 Airport SUV $658,241 4097
2019 Q2 Downtown Economy $641,168 4302
2019 Q3 Downtown Economy $681,155 4540
2019 Q4 Downtown Economy $704,556 4620
2019 Q1 Downtown Economy $718,651 4898
2019 Q4 Airport Economy $918,045 5224

On july 1, 2016, killearn company acquired 103,000 of the outstanding shares of shaun company for $21 per share. this acquisition gave killearn a 40 percent ownership of shaun and allowed killearn to significantly influence the investee's decisions. as of july 1, 2016, the investee had assets with a book value of $6 million and liabilities of $1,468,500. at the time, shaun held equipment appraised at $140,000 above book value; it was considered to have a seven-year remaining life with no salvage value. shaun also held a copyright with a five-year remaining life on its books that was undervalued by $562,500. any remaining excess cost was attributable to goodwill. depreciation and amortization are computed using the straight-line method. killearn applies the equity method for its investment in shaun. shaun's policy is to declare and pay a $1 per share cash dividend every april 1 and october 1. shaun's income, earned evenly throughout each year, was $580,000 in 2016, $606,600 in 2017, and $649,200 in 2018. in addition, killearn sold inventory costing $93,000 to shaun for $155,000 during 2017. shaun resold $97,500 of this inventory during 2017 and the remaining $57,500 during 2018.a. determine the equity income to be recognized by killearn during each of these years. 2016 2017 2018b. compute killearn’s investment in shaun company’s balance as of december 31, 2018.

1. revising for conciseness - eliminating flabby expressions,limiting long lead-ins, and dropping unnecessary fillerstime is money in any business environment. people want information communicated quickly and clearly. to make your writing more concise and understandable, avoid flabby expressions, long lead-ins, and unnecessary fillers. your audience will appreciate your brevity.1. if your writing contains a flabby expression like in view of the fact that, replace it with the word because / although / probably .for each of the following two sentences, choose the best revision.2. i am sending you this letter to inform you that we have experienced an unexpected surprise within our expense sheet, but we are positively certain we will solve it.1) we need to inform you that we have experienced an unexpected surprise with our expense sheet, but we are midway to an end result.2) we have identified a problem with our expense sheet, but we will solve it.3) i am sending you this letter to inform you that we have a problem with our expense sheet, but we are positively certain we have a solution.3. it is the user who should contact the center.1) everyone knows that it is the user who should contact the center.2) the user should contact the center.3) if there is a problem, the user should contact the center.read the following passage, and then answer the question.[1] you scheduled seven conference calls for this morning between 10 and 11 a.m. [2] generally, the company limits the number of conference calls to three per hour. [3] i’m letting you know that in the future, we should be more careful about scheduling.4. which revision limits the long lead-in in sentence 3? 1) in the future, we should be more careful about scheduling.2) i’m letting you know so that in the future we are more careful about scheduling calls.3) so that you know in the future, we should be more careful about scheduling.

Johnson company uses the allowance method to account for uncollectible accounts receivable. bad debt expense is established as a percentage of credit sales. for 2018, net credit sales totaled $6,400,000, and the estimated bad debt percentage is 1.40%. the allowance for uncollectible accounts had a credit balance of $61,000 at the beginning of 2018 and $49,500, after adjusting entries, at the end of 2018.required: 1. what is bad debt expense for 2018 as a percent of net credit sales? 2. assume johnson makes no other adjustment of bad debt expense during 2018. determine the amount of accounts receivable written off during 2018.3. if the company uses the direct write-off method, what would bad debt expense be for 2018?