Table 2 (a): Problem 2 Data, Part 1 Investment Per Department Square Foot ($) Electronics Furniture Men's Clothing Clothing Jewelry Books Appliances...

A department store chain is planning to open a new store. It needs to decide how to allocate the 100,000 square feet of available floor space among seven departments. Data on expected performance of each department per month, in terms of square feet, is summarized in the tables Problem 2 Data, Parts a and b found in the Excel spreadsheet Midterm data posted with this exam.The company has gathered $20 million to invest in floor stock. The risk column is a measure of risk associated with investment in floor stock based on past data from other stores and accounts for outdated inventory, pilferage, breakage and so on. For instance, electronics loses $24 for every $100 invested. Profit is calculated after covering risk.Develop a linear programming model to maximize profit and find the optimal solution