Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Please solve using excel and show the your detailed work. I will leave a like. Thanks so much! Garden Variety Flower Shop uses 550 clay
Please solve using excel and show the your detailed work. I will leave a like. Thanks so much!
Garden Variety Flower Shop uses 550 clay pots a month. The pots are purchased at $3.00 each. Annual carrying costs per pot are estimated to be 30 percent of cost, and ordering costs are $20 per order. The manager has been using an order size of 1,500 flower pots. a.What additional annual cost is the shop incurring by staying with this order size? (Round your optimal order quantity to the nearest whole number. Round all other intermediate calculations and your final answer to 2 decimal places. Omit the "$" sign in your response.) Additional annual cost b. Other than cost savings, what benefit would using the optimal order quantity yield (relative to the order size of 1,500)? (Use the rounded order quantity from Part a. Round your final answer to the nearest whole percent. Omit the "%" sign in your response.) About | % of the storage space would be neededStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started