Question

In: Operations Management

The Waterworks Plumbing Supply Company stocks thousands of plumbing items sold to regional plumbers, contractors and...

The Waterworks Plumbing Supply Company stocks thousands of plumbing items sold to regional plumbers, contractors and retailers. James Sullivan, the firm’s general manager, wonders how much money could be saved annual if an Inventory Model was defined/used instead of the firm’s present rules of thumb, to determine an Optimal Inventory Policy. Material #3925 is externally sourced.

Because Waterworks supplies hundreds of regional plumbers, contractors and retailers, their operation experiences a probabilistic demand; in fact, the number of units demanded varies considerably from day-to-day and from week-to-week. Historical sales data (for Material #3925) indicate that demand during a one-week lead time can be described as having a Normal Probability Distribution with a mean of 190 units and a standard deviation of 35 units (1 unit = 1 brass valve, Material #3925).

Mike Wazowski develops the following estimates from accounting information:

Cost per valve = $1.60

Annual Inventory Holding Rate = 25%

Ordering Cost (per order) = $5.50

Working Days per Year = 250

Lead Time = 5 days

James Sullivan is willing to tolerate a stock-out rate of 5%. What is the recommended inventory decision (i.e., the order quantity and the reorder point)? And, how much Safety Stock will be made available to absorb higher-than-usual demand during the lead time? What is the associated cost of the Safety Stock? Finally, what is the anticipated Total Annual Cost for this inventory system/policy?

Expert Solution

Given are following data :

Annual demand = D = 190/ week x 52 weeks = 9880

Ordering cost = Co = $5.50

Annual inventory holding cost = Ch = 25% of $1.60 = $0.40

Optimum order quantity ( EOQ )

= Square root ( 2 x Co x D/Ch )

= Square root ( 2 x 5.50 x 9880/0.40)

= 521.24 ( 521 rounded to nearest whole number )

Standard deviation of weekly ( i.e. 7 days ) demand = 35

Lead time = 5 days

Therefore, standard deviation of demand during lead time of 5 days = 35 x Square root ( 5/7 ) = 29.58

In stock probability ( since stockout rate is 5% ) = 95% (or, 0.95 )

Z value for in stock probability of 0.95 = NORMSINV ( 0.95 ) = 1.6448

Therefore safety stock = Z value x standard deviation of demand during lead time of 5 days = 1.6448 x 29.58 = 48.653 ( 49 rounded to nearest whole number )

SAFETY STOCK = 49

Daily demand = Weekly demand / 7 = 190/7

Reorder point = Daily demand x Lead time of 5 days + safety stock = 190/7 x 5 + 49 = 135.71 + 49 = 184.71 ( 185 rounded to nearest whole number )

REORDER POINT = 185

Annual cost of safety stock = Annual inventory holding cost x Safety stock = $0.40 x 49 = $19.60

Total annual inventory cost = ( EOQ/2 + safety stock ) x Ch = ( 521/2 + 49 ) x $0.40 = ( 260.5 + 49) x $0.40 = $ 309.5 x0.40 = $123.8

Total annual ordering cost = Ordering cost x Number of orders = Ordering cost x annual demand/ EOQ= $5.50x 9880/521 = $104.30

Total annual purchasing cost = Cost/ valve x annual demand for valves = $1.60 x 9880 = $15808

Anticipated total annual cost for this inventory policy

= Total annual purchasing cost + Total annual inventory cost + Total annual purchasing cost

= $15808 + $123.80 + $104.30

= $16036.10 ( $16036 rounded to nearest whole number )

ANTICIPATED TOTAL ANNUAL COST FOR THIS INVENTORY SYSTEM = $16036

keosha answered 10 months ago

Yeopay Plumbing Supply accepts bank credit cards and offers established plumbers charge accounts with terms of...

Yeopay Plumbing Supply accepts bank credit cards and offers established plumbers charge accounts with terms of 1/eom, n/45. Yeopay’s experience is that 25% of its sales are for cash and bank credit cards. The remaining 75% are on credit. Of the cash sales, 40% pay cash and the remaining 60% pay with bank credit cards. Yeopay receives payments from the bank on credit card sales at the end of the day. However, Yeopay has to pay 3% for these services....

4) A company manufactures household items sold at trade shows. The items, classified as either Trinkets...

4) A company manufactures household items sold at trade shows. The items, classified as either Trinkets or Widgets are manufactured on a common assembly line. Although different direct materials are used, the direct labour cost is the same for each product line. The plant-wide rate for allocating manufacturing overhead to its products is no longer acceptable. The production manager has heard about activity-based costing and has assembled some information for use in changing the cost system to a cost driver...

