I have questions one and two finished. looking for help or examples to finish 3 and 4.

After making some wise short-term investments at a race track, Chris Low had some additional cash to invest in a business. The most promising opportunity at the time was in building supplies, so Low bought a business that specialized in sales of one size of nail. The annual volume of nails was 2,200 kegs, and they were sold to retail customers in an even flow. Low was uncertain how many nails to order at any time. Initially, only two costs concerned him: order-processing costs, which were $52 per order without regard to size, and warehousing costs, which were $1.52 per year per keg space. This meant that Low had to rent a constant amount of warehouse space for the year, and it had to be large enough to accommodate an entire order when it arrived. Low was not worried about maintaining safety stocks, mainly because the outward flow of goods was so even. Low bought his nails on a delivered basis. Questions 1. Using the EOQ methods outlined in the chapter, how many kegs of nails should Low order at one time? Compute the corresponding Orders per year, Annual processing cost, Annual warehousing cost, and the Total inventory-related cost. 2. Assume all conditions in Question I hold, except that Low's supplier now offers a quantity discount in the form of absorbing all or part of Low's order-processing costs. For orders of 750 or more kegs of nails, the supplier will absorb all the order-processing costs; for orders between 250 and 749 kegs, the supplier will absorb half. Use the provided cost table to estimate Low's new EOQ. Should he take the full rebate? Should he take the partial rebate? Should he avoid the rebate? Compare the savings in Total inventory-related costs from #1 to convince Mr. Low of your recommendation. 3. Temporarily, ignore your work on Question 2. Assume that Low's warehouse offers to rent Low space on the basis of the average number of kegs Low will have in stock, rather than on the maximum number of kegs Low would need room for whenever a new shipment arrived. The storage charge per keg remains the same. Does this change the answer to Question 1? If so, what is the new answer? Should Mr. Low take the new warehouse offer? What is your new recommendation for EOQ? Compare the savings in Total inventory-related costs from #1 to convince Mr. Low lof your recommendation. 4. Take into account the answer to Question 1 and the supplier's new policy outlined in Question 2 and the warehouse's new policy in Question 3. What is your new recommendation for EOQ? Convince Mr. Low to take the supplier rebate, new warehouse offer, both or neither. nd 4 Low's luck at the race track is File Home Insert Draw Page Layout Formulas Data Review View Help Viewing w Calibri 12 Bar A Merge General EEE M fx B D E K M . N Question 2: Orders per Year Order Size Annual Processing Costs ($) $0.00 Annual Warehousing Costs ($) Total Annual Inventory Costs ($) 7 2 0 3 4 3 4 5 -6 87 58 39 40 41 42 600 Valur 5 6 7 8 9 Hint: use the table above to identify the minimum Total Cost option. The new EOQ, based on the current situation is: 43 44 Total cost savings (or extra expenses) from #1? Discuss your recommended Order size. Should he take the full rebate? Should he take the partial rebate? Should he avoid the rebate? Compare the savings in Total inventory-related costs from #1 to convince Mr. Low of your recommendation. 45 Calibri 12 12 BIG ab Merge v General 00 fx B C D E F G H j K M N Question 3: Orders Per Year Order Size Annual Processing Costs ($) Annual Warehousing Costs ($) Total Annual Inventory Costs ($) 1 0 2 3 4 5 6 7 8 3 e 9 1 The new EOQ, based on the current situation is: Hint: use the table above to identify the minimum Total Cost option 2 Total cost savings (or extra expenses) from #1? 3 4 Should Mr. Low take the new warehouse offer? What is your new recommendation for EOQ? Compare the savings in Total inventory-related costs from #1 to convince Mr. Low of your recommendation 5 HII EOQ of Low Nail Company Lalb vab Merge v General 200 fx A B C D E F G H Question 3: K M N Orders Per Year Order Size Annual Processing Costs ($) Annual Warehousing Costs ($) Total Annual Inventory Costs ($) 1 0 2. 3 4 + 5 6 7 8 9 1 The new EOQ, based on the current situation is: Hint: use the table above to identify the minimum Total Cost option Total cost savings (or extra expenses) from #1? 3 1 Should Mr. Low take the new warehouse offer? What is your new recommendation for EOQ? Compare the savings in Total inventory-related costs from #1 to convince Mr. Low of your recommendation. 5 EOQ of Low Nail Company Giv Workbook Statistics