Problem Solve Brief Problem Solve - Data & Information The following information is available for this task: 2.1 Tender Prices 2.1.1 Each of the three suppliers has priced six items. The submitted prices are: Estimated Annual Quantity Alpha Pipes Ltd Beta Works Ltd Coventry Utilities Lid Item 1,000 E 500 500 500 Item 2 2.000 E 1, 100 E 1,000 1,000 Item 3 500 E 4,400 E 3,500 400 Item 4 3.000 E 275 E 300 325 Item 5 2.000 E 325 E 175 325 Item 8 1,000 45 50 50 2.2 Existing Supplier Prices: 2.2.1 The existing supplier is Alpha Pipes Ltd and their current prices are: Current Contract|Alpha Pipes Ltd Item 1 550 Item 2 E 1.225 Item 3 E 4.550 Item 4 E 300 Item 5 E 325 Item 8 44 2.3 Order Volumes and Discounts: 2.3.1 Future order volumes are uncertain, so suppliers have been invited to submit offers discounts. If the annual total value placed by the business exceeds $5m, the offers are: Discounts Offered: Alpha Pipes Beta Works Coventry Utilities If >25m per annum 5.0% 0.8% 1.5% 2.3.2 Would this affect your decision in any way? 2.4 Other Considerations: 2.4.1 From the Supplier Shortlisting stage, the following information was gathered on the Age of Value of Safety Record Worked Supplier Company Nr of [accidents In Head Office for STS water work [Years Staff Location In past 12 Trading) past s yraj Before? months A B C D E Alpha Pipes Ltd 15 20 Birmingham Yes E100m Beta Works Ltd 10 125 10 Glasgow No E1000m Coventry Utilities Lid 25 45 Coventry Yes E50m 2.4.2 No further analysis is required on this information, but how would you use this "( information when making your recommendation? 2.4.3 Your business provides an essential service to your customers. How might current is