Reference no: EM13971563
1. Your company manufactures bowling balls in Akron, Ohio. The primary raw material is polyurethane that you order from suppliers. The cost to place each order is $250. The price of the material is $4000 per ton delivered to your plant regardless of lot size. Annual demand for polyurethane at your plant is 76,000 tons. Your company uses 4.5% to calculate its annual cost of carrying materials in inventory. What is the optimal lot size in order to minimize the sum of annual ordering costs and inventory carrying costs of polyurethane? What is the total annual cost based on your optimal lot size?
If you supplier offered you a 10% price reduction per order for minimum orders over 500 tons, would you continue to use your optimal lot size or order at least the minimum? Support your decision with calculations.
Please show and explain calculations in excel
2. Given the following historical data on two alternative suppliers of a critical material your company requires, which of the two suppliers (supplier 1 or supplier 2) will minimize your required safety stock? Show and describe your analysis!
Base your analysis on the supplied data and assume "all else is equal" between the two suppliers. In other words, cost per unit, quality, TCO, etc. do not need to be considered. Do not concern yourself with any other issues or data other than that which is given below.
For any given period, your company's goal is to have required materials available in inventory 99.9% of the time.
Your mean requirement (demand) per day: 700 units.
Standard deviation of your daily requirement: 65 units.
Supplier 1
Mean lead-time: 7 days
Standard deviation of lead-time: 1 day
Supplier 2
Mean lead-time: 5 days
Standard deviation of lead-time: 2 days
|
What could nestlé have done better in implementing sap
: The primary lesson that Dunn says she gained from this project is "No major software implementation is really about the software. It"s about change management." Do you agree with her statement?
|
|
What are common sources of funding available to entrepreneur
: Write a 525- to 700-word paper (total) that addresses the following subjects. What are the common sources of funding available to the entrepreneurs?
|
|
Standard deviation of returns
: A stock had returns of 6 percent, -4 percent, 4 percent, and 16 percent over the past four years. What is the standard deviation of these returns?
|
|
Determine best funding alternative for ockham technologies
: Determine the best funding alternative for Ockham Technologies and how it will affect the formation of the Board of Directors.
|
|
What is the total annual cost based on your optimal lot size
: What is the optimal lot size in order to minimize the sum of annual ordering costs and inventory carrying costs of polyurethane? What is the total annual cost based on your optimal lot size?
|
|
Describe and critique all data displays in this article
: What descriptive statistics were used? List all and briefly describe.
|
|
Diamond model with logarithmic utility
: In the case of logarithmic utility, Cobb-Douglas production, and delta=1, what is the equation for kt+1 as a function of kt? Comment on whether you find this surprising.
|
|
The paper on conflict and poverty in a world where boundarie
: The paper on Conflict and Poverty in a world where boundaries and borders have blurred, and where seemingly distant threats can metastasize into immediate problems, the fight against global poverty has become a fight for global security.
|
|
Substantive tests for plant assets
: Pierce, an independent auditor, was engaged to audit the financial statements of Mayfair Construction Incorporated for the year ended December 31, 20X3.
|