3. A company which produces a single product has definite orders for this product over the next six months as follows: 1 3 4 5 Month 2 Demand 350 680 475 590 460 6 390 The company ended the previous month (month 0) with an inventory of 200 units, and the previous month production level was 400 units. The company wishes to end this six-month planning period with an inventory of at least 50 units. It costs $3.50 per unit to increase the production level from one month to the next, and $6.00 per unit to decrease it. The cost of holding inventory from one month to the next is $4.80 per unit per month. No shortages are permitted. In each month, the company wants to produce an integer number of units. The company wishes to minimize the sum of production level change costs and inventory costs over the six-month planning horizon.

3. A company which produces a single product has definite orders for this product over the next six months as follows: 1 3 4 5 Month 2 Demand 350 680 475 590 460 6 390 The company ended the previous month (month 0) with an inventory of 200 units, and the previous month production level was 400 units. The company wishes to end this six-month planning period with an inventory of at least 50 units. It costs $3.50 per unit to increase the production level from one month to the next, and $6.00 per unit to decrease it. The cost of holding inventory from one month to the next is $4.80 per unit per month. No shortages are permitted. In each month, the company wants to produce an integer number of units. The company wishes to minimize the sum of production level change costs and inventory costs over the six-month planning horizon.

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

Company XYZ, Inc. purchases widgets from a supplier at a cost of $20 per unit and sells the widgets for $30 per unit. By the end of Spring, demand for these widgets subsided considerably and all widgets that weren't sold during the Spring can be sold at a discounted price of $18 per unit. The company estimates demand during quarter two (Q2) to be normally distributed with mu = ? = 10,000 and sigma = ? =1525 boxes What is the optimal stockout probability for company XYZ, Inc.?
15) JBs needs to determine what quantity of a new tennis racquet to order for the upcoming summer season. They sell the racquet for $110 and procure it from their supplier for $70. Any leftovers will be marked down 60% and are expected to all sell at that price. Anticipated demand is modeled with a normal distribution where the mean is 120 and the standard deviation is 25. How many racquets should JBs order if they want to meet a 95% target fill rate? A) 130 C) 162 B) 127 D) 149
X1=29000 X2=5 I need a step by step answer please (not on excel please)
I want the answer
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…
1. Suppose the demand of a product in a retail store is 800 per year and it occurs at a constant rate. Placement of an order of this product to an outside supplier by the store is 40 Dollar. The super market authority has calculated the inventory holding cost per unit per year as 90 cents. Assuming no occurrence of shortages of the product, find a) i. the minimal order quantity of the product from the outside supplier if the product is not allowed to sell during production. ii. the minimal number of orders per year. Explain whether the nearest integer number of orders per year is justified. iii. the cycle time of a lot in months. iv. the annual minimal total cost of ordering and inventory holding for that minimal order quantity. v. the reorder point if the lead time of delivering a lot is 2 days,? b) If the production rate of processing the product is 1200 per year and the set up cost per set up is 65 Dollar. If the selling of the product is allowed during production, determine i) the…
"Nordlund Boat Company has been repairing, refitting, and building custom boats. for over 60 years in the Pacific Northwest." The company is located in Tacoma, Washington. One of the engine's most critical components is the exhaust manifolds. The company purchases this item from the best manufacturers in the world. TJ is the buyer in charge of managing this item. TJ's purchasing agent currently submits an order release for this item every 4 weeks. The company's annual demand is 400 units (2 units per working day). Nordlund's relatively low volume and quality focus, rather than volume focus, means the company cannot take advantage of quantity discounts. The supplier has agreed to deliver this item within 1 week following an order release. For this reason, Nordlund has never had a shortage of exhaust manifolds. The total time between the release date and date of receipt is 1 week or 5 working days. The accounting has generated the following inventory-related costs. Procurement costs…
Algro Inc. keeps a wide range of parts and materials on hand for use in its production processes. Management has recently had difficulty managing parts inventory as demand for its finished goods has increased; they frequently run out of some critical parts while having an endless supply of others. They would like to classify their parts inventory according to the ABC approach to better control inventory. The following is a list of parts, along with their annual usage and unit value: Item Annual Unit Item Annual Unit Number Usage Cost Number Usage Cost 1 36 $350 2 510 30 3 50 23 4 300 45 5 18 1900 6 500 8 7 710 4 8 80 26 9 344 28 10 67 440 11 510 2 12 682 35 13 1216 95 50 14 10 3 15 820 1 KARAN2222222222 16 60 $610 17 120 20 18 270 15 19 45 50 20 19 3200 21 910 3 12 4750 23 30 2710 24 24 1800 25 870 105 26 244 30 27 750 15 28 45 110 29 46 160 30 165 25 a. Classify the inventory items according to the ABC approach using the dollar value of annual demand. b. Clearly explain why you…
Magdeleine James is a sole trader, who sells souvenir T-shirts. She wishes to sell her T-shirts at the Tobago Jazz festival. Each t-shirt cost $165 to produce and sells for $225. After the festival, she reduces the sale price of the T-shirts by 70% in order to sell them off. Experience from previous years has shown that the demand for these T-shirts at the festival is 82, with a standard deviation of 21. How many T-shirts should Magdeleine take to sell at the festival?
BicycleBro is a retailer that sells bicycles. The company had been operating for 30 days (1 month). By the end of 1 month it wants to measure its performance in terms of Inventory turnover and Days of inventory. Below is the information that the company has collected from its warehouse and accounting department Stock Count Sheet Item code Stock on hand Stock count week (week number when employees counted the stock on hand) 100 30 week1 200 10 week1 100 10 week3 200 20 week3 Inventory valuation Item code Value per unit (in $) 100 1000 200 2000 Bicycles sold by end of month Item code Units sold 100 5 200 10 Given the information above find What is the total inventory turnover rate for given period? What is the total Inventory Days of Sales for given period?
A firm produces three products. Product A sells for $60; its variable costs are $20. Product B sells for $200; its variable costs are $120. Product C sells for $25; its variable costs are $10. Last year, the firm sold 1000 units of A 2000 units of B, and 10,000 units of C The firm has fixed costs of $320,000 per year. Calculate the break-even point of the firm.
An airline company offers four fairs as shown in the table below. The demand distribution for each fare is normal with mean and standard deviation as given in the table. Find an estimate of the protection levels for the classes using the heuristic EMSR-a. Note:- Do not provide handwritten solution. Maintain accuracy and quality in your answer. Take care of plagiarism. Answer completely. You will get up vote for sure.