OM6     ONLINE-LMS INTEGRATED ACCESS
OM6 ONLINE-LMS INTEGRATED ACCESS
6th Edition
ISBN: 9781337118323
Author: Collier
Publisher: CENGAGE L
Question
Book Icon
Chapter 12, Problem 9PA

a

Summary Introduction

Interpretation:

Total annual parts and logistics cost for each supplier.

Concept Introduction:

The lot sizing rule consists of lot-for-lot, Fixed order quantity and Fixed period quantity. Out of all lot sizing rule, lot-for-lot rule results in least inventory because the order is planned and released according to net requirement of that particular week. A fixed order quantity is an inventory system in which a firm orders a fixed lot size i.e. the order quantity remains the same when ordered every time.

a

Expert Solution
Check Mark

Explanation of Solution

    Data Supplier A Supplier L
    Procurement cost/ unit, P$11.80$10.85
    Tariff cost/ unit,
    Tc
    $0.00$0.46
    Unit transportation cost,
    Tm
    $0.90$1.25
    Order cost/ order,
    Cο
    $155$195
    Holding cost per unit,
    Ch
    $1.45$1.10
    Lead time, L45100

The different cost components that are involved in this case are:

   Total procurement cost

   Total tariff cost

   Total transportation cost

   Annual ordering cost

   Annual inventory carrying cost

   Average annual pipeline Inventory cost

Compute these costs for all the three suppliers and select based on the least total cost of the supply chain.

The following formulae will be used:

Total procurement cost = D.P

Total tariff cost = D.Te

Total transportation cost = D.Tm

Annual ordering cost = (DQ).Cο

Annual carrying cost = (Q2).Ch

Annual pipeline inventory cost = (Dd).L.Ch

Where, D= annual demand, P= procurement cost per unit, Tc = tariff cost per unit, Tm = unit transportation cost, Cο = ordering cost per order, Ch = unit carrying cost per annum, Q = order size, d = number of days in a year, and L = lead time.

Note the computations done in the following Excel format.

    Total supply chain cost analysis
    Data Supplier A Supplier L
    Procurement cost/ unit, P$11.80$10.85
    Tariff cost/ unit,
    Tc
    $0.00$0.46
    Unit transportation cost,
    Tm
    $0.90$1.25
    Order cost/ order,
    Cο
    $155$195
    Holding cost per unit,
    Ch
    $1.45$1.10
    Lead time, L45100
    Order quantity50000100000
    Average number of orders/ year (D/Q)2010
    Annual demand, D1000000
    No. of days in a year, d340
    Average daily demand (D/d)2941
    Cost calculations
    Total procurement cost$11,800,000.00$10,850,000.00
    Total management oversight cost$0.00$460,000.00
    Total annual transportation cost$900,000.00$1,250,000.00
    Annual order cost$3,100$1,950
    Annual holding cost$36,250.00$55,000.00
    Average annual pipeline Inventory cost$191,911.76$323,529.41
    Total supply chain cost$12,931,261.76$12,940,479.41

The following is the formulated excel sheet calculations as shown below:

  OM6     ONLINE-LMS INTEGRATED ACCESS, Chapter 12, Problem 9PA

b

Summary Introduction

Interpretation:

Recommendation on order quantity

Concept Introduction:

The lot sizing rule consists of lot-for-lot, Fixed order quantity and Fixed period quantity. Out of all lot sizing rule, lot-for-lot rule results in least inventory because the order is planned and released according to net requirement of that particular week. A fixed order quantity is an inventory system in which a firm orders a fixed lot size i.e. the order quantity remains the same when ordered every time.

b

Expert Solution
Check Mark

Explanation of Solution

Based on the minimum total cost, the correct choice should be the Supplier A with Q = 50,000.

c

Summary Introduction

Interpretation:

Criteria for choosing supplier and quantity

Concept Introduction:

The lot sizing rule consists of lot-for-lot, Fixed order quantity and Fixed period quantity. Out of all lot sizing rule, lot-for-lot rule results in least inventory because the order is planned and released according to net requirement of that particular week. A fixed order quantity is an inventory system in which a firm orders a fixed lot size i.e. the order quantity remains the same when ordered every time.

c

Expert Solution
Check Mark

Explanation of Solution