DURAPLAST Company Ltd., opened its doors in 1979 as a wholesale supplier of plumbing equipment, tools, and parts to hardware stores, home-improvement centers, and professional plumbers in the Accra-Tema Metropolitan area.

DURAPLAST Company Ltd., opened its doors in 1979 as a wholesale supplier of plumbing equipment, tools, and parts to hardware stores, home-improvement centers, and professional plumbers in the Accra-Tema Metropolitan area. Over the years they have expanded their operations to serve customers across the nation and now employ over 200 people as technical representatives, buyers, warehouse workers, and sales and office staff. Most recently DURAPLAST has experienced fierce competition from the large online discount stores such as Qualiplast and...

MacKenzie Company sold $360 of merchandise to a customer who used a Regional Bank credit card....

MacKenzie Company sold $360 of merchandise to a customer who used a Regional Bank credit card. Regional Bank deducts a 1.0% service charge for sales on its credit cards and credits MacKenzie's account immediately when sales are made. The journal entry to record this sale transaction would be: Debit Cash of $360 and credit Sales $360. Debit Cash of $360 and credit Accounts Receivable $360. Debit Accounts Receivable $360 and credit Sales $360. Debit Cash $356.40; debit Credit Card Expense...

MacKenzie Company sold $520 of merchandise to a customer who used a Regional Bank credit card....

MacKenzie Company sold $520 of merchandise to a customer who used a Regional Bank credit card. Regional Bank deducts a 5.0% service charge for sales on its credit cards. MacKenzie electronically remits the credit card sales receipts to the credit card company and receives payment immediately. The journal entry to record this sale transaction would be: Debit Accounts Receivable—Regional $494.00; debit Credit Card Expense $26.00 and credit Sales $520. Debit Cash $494.00; debit Credit Card Expense $26.00 and credit Sales...

Rembrandt Paint Company had the following income statement items for the year ended December 31, 2021 ($ in thousands):

Rembrandt Paint Company had the following income statement items for the year ended December 31, 2021 ($ in thousands): Sales revenue ............................................$18,000Interest revenue ...............................................100Interest expense ...............................................300Cost of goods sold .......................................10,500Selling and administrative expense ............2,500Restructuring costs ..........................................800 In addition, during the year, the company completed the disposal of its plastics business and incurred a loss from operations of $1.6 million and a gain on disposal of the component’s assets of $2 million. There were 500,000 shares of common stock outstanding throughout 2021. Income...

The following information is available regarding Western Regional Supply Company: The company's December 2019 records showed...

The following information is available regarding Western Regional Supply Company: The company's December 2019 records showed the following: Cash Receipts Journal Cash Disbursements Journal Date $ Date Cheque # $ December 1 9 12 21 23 30 TOTAL 5,000 8,300 7,200 10,900 2,700 3,200 $ 37,300 December 2 6 10 15 17 23 31 47 48 49...

On January 1, 2018, Swifty Incorporated sold services to a Canadian supply company and accepted a...

On January 1, 2018, Swifty Incorporated sold services to a Canadian supply company and accepted a three-year note in the amount of 10,100 Canadian dollars. Assume that exchange rates between the U.S. dollar and the Canadian dollar are as follows: Date U.S. Dollars per Canadian Dollars January 1, 2018 $0.96 December 31, 2018 1.00 December 31, 2019 0.92 Provide the journal entries (in U.S. dollars) prepared by Swifty to record the receipt of the note and the exchange gains/losses recognized...

Hafers, an electrical supply company, sold $5,000 of equipment to Jim Coates Wiring, Inc. Coates signed...

Hafers, an electrical supply company, sold $5,000 of equipment to Jim Coates Wiring, Inc. Coates signed a promissory note May 12 with 4.8% interest. The due date was August 10. Short of funds, Hafers contacted Charter One Bank on July 20; the bank agreed to take over the note at a 6.5% discount. (Use Days in a year table.) What proceeds will Hafers receive? (Use 360 days a year. Do not round intermediate calculations. Round your final answer to the...

1- Hafers, an electrical supply company, sold $5,000 of equipment to Jim Coates Wiring, Inc. Coates...

1- Hafers, an electrical supply company, sold $5,000 of equipment to Jim Coates Wiring, Inc. Coates signed a promissory note May 12 with 4.8% interest. The due date was August 10. Short of funds, Hafers contacted Charter One Bank on July 20; the bank agreed to take over the note at a 6.5% discount. (Use Days in a year table.) What proceeds will Hafers receive? (Use 360 days a year. Do not round intermediate calculations. Round your final answer to...