Precision Products specializes in custom-manufactured metal parts. The production manager has asked you to create an Excel spreadsheet to help manage operations. The company needs a way to calculate staffing requirements (number of employees) based on different levels of production.

The five manufacturing operations are fabrication, welding, machining, assembly, and packaging. One unit of production requires 1.5 hours for fabrication, 2.25 hours for welding, 0.7 hours for machining, 3.2 hours for assembly, and 0.5 hours for packaging. This is what you will do:

1. Download the PrecisionProducts.xlsx file to your computer.  
2. Enter a formula in cell D4 to calculate the weekly production for the first row of 200 units. Copy the formula to cells D5 through D7.
   1. Example:  =C4*1.5
   2. You can also use absolute cell reference: Example:  =C4*$D$3
3. Repeat this for cells E4 through H7.
4. Use the SUM function to calculate the total production hours in cell I4 and copy to remaining cells.
   1. Example:  =SUM(D4:H4)
5. Enter a formula in cell D10 to calculate the number of workers needed for a 40-hour week.
6. Copy the formula to the remaining cells.
7. Use the SUM function to calculate the Total Requirements in column I.
8. Make the necessary change(s) to show the total required for each level of production if Precision Products operates a 45-hour production schedule.

...heart disease remains the No. 1 killer in America; nearly half of all Americans have high blood pressure, high cholesterol, or smoke—some of the leading risk factors for heart disease…

—Murphy et al., 2018

Despite the high mortality rates associated with cardiovascular disorders, improved treatment options do exist that can help address those risk factors that afflict the majority of the population today. 

As an advanced practice nurse, it is your responsibility to recommend appropriate treatment options for patients with cardiovascular disorders. To ensure the safety and effectiveness of drug therapy, advanced practice nurses must consider aspects that might influence pharmacokinetic and pharmacodynamic processes such as medical history, other drugs currently prescribed, and individual patient factors.

Reference: Murphy, S. L., Xu, J., Kochanek, K. D., & Arias, E. (2018). Mortality in the United States, 2017. Retrieved from https://www.cdc.gov/nchs/products/databriefs/db328.htm

To Prepare

• Review the Resources for this module and consider the impact of potential pharmacotherapeutics for cardiovascular disorders introduced in the media piece.
• Review the case study assigned by your Instructor for this Assignment.
• Select one the following factors: genetics, gender, ethnicity, age, or behavior factors.
• Reflect on how the factor you selected might influence the patient’s pharmacokinetic and pharmacodynamic processes.
• Consider how changes in the pharmacokinetic and pharmacodynamic processes might impact the patient’s recommended drug therapy.
• Think about how you might improve the patient’s drug therapy plan based on the pharmacokinetic and pharmacodynamic changes. Reflect on whether you would modify the current drug treatment or provide an alternative treatment option for the patient.

case study:

CASE STUDY 2: Patient HM has a history of atrial fibrillation and a transient ischemic attack (TIA). The patient has been diagnosed with type 2 diabetes, hypertension, hyperlipidemia and ischemic heart disease.

Drugs currently prescribed include the following:

• Warfarin 5 mg po daily MWF and 2.5 mg daily T, TH, Sat, Sun 

• Aspirin 81 mg po daily 

• Metformin 1000 mg po bid 

• Glyburide 10 mg po bid 

• Atenolol 100 mg po daily 

• Motrin 200 mg 1–3 tablets every 6 hours as needed for pain

Write a 2- to 3-page paper that addresses the following:

• Explain how the factor you selected might influence the pharmacokinetic and pharmacodynamic processes in the patient from the case study you were assigned.
• Describe how changes in the processes might impact the patient’s recommended drug therapy. Be specific and provide examples.
• Explain how you might improve the patient’s drug therapy plan and explain why you would make these recommended improvements.

Rubrics:

Explain how the factor you selected might influence the pharmacokinetic and pharmacodynamic processes in the patient from the case study you were assigned.--

Describe how changes in the processes might impact the patient's recommended drug therapy. Be specific and provide examples.--

Explain how you might improve the patient's drug therapy plan, and explain why you would make these recommended improvements.

Written Expression and Formatting - Paragraph Development and Organization:
Paragraphs make clear points that support well developed ideas, flow logically, and demonstrate continuity of ideas. Sentences are carefully focused--neither long and rambling nor short and lacking substance.

Written Expression and Formatting - English writing standards:
Correct grammar, mechanics, and proper punctuation

Written Expression and Formatting - The paper follows correct APA format for title page, headings, font, spacing, margins, indentations, page numbers, running head, parenthetical/in-text citations, and reference list.--

References:

Rosenthal, L. D., & Burchum, J. R. (2018). Lehne’s pharmacotherapeutics for advanced practice providers. St. Louis, MO: Elsevier.

