Please show work in excel w formulas if possible

A jewelry firm buys semiprecious stones to make bracelets and rings. The supplier quotes a price of $9.00 per stone for quantities of 600 stones or more, $9.40 per stone for orders of 400 to 599 stones, and $9.90 per stone for lesser quantities. The jewelry firm operates 109 days per year. Usage rate is 27 stones per day, and ordering costs are $47. a. If carrying costs are $1 per year for each stone, find the order quantity that will minimize total annual cost. (Do not round intermediate calculations. Round your final answer to the nearest whole number.) Order quantity stones b. If annual carrying costs are 29 percent of unit cost, what is the optimal order size? (Do not round intermediate calculations. Round your final answer to the nearest whole number.) Optimal order size stones c. If lead time is 2 working days, at what point should the company reorder? (Do not round intermediate calculations. Round your final answer to the nearest whole number.) Reorder quantity stones