-
+1 - 312-224-1615
Get in touch with us
-
support@helpwithassignment.com
Send us an e-mail
Solution Library
Maintaining Optimum Inventory Problem
Question
Powered by Koffe (PBK) is a new campus coffee store. PBK uses 50 bags of whole bean coffee every month, and you may assume that the demand is perfectly steady throughout the year. PBK has signed a year-long contract to purchase its coffee from a local wholesaler, Phish Roasters, for a price of $25 per bag and an $85 fixed cost of placing an order which is independent of the size of the order. The holding cost due to storage etc. is $1.50 per bag per month.
a. What is the optimal order size in bags?
b. Given your answer in (a), how many times does PBK order in a year?
c. Given your answer in (a), how many months of supply of coffee does PBK have on average?
d. On average, how many dollars per year does PBK spend to hold coffee?
e. A South American import/export company has offered PBK a deal for next year. PBK can buy a years’ worth of coffee at one go from them for $20 per bag and a fixed cost of $2000. Whom should PBK order from for the next year? Quantitatively justify your answer.
Summary
The question belongs to Operations Management and it is about a coffee store named Powered By Koffe. PBK has entered into contract with a coffee bean supplier and it requires PBK to pay for placing the order as well. The company wants to know the optimum size for placing the order to minimize the cost of order placement. This has been given calculated in the solution in the Excel sheet.
Total Word Count 92
WHAT OUR STUDENTS SAY
Excel formulas get me confused at the very basic level and to say that I was in deep waters with using Excel Solver in my math assignments would be an understatement. Thanks to the Excel Solver assignment help experts at HwA, I am now much more confident and my grades have improved.
Rachel Hawkins Student
1. I never faced any problem with marketing management or finance. But with operations management, I always suffered. I was unable to under the concepts of the decision tree analysis and the concept of location strategies. When I came across TheReliableTutor.com, I was relieved as they helped me overcome the horrors of operations management and transformed my fear into a genuine interest.
Simon Betteridge Student
I was facing a lot of problems with finding the right and relevant material for my quantitative chemistry assignment and running out of time before the submission deadline. The chemistry assignment expert at HwA helped me find the right research material and also helped me finish the quantitative chemistry assignment on time.
Rebecca Taylor Student
I was badly stuck with an argumentative essay writing assignment when I started searching for help on the net. I never thought that I will get any sort of specialized help for the Australian universities and when HwA promised to deliver that, I thought why not? Then I chatted with the expert and I got to know that she was also from the same university as I am in. It was kind of cool as she knew my syllabus and helped me out by writing and excellent essays which helped me get great grades.
Oliver Stuart Brown Student
I never faced any problem with marketing management or finance. But with location strategy, I always suffered with the PERT and CRM based problems. I was unable to understand the concept of location strategies. When I came across HwA, I was relieved as they helped me overcome the horrors of location strategy and transformed my fear into a genuine interest.
Stuart Henderson Student
Comments
this is a very good website
I have 50 questions for the same test your page is showing only 28
hi can you please help or guide me to answer my assignments. thanks
hi can anyone help or guide me to my assignments. thanks
This solution is perfect ...thanks
Hello Allison,I love the 2nd image that you did! I also, had never heard of SumoPaint, is something that I will have to exolpre a bit! I understand completely the 52 (or so) youtube videos that you probably watched. Sometimes they have what you want, sometimes they don't! However, it is always satisfying when you are able to produce something that you have taught yourself. Great job!Debra 0 likes
Perfect bank of solution.
great !
thanks for the quick response. the solution looks good. :)
thnx for the answer. it was perfect. just the way i wanted it.
works fine.