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…
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).
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?
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 optimal quantity of coal to receive in each order.
Perform an ABC analysis on the following set of products Item Annual Demand Unit Cost A211 800 R9 B390 100 R90 C003 450 R6 D100 400 R100 E707 85 R2000 F660 250 R320 G473 500 R75 H921 100 R75
Micro-Electronics Warehouse Headset and Webcam Sale Item Type Reg. Price After Savings Price BuddyChat 200 Headset $34.72 $24.40 BuddyChat 300 Headset $41.27 $34.91 BuddyCam HD Webcam $83.54 $61.46 You have decided to purchase the headset with the greatest markdown percent and the BuddyCam HD webcam in order to take advantage of an "Extra $15 Rebate" offer when you purchase both. What is the markdown percent on your total purchase including the rebate?
A retailer uses a periodic review order-up-to model to control the inventory of one of its high volume products. Average demand is 2580 units per week with a standard deviation of 1270. The review period is 5 weeks, the lead time is 11 weeks, and the safety factor used is 0.61. How many stockouts should the retailer expect for this product next year?

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