A solar panel manufacturer uses a specific type of silicon photovoltaic (PV) cell in production. Demand...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
A solar panel manufacturer uses a specific type of silicon photovoltaic (PV) cell in production. Demand for this PV cell has a constant rate of 40 per month. The company should decide among three sourcing options for the PV cell: supplier X, supplier Y, or in-house production. Supplier X offers an all-units discount schedule for its PV cells: It charges $50 for each cell if the order size is less than 500, $45 for each cell if the order size is between 500 and 1000, and $40 for each cell if the order size is greater than or equal to 1000. The order setup cost required by this supplier is $2000. • Supplier Y offers an incremental discount schedule for its PV cells: It charges $50 for each cell if the order size is less than or equal to 300, $40 for each cell purchased beyond 300 if the order size is between 301 and 600, and $30 for each cell purchased beyond 600. The order setup cost required by this supplier is $1000. • For the option of in-house production, it costs $800 to initiate a production run and each cell costs the company $48 to manufacture. The company has the capacity to produce 50 cells per month. The inventory holding costs are based on a 25 percent annual interest rate. (a) (20 points) If the company works with supplier X, what is the optimal order quantity for PV cells? (b) (20 points) If the company works with supplier Y, what is the optimal order quantity for PV cells? (c) (15 points) If the company prefers in-house production, what is the optimal size of each production run for PV cells? (d) (15 points) Calculate the optimal total annual cost for each option. Which option should the company choose? (e) (30 points) Suppose that the manufacturer does not want to keep any PV cell in inventory for more than 1.5 years. Answer the questions (a)-(d) in this case. Which option should the company choose in this case? A solar panel manufacturer uses a specific type of silicon photovoltaic (PV) cell in production. Demand for this PV cell has a constant rate of 40 per month. The company should decide among three sourcing options for the PV cell: supplier X, supplier Y, or in-house production. Supplier X offers an all-units discount schedule for its PV cells: It charges $50 for each cell if the order size is less than 500, $45 for each cell if the order size is between 500 and 1000, and $40 for each cell if the order size is greater than or equal to 1000. The order setup cost required by this supplier is $2000. • Supplier Y offers an incremental discount schedule for its PV cells: It charges $50 for each cell if the order size is less than or equal to 300, $40 for each cell purchased beyond 300 if the order size is between 301 and 600, and $30 for each cell purchased beyond 600. The order setup cost required by this supplier is $1000. • For the option of in-house production, it costs $800 to initiate a production run and each cell costs the company $48 to manufacture. The company has the capacity to produce 50 cells per month. The inventory holding costs are based on a 25 percent annual interest rate. (a) (20 points) If the company works with supplier X, what is the optimal order quantity for PV cells? (b) (20 points) If the company works with supplier Y, what is the optimal order quantity for PV cells? (c) (15 points) If the company prefers in-house production, what is the optimal size of each production run for PV cells? (d) (15 points) Calculate the optimal total annual cost for each option. Which option should the company choose? (e) (30 points) Suppose that the manufacturer does not want to keep any PV cell in inventory for more than 1.5 years. Answer the questions (a)-(d) in this case. Which option should the company choose in this case?
Expert Answer:
Answer rating: 100% (QA)
a To find the optimal order quantity for PV cells when working with supplier X we need to find the point where the marginal cost of ordering from supp... View the full answer
Related Book For
Principles Of Heat Transfer
ISBN: 9781305387102
8th Edition
Authors: Frank Kreith, Raj M. Manglik, Mark S. Bohn
Posted Date:
Students also viewed these general management questions
-
The money manager of a R4 000 000 investment fund. The fund consists of four shares with the following investments and betas: Share Investment Beta Class A share R400 000 1.50 Class B share R600 000...
-
Lenovo needs to procure six-core processors for the manufacture of its laptops. The company requires these processors at a fairly flat rate of 100 per month. They have to decide between three...
-
Managing Scope Changes Case Study Scope changes on a project can occur regardless of how well the project is planned or executed. Scope changes can be the result of something that was omitted during...
-
You have recently been hired as a consultant for a personal financial planning firm. One of your first projects is creating a retirement plan for a couple, Tom and Helena Keeley. They have just...
-
A friend of your family, Nancy Chen, has just graduated from dental school and is opening up her new practice. To do this, she has formed a corporation called Chen Dental Services Ltd. Revenues from...
-
Kang Ltd., a manufacturer of ballet shoes, is experiencing a period of sustained growth. In an effort to expand its production capacity to meet the increased demand for its product, the company...
-
The Peoples National Bank raised capital through the sale of \(\$ 100\) million face value of four percent coupon rate, ten-year bonds. The bonds paid interest semiannually and were sold at a time...
-
Use the following data, compute 1. Cost of goods manufactured for both Garcia Company and Culpepper Company. (Omit the "$" sign in your response.) 2. Cost of goods sold for both Garcia Company and...
-
explain IAS 24 and ASC Topic 850, both titled Related Party Disclosures, have similar objectives and requirements for related party disclosures. Principally, both U.S. GAAP and IFRS require...
-
Diana acquires, for $65,000, and places in service a 5-year class asset on December 19, 2022. It is the only asset that Diana acquires during 2022. Diana does not elect immediate expensing under ...
-
You have read "The Lottery" by Jackson and "A Good Man is Hard to Find" by O'Connor. Now it is time to argue who does conflict better. In at least two well-structure paragraphs, please respond to the...
-
Define a cycle in a network. Describe a cycle assuming a fully connected network with nodes numbered 1,2,3,4,5, and 6.
-
Why would we use agent- based models in stead of analytic models?
-
Can emergence be observed at the level of an SoS? Why or why not?
-
What is the ultimate goal of ABM ? Explain what is gained from this ultimate goal.
-
Explain the phenomenon of emergence in SoS . Why is this property impor-tant?
-
The HIM manager recently performed an audit of the integrity of the master patient index. Her audit revealed of 200 patient records reviewed, 5% of those patients had a duplicate record created....
-
Proposals have been made to ?sail? spacecraft to the outer solar system using the pressure of sunlight, or even to propel interstellar spacecraft with high-powered, Earth-based lasers. Sailing...
-
Recent studies have shown that the supply of crude oil from Alaska's North Slope will soon decline to sub-economic levels and that production will then cease. Alternatives are under consideration...
-
A 15-cm-OD pipe is buried with its centerline 1.25 m below the surface of the ground (k of soil is 0.35 W/(m K)). An oil having a density of 800 kg/m 3 and a specific heat of 2.1 kJ/(kg K) flows in...
-
Evaluate the Prandtl number from the following data: c p = 2.1 kJ/kg K, k = 3.4 W/m K, = 0.45 kg/m s.
-
The Washington Company owns no plant assets and had the following income statement for the year: Additional information about the company includes: Use the preceding information to calculate the cash...
-
The Azuza Company owns no plant assets and had the following income statement for the year: Additional information about the company includes: Use the preceding information to calculate the cash flow...
-
Use the following information regarding the Hamilton Corporation to prepare a statement of cash flows using the indirect method: Accounts payable decrease. Accounts receivable increase. Wages payable...
Study smarter with the SolutionInn App