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


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 assignment solution file contains the answers to all the questions in the assignment file along with relevant discussions. This is supported by relevant calculations in spreadsheet. The theoretical answers have been discussed in considerable detail. Citations and references have been provided wherever appropriate. The assignment has been done in APA format.

Put your comment
View Conversion
  1. user image

    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
Critically discuss how the three major sociological perspectives of functionalism, conflict theory, and interactionism view the role of social institutions in society.
Would you classify Bill Gates as a charismatic or transformational leader? Why? Consider the followers and employees of Gates. What are some unique characterisitcs of Gate's f
I read the Elias paper on liability of trade associations. She hinged it on control. In medical cases, particularly US v. AMA and Wilk V. AMA, which are antitrust cases, the c
Climate of eastern Washington and eastern Oregon are much drier than that of the western parts of the states. How does the geographic factor of topography explain this pattern
Analyze this information with respect to your beliefs about how problems arise and how people change. Explain the affect that person-centered theory has had on your own theo
Define democracy and define reform. What aspects did Populist and Progressive reform movements have in common that reflected those definitions and specify how so in each case.
Some people feel there are simply too many lawsand regulations governing how companies may manage their employees.These people believe everyone would be better off if we let t
Please research the term “Military Industrial Complex”. What does this term mean, who coined the term and when?  How is this concept related to Third World military regimes?