Modeling Tasks using the CT Spend Tab

$1$ What is the aggregate sum repaid $($Cost$)$ for $2021$

$2$ What is the typical expense per solution guarantee in $2021?$

$3$ What is the LABETALOL used to treat

$4$ Fill in section R on CT Enjoy with the Expense per Unit

$5$ What is the typical expense per unit in $2021?$

$6$ What is the typical expense per unit in $2020?$

$7$ What is the percent development in the aggregate sum repaid somewhere in the range of $2020$ and $2021?$

$8.$ Do you imagine that development in spending will be something very similar somewhere in the range of $2020$ and $2021$ as in $2021$ and $2022?$ If not, what do you suppose the development rate will be$<img\; src="https://dsd5zvtm8ll6.cloudfront.net/questions/2024/01/65a542bbcdb9d\_1705329336542.jpg"\; style="display:\; block;\; vertical-align:\; top;\; margin:\; 5px\; auto;\; text-align:\; center;"\; width="1238"\; height="825"\; alt="X\; AutoSave\; On\; F\; File\; Home\; Insert\; Draw\; A1\; Paste\; Clipboard\; 1\; Type\; 2\; FFSU\; 3\; FFSU\; 4\; FFSU\; 5\; FFSU\; 6\; FFSU\; 7\; FFSU\; 8">$

