7. A Spanish company is considering moving manufacturing from Spain to Mexico.3 hours of labor are needed to make the item with Spanish cost of labor 25 Eurosper hour and Mexican 5 per hour. Spanish holding cost per week is 2 Euros andMexican 1.5 Euros. Orders are placed weekly and lead time in Spain is 3 weeks withMexican lead time 15 weeks. Demand is normally distributed with mean 500 andstandard deviation 100 and they use 3 standard deviations as the safety factor.A) If it keeps production in Spain, on average how many units of inventory will ithave on hand and on order?B) If it moves production to Mexico, on average how many units will it have on handand on order?C)ln Spain, what is its holding cost per item?D) In Mexico, what is its holding cost per item?E) What would be the change in cost per item is production is moved from Spain toMexico?

Given data: Average demand per period D = 500 Lead time L = 3 week SD of demand per…

Answered: 7. A Spanish company is considering…

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 33P: Assume the demand for a companys drug Wozac during the current year is 50,000, and assume demand...

See similar textbooks

Similar questions

7. A Spanish company is considering moving manufacturing from Spain to Mexico. 3 hours of labor are needed to make the item with Spanish cost of labor 25 Euros per hour and Mexican 5 per hour. Spanish holding cost per week is 2 Euros and Mexican 1.5 Euros. Orders are placed weekly and lead time in Spain is 3 weeks with Mexican lead time 15 weeks. Demand is normally distributed with mean 500 and standard deviation 100 and they use 3 standard deviations as the safety factor. A) If it keeps production in Spain, on average how many units of inventory will it have on hand and on order? B) If it moves production to Mexico, on average how many units will it have on hand and on order? C)In Spain, what is its holding cost per item? D) In Mexico, what is its holding cost per item? E) What would be the change in cost per item is production is moved from Spain to Mexico?
1. The demand for a product of Carolina Industries varies greatly from month to month. Based on the past three years of data, the following shows the monthly demand at Carolina Industries. Unit Demand # Months 300 6 400 8 500 12 600 10 A.If the company places monthly orders equal to the expected value of the monthly demand, what should Carolina’s monthly order quantity be for this product? B. What are the variance and the standard deviation for the number of units demanded?
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
Weekly demand for a certain type of automotive spark plug in a local repair shop is normallydistributed with mean 34 and standard deviation 12. Procurement lead time is six weeks.Determine the lead time demand distribution.
Q: A hardware company stocks nuts and bolts and orders them from a local supplier once every 2 weeks (10 working days). Lead time is 2 days. The company has determined that the average demand for 1⁄2 inch bolts is 150 per week (5 working days), and it wants to keep a safety stock of 3 days’ supply on hand. An order is to be placed this week, and the stock on hand is 130 bolts.a. What is the target level?b. How many 1⁄2 inch bolts should be ordered this time?
The following table contains figures on the monthly volume and unit costs for a random sample of 16 items from a list of 2,000 inventory items at a health care facility. Transcribed Image Text: Item Unit Cost Usage Item Unit Cost Usage K34 $10 200 F99 20 60 K35 25 600 D45 10 550 K36 36 150 D48 12 90 M10 16 25 D52 15 110 M20 20 40 08 200 D57 120 245 80 NO8 30 40 F14 20 300 PO5 16 500 F95 30 800 P09 10 30 a-Develop an A-B-C classification for these items. b-Given the monthly usages in the following table, classify the items in A, B, and C categories according to dollar usage. c- Determine the percentage of items in each category and the annual dollar value for each category for part b.
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.50 a copy. You sell a copy of San Pedro Times for $1.25. Daily demand is distributed normally with mean = 335 and standard deviation = 67. 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 α-level. Round your z-value to 2 decimal places and final answer to to 2 decimal places.) b. Based on a, what is the probability that you will run out of stock? (Round your answer to the nearest whole number.)
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)
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?
a. Mr. Mashabela operates a small novelty shop. Each morning he purchases a small quantity of daily computerized horoscopes at a cost of R15.00 per item. He resells them later in the day for R25.00 per horoscope. For the past 200 days, Mr. Mashianoke's demand has been 6 items on 60 days, 7 items on 60 days, 8 items on 40 days, 9 items on 20 days and 10 items on 20 days. The horoscopes come in packages of 2, which forces Mr. Mashabela to purchase an even number, and the horoscopes are salable for one day only. At the end of each working day, however, Mr. Mashabela can sell any remaining horoscopes to a night-own peddler for R10.00 per item. i) Set up the payoff matrix for the above problem. ii) Assuming the probabilities of the occurrence of the state of nature is unknown, how many computerized horoscopes should the decision maker purchase based on opportunistic loss? i) Using the expected monetary value approach, determine how many computerized horoscopes should Mr. Mashabela purchase.…
c) Dtee operates a small novelty shop. Each morning she purchases a small quantity of daily computerized horoscopes at a cost of R15.00 per item. She resells them later in the day for R25.00 per horoscope. For the past 200 days, Dtee's demand has been 6 items on 60 days, 7 items on 60 days, 8 items on 40 days, 9 items on 20 days and 10 items on 20 days. The horoscopes come in packages of 2, which forces Dtee to purchase an even number, and the horoscopes are saleable for one day only. At the end of each working day, however, Dtee can sell any remaining horoscopes to a night-town peddler for R10.00 per item. Set up the pay-off matrix for this problem.
13 Pam’s demand for hats is normally distributed with mean 500 and standard deviation 100. She sells her hats for $50 each and buys hats for $10 each, and anything she can't sell by the end of the year, the wholesaler will buy for $5 each. How many hats should she order for next year to maximize profit?

SEE MORE QUESTIONS

Recommended textbooks for you

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

SEE MORE TEXTBOOKS