bation 1+ cet Xil = number of emponesta produced in Pant 1 and ivepled to Souce A x32= eumeber af cempotesis prutuced in mart f and susplied to 5 bore b x23= nu ber ef companens srobuced in Mant 2 end aucples to stote A x3y= rumber af componenti proeuced in hant 2 and tusples te spore A Xii = number of components prokeced in fart 1 and wuspled to foure A. Xyy = rumler of conpooenti erodiced in Flant 3 and tuppoed 10 suere f Xin = Ramber of compenents produced in Fant 3 and auppled to sbere C Miford Lumber Company ships construction materials from three wood-peocessing plants to three retail stores. The shipping cost, monthly production capacies, belor. Formulate a tinear optimization model for this problem, implement your mooe on a spredsheet, and use Excel Solver to find a solution that minimizes total distrit -1. Let X11= number of components preduced in Plant 1 and supplied to Store A x12= number of components produced in Pant 1 and supplied to Stere B X13= number of components produced in Plant 1 and supplied to store C X21= number of components produced in Plant 2 and supplled to Store A X22= number of components produced in plant 2 and supplied to Store 8 X73= number of components produced in Plant 2 and supplied to Store C X21 = number of components produced in Plant 3 and supplied to store A X32 n number of componerts produced in Plant 3 and supplied to store B X3y= number of components produced in Plant 3 and supplied to Szore C. xn t number of comptrents preduced in plant 2 and supplied to Stere B x3= number of components preduced in Plant 2 and subplled to 5 tere C x31= furmber of componenks preduced in Pant 3 and supplied to Store A x32 = number of eemponeies produced in Flant 3 and supplitd ts Store B X is n number of comigonente produced in Plant 3 and suppled to stoen C bation 1+ cet Xil = number of emponesta produced in Pant 1 and ivepled to Souce A x32= eumeber af cempotesis prutuced in mart f and susplied to 5 bore b x23= nu ber ef companens srobuced in Mant 2 end aucples to stote A x3y= rumber af componenti proeuced in hant 2 and tusples te spore A Xii = number of components prokeced in fart 1 and wuspled to foure A. Xyy = rumler of conpooenti erodiced in Flant 3 and tuppoed 10 suere f Xin = Ramber of compenents produced in Fant 3 and auppled to sbere C Miford Lumber Company ships construction materials from three wood-peocessing plants to three retail stores. The shipping cost, monthly production capacies, belor. Formulate a tinear optimization model for this problem, implement your mooe on a spredsheet, and use Excel Solver to find a solution that minimizes total distrit -1. Let X11= number of components preduced in Plant 1 and supplied to Store A x12= number of components produced in Pant 1 and supplied to Stere B X13= number of components produced in Plant 1 and supplied to store C X21= number of components produced in Plant 2 and supplled to Store A X22= number of components produced in plant 2 and supplied to Store 8 X73= number of components produced in Plant 2 and supplied to Store C X21 = number of components produced in Plant 3 and supplied to store A X32 n number of componerts produced in Plant 3 and supplied to store B X3y= number of components produced in Plant 3 and supplied to Szore C. xn t number of comptrents preduced in plant 2 and supplied to Stere B x3= number of components preduced in Plant 2 and subplled to 5 tere C x31= furmber of componenks preduced in Pant 3 and supplied to Store A x32 = number of eemponeies produced in Flant 3 and supplitd ts Store B X is n number of comigonente produced in Plant 3 and suppled to stoen C
