Question 30 1 pts Kite 'N String manufactures old-fashioned diagonal and box kites from high-strength paper and wood. Each diagonal kite, which nets the company a $3 profit and requires & square feet of paper and 5 linear feet of wood. Each box kite nets a $5 profit and requires 6 square feet of paper and 10 linear feet of wood. Each kite needs to be packaged in a single box before it is sold to customers. This week Kite 'N String has 1500 boxes for packaging (one for each kite), and the capacity to tailor 10,000 square feet of paper and 12,000 linear feet of wood for kite production. Kite 'N String need to make production decision in order to maximize the company's total profit for this week? Implement this problem into excel and solve for the optimal solutions. What is the optimal total profit? (Please type ONLY NUMBERS with NO ROUNDING in the answer box) Question 31 1 pts Heavenly Casket Company is trying to choose sites for the production of its mail order" caskets. It is considering plants in Chicago, Dallas, and Atlanta. Finished caskets will then be sent to their two distribution sites in Trenton and Tacoma, which take orders over the internet. Heavenly expects demand of at least 4000 caskets per year in Trenton and at least 2500 in Tacoma. The table below gives annual plant capacity, and unit transportation costs between possible plant locations and the distribution sites: Site Capacity Shipping to Shipping to Trenton Cost Tacoma Cost Per Unit Per Unit Chicago 4000 $75 $60 Dallas 3000 $100 $70 Atlanta 3700 $82 $90 Formulate this transportation network problem as an integer linear programming model in order to minimize the total annual transportation cost. Implement the problem in excel and find the optimal solutions. What is the optimal shipping quantity from Chicago to Trenton? (Please type ONLY NUMBERS with NO ROUNDING in the answer box)