Question: 3) Ellename HW3.01.xlsx United Colors of Benetton uses 10,000 zippers in its products per year. The operations manager of Benetton has identified two potential suppliers

3) Ellename HW3.01.xlsx United Colors of Benetton
3) Ellename HW3.01.xlsx United Colors of Benetton
3) Ellename HW3.01.xlsx United Colors of Benetton uses 10,000 zippers in its products per year. The operations manager of Benetton has identified two potential suppliers for zippersone in China and one in Istanbul. She has the following information about these two suppliers: Supplier in China Local Supplier in Istanbul Unit purchasing price of $4 Unit purchasing price of $5 Fixed ordering cost of $300 Fixed ordering cost of $50 Unit holding cost is $1 per unit per year Unit holding cost is $1 per unit per year a What are the optimal order quantities from the suppliers in China and Istanbul? How many times should Benetton place orders from each supplier over the course of a year? What is the total cost (holding, ordering and purchasing) cost for each supplier? Which supplier should Benetton choose? b. 0. Plot the total costs for each supplier using a line-graph (total costs for each supplier should be in the same chart) for order quantity values between 100 and 5000 in increments of 100 Data Review View Help File Home Insert Page Layout Formulas PROTECTED VIEW Be careful-files from the Internet can contain viruses. Unless you need to edit, it's safer to stay in Prote G11 X fx A B C D E F H stanbul China 4 unit price 5 3 fixed cost 300 50 4 unit holding 1 1 5 123 2 S6700 a 8 9 10 11 12 13 14 15 16 17 18 ~H 8982~ ~~~. 19 20 21 22 23 4227825 26 29 30

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!