This is a mode mix problem about fulfillment operations management. Please solve all five questions steps by steps. Please do not use any excel spreadsheet. I will high rate your work. Thanks a lot.

Mode Mix Problem ( 40 points) ABC Power Tools is currently making shipments from its plant in New Jersey to a customer location in California. ABC currently uses a mix a motor carriers and rail to move its product to its customer. ABC is contemplating using an all motor option for this move. Use the following information to answer the questions at the end: - Price per unit =$1000 - Net cost per unit =$690 - Daily demand =500 units - Inventory carrying cost =30% - Rail cost =2% of the price of the product - Motor carrier cost =10% of the price of the product - ABC owns the inventory up to the delivery at the customer's DC Questions 1. For the current mode mix, what is the percent days in transit compared to the total days that ABC owns the inventory? 2. What is the percent change in the percent of days in transit from the current mode mix to the proposed mode mix for when ABC owns the inventory? 3. What is the difference in inventory carrying cost between the current and proposed mode mixes? What is the percent change in inventory carrying cost between the two mode mixes? 4. What is the difference in freight cost between the two mode mixes? What is the percent change in freight cost between the two mode mixes? 5. What is the total change in cash flow between the two mode mixes