Project to yield an acceptable return on investment

Assignment Help Financial Accounting

Reference no: EM13794854

Smith Corporation produces bucket loader assemblies for the tractor industry. The product has a long-term life expectancy. Smith has decided to implement a JIT inventory system. Smith is deciding whether to use ABC Co. or XYZ Co. as the supplier. The following relevant information is available for analysis:

One time cost to rearrange the shop floor into manufacturing cells is $305,000

Monthly demand is 1,000 units.

Purchase orders from ABC will cost $7.50 each. Purchase orders from XYZ will cost $7.00 each.

ABC will charge $110 per unit. XYZ will charge $100 per unit.

ABC’s units will be inspected at a cost of 30 cents per unit.

Smith’s required annual rate of return is 5%.

Stock-out costs are expected to be $3.50 per unit for ABC and $3.00 per unit for XYZ.

Stock-out units are expected to be 5% of the order quantity for ABC and 5% for XYZ. These stockouts are anticipated to occur during each reorder period.

Other annual carrying costs are 1% of the unit purchase cost for ABC and for XYZ.

Questions:

What is the EOQ if Smith chooses ABC Co.?

What is the EOQ if Smith chooses XYZ Co.?

From a quantitative perspective, which supplier should Jones use to implement the JIT system? Show the computations supporting your decision. Note that your solution should be in professional format, and should include a proper heading, date, consistent formatting, etc.

What is the minimum amount of cost savings (in dollars) that Smith would need to save by implementing the JIT system in order for the project to yield an acceptable return on investment?

Please show answer in Excel format

Reference no: EM13794854

Questions Cloud

Purpose and methodologies process for evaluating : Describe the purpose and methodologies process for evaluating and revising a public policy.

How do we create sympathy and portrayal for curleys wife : How do we create sympathy and portrayal for Curley's wife. Not over 500 words. I want to get all the marks as possible to achieve Band 5 which states.

Analyze the rhetorical strategies of ethos and pathos : Analyze the rhetorical strategies of ethos, pathos, logos in writing samples and for incorporation into essays or presentations.

Write a research proposal that states the claim of project : Write a research proposal that states the claim and scope of the research project. Outline the main sections of the research project.

Project to yield an acceptable return on investment : Smith Corporation produces bucket loader assemblies for the tractor industry. The product has a long-term life expectancy. Smith has decided to implement a JIT inventory system. Smith is deciding whether to use ABC Co. or XYZ Co. as the supplier. The..

Understanding customer wants and needs and pest analysis : Understanding Customer Wants and Needs and PEST Analysis

Problems based on different phases of the moon : Identify and describe in your own words three separate and specific pieces of scientific evidence that support the Big Bang theory?

Not recognize a gain on the sale of the land : Justings Co. owned 60% of Evana Corp. During 2015, Justings sold to Evana land with a book value of $62,000. The selling price was $90,000. In its accounting records, Justings should

What is the purpose of an executive summary : What is the purpose of an executive summary? What are the four guidelines for a letter of transmittal? What are the four guidelines for discussion sections within a formal report?

User Account

All Pages