A company needs to schedule the monthly production of a certain item for the next 4 months. The unit production cost is estimated to be $12 for the first 2 months and $14 for the last two months. The monthly demands are 750, 1000, 850 and 950 units. The company can increase the monthly production during the second and third months by utilizing overtime. The increase in production by this measure is limited to 400 units per month, and costs an extra $4 per unit. The regular production capacity is 1000 units/month. Excess production can be stored at a cost of $3 per unit per month, but a maximum of 50 units can be stored in any month. Assuming that the beginning and ending inventory levels are zero, formulate this problems as an LP model so that the total cost s minimized.

A company needs to schedule the monthly production of a certain item for the next 4 months. The unit production cost is estimated to be $12 for the first 2 months and $14 for the last two months. The monthly demands are 750, 1000, 850 and 950 units. The company can increase the monthly production during the second and third months by utilizing overtime. The increase in production by this measure is limited to 400 units per month, and costs an extra $4 per unit. The regular production capacity is 1000 units/month. Excess production can be stored at a cost of $3 per unit per month, but a maximum of 50 units can be stored in any month. Assuming that the beginning and ending inventory levels are zero, formulate this problems as an LP model so that the total cost s minimized.

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

A manufacturer has a production facility that requires 15,604 units of component JY21 per year. Following a long-term contract, the manufacturer purchases component JY21 from a supplier with a lead time of 7 days. The unit purchase cost is $25.6 per unit. The cost to place and process an order from the supplier is $121 per order. The unit inventory carrying cost per year is 10.5 percent of the unit purchase cost. The manufacturer operates 250 days a year. Assume EOQ model is appropriate. If the manufacturer uses a constant order quantity of 2,640 units per order, what is the annual holding cost? Use at least 4 decimal places.
You are asked to help your boss deciding who is considering whether to make or buy a part fora top most demanding product of the company.Your company can make the component for $40 per unit or buy it for $50 per unit from vendor.If the Company decides to make the component, it will require 4 hours of machine time tomake each part. The company has 2,000 hours of machine time available per month. Shouldthe company make or buy the component? How many max parts company can make?________________________________________________________________
Boston Company use a special part in manufacturing of its finished products. The unit cost thisspecial part is $ 35, and details of its manufacturing cost is as follows. The $35 unit productcost of this part is based on average 25,000 number of parts produced each year.An outside supplier has offered to supply the 25,000 parts at a cost of $30 per part. The specialequipment used to manufacture the above part. This equipment can only be used formanufacturing of this part and if not used it has no resale value.The total amount of general factory overhead, which is allocated based on direct labor-hours,would be unaffected by this decision because it is fixed cost..Suggest the management whether to stop producing internally and buy them from theoutside supplier?Description CAD Direct Materials 10Direct Labor 6Variable overheads…
2.28 A foundry produces castings to order. An order for 20 special castings has been re- ceived. Since the casting process is highly variable, not all castings produced are good. The cost of producing each casting is $550; the additional cost of finishing a good casting is $125. If a casting is not good, it is recycled at a value of $75; excess good castings are not finished but are recycled at a value of $75. The customer has agreed to accept 15, 16, 17, 18, 19, or 20 castings at a price of $1250 each. If fewer than 15 good castings are produced, none will be purchased by the customer. Prob- ability distributions for the number of good castings produced in a batch of varying sizes are given below. How many castings should be scheduled in order to maximize expected profit? #Good Castings 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 79 2 PRODUCT, PROCESS, AND SCHEDULE DESIGN Number of Castings Scheduled 15 16 17 0.05 0.00 0.00 0.00 0.00 0.00 0.05 0.05 0.00…
Products A,B, and C are sold door-to-door. A costs $ 3 per unit, take 10 minutes to sell (on the average) and costs $0.50 to deliver to customer. B costs $ 5, takes 15 minutes to sell, and is left with the customer at the time of sale. C costs $ 4, takes 12 minutes to sell, and costs $ 1 to deliver. During any week, a salesperson is allowed to draw up to $ 500 worth of A,B,C (at cost) and is allowed delivery expenses not to exceeds $ 75. If a salesperson’s selling time is not expected to exceed 30 hours (1,800 minutes) in a week, and if the salesperson profit (net after all expenses) is $ 1 each on a unit of A and B and $ 2 on a unit of C, what combination of sales of A, B, and C will lead to maximum profit, and what is the maximum profIt?
The Delta company uses three raw materials to make cakes. Delta is trying to reduce warehousing costs and establishes three policies to that end: i) The annual number of orders for all products must be at least 20 per contractual terms with transportation providers. ii) The average inventory in units must be a maximum of 1800. iii) Because the raw material is perishable, there can never be more than 2000 units in inventory of raw material 1. Raw material 2 has a maximum allowed of 1200 units and the raw material 3 can store maximum 400 units. The following table shows the product information: Materia Demanda Costos por unidad Costo por prima (u/año) ordenar ($) 2200 2 300 2 500 4 650 3 3000 10 100 Consider an interest rate of 10% per year. A) Formulate the problem as a mathematical programming model that minimizes the total annual cost. b) Represent the problem in a single equation including the constraints in terms of lambda c) Find the optimized batch sizes for the company's raw…
A manufacturing cell makes three models of a product – AKC1011, BC0001, and AC0102. The daily demand for the three products are as follows: 200 of AKC1011, 500 BC0001, and 300 of AC0102. Develop a balanced mixed-model sequence that should be repeated throughout the day in order to meet demand.
Barbara Flynn sells papers at a newspaper stand for $0.40. The papers cost her $0.30, giving her a $0.10 profit on each one she sells. From past experience Barbara knows that: a) 20% of the time she sells 150 papers. b) 20% of the time she sells 200 papers. c) 30% of the time she sells 250 papers. d) 30% of the time she sells 300 papers. Assuming that Barbara believes the cost of a lost sale to be $0.05 and any unsold papers cost her $0.30 and she orders 250 papers. Use the following random numbers: 14, 4, 13, 9, and 25 for simulating Barbara's profit. (Note: Assume the random number interval begins at 01 and ends at 00.) Based on the given probability distribution and the order size, for the given random number Barbara's sales and profit are (enter your responses for sales as integers and round all profit responses to two decimal places): Random Number Sales Profit 14 4 13 9 25
Consider a fim that sells its product in both the US. and the U.K. U.S. demand is for 13,000 unite, and the U.S. production capadty is 16,000 units. Demand in the U.K. is for 9,000 units, and the U.K. production capacity is 13,000 units. Production cost in the U.S. is $14.7, and production cost in the U.K. is £7. The current exchange rate is $1.221. The shipping cost is $3 per unit for any units shipped between the two countries. Sales prices equate to $120 in each country. a) How many should be made in each country? US units. UK units b) How much is the proft for each country? U.S. ProfitS (round your reaponse to the nearesat dollar). U.K. Profit-S fround your response to the nearest dollar). Enter your answer in each of the answer boxes.
Global Logistics needs to rent space for storing product for the next three years. The following information regarding the demand and spot price is available. Current demand for the product is 150,000. Historically, Global Logistics has required 1500 square feet to store 1500 units of the product. Demand for the product can go up by 20% with a probability of 0.7 or down by 20% with a probability of 0.3. Global Logistics can sign a three-year fixed lease to rent 150,000 square feet of space at $1.00 per square foot per year. The firm may also choose to obtain warehousing space on the spot market. The current spot market price is $1.20 per square foot per year. The spot price can go up by 10% with a probability of 0.8 and can decrease by 10% with a probability of 0.2. The firm receives a revenue of $1.22 for each unit of demand. a) Create a decision tree showing period 0, 1 and 2 for the scenario described above. b) Calculate the NPV for the option when the firm decides to sign a…
An automotive warehouse stocks a variety of parts that are sold at neighborhoodstores. One particular part, a popular brand of oil filter, is purchased by thewarehouse for $1.50 each. It is estimated that the cost of order processing andreceipt is $100 per order. The company uses an inventory carrying charge based on warehouse for $1.50 each. It is estimated that the cost of order processing andreceipt is $100 per order. The company uses an inventory carrying charge based ona 28 percent annual interest rate.The monthly demand for the filter follows a normal distribution with mean280 and standard deviation 77. Order lead time is assumed to be five months.Assume that if a filter is demanded when the warehouse is out of stock, then thedemand is back-ordered, and the cost assessed for each back-ordered demand is$12.80. Determine the following quantities:a. The optimal values of the order quantity and the reorder level.b. The average annual cost of holding, setup, and stock-out associated…
ABC Corporation has recently given out a nine-month contract to a construction subcontractor. At the end of the first month, it becomes obvious that the subcontractor is not reporting costs according to an appropriate WBS level. ABC Corporation asks the subcontractor to change its cost reporting procedures. The subcontractor states that this cannot be done without additional funding. This problem has occurred with other subcontractors as well. What can ABC Corporation do about this?