1. The goal is to sell all inventory in 36 weeks and the objective is to maximize your profit margins.

Developing a Decision Support System for a Major Retail Company Your Role: You are a Data Analyst for a major Clothing Retailer. Your tasks are to analyze data for the different styles, work on pricing and cost analysis, develop promotion plans for finding suppliers and report back to the Chief Marketing Officer. Data for the problem: For simplicity we have reduced the number of styles you will consider. Every style has a cost and an initial price. Here are all the data Data from Table 1 style: This is specific style - product cost: cost for one unit price: Initial Price margin: Initial Margin 100* (Price-cost)/price day: The day that the style/product was introduced in the stores CurrentW_1: The first week for which we have data Week_1: How many weeks have passed for the first week of data we have collected style cost/unit price margin date Currentw_1 Week_1 99999 100000 100001 100002 100003 100004 100006 100007 100010 7.95 26.41 7.95 26.41 6.50 27.66 6.50 27.66 6.00 27.65 6.00 27.65 7.85 27.64 7.85 27.64 8.00 26.40 69.9 69.9 76.5 76.5 78.3 78.3 71.6 71.6 69.7 13-Nov 13-Nov 13-Nov 13-Nov 13-Nov 13-Nov 13-Nov 13-Nov 13-Nov 3/29/2015 3/29/2015 3/29/2015 3/29/2015 3/29/2015 3/29/2015 3/29/2015 3/29/2015 3/29/2015 19.4286 19.4286 19.4286 19.4286 19.4286 19.4286 19.4286 19.4286 19.4286 Table 1 Margin2: The margin of the units sold 100*(Revenue2-Cost2)/Revenue2 Cost2: The cost of the units sold so far Cum. Revenue2: The revenue from the units sold Your Task 1. The goal is to sell all inventory in 36 weeks and the objective is to maximize your profit margins. style Cumulative Revenuet 417 99999 100000 100001 100002 100003 100004 100006 100007 100010 Cost1 of SOLD1 Inventory1 Margin 1 units sold 407 1521 56.23235.7 1055 57.53315.2 705 654 70.64582.5 831 554 71.25401.5 796 1024 72.7 4778 687 820 73 4122 638 1244 63.3 5008.3 670 858 84.1 5259.5 875 850 44.1 7000 7387.3 7800.4 15587 18755 17495 15267 13647 14650 12522 Table 2 Data from Table 2 SOLD1: Units that we sold from November 13 to the current week (3/29/2015) Inventory1: Our current inventory 3/29/2015 Margin1: The margin obtained from the units sold 100* (Revenue 1-Cost1/Revenuel Cost1: The cost of the units sold Cum. Revenuel: The revenue from the units sold style Sales2 Cumulative Inventory2 in Sold2 end end of week of week week Cost2 Margin2 end of week Cumulative Revenue2 end of week 477 70 54 35 99999 100000 100001 100002 100003 100004 100006 100007 100010 471 740 881 855 1451 999 614 520 963 30 59 54.4 | 3792.2 56.13744.5 70.3 4810 715596.5 72.2 5130 72.4 4446 62.5 5408.7 63.35659.9 43.1 7384 8316.1 8529.5 18195 19298 18453 16109 14423 54 51 741 689 721 766 1187 804 794 51 48 15422 12977 923 Table 3 Data from Table 3 Cum. Sales2: Sales of units from 3/29/2015 to 4/4/2015 Cum. Sold2: Units that we sold from November 13 to the current week (4/5/2015) Inventory2: Our current inventory 4/5/2015 Developing a Decision Support System for a Major Retail Company Your Role: You are a Data Analyst for a major Clothing Retailer. Your tasks are to analyze data for the different styles, work on pricing and cost analysis, develop promotion plans for finding suppliers and report back to the Chief Marketing Officer. Data for the problem: For simplicity we have reduced the number of styles you will consider. Every style has a cost and an initial price. Here are all the data Data from Table 1 style: This is specific style - product cost: cost for one unit price: Initial Price margin: Initial Margin 100* (Price-cost)/price day: The day that the style/product was introduced in the stores CurrentW_1: The first week for which we have data Week_1: How many weeks have passed for the first week of data we have collected style cost/unit price margin date Currentw_1 Week_1 99999 100000 100001 100002 100003 100004 100006 100007 100010 7.95 26.41 7.95 26.41 6.50 27.66 6.50 27.66 6.00 27.65 6.00 27.65 7.85 27.64 7.85 27.64 8.00 26.40 69.9 69.9 76.5 76.5 78.3 78.3 71.6 71.6 69.7 13-Nov 13-Nov 13-Nov 13-Nov 13-Nov 13-Nov 13-Nov 13-Nov 13-Nov 3/29/2015 3/29/2015 3/29/2015 3/29/2015 3/29/2015 3/29/2015 3/29/2015 3/29/2015 3/29/2015 19.4286 19.4286 19.4286 19.4286 19.4286 19.4286 19.4286 19.4286 19.4286 Table 1 Margin2: The margin of the units sold 100*(Revenue2-Cost2)/Revenue2 Cost2: The cost of the units sold so far Cum. Revenue2: The revenue from the units sold Your Task 1. The goal is to sell all inventory in 36 weeks and the objective is to maximize your profit margins. style Cumulative Revenuet 417 99999 100000 100001 100002 100003 100004 100006 100007 100010 Cost1 of SOLD1 Inventory1 Margin 1 units sold 407 1521 56.23235.7 1055 57.53315.2 705 654 70.64582.5 831 554 71.25401.5 796 1024 72.7 4778 687 820 73 4122 638 1244 63.3 5008.3 670 858 84.1 5259.5 875 850 44.1 7000 7387.3 7800.4 15587 18755 17495 15267 13647 14650 12522 Table 2 Data from Table 2 SOLD1: Units that we sold from November 13 to the current week (3/29/2015) Inventory1: Our current inventory 3/29/2015 Margin1: The margin obtained from the units sold 100* (Revenue 1-Cost1/Revenuel Cost1: The cost of the units sold Cum. Revenuel: The revenue from the units sold style Sales2 Cumulative Inventory2 in Sold2 end end of week of week week Cost2 Margin2 end of week Cumulative Revenue2 end of week 477 70 54 35 99999 100000 100001 100002 100003 100004 100006 100007 100010 471 740 881 855 1451 999 614 520 963 30 59 54.4 | 3792.2 56.13744.5 70.3 4810 715596.5 72.2 5130 72.4 4446 62.5 5408.7 63.35659.9 43.1 7384 8316.1 8529.5 18195 19298 18453 16109 14423 54 51 741 689 721 766 1187 804 794 51 48 15422 12977 923 Table 3 Data from Table 3 Cum. Sales2: Sales of units from 3/29/2015 to 4/4/2015 Cum. Sold2: Units that we sold from November 13 to the current week (4/5/2015) Inventory2: Our current inventory 4/5/2015