using excel

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, I 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/1b. They can get discounts of they buy in large quantities: Quantity Small :0-99,999 lbs. Full price Medium: 100,000 lbs. 3% discount Large: 300,000 lbs. 7% discount Very Large: 500,000 lbs. 12% discount Price 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