Analyse the effect on inventory

Assignment Help Other Subject
Reference no: EM132017996

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

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.

Reference no: EM132017996

Questions Cloud

Analyzing social problems and social policy : An explanation of the theories that support the problem and approaches scholars and policy analysts use to address the problem.
How has the family changed as a social form : How has the family changed as a social form? What is the value of using sociology to understand the changing nature of the family?
Estimate of the highest price consumers : How would you reply to the Mieke's request for information and Should the service be marketed - estimate of the highest price consumers are willing to pay
The great variety of careers and occupations : A review of some of the data bases in the text will provide opportunities to search and identify many occupational areas within different governmental.
Analyse the effect on inventory : LSC802 - Trade-off Analysis - Analyse the effect on inventory against the cost of transport; and derive and analyse the trade-off between transportation cost
Discuss about the discrimination and prejudice : Compare and contrast each term: discrimination, prejudice, racism, institutional racism, and stereotyping.
Identify various forms of institutional racism : Differentiate between prejudice, discrimination, and stereotyping Analyze the concepts of White privilege and colorblind racism.
Describe sexually transmitted infections : Describe sexually transmitted infections, and discuss the implications of providing students with condoms.
Describe what changes you would make to the policy : Brief explanation of the event you selected that led to the formation of a social policy. Then, explain what changes you would make to the policy.

Reviews

inf2017996

8/4/2018 3:26:51 AM

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

inf2017996

8/4/2018 3:26:01 AM

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

len2017996

6/13/2018 6:49:09 AM

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.

Write a Review

Other Subject Questions & Answers

  Relationship between person-centered and adlerian therapy

Is the relationship between Person-Centered therapy and Adlerian therapy?

  What is your current or future career path

What is your current or future career path and how might statistics play a role in that career? Your response should contain details and examples.

  Describe the ethical issues related to cultural competence

Examine the influence of your own personal values as related to the diversity issues presented in this case. Reflect on how you felt as you read the case study, how your values came into play, and how you would handle your values in a situation su..

  What is the definition of flashbulb memory

What is the definition of Flashbulb memory and an example

  What determines the toxicity of a chemical

What determines the toxicity of a chemical? To what extent do you agree with assumption that "all substances are poisons"? What is human exposure assessment?

  Explain how the theory could be applied in the real world

Using the constructionist approach dealing with deviance, explain how the theory could be applied in the real world today, use a an example of an action that would be considered deviant in our society and explain it using chosen theory.

  Determine whether or not types of benefits would motivate

Determine whether or not these types of benefits would motivate you as an employee for a long-term commitment. Support your reasoning.

  Test-retest reliability with inter-rater reliability

What components differentiate experiments from the non-experimental methods discussed in Modules 2 and 3? How do experiments do a better job of assessing causality? test-retest reliability with inter-rater reliability. Internal validity with extern..

  Different types of materials exhibit at failure

What clues would you look for to help you determine if the failure occurred inflight or as a result of crash forces? What would the different types of materials exhibit at failure?

  What kinds of effects does addiction have on communities

Imagine you work in a community substance abuse treatment facility, and see the effects of addiction on individuals and families daily. What kinds of effects does addiction have on communities

  Explain the history of fingerprint analysis

At the conclusion of each laboratory project, a written report will be required. This is your opportunity to tell the instructor what you have learned from the weekly content by focusing on the criteria listed above. Reports should display critica..

  How forensic psychologists used in civil legal matters

Discuss how forensic psychologists can be used in civil legal matters. Also discuss the various civil cases in which psychologists can participate, including child custody.

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