Question
the financial director Peter, is deciding how to best utilize the budget for upcoming project to purchase the antigen tests with the possibility of self-testing.
the financial director Peter, is deciding how to best utilize the budget for upcoming project to purchase the antigen tests with the possibility of self-testing. The bursar has provided him with CZK 5 000 000 to spend. After some research, Peter chose following antigen tests and put together following table with estimated price per test, sensitivity, and cost per one antigen test (including shipping and VAT). using Solver choose antigen test based on the following constraints: achive the highest sensitity, order 5000 test and keep you budget in the range.
No. | Type of antigen test | Which one? | How many? | Unit price (per one test) | Sensitivity of the test (no. out of 10) |
1 | HYGISUN - Rapid COVID-19 Antigen test | 1,410 K | 9 | ||
2 | Realy Tech SARS-CoV-2 Antigen Rapid Test | 1,330 K | 9 | ||
3 | Joysbio - SARS-CoV-2 Antigen Rapid Test | 790 K | 6 | ||
4 | Flowflex SARS-CoV-2 Antigen test | 1,080 K | 8 | ||
5 | LEPU Medical - SARS-CoV-2 Antigen test | 760 K | 6 | ||
6 | Novel Med- SARS-CoV-2 Antigen test | 880 K | 6 | ||
7 | V-check SARS CoV-2 Antigen test | 950 K | 7 | ||
8 | Diaquick SARS CoV-2 Antigen test | 1,280 K | 9 | ||
9 | VivaDiag SARS CoV-2 Antigen test | 860 K | 6 | ||
10 | FlowFlegs SARS CoV-2 Antigen test | 1,240 K | 9 |
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