Chris Sandvig Irrigation, Inc., has summarized the price list from four potential suppliers of an underground control valve. See the table below. Annual usage is 700 valves; order cost is $7 per order, and annual inventory holding costs are $2.15 per unit. Vendor A Price Vendor B Price $34.75 Vendor C Vendor D Quantity Quantity Quantity Price Price Quantity 1-149 150-299 1-14 $35.00 $34.50 $34.25 1-24 25-99 1-49 15-24 34.75 33.55 34.00 50-149 33.75 33.00 25-99 100-199 32.50 300+ 31.00 32.80 31.60 150-299 100-199 200-399 32.35 200-399 400+ 300+ 31.10 31.15 30.75 30.50 400+ Which vendor should be selected and what order quantity is best if Sandvig Irrigation wants to minimize total cost? Chris Sandvig Irrgation should orderunits at a time from Vendor B (enter your response as a whole number).
Q: g. The total cost for this inventory plan h. The number of orders i. Ordering point j. The profit…
A: g. Total cost of inventory plan: Total Cost = Purchase Cost + Ordering Cost + Holding Cost…
Q: If you have a third option for the data in Problem( Your options for shipping $100,000 of machine…
A: a)given,in order to ship $100,000 of machine it will take 30 days at a cost of $3800estimated…
Q: In their most basic form, RFID tags track the progress of products from warehouse to retail shelf to…
A: The RFID technology can be defined as the technology that is used by the logistics companies to…
Q: D and L produces high quality plain colored t-shirts and polo jerseys which it sells at its retail…
A: Given information, Time take to arrive = 5 days Service probability = 97.5% Daily Demand = 20…
Q: A company ships LTL to customers in a market in the Midwest at an average costof $40 per cwt. It…
A: Given data: Plant to client shipping cost (Cpc) = $40 per cwt Plant to distribution center (Cpdc) =…
Q: Lovely Apparel must decide how many sets of assorted summer wear to order for its three stores.…
A: Decision analysis is a method for making strategic business decisions that is systematic,…
Q: Eagle Electric Repair is a repair facility for several major electric appliance manufacturers. Eagle…
A: Formula:
Q: Bernie’s Bike Shop receives the following trade discounts: 20/15/15. The vendor’s price list…
A: Given - Manufacturer’s list price = $550 Trade discounts: 20/15/15
Q: As manager of the St. Cloud Theatre Company, you have decided that concession sales will support…
A: Given, Items selling price variable cost % of revenue. Soft drink $1.00 $ 0.65 25 Wine…
Q: Community Hospital orders latex sanitary gloves from a hospital supply firm. The hospital expects to…
A: Optimal Order Quantity or Order size/Economic Order Quantity is the order level that a company…
Q: rand Styles Furniture Store is overstocked in (has excess inventory of) one type of chair. Based on…
A: Talking about the first case, when the inventory of chairs will be huge with the organization then,…
Q: 8. Consider a supply chain where a mamufacturer sells to a distributor who sells to a wholesaler who…
A: Bullwhip Measure = Variance in Order / Variance in Demand Variance in Demand for Retailer = 4000…
Q: As manager of the St. Cloud Theatre Company, you have decided that concession sales will support…
A: To determine the break-even point by using the formulae: BPEs =F∑1-ViPi×Wi Where,F= fixed cost Vi =…
Q: A car rental agency uses 96 boxes of staples a The boxes cost $4 each. It costs $10 to order…
A: Given, Annual demand, d =96 boxes Unit cost, u =$4 per box Ordering cost, o =$10 Carrying costs, h…
Q: If the variance of orders of a manufacturer equals 1000, and the variance of orders of its supplier…
A: Find the Given details below: Given details: Variance of Orders (Manufactures) 1000 Variance…
Q: Shaftel Ready Mix is a processor and supplier of concrete, aggregate, and rock products. One…
A: Shaftel Ready Mix is a processor and provider of concrete, total, and rock items. In…
Q: Healthy Plants Ltd. (HP) produces its premium plant food in 60-pound bags. Demand for the product is…
A: Demand (d)= 150000 pounds per week Working weeks= 50 weeks per week Weekly production(p) = 250000…
Q: Consider the supply : Last year, the retailer’s weekly variance of demand was 200 units.The…
A: What is the bullwhip effect? Envision an individual having a long whip in his grasp, and on the off…
Q: The EastCoasters Bicycle Shop stocks bikes; helmets;clothing; a variety of bike parts including…
A:
Q: ABC Company purchased its inventory at a lump price of P20,000. Relative sales value for each type…
A: The Inventory when purchased at a lump sum price, then the cost of inventory will be assigned in the…
Q: Eight Flags operates several amusement parks in the Midwest. The company stocks machine oil to…
A: Total cost is the total of all expenditures incurred by a corporation in order to produce a given…
Q: An eyeglass retailer buys lenses from a supplier at $100 each. The retailer orders 250 lens pairs…
A:
Q: XYZ has developed the following data from its Material A Safety stock Average (normally) daily use…
A: THE ANSWER IS AS BELOW:
Q: A local club is selling Christmas trees and deciding how many to stock for the month of December. If…
A:
Q: ManagementQ&A LibrarySuthar Timber Merchants in Patiala, India, features a large selection of…
A: Enterprise resource planning is a type of software designed for enhancing the existing business…
Q: Consider the supply chain illustrated here:Last year, the retailer's weekly variance of demand was…
A: Note - Hi! Thank you for the question, As per the honour code, we are allowed to answer three…
Q: Company B is a retailer of mobile phones in Australia that works 250 days in a year. The manager is…
A: Hello thank you for the question. As per guidelines, we would provide only first three-subparts at a…
Q: ompany B is a retailer of mobile phones in Australia that works 250 days in a year. The manager is…
A: EOQ≈ 29 phones. Total cost of purchase= $35,206 Total ordering cost =$2,586 Total cost of holding…
Q: As manager of the St Cloud Theatre Company, you have decided that concession sales will support…
A:
Q: Manufacturer Distributor E Wholesaler Retailer Last year, the retailer's weekly variance of demand…
A: The bullwhip effect is a phenomenon used in the supply chain where fluctuations in inventory or raw…
Q: Consider a supply chain with a manufacturer (M) and a retailer (R). The manufacturer produces a…
A: Note- We’ll answer the first three subparts of the question since the exact one wasn’t specified.…
Q: Last year, the retailer’s weekly variance of demand was 200 units. The variance of orders was 500,…
A: The bull whip impact at any connection in the store network can be determined by the recipe. Bull…
Q: Eight Flags operates several amusement parks in the Midwest. The company stocks machine oil to…
A: Given data:
Q: Company B is a retailer of mobile phones in Australia that works 250 days in a year. The manager is…
A: Since you have posted a question with multiple sub-parts, we will solve the first three subparts for…
Q: Company B is a retailer of mobile phones in Australia that works 250 days in a year. The manager is…
A: The formulas used for solving the question are: EOQ = 2 × Annual demand × Ordering costHolding cost…
Q: Muscat Tubes Manufacturing LLC are the manufacturer of picture tubes for T.V. The following are the…
A: The question is related to Inventory Management. We will Start with calculation of Reorder level.
Q: A manager must set up inventory ordering systems for two new production items, P34 and P35.P34 can…
A: Given data The z score will be calculated by the ‘=NORMSINV (probability)’ function on the Excel…
Q: As manager of the St. Cloud Theatre Company, you have decided that concession sales will support…
A: Find the given details below: Given details: Item Selling Price Variable cost % of revenue…
Q: r pays $28 for each battery and estimates that the annual holding cost is 30 percent of the…
A: The current ordering and holding costs are: C(100) = (R/Q)K+(Q/2)h
Q: Determine how many products to ship from each factory to each warehouse, or from each factory to…
A: This question is related to supply chain management and this topic falls under the operations…
Q: With example explain how I can use RFID to manage inventory?
A: RFID is the abbreviation of Radio frequency identification. It is the technology used to identify…
Q: As manager of the St. Cloud Theatre Company, you have decided that concession sales will support…
A: Calculation of total fixed cost Labor 250 Booth Rental 300 Total Fixed cost 550
Q: Lenka's Fresh Snacks (LFS), the producer of the Lenka Bar, is a granola bar manufacturer based in…
A: The process that includes the raw materials which are transformed into the finished goods is known…
Q: Uni Lever is in process to reduce its inventory costs. Annual demand for a raw material costing Rs.…
A: Annual Demand = D = 60,000 units Cost = Rs 12 per unit Ordering Cost = O = Rs. 6 per order Holding…
Q: An EOQ model that incorporates quantity discounts is used to determine: a. whether to use…
A: Answer - how many units should be ordered
Q: As manager of the St. Cloud Theatro Company, you have docided that concession sales will support…
A: Given: Labor cost=$280Contractual cost=$80No. of booths = 5
Trending now
This is a popular solution!
Step by step
Solved in 2 steps
- 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. Is Ben Gibson acting legally? Is he acting ethically? Why or why not?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?2. Avondale ice-cream shop in St Catherine's has been buying vegan-custard for its own plant base chunky chocolate passion explosion flavor using EOQ analysis. The supplier has now offered Avondale a discount of $0.50 off all units if the firm will make its purchases monthly or $1.00 off if the firm will make its purchases quarterly. Current data for the problem are: D = 720 units per year; S= $6.00, I= 20% per year; P= $25. (a) What is the EOQ at the current behavior? (b) What is the annual total cost, including product cost, of continuing their current behavior? (c) What are the annual total costs, if they accept either of the proposed discounts? (d) At the cheapest of the total costs, are carrying costs equal to ordering costs? Explain.
- Chris Sandvig Irrigation, Inc., has summarized the price list from four potential suppliers of an underground control valve. See the table below. Annual usage is 1,100 valves; order cost is $10 per order; and annual inventory holding costs are $7.55 per unit. D D Vendor A Quantity 1-14 15-24 25-99 100-199 200-399 400+ Price $35.00 34.75 33.55 32.35 31.15 30.75 Vendor C Vendor D Vendor A D Vendor B Vendor B Which vendor should be selected and what order quantity is best if Sandvig Irrigation wants to minimize total cost? Chris Sandvig Irrigation should order units at a time from (enter your response as a whole number). Quantity 1-24 25-99 100-199 200-399 400+ Price $34.75 34.00 32.80 31.60 30.50 MacBook Air O Vendor C Quantity 1-49 50-149 150-299 300+ Price $34.50 33.75 32.50 31.10 Vendor D Quantity 1-149 150-299 300+ Price $34.25 33.00 31.00 NextOne of your Taiwanese suppliers has bid on a new line of molded plastic parts that is currently being assembled at your plant. The supplier has bid $0.10 per part, given a forecast you provided of 400,000 parts in one year1. 500,000 in year 2; 700,000 in year 3. shipping and handling of parts from the supplier’s factory is estimated at $0.01 per unit. Additional inventory handling charges should amount to $0.006 per unit. Finally, administrative costs are estimated at $30 per month. Although your plant can continue producing the part, the plant would need to invest in another molding machine, which would cost $20,000. Direct materials can be purchased for $0.06 per unit. Direct labor is estimated at $0.05 per unit plus a 50% surcharge for benefits and, indirect labor is estimated at $0.008 per unit plus 50% benefit. Up-front engineering and design costs will amount to $40,000. Finally, management has insisted that overhead be allocated if the parts are made in-house at a rate of 100%…Bradley Solutions and Alexander Limited are two well-established suppliers of inexpensive tools. Weekend Projects is a national chain of retail outlets that caters to the occasional fixer-upper who would prefer to get the job done fast rather than investing in a well-appointed tool box. Weekend Projects wants to find a supplier for a particular tool set that promises to be a big seller. Expected annual sales are 100,000 units (D). Weekend's warehouses operate 50 weeks a year. Management collected data on the two suppliers, which are contained in the table below: Annual Freight Costs Shipping Quantity (Q) Price/Unit Annual Holding Lead Time (L) (p) $7.15 $7,15 Annual Supplier Bradley Alexander 10,000 25,000 $40.000 $26.000 50,000 $18.000 Cost/Unit (H) (wks) Administrative Cost $15.000 $1.43 $1.43 $30,000 $25,000 $17,000 6 $10,000 a. Which of the two suppliers would provide the lowest annual cost to Weekend Projects? What shipping quantity would you suggest? Using V and a shipping…
- Bradley Solutions and Alexander Limited are two well-established suppliers of inexpensive tools. Weekend Projects is a national chain of retail outlets that caters to the occasional fixer-upper who would prefer to get the job done fast rather than investing in a well-appointed tool box. Weekend Projects wants to find a supplier for a particular tool set that promises to be a big seller. Expected annual sales are 100,000 units (D). Weekend's warehouses operate 50 weeks a year. Management collected data on the two suppliers, which are contained in the table below: Annual Freight Costs Shipping Quantity (Q) Price/Unit Annual Holding Lead Time (L) Cost/Unit (H) $1.43 Annual Supplier Bradley Alexander Administrative Cost $15,000 $10.000 10.000 25,000 50,000 (p) $7. 15 (wks) $40,000 $30,000 $26,000 $18.000 $25,000 $17,000 $7,15 $1.43 6 a. Which of the two suppliers would provide the lowest annual cost to Weekend Projects? What shipping quantity would you suggest? Using Alexander and a…Bradley Solutions and Alexander Limited are two well-established suppliers of inexpensive tools. Weekend Projects is a national chain of retail outlets that caters to the occasional fixer-upper who would prefer to get the job done fast rather than investing in a well-appointed tool box. Weekend Projects wants to find a supplier for a particular tool set that promises to be a big seller. Expected annual sales are 100,000 units (D). Weekend's warehouses operate 50 weeks a year. Management collected data on the two suppliers, which are contained in the table below: Annual Freight Costs Shipping Quantity (Q) Price/Unit Annual Holding Lead Time (L) Annual Supplier Bradley Alexander 50.000 $18,000 $17.000 Cost/Unit (H) $1.43 $1.43 10,000 25,000 (p) $7.15 (wks) Administrative Cost $40,000 $30,000 $26.000 $25.000 $15,000 S7.15 6 $10.000 a. Which of the two suppliers would provide the lowest annual cost to Weekend Projects? What shipping quantity would you suggest? Using and a shipping quantity…Bradley Solutions and Alexander Limited are two well-established suppliers of inexpensive tools. Weekend Projects is a national chain of retail outlets that caters to the occasional fixer-upper who would prefer to get the job done fast rather than investing in a well-appointed tool box. Weekend Projects wants to find a supplier for a particular tool set that promises to be a big seller. Expected annual sales are 100,000 units (D). Weekend's warehouses operate 50 weeks a year. Management collected data on the two suppliers, which are contained in the table below: Annual Freight Costs Shipping Quantity (Q) Annual Price/Unit Annual Holding Lead Time (L) Cost/Unit (H) $1.83 $1.83 50,000 Supplier Bradley Alexander 10,000 25,000 $28.000 (wks) (p) $9.15 $9.15 Administrative Cost $40,000 $35,000 $18,000 $17,000 $10,000 $15,000 $26,000 7 a. Which of the two suppliers would provide the lowest annual cost to Weekend Projects? What shipping quantity would you suggest? Using and a shipping quantity…
- Bradley Solutions and Alexander Limited are two well-established suppliers of inexpensive tools. Weekend Projects is a national chain of retail outlets that caters to the occasional fixer-upper who would prefer to get the job done fast rather than investing in a well-appointed tool box. Weekend Projects wants to find a supplier for a particular tool set that promises to be a big seller. Expected annual sales are 100,000 units (D). Weekend's warehouses operate 50 weeks a year. Management collected data on the two suppliers, which are contained in the table below: Annual Freight Costs Shipping Quantity (Q) Price/Unit Annual Holding Lead Time (L) Cost/Unit (H) Annual Supplier Bradley Alexander 10,000 $35,000 25,000 $27,000 $40,000 $28,000 $18,000 50,000 $17,000 (p) (wks) Administrative Cost $8.10 $8.10 $1.62 $1.62 $15,000 $10,000 6 a. Which of the two suppliers would provide the lowest annual cost to Weekend Projects? What shipping quantity would you suggest? Using V and a shipping…Bradley Solutions and Alexander Limited are two well-established suppliers of inexpensive tools. Weekend Projects is a national chain of retail outlets that caters to the occasional fixer-upper who would prefer to get the job done fast rather than investing in a well-appointed tool box. Weekend Projects wants to find a supplier for a particular tool set that promises to be a big seller. Expected annual sales are 100,000 units (D). Weekend's warehouses operate 50 weeks a year. Management collected data on the two suppliers, which are contained in the table below: Annual Freight Costs Shipping Quantity (Q) Price/Unit Annual Holding Lead Time (L) Cost/Unit (H) $1.43 $1.43 Annual Supplier Bradley 10,000 $40,000 50,000 $18,000 $25,000 $17,000 25,000 (p) S7.15 (wks) Administrative Cost $26.000 5 $15,000 Alexander $30,000 S7.15 $10.000 a. Which of the two suppliers would provide the lowest annual cost to Weekend Projects? What shipping quantity would you suggest? Using Alexander and a…Bradley Solutions and Alexander Limited are two well-established suppliers of inexpensive tools. Weekend Projects is a national chain of retail outlets that caters to the occasional fixer-upper who would prefer to get the job done fast rather than investing in a well-appointed tool box. Weekend Projects wants to find a supplier for a particular tool set that promises to be a big seller. Expected annual sales are 100,000 units (D). Weekend's warehouses operate 50 weeks a year. Management collected data on the two suppliers, which are contained in the table below: Annual Price/Unit Holding Cost/Unit Lead Time (L) (p) (wks) Supplier 10,000 25,000 50,000 Bradley $40,000 $26,000 $19,000 Alexander $30,000 $28,000 $17,000 $7.15 $7.15 a. Which of the two suppliers would provide the lowest annual cost to Weekend Projects? What shipping quantity would you suggest? and a shipping quantity of Using Annual Freight Costs Shipping Quantity (Q) -w an example Get more help. (H) $1.43 $1.43 6 4 Annual…