Please do it by hand. Not in Excel 3. A large producer of household products purchases a glyceride used in one of its deodorantsoaps from outside of the company. It uses the glyceride at a fairly steady rate of 40pounds per month, and the company uses a 23 percent annual interest rate to computeholding costs. The chemical can be purchased from a supplier who offers the followingall-units discount schedule:Order SizePrice per pound0≤Q<500500≤Q<1,000$1.30$1.201,000≤Q$1.101Assume that the cost of order processing is $150. What is the optimal order quantity andthe corresponding annual total cost?(show your calculations)

Given information:- Usage rate = 40 pounds/month = 480 pounds/year- Annual interest rate = 23% for…

Answered: 3. A large producer of household…

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

3
14. 12 The purchasing manager for the Atlantic Steel Company must determine a policy for ordering coal to operate 12 converters. Each converter requires exactly 5 tons of coal per day to operate, and the firm operates 360 days per year. The purchasing manager has determined that the ordering cost is $80 per order and the cost of holding coal is 20% of the average dollar value of inventory held. The purchasing manager has negotiated a contract to obtain the coal for $12 per ton for the coming year. a. Determine the optimal quantity of coal to receive in each order. (Ans: 1200 tons) b. Determine the total inventory-related costs associated with the optimal ordering policy (do not include the cost of the coal). (Ans: TC= $2880) c. If 5 days of lead time are required to receive an order of coal, how much coal should be on hand when an order is placed? (Ans= R=300 tons)
A company is planning to purchase 10,000 units of a particular item in the year ahead. The item is purchased in boxes each containing 10 units of the item, at a price of €400 per box. The cost of holding an item in inventory for a year (including insurance, interest and space costs) is 10% of the purchase price. The cost of placing and receiving orders is to be estimated from cost data collected relating to similar orders, where costs of €7,000 were incurred on 25 orders. It should be assumed that ordering costs change in proportion to the number of orders placed. 5% should be added to the above ordering costs to allow for inflation. Assume that usage of the item will be even over the year. Required: (a) Calculate the economic order quantity (EOQ) in boxes which minimises total costs (b) Outline when and why it is appropriate to use economic batch quantity (EBQ)
As with other products, Fisher-Price faces the decision of how many Weather Teddy units to order for the comingholiday season. Members of the management team suggested order quantities of 15,000, 18,000, 24,000, or28,000 units. The wide range of order quantities suggested indicates considerable disagreement concerning themarket potential. The product management team asks you for an analysis of the stock-out probabilities forvarious order quantities, an estimate of the profit potential, and to help make an order quantity recommendation.Fisher-Price expects to sell Weather Teddy for $24 based on a cost of $16 per unit. If inventory remains afterthe holiday season, Fisher-Price will sell all surplus inventory for $5 per unit. After reviewing the sales historyof similar products, Fisher-Price’s senior sales forecaster predicted an expected demand of 20,000 units with a.95 probability that demand would be between 10,000 units and 30,000 units. Question: One of Fisher-Price’s managers felt…
As with other products, Fisher-Price faces the decision of how many Weather Teddy units to order for the comingholiday season. Members of the management team suggested order quantities of 15,000, 18,000, 24,000, or28,000 units. The wide range of order quantities suggested indicates considerable disagreement concerning themarket potential. The product management team asks you for an analysis of the stock-out probabilities forvarious order quantities, an estimate of the profit potential, and to help make an order quantity recommendation.Fisher-Price expects to sell Weather Teddy for $24 based on a cost of $16 per unit. If inventory remains afterthe holiday season, Fisher-Price will sell all surplus inventory for $5 per unit. After reviewing the sales historyof similar products, Fisher-Price’s senior sales forecaster predicted an expected demand of 20,000 units with a.95 probability that demand would be between 10,000 units and 30,000 units. Compute the probability of a stock-out for the…
Understanding how to use fx rates Centria Bakery from Kokkola, Finland, has become recently very popular with its chocolate cakes made from raw chocolate ingredients from a Swiss chocolate company Chocolaté Fin SARL (Switzerland). For the holiday season, Centria Bakery intends to prepare at least 1 000 chocolate cakes so it needs to buy some delicate raw chocolate for 10 000 CHF to pay its Swiss chocolate supplier. Nordea banker quotes bid-ask rates of 1.3990-1.4000 CHF/EUR. (euro is the base currency). What is Centria Bakerys euro cost of the 10 000 Swiss francs for the raw chocolate? Give your answer with two decimals. 5 232,60 13 990,00 7 147,96 6 142,85
3. Daily demand for tablets of amazon is normally distributed, with a mean of 100 and standard deviation of 30. The tablet supplier takes an average of 15 days to replenish inventory at Amazon. The standard deviation of the supplier lead time is 5 days. Amazon follows a "periodic review policy" with a review period of 30 days. Amazon is targeting a CSL of 98% for its tablet inventory. (a) What is the mean demand during lead time and review period? What is the standard deviation of demand during lead time and review period? (c) What is the safety (b) stock (in units) during lead time and review period?
Teddy Bower is an outdoor clothing and accessories chain that purchases a line of parkas at $10 each from its Asian supplier, TeddySports. Unfortunately, at the time of the order placement, demand is still uncertain: Teddy Bower forecasts that its demand is normally distributed with a mean of 1800 and a standard deviation of 1000. Teddy Bower sells these parkas at $22 each. Unsold parkas have little salvage value; Teddy Bower simply gives them away to a charity (and also doesn't collect a tax benefit for the donation). How many parkas should Teddy Bower buy from TeddySports to maximize expected profit? (please use the normal distribution table and round up to the nearest integer).
That One Book sells its books through The Witch and the Wardrobe bookstores. It costs That One Book $0.80 to print each book; it sells the book to The Witch and the Wardrobe for $2.50. The Witch and the Wardrobe then sells the books at retail for $6.00. Whatever doesn’t sell gets thrown away. Demand for the book each issue is normal with a mean of 5219 and a standard deviation of 1610. To give The Witch and the Wardrobe incentive to order more books, it proposes a revenue-sharing contract. Instead of selling the book to The Witch and the Wardrobe for $2.50, That One Book will sell its books to The Witch and the Wardrobe for only $1.00. However, for each book that The Witch and the Wardrobe sells at retail, The Witch and the Wardrobe must give $2.00 back to That One Book. With this revenue sharing agreement in place, what is the optimal order amount that will maximize The Witch and the Wardrobe expected profit? Please do fast ASAP
Problem 20-10 (Algo) You are a newsvendor selling San Pedro Times every morning. Before you get to work, you go to the printer and buy the day's paper for $0.30 a copy. You sell a copy of San Pedro Times for $1.10. Daily demand is distributed normally with mean = 265 and standard deviation = 53. At the end of each morning, any leftover copies are worthless and they go to a recycle bin. a. How many copies of San Pedro Times should you buy each morning? (Use Excel's NORMSINV() function to find the correct critical value for the given a-level. Round your z-value to 2 decimal places and final answer to to 2 decimal places.) Optimal order quantity b. Based on a, what is the probability that you will run out of stock? (Round your answer to the nearest whole number.) Probability
The purchasing manager for the Atlantic Steel Company must determine a policy for orderingcoal to operate 12 converters. Each converter requires exactly 5 tons of coal per day to operate,and the firm operates 360 days per year. The purchasing manager has determined that the orderingcost is $80 per order and the cost of holding coal is 20% of the average dollar value of inventoryheld. The purchasing manager has negotiated a contract to obtain the coal for $12 per ton forthe coming year. Determine the total inventory-related costs associated with the optimal ordering policy (do not include the cost of the coal).
The purchasing manager for the Atlantic Steel Company must determine a policy for orderingcoal to operate 12 converters. Each converter requires exactly 5 tons of coal per day to operate,and the firm operates 360 days per year. The purchasing manager has determined that the orderingcost is $80 per order and the cost of holding coal is 20% of the average dollar value of inventoryheld. The purchasing manager has negotiated a contract to obtain the coal for $12 per ton forthe coming year. If 5 days of lead time are required to receive an order of coal, how much coal should be on hand when an order is placed?

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