4. Brighton Fabricators builds large components for solar arrays. Every year they buy a million pounds of welding wire. Their supplier has offered them the following bulk pricing discounts and shipping conditions. Make a recommendation for the purchase quantities they should buy and how should they have it shipped. shipped. You can include a spreadsheet in your answer if you want. You need a written explanation why you recommend it. {BTW, if you think I forgot to give you some crucial information, want you to know that I am only giving you the type of information you will get on the job... aka more real life) Details of Quote: The bulk discount would be PER ORDER. Price per pound starts at $0.2/lb. They can get discounts of they buy in large quantities: Price Quantity Small :0-99,999 lbs. Medium: 100,000 lbs. Large: 300,000 lbs. Very Large: 500,000 lbs. Full price 3% discount 7% discount 12% discount When you place the order, you have to buy and pay for it all at once, but you don't have to have it delivered all at once. If you ship it in quantities less than 160,000 lbs., then you pay $500 for delivery. If you ship it in quantities >160,000 lbs., then freight is free. What purchase quantities are you going to recommend to your business owner and why? If we assume that there is a highly demand for 1,000,000 per year so the carrying cost would be 35% of the price