Question

In: Accounting

Emma, a buyer at William A Smith Engineering, a Mississippi-based purveyor of transits for surveyors, was...

Emma, a buyer at William A Smith Engineering, a Mississippi-based purveyor of transits for surveyors, was doing some number crunching. William A Smith Engineering was reevaluating its suppliers for a key component of the transit, the stand. After some extensive evaluation, Emma had narrowed it down to two suppliers and she was comparing them. Jackson Castings, Inc. was a regional company and Shanghai Metals was based in Guangdong Province, China. Given the following information that Emma compiled, use total cost analysis to determine which supplier is more cost-effective for William A Smith Engineering.

Late delivery of the stand results in either a lost sale (thus lost profit) or a customer backorder (each time there is a backorder, it costs $395). Assume for the cost comparison that the company orders 12 times per year, the order quantity is 7,833 units, and that the annual requirement (forecast) is 94,000 units.

Each time that she orders from a domestic supplier, Emma estimates that it costs the company $ 708 and each time she orders from international suppliers, it costs about $1,160. For purposes of calculating quality problems and declaring the value for customs and insurance, Emma uses the expected invoice amount (purchase cost + packing/packaging) as a base. Emma also knows that additional factory inspection trips will need to be made to the China facility to support the company’s environmental, social, and quality goals.

What should Emma do? Taking in consideration procurement rules of thumb regarding international sourcing and based on the analysis below, should she source globally or domestically?

Enter Global or Domestic.

Important! Round each entry to the nearest whole number. Enter as ###,###. Enter negative numbers as -###,###.

Product Weight 5 pounds
Cost of working capital 9% per year
Profit margin 12% annual
Price of finished transit $ 560 per unit
Percent of late deliveries that result in backorders 42% of late deliveries
Percent of late deliveries that result in lost sales 58% of late deliveries
Jackson Castings Shanghai Metals
Quoted unit price $37.00 $28.00
Packing cost (+ packing for international shipping) $ 1.48 $3.25
Tooling cost $3,000 $5,000
Invoice Terms 2/10, net 30 2/15, net 30
Domestic delivery distance (in miles) 122 400
Supplier quality rating (% problems) 2.00% 3.00%
Supplier delivery rating (% problems) 1.00% 2.00%
Number of forty-foot equivalents (FEU) per order 1
China inland freight and freight forwarding (per FEU) $418
Ocean transport (per FEU) $2,591
Marine cargo insurance (% declared value) 1.4%
U.S. Customs duty and fees (% declared value) 5.0%
U.S. port handling and brokerage fees (per FEU) $1,449
Factory inspection trips to China $30,000
Domestic U.S. Transportation Costs
Full truckload (TL>40,000 lbs.) $0.89 per ton-mile
Less-than-truckload (LTL) $1.14 per ton-mile
Note: per ton mile = 2,000 pounds per mile

FILL OUT ALL SHANGAI METALS COLUMN

Description Jackson Castings Shanghai Metals
Purchase Cost $ 3,478,000 $
Packing Cost 139,120
Effective Invoice Amount $ 3,617,120 $ 2,937,500
Effect of Discount Terms
Cash Discount -72,342
Cost of Capital Savings -9,043
Tooling Cost 3,000
Ordering Cost 8,496
Domestic Transportation Cost 32,684
China Inland Freight and Freight Forwarding
Ocean Transport
Marine Cargo Insurance
U.S. Customs Duty and Fees
U.S. Port Handling and Brokerage Fees
Quality Cost 72,342
Cost of Late Delivery
Backorders 155,946
Lost sales 36,637
China Factory Inspection Trips
TOTAL COST $ 3,844,840 $ 3,738,602

Solutions

Expert Solution

Description Shanghai Metals
Purchase cost (94000 x $28) 2632000
Packing cost (94000 x $3.25) 305500
Effective invoice amount 2937500
Effect of discount terms:
Cash discount (2% x $2937500) -58750
Cost of capital savings -11016
Tooling cost 5000
Ordering cost (12 x $1160) 13920
Domestic transportation cost [(94000 x 5 x 400)/2000 x $1.14] 107160
China inland freight and freight forwarding (1 x 12 x $418) 5016
Ocean transport (1 x 12 x $2591) 31092
Marine cargo insurance (1.4% x $2937500) 41125
U.S Customs duty and fees (5% x $2937500) 146875
U.S. Port handling and brokerage fees (1 x 12 x $1449) 17388
Quality cost (3% x $2937500) 88125
Cost of late delivery:
Backorders (94000 x 42% x 2% x $395) 311892
Lost sales (94000 x 58% x 2% x $67.20)* 73275
China factory inspection trips 30000
TOTAL COST 3738602

Considering the procurement rule of thumb for international sourcing, if the international sourcing does not generate minimum cost savings of 15% over the domestic sourcing, then domestic sourcing should be opted for.

