Question
Tomlinson's Lumens, Inc. (TLI) is a large manufacturer of lighting fixtures and parts. TLA's Accounting department receives the file tomlinsonprices&units that summarizes the price and
Tomlinson's Lumens, Inc. (TLI) is a large manufacturer of lighting fixtures and parts. TLA's Accounting department receives the file tomlinsonprices&units that summarizes the price and units sold, respectively, for each product it produces on a quarterly basis. The data has been collected in the Microsoft Excel file below. Download the spreadsheet and perform the required analysis to answer the question below. Download spreadsheet tomlinsonprices&units-2a0adb.xlsx Use this information calculate the company's most recent quarterly total sales of all product codes beginning with the letter Y. Round your answer to the nearest dollar. $ fill in the blank 2
| Product Code | Units Sold |
| L590AX8 | 19880 |
| Q760CE5 | 16536 |
| Z155LO4 | 15421 |
| Y217OS5 | 19711 |
| Z143KH3 | 13846 |
| P437XC1 | 13959 |
| N609CX2 | 13371 |
| D819SZ1 | 4934 |
| W496VK9 | 6727 |
| Q204QC8 | 14156 |
| F739GE9 | 17711 |
| R300KE3 | 11046 |
| F354YA10 | 12909 |
| N342WB5 | 2114 |
| U656DX7 | 3893 |
| F986SK7 | 14350 |
| Z333GO3 | 19264 |
| J244UB6 | 19782 |
| P105EM5 | 11033 |
| V243JE5 | 6610 |
| X721GE6 | 11487 |
| F386TD10 | 5452 |
| K587XO8 | 17420 |
| V535NH9 | 14419 |
| I176OD10 | 5167 |
| O641CJ5 | 20259 |
| Q479KL7 | 1664 |
| W934JP5 | 18638 |
| Y977KF4 | 8265 |
| L784HB3 | 11604 |
| Q118NF9 | 1204 |
| T259QF7 | 12646 |
| U778ZW5 | 14991 |
| R615LH10 | 18246 |
| Y242EC2 | 11274 |
| M685SH7 | 10362 |
| W557UH4 | 9559 |
| F765JP4 | 16888 |
| M354CG4 | 3936 |
| N769UD7 | 17202 |
| P966JC7 | 10836 |
| K908ZV9 | 12502 |
| Q874SP5 | 15850 |
| T610PS5 | 19440 |
| Q528KM10 | 2708 |
| J542YO3 | 6814 |
| B212ZT3 | 7239 |
| U721IS1 | 2132 |
| H634GL9 | 17556 |
| I434EM7 | 1479 |
| H552IU5 | 2312 |
| I458WO1 | 6646 |
| W313DM10 | 4424 |
| G815LU8 | 18673 |
| Z122PS9 | 3984 |
| C594MY2 | 17464 |
| B751AJ6 | 14090 |
| W379YL10 | 13207 |
| Z416DO8 | 3012 |
| H123FR6 | 19298 |
| C591XV5 | 9435 |
| C523HL5 | 8761 |
| K920XN5 | 1398 |
| X809SD9 | 20182 |
| I458WM8 | 16737 |
| Y421YQ7 | 3502 |
| Y157LU2 | 14765 |
| W415OX10 | 12518 |
| W282DT4 | 14084 |
| F512JV6 | 14125 |
| E632XA8 | 13046 |
| K434PV4 | 8653 |
| Z333RO8 | 12958 |
| W481ID6 | 884 |
| V574GK7 | 12022 |
| A822FH5 | 1993 |
| J580OC7 | 7640 |
| B175TW8 | 10960 |
| D868AO5 | 2612 |
| G871SG4 | 3340 |
| A172PW6 | 15221 |
| M656JA6 | 10159 |
| C383CD2 | 12797 |
| D227TM1 | 3656 |
| D623PE5 | 19426 |
| I743OO3 | 8916 |
| P723XZ10 | 18842 |
| K642ZK8 | 7383 |
| W321RD6 | 15171 |
| J434YU8 | 17772 |
| M961RN5 | 18021 |
| A289DG10 | 9893 |
| Y621SS2 | 13053 |
| K706RF9 | 7491 |
| X532NQ5 | 18124 |
| K529LD4 | 10176 |
| T567NT7 | 18380 |
| T526AF6 | 15933 |
| B160MW8 | 11218 |
| U269VV2 | 6538 |
| D259BK4 | 14708 |
| M693TQ4 | 17335 |
| F797NO8 | 14479 |
| O652AL6 | 8205 |
| K574KA2 | 12671 |
| Z940MR1 | 4745 |
| K645SX6 | 6183 |
| A751VY2 | 19375 |
| D196NY1 | 15454 |
| X504YP10 | 15810 |
| W891YR6 | 14798 |
| Y683ZX5 | 18340 |
| S418RY6 | 16477 |
| D218OF2 | 608 |
| P553XH10 | 6798 |
| D523SR7 | 13762 |
| P235AU3 | 16877 |
| X276QB3 | 13354 |
| E698BA7 | 9188 |
| S731XB8 | 15205 |
| N115RJ5 | 6670 |
| R311TW5 | 19861 |
| M522JB4 | 7845 |
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started
Auditing And Assurance Services An Integrated Approach
Authors: Alvin A. Arens, Randal J. Elder, Mark S. Beasley
11th Edition
0131867121, 978-0131867123
