met ad 680 supply chain management problem set 3
Problem Set #3: Optimization
Create a spreadsheet that determines, for each manufacturing location, the expected profits and how many units the vendor should order from each manufacturer. Assume that demand variation is normally distributed. Vary the annual holding cost percentage and show how the expected profits and order quantities for a range of holding rates from 10% to 40%. Show these results in tabular and graphical form. Clearly organize and label the spreadsheet to show inputs and results (i.e., a user may wish to modify inputs later as more information becomes available).
Do you need a similar assignment done for you from scratch? We have qualified writers to help you. We assure you an A+ quality paper that is free from plagiarism. Order now for an Amazing Discount!Use Discount Code “Newclient” for a 15% Discount!NB: We do not resell papers. Upon ordering, we do an original paper exclusively for you.