The 23,000-seat Air East Arena houses the local professional ice hockey, basketball, indoor soccer, and arena football teams as well as various trade shows, wrestling and boxing matches, tractor pulls, and circuses. Arena vending annually sells large quantities of soft drinks and beer in plastic cups with the name of the arena and the various team logos on them. The local container cup manufacturer that supplies the cups in boxes of 100 has offered arena management the following discount price schedule for cups: Order Quantity (boxes) Price per Box 2000-6999 $47 7000-11,999 43 41 12,000-19,999 20,000+ 38 The annual demand for cups is 2.3 million, the annual carrying cost per box of cups is $1.90, and ordering cost is $320. Determine the optimal order quantity and total annual inventory cost. a. Find the economic order quantity Q* for each group b. Find the total annual cost TC for each group for the values of Q* found in (a). c. From (a) and (b) state the economic order quantity that gives the minimum total annual cost

The 23,000-seat Air East Arena houses the local professional ice hockey, basketball, indoor soccer, and arena football teams as well as various trade shows, wrestling and boxing matches, tractor pulls, and circuses. Arena vending annually sells large quantities of soft drinks and beer in plastic cups with the name of the arena and the various team logos on them. The local container cup manufacturer that supplies the cups in boxes of 100 has offered arena management the following discount price schedule for cups: Order Quantity (boxes) Price per Box 2000-6999 $47 7000-11,999 43 41 12,000-19,999 20,000+ 38 The annual demand for cups is 2.3 million, the annual carrying cost per box of cups is $1.90, and ordering cost is $320. Determine the optimal order quantity and total annual inventory cost. a. Find the economic order quantity Q* for each group b. Find the total annual cost TC for each group for the values of Q* found in (a). c. From (a) and (b) state the economic order quantity that gives the minimum total annual 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

ChapterC: Cases

Section: Chapter Questions

Problem 5.1SC: Scenario 3 Ben Gibson, the purchasing manager at Coastal Products, was reviewing purchasing...

See similar textbooks

Similar questions

