Jacaranda Builders is undertaking an analysis of supplier costs in order to evaluate the relative costs and performance of each supplier. They have isolated a range of activities that are consumed by suppliers, identified activity drivers, and estimated the cost per unit of activity driver for last year: Activity Cost per unit of activity driver Downtime due to poor quality material $200 per unit reworked Order material $250 per order Receive order $180 per delivery Inspect order $300 per delivery Return material to supplier $220 per return Pay supplier $190 per invoice Dispute invoiced amount $560 per dispute The three major suppliers to the company consumed the following numbers of activities: Activity Possum Timber Wombat Plumbing Emu Insulation Units reworked 10 Order material 40 48 30 Receive order 40 60 38 Inspect order 40 60 38 Return material to supplier 5 4 15 Pay supplier 12 48 12 Dispute invoiced amount 13 In addition, a supplier relationship manager (salary $90 000) was employed. It is estimated that 60 per cent of his time was spent serving Wombat Plumbing, and 40 per cent on the other two suppliers. The cost of material purchased from each supplier was as follows: Page 746 Possum Timber $120 000 Wombat Plumbing $150 000 Emu Insulation S 74 000 Required: 1. Calculate the total cost of ownership for each of the three suppliers, using a format similar to that shown in Exhibit 15.3 0. 2. Determine the supplier performance index for each supplier.

Essentials of Business Analytics (MindTap Course List)
2nd Edition
ISBN:9781305627734
Author:Jeffrey D. Camm, James J. Cochran, Michael J. Fry, Jeffrey W. Ohlmann, David R. Anderson
Publisher:Jeffrey D. Camm, James J. Cochran, Michael J. Fry, Jeffrey W. Ohlmann, David R. Anderson
Chapter11: Linear Optimization Models
Section: Chapter Questions
Problem 10P: The management of Hartman Company is trying to determine the amount of each of two products to...
icon
Related questions
icon
Concept explainers
Topic Video
Question
9:44
.ll LTE
= Chegg
Supplier Costs In Order To...
Jacaranda Builders is undertaking an analysis of supplier costs in order to evaluate the relative costs and performance of each
supplier. They have isolated a range of activities that are consumed by suppliers, identified activity drivers, and estimated the cost
per unit of activity driver for last year:
Activity
Cost per unit of activity driver
Downtime due to poor quality material
$200 per unit reworked
Order material
$250 per order
Receive order
$180 per delivery
Inspect order
$300 per delivery
Return material to supplier
$220 per return
Pay supplier
$190 per invoice
Dispute invoiced amount
$560 per dispute
The three major suppliers to the company consumed the following numbers of activities:
Activity
Possum Timber
Wombat Plumbing
Emu Insulation
Units reworked
10
2
Order material
40
48
30
Receive order
40
60
38
Inspect order
40
60
38
Return material to supplier
5
4
15
Pay supplier
12
48
12
Dispute invoiced amount
13
In addition, a supplier relationship manager (salary $90 000) was employed. It is estimated that 60 per cent of his time was spent
serving Wombat Plumbing, and 40 per cent on the other two suppliers.
The cost of material purchased from each supplier was as follows:
Page 746
Possum Timber
$120 000
Wombat Plumbing
$150 000
Emu Insulation
S 74 000
Required:
1. Calculate the total cost of ownership for each of the three suppliers, using a format similar to that shown in Exhibit 15.3 0
2. Determine the supplier performance index for each supplier.
3. Discuss the relative performance of each supplier.
4. Do you have any recommendations on supplier selection for the management of Jacaranda Builders?
Show transcribed image text
This problem has been solved!
See the answer
A chegg.com
Transcribed Image Text:9:44 .ll LTE = Chegg Supplier Costs In Order To... Jacaranda Builders is undertaking an analysis of supplier costs in order to evaluate the relative costs and performance of each supplier. They have isolated a range of activities that are consumed by suppliers, identified activity drivers, and estimated the cost per unit of activity driver for last year: Activity Cost per unit of activity driver Downtime due to poor quality material $200 per unit reworked Order material $250 per order Receive order $180 per delivery Inspect order $300 per delivery Return material to supplier $220 per return Pay supplier $190 per invoice Dispute invoiced amount $560 per dispute The three major suppliers to the company consumed the following numbers of activities: Activity Possum Timber Wombat Plumbing Emu Insulation Units reworked 10 2 Order material 40 48 30 Receive order 40 60 38 Inspect order 40 60 38 Return material to supplier 5 4 15 Pay supplier 12 48 12 Dispute invoiced amount 13 In addition, a supplier relationship manager (salary $90 000) was employed. It is estimated that 60 per cent of his time was spent serving Wombat Plumbing, and 40 per cent on the other two suppliers. The cost of material purchased from each supplier was as follows: Page 746 Possum Timber $120 000 Wombat Plumbing $150 000 Emu Insulation S 74 000 Required: 1. Calculate the total cost of ownership for each of the three suppliers, using a format similar to that shown in Exhibit 15.3 0 2. Determine the supplier performance index for each supplier. 3. Discuss the relative performance of each supplier. 4. Do you have any recommendations on supplier selection for the management of Jacaranda Builders? Show transcribed image text This problem has been solved! See the answer A chegg.com
Expert Solution
steps

Step by step

Solved in 5 steps

Blurred answer
Knowledge Booster
Costing Systems
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Essentials of Business Analytics (MindTap Course …
Essentials of Business Analytics (MindTap Course …
Statistics
ISBN:
9781305627734
Author:
Jeffrey D. Camm, James J. Cochran, Michael J. Fry, Jeffrey W. Ohlmann, David R. Anderson
Publisher:
Cengage Learning
Managerial Accounting
Managerial Accounting
Accounting
ISBN:
9781337912020
Author:
Carl Warren, Ph.d. Cma William B. Tayler
Publisher:
South-Western College Pub
Financial And Managerial Accounting
Financial And Managerial Accounting
Accounting
ISBN:
9781337902663
Author:
WARREN, Carl S.
Publisher:
Cengage Learning,
Principles of Cost Accounting
Principles of Cost Accounting
Accounting
ISBN:
9781305087408
Author:
Edward J. Vanderbeck, Maria R. Mitchell
Publisher:
Cengage Learning
EBK CONTEMPORARY FINANCIAL MANAGEMENT
EBK CONTEMPORARY FINANCIAL MANAGEMENT
Finance
ISBN:
9781337514835
Author:
MOYER
Publisher:
CENGAGE LEARNING - CONSIGNMENT