1. A&C Distributors is a company that represents many outdoorproducts companies and schedules deliveries to discount stores,garden centers, and hardware stores. Currently, scheduling needs tobe done for two lawn sprinklers, the Water Wave and Spring Showermodels. Requirements for shipment to a warehouse for a nationalchain of garden centers are shown below.

I need just e answer.

Month	ShippingCapacity	Product	MinimumRequirement	Unit Cost toShip	Per Unit InventoryCost
March	8000	Water Wave	3000	.30	.06
		Spring Shower	1800	.25	.05
April	7000	Water Wave	4000	.40	.09
		Spring Shower	4000	.30	.06
May	6000	Water Wave	5000	.50	.12
		Spring Shower	2000	.35	.07

Let Sij be thenumber of units of sprinkler i shipped in month j, where i = 1 or2, and j = 1, 2, or 3. Let Wij be the number of sprinklers that areat the warehouse at the end of a month, in excess of the minimumrequirement.

Let Sij be thenumber of units of sprinkler i shipped in month j, where i = 1 or2, and j = 1, 2, or 3. Let Wij be the number of sprinklers that areat the warehouse at the end of a month, in excess of the minimumrequirement.

a Write theportion of the objective function that minimizes shippingcosts.

2. An inventory cost is assessed against this ending inventory.Give the portion of the objective function that representsinventory cost.
3. There will be three constraints that guarantee, for each month,that the total number of sprinklers shipped will not exceed theshipping capacity. Write these three constraints.
4. There are six constraints that work with inventory and thenumber of units shipped, making sure that enough sprinklers areshipped to meet the minimum requirements. Write these sixconstraints.
5. Formulate and Solve Using Excel the wholeproblem.