Please show all steps and fully explain. If excel spreadsheet is used show cell code. will give thumb up

A firm wants a buyer to adjust their purchasing amount and frequency by changing the price it charges so that they purchase the target times per year. For example, if the firm purchases 10 times a year a firm might want it to purchase 5 times yearly instead. The firm recognizes that an incentive will have to be offered to do this and has set the incentive as the amount the purchaser would save in total (based on total material cost as used in inventory analysis) from the current cost to the purchaser. Data on the customer is given below as well as the target savings identified the firm thinks is required to get the purchaser to change their buying pattern.

Current Order Amt	Order Cost	Current Price	Incentive/Savings	Order per Year	Holding %	Target Orders/yr
310	500.00	135.00	5,000.00	18	60.0%	5

NOTE: The customer may not be applying EOQ to its current ordering quantity and frequency.

a. What is the total annual cost to the customer of the current ordering policy?

b. What is the highest price the seller can offer the customer so the customer orders 4 times yearly and meets the targeted savings?