• Chapter 34, “Review of Hemodynamics” (pp. 335–340)
• Chapter 35, “Diuretics” (pp. 341–349)
• Chapter 36, “Drugs Acting on the Renin-Angiotensin-Aldosterone System” (pp. 351–362)
• Chapter 37, “Calcium Channel Blockers” (pp. 363–369)
• Chapter 38, “Vasodilators” (pp. 371–373)
• Chapter 39, “Drugs for Hypertension” (pp. 375–388)
• Chapter 40, “Drugs for Heart Failure” (pp. 389–402)
• Chapter 41, “Antidysrhythmic Drugs” (pp. 403–418)
• Chapter 42, “Prophylaxis of Atherosclerotic Cardiovascular Disease: Drugs That Help Normalize Cholesterol and Triglyceride Levels” (pp. 419–439)
• Chapter 43, “Drugs for Angina Pectoris” (pp. 441–450)
• Chapter 44, “Anticoagulant and Antiplatelet Drugs” (pp. 451–472)

...heart disease remains the No. 1 killer in America; nearly half of all Americans have high blood pressure, high cholesterol, or smoke—some of the leading risk factors for heart disease…

—Murphy et al., 2018

Despite the high mortality rates associated with cardiovascular disorders, improved treatment options do exist that can help address those risk factors that afflict the majority of the population today. 

As an advanced practice nurse, it is your responsibility to recommend appropriate treatment options for patients with cardiovascular disorders. To ensure the safety and effectiveness of drug therapy, advanced practice nurses must consider aspects that might influence pharmacokinetic and pharmacodynamic processes such as medical history, other drugs currently prescribed, and individual patient factors.

Reference: Murphy, S. L., Xu, J., Kochanek, K. D., & Arias, E. (2018). Mortality in the United States, 2017. Retrieved from https://www.cdc.gov/nchs/products/databriefs/db328.htm

To Prepare

• Review the Resources for this module and consider the impact of potential pharmacotherapeutics for cardiovascular disorders introduced in the media piece.
• Review the case study assigned by your Instructor for this Assignment.
• Select one the following factors: genetics, gender, ethnicity, age, or behavior factors.
• Reflect on how the factor you selected might influence the patient’s pharmacokinetic and pharmacodynamic processes.
• Consider how changes in the pharmacokinetic and pharmacodynamic processes might impact the patient’s recommended drug therapy.
• Think about how you might improve the patient’s drug therapy plan based on the pharmacokinetic and pharmacodynamic changes. Reflect on whether you would modify the current drug treatment or provide an alternative treatment option for the patient.

case study:

CASE STUDY 2: Patient HM has a history of atrial fibrillation and a transient ischemic attack (TIA). The patient has been diagnosed with type 2 diabetes, hypertension, hyperlipidemia and ischemic heart disease.

Drugs currently prescribed include the following:

• Warfarin 5 mg po daily MWF and 2.5 mg daily T, TH, Sat, Sun 

• Aspirin 81 mg po daily 

• Metformin 1000 mg po bid 

• Glyburide 10 mg po bid 

• Atenolol 100 mg po daily 

• Motrin 200 mg 1–3 tablets every 6 hours as needed for pain

Write a 2- to 3-page paper that addresses the following:

• Explain how the factor you selected might influence the pharmacokinetic and pharmacodynamic processes in the patient from the case study you were assigned.
• Describe how changes in the processes might impact the patient’s recommended drug therapy. Be specific and provide examples.
• Explain how you might improve the patient’s drug therapy plan and explain why you would make these recommended improvements.

Rubrics:

Explain how the factor you selected might influence the pharmacokinetic and pharmacodynamic processes in the patient from the case study you were assigned.--

Describe how changes in the processes might impact the patient's recommended drug therapy. Be specific and provide examples.--

Explain how you might improve the patient's drug therapy plan, and explain why you would make these recommended improvements.

Written Expression and Formatting - Paragraph Development and Organization:
Paragraphs make clear points that support well developed ideas, flow logically, and demonstrate continuity of ideas. Sentences are carefully focused--neither long and rambling nor short and lacking substance.

Written Expression and Formatting - English writing standards:
Correct grammar, mechanics, and proper punctuation

Written Expression and Formatting - The paper follows correct APA format for title page, headings, font, spacing, margins, indentations, page numbers, running head, parenthetical/in-text citations, and reference list.--

References:

Rosenthal, L. D., & Burchum, J. R. (2018). Lehne’s pharmacotherapeutics for advanced practice providers. St. Louis, MO: Elsevier.

• Chapter 34, “Review of Hemodynamics” (pp. 335–340)
• Chapter 35, “Diuretics” (pp. 341–349)
• Chapter 36, “Drugs Acting on the Renin-Angiotensin-Aldosterone System” (pp. 351–362)
• Chapter 37, “Calcium Channel Blockers” (pp. 363–369)
• Chapter 38, “Vasodilators” (pp. 371–373)
• Chapter 39, “Drugs for Hypertension” (pp. 375–388)
• Chapter 40, “Drugs for Heart Failure” (pp. 389–402)
• Chapter 41, “Antidysrhythmic Drugs” (pp. 403–418)
• Chapter 42, “Prophylaxis of Atherosclerotic Cardiovascular Disease: Drugs That Help Normalize Cholesterol and Triglyceride Levels” (pp. 419–439)
• Chapter 43, “Drugs for Angina Pectoris” (pp. 441–450)
• Chapter 44, “Anticoagulant and Antiplatelet Drugs” (pp. 451–472)