Can you assist me with Chapter 12 Question 9 it has two parts, Please show the steps it's easier to follow along instead of an excel spreadsheet. Thank you 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 $10 per order; and annual inventory holdingcosts are $5.25 per unit.Vendor APrice$35.00Vendor BQuantityVendor CPrice$34.50Vendor DPrice$34.2533.0031.00Quantity1-14Quantity1-149PriceQuantity1-491-24$34.7525-99100-19915-2434.7534.0050-14933.75150-29925-99150-29933.5532.3531.1530.7532.8031.6030.5032.50300+100-199200-399300+31.10200-399400+400+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). Based on available information, lead time demand for PC jump drives averages 51 units (normally distributed), with a standard deviation of 4 drives. Management wants a 90% service level. Refer to the standard normal table forz-values.a) What value of Z should be applied?b) How many drives should be carried as safety stock? units (round your response to the nearest whole number).c) What is the appropriate reorder point? units (round your response to the nearest whole number).

Which vendor should be selected and what order quantity is best if Sandvig Irrigation wants to minimize total cost? Chris Sandvig Irrigation should order O units at a time from |(enter your response as a whole number).

Which vendor should be selected and what order quantity is best if Sandvig Irrigation wants to minimize total cost? Chris Sandvig Irrigation should order O units at a time from |(enter your response as a whole number).

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...

See similar textbooks

Similar questions

Peach Company uses 800 units of a product per year on a continuous basis. The product has a Fixed Cost of $50 per order, and its carrying cost is $2 per unit per year. It takes 5 days to receive a shipment after an order is placed, and the firm wishes to hold 10 days’ usage in inventory as a safety stock. Show Computations and Explanations. The EOQ = 200 Units The Average Level of Inventory = 121.92 Units The Reorder Point = 33 Units A. Indicate if the Variable Change if the firm does not hold the Safety Stock. Variable: Reorder Point (Format: Change or Do not Change) B. Indicate if the Variable Change if the firm does not hold the Safety Stock. Variable: Economic Order Quantity (Format: Change or Do not Change)
Annual demand for the notebook binders at Duncan's Stationery Shop is 10,000 units. Dana Duncan operates her business 300 days per year and finds that deliveries from her supplier generally take 5 working days. Calculate the reorder point for the notebook binders that she stocks. The reorder point for the notebook binders isunits (round your response to the nearest whole number).
Coffee Company uses 800 units of a product per year on a continuous basis. The product has a Fixed Cost of $50 per order, and its carrying cost is $2 per unit per year. It takes 5 days to receive a shipment after an order is placed, and the firm wishes to hold 10 days’ usage in inventory as a safety stock. Show Computations and Explanations. The EOQ = 200 Units The Average Level of Inventory = 92 Units The Reorder Point = 33 Units A. Indicate if the Variable Change if the firm does not hold the Safety Stock. Variable: Ordering Cost (Format: Change or Do not Change) B. Indicate if the Variable Change if the firm does not hold the Safety Stock. Variable: Carrying Cost (Format: Change or Do not Change) C. Indicate if the Variable Change if the firm does not hold the Safety Stock. Variable: Total Inventory Cost (Format: Change or Do not Change)
I need help. It is due today. The answer for question b, 465 units is false/not correct The two images are the examples on how to solve the problem. 1. Petromax Enterprises uses a continuous review inventory control system for one of its SKUs. The following information is available on the item. The firm operates 52 weeks in a year. Refer to the standard normal table for z-values. ≻Demand = 78,000 units/year ≻Ordering cost = $30.00/order ≻Holding cost = $3.00/unit/year ≻Average lead time = 1 week ≻Standard deviation of weekly demand = 200 units The answer for a is: a. The economic order quantity for this item is 1249 units.(Enter your response rounded to the nearest whole number.) FIND b, please b. If Petromax wants to provide a 98% service level, the safety stock is "what?" units (enter your response rounded to the nearest whole number)
A produce distributor uses 720 packing crates a month, which it purchases at a cost of $10 each. The manager has assigned an annual carrying cost of 35 percent of the purchase price per crate. Ordering costs are $28. Currently the manager orders once a month. How much could the firm save annually in ordering and carrying costs by using the EOQ? (Round intermediate calculations and final answer to 2 decimal places. Omit the "$" sign in your response.) Savings$ ____per year
Southeastern Bell stocks a certain switch connector at its central warehouse for supplying field service offices. The yearly demand for these connectors is 14,100 units. Southeastern estimates its annual holding cost for this item to be $25 per unit. The cost to place and process an order from the supplier is $76. The company operates 300 days per year, and the lead time to receive an order from the supplier is 3 working days. a) What is the economic order quantity? units (round your response to the nearest whole number).
Based on available information, lead time demand for PC jump drives averages 50 units (normally distributed), with a standard deviation of 5 drives. Management wants a 98% service level. Refer to the standard normal table for z-values. Part 2 a) What value of Z should be applied? ▼ 1.28? 2.06? 1.04? or 1.65? Part 3 b) How many drives should be carried as safety stock? ___________ units (round your response to the nearest whole number). Part 4 c) What is the appropriate reorder point? _________ units (round your response to the nearest whole number).
Southeastern Bell stocks a certain switch connector at its central warehouse for supplying field service offices. The yearly demand for these connectors is 15,200 units. Southeastern estimates its annual holding cost for this item to be $26 per unit. The cost to place and process an order from the supplier is $73. The company operates 300 days per year, and the lead time to receive an order from the supplier is 2 working days. Part 2 a) What is the economic order quantity? enter your response here units (round your response to the nearest whole number). Part 3 b) What are the annual holding costs? $enter your response here (round your response to the nearest whole number). Part 4 c) What are the annual ordering costs? $enter your response here (round your response to the nearest whole number). Part 5 d) What is the reorder point? enter your response here units (round your response to the nearest whole number).
The retail shop averages demand of 100 chocolate chip cookies per day, with a 10 cookie standard deviation. Based on the previous chocolate chip production, lead time for reorder is 3 days (0 standard deviation) since there is no shipping involved. Management would like to ensure a 90% service level for its customers. Use Excel template to calculate the reorder point (ROP)
All Seasons Flower Shop uses 870 clay pots a month. The pots are purchased at $ 6 each. Annual holding cost per pot is estimated to be 35% of purchase cost. Ordering cost is $ 40 per order. The shop operates 12 months in a year. What is the economic order quantity (EOQ)?
Annual demand for a product is 11,440 units; weekly demand is 220 units with a standard deviation of 80 units. The cost of placing an order is $85, and the time from ordering to receipt is four weeks. The annual inventory carrying cost is $0.65 per unit. a. To provide a 99 percent service probability, what must the reorder point be? (Use Excel's NORMSINV() function to find the correct critical value for the given α-level. Do not round intermediate calculations. Round "z" value to 2 decimal places and final answer to the nearest whole number.) What is the reorder point? ______________ b. Suppose the production manager is told to reduce the safety stock of this item by 90 units. If this is done, what will the new service probability be? (Use Excel's NORMSDIST() function to find the correct probability for your computed Z-value. Round your answer to the nearest whole number.) What is the service probability? _________
Fruitcake Specialists sells 36,000 fruit cakes annually. Annual carrying costs are P5 per fruit cake and the ordering costs are P100 per order. The firm has decided to maintain a safety stock of one month's sales or 3,000 fruit cakes. The delivery time per order is 5 days. Assume a 365-day a year. What is the EOQ? What is the average inventory? How many orders should be placed each year? What is the total inventory cost? What is the re-order point?