X AutoSave On F File Home Insert Draw A1 Paste Clipboard 1 Type 2 FFSU 3 FFSU 4 FFSU 5 FFSU 6 FFSU 7 FFSU 8 FFSU 9 FFSU 10 FFSU 11 FFSU 12 FFSU 13 FFSU 14 FFSU 15 FFSU 16 FFSU 17 FFSU 18 FFSU 19 FFSU 20 FFSU 21 FFSU 22 FFSU 23 FFSU 24 FFSU 25 FFSU 26 FFSU 27 FFSU 28 FFSU 29 FFSU 30 FFSU 31 FFSU 32 FFSU 33 FFSU 34 FFSU 35 FFSU 36 FFSU 37 FFSU 38 FFSU 39 FFSU 40 FFSU 41 FFSU 42 FFSU 43 FFSU 44 FFSU 45 FFSU 46 FFSU 47 FFSU 48 FFSU 49 FFSU 50 FFSU 51 FFSU 52 FFSU 53 FFSU 54 FFSU 55 FFSU 56 FFSU 57 FFSU 58 FFSU 59 FFSU 60 FFSU 61 FFSU 62 FESU Ready A B state CT CT CT CT CT CT CT CT CT CT CT CT CT CT CT CT CI CT CT CT CT CT CT CT CT CT CT CT CT CT CT CT CT CT CT CT CT CT CT CT CT CT CT CT CT CT CT CT CT CT CT CT CT CT CT CT CT Calibri B I U 00116200116 00116200116 00116200116 00116200116 00338065604 00338065604 00338065604 Y Y 7 00338065604 00264959420 00264959820 00264959820 00264959820 00264959820 00264180031 00264180032 00264780000 00264780009 00264780010 00264780020 00338055311 00338055318 00264180031 00264180032 00264780000 00264780009 00264780010 00264780020 00338055311 00338055318 00264180031 00264180032 00264780000 00264780009 00264780010 00264780020 00338055311 00338055318 X fx Type C D ndc labeler_code Y Y T Y 7 Y Y 7 00264180031 00264180032 00264780000 00264780009 00264780010 00264780020 00338055311 00338055318 00338004804 00338004804 00338004802 00338004803 00338004804 00338004803 00338004804 00264762200 00264762200 00264762200 00338064406 00338064406 00338064406 00338050206 00338050206 00338050206 Y V 00264 00264 00264 00264 00264 00264 00338 00338 00264 00264 00264 00264 00264 00264 00338 00338 00338 00338 00338 00338 00338 00338 00338 00264 00264 00264 00338 00338 00338 00338 00338 00338 Unit 1 CT Spend Y Page Layout Y 11 Accessibility: Investigate Font 00116 00116 00116 00116 00338 00338 00338 00338 00264 00264 00264 00264 00264 00264 00264 00264 00264 00264 00264 00338 00338 00264 00264 00264 00264 00264 00264 00338 00338 V Y 7 Y T Y T 7 T 7 V 7800 7800 7800 E product_code 2001 2001 2001 2001 0656 0656 0656 0656 9594 9598 9598 9598 9598 1800 1800 7800 0553 0553 1800 1800 7800 7800 7800 7800 0553 0553 1800 1800 7800 7800 7800 7800 0553 0553 1800 1800 7800 7800 7800 7800 0553 0553 0048 0048 0048 0048 0048 0048 0048 Drug Data Unit.xlsx Saved 7622 7622 7622 0644 0644 0644 0502 0502 0502 Formulas Data Review V H F G package_size year! quarte 16 2021 4 16 3 16 2 16 1 4 4 3 2 1 1 4 Humalog | 4 4 4 20 20 20 20 20 31 32 0 9 10 20 11 18 31 32 0 9 10 20 11 18 31 32 0 9 10 20 11 18 31 32 0 9 10 20 11 18 4 4 2 3 4 = = = = 3 4 0 0 0 6 6 6666 + 2021 2021 2021 2021 2021 2021 2021 2021 2021 2021 2021 2021 2021 2021 2021 2021 2021 2021 2021 2021 2021 2021 2021 2021 2021 2021 2021 2021 2021 2021 2021 2021 2021 2021 2021 2021 2021 2021 2021 2021 2021 2021 2021 2021 2021 2021 2021 2021 2021 2021 2021 2021 2021 2021 2021 2021 2021 2021 2021 2021 3 2 1 4 4 4 4 4 4 4 4 3 3 3 3 3 3 3222ww 222 2 1 1 1 1 1 1 1 14 3 2 2 2 1 1 3 2 1 4 3 1 4 3 2 View Automate Alignment product_name .12% CHLOR .12% CHLOR .12% CHLOR .12% CHLOR 0.25 ACETI 0.25 ACETI 0.25 ACETI 0.25 ACETI 0.4% LIDOC 0.8% LIDOC 0.8% LIDOC 0.8% LIDOC 0.8% LIDOC 0.9% SODIU 0.9% SODIU 0.9% SODIU 0.9% SODIU 0.9% SODIU 0.9% SODIU 0.9% SODIU ab Wrap Text 0.9% SODIU 0.9% SODIU 0.9% SODIU 0.9% SODIU 0.9% SODIU 0.9% SODIU 0.9% SODIU 0.9% SODIU 0.9% SODIU 0.9% SODIU 0.9% SODIU 0.9% SODIU 0.9% SODIU 0.9% SODIU 0.9% SODIU 0.9% SODIU 0.9% SODIU 0.9% SODIU 0.9% SODIU 0.9% SODIU 0.9% SODIU 0.9% SODIU 0.9% SODIU 0.9% SODIU 0.9% SODIU 0.9% SODIU 0.9% SODIU 0.9% SODIU 0.9% SODIU 0.9% SODIU 0.9% SODIU 0.9% SODIU 10% DEXTRO 10% DEXTRO 10% DEXTRO 10% TRAVAS 10% TRAVAS 10% TRAVAS 15% CLINIS 15% CLINIS 15% CLINIS Search Merge & Center Class Sodium Sodium Sodium Sodium Sodium Sodium Sodium Sodium Sodium Sodium Sodium Sodium Sodium Sodium Sodium Sodium Sodium Sodium Sodium Sodium Sodium Sodium Sodium Sodium Sodium Sodium Sodium Sodium Sodium Sodium Sodium Help Other irrigating solutions Other irrigating solutions Other irrigating solutions Other antidepressants Other antidepressants Other antidepressants Other antidepressants Other antidepressants Other antidepressants N General $ V % 9 Labeler Antiinfectives and antiseptics foXttrium Laboratories, Inc. Antiinfectives and antiseptics fXttrium Laboratories, Inc. Antiinfectives and antiseptics fXttrium Laboratories, Inc. Antiinfectives and antiseptics fXttrium Laboratories, Inc. Organic acids Baxter Healthcare Corporation Organic acids Organic acids Organic acids Antiarrhythmics, class lb Antiarrhythmics, class lb Antiarrhythmics, class lb Antiarrhythmics, class lb Antiarrhythmics, class lb Sodium Sodium Sodium Sodium Sodium Sodium Sodium Sodium Number K Baxter Healthcare Corporation Baxter Healthcare Corporation B. Braun Medical Inc. B. Braun Medical Inc. B. Braun Medical Inc. B. Braun Medical Inc. B. Braun Medical Inc. B. Braun Medical Inc. Baxter Healthcare Corporation Baxter Healthcare Corporation B. Braun Medical Inc. B. Braun Medical Inc. B. Braun Medical Inc. B. Braun Medical Inc. B. Braun Medical Inc. B. Braun Medical Inc. Baxter Healthcare Corporation Baxter Healthcare Corporation B. Braun Medical Inc. B. Braun Medical Inc. B. Braun Medical Inc. B. Braun Medical Inc. B. Braun Medical Inc. B. Braun Medical Inc. .00 .0 00 .0 Baxter Healthcare Corporation Baxter Healthcare Corporation Baxter Healthcare Corporation Brand B. Braun Medical Inc. Brand B. Braun Medical Inc. Brand B. Braun Medical Inc. Brand Brand B. Braun Medical Inc. B. Braun Medical Inc. B. Braun Medical Inc. Brand B. Braun Medical Inc. B. Braun Medical Inc. B. Braun Medical Inc. B. Braun Medical Inc. B. Braun Medical Inc. Baxter Healthcare Corporation Baxter Healthcare Corporation Baxter Healthcare Corporation Baxter Healthcare Corporation Baxter Healthcare Corporation B. Braun Medical Inc. Brand or Generic Brand Brand Brand Brand Brand Brand Brand Generic Generic Generic Generic Generic Generic Generic Generic Generic Generic Generic Generic Generic. Generic Generic Generic Generic Generic Generic Generic Generic Generic Generic Generic Generic Generic Generic Generic Generic Generic Baxter Healthcare Corporation Generic Baxter Healthcare Corporation Generic Baxter Healthcare Corporation Generic Baxter Healthcare Corporation Generic Generic Generic Generic Generic Generic Brand Brand Brand Conditional Format as Cell Formatting V Table Styles Brand Brand B. Braun Medical Inc. B. Braun Medical Inc. Baxter Healthcare Corporation Baxter Healthcare Corporation Baxter Healthcare Corporation Baxter Healthcare Corporation Baxter Healthcare Corporation Baxter Healthcare Corporation Brand Brand Brand Brand Styles M units_reimbursed 2,211,112 2,658,840 2,409,479 2,661,566 16,000 25,000 29,000 38,000 38 20 21 15 15 23,000 21,752 50,000 340,735 89,751 216,752 8,650 559,050 21,350 28,316 110,245 226,700 134,455 325,759 34,150 1,002,450 10,300 17,855 70,280 175,150 122,502 202,256 12,700 460,117 12,451 42,216 63,688 82,725 88,251 179,002 10,200 494,200 421,006 420,000 107,500 180,000 314,000 195,000 557,000 102,000 155,000 173,000 155,362 49,645 92,059 856,651 847,996 685.704 N number_of_prescriptions Insert Delete Format Cells 5,388 $ 16 $ 18 $ 20 $ 26 $ 15 $ 14 $ 15 $ 12 $ 12 $ 46 $ O total amount_reimbursed 4,683 $ 5,631 $ 4,954 $ 52 $ 48 $ 57 $ 103 $ 305 $ 18 $ 544 S 59 $ 82 $ 104 $ 93 $ 136 $ 347 $ 82 $ 849 $ 40 $ 57 $ 59 $ 81 $ 120 $ 303 $ 29 $ 460 64 $ 91 $ 53 $ 50 $ 127 $ 286 $ 41 $ 474 $ 24 $ 22 $ 22 $ 11 $ 18 $ 11 32 $ 14 $ 23 $ 24 $ 108 $ V 48 $ 20 $ 352 $ 381 $ 244 S WE > Count: 1165419 V AT O Z Sort & Find & Filter Select Editing 57,295 $ 68,004 $ 60,437 $ 66,507 $ 276 $ 356 $ 398 $ 510 2 $ 8 $ 4 $ 3 $ 4 $ 222 $ 103. $ 122 1,214 $ 336 $ 1,338 $ 1,040 $ 31,314 $ $ 395 578 $ 345 $ 982 $ 766 $ 2,494 $ 3,844 $ 55,483 $ 250 $ 387 $ 238 $ 741 $ 528 $ 1,395 $ 1,374 $ 25,534 $ 277 $ 954 $ 208 $ 413 $ 299 $ 1,143 $ 1,077 $ 25,617 $ 1,757 $ 1,730 $ 1,647 $ 1,359 $ 1,300 $ 1,363 $ 2,179 $ Paul Licon 893 $ 1,376 $ 1,518 $ 6,991 $ $ 1,961 4,124 $ 77,629 $ 70,834 $ 54.931 M SUCH 61 Comments Add-ins P medicaid_amount_reimbursed Add-ins 57,273 $ 67,974 $ 60,389 $ 66,445 $ 276 $ 356 $ 398 $ 510 $ 2 $ 8 $ 4 $ 3 $ 4 $ 206 $ 81 $ 120 $ 1,208 $ 296 $ 1,239 S 1,040 $ 31,314 376 $ 569 $ 296 $ 970 $ 686 $ 2,375 $ 3,844 $ 55,453 $ 239 $ 383 $ 172 $ 721 $ 478 $ 1,299 $ 1,374 $ 25,534 $ 265 $ 950 $ 155 $ 405 $ 229 $ 1,065 $ 1,077 $ 25,617 $ 1,683 $ 1,656 $ 1,647 $ 1,302 $ 1,210 $ 1,322 $ 2,031 $ 893 $ 1,376 $ 1,518 $ 6,991 $ 1,961 $ 4,124 $ 71,950 $ 69,241 $ 53.653 Analyze Data Share non_medicaid_amount_reiml + 59%