International saving/domestic cost = ($3844840 - $3738602)/$3844840 = $106238/$3844840 = 2.76%

Emma should source - DOMESTIC


Related Solutions

Joseph, a buyer at Taggart & Smith, a Georgia-based purveyor of custom stereos for auto enthusiasts,...
Joseph, a buyer at Taggart & Smith, a Georgia-based purveyor of custom stereos for auto enthusiasts, was doing some number crunching. Taggart & Smith was reevaluating its suppliers for a key component of the custom stereo, the sub-woofer. After some extensive evaluation, Joseph had narrowed it down to two suppliers and he was comparing them. PeachTree SpeakerWorks was a regional company and China Sound was based in Guangdong Province, China. Given the following information that Joseph compiled, use total cost...
William Smith, Sr., was the founder of Smith Enterprises, Inc. He owns 60% of the stock...
William Smith, Sr., was the founder of Smith Enterprises, Inc. He owns 60% of the stock of Smith Enterprises (60,000 shares of 100,000 shares outstanding, stock basis $100 per share). The value of the stock was recently determined to be about $500 per share. Over the years, William, Sr., has done a very good job of getting his sons and daughters (and even grandchildren) involved in the business, and the other 40% of the Smith Enterprises stock is owned by...
1.F): Understanding of ethical and professional responsibilities William, an engineer working for an established engineering firm,...
1.F): Understanding of ethical and professional responsibilities William, an engineer working for an established engineering firm, is working after normal business hours to finish an important and urgent on-going bid. He realizes that he is missing data that had been sent to his coworker Mike. William had inadvertently observed Mike typing his password several days ago and decides to log into Mike’s computer and resend the data to himself. Upon doing so, William sees an email sent from Mike’s account...
Emma Engineering Group receives royalties on a technical manual written by two of its engineers and sold to a publishing company.
  Emma Engineering Group receives royalties on a technical manual written by two of its engineers and sold to a publishing company. Royalties are 10% of net sales, receivable on October 1 for sales in January through June and on April 1 for sales in July through December of the prior year. Sales of the manual began in July 2015, and Emma accrued royalty revenue on $30,400 of sales at December 31, 2015. Emma received royalties of $2,889 on April...
Emma Engineering Group receives royalties on a technical manual written by two of its engineers and sold to a publishing company.
  Emma Engineering Group receives royalties on a technical manual written by two of its engineers and sold to a publishing company. Royalties are 10% of net sales, receivable on October 1 for sales in January through June and on April 1 for sales in July through December of the prior year. Sales of the manual began in July 2015, and Emma accrued royalty revenue on $34,400 of sales at December 31, 2015. Emma received royalties of $3,853 on April...
Adam Smith is a portfolio manager with Point72 Investments, a U.S.-based asset management firm. Smith is...
Adam Smith is a portfolio manager with Point72 Investments, a U.S.-based asset management firm. Smith is considering using options to enhance portfolio returns and control risk. He asks his junior analyst, John Miller, to help him. John collected the current market prices and data of selected instruments related to Lotus stock in Table 2. According to Table 2, which of the following should be Smith's arbitrage strategy? (Choose the best answer) Table 2 European call option on Lotus equity $6...
question1: students' scores: mark: 81 john: 99 smith: 66 Meggie: 100 terry: 20 William: 65 a....
question1: students' scores: mark: 81 john: 99 smith: 66 Meggie: 100 terry: 20 William: 65 a. Modify the student's score program so that it reads the exam scores into a queue and prints the queue. –Next, filter out any exams where the student got a score of 100. –Then perform your previous code of reversing and printing the remaining students. b. What if we want to further process the exams after printing?
The Smith Engineering Company began operations on December 1, 2017. The unadjusted trial balance of the...
The Smith Engineering Company began operations on December 1, 2017. The unadjusted trial balance of the Smith Engineering Company as of December 31, 2017 is found on the trial balance tab. The following information is required to prepare the necessary adjusting entries for the Smith Engineering Company found in chapter 3. 1) The balance in Prepaid insurance represents a 24-month policy that went into effect on December 1, 2017. Review the unadjusted balance in Prepaid insurance, and prepare the necessary...
The Smith Engineering Company began operations on December 1, 2017. The unadjusted trial balance of the...
The Smith Engineering Company began operations on December 1, 2017. The unadjusted trial balance of the Smith Engineering Company as of December 31, 2017 is found on the trial balance tab. The following information is required to prepare the necessary adjusting entries for the Smith Engineering Company found in chapter 3. 1) The balance in Prepaid insurance represents a 24-month policy that went into effect on December 1, 2017. Review the unadjusted balance in Prepaid insurance, and prepare the necessary...
One page ESSAY on “Heart disease death rate in Mississippi” based on “Healthy People 2020” program
One page ESSAY on “Heart disease death rate in Mississippi” based on “Healthy People 2020” program
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT