=15. Suppose that Westside Auto of Problem 4, with D = 12,000 units per year, Ch(2.50)(0.20) = $0.50, and Co = $25, decided to operate with a backorder inventory policy.Backorder costs are estimated to be $5 per unit per year. Identify the following:a. Minimum cost order quantityb.Maximum number of backordersC.Maximum inventoryd. Cycle timee. Total annual cost

Given data: Annual demand (D) = 12000 units Ordering cost (Co) = $25,Holding cost (Ch) = $0.50,…

Answered: 15. Suppose that Westside Auto of…

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

DETERMINING INVENTORY MODELS FSYHILD is a manufacturing company of made to order face shield. It is producing products at a constant rate with a requirement of 5,500 face shields per quarter throughout the year. If ordering costs are P35.00 per order, unit cost is P10.00 per face shield, and annual inventory holding cost are charged at 30% of the units cost. A. What is the EOQ for this component? B. What is the expected time between orders? C. What are the total annual inventory and holding cost associated with your EOQ recommendation? D. Assuming a lead time of 5 days, what is the reorder point? E. What is the total cost if the management decides to increase the demand by 75%?
Reorder Point Ordering: Average demand per day () is 25 units, with a std. dev. of (od) 15 units. Lead time (LT) is 49 days. Find demand during lead time (DDL), safety stock (SS) and reorder point (ROP ) for 4-sigma (z = 4). DDL= 500 units, SS = 1225 units, ROP = 1645 units DDL= 1,645 units, SS=420 units, ROP = 1225 units DDL= 1,225 units, SS = 420 units, ROP = 1645 units DDL= 0 units, SS = 1225 units, ROP = 420 units DDL= 420 units, SS = 1645 units, ROP = 420 units
Year Cost of Good Sold Beginning Inventory (In Pesos) Ending Inventory (In Pesos) 1 503,425 10,300 12,400 2 643,056 12,400 11,200 3 690,432 11,200 10,670 4 734,509 10,670 11,200 5 758,734 ? 10,987 REQUIRED Determine the inventory turnover for year 5. Determine the number of days the finished goods stay in inventory in Year 1. There was no improvement in inventory turnover in Year 5 compared to Year 1. This statement is not correct. Write YES or NO for the answer
Famous Albert prides himself on being the Cookie King of the West. Small, freshly baked cookies are the specialty of his shop. Famous Albert has asked for help to determine the number of cookies he should make each day. From an analysis of past demand, he estimates demand for cookies as DEMAND PROBABILITY OF DEMAND 1,800 dozen 0.05 2,000 0.10 2,200 0.20 2,400 0.30 2,600 0.20 2,800 0.10 3,000 0.05 Each dozen sells for $0.69 and costs $0.49, which includes handling and transportation. Cookies that are not sold at the end of the day are reduced to $0.29 and sold the following day as day-old merchandise. Compute the expected profit or loss for each cookie making decision quantity. (Round your answers to the nearest whole number. Enter expected losses with a negative sign) Based on your answers to part a., what is the optimal number of cookies to make? By using marginal analysis, what is the optimal number of cookies to make?
Using the gross requirements schedule below*, prepare an alternative ordering system that always orders 100 units the week prior to a shortage (a fixed order quantity of 100). What is the cost of this ordering system? D Period 1 2 3 Gross requirements 35 30 40 4 5 6 7 8 9 10 0 10 40 30 0 30 55 *Holding cost = $1/unit/week; setup cost = $100; lead time = 1 week; beginning inventory = 35 units. Prepare a net requirements plan (enter your responses as whole numbers). The holding cost of this ordering system is $ The setup cost of this ordering system is $ The total cost of this ordering system is $ Period Gross requirements On-hand at beginning of period 35 On-hand at end of period Net requirements Order receipt Order release (enter your response as a whole number). (enter your response as a whole number). (enter your response as a whole number). 1 35 2 3 30 40 4 0 7 8 9 10 0 30 55 5 6 10 40 30
Catlea Merchandising is engaged in selling school shoesfor both boys and girls in their teenage years. Catlea needs 32,000 pairs of shoes in a year in order to satisfy the market demand. It costs ₱ 48 to place an order while ₱ 8 is needed to hold each quantity of shoe in Catlea's inventory. Upon checking on Catlea's supplier, it takes 8 days in between placing an order and eventually receiving it. a. Determine the Economic Order Quantityb. Determine the number of order per monthc. Determine the reorder point
Economic Order Quantity and Reorder PointFind the economic order quantity and the reorder point, givenAnnual demand ( D )= 1, 000 unitsAverage daily demand ( d¯ ) = 1, 000 ∕365ordering cost ( S ) = $5 per orde rHolding cost ( H ) = $1.25 per unit per yearLead time ( L ) = 5 daysCost per unit ( C ) =$12.50What quantity should be ordered?
1. William Beville's computer training school, in Richmond, stocks workbooks with the following characteristics: Demand D Ordering cost S Holding cost H = 19,500 units/year = $25/order = $4/unit/year a) Calculate the EOQ for the workbooks.
Problem 13-16 The McDonald's fast-food restaurant on campus sells an average of 4,800 quarter-pound hamburgers each week. Hamburger patties are resupplied twice a week, and on average the store has 465 pounds of hamburger in stock. Assume that the hamburger patties cost $3 a pound and there are 52 weeks in a year. a. What is the inventory turnover for the hamburger patties? (Round your answer to 2 decimal places.) Inventory turnover per year b. On average, how many days of supply are on hand? (Do not round intermediate calculations. Round your answer to 2 decimal places.) Average days of supply
Thomas' Bike Shop, with a 250 day working year, stocks a high-volume item. The average daily demand is 7p units, the lead time is 4 days, and sometimes may take up to 5 days. a. Calculate the re-order point without safety stock. b. Calculate the re-order point with safety stock.
UNCERTAIN DEMAND Lead time demand for an item averages 100 units, with a standard deviation of 30. The order quantity is 200 units. Management desires that 99 percent of all demand be met from stock. a) What is the optimal order point? b) Suppose management wanted a 98 percent service level; what would be optimal order point be c)Suppose management wanted 90 service level. Compute the optimal order point
please Solve question G,H AND I Question A to F IS SOLVED (a) What is the expected jet fuel yearly average demand D? =4160 tons(b) Given D, find the order lot size Q that gives the economic order quantity (EOQ). =60.39 unit(c) Given the EOQ, what is the total inventory holding cost?= $1067695.2(d) Given the EOQ, what is the total inventory ordering cost? =OC=$1067726.4(e) Given the EOQ, what is the total annual inventory cost?TIC=2135421.6 =1.32(f) What is the time between orders in weeks? = 39.39 The airport is convinced that placing an order every season (every P = 13weeks) will be best. It is also aware that the expected demand will varywith a standard deviation of 20 tons, so it needs to take this information into account. (g) What is the protection period required by the proposed 13-week periodic review system?(h) The airport is required by the airlines to maintain a 99.75% service level.What is the required safety stock?(i) Calculate the order size (Q) when using P = 13.(j)…

SEE MORE QUESTIONS

Recommended textbooks for you

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Operations Management

ISBN:

9781259667473

Author:

William J Stevenson

Publisher:

McGraw-Hill Education

Operations and Supply Chain Management (Mcgraw-hi…

Operations Management

ISBN:

9781259666100

Author:

F. Robert Jacobs, Richard B Chase

Publisher:

McGraw-Hill Education

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Operations Management

ISBN:

9781259667473

Author:

William J Stevenson

Publisher:

McGraw-Hill Education

Operations and Supply Chain Management (Mcgraw-hi…

Operations Management

ISBN:

9781259666100

Author:

F. Robert Jacobs, Richard B Chase

Publisher:

McGraw-Hill Education

Business in Action

Operations Management

ISBN:

9780135198100

Author:

BOVEE

Publisher:

PEARSON CO

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

Production and Operations Analysis, Seventh Editi…

Operations Management

ISBN:

9781478623069

Author:

Steven Nahmias, Tava Lennon Olsen

Publisher:

Waveland Press, Inc.

SEE MORE TEXTBOOKS