+1-415-670-9189
info@expertsmind.com
Analyse the effect on inventory
Course:- Other Subject
Reference No.:- EM132017996




Assignment Help
Expertsmind Rated 4.9 / 5 based on 47215 reviews.
Review Site
Assignment Help >> Other Subject

Trade-off Analysis

In this assessment you are presented with two fictitious scenarios and, depending upon the scenario, you will use a spreadsheet approach to derive an optimal transportation mode; analyse the effect on inventory against the cost of transport; and derive and analyse the trade-off between transportation cost and customer service level. Finally, you will consider and evaluate innovative options to mitigate these trade-off decisions. Both scenarios are to be addressed and all questions answered.

Scenario A

The Dunedin-based CrockShop Crockery Company produces a line of crockery goods for the New Zealand market. The typical distribution plan is to produce finished goods inventories to be kept at the plant site. Goods are then shipped to company-owned field warehouses by way of common carriers. Rail is currently used to ship between the Dunedin plant and the Auckland warehouse. The average transit time for rail shipments, T, is 21 days. Letting Q = shipment size, at each stocking point (plant and warehouse) there is an average, Q/2, of 50,000 unit sets of crockery having an average cost, C, at $30 per unit. Inventory carrying cost, I, is 30 percent of unit cost per year.

The company wants to select the mode of transportation that will minimise the total costs. It is estimated that for every day that transit time can be reduced from the current 21 days, average inventory levels can be reduced by 2 percent. The demand, D, is 300,000 sets sold per year out of the Auckland warehouse. The company can use the following transportation services:

TOFC stands for ‘trailer on flat car', i.e. a truck trailer piggybacking on a rail flat car.

The four factors to be considered are transport costs, plant inventory, in-transit inventory, and warehouse inventory. Hint, use the following formulae:
- Transportation cost = RD;
- Plant inventory cost = ICQ/2, where Q/2 = 50,000 units for rail, as provided above;
- In-transit inventory cost = ICTD/365; and
- Auckland warehouse inventory cost = IC'Q/2, where C' = C + R, i.e. the product value at the warehouse).

Scenario A

Assumptions

1. Assume there is no intention by the company to invest in transportation equipment, so there is no need to consider the cost of investing in trucks, aircraft, rail cars, or ships. The Crockshop Crockery Company uses third party carriers only;

2. For all inventory cost estimates you should assume that the demand rate is constant and deterministic; and

3. Assume production occurs instantaneously at the plant, i.e. there is no need for safety or buffer stock.

Scenario B

Merino Bales Ltd is a bulk wool wholesaler to the clothing producer market in New Zealand. All orders are shipped via truck to customers using a third party carrier. The carrier charges an administration fee of $100 per order. LTL* shipments are charged 0.03W, as a variable cost, where W is the number of kilograms of wool shipped on the truck, but this cost is limited to a maximum of $450 per truck. A TL (20,000 kg) shipment is charged a discounted set price of $450. Truck charges are additional to the administration fee.

* LTL = less than (full) load. TL = (full) truck load.

Currently Merino Bales ships orders on the day they are received, which results in two days in transit. This policy allows Merino Bales to achieve a response time of two days. Merino is aware that combining orders across time can result in lower transportation cost because it results in larger shipments and reduces variation in shipment sizes. Therefore, Merino wants to know what the cost advantage might be if the response time is increased to three or four days. To determine this, demands (kg) over a two-week period have been taken as follows:

Assignment details are on the next page.

Your Assignment

You are to answer the questions below.

Scenario A

1. Calculate the annual transport cost for each service, Dunedin to Auckland;

2. Calculate the costs of inventory at the plant, in transit, and at the Auckland warehouse for each service;

3. Determine the total cost of each service. Which service delivers the minimum total cost to the company?

Scenario B

4. Determine the total cost of a two-day, three-day, and four-day response using the demand figures provided. Explain which option appears to achieve the best balance of cost and customer responsiveness.

5. How would you determine whether an increase in delivery lead time would be acceptable to customers?

6. Based on what you know now, how would you ‘sell' the new delivery service level to customers?
General Question

7. What other innovations and/or methods would you recommend as viable ways to mitigate these trade-off decisions?
The total submission should comprise 1200 words (+/-10%, not including calculations, appendices, citations and references), noting that there is considerable work in accurately determining costs. Upload your spreadsheet file in addition to your written submission.

You must make reference to any models, frameworks, concepts, and terminology that you have encountered in class, in your textbook, or sourced elsewhere. Any assumptions you make are to be stated as such and you are to explain why you consider them to be realistic assumptions.

APA referencing guidelines are to be followed and evidence of wide reading is expected for an assignment at this level.

Attachment:- Assignment.rar

Answered:-

Verified Expert

The attached file contains the solution to the assignment. The topic supply chain management has been discussed in considerable detail. Citations and references have been provided wherever appropriate. The design of the supply chain has been fully dealt with.



Put your comment
 
View Conversion
Minimize
  1. user image
    inf2017996

    Thanks you so much, really satisfied with the content, just moving around rather focus on answering the real problem.. Focused answers what is being asked. I am really satisfied as you paid attention about requirements.. Word count is followed for every question. You did follow the mentioned reference style as well. Thanks a lot

  2. user image
    inf2017996

    1. TMS selection and SC Visibility 2 Sustainability and Waste (CO2) Emission Both above mention points, please assign word limit balance between topics. all are equally important. I need both risks & its mitigation Please write in a paragraph I have a previous assignment has done this month only, which has spreadsheet calculation attached to it. I have an extension to that assignment of 3600 words with the due date is 1st. can I get the same expert? He/She has the idea about previous work. so, it will be easy to write. There was 2 assignment that time so please check I wish the same expert who did the transport cost assignment where Excel sheet calculation was used. I fu can manage to share the cost, I will pay after few hours

  3. user image
    len2017996

    Please find the attached file. And inform expert the apart from the 7 questions, the basic format of a report writing will be applied like the intro, main part, conclusion, and references in APA style. The spreadsheet is numerical solved by me. which has 7 questions out of which 4 are numerical which I solved already the rest three is theory answers based on numerical results. The total word limit is 1200 including numerical.



Ask Question & Get Answers from Experts
Browse some more (Other Subject) Materials
Analyze the ways in which the U.S. government regulates product safety and make at least one recommendation for how the regulatory approach of one of the agencies discussed (F
A common problem in the Sahel region of Africa is that boundaries drawn by the British and the French do not correspond to the peoples and tribes in the area.
Identify two research projects outlined in the article by Davis, Gross, and Clancy (2012) that contribute to the quality of care. Evaluate how these two health services rese
Give an example of a situation in which a first impression led you to make a correct attribution and one in which the attribution you made from a first impression was wrong.
How will the strategioc, alliares react to the collapse of Hanjin Shipping - What courses of action do you recommend for the bigger shipping companies in terms of further inv
Post 250 word response to the following: Describe the consequences of the French and Indian War. Discuss the means and the consequences of the British decision to have colonis
You are sitting with your friends, talking about the latest movie you and your friends just saw. One of your friends mentions that theaters use subliminal messages while sho
Freud's Psychoanalytic theory is one of the most controversial in Psychology. Many people tend to react strongly, either positively or negatively, to his theory. What is your