Floral Beauty, Inc., is a large floral arrangements store located in Asheville Mall. Bridal Lilies, which are a specially created bunch of lilies for bridal bouquets, cost Floral Beauty $19 each. There is an annual demand for 22,000 Bridal Lilies. The manager of Floral Beauty has determined that the ordering cost is $85 per order, and the carrying cost, as a percentage of the unit cost, is 14%. Floral Beauty is now considering a new supplier of Bridal Lilies. Each lily would cost only $17.50, but to get this discount, Floral Beauty would have to buy shipments of 2,000 Bridal Lilies at a time. Should Floral Beauty use the new supplier and take this discount for quantity buying?d) What is the total annual inventory cost (including purchase cost) for the current supplier?e) What is the annual holding cost for the new supplier (when purchasing 2,000 each order)?f) What is the total annual inventory cost (including purchase cost) for the new supplier (whenI Need help on the formulas for d, e, f. solve of excel

From Current supplier:Annual demand (D) = 22,000Unit cost (C) = $19Ordering cost (S) = $85Unit…

Answered: Floral Beauty, Inc., is a large floral…

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...

Related questions

Question

100%

Floral Beauty, Inc., is a large floral arrangements store located in Asheville Mall. Bridal Lilies, which are a specially created bunch of lilies for bridal bouquets, cost Floral Beauty $19 each. There is an annual demand for 22,000 Bridal Lilies. The manager of Floral Beauty has determined that the ordering cost is $85 per order, and the carrying cost, as a percentage of the unit cost, is 14%. Floral Beauty is now considering a new supplier of Bridal Lilies. Each lily would cost only $17.50, but to get this discount, Floral Beauty would have to buy shipments of 2,000 Bridal Lilies at a time. Should Floral Beauty use the new supplier and take this discount for quantity buying?
d) What is the total annual inventory cost (including purchase cost) for the current supplier?
e) What is the annual holding cost for the new supplier (when purchasing 2,000 each order)?
f) What is the total annual inventory cost (including purchase cost) for the new supplier (when

I Need help on the formulas for d, e, f. solve of excel

Expert Solution