Spreadsheet Analysis of the EOQ at the Neighborhood Pharmacy, Inc.

A. Set up a table or spreadsheet for NPI's order quantity (Q), inventory-related total cost (TC), the 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). The 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) appears as follows: Quantity (Q) Total Cost (TC) Price (P) Use Requirement (X) Order Cost θ Carrying Cost (C) 0 4 5,000 $50 $0.50 100 $22,525 4 5,000 50 0.50 200 21,300 4 5,000 50 0.50 300 20,908 4 5,000 50 0.50 400 20,725 4 ...