1. Formulate an LP Model for Each Store. Please include Decision variables, Objective function, and Constraints!

2. Solve it! (on Solver)

3. Which Stores are efficient and which Stores are not efficient?

Please solve it and do all calculation and answers on Excel.

Insert Draw Page Layout Formulas Data Review View Tell me X Calibri (Body) 11 V Wrap Text A A A General $%9 .00 BIU A == Merge & Center .00 .0 J3 X fx 1. Formulate a LP Model for Each Store. Please include Decision variables, Objective function and Constraints! B C D E F G H DATA ENVELOPMENT ANALYSIS 1 2 3 OUTPUT SALES 4 STORE LOCATION EBITDA 5 6 7 INPUT STORE ARE(SQ.FT) #EMPLOYEES 35,523.00 62.00 39,493.00 39,731.00 35,833.00 36,552.00 37,328.00 38,709.00 37,827.00 8 75.00 79.00 77.00 75.00 61.00 79.00 9 10 11 12 66.00 66.00 13 35,631.00 14 39,508.00 63.00 Home Paste 15 16 1 A 2 B 3 C 4 D 5 E 6 F 7 G 8 H 9 K 10 L 47,682,116.00 42,612,114.00 44,187,228.00 30,487,610.00 41,535,542.00 24,497,561.00 43,749,818.00 24,081,113.00 44,711,757.00 32,138,829.00 7,459,291.04 3,880,099.22 4,215,221.34 4,201,924.50 5,182,632.13 3,079,085.88 6,485,312.38 1,820,738.46 6,310,682.23 125,695.97 Share *APO V Delete Format Conditional Format Cell Formatting as Table Styles Sort & Find & Filter Select K L M N 0 P 1. Formulate a LP Model for Each Store. Please include Decision variables, Objective function and Constraints! 2. Solve it! 3. Which Stores are efficient? 4. Which Stores are not efficient? EX Comments K) TON Analyze Data 20 IIX CO Insert