Exam (elaborations)
SCM Quiz 5 Final Exam Questions with Answers accurately defined best rated a+ 2024/2025
- Course
- Institution
SCM Quiz 5 Final Exam Questions with Answers accurately defined best rated a+ 2024/2025
[Show more]
Content preview
SCM Quiz 5 Final Exam Questionswith Answers accurately defined
best rated a+ 2024/2025
Using a computerized Inventory Management System, a Paint Supply Store franchise
continuously monitors the inventory of all the paint located at each of their 15 stores and their
distribution warehouse. The Paint Supply Store franchise sells an average of 30 gallons of Red
Paint every week (for 52 weeks per year). Their current policy is that when they place an order
for Red Paint from their supplier, they order 70 gallons at a price of $2.00 per gallon. [The
company does not hold Safety Stock]
It takes 1.25 weeks to receive an order from the supplier.
Administrative costs for Ordering paint have been estimated to be $15 per order.
Holding Costs = 20% of the purchase price per gallon per year.
What is the Total Annual Inventory Cost for the company's current policy? - Answer A. $348.29
Explanation:
Given that: The Paint Supply Store franchise sells an average of 30 gallons of Red Paint every
week (for 52 weeks per year) i.e weekly demand = 30 gallons
Since 30 gallons is demanded weekly
Then annual demand for a year that contains 52 weeks = 30 × 52 = 1560
Order quantity = 70 gallons
Thus; number of orders = annual demand for a year / order quantity number of orders =
1560 /70 number of orders = 22.2857
, Price per gallon = $2.00
Time to receive order = 1.25 weeks
Administrative cost Ordering paint (i.e ordering cost per order) = $15
The total Ordering cost per order = number of orders × ordering cost per order
The total Ordering cost per order = 22.2857 × 15
The total Ordering cost per order = $334.2855
Holding cost = 20% of the purchase price per gallon per year
Holding cost = 20/100 × $2
Holding cost = 0.2 × $2
Holding cost = $0.4 per unit per year ∴
The Inventory Holding cost = ( order quantity /2 ) × holding cost The Inventory Holding cost =
(70/2) × 0.4 The Inventory Holding cost = 35 × 0.4
The Inventory Holding cost = $14
Finally, Total Annual Inventory Cost for the company's current policy is :
Total Annual Inventory Cost = Total Ordering cost per order + Inventory Holding cost Total
Annual Inventory Cost = $334.2855 + $14
Total Annual Inventory Cost = $348.2855
Total Annual Inventory Cost ≅ $348.29
https://answer.ya.guru/questions/1625711-using-a-computerized-inventory-management-
system-a-paint-supply.html
The benefits of buying summaries with Stuvia:
Guaranteed quality through customer reviews
Stuvia customers have reviewed more than 700,000 summaries. This how you know that you are buying the best documents.
Quick and easy check-out
You can quickly pay through credit card or Stuvia-credit for the summaries. There is no membership needed.
Focus on what matters
Your fellow students write the study notes themselves, which is why the documents are always reliable and up-to-date. This ensures you quickly get to the core!
Frequently asked questions
What do I get when I buy this document?
You get a PDF, available immediately after your purchase. The purchased document is accessible anytime, anywhere and indefinitely through your profile.
Satisfaction guarantee: how does it work?
Our satisfaction guarantee ensures that you always find a study document that suits you well. You fill out a form, and our customer service team takes care of the rest.
Who am I buying these notes from?
Stuvia is a marketplace, so you are not buying this document from us, but from seller DoctorMark. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $10.99. You're not tied to anything after your purchase.
Can Stuvia be trusted?
4.6 stars on Google & Trustpilot (+1000 reviews)
75632 documents were sold in the last 30 days
Founded in 2010, the go-to place to buy study notes for 14 years now