Annual cost associated with running the upgraded system

Assignment Help Accounting Basics
Reference no: EM131048737

A Supply chain reconfiguration case study

The case company (referred to as ABC) is a leading supplier of maintenance, repair and operating (MRO) products to business and institutions in the United States, Canada and Mexico with an expanding presence in the Japan, India, China and Panama. The company works with more than 3,000 suppliers and offers nearly 900,000 products ranging from industrial adhesive used in manufacturing, to hand tools, janitorial supplies, lighting equipment, and power tools. When something is needed by one of their 1.8 million customers, it is often needed quickly. So, quick service and product availability are key drivers to ABC's success.

Your assignment involves studying the US distribution network in ABC's supply chain. ABC works with over 250 suppliers in China and Taiwan region. The suppliers produce products to ABC's specifications and ship to the US using ocean freight carriers from four major ports in China and Taiwan. From these ports, products are shipped to US entry ports in either Seattle or Los Angeles. ABC currently has free on board (FOB) shipping contracts with Chinese and Taiwanese suppliers by which the supplier is responsible for all costs incurred until the product is delivered to the US entry ports. Approximately 40% of the containers enter in Seattle and 60% at the Los Angeles port. Containers on arrival at the port cities are inspected by federal agents. After passing through customs, products are loaded onto the 20-foot and 40-foot containers and are shipped by rail to ABC's central distribution centre in Kansas City. Variable processing costs at both Los Angeles and Seattle ports are $5 per cubic meter (CBM). The rate for shipping the containers to Kansas City is $0.0018 per CBM per mile.

In Kansas City, the containers are unloaded and processed though a quality assurance check. This costs $3 per CBM processed. A negligible percentage of the material may need to be sent back to the supplier. Errors in quantity and package size are often found requiring accounting adjustments. Items are stored in Kansas City distribution centre, which serves nine warehouses in the US. The nine warehouses each place orders at the distribution centre that contains all the items to be replenished. Kansas City consolidates the items on order onto pallets and ships them on 53-foot trucks to warehouses. Truck freight cost $0.0220 per CBM per mile. The demand forecasts for the items purchased from China/Taiwan for next year and shipping distances are given in the following table:

Demand (CBM) - Distances (Miles)

Warehouse Average % of total Demand From Kansas City From Los Angeles From Seattle

Kansas City  20,900 11% 0 1,620 1,870
Cleveland  17,100 9% 800 2,350 2,410
New Jersey  24,700 13% 1200 2,780 2,890
Jacksonville  15,200 8% 1150 2,420 2,990
Chicago  22,800 12% 520 2,020 2,060
Greenville  15,200 8% 940 2,320 2,950
Memphis  17,100 9% 510 1,790 2,330
Dallas  22,800 12% 500 1,430 2,130
Los Angeles  34,200 18% 1620 0 1,140






Total 



190,000

Although a high percentage of demand was from warehouses in south and east of Kansas City, the question has surfaced concerning the 18% that will be shipped to Kansas City and then shipped back to Los Angeles warehouse. This double-transportation could potentially be eliminated if a new distribution centre were built in Los Angeles. The idea might be to ship material arriving at the Seattle port by rail to a new Los Angeles distribution centre, which would be located at the current location of the Los Angeles warehouse.

It is estimated that the Los Angeles facility could be upgraded at a one-time cost of $1,500,000 and then operated for $350,000 per year. In the new Los Angeles distribution centre, containers would be unloaded and processed through a quality assurance check, just as is now done in Kansas City. The variable cost for doing this would be $5 per CBM processed, which includes the cost to move the containers from the Los Angeles port to the distribution centre. After the material is processed in Los Angeles, the amount needed to replenish the Los Angeles warehouse (approximately 18%) would be kept and the rest sent my rail to Kansas City. It would then be stocked in the Kansas City distribution centre and used to replenish the warehouses.

ABS management feels that it may be possible to make the change, but they are unsure if it would actually save any money and whether it would be a good strategic change.

Questions to be addressed in your analysis:

1. What would be the annual cost associated with running the existing system?

Note: In the existing system 40% of the volume arrives in Seattle and 60% in Los Angeles. All material is transferred to the Kansas City distribution centre by rail, where it is unloaded and quality checked. All volume is then transferred by truck to the nine existing warehouses in the US.

2. What would be the annual cost associated with running the upgraded system?

