Production Cost Carrying Cost Per 1000 Month Capacity Demand Per 1000 First Month Other Month Jan 16 -- 5?,100 5110 555 Feb 18 -- S7,?DD $110 555 March 20 14 5?,600 5120 555 April 23 20 $1300 $135 555 May 29 26 5?,900 5150 555 June 36 33 5?,400 5155 555 July 28 Aug 10 For instance, 1000 units ofswimwear made in January to meet demand in April would cost $7,100 in production cost plus $220 in carrying costs during February, March, and April {5110 for carrying into February, 555 for carrying into March, and $55 for carrying into April] A. Formulate and LP model for this problem using excel [1 point] B. 1What is the optimal solution? {1 point}