Ask Question, Ask an Expert

+61-413 786 465

info@mywordsolution.com

Ask Corporate Finance Expert

Project

Randy Smith, Inventory Control Manager. Randy Smith was very proud of his new position as inventory control manager for the Johnson Trinket Company. His primary responsibility had been fairly clearly defined:

Maintain an inventory level in the warehouse that ensures that production will not run out of stock, yet also maintain an inventory level that will minimize inventory holding and control costs. Since Randy had recently had a course in materials management, he knew an approach that should help him. He decided to make a list of inventory items in one small section of the warehouse to see if he could develop a good plan for inventory control. If it worked in the one small section, he could expand it to the rest of the more than 30,000 part numbers in the warehouse.

The following is the data Randy compiled:

Part Number

Part unit value in $

Quantity currently in inventory

Average annual usage

1234

$2.50

300

3000

1235

$0.20

550

900

1236

$15.00

400

1000

1237

$0.75

50

7900

1238

$0.76

180

2800

1239

$4.40

20

5000

1240

$1.80

200

1800

1241

$0.05

10

1200

1242

$17.20

950

2000

1243

$9.00

160

2500

1244

$3.20

430

7000

1245

$0.30

500

10000

1246

$1.10

25

7500

1247

$8.10

60

2100

1248

$5.00

390

4000

1249

$0.90

830

6500

1250

$6.00

700

3100

1251

$2.20

80

6000

1252

$1.20

480

4500

1253

$5.90

230

900

When Randy scanned the list, he noticed several things that disturbed him, and he asked one of the experienced inventory clerks. The following list summarizes the part number issues that concerned Randy, and the explanation from the clerk:

Part number 1236, a very expensive part with almost half-a-year's worth of inventory.

This part is used for a product that has very cyclical demand, and the busy time of the year is about to start.

Part number 1241 is very inexpensive, yet the inventory is very small. This part has a supplier with an erratic delivery history, and the part also has a very long lead time. A lot of 150 has been on order for some time, and is now several days past due.

Part number 1242, like 1236, is expensive with almost half a year worth of inventory- this part is shipped to a location on the other side of the country and is being accumulated into a large lot to save shipping costs.

Part number 1246 is not too expensive, with a low inventory. This part is produced in-house, and has a quality tolerance that the older equipment, which was used to produce it, had a difficult time meeting. The last batch was rejected by the quality department.

Part number 1253 is moderately expensive with a large inventory compared to usage.

This part was subject to a recent quality audit, and almost 150 of the items were rejected as a result of that audit.

Once Randy understood some of the issues, suddenly he did not feel quite as confident that he had the best approach in mind to control the inventory to meet the expectations of his boss.

Assignment

(1). The information above to evaluate the current situation.

(2). Given your evaluation, try to develop an integrated inventory control policy that Randy should consider.

(3). Is there other information that you would like to see that might help you to make a more effective policy?

(4). If so, what would that information be and how would you use it to help you?

Instructions:

1) The research findings should be handed in before April 8th as a Word document using a font of 12 and spacing =1.5. 

2) Personalize the style of your text. Imagine you are generating a report to inform the audience it is addressed to or to answer the requirement of your manager.

3) Be clear and organized in your presentation of the text: use bullet points, tables and brief texts to convey your message.

4) The assignment will count for 20% of your final mark.

7) Plagiarism could lead to obtaining a mark of zero on the project.

8) Both of electronic and printed versions should be sent to me before the deadline.

Corporate Finance, Finance

  • Category:- Corporate Finance
  • Reference No.:- M91752549

Have any Question?


Related Questions in Corporate Finance

Business finance case study assignment -instructions - you

BUSINESS FINANCE CASE STUDY ASSIGNMENT - Instructions - You must do Questions 1-5a, 8 and 10 on a spreadsheet. Eternal Youth Ltd (EY) is a New Zealand company which produces and sells cosmetics. Its financial year is 1 J ...

Investment management assignment -in this assignment you

Investment Management Assignment - In this assignment you will be computing bond prices, modified durations and holding period returns. You will also implementing a hedging strategy for a stream of liabilities. Data Desc ...

Assignment -topic - recent years have seen rapid

Assignment - Topic - Recent years have seen rapid development in Australia's housing market. The effect of high housing prices on Australian families is enormous. Despite those challenges, you would like to buy 3-bedroom ...

Question - discuss the relationship between external

Question - Discuss the relationship between external financing and growth of a firm. Including a discussion of how financial policy of a firm should encompass policy addressing the firm's internal growth rate, sustainabl ...

Financial modelling assignment -1 today is 1 january 2018

Financial Modelling Assignment - 1. Today is 1 January 2018. Jackson who is aged 80 has a portfolio which consists of three different types of financial instruments (henceforth referred to as instrument A, instrument B a ...

Question - develop a forecast model for sales through

Question - Develop a forecast model for sales through operating income. Create the forecast in Excel. In a Word document, describe the set of assumptions (ratios) you used, and explain how you justify them. Attachment:- ...

Questions -q1 fv of ordinary annuity what is the future

Questions - Q1: (FV of Ordinary Annuity) What is the future value of a $50 annuity payment over 20 years if the interest rates are 6%? Q2: (PV of Ordinary Annuity) What is the present value of above annuity? Q3: (FV and ...

Mini case assignment -problems - use internet to identify a

Mini Case Assignment - Problems - Use internet to identify a house or condo that you may be interested in investing as a rental property for 10+ years. (Suggested price range between $250k - $1 million) 1. Estimate the a ...

Assignment -task requirements you have been randomly

Assignment - Task requirements: You have been randomly assigned an Australian publicly listed company (refer to the separate excel spreadsheet provided to identify your company). Using the financial reports for your comp ...

Assignment -part a - saturn petcare australia and new

Assignment - Part A - Saturn Petcare Australia and New Zealand is Australia's largest manufacturer of pet care products. Saturn have been part of the Australian and New Zealand pet care landscape since opening their firs ...

  • 4,153,160 Questions Asked
  • 13,132 Experts
  • 2,558,936 Questions Answered

Ask Experts for help!!

Looking for Assignment Help?

Start excelling in your Courses, Get help with Assignment

Write us your full requirement for evaluation and you will receive response within 20 minutes turnaround time.

Ask Now Help with Problems, Get a Best Answer

Why might a bank avoid the use of interest rate swaps even

Why might a bank avoid the use of interest rate swaps, even when the institution is exposed to significant interest rate

Describe the difference between zero coupon bonds and

Describe the difference between zero coupon bonds and coupon bonds. Under what conditions will a coupon bond sell at a p

Compute the present value of an annuity of 880 per year

Compute the present value of an annuity of $ 880 per year for 16 years, given a discount rate of 6 percent per annum. As

Compute the present value of an 1150 payment made in ten

Compute the present value of an $1,150 payment made in ten years when the discount rate is 12 percent. (Do not round int

Compute the present value of an annuity of 699 per year

Compute the present value of an annuity of $ 699 per year for 19 years, given a discount rate of 6 percent per annum. As