Help with business analytics DUE TONIGHT (11pm EST)

profilerefapa
DataforQuestion2.xlsx

Sheet1

Department Investment/sf Risk as a % of $ invested Minimum sf Maximum sf Expected Profit per sf
Electronics 100 24 8000 30000 13
Furniture 50 12 10000 30000 6
Men's Clothing 30 5 2000 5000 3
Clothing 600 10 2000 42000 30
Jewelry 900 14 1000 11000 21
Books 50 2 1000 7000 1
Appliances 400 3 12000 40000 14
Data for Q2

Sheet2

Sheet3

Sheet4