P Aitana Arguis AA 8 Find Y An Coke Ai8bC:D Replace No Spaci... Heading 1 Dictate Sentity Editor Select- Styles F Editing Voice Sensitivity Chapter 4-Linear Programming Applications in Marketing, Finance and Operations Management Question 5 (20 points). Edwards Manutachang Company purchases two component parts om three different supplers. The suppliers have lended capacity, and no one suppler can meet the company's needs in addson, the suppliers charge different prices for the components Component price dats (in price per unit) are as flows Supplier Component 2 $13 $12 $10 $14 $10 $11 Each soppler has a tened capacity in terms of the total number of componenty However, as long is Edwards provides suficient advance onders, mach sester can dev capacity to component 1, component 2, or any continuation of the two components number of units ordered is within in capacity Suppler capacities Supplier Capacity 1600 1000 200 the Edwards production plan for the next perod ecudes 1000 units of component tad 00 unts of componend 2, what purchases do you recomend W Forma a ne prigning model Solve the near program hated in part total schengco Excel S 1 ti Provide screenshots each exel sheet Your model sheet your restoranowe mpot y antras bee Append you will miss tee the acreenshot fer MS Excel Selver Solution, you will be graded for zers for the soldat That how many ts of each component should be onded from he What is the purchase coat for the mone p Let unts of component pushad to Docu A 81 8 Extr.. Comments La Reuse Files Editor Bee F ENG 1304