Scenario 3 Ben Gibson, the purchasing manager at Coastal Products, was reviewing purchasing expenditures for packaging materials with Jeff Joyner. Ben was particularly disturbed about the amount spent on corrugated boxes purchased from Southeastern Corrugated. Ben said, I dont like the salesman from that company. He comes around here acting like he owns the place. He loves to tell us about his fancy car, house, and vacations. It seems to me he must be making too much money off of us! Jeff responded that he heard Southeastern Corrugated was going to ask for a price increase to cover the rising costs of raw material paper stock. Jeff further stated that Southeastern would probably ask for more than what was justified simply from rising paper stock costs. After the meeting, Ben decided he had heard enough. After all, he prided himself on being a results-oriented manager. There was no way he was going to allow that salesman to keep taking advantage of Coastal Products. Ben called Jeff and told him it was time to rebid the corrugated contract before Southeastern came in with a price increase request. Who did Jeff know that might be interested in the business? Jeff replied he had several companies in mind to include in the bidding process. These companies would surely come in at a lower price, partly because they used lower-grade boxes that would probably work well enough in Coastal Products process. Jeff also explained that these suppliers were not serious contenders for the business. Their purpose was to create competition with the bids. Ben told Jeff to make sure that Southeastern was well aware that these new suppliers were bidding on the contract. He also said to make sure the suppliers knew that price was going to be the determining factor in this quote, because he considered corrugated boxes to be a standard industry item. As the Marketing Manager for Southeastern Corrugated, what would you do upon receiving the request for quotation from Coastal Products?
Cryolab Inc makes and sells a lawn fertilizer called Hypergro. The company has developed standard costs for one bag of Hypergro as follows: Standard Quantity/Hours Standard Price/Rate Standard Cost per Bag Direct Material 25 pounds ₱ 0.75 ₱18.75 Direct Labor 0.25 hours ₱69.00 ₱17.30 Variable overhead 0.25 hours ₱24.00 ₱ 6.00 Total ₱42.05 The company had no beginning inventories of any kind on January 1. Variable overhead is applied to production on the basis of standard direct labor hours. During January, the following activity was recorded by the company: Production of Fastgro: 23,000 bags Direct materials purchased: 585,000 pounds at a cost of ₱436,250 Direct labor worked: 5,800 hours at a cost of ₱397,300 Variable overhead incurred: ₱140,650 Inventory of direct materials on January 31: 8,000 pounds Compute the variances and indicate whether it is FAVORABLE (F) or UNFAVORABLE (U) in your solution sheet. The raw…
Last year the retailer's weekly variance of demand was 190 units. The variance of orders was 480, 590, 730, and 1,380 units, for the retailer, wholesaler, distributor, and manufacturer, respectively (Note that the variance of orders equals the variance of demand for that firm's supplier) a) The bullwhip measure for the retailer is. (Enter your response rounded to two decimal places) b) The bullwhip measure for the wholesaler is c) The bullwhip measure for the distributor is (Enter your response rounded to two decimal places) (Enter your response rounded to two decimal places) d) The bullwhip measure for the manufacturer is (Enter your response rounded to two decimal places) e) In this supply chain, the appears to be contributing the most to the bullwhip effect, Enter your answer in each of the answer boxes javascript doExercise(10) This workstation has a time use limit of
Retailers Warehouse (RW) is an independent supplier of household items to department stores. RW attempts to stock enough items for a 98 percent service probability. A stainless steel knife set is one item it stocks. Demand (2,400 sets per year) is relatively stable over the entire year. Whenever a new stock is ordered, a buyer must ensure that numbers are correct for stock on-hand and then phone in a new order. The total cost involved to place an order is about $5. RW figures that holding inventory in stock and paying for interest on borrowed capital, insurance, and so on, add up to about $4 holding cost per unit per year. Analysis of the past data shows that the standard deviation of demand from retailers is about four units per day for a 365-day year. The lead time to get the order in seven days.a. What is the economic order quantity?b. What is the reorder point?
Ruby-Star Incorporated is considering two different vendors for one of its top-selling products which has an average weekly demand of 60 units and is valued at $60 per unit. Inbound shipments from vendor 1 will average 370 units with an average lead time (including ordering delays and transit time) of 5 weeks. Inbound shipments from vendor 2 will average 520 units with an average lead time of 1 week. Ruby-Star operates 52 weeks per year; it carries a 5-week supply of inventory as safety stock and no anticipation inventory. a. What would be the average aggregate inventory value of this product if Ruby-Star used vendor 1 exclusively?b. What would be the average aggregate inventory value of this product if Ruby-Star used vendor 2 exclusively?c. How would your analysis change if average weekly demand increased to 100 units per week?
Retailers Warehouse (RW) is an independent supplier of household items to department stores. RW attempts to stock enough items for a 98 percent service probability. A stainless steel knife set is one item it stocks. Demand (2,400 sets per year) is relatively stable over the entire year. Whenever new stock is ordered, a buyer must assure that numbers are correct for stock on hand and then phone in a new order. The total cost involved to place an order is about $5. RW i gures that holding inventory in stock and paying for interest on borrowed capital, insurance, and so on, add up to about $4 holding cost per unit per year.Analysis of the past data shows that the standard deviation of demand from retailers is about four units per day for a 365-day year. Lead time to get the order is seven days.a. What is the economic order quantity?b. What is the reorder point?
Retailers Warehouse (RW) is an independent supplier of household items to department stores. RW attempts to stock enough items for a 98 percent service probability. A stainless steel knife set is one item it stocks. Demand (2,400 sets per year) is relatively stable over the entire year. Whenever new stock is ordered, a buyer must ensure that numbers are correct for stock on-hand and then phone in a new order. The total cost involved to place an order is about $5. RW figures that holding inventory in stock and paying for interest on borrowed capital, insurance, and so on, add up to about $4 holding cost per unit per year. Analysis of the past data shows that the standard deviation of demand from retailers is about four units per day for a 365-day year. Lead time to get the order is seven days. What is the economic order quantity? Note: Round your answer to the nearest whole number. What is the reorder point? Note: Use Excel's NORM.S.INV() function to find the z value. Round z…
Ruby-Star Incorporated is considering two different vendors for one of its top-selling products which has an average weekly demand of 30 units and is valued at $100 per unit. Inbound shipments from vendor 1 will average 300 units with an average lead time (including ordering delays and transit time) of 4 weeks. Inbound shipments from vendor 2 will average 490 units with an average lead time of 1 week. Ruby-Star operates 52 weeks per year; it carries a 4-week supply of inventory as safety stock and no anticipation inventory. a. The average aggregate inventory value of the product if Ruby-Star used vendor 1 exclusively is $39,000. (Enter your response as a whole number.) b. The average aggregate inventory value of the product if Ruby-Star used vendor 2 exclusively is $ (Enter your response as a whole number.)
Ruby-Star Incorporated is considering two different vendors for one of its top-selling products which has an average weekly demand of 30 units and is valued at $60 per unit. Inbound shipments from vendor 1 will average 330 units with an average lead time (including ordering delays and transit time) of 4 weeks. Inbound shipments from vendor 2 will average 450 units with an average lead time of 3 weeks. Ruby-Star operates 52 weeks per year; it carries a 4-week supply of inventory as safety stock and no anticipation inventory. A. the average aggregate inventory value of the product if ruby star used vendor 1 exclusively is $_____ (enter your response as a whole number) B. the average aggregate inventory value of the product if ruby sta used vendor 2 exclusively is $______ (enter your response as a whole number) C. how would your analysis change if average weekly demand increased to 140 units per week? the average aggregate inventory value of the product if ruby star used vendor 1…
Green Gardens' owner has asked your advice about a possible problem at his business. Over the last 6 months the large-sized lawn and garden inventory (ie, tables, chairs, planters, etc.) has appeared to be short. The inventory records that employees use to determine what is on hand show that more inventory is available than can actually be located. This has cause frustration and mis-trust in the inventory records for the sales employees. The owner realizes that the problem is bigger than just frustrated employees. He is afraid that inventory is being stolen, a problem he didn't think possible given that these are large items that are not easily moved. Requirements: Provide the owner with two internal controls that he could implement to reduce the likelihood of theft of the lawn and garden inventory.
Copper Kettle Catering (CKC) is a full-service catering company that provides services ranging from box lunches for picnics or luncheon meetings to large wedding, dinner, or office parties. Established as a lunch delivery service for offices in 1972 by Wayne and Janet Williams, CKC has grown to be one of the largest catering businesses in Raleigh, North Carolina. The Williams’s divide customer demand into two categories: deliver only and deliver and serve. The deliver-only side of the business delivers boxed meals consisting of a sandwich, salad, dessert, and fruit. The menu for this service is limited to six sandwich selections, three salads or potato chips, and a brownie or fruit bar. Grapes and an orange slice are included with every meal, and iced tea can be ordered to accompany the meals. The overall level of demand for this service throughout the year is fairly constant, although the mix of menu items delivered varies. The planning horizon for this segment of the business is…
Consider the supply chain involved when a customer orders a product at Souq.com website as a retailer where the website directly sends the order to the customers. What is the cycle that will be deleted from cycle View representation for this scenario? Manufacturing cycle Procurement cycle Replenishment cycle Customer order cycle