Dashboard x Topic: Link to submit in-clas x Assignment 3 X Launch LTI X E QA - Google Docs x Homework Help - Q&A from X + V X > C a office365-iad-prod.instructure.com/Iti/linked-share-item/781694/rce_content_item_selection M Gmail YouTube Maps UNIVERSITY PORTA... * RAID 1 vs. RAID 5:.. Other bookmarks b) If the Edwards production plan for the next period includes 1000 units of component 1 and 800 units of component 2, what purchases do you recommend? That is, how many units of each component should be ordered from each supplier? Use Excel Solver. (10 Points) c) What is the total purchase cost for the components? (5 Points) 3. EZ-Windows, Inc., manufactures replacement windows for the home remodeling business. In January, the company produced 15,000 windows and ended the month with 9000 windows in inventory. EZ-Windows' management team would like to develop a production schedule for the next three months. A smooth production schedule is obviously desirable because it maintains the current workforce and provides a similar month-to-month operation. However, given the sales forecasts, the production capacities, and the storage capabilities as shown, the management team does not think a smooth production schedule with the same production quantity each month is possible. FEBRUARY MARCH APRIL SALES FORECAST 15,000 16,500 20,000 PRODUCTION CAPACITY 14,000 14,000 18,000 STORAGE CAPACITY 6,000 6,000 6,000 The company's cost accounting department estimates that increasing production by one window from one month to the next will increase total costs by $1.00 for each unit increase in the production level. In addition, decreasing production by one unit from one month to the next will increase total costs by $0.65 for each unit decrease in the production level. Ignoring production and inventory carrying costs, a) Formulate a linear programming model that will minimize the cost of changing production levels while still satisfying the monthly sales forecasts. (10 Points) b) Solve the model using Excel Solver. (10 Points) 4. Tri-County Utilities, Inc., supplies natural gas to customers in a three-county area. The company purchases natural gas from two companies: Southern Gas and Northwest Gas. Demand forecasts for the coming winter season are as follows: Hamilton County, 400 units; Butler County, 200 units; and Clermont County, 300 units. Contracts to provide the following quantities have been written: Southern Gas, 500 units; and Northwest Gas, 400 units. Distribution costs for the counties vary, depending upon the location of the suppliers. The distribution costs per unit (in thousands of dollars) are as follows: PAGE 2 OF 3 100% Type here to search O 720 F ~ 93 8 ( 41 ) ENG 4:26 pm 99+ 21 UK 10/04/2022 S