ESTRELLA is a bike retailer located in the outskirts of Bacolod City. ESTRELLA purchases bikes from STORAGEHUB in orders of 250 bikes which is the current economic order quantity. STORAGEHUB is now offering the following bulk discounts to its customers: Price 0% discount on orders less than 499 P3,500 10% discount on orders above 500 units - 999 3,150 15% discount on orders above 1,000 units 2,975 ESTRELLA is wondering if the EOQ model is still the most economical and whether increasing the order size would actually be more beneficial. Following information is relevant to forming the decision: Annual demand is 5000 units Ordering cost is $100 per order Annual holding cost is 25% QTY SETUP HOLDING PROODUCT COST TOTAL COST Q1 25423.73 25812.5 what is the product cost what is the total cost Q2 3000 198437.5 what is the product cost what is the total cost Q3 1500 371875 what is the product cost what is the total cost

ESTRELLA is a bike retailer located in the outskirts of Bacolod City. ESTRELLA purchases bikes from STORAGEHUB in orders of 250 bikes which is the current economic order quantity. STORAGEHUB is now offering the following bulk discounts to its customers: Price 0% discount on orders less than 499 P3,500 10% discount on orders above 500 units - 999 3,150 15% discount on orders above 1,000 units 2,975 ESTRELLA is wondering if the EOQ model is still the most economical and whether increasing the order size would actually be more beneficial. Following information is relevant to forming the decision: Annual demand is 5000 units Ordering cost is $100 per order Annual holding cost is 25% QTY SETUP HOLDING PROODUCT COST TOTAL COST Q1 25423.73 25812.5 what is the product cost what is the total cost Q2 3000 198437.5 what is the product cost what is the total cost Q3 1500 371875 what is the product cost what is the total cost

Purchasing and Supply Chain Management

6th Edition

ISBN:9781285869681

Author:Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson

Publisher:Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson

Chapter16: Lean Supply Chain Management

Section: Chapter Questions

Problem 10DQ: The chapter presented various approaches for the control of inventory investment. Discuss three...

See similar textbooks

Similar questions

