Alinear programming computer package is needed The Sher Star Bicyce Company will be manufacturing both men's and one's mods for its Easy-do-bicydes 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 demand forecasts call for 150 125 women's models to be shipped during the first month and 200 mer's and 150 women's models to be hoed during the second month Adional data are shown Labor Requirements (hours) Model Production Costs Current Inventory Manufacturing Ansembly $120 2.0 1.5 20 Women's $90 16 30 Men's 10 Last month the company sed a total of 1,000 hours of bor. The company's tabor relations poley will not allow the combined total hours of labor (manufacturing plus assembly ta ncrease or decrease by more than 100 hours from month to month. In addition, the company charges monthly inventory at the rate of the production cont based on the Inventory levels at the end of the month. The company would like to have at least 25 units of each modelis inventory at the end of the two months, Only intoper amounts of bicycles can be produced {a) Establish production schedule that minimes production and inventory costs and sises the labor smoothing, demand, and Inventory requirements men's model in month bicycles womens modelin mart 1 bicycles men's model in month 2 bicycles women's model in month 2 bicycles Total Cost $ What inventories will be trainer What inventories will be maintained Inventory Schedule men's model in month 1 bicycles women's model in month 1 bicycles mer's model in month 2 bicycles women's model in month 2 bicycles What are the monthly labor requirements? previous month month 1 hrs month 2 hrs (b) If the company changed the constraints so that monthly labor increases and decreases could not exceed so hours, what would happen to the production schedule? men's model in month bleycles women's model in month 1 bicycles men's model in month 2 bicycles women's model in month 2 bicycles Total Cost (b) of the company changed the constraints so that monthly labor Increases and decreases could not exceed so hours, what would happen to the production schedule? men's model in month 1 bicycles women's model in month 1 bicycles men's model in month 2 bicycles women's model in month 2 bicycles Total Cost $ How much will the cost increase