Production and Operations Analysis, Seventh Edition
7th Edition
ISBN: 9781478623069
Author: Steven Nahmias, Tava Lennon Olsen
Publisher: Waveland Press, Inc.
expand_more
expand_more
format_list_bulleted
Question
Chapter 4.8, Problem 28P
Summary Introduction
To determine:
Optimal order quantity
Introduction:
Economic order quantity is the optimal quantity which is ordered keeping in mind to minimize the cost and fulfilling of demand. This is usually done when cost varies according to the number of units demanded.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solutionStudents have asked these similar questions
Instructions
There are four parts to this problem. Use Excel to perform the following.
a. Use the economic order quantity formula (EOQ = SQRT((2SD/H)) to determine the optimal number of units that the company should order based on each assumed level of order based on each assumed level of order quantities provided in the data.
b. Complete the table by calculating the number of orders per year, annual order cost, annual holding cost, and annual total cost. Highlight the minimum annual total cost using conditional formatting. Hint: The minimum cost should equal the cost at the EOQ you calculated in part a.
c. Create a line chart that graphs annual order cost, annual holding cost, and annual total cost. The x-axis should be the quantity ordered. Include a chart legend, appropriate chart title, axes labels, and properly formatted amounts on the axes.
d. Examine the chart and your responses to parts a and b. Indicate any relationships.
Suppose that in the given problem the space consumed by each vegetable is not proportional to its cost. In particular, suppose that one pound of lettuce required 0.4 square foot of space and one pound of zucchini required 1 square foot of space. Determine upper and lower bounds on the optimal values of the order quantities in this case. Test different values of the Lagrange multiplier to find the optimal values of the order quantities. (A spreadsheet is ideally suited for this kind of calculation. If you solve the problem using a spreadsheet, place the Lagrange multiplier in a cell so that its value can be changed easily.)
Usha Handling Company is currently faced with an inventory rotation problem. Thisdifficulty stems from the fact that some supplies must be used prior to a stated expiration date.Upon receipt, a new shipment of these perishable items must be stacked beneath the boxes that are currently in inventory. A substantial amount of time is consumed in restacking the items according to their expiration dates. The company would like to reduce the double and sometimes triple handling of items. How can this goal be achieved? Are there alternative solutions which might also be effective?
Chapter 4 Solutions
Production and Operations Analysis, Seventh Edition
Ch. 4.4 - Prob. 1PCh. 4.4 - Prob. 2PCh. 4.4 - Prob. 3PCh. 4.4 - Prob. 4PCh. 4.4 - Prob. 5PCh. 4.4 - Prob. 6PCh. 4.4 - Prob. 7PCh. 4.4 - Prob. 8PCh. 4.4 - Prob. 9PCh. 4.5 - Prob. 10P
Ch. 4.5 - Prob. 11PCh. 4.5 - Prob. 12PCh. 4.5 - Prob. 13PCh. 4.5 - Prob. 14PCh. 4.5 - Prob. 15PCh. 4.5 - Prob. 16PCh. 4.6 - Prob. 17PCh. 4.6 - Prob. 18PCh. 4.6 - Prob. 19PCh. 4.6 - Prob. 20PCh. 4.7 - Prob. 21PCh. 4.7 - Prob. 22PCh. 4.7 - Prob. 23PCh. 4.7 - Prob. 24PCh. 4.7 - Prob. 25PCh. 4.8 - Prob. 26PCh. 4.8 - Prob. 27PCh. 4.8 - Prob. 28PCh. 4.9 - Prob. 29PCh. 4.9 - Prob. 30PCh. 4 - Prob. 31APCh. 4 - Prob. 32APCh. 4 - Prob. 33APCh. 4 - Prob. 34APCh. 4 - Prob. 35APCh. 4 - Prob. 36APCh. 4 - Prob. 37APCh. 4 - Prob. 38APCh. 4 - Prob. 39APCh. 4 - Prob. 40APCh. 4 - Prob. 41APCh. 4 - Prob. 42APCh. 4 - Prob. 43APCh. 4 - Prob. 44APCh. 4 - Prob. 45AP
Knowledge Booster
Similar questions
- 8. 4 The Western Jeans Company purchases denim from Cumberland Textile Mills. The Western Jeans Company uses 35,000 yards of denim per year to make jeans. The cost of ordering denim from the textile company is $500 per order. It costs Western $0.35 per yard annually to hold a yard of denim in inventory. Determine the optimal number of yards of denim the Western Jeans Company should order, the minimum total annual inventory cost, the optimal number of orders per year, and the optimal time between orders. ( Ans: Q=10000 yards: TC=$3500; No. of orders=3.5 per year; Time between orders= 104.3)arrow_forwardThe Economic Order Quantity model enables O a. determination of safety stock O b. determining fixed order quantities O c. ordering items with dependent demand O d. determining fixed interval order quantities O e. ordering perishable itemsarrow_forwardThe Delta company uses three raw materials to make cakes. Delta is trying to reduce warehousing costs and establishes three policies to that end: i) The annual number of orders for all products must be at least 20 per contractual terms with transportation providers. ii) The average inventory in units must be a maximum of 1800. iii) Because the raw material is perishable, there can never be more than 2000 units in inventory of raw material 1. Raw material 2 has a maximum allowed of 1200 units and the raw material 3 can store maximum 400 units. The following table shows the product information: Materia Demanda Costos por unidad Costo por prima (u/año) ordenar ($) 2200 2 300 2 500 4 650 3 3000 10 100 Consider an interest rate of 10% per year. A) Formulate the problem as a mathematical programming model that minimizes the total annual cost. b) Represent the problem in a single equation including the constraints in terms of lambda c) Find the optimized batch sizes for the company's raw…arrow_forward
- A manager receives a forecast for next year. Demand is projected to be 600 units for the first half of the year and 920 units for the second half. The monthly holding cost is $2 per unit, and it costs an estimated $55 to process an order. a.Assuming that monthly demand will be level during each of the six-month periods covered by the forecast (e.g., 100 per month for each of the first six months), determine an order size that will minimize the sum of ordering and carrying costs for each of the six-month periods. (Round your answers to the nearest whole number.) Period Order Size 1 – 6 months?_____units 7 – 12 months?_____units b.If the vendor is willing to offer a discount of $10 per order for ordering in multiples of 50 units (e.g., 50, 100, 150), would you advise the manager to take advantage of the offer in either period? If so, what order size would you recommend? (Round intermediate calculations to 2 decimal places.) Period Order Size 1 – 6 months?____ units 7 – 12 months?____…arrow_forwardA company manufactures two products A and B. Each A requires two C’s and one D. Each D requires two F’s and one E, while each E requires one F. Each product B requires one D and two E’s. The table below shows data from the inventory records. ITEM ITEM ITEM ITEM DATA CATEGORY C D E F Lot - sizing rule Fixed Order Quantity = 220 Lot for Lot Fixed Order Quantity = 300 Period Order Quantity P = 2 Lead time 3 weeks 2 weeks 3 weeks 2 weeks Scheduled receipts 280 (week 1) None 300 (week 3) None Beginning inventory 25 0 150 600 The MPS for product A calls for 85 units to be started in week 3 and 100 units to be started in week 6. The MPS for product B calls for 180 units to be started in week 5.Develop the material requirements plan (showing Gross requirements, Scheduled receipts, On hand inventory, Net requirements, and Planned-order release) for the next six weeks for items C, D, E and F.arrow_forwardSingle-period. This type of problem can be recognized when a probability distribution or empirical Problem 8distribution for demand for a “perishable” item is given along with unit shortage and excess costs, orinformation that can be used to calculate them. Use these steps to solve the problem:1. Compute the optimal service level using Formula 13–17.2. If the given distribution is uniform or normal, use that to obtain the exact stocking level.3. If the distribution is Poisson or empirical, SL will fall between two cumulative frequencies.Round up to the higher frequency to find the optimal stocking level. Note: If the distribution isempirical, first obtain the cumulative frequencies or probabilities.A firm that installs cable TV systems uses a certain piece of equipment for which it carries two spareparts as optimal. The parts cost $500 each and have no salvage value or useful life after one period.Part failures can be modeled by a Poisson distribution with a mean of two failures during…arrow_forward
- L. Houts Plastics is a large manufacturer of injection-molded plastics in North Carolina. An investigation of the company's manufacturing facility in Charlotte yields the information presented in the table below. How would the plant classify these items according to an ABC classification system? (Round dollar volume to the nearest whole number and percentage of dollar volume to two decimal places.) Item number 2349 should be classified as Item Code 1289 2347 2349 2363 2394 2395 6782 7844 8210 8310 9111 Item number 8210 should be classified as L. Houts Plastics Charlotte Inventory Levels Avg. Inventory (units) Value ($/unit) 3.75 420 300 120 60 60 322576 20 12 4.00 2.50 1.80 1.75 2.25 1.15 2.05 2.00 2.00 3.00 Dollar Volume 1,200 300 105 23 25 % of Dollar Volume 34.72 8.68 3.04 0.67 0.71 14 18 3,456 For the following three questions, consider only items 1289, 2349, and 8210 from the above table for relative classification (these are some of the items for which you computed the metrics).…arrow_forwardXYZ’s Hardware is a small family business in Dubai, UAE. The owners, Abdullah and Omar,must use every square foot of store space as profitably as possible. They have never keptdetailed inventory or sales records. As soon as a shipment of goods arrives, the items areimmediately placed on store shelves. Invoices from suppliers are only kept for tax purposes.When an item is sold, the item number and price are rung up at the cash register. The ownersuse their own judgment in identifying items that need to be reordered.a). How could information systems help Abdullah and Omar run their business?b). What data should these systems capture?arrow_forwardWhich of the following can be said for the Production Order Quantity (PPC) model? Lütfen birini seçin: O a. Causes more stock than ESM model O b. Uses order cost instead of setup cost in the total inventory cost formula c. Eliminates the assumption that demand is known and fixed O d. Assumes one-time delivery of orders O e. ÜSM model is suitable if the product in stock is sold/used as it is producedarrow_forward
- Consider a two-stage plant-retailer supply chain. Lead time for orders is two weeks. Safety stock is equal to one week's demand, and future demand is estimated by the average of the past two weeks. 1. Develop production planning model (equations) for the retailer that states the order-up- to rule, and order quantities as a function of time. 2. Using a table format (Columns are Week, Starting retail inventory, On order, Order-up-to target, Order quantity, and Demand) track performance of the retailer for eight weeks if demand suddenly shifts from 100 units per week to 110 units per week starting in period 3 and stays at 110 to the end.arrow_forwardc. Once you find the optimal order quantity i.e., EOQ, create a Data Table that generates inventory cost within ±100 units (with 10units increment) from the optimal order quantity. For example, if the EOQ=150, then you need to generate Data Table for inventory cost starting from 50 to 250 with 10 increments. Explain the exact steps completed in excel to create the data table d. Create a Scatter plot with “smooth lines” for the Data Table created in c) to show the inventory cost. Label your plot clearly (axis and title). The optimum order quantity should indicate the minimum cost in your plot.arrow_forwardThe materials manager of a tire manfacturer must predict periodically place order for a key chemical one of the raw materials used in manufacturing uses the chemical at a rate of 300lbs each week and the lead time of delivery is 4 days. Assume that the manufacturing operation runs 5 days a week. At what point should the chemical be reorderedd a. when 1200lbs are remaining b. where 0lbs are remaining c. where 375lbs are remaining d. when 240lbs are remarrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Practical Management ScienceOperations ManagementISBN:9781337406659Author:WINSTON, Wayne L.Publisher:Cengage,
Practical Management Science
Operations Management
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:Cengage,