How do I add the extra $400 to the table.

discuss this issue in the memo. Problem 3: Economic Order Quantity In a new worksheet of your own design, create visual basic macros for calculating economic order quantity, orders per year, and total stocking cost. The total stocking cost macro should take arguments k, d, h, eoq, and opy. LPB estimates their annual demand (D) for peanuts is 168, 120 TONS. Determine LPB's EOQ and OPY values for ordering peanuts if inventory costs are $0.04 per TON per year. LPBs current ordering system results in a charge of $20 per order but they are considering a new ordering system that would lower ordering costs to $5 per order, the new system will cost $400.00 per year to implement and operate. Set up a small table comparing EOQ, OPY, and total stocking cost for the existing ordering system versus the new stocking system. Create a bar or column chart that compares the EOQ from the old ordering system to the new ordering system, make a second chart that compares OPY from the two systems, make a third chart comparing total stocking cost for the two systems. In the memo discuss how much the new ordering system would change the EOQ, OPY, and total stocking cost values. Should they adopt the new ordering system? Problem 4: Data Analysis