Note: In the new system, the Los Angeles warehouse is upgraded to include a distribution centre capable of processing all the volume coming into the US. Containers coming into Seattle would be inspected by federal officials (it needs to be done at all port locations) and then immediately shipped by rail in their original containers to Los Angeles. All volume would be unloaded and quality checked in Los Angeles. 18% of the volume would then be kept in Los Angeles for distribution through that warehouse and the rest transhipped by rail to the Kansas City warehouse. The material sent to Kansas City would not need to go through another "unload and quality check process" and would be directly stored to supply the eight remaining warehouses in the US.

3. What should be done based on your analysis of the US distribution system? Should the new Los Angeles distribution centre be added? Is this strategically something that ABC should do? What have they not considered that may be important?

I need the solution and excel for this case study - I need a pre-evaluted answers no need of doing it from the scratch

Verified Expert

The given solution is prepared in MS word document and supporting Ms Excel document. The Case Analysis "Supply chain reconfiguration case of ABC company" is around 6 Pages and more than 1000 words count, Its includes Solution to Practical Problems, Calculations , Summary and other Detailed Analysis. This is verified solution and its answering all the questions mentioned per the requirement of the assignment.

Reference no: EM131048737

Questions Cloud

What was the transmission rate of therouter in mb : We measured a router for a ten minute period. During the measurement interval, the router transmitted atotal of 4800 MB of data and was busy for eight of the ten minutes. What was the transmission rate of therouter in MB
Supply chain for breakfast cereal : Consider the supply chain for breakfast cereal. Discuss the competing objectives of the farmers who make the raw materials, the manufacturing division of the company that makes the cereal, the marketing of the company that makes the cereal,
How many addresses are left : Create 4 subnets for this organisation with the first subblock of 120 addresses, the second subblock of 60 addresses, the third subblock of 30 addresses and the fourth subblock of 12 addresses.
Can anybody give me a snippet or a little guide : I need to calculate the hash of the file that its path is stored in fpath variable.I think it can be done via GetHashCode. Can anybody give me a snippet or a little guide?
Annual cost associated with running the upgraded system : What should be done based on your analysis of the US distribution system? Should the new Los Angeles distribution centre be added? Is this strategically something that ABC should do? What have they not considered that may be important?
Calculate the average number of miles you ran : Calculate the sum of the total miles you spent running over the 10 weeks. Calculate the average number of miles you ran.
Display a square on the screen : Write aprogram class named SquareDisplay that asks the user for a positiveinteger nogreater than 15. Theprogram should then display a square on the screen using thecharacter ‘X'. The number entered by the user will be the length of each side of th..
What evidence indicates that corporate profits will rise : What two factors are important to making the principle of "compounding" work? What evidence indicates that corporate profits will rise?
Difficulties that barilla operating system faces : Would it be effective? If so, which customers would you targetnext? How would you convince them that the JITD program was worth trying? If not, whatalternatives would you suggest to combat some of the difficulties that Barilla's operating system f..

Reviews

Write a Review

 

Accounting Basics Questions & Answers

  Ruby kyleact360nbsp module 3 critical thinkingcomplete the

ruby kyleact360nbsp module 3 critical thinkingcomplete the following exercise. submit journal entries in an excel file

  The two firms fall in the same industry

Can the financial positions of the two firms be compared assuming that the two firms fall in the same industry?

  Wilson company applies overhead based on direct labor cost

wilson company applies overhead based on direct labor cost. during 2014 wilson company estimated that it would incur

  Account titles and explanation

Account Titles and Explanation

  Indicate whether the user would most likely find the

indicate whether the user would most likely find the information by looking at the income statement the balance sheet

  Suppose a firm had an extraordinary loss of 300000 if the

suppose a firm had an extraordinary loss of 300000. if the firms tax rate is 35 how will the loss be shown in the

  What is joses cost basis for the delivery van

What is Jose's cost basis for the delivery van - Jose purchased a delivery van for his business through an online auction. His winning bid for the van was $24,500.

  What are the major provisions of the occupational safety

What are the major provisions of the Occupational Safety and Health Act (OSHA)?

  Identify the variable as quantitative

For each of the following, indicate whether the appropriate variable would be qualitative or quantitative. If you identify the variable as quantitative, indicate whether it would be discrete or continuous.

  How are the features of the income statement balance sheet

how are the features of the income statement balance sheet and statement of cash flow utilized in both the gaap and the

  Calculate the approximate fixed cost component of tanners

tanner inc. has incurred the following overhead costs over a 6 week period week machine hours overhead cost 1 68 1190 2

  Design and implement a job costing system

discuss ways in which the company you researched could best use job costing information to design and implement a job costing system

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd