Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

CLARINDA COMMUNITY HOSPITAL is a 230-bed, not-for-profit, acute care hospital located in Clarinda, Iowa. The city is a typical Midwestern county seat and farming community

CLARINDA COMMUNITY HOSPITAL is a 230-bed, not-for-profit, acute care hospital located in Clarinda, Iowa. The city is a typical Midwestern county seat and farming community best known as the birthplace of Glenn Miller, the famous big band leader of the late 1930s and early 1940s. Clarinda carries more than 10,000 different items of inventory that vary widely in price, order lead times, and stockout costs. (Stockout costs are the total costs that result from running out of stock of a particular inven- tory item, including higher costs of service caused by scheduling delays or emergency replenishments as well as the costs associated with negative patient outcomes and potential lawsuits.) It uses the activity-based costing (ABC) method of inventory classification, also called "selective inventory control," along with a variety of inventory-control methods to manage its different inventory items. The ABC classification system works in this way: Clarinda maintains data on the average annual usage and unit cost of each inventory item, which typically is called a stock-keeping unit (SKU). Then, the dollar usage (Average annual usage x Unit cost) is calculated for each SKU. Next, these amounts are converted into percentages of total dollar usage, and the SKUs are arrayed from highest to lowest percentage. The SKUs are then divided into three groups (or classes)-labeled A, B, and C-using the general guidelines provided in exhibit 28.1. To better use the limited resources available for inventory management, Clarinda's managers focus most of their attention on Class A items. The usage rates, stock positions, and delivery times for SKUs in this class are reviewed on a biweekly basis, with control and ordering system data adjusted as necessary. Class B items are reviewed every quarter, while Class C items are reviewed semiannually. Even though this process has served Clarinda well, Marco Munoz, its new chief financial officer, thinks the hospital is carrying excess inventories. He notes that Clarinda has never come close to having a stockout, even when it has been running near 100 percent occupancy. He believes that a thorough review should be undertaken of all Class A items and that inven- tory turnover might be increased by 25 percent, and hence might lower inventory carrying costs, by trimming current stocks. To convince Clarinda's CEO, Marco plans to perform a demonstration inventory analysis that focuses on the forms used by the surgical intensive care unit (SICU). Different forms are required for almost every aspect of SICU operations, including records of patient progress; requests for lab tests, blood products, and medications; nurse and physician notes; and transfer/ discharge instructions. Exhibit 28.2 shows inventory usage and cost data on the SICU's 25 forms. To begin his demonstration analysis, Marco plans to conduct a new ABC analysis on the SICU's inventory. (Clarinda is in the process of converting to web-based forms as part of the transition to electronic medical records, but the paper forms will still be used for several years.) As part of its commitment to supporting the local economy, Clarinda currently uses a single local source for all of the SICU's forms: Atwood Printing and Office Supplies (Supplier A). Supplier A requires a $25 set-up fee on each order, in addition to the cost per unit. Clarinda is considering using a national supplier, Bateman Medical Office Products (Supplier B), which charges no set-up fee but does charge $50 to cover postage and han- dling. Supplier B takes three days to deliver the forms, as opposed to only one day for Supplier A. Processing each order will cost Clarinda another $25, regardless of which supplier is used. Thus, the total order cost is $50 for Supplier A and $75 for Supplier B. Marco's ultimate goal is to use economic ordering quantity (EOQ) concepts to select the supplier for all forms used by the SICU. His primary areas of concern are (1) the number of orders placed each year, (2) reorder points (in units), and (3) total inventory costs. As part of the demonstra- tion analysis, Marco will focus on the form used to order blood products from Clarinda's blood bank (SKU number 53104 in exhibit 28.2). The data

image text in transcribedimage text in transcribedimage text in transcribed
associated with Suppliers A and B, as well as the inventory carrying costs and other data, are summarized in exhibit 28.3. In addition to an analysis without safety stocks, Marco is concerned about the impact of safety stocks on the decision. Clarinda currently carries a safety stock of two units of SKU 53104 to protect itself against stockouts as a result of delivery delays and/or an increase in the usage rate. When asked how that amount was calculated, the manager of the SICU stated that she didn't know but the hospital had always done it that way. How- ever, if Clarinda decides to switch to Supplier B, the manager stated that it seems logical to increase the safety stock to six units to reflect Supplier B's three-times-as-long lead time. The following are of particular interest: the impact of safety stocks on inventory costs, the safety margins that such stocks would provide against higher-than-expected usage and shipping delays, and whether the current lead time for Supplier A and the estimate for Supplier B make any sense. Marco has heard a rumor that Supplier B is about to offer a 10 percent discount if the entire year's demand (92 units) is ordered at once. He wants to know what the impact of this discount would be on the decision about which supplier to use. How high a discount is needed to make Supplier B less costly than Supplier A is also useful to know. Furthermore, Marco is aware that the forms would not likely be ordered exactly as prescribed by the EOQ model, so he would like to know the impact of ordering variations on total inventory costs. Finally, he knows that Clar- inda's CEO has expressed some doubt about the value of the EOQ model in making real-world inventory decisions. "If I'm right in my concerns," he asked, "what other inventory control methods are available to us?" Place yourself in Marco's shoes to see if you can conduct the demonstra- tion analysis that he has in mind. Classification Inventory Value Inventory Amount EXHIBIT 28.1 ABC Classification 60%-70% 10%-20% Guidance 20%-30% 30%-40% 10%-20% 50%-60%EXHIBIT 28.2 Supplier A Units Used Clarinda Community SKU Number Unit Size Unit Cost Annually Hospital: Form Inventory Data for SICU 50071 25 $ 31 50083 25 16 4 50084 50 18 14 50091 250 86 28 50100 25 22 4 50102 250 793 3 50122 250 196 50129 250 177 50131 100 122 50132 100 98 50138 100 26 50139 50 21 10 50170 100 8 83 50172 100 44 4 50174 500 62 8 50193 25 2 66 50194 100 122 2 50206 250 11 279 50472 100 192 2 50475 125 551 4 50694 100 18 10 51060 100 102 6 53006 50 17 4 53104 50 66 92 57134 100 16 5Expected annual usage 92 units EXHIBIT 28.3 Clarinda Community Cost per Unit Hospital Cost and Supplier A $66 Usage Data: Blood Supplier B $60 Product Ordering Form (SKU 53104) Inventory Carrying Costs Depreciation 0.0% Storage and handling 17.1 Interest expense 6.6 Property taxes 0.4 Insurance 0.9 Total carrying costs 25.0% Inventory Ordering Costs Supplier A $50 Supplier B $75 Current Safety Stocks Supplier A 2 units Supplier B (estimate) 6 units Delivery Times Supplier A 1 day Supplier B 3 days

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Financial Accounting Fundamentals With Connect Plus

Authors: John Wild

4th Edition

77785932, 978-0077785932

More Books

Students also viewed these Accounting questions