ase provide your work process. If only a final answer is provided, without any work shown, you will receive ZERO point. zell with Excel function typed in is considered as "work shown".

$31$ Please revisit Example $4($Ordering with Quantity Discounts$)$ of Week $2,$ Spreadsheet Modeling $($Slide page $18).$ Use the information from this example to complete the following task.

Example $4($Ordering with Quantity Discounts

Sam's Bookstore, with many locations across the United States, places orders for all of the latest books and then distributes them to its individual bookstores. Sam's needs a model to help it order the appropriate number of any title. For example, Sam's plans to order a popular new hardback novel, which it will sell for $$30.$ It can purchase any number of this book from the publisher, but due to quantity discounts, the unit cost for all books it orders depends on the number ordered. If the number ordered is less than $1000,$ the unit cost is $$24.$ After each $1000,$ the unit cost drops: to $$23$ for at least $1000$ copies; to $$22\mathrm{.}25$ for at least $2000$ ; to $$21\mathrm{.}75$ for at least $3000$; and to $$21\mathrm{.}30($the lowest possible unit cost$)$ for at least $4000.$ For example, if Sam's orders $2500$ books, its total cost is $$22\mathrm{.}25(2500)=$$$55,625.$ Sam's is uncertain about the demand for this book$-$it estimates that demand could be anywhere from $500$ to $4500.$ Also, as with most hardback novels, this one will eventually come out in paperback. Therefore, if Sam's has any hardbacks left when the paperback comes out, it will put them on sale for $$10,$ at which price it belleves all leftovers will be sold.

In some ordering problems, like the one in Example $4,$ when demand exceeds existing inventory, the excess demand is not lost but is filled by expedited orders$-$at a premium cost to the company. Change Sam's model to reflect this behavior. Assume that the unit cost of expediting is $$40,$ well above the highest regular unit cost. Use a trial value of $3000$ as the demand. No need to perform the data table analysis, only the basic spreadsheet model is required. Please use range names and list all range names used $(8$ points$).$