Given the information in Exhibit 13.15 and a budget of $5,000,000, what is the most that...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Given the information in Exhibit 13.15 and a budget of $5,000,000, what is the most that Loyola Machining can pay for each manufactured unit? Assume one year is 250 working days and the order size is 6,500 units. Use the Total Supply Chain Cost Excel template for your analysis. EXHIBIT 13.15 Supply Chain Costs for Loyola Machining Price per Unit (P) Oversight Cost per Unit (0) 50.31 Annual Demand (D) 1 Total Supply Chain Cost Analysis 2 Enter the data only in the yellow cells. 3 The template is designed for up to five suppliers. 4 5 Supplier 6 7 10 11 32 13 14 15 16 17 18 19 20 21 22 23 24 Procurement cost/unit. P Management oversight cost/unit, O Unit transportation cost Ct Order cost/order, C. Holding cost per unit, C. Lead time, L Transport Cost per Unit (C) 8 Copyright © 2017 Cengage Learning Not for commercial use. Annual Demand, D Order Quantity, Q Average number of orders/year (D/Q) Average daily demand (D/250) Total procurement cost Total management oversight cost Total annual transportation cost Annual order cost Annual holding cost Average annual pipeline inventory cost Total supply chain costs Japanese $7.65 50.55 $0.60 5625.00 $1.35 00 400000 40000 $10.00 1600.00 $3,000,000.00 $220,000.00 $240,000.00 56.350.00 Order Cost (C) Mexican $7.60 50.65 $0.35 $400.00 $1.35 45 $3,040,000,00 $260.000.00 $140,000.00 54,000.00 522XXX1.00 $27.000.00 $129.000.00 502.200.00 53682.850.00 $1,568,2000.08 D Chinese $7.00 $1.25 50.75 $850.00 $1.35 120 $2,800,000.00 $500,000,00 $300,000.00 $8,500.00 $27,000.00 5259,200.00 $3,894,700.00 Cost to Store One Unit One Year (C₂) 19.00 E F Oder Lead Time in Days (4) 20 G Given the information in Exhibit 13.15 and a budget of $5,000,000, what is the most that Loyola Machining can pay for each manufactured unit? Assume one year is 250 working days and the order size is 6,500 units. Use the Total Supply Chain Cost Excel template for your analysis. EXHIBIT 13.15 Supply Chain Costs for Loyola Machining Price per Unit (P) Oversight Cost per Unit (0) 50.31 Annual Demand (D) 1 Total Supply Chain Cost Analysis 2 Enter the data only in the yellow cells. 3 The template is designed for up to five suppliers. 4 5 Supplier 6 7 10 11 32 13 14 15 16 17 18 19 20 21 22 23 24 Procurement cost/unit. P Management oversight cost/unit, O Unit transportation cost Ct Order cost/order, C. Holding cost per unit, C. Lead time, L Transport Cost per Unit (C) 8 Copyright © 2017 Cengage Learning Not for commercial use. Annual Demand, D Order Quantity, Q Average number of orders/year (D/Q) Average daily demand (D/250) Total procurement cost Total management oversight cost Total annual transportation cost Annual order cost Annual holding cost Average annual pipeline inventory cost Total supply chain costs Japanese $7.65 50.55 $0.60 5625.00 $1.35 00 400000 40000 $10.00 1600.00 $3,000,000.00 $220,000.00 $240,000.00 56.350.00 Order Cost (C) Mexican $7.60 50.65 $0.35 $400.00 $1.35 45 $3,040,000,00 $260.000.00 $140,000.00 54,000.00 522XXX1.00 $27.000.00 $129.000.00 502.200.00 53682.850.00 $1,568,2000.08 D Chinese $7.00 $1.25 50.75 $850.00 $1.35 120 $2,800,000.00 $500,000,00 $300,000.00 $8,500.00 $27,000.00 5259,200.00 $3,894,700.00 Cost to Store One Unit One Year (C₂) 19.00 E F Oder Lead Time in Days (4) 20 G
Expert Answer:
Answer rating: 100% (QA)
The most that Loyola Machining can pay for each manufactured unit is 760 This is calculated using th... View the full answer
Related Book For
Modern Advanced Accounting in Canada
ISBN: 978-1259087554
8th edition
Authors: Hilton Murray, Herauf Darrell
Posted Date:
Students also viewed these mathematics questions
-
Given the information in Problem 6-56, develop a gross material requirements plan for 50 units of item A.
-
Given the information in the previous two problems, calculate the gross margin, the operating margin, return on assets, and return on equity for Smashville, Inc.
-
Given the information in the following lag exercises, compute the early, late, and slack times for the project network. Which activities on the critical path have only the start or finish of the...
-
For students who enjoy the complexities of analytical syllogistics, here follow some theoretical questions whose answers can all be derived from the systematic application of the six rules of the...
-
a. International Paper Company (IP) needs $100 million of additional financing, but because of restrictions in existing debt covenants, it cannot place any more debt on its balance sheet. To obtain...
-
A. Review Microsoft and Nokia alliance described in a STRATEGY APPLICATION in this chapter. Identify the strategy underpinning this alliance. Is this an effective counter to the strength of...
-
Why is the equity method sometimes called the one-line consolidation method?
-
Landers Inc. is considering purchasing J&B Properties, which has the following assets and liabilities. 1. Make the journal entry necessary for Landers Inc. to record the purchase if the purchase...
-
e) Describe 3 substantives tests that the auditor would perform to obtain sufficient and appropriate audit evidence and financial statement assertions that could be tested on salary and wages.. The...
-
An end loader for a small garden tractor is shown. All connections are pinned. The only significant weight is W . (a) Draw six FBDs, one each for members BC, DG, and AEF , plate CDE, hydraulic...
-
Power Company reported beginning and ending total assets of $ 32000 and $ 3000 respectively. Its net sales revenue for the year were $ 30 comma 380. What was Power's asset turnover? ratio?
-
Briefly, what responsibilities have The Institute of Internal Auditors (IIA), internal auditing departments, and individual practitioners assumed in the development of professionalism in internal...
-
Identify six ways that internal auditors can help to minimize their chances of being placed in situations in which they feel unable to make objective professional judgments.
-
Indicate the specific internal accounting control objectives and a proper departmental assignment of duties for the first four functions involved in executing purchase transactions.
-
What are the specific accounting control objectives for the three functions involved in recording purchases and cash disbursements?
-
Enumerate the steps in (a) preparing vouchers and (b) issuing checks.
-
The table below contains information on five work orders. Each order is processed in two machines, first in machine A and then in machine B. Working Processing time in Processing time in order...
-
KD Insurance Company specializes in term life insurance contracts. Cash collection experience shows that 20 percent of billed premiums are collected in the month before they are due, 60 percent are...
-
Shown below are selected ledger accounts from the trial balance of a parent and its subsidiary as of December 31, Year 10. Additional Information: P Company purchased its 90% interest in S Company...
-
Distinguish between the financial reporting for FVTPL investments and that for investments in associates.
-
The FCT and PCT methods each produce different amounts for translation gains and losses due to the items at risk. Explain.
-
Purchasing power parity You are given the data in Table 3.17 on prices in local currency in the United States, Mexico, and England. a. What are the rates of currency exchange suggested by the...
-
HG Lang Designs operates an exclusive bridal boutique in Manhattan. All gowns are designed by Lang but are manufactured by various small firms in France and Italy. The following financial information...
-
HG Lang Designs operates an exclusive bridal boutique in Manhattan. All gowns are designed by Lang but are manufactured by various small firms in France and Italy. The following financial information...
![Mobile App Logo](https://dsd5zvtm8ll6.cloudfront.net/includes/images/mobile/finalLogo.png)
Study smarter with the SolutionInn App