Coral Drugs Case Study
Autor: Gir Rana • April 26, 2019 • Case Study • 2,070 Words (9 Pages) • 1,927 Views
Case 10-2: Coral Drugs March 13, 2019
Team 2: Hyrum Jerez
Gir Rana
Berlain Tsinchou
Rob Cameron
Anthony Polini
Tom Norton
Coral Drugs Background
- Long established retail Drug Store (pharmacy) founded in 1962
- Operates 114 stores in the state of Ohio
- Expansion plans of 8-10 stores over the next 5 years
- Retail outlets sell pharmaceutical products as well as other drug store items
- Strong financial balance sheet
- Looking to pursue any opportunity to improve/increase profitability
- Sells both national & private label brands (i.e.) Life Brand - Shoppers Drugs
- Private brands have an average margin of 40% vs. 25% margin on national brands
- Coral private brand suppliers manufacture, generate artwork, invest in required equipment and perform quality assurance
Main Issue
Supplier change from existing long-standing Twinney Incorporated (“Twinney”) to potential new supplier Gorman and Irizawa Ltd (G& I) for dandruff shampoo sourcing for its private label shampoo.
Associated Issues
- Twinney is not willing to alter verbal arrangements as requested by Coral
- No existing written agreement between Coral and Twinney
- Twinney manufacturing plant is located 600 miles away
- Twinney injection mold machine requires capital repairs => potential supply disruption looming.
- Existing lead times 3-4 weeks for new orders
- Order restrictions - must order by skid volume => 4,000 units / skid
- Current retail sales avg. 5,000 units/month => sales & order quantities not aligned
- Inventory carrying costs (2%/month/24% annualized)
- Stock-outs have occurred due to lead times as noted above
- G & I - small start-up, hungry for business and located close to Coral warehouse
Assumptions
- Current contract not written / verbal understanding only.
- Coral to provide 30 day Notice of Termination to Twinney if necessary. Remove any legal ambiguity issues by acting as if a proper written contract existed.
- Current bid by Twinney represents current price used (no +/- adjustment to price)
- Transportation costs for G & I due to proximity to Coral warehouse is insignificant
- 600 mile transportation cost => 10% of annual spend for Twinney order ($4,000 or $0.067/oz avg. over 60,000 units)
Analysis
Qualitative Analysis
TWINNEY INCORPORATED
- Long relationship with Coral Drugs for private label production.
- Unwilling to accommodate Coral Drugs request or alter terms already agreed upon.
- Minimum order requirements = full skid at 4,000 units
- Needs to repair injection mold machine -> capital requirement & timing of back online
- Future supply issues with lead times and production run delays
- Currently produces and ships FOB to Coral Drugs warehouse - (600 miles away)
- Discount payment terms of 2/10 net 30 days
- Lead times 3-4 weeks, results in various Coral inventory levels (overages/stock-outs)
- Product sizes are smaller (6oz and 2oz) than national sizes (7oz and 3oz)
GORMAN AND IRIZAWA LTD
- Young local company; interested in building its business
- Lower bid prices per unit across all 3 products
- Product sizes (7oz and 3oz) compares equally to national brand sizes
- Potential to offer better value to customer = more volume for same price potentially
- Willing to accept terms of existing agreement as well as payment terms of 2/10, net 30 day.
- Same FOB delivery but located close to warehouse (assume 0-5 miles). No lead times => order with next day delivery; no minimum order quantities => very attractive option
- New facility but small footprint compared to Twinney; room for expansion possibly
Decision Criteria Matrix
Manufacturing | Transport Cost | Supplier Size | Contractual | Inventory | |
Supplier | Location | Arrangements | |||
TWINNEY | 600 miles away | Built into bid | Large | Not willing to | 2% /month |
(existing) | be flexible | long lead times | |||
X | X | X | X | X | |
G & I | Very proximal | Insignificant in | Small start-up | Open to | JIT delivery |
(new) | to Coral | bid | formalizing | ||
warehouse | |||||
√ | √ | √ | √ | √ | |
Quantitative Analysis
Profit Margin & Breakeven Analysis
Twinney Incorporated | |||||||||||
Type | Quantity | $/unit | Carrying Cost | Total Cost | Retail Price | Unit Revenue | Unit Margins | ||||
Regular | 20000 | 0.72 | 0.08 | 16000 | 1.49 | 29800 | 13800 | ||||
Fragrance | 20000 | 0.85 | 0.08 | 18600 | 1.49 | 29800 | 11200 | ||||
Trial | 20000 | 0.47 | 0.08 | 11000 | 0.89 | 17800 | 6800 | ||||
45600 | 77400 | 31800 | |||||||||
Carrying Cost | $4896/60000 = .08 / unit | ||||||||||
Assume each size the carrying costs remain constant | |||||||||||
4896/3 = 1632 units of each | |||||||||||
Average Weighted Cost (45600/60000) = .76 / unit | |||||||||||
Average Weighted Margin (31800/60000) = 0.53 | |||||||||||
Unit #'s for Breakeven Point = 24168 units sold/yr | |||||||||||
Gorman & Irizawa | |||||||||||
Type | Quantity | $/unit | Carrying Cost | Total Cost | Retail Price | Unit Revenue | Unit Margins | ||||
Regular | 20000 | 0.7 | 0.07 | 15400 | 1.49 | 29800 | 14400 | ||||
Fragrance | 20000 | 0.75 | 0.07 | 16400 | 1.49 | 29800 | 13400 | ||||
Trial | 20000 | 0.35 | 0.07 | 8400 | 0.89 | 17800 | 9400 | ||||
40200 | 77400 | 37200 | |||||||||
Carrying Cost | 4320/60000 = 0.07/unit | ||||||||||
Assume each size the carrying costs remain constant | |||||||||||
4320/3 = 1440 units of each | |||||||||||
Average Weighted Cost ((40200/60000) = 0.67 | |||||||||||
Average Weighted Margin (37200/60000) = 0.62 | |||||||||||
Unit #'s for Breakeven Point = 24924 units sold/yr (0.67*37200) |
[pic 1][pic 2][pic 3][pic 4][pic 5][pic 6]
...