Prepare a budget for clinical trials based on a specific protocol,…

  • Prepare a budget for clinical trials based on a specific protocol, for example, drug will be used 1mg per day per patient.  The protocol may be changed in the future so make sure your worksheet is flexible enough to be easily modified.
  • Begin your budget in a new workbook named TrialsBudget_Your name.xls.
  • Prepare three identically formatted sheets, one for each year.  Name your sheets Year1, Year2, and Year3.
  • Each sheet needs to contain the expenses for each of the items listed in the table below.  Expenses should be calculated for each of the twelve months and the yearly total.  All expense values should be rounded to the nearest dollar.
Expense ItemCost
Manufacturing and Distribution$0.25 per milligram
Participant Fees$25 per month per patient
Physician Fees$1200 per patient per year
Blood Testing$35 per participant per test (quarterly:  January, April, July, October)
Urine Analysis$5 per participant (bimonthly:  January, March, May, etc.)
Administration and Overhead$10,000 per month

 

  • To create this budget, you also make the following assumptions:
    • Assume that there will initially be 1000 participants with an attrition rate of 5% per year (thus, year two’s budget is based on 950 participants).  This value should be explicitly listed on the top portion of each year’s budget.
    • Assume that each year has 365 days, and each month contains the corresponding number of days (e.g., January 31, February 28, etc).
    • Assume that physician fees and blood and urine test fees increase approximately 5% per year.
    • Assume all other fees will remain the same.
    • For calculation purposes, assume that the average daily dosages per person per day match those of your selected protocol.
  • Generate monthly and yearly totals for each expense item.  Include a grand total for all expenses in each year.
  • After the budget for each year is complete, add a fourth worksheet title Summary.  This worksheet needs to contain the yearly total columns from each of the three years.  Create 3-year totals by expense item. Include a grand total for the three years of expenses.  Reference the values on the yearly worksheets, so any updates to the expenses for a given year are immediately reflected on the Summary worksheet.

Share This Post

Email
WhatsApp
Facebook
Twitter
LinkedIn
Pinterest
Reddit

Order a Similar Paper and get 15% Discount on your First Order

Related Questions

1. There are eight characteristics of language. Describe and…

1. There are eight characteristics of language. Describe and explain three characteristics (of your choosing) and provide an example to support the characteristic. 2. There are six characteristics of supporting the innateness hypothesis. Describe and explain three characteristics (of your choosing) and provide an example to support the characteristic. 3.

In the late 19th century, which of the following was a consequence…

In the late 19th century, which of the following was a consequence of the shift to the sharecropping system in the South?   a rise in post-Civil War crop production   a diversification of agricultural production of crops   an increase in debt peonage, tying freedmen to the land   a significant redistribution

3. Gains from trade Suppose there exist two imaginary countries,…

3. Gains from trade Suppose there exist two imaginary countries, Glacier and Congaree. Their labor forces are each capable of supplying four million hours per day that can be used to produce pistachios, chinos, or some combination of the two. The following table shows the amount of pistachios or chinos

Which of the following is TRUE regarding cultural variations in…

Which of the following is TRUE regarding cultural variations in attachment style?  A. Germany has significantly more securely attached infants than the US B. All of these answers are truth.  C. Some countries have more insecure- avoidant infants than securely attachments infants  D. Japan has a higher percentage of infants

An argument-based paper. Read the short story “The Necklace,” by…

An argument-based paper. Read the short story “The Necklace,” by Guy de Maupassant. This will be the subject matter for “Essay Three.” You will be trying to convince who ever reads this of the validity of your viewpoint, and make them “see things your way.” You will, also,  need to

General Mills and Kellogg’s, major rivals in the breakfast cereal…

General Mills and Kellogg’s, major rivals in the breakfast cereal market, decide simultaneously on their advertising strategies. Each has five options, A through E. The following table shows their net profits (in millions of dollars) for various advertising strategy combinations. In each cell, the first entry is the profit for

The law of demand states that there is a ________ relationship…

The law of demand states that there is a ________ relationship between price and quantity demanded.   negative positive increasing direct   Which of the following are the best examples of substitutes?   pasta and tomato sauce iPods and earphones golf balls and golf clubs pens and pencils   An

Does faith-based natural law justify acts of violence?   The…

Does faith-based natural law justify acts of violence?   The textbook must be used, cited and referenced in each post. In addition to citing the textbook and other relevant course instructional material, you must find, read, and cite at least two additional scholarly articles to support your essay. Understanding Terrorism:

Choose two different visual media items that express opinions about…

Choose two different visual media items that express opinions about trade agreements, barriers to trade or free trade. The items must be from this past year.  The resource list provides some examples of visual media and guidance on where to locate them on the internet. Be sure to include the media