Problem 1: Shortest Route with Different Origin and Destination (12 points) A network map is given in the Excel file a) Use the table in the Excel file to find the fastest route from point A to point H. For full credit, you must include the completed table in your answer and show the solved and unsolved nodes considered in each step until you solve for point H. (10 points) b) What nodes do you pass through along the fastest route from A to point H? (2 points) Problem 2: Linear Programming (8 points) A network map is given in the Excel file. Use "A" to denote tons of product moving from Supplier A to Plant 1 a) Show all the supplier constraints (2 points) b) Show all the destination constraints. (2 points) c) Show all the non-negative constraints. d) Show the objective function (be sure to include "minimize 2 points) or "maximize") (2 points) Problem 3: Pareto's Law (10 points) Annual sales data for 50 SKUs stored at the warehouse is given in the Excel file. The company will be launching a website that will sell 10 of these 50 SKUs, but the decision as to which 10 items won't be made until May 15. Unfortunately you nced to let Finance know by February 12 the value of the inventory that will need to be stored to support these web orders, so you will use Pareto's Law to estimate the website sales and inventory The company projects incremental website sales of $750,000 in the first year a) Determine the % of sales (Y value) for the top 30% of b) Given the X and Y from part a, calculate the constant A (2 c)Use a turnover ratio of 10 for the top 20% of SKUs (A items (the X value) 2 points) points) items), a turnover ratio of 6 for the next 300% of SKUs (B items), and turnover ratio of 2 for the remaining SKUs (C items) Assuming the same Pareto's Law relationship between sales and items in the warehouse will hold for the website SKUs, forecast the average inventory value for the wcbsite SKUs, (Hint: create an item forecast for the website SKUs similar to slide 14) (6 points Problem 1: Shortest Route with Different Origin and Destination (12 points) A network map is given in the Excel file a) Use the table in the Excel file to find the fastest route from point A to point H. For full credit, you must include the completed table in your answer and show the solved and unsolved nodes considered in each step until you solve for point H. (10 points) b) What nodes do you pass through along the fastest route from A to point H? (2 points) Problem 2: Linear Programming (8 points) A network map is given in the Excel file. Use "A" to denote tons of product moving from Supplier A to Plant 1 a) Show all the supplier constraints (2 points) b) Show all the destination constraints. (2 points) c) Show all the non-negative constraints. d) Show the objective function (be sure to include "minimize 2 points) or "maximize") (2 points) Problem 3: Pareto's Law (10 points) Annual sales data for 50 SKUs stored at the warehouse is given in the Excel file. The company will be launching a website that will sell 10 of these 50 SKUs, but the decision as to which 10 items won't be made until May 15. Unfortunately you nced to let Finance know by February 12 the value of the inventory that will need to be stored to support these web orders, so you will use Pareto's Law to estimate the website sales and inventory The company projects incremental website sales of $750,000 in the first year a) Determine the % of sales (Y value) for the top 30% of b) Given the X and Y from part a, calculate the constant A (2 c)Use a turnover ratio of 10 for the top 20% of SKUs (A items (the X value) 2 points) points) items), a turnover ratio of 6 for the next 300% of SKUs (B items), and turnover ratio of 2 for the remaining SKUs (C items) Assuming the same Pareto's Law relationship between sales and items in the warehouse will hold for the website SKUs, forecast the average inventory value for the wcbsite SKUs, (Hint: create an item forecast for the website SKUs similar to slide 14) (6 points
