A linear programming computer package is needed. The Silver Star Bicycle Company will be manufacturing both men’s and women’s models for its Easy-Pedal 10-sp demand forecasts call for 150 men’s and 125 women’s models to be shipped during the first month and 200 mer Labor Requirements (hours) Model Production Costs Current Inventory Manufacturing Assembly Men’s $120 2.0 1.5 20 Women’s $90 1.6 1.0 30 Last month the company used a total of 1,000 hours of labor. The company’s labor relations policy will not allow at the rate of 2% of the production cost based on the inventory levels at the end of the month. The company wo (a) Establish a production schedule that minimizes production and inventory costs and satisfies the labor-smo cycles during the next two months. Management wants to develop a production schedule indicating how many bicycles of each model should be produced in each month. Current 150 women’s models to be shipped during the second month. Additional data are shown. mbined total hours of labor (manufacturing plus assembly) to Increase or decrease by more than 100 hours from month to month. In addition, the company charges monthly inventory e to have at least 25 units of each model in inventory at the end of the two months. Only integer amounts of bicycles can be produced -demand, and invertory requirements. at the rate of 2% of the production cost based on the inventory levels at the end of the month. The company would like to have (a) Establish a production schedule that minimizes production and inventory costs and satisfies the labor-smoothing, demand, men’s model in month 1 bicycles X women’s model in month 1 *21 bicycles x men’s model in month 2 bicycles x women’s model in month 2 *22 bicycles *12 Total Cost $ 67156 What inventories will be maintained? Total Cost $ U What inventories will be maintained? Inventory Schedule men’s model in month 1 $11 bicycles X women’s model in month 1 $21 bicycles men’s model in month 2 $12 bicycles X women’s model in month 2 522 bicycles