You need to calculate the Average Days on Lot based on MSRP and/or Types using the...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
You need to calculate the Average Days on Lot based on MSRP and/or Types using the Inventory data. n. Enter functions into the Average Days on Lot chart area that calculate the following: • Insert a function in K10 that display the Average Days on Lot of all Types • Insert a function in L10 that display the Average Days on Lot of all Types that have a color of Red • Insert a function in M10 that displays the Average Days on Lot of all Types that have a GPS File Pastel L6 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 4 Home X Cut [Copy ✓ B Clipboard. Format Painter Year Insert Page Layout Type 2018 Sedan 2017 Coupe 2017 Coupe 2017 Truck 2018 SUV 2018 Coupe 2018 SUV 2017 Sedan 2018 Van 2018 Sedan 2017 Truck C 2018 Van 2018 Sedan 2017 Truck 2017 SUV 2017 Van 2017 Truck F 1 VIN Search 2 69716460 Arrival Date Raffle Eligit Special Notes 6/18/2017 3 4 5 6 7 8 9 10 11 12 2018 Truck 2017 SUV 2018 Sedan 2018 Coupe 2018 Van 2017 SUV 5 2017 Sedan 2018 Van 2017 Van 2018 Coupe 2018 Truck 2018 Sedan 2018 Coupe 2017 Sedan 2018 Sedan X Calibri B IU - Inventory D Red Red Color White White fo Gray Blue White Red Red Black Black Black Red White Blue White Red Black Black Black Red Gray Blue White Black Black Red Gray Black White Gray Red Font Loan Yes No No No Yes No No Yes Yes Yes Yes No No No No No No No Yes No Yes Yes No No Yes No Yes Yes Yes No Yes No Formulas E + 11 A A ✓ A GPS Data 5 Inventory Arrival Date 6/18/2017 11/16/2017 12/23/2017 10/9/2017 9/4/2017 3/15/2017 2/20/2017 2/8/2017 7/15/2017 1/21/2017 10/3/2017 8/25/2017 8/7/2017 12/10/2017 4/4/2017 5/24/2017 8/21/2017 Review 3/4/2017 7/25/2017 1/20/2017 6/14/2017 9/16/2017 7/23/2017 4/18/2017 6/17/2017 2/13/2017 2/27/2017 1/1/2017 8/27/2017 7/4/2017 12/20/2017 5/16/2017 View Help Alignment $ ab Wrap Text MSRP 24,989 $ $ 35,903 $ 23,623 $ 22,848 $ 19,841 Ś 24,463 $ 30,946 19,918 $ $ 34,718 17,511 $ $ 24,452 $ 37,516 Ś 33,695 $ $ G Merge & Center 26,057 26,534 31,193 21,916 $ 17,702 $ 35,004 $ 26,548 Ś 33,197 Ś $ 31,443 $ 28,285 $ 26,751 $ 38,433 $ 20,257 $ 31,604 $ 31,686 $ 27,818 $ 26,781 $ 21,504 Ś 38,427 H Days on Lot 5 General $%950 00 Number Special Notes 197 Raffle Eligible 46 9 84 119 292 Bonus Eligible 315 Bonus Eligible 327 Bonus Eligible 170 Raffle Eligible 345 Bonus Eligible 90 129 Raffle Eligible 147 Raffle Eligible 22 272 Bonus Eligible 222 Bonus Eligible 133 Raffle Eligible 303 Bonus Eligible 160 Raffle Eligible 346 Bonus Eligible 201 Bonus Eligible 107 162 Raffle Eligible 258 Bonus Eligible 198 Raffle Eligible 322 Bonus Eligible 308 Bonus Eligible 365 Bonus Eligible 127 Raffle Eligible 181 Raffle Eligible 12 230 Bonus Eligible G ISH Conditional Format as Formatting Table K VIN # Count Overall Normal Calculation VIN # VIN # 69716460 24948740 51210965 55320488 25856260 12040895 63178024 17516090 96152231 23686693 44261695 94758156 48675320 96934792 L Year Bad Check Cell M Type 2018 Sedan Year Year Styles Min MSRP Average Days On Lot Color:Red w/GPS Type Type 2018 Sedan 2018 Sedan 2018 Sedan 2018 Sedan 2018|Sedan 2018 Sedan 2018 Sedan 2018 Sedan 2018 Sedan 2018 Sedan 2018 Sedan 2018 Sedan 2018 Sedan 2018 Sedan N Good Neutral Explanatory... Input Color Combined Red Black Black Blue Black Gray Gray Black Blue White Red Gray Black Red Color Color Yes O Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes GPS Max MSRP GPS GPS Search Criteria Arrival Date Summary Data Search Results Arrival Date Arrival Date 6/18/2017 1/21/2017 8/27/2017 5/12/2017 11/5/2017 5/18/2017 3/7/2017 7/15/2017 7/3/2017 2/17/2017 1/23/2017 3/7/2017 6/17/2017 2/3/2017 A Insert Delete Format: Cells $ $ $ $ $ $ $ $ $ $ $ $ $ $ O MSRP Ave Days on Lot MSRP MSRP 24,989 17,511 27,818 21,929 24,985 37,251 37,141 29,530 38,807 36,340 24,559 35,272 37,195 30,544 Σ AutoSum Fill ✓Clear R Editing Days on Lot 27 Sort & Find & Filter Select Days on Lot Days on Lot S 197 Raffle Eligible 345 Bonus Eligible 127 Raffle Eligible 234 Bonus Eligible 57 0 Share 228 Bonus Eligible 300 Bonus Eligible 170 Raffle Eligible 182 Raffle Eligible 318 Bonus Eligible 343 Bonus Eligible 300 Bonus Eligible 198 Raffle Eligible 332 Bonus Eligible Ideas Special Notes Special Notes Special Notes Comme Ideas. Sensitivity Sensitivity Activate Windows Go to Settings to activate Windows. T • Insert a function in N10 that displays the Average Days on Lot of all Types that have a MSRP that is higher than 20000 and have a Color of White. You need to calculate the Average Days on Lot based on MSRP and/or Types using the Inventory data. n. Enter functions into the Average Days on Lot chart area that calculate the following: • Insert a function in K10 that display the Average Days on Lot of all Types • Insert a function in L10 that display the Average Days on Lot of all Types that have a color of Red • Insert a function in M10 that displays the Average Days on Lot of all Types that have a GPS File Pastel L6 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 4 Home X Cut [Copy ✓ B Clipboard. Format Painter Year Insert Page Layout Type 2018 Sedan 2017 Coupe 2017 Coupe 2017 Truck 2018 SUV 2018 Coupe 2018 SUV 2017 Sedan 2018 Van 2018 Sedan 2017 Truck C 2018 Van 2018 Sedan 2017 Truck 2017 SUV 2017 Van 2017 Truck F 1 VIN Search 2 69716460 Arrival Date Raffle Eligit Special Notes 6/18/2017 3 4 5 6 7 8 9 10 11 12 2018 Truck 2017 SUV 2018 Sedan 2018 Coupe 2018 Van 2017 SUV 5 2017 Sedan 2018 Van 2017 Van 2018 Coupe 2018 Truck 2018 Sedan 2018 Coupe 2017 Sedan 2018 Sedan X Calibri B IU - Inventory D Red Red Color White White fo Gray Blue White Red Red Black Black Black Red White Blue White Red Black Black Black Red Gray Blue White Black Black Red Gray Black White Gray Red Font Loan Yes No No No Yes No No Yes Yes Yes Yes No No No No No No No Yes No Yes Yes No No Yes No Yes Yes Yes No Yes No Formulas E + 11 A A ✓ A GPS Data 5 Inventory Arrival Date 6/18/2017 11/16/2017 12/23/2017 10/9/2017 9/4/2017 3/15/2017 2/20/2017 2/8/2017 7/15/2017 1/21/2017 10/3/2017 8/25/2017 8/7/2017 12/10/2017 4/4/2017 5/24/2017 8/21/2017 Review 3/4/2017 7/25/2017 1/20/2017 6/14/2017 9/16/2017 7/23/2017 4/18/2017 6/17/2017 2/13/2017 2/27/2017 1/1/2017 8/27/2017 7/4/2017 12/20/2017 5/16/2017 View Help Alignment $ ab Wrap Text MSRP 24,989 $ $ 35,903 $ 23,623 $ 22,848 $ 19,841 Ś 24,463 $ 30,946 19,918 $ $ 34,718 17,511 $ $ 24,452 $ 37,516 Ś 33,695 $ $ G Merge & Center 26,057 26,534 31,193 21,916 $ 17,702 $ 35,004 $ 26,548 Ś 33,197 Ś $ 31,443 $ 28,285 $ 26,751 $ 38,433 $ 20,257 $ 31,604 $ 31,686 $ 27,818 $ 26,781 $ 21,504 Ś 38,427 H Days on Lot 5 General $%950 00 Number Special Notes 197 Raffle Eligible 46 9 84 119 292 Bonus Eligible 315 Bonus Eligible 327 Bonus Eligible 170 Raffle Eligible 345 Bonus Eligible 90 129 Raffle Eligible 147 Raffle Eligible 22 272 Bonus Eligible 222 Bonus Eligible 133 Raffle Eligible 303 Bonus Eligible 160 Raffle Eligible 346 Bonus Eligible 201 Bonus Eligible 107 162 Raffle Eligible 258 Bonus Eligible 198 Raffle Eligible 322 Bonus Eligible 308 Bonus Eligible 365 Bonus Eligible 127 Raffle Eligible 181 Raffle Eligible 12 230 Bonus Eligible G ISH Conditional Format as Formatting Table K VIN # Count Overall Normal Calculation VIN # VIN # 69716460 24948740 51210965 55320488 25856260 12040895 63178024 17516090 96152231 23686693 44261695 94758156 48675320 96934792 L Year Bad Check Cell M Type 2018 Sedan Year Year Styles Min MSRP Average Days On Lot Color:Red w/GPS Type Type 2018 Sedan 2018 Sedan 2018 Sedan 2018 Sedan 2018|Sedan 2018 Sedan 2018 Sedan 2018 Sedan 2018 Sedan 2018 Sedan 2018 Sedan 2018 Sedan 2018 Sedan 2018 Sedan N Good Neutral Explanatory... Input Color Combined Red Black Black Blue Black Gray Gray Black Blue White Red Gray Black Red Color Color Yes O Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes GPS Max MSRP GPS GPS Search Criteria Arrival Date Summary Data Search Results Arrival Date Arrival Date 6/18/2017 1/21/2017 8/27/2017 5/12/2017 11/5/2017 5/18/2017 3/7/2017 7/15/2017 7/3/2017 2/17/2017 1/23/2017 3/7/2017 6/17/2017 2/3/2017 A Insert Delete Format: Cells $ $ $ $ $ $ $ $ $ $ $ $ $ $ O MSRP Ave Days on Lot MSRP MSRP 24,989 17,511 27,818 21,929 24,985 37,251 37,141 29,530 38,807 36,340 24,559 35,272 37,195 30,544 Σ AutoSum Fill ✓Clear R Editing Days on Lot 27 Sort & Find & Filter Select Days on Lot Days on Lot S 197 Raffle Eligible 345 Bonus Eligible 127 Raffle Eligible 234 Bonus Eligible 57 0 Share 228 Bonus Eligible 300 Bonus Eligible 170 Raffle Eligible 182 Raffle Eligible 318 Bonus Eligible 343 Bonus Eligible 300 Bonus Eligible 198 Raffle Eligible 332 Bonus Eligible Ideas Special Notes Special Notes Special Notes Comme Ideas. Sensitivity Sensitivity Activate Windows Go to Settings to activate Windows. T • Insert a function in N10 that displays the Average Days on Lot of all Types that have a MSRP that is higher than 20000 and have a Color of White.
Expert Answer:
Posted Date:
Students also viewed these finance questions
-
What data would you need to calculate a scale curve or experience curve?
-
You need to calculate the estimated future availability of a cloud-based IT resource. You determine that only one possible event can occur for the cloud-based IT resource to become unavailable. As a...
-
What information do you need to calculate an accurate income statement? What are likely to be the four largest expenses?
-
EFG Manufacturing, a private company, produces light bulbs. It has 100 employees. 15 of their employees have asked for short breaks during the workday for religious purposes. They have also asked for...
-
Some businesses construct capital assets for their own use. What costs should be capitalized for these assets? Explain what policy to follow for (a) General company overhead, (b) Costs of...
-
Refer to Exercise 24.17a. Estimate the value of ke, when r = 1.48 nm.
-
Using the above data, calculate the operatingcash-flow-to-current-liabilities ratio for Evans \& Sons. The following information for Evans \& Sons relates Cash flow from operating activities......
-
Pace Corporation reports the following results for the current year: Gross profit on sales .. $120,000 Long-term capital loss 10,000 Short-term capital loss 5,000 Dividends from 40%-owned domestic...
-
Value maximization as a goal of the firm: Value maximization as a goal of the firm: focuses on quarterly changes in earnings is an accounting number takes a long-run perspective that focuses on the...
-
The figure is a schematic drawing of a countershaft that supports two V-belt pulleys. For each pulley, the belt tensions are parallel. For pulley A consider the loose belt tension is 15 percent of...
-
Typically, the expected return for a company's stock is estimated using historical returns for the stock. True or False For Stock Z, the following three monthly returns were realized: Month 1 = 5%,...
-
What are five things accountants can do to maximize their organizations chances of succeeding at digital transformation?
-
What are two important implications of digital business and digital business transformation for accountants?
-
Explain what outcomes each of IFACs seven future ft accounting roles focus on delivering (i.e. the Co-Pilot, the Navigator, the Brand Protector, the Storyteller, the Trusted Professional, the Process...
-
Identify four changed accounting roles and activities as a result of digital technology advancements.
-
What is a future ft accountant according to the International Federation of Accountants (IFAC)?
-
INTERACTIVE SESSION MANAGEMENT Can You Run the Company with Your iPhone? Can you run the company just by using your iPhone? Perhaps not entirely, but there are many business functions today that can...
-
Show that gj concave AHUCQ Abadie For nonnegative variables, we have the following corollary.
-
Consider the following income statement data from the Mono Company: a. Prepare a comparative income statement, showing increases and decreases in dollars and in percentages. b. Comment briefly on the...
-
Financial Statement Disclosures Which of the following is not a common form of financial statement disclosure? a. Notes to financial statements. b. Supplemental information. c. Parenthetical...
-
Financial Statement Analysis Limitations Which of the following is not considered a limitation of financial statement analysis? a. Firms may use different accounting methods. b. Firms may be audited...
Study smarter with the SolutionInn App