No paperwork. Use Excel LP solver and model step by step with formulas and constraints.

13. (10 points) An assembly line at Northern Manufacturing Ltd. (NML) has 4 stations. All laborers are trained to operate all stations. The union contract limits laborers to a 40-hour work week with no overtime. NML is contracted to produce 320 units per week, with a profit of $1000 per unit. Each unit must proceed through all 4 stations in order. However, there is sufficient work in progress inventory to keep all stations busy at all times. Station information is detailed in the following table: Station Time Required Per Unit in Cost to Build the Station minutes 15 $5000 20 $8000 3 30 $4000 20 $10,000 AWN- How many stations of each type does the assembly line require to meet demand? Required: Solve this model by using Excel and computer