Explain the most appropriate distribution system that can be used by Pepsi Co Jamaica to reduce order lead time and client delivery lead time. Please provide a justification for your response
Charlie’s Pizza orders all of its pepperoni, olives, anchovies, and mozzarella cheese to be shipped directly from Italy. An American distributor stops every four weeks to take orders. Because the orders are shipped directly from Italy, they take three weeks to arrive. Charlie’s Pizza uses an average of 150 pounds of pepperoni each week, with a standard deviation of 30 pounds. Charlie’s prides itself on offering only the best quality ingredientsand a high level of service, so it wants to ensure a 98 percent probability of not stocking out on pepperoni. Assume that the sales representative just walked in the door and there are currently 500 pounds of pepperoni in the walk-in cooler. How many pounds of pepperoni would you order? (Answer in Appendix D)
Retailers Warehouse (RW) is an independent supplier of household items todepartment stores. RW attempts to stock enough items for a 98 percent serviceprobability.A stainless steel knife set is one item it stocks. Demand (2,400 sets peryear) is relatively stable over the entire year. Whenever new stock isordered, a buyer must assure that numbers are correct for stock on handand then phone in a new order. The total cost involved to place an order isabout $5. RW figures that holding inventory in stock and paying forinterest on borrowed capital, insurance, and so on adds up to about $4holding cost per unit per year.Analysis of the past data shows that the standard deviation of demandfrom retailers is about four units per day for a 365-day year. Lead time toget the order is seven days.a. What is the economic order quantity?b. What is the reorder point?
Explain the elements of inventory management ?
Explain the role of event-driven systems in optimizing inventory management in the retail industry.
MGR Corporation sells table napkins. These are sold by dozen per package for Php 20. They sell 2,000 packages per month. Each package sells at Php 10 and requires 6 days lead time from date of order to date of delivery. The ordering cost is at Php 1.20 and the carrying cost is 10% per annum. Find the following: a) EOQ b) The number of orders per year c) The total cost of buying and carrying the table napkins for the year d) Assuming that the present inventory level is 200 packages and there is no safety stock, when is the next order placed (use 360 days/year)
define the ABC approach to inventory management Several metrics can be used to identify an A-status:explain?
Charlie’s Pizza orders all of it pepperoni, olives, anchovies, and mozzarella cheese to be shipped directly from Italy. An American distributor stops by every seven weeks to take orders. Because the orders are shipped directly from Ital, they take six weeks to arrive. Charlies Pizza uses an average of 250 pounds of pepperoni each week, with a standard deviation of 18 pounds. Charlie prides itself on offering only the best –quality ingredients and a high level of service, so it wants to ensure a 95 percent probability of not stocking out on pepperoni. Assume that the sales representative just walked in the door and there are currently 470 pounds of pepperoni in the walk-in cooler. How many pounds of pepperoni would you order? (Use the excels NORMSINV( ) function to find the critical value for the given a-level, (Round you z-value to 2 decimal places and final answer t
Explain the difference between static and dynamic inventory models?
Kabel Market store sells electric cable. The demand for cable is normally distributed. The inventory related information at Kabel Market is as follows: Average Annual Demand = 16,900 meters Standard deviation of weekly demand = 28 meters Cable selling price = AMD 640.00 per meter Ordering cost = AMD 1,250.00 per order Lead time = 5 weeks Annual inventory-holding cost estimate = 2.5% of the cable selling price Required service level = 95% Kabel Market works 52 weeks a year. Note: The approximate z values are: for 0.9 ≈ 1.28, for 0.92 ≈ 1.405, for 0.95 ≈ 1.645, for 0.98 ≈ 2.05. Suppose the bar management practices the fixed-QUANTITY ordering system with the use of the economic order quantity. Answer the following questions: (i) How many meters of cable they order from the supplier each time? (ii) When do they place an order? (iii) What is the safety stock?
Costco launched the warehouse shopping model when it opened its first location in 1976, requiring customers to purchase an annual membership in order to shop at the store.65 The first location was called Price Club and initially sold only to small businesses. More than 40 years later, Costco is one of the nation’s top retailers and the nation’s largest membership warehouse chain. They operate more than 700 warehouses located around the world, with more than 80 million members and over $116 billion in annual revenues. In addition to demonstrating steady growth throughout its history, the company consistently performs better than competitors. For example, Costco’s sales per square foot are nearly 70 percent higher than their closest competitor, Sam’s Club. So how has Costco achieved this level of success? Experts agree that Costco’s simple strategy has allowed the company to persist, even in challenging times. In fact, some say Costco has the best business model in the retail industry.…
Discuss the elements of inventory management?

SEE MORE QUESTIONS

Recommended textbooks for you

Purchasing and Supply Chain Management

Operations Management

ISBN:

9781285869681

Author:

Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson

Publisher:

Cengage Learning

Purchasing and Supply Chain Management

Operations Management

ISBN:

9781285869681

Author:

Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson

Publisher:

Cengage Learning

SEE MORE TEXTBOOKS

GET THE APP

About FAQ Academic Integrity Sitemap Document Sitemap

Contact Bartleby Contact Research (Essays)High School Textbooks Literature Guides Concept Explainers by Subject Essay Help Mobile App

GET THE APP

Privacy

Your CA Privacy Rights

Your NV Privacy Rights

About Ads

Manage My Data

bartleby, a Learneo, Inc. business

	QTY	SETUP	HOLDING	PROODUCT COST	TOTAL COST
Q1		25423.73	25812.5	what is the product cost	what is the total cost
Q2		3000	198437.5	what is the product cost	what is the total cost
Q3		1500	371875	what is the product cost	what is the total cost