Following are some of the criteria other than then total cost. The relevant metrics for measurement are also mentioned in the following table.

    CriteriaMetric
    QualitySigma level
    ReliabilityAverage service level
    CapacityPercentage utilization
    Delivery adherenceVariability in lead time

d

Summary Introduction

Interpretation:

Recommendation for supplier who is not awarded the brake pad order..

Concept Introduction:

The lot sizing rule consists of lot-for-lot, Fixed order quantity and Fixed period quantity. Out of all lot sizing rule, lot-for-lot rule results in least inventory because the order is planned and released according to net requirement of that particular week. A fixed order quantity is an inventory system in which a firm orders a fixed lot size i.e. the order quantity remains the same when ordered every time.

d

Expert Solution
Check Mark

Explanation of Solution

Supplier L should be given a target of reducing the procurement cost per unit by, say, 3%. Even with a 3% reduction of procurement cost per unit, it can compete with supplier A based on the total cost. This is shown below.

    Total supply chain cost analysis
    Data Supplier A Supplier L
    Procurement cost/ unit, P$11.80$10.85
    Tariff cost/ unit,
    Tc
    $0.00$0.46
    Unit transportation cost,
    Tm
    $0.90$1.25
    Order cost/ order,
    Cο
    $155$195
    Holding cost per unit,
    Ch
    $1.45$1.10
    Lead time, L45100
    Order quantity50000100000
    Average number of orders/ year (D/Q)2010
    Annual demand, D1000000
    No. of days in a year, d340
    Average daily demand (D/d)2941
    Cost calculations
    Total procurement cost$11,800,000.00$10,524,500.00
    Total management oversight cost$0.00$460,000.00
    Total annual transportation cost$900,000.00$1,250,000.00
    Annual order cost$3,100$1,950
    Annual holding cost$36,250.00$55,000.00
    Average annual pipeline Inventory cost$191,911.76$323,529.41
    Total supply chain cost$12,931,261.76$12,614,979.41

Want to see more full solutions like this?

Subscribe now to access step-by-step solutions to millions of textbook problems written by subject matter experts!
Students have asked these similar questions
analysis needs to address the following issues: The battery temperatures are a major concern for us. Can you analyze and describe the sample data? What are the average and median temperatures? How much variability is there in the temperatures? Is there anything that stands out? Our engineers’ assumption is that the temperature data is normally distributed. If that is the case, what would be the likelihood that the Safety Zone temperature will exceed 5.15 degrees? What is the probability that the Safety Zone temperature will be less than 4.65 degrees? What is the actual percentage of samples that exceed 5.25 degrees or are less than 4.75 degrees? Is the manufacturing process producing units with stable Safety Zone temperatures? Can you check if there are any apparent changes in the temperature pattern? Are there any outliers? A closer look at the Z-scores should help you in this regard.
Factor Factor Description Weight Present Location Newbury Hyde Park 1 Average community income 0.35 2 Community growth potential 0.15 3 Availability of public transportation 0.20 4 Labor availability, attitude, and cost 0.30 3 2 3 2 35 20 25 75 33 28 55 55 25 75 65 50 50 55
Subway with more than 27,000 outlets in the US is planning for a new restaurant in Buffalo New York. A) Based on the given information, the best location in Buffalo for Subway to open the new restaurant is Baptist Church with a total weighted score of? (Enter your response rounded to two decimal places.) B) If the weights for Space and Traffic density are reversed, the best location in Buffalo for Subway to open the new restaurant will be with a total weighted score of ? (Enter your response rounded to two decimal places.)
Knowledge Booster
Background pattern image
Similar questions
SEE MORE QUESTIONS
Recommended textbooks for you
Text book image
Purchasing and Supply Chain Management
Operations Management
ISBN:9781285869681
Author:Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson
Publisher:Cengage Learning
Text book image
MARKETING 2018
Marketing
ISBN:9780357033753
Author:Pride
Publisher:CENGAGE L
Text book image
Contemporary Marketing
Marketing
ISBN:9780357033777
Author:Louis E. Boone, David L. Kurtz
Publisher:Cengage Learning
Text book image
MKTG 12:STUDENT ED.-TEXT
Marketing
ISBN:9781337407595
Author:Lamb
Publisher:Cengage