Question: We have provided the demand data for a product spanning the next 5 0 months. The company aims to choose a supplier to economically source
We have provided the demand data for a product spanning the next months. The company aims to choose a supplier to economically source this product. Make suitable assumptions to use OM techniques discussed in this course to identify a suitable supplier. Please implementprovide all necessary formulascalculations in Excel. Feel free to provide brief justifications and notes. You must upload an Excel file any other file format will be ignored, and the project will not be marked Use your inventory and supply chain skills to rank suppliers in terms of total cost Please mark the cellscolumns properly for better readability. All the calculations must be performed in the Excel sheet.
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
