The information needed to solve these problems is presented in the Module Three Excel Worksheet. The initial setup for Solver is presented for each problem. Each problem has its own worksheet. 1. An apparel manufacturer makes 4 types of neckties: all silk, all cotton, all polyester and a 50/50 cotton-polyester blend. The profit per tie, the quantity of fabric used to make each type of tie and the quantity of fabric available are presented in the table on the Problem 1 worksheet. The manufacturer will make at least 5,000 of each type of necktie. j L B C D E F G H Fabric required per tie, yds. Profit Product Silk Cotton Polyester per tie, $ Silk 0.125 5.2 Cotton 0.1 5.5 Polyester 0.08 3.2 50/50 Poly-Cotton Blend 0.05 0.04 4 Fabric Available, yds. 800 20000 20000 Fabric used Objective Variable cells Fabric used