excel assignment
rfeliz12
NP_EX19_EOM4-1_RichardFeliz_1.xlsxDocumentation
| New Perspectives Excel 2019 | Module 4: End of Module Project 1 | |
| FLO Biotech | |
| ANALYZE AND CHART FINANCIAL DATA | |
| Author: | Richard Feliz |
| Note: Do not edit this sheet. If your name does not appear in cell B6, please download a new copy of the file from the SAM website. | |
Sales by Product
| FLO Biotech | ||||||
| Sales of 2021 Top 10 Products | ||||||
| 2017-2021 | ||||||
| Total revenue (thousands) | ||||||
| Product | 2017 | 2018 | 2019 | 2020 | 2021 | Trend |
| DR2907 | $131.88 | $321.39 | $311.11 | $390.13 | $585.19 | |
| CI5839 | 118.49 | 272.41 | 459.28 | 1052.67 | 2205.35 | |
| EK3206 | 102.87 | 111.20 | 262.44 | 483.41 | 829.05 | |
| QL2749 | 79.93 | 194.39 | 227.63 | 550.87 | 961.81 | |
| EN3059 | 83.04 | 146.15 | 226.39 | 226.61 | 208.48 | |
| EP2943 | 82.48 | 77.45 | 86.74 | 85.53 | 171.91 | |
| QU2748 | 66.23 | 133.39 | 218.89 | 508.70 | 1036.72 | |
| ZO2948 | 61.21 | 125.60 | 250.95 | 362.13 | 601.13 | |
| CV9461 | 53.98 | 78.49 | 179.89 | 263.00 | 379.25 | |
| LW0301 | 44.40 | 101.01 | 225.66 | 474.33 | 358.12 | |
| Other products | 198.17 | 298.44 | 262.03 | 221.16 | 487.21 | |
| Total revenue | $1,022.68 | $1,859.92 | $2,711.01 | $4,618.53 | $7,824.23 |
