Purchase Solution

Spreadsheet Analysis of the EOQ at the Neighborhood Pharmacy

Not what you're looking for?

Ask Custom Question

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.

View More Free Quizzes
Related BrainMass Solutions

  • Operations Management -- Inventory

    We modify the spreadsheet slightly to add the purchase cost to the total cost. Using "month" as our time unit of analysis, we plug the following numbers into the spreadsheet: Dough R Demand rate avg.

  • Inventory model for a Small Bakery

    To compute the ABC model using spreadsheet software, please access this link from Winthrop University: http://cba.winthrop.edu/riddlee/MGMT326_S09/ABC_Analysis_Excel_new2.doc This file gives you the easy steps in ABC analysis using only Microsoft Excel

  • Financial and turnover analysis

    (a) Prepare an income statement in excel (b) Prepare a balance sheet in excel (c) Prepare a statement of cash flows in excel 2. Ratio analysis: provide the following ratios for Walgreen's for 2009. In excel spreadsheet 1.

  • MCQs on forecasting, inventory

    the attitude of top management toward the use of the EOQ model b. an assessment of the impact of obsolescence upon the EOQ c. analysis of how much the EOQ will change when other variable change d.

  • Hypothetical Shopko Stores capital budgeting decision

    The new store footprint is 77,500 square feet at a cost of $255 per square foot all in. Management is excited by the prospects of increasing profit margin with the reduced foot print, yet still offering pharmacy and optical services. 3.

  • minimum Annual Total Cost

    Economic Order Quantity (a) Creating the spreadsheet: A particular raw material is available to a company at three different prices, depending on the size of the order. If you order ... You will pay ...

  • suppy chain

    12427 Supply Chain Cyclic Schedule In European Metals, we examined a "cyclic schedule," in which we produce each item in turn, until all items have been produced; then we start over at the beginning. Refer to the EuroMet spreadsheet. a.

  • Decision making-Proposal for a 24 hour pharmacy

    The pharmacy will have an annual growth rate of at least 16% 9.2. A loan of $200,000 will be acquired from the bank to develop the business 9.3. The loan will have a 10 year term at a 9% interest rate 10.

  • Regression analysis and t test

    Data for a sample of 25 apartments in a particular neighborhood are provided in the attached excel spreadsheet. At the .05 level of significance determine if the correlation between rental cost and apartment size is significant. A.

View More Related Solutions