Ceramics Direct produces tiles for luxury flooring. The demand per month is 700 pounds of tile. Ceramics Direct can produce 1500 pounds of tile per month. Since the machinery gets dirty and must be cleaned before every batch the setup cost if $300. It cost $10 to produce one pound of tile. The inventory cost is 30% of annual cost. There can be a chance of backlogging. The two types are loss of goodwill, which is about $20 per pound. Shortage penalty is $1.50 per pound short every month. Find the economic order quantity, optimal backorder, and annual total cost of inventory.

Ceramics Direct produces tiles for luxury flooring. The demand per month is 700 pounds of tile. Ceramics Direct can produce 1500 pounds of tile per month. Since the machinery gets dirty and must be cleaned before every batch the setup cost if $300. It cost $10 to produce one pound of tile. The inventory cost is 30% of annual cost. There can be a chance of backlogging. The two types are loss of goodwill, which is about $20 per pound. Shortage penalty is $1.50 per pound short every month. Find the economic order quantity, optimal backorder, and annual total cost of inventory.

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

Problem 20-22 (Algo) Annual demand for a product is 16,120 units; weekly demand is 310 units with a standard deviation of 55 units. The cost of placing an order is $145, and the time from ordering to receipt is four weeks. The annual inventory carrying cost is $0.55 per unit. a. To provide a 90 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.) Reorder point____________ units ? b. Suppose the production manager is told to reduce the safety stock of this item by 80 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.) Service probability___________%
Develop a EOQ solution and calculate total relevant costs for the gross requirements in the following table*. Period 1 2 3 4 5 6 7 8 9 10 11 12 Gross requirements 20 30 30 30 20 10 40 60 *Holding cost =$ 2.50/unit/week; setup cost =$ 150; lead time =1 week; beginning inventory =40. What is the average demand per week? with 2 decimal places): Calculate Economic Order Quantity (EOQ) Develop a EOQ solution (enter your responses as whole numbers). Period 1 2 3 4 5 6 7 8 9 10 11 12 Gross requirements 20 30 30 30 20 10 40 60 Scheduled receipt…
Develop a lot-for-lot solution and calculate total relevant costs for the gross requirements in the following table*. Period 1 2 3 4 5 6 7 8 9 10 11 12 Gross requirements 30 30 40 70 30 10 70 50 *Holding cost =$ 3.50/unit/week; setup cost =$ 200; lead time =1 week; beginning inventory =40. Develop a lot-for-lot solution (enter your responses as whole numbers). Period 1 2 3 4 5 6 7 8 9 10 11 12 Gross requirements 30 30 40 70 30 10 70 50 On-hand at beginning of period 40 On-hand at end of period…
1. Demand for walnut fudge ice cream at the Sweet Cream Dairy can be approximated by a normal distribution with a mean of 21 gallons per week and a standard deviation of 5 gallons per week. The new manager desires a service level of 90 percent. Lead time is 8 days, and the dairy is open seven days a week. (Hint: Work in terms of weeks.) If the ROP model is used, what is the appropriate  safety stock level  to achieve the desired service level? Round to two decimal places. Answer: _________
The local supermarket buys lettuce each day to ensure really fresh produce. Each morning any lettuce that is left from the previous day is sold to a dealer that resells it to farmers who use it to feed their animals. This week the supermarket can buy fresh lettuce for $4.00 a box. The lettuce is sold for $16.00 a box and the dealer that sells old lettuce is willing to pay $2.50 a box. Past history says that tomorrow's demand for lettuce averages 252 boxes with a standard deviation of 34 boxes. How many boxes of lettuce should the supermarket purchase tomorrow? (Round your answer to the nearest whole number.)
Develop a lot-for-lot solution and calculate total relevant costs for the gross requirements in the following table*. Period 1 2 3 4 5 6 7 8 9 10 11 12 Gross requirements 30 30 30 60 30 20 70 60 *Holding cost=$3.50/unit/week; setup cost=$150; lead time=1 week; beginning inventory=40. Develop a lot-for-lot solution (enter your responses as whole numbers). Period 1 2 3 4 5 6 7 8 9 10 11 12 Gross requirements 30 30 30 60 30 20 70 60 Scheduled receipt Projected On-hand 40 enter your response here enter your response here enter your response here enter your response here enter your response here enter your response here…
Complete all work in EXCEL- show formula Demand for a popular athletic shoe is nearly constant at 800 pairs per week for a regional division of a national retailer. The cost per pair is $54. It costs $72 to place an order, and annual holding costs are charged at 22% of the cost per unit. The lead time is two weeks. a. What is the EOQ? b. What is the reorder point? c. What is the cycle time? d. What is the total annual cost?
The task I am struggling with. What percentage of cost of a Dell computer reflects inventory costs? Assume Dell’s yearly cost is 40% to account for the cost of capital for financing the inventory the warehouse space, and the cost of obsolescence. In other words Dell incurs a cost of $40 for a $ 100 component that is in the company’s inventory for one entire year. In 2001 Dells 10-k reports showed that the company had $400 million in inventory and COGS of $ 26.442 millionThank you very much for your help.
Current decision to buy: Ross White's machine shop uses 300 brackets each month during the course of a year. This usage is relatively constant throughout the year. Currently, these brackets are purchased from a supplier 100 miles away for $25 each and the lead time is 2 days. The holding cost per bracket per year is $3.75 (15% of the unit cost) and the annual ordering cost per order is $18.50. There are 240 working days per year. Possible future decision to make in-house: Ross White is reconsidering his decision of buying the brackets and is considering making the brackets in-house. He has determined the set up costs would be $22.50 in machinist time and lost production time. Forty eight brackets could be produced in a day once the machine has been set up. Ross estimates that the cost (including labor and materials) of producing one bracket would be $22.85. The holding cost would be 12% of the cost. What is the EOQ given Ross' current decision to buy the brackets? What is the…
FlyUs Airlines is unhappy with the number of empty seats onits New York to Philadelphia flight. To remedy the problem,the airline is offering a special discounted rate of $89 insteadof the normal $169, but only for 7-day advance purchasesand for a limited number of seats per flight. The aircraftflown from NY to Philly holds 100 passengers. Last month’sdistribution of full-fare passengers is shown below. Howmany seats should FlyUs reserve for full-fare passengers?
The local supermarket buys lettuce each day to ensure very fresh produce. Each morning, any lettuce that is left from the previous day is sold to a dealer that resells it to farmers who use it to feed their animals. This week, the supermarket can buy fresh lettuce for $4 a box. The lettuce is sold for $10 a box and the dealer that sells old lettuce is willing to pay $1.50 a box. Past history says that tomorrow’s demand for lettuce averages 250 boxes, with a standard deviation of 34 boxes. How many boxes of lettuce should the supermarket purchase tomorrow?
What is the level total Production Rate? Answer units (b) What is the maximum quantity subcontracted and in which period? Quantity-Answer and Period-Answer (c) What is the maximum quantity backlogged and in which period? Quantity-Answer and Period-Answer (d) What is the total regular production cost? $Answer (e) What is the total overtime cost? $Answer (f) What is the total subcontracting cost? $Answer (g) What is the total inventory carrying cost? $Answer (h) What is the total backorder cost? $Answer (i) What is the total aggregate plan cost? $Answer