Can you please show solutions in excel? Thank you.

24. Question 1 (1 point) Aqua System Inc. expects to have $3,979,710 in credit sales during the coming year. Currently all checks are sent to the home office. A proposed lockbox system can eliminate 5 days of float, releasing funds which, when invested, will earn 6.00 percent per year. What annual savings can Aqua System expect if the system is implemented? Use a 365-day year. 25. Book Depot Inc. sells on terms of 1/10, net 65. What is the implicit cost of trade credit under these terms? Use a 365-day year. 26. Pets Store Inc. sells on terms of 1/20, net 85. What is the effective annual cost of trade credit under these terms? Use a 365-day year. 27. Post Card Depot, an large retailer of post cards, orders 8,847,550 post cards per year from its manufacturer. Post Card Depot plans on ordering post card 22 times over the next year. Post Card Depot receives the same number of post cards each time it orders. The carrying cost is $0.30 per post card per year. The ordering cost is $413 per order. 28. Post Card Depot, an large retailer of post cards, orders 6,841,540 post cards per year from its manufacturer. Post Card Depot plans on ordering post card 21 times over the next year. Post Card Depot receives the same number of post cards each time it orders. The carrying cost is $0.17 per post card per year. The ordering cost is $219 per order. What is the annual ordering cost of the post card inventory? 29. Post Card Depot, an large retailer of post cards, orders 8,992,620 post cards per year from its manufacturer. Post Card Depot plans on ordering post card 8 times over the next year. Post Card Depot receives the same number of post cards each time it orders. The carrying cost is $0.08 per post card per year. The ordering cost is $467 per order. What is the annual total costs of post card inventory? 30. Cheeseburger and Taco Company purchases 13,595 boxes of cheese each year. It costs $23 to place and ship each order and $6.22 per year for each box held as inventory. The company is using Economic Order Quantity model in placing the orders. Calculate Economic Order Quantity. 31. Cheeseburger and Taco Company purchases 9,865 boxes of cheese each year. It costs $14 to place and ship each order and $8.35 per year for each box held as inventory. The company is using Economic Order Quantity model in placing the orders. What is the average inventory held during the year? 32. Cheesburger and Taco Company purchases 10,709 boxes of cheese each year. It costs $13 to place and ship each order and $8.83 per year for each box held as inventory. The company is using Economic Order Quantity model in placing the orders. How many orders will be placed each year? 33. Cheeseburger and Taco Company purchases 13,037 boxes of cheese each year. It costs $30 to place and ship each order and $4.19 per year for each box held as inventory. The company is using Economic Order Quantity model in placing the orders. What is the annual carrying costs of post card inventory. 34. Cheeseburger and Taco Company purchases 18,053 boxes of cheese each year. It costs $15 to place and ship each order and $5.42 per year for each box held as inventory. The company is using Economic Order Quantity model in placing the orders. What is the annual ordering cost of the post card inventory. 35. Cheeseburger and Taco Company purchases 15,363 boxes of cheese each year. It costs $30 to place and ship each order and $9.35 per year for each box held as inventory. The company is using Economic Order Quantity model in placing the orders. What is the annual total costs of post card inventory. 36. Appliance for Less is a local appliance store. It costs this store $15.13 per unit annually for storage, insurance, etc., to hold microwave in their inventory. Sales this year are anticipated to be 790 units. Each order costs $86. The company is using Economic Order Quantity model in placing the orders. It takes approximately 1 day(s) to receive an order after it has been placed. If the store insists on a 1 day(s) safety stock (assume 365-days a year), what should the inventory level be when a new order is placed? 37. Appliance for Less is a local appliance store. It costs this store $25.06 per unit annually for storage, insurance, etc., to hold microwave in their inventory. Sales this year are anticipated to be 637 units. Each order costs $95. The company is using Economic Order Quantity model in placing the orders. What is the average inventory held during the year including safety stock if the store insists on a 3 days safety stock (assume 365 days a year)