Spreadsheet Analysis of the EOQ at the Neighborhood Pharmacy
Not what you're looking for?
Spreadsheet Analysis of the EOQ at the Neighborhood Pharmacy, Inc.
During the relevant planning period, the per unit purchase cost for an important prescribed (ethical) drug is P=$4, the total estimated use for the planning period is X=5,000, the cost of placing an order is $50, and the per unit carrying cost is C=$0.50, calculated as the current interest rate of 12.5 percent multiplied by the per unit purchase cost of the item.
A. Set up a table or spreadsheet for NPI's order quantity (Q), inventory-related total cost (TC), purchase price (P), use requirement (X), order cost, and carrying cost (C). Establish a range for Q from 0 to 2,000 in increments of 100 (i.e. 0, 100, 200,......2,000)
B. Based on the NPI table or spreadsheet, determine the order quantity that will minimize the company's inventory-related total costs during the planning period.
C. Placing inventory-related total costs, TC, on the vertical or Y-axix and order quantity, Q on the horizonal X-axis, plot the relation between inventory-related total costs and the order quantity.
Purchase this Solution
Solution Summary
solution contains Spreadsheet Analysis of the EOQ at the Neighborhood Pharmacy, Inc.
Purchase this Solution
Free BrainMass Quizzes
Business Ethics Awareness Strategy
This quiz is designed to assess your current ability for determining the characteristics of ethical behavior. It is essential that leaders, managers, and employees are able to distinguish between positive and negative ethical behavior. The quicker you assess a person's ethical tendency, the awareness empowers you to develop a strategy on how to interact with them.
Understanding Management
This quiz will help you understand the dimensions of employee diversity as well as how to manage a culturally diverse workforce.
Operations Management
This quiz tests a student's knowledge about Operations Management
Transformational Leadership
This quiz covers the topic of transformational leadership. Specifically, this quiz covers the theories proposed by James MacGregor Burns and Bernard Bass. Students familiar with transformational leadership should easily be able to answer the questions detailed below.
Balance Sheet
The Fundamental Classified Balance Sheet. What to know to make it easy.