I need help I keep getting the wrong answers and I'm not too great with excel either

6-25 Shoe Shine is a local retail shoe store located on the north side of Centerville. Annual demand for a pop- ular sandal is 500 pairs, and John Dirk, the owner of Shoe Shine, has been in the habit of ordering 100 pairs at a time. John estimates that the ordering cost is $10 per order. The cost of the sandal is $5 per pair. For John's ordering policy to be correct, what would ha nrohlam ... the carrying cost as a percentage of the unit cost have to be? If the carrying cost was 10% of the cost, what would the optimal order quantity be? Anal Paste TIL A BIU Merge & Center A6 x v fx D E F G H Use this worksheet in order to solve problem 6-25 from your book. After you calculate al numbers, provide clear answers to the question 5 6 7 8 Data 9 Demand rate, D 10 Ordering/Setup cost. Co 11 Holding cost Ch 12 13 Results 14 Optimal Order Quantity, Q' 15 Average Inventory 16 Number of Orders 17 18 Holding costs 19 Ordering costs 20 Total cost T. 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 42 43 45 46 47 48 49 PART 1 PART 2 PART 3 PART 4