Set up the objective function and enumerate all the constraints, Define the decision variables of the IP Programming problem 5. A semiconductor corporation produces a particular solid-state module that it supplies to fourdifferent television manufacturers. The module can be produced at each of the corporation's threeplants, although the costs vary because pf differing production efficiencies at the plants.Specifically, it costs 110 pesos to produce a module at Plant A, 95 pesos to produce a module atPlant B, and 103 pesos to produce a module at Plant C. Monthly production capacities of the plantsare 7500, 10000 and 8100 modules, respectively. Sales forecasts project monthly demand at 4200,8300, 6300 and 2700 for television manufacturers I, II, III and IV, respectively. If the cost (inpesos) for shipping a module from a plant to a manufacturer is as shown in the table below,determine the production level in each plant that will meet all needs at minimum total cost.Manufacturer IManufacturer IIManufacturer IIIManufacturer IVPlant A11139.19Plant B12161014Plant C14131215

After adding the information given in the question description, the table will be as follows. Total…

Answered: Set up the objective function and…

Set up the objective function and enumerate all the constraints, Define the decision variables of the IP Programming problem

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

13.20. Southwood Furniture Company is a U.S.-based furniture manufacturer that offshored all of its actual manufacturing opera- tions to China about a decade ago. It set up a distribution center in Hong Kong from which the company ships its items to the United States on container ships. The company learned early on that it could not rely on local Chinese freight forwarders to arrange for sufficient containers for the company's shipments, so it contracted to purchase containers from a Taiwanese manufacturer and then sell them to shipping companies at the U.S. ports the containers are shipped to. Southwood needs 715 containers each year. It costs $1200 to hold a container at its distribution center, and it costs $6000 to receive an order for the containers. Determine the optimal order size, min- imum total annual inventory cost, number of annual orders, and time between orders.
Joint Products Choi Company manufactures two skin care lotions, Smooth Skin and Silken Skin,from a joint process. The joint costs incurred are $420,000 for a standard production run that generates 180,000 pints of Smooth Skin and 120,000 pints of Silken Skin. Smooth Skin sells for $2.40 perpint, while Silken Skin sells for $3.90 per pint.Required1. Assuming that both products are sold at the split-off point, how much of the joint cost of each production run is allocated to Smooth Skin using the relative sales value method?2. If no separable costs are incurred after the split-off point, how much of the joint cost of each productionrun is allocated to Silken Skin using the physical measure method method?3. If separable processing costs beyond the split-off point are $1.40 per pint for Smooth Skin and $0.90 perpint for Silken Skin, how much of the joint cost of each production run is allocated to Silken Skin usinga net realizable value method?4. If separable processing costs beyond the…
In the last 12 months the quantities shown inTable 1 of light vehicles of a brand "R" were sold in the national territory.The selling price of each R vehicle is 12590€. The production cost(including raw material cost) of one is 7730€. The company usesown transportation to transport the vehicles worth 420€, andgiven the distance to the factory, takes on average, 8days, with a standard deviation of 2 days. Storage until saleis estimated at 150€/unit.year. The companyfinancial loans at an annual rate of 2.2%. Consider that ayear has 264 working days.a) Determine the economic order quantity.b) Consider that a service level of 85% (Z=1.036) is to be ensured using a continuous reviewinventory management policy of continuous review. Determine:i. The order point.ii. The economic order quantity considering stock-outs. Month Sales Month Sales 1 2235 7 3078 2 3206 8 2366 3 4298 9 1966 4 3309 10 2149 5 3640 11 2387 6 4038 12 2492
(3marks) c. The Ambrosia Bakery makes cakes for freezing and subsequent sale. The bakery, which operates five days a week, 52 weeks a year, can produce cakes at the rate of I16 cakes per day. The bakery sets up the cake-production operation and produces until a predetermined number have been produced. When not producing cakes, the bakery uses its personnel and facilities lor produciny other bakery tems Ihe selup cost lor a oduction run of cakes is 700 The cost of holdling frozen cakes in storage is 9 per Cake per year. the annual demand lor Ihuzen cakes, which Is contant over time, is G000 cakes. Determine the lollowing 1Optimal production run quantity ii. The maximum inventory ii. Total annual inventory costs iv. Optimal number of production runs per year V. Optimal cyele tinie (time between run starts)
A company manufacture and sells direct to consumers 10000 jars per month at Rs 1.25 per ja The company's normal production capacity is 20000 jars per month. An analysis of cost for 10000 jars shows :- Rs 1000 Direct Materials 2475 Direct Labour 140 Power 1030 Jars & Misc supplies 7955 Fixed Expenses 12600 The company has received an offer for export of 10000 jars per month at Rs. 0.75 a jar Write a short note on the advisability or otherwise of accepting the offer. uith dotoile ae nossible
13.6. The Ambrosia Bakery makes cakes for freezing and subsequent sale. The bakery, which operates five days a week, 52 weeks a year, can produce cakes at the rate of 116 cakes per day. The bakery sets up the cake-production operation and produces until a predetermined number (Q) has been produced. When not producing cakes, the bakery uses its personnel and facilities for producing other bakery items. The setup cost for a production run of cakes is $700. The cost of holding frozen cakes in storage is $9 per cake per year. The annual demand for frozen cakes, which is constant over time, is 6000 cakes. Determine the following: a. Optimal production run quantity (Q) b. Total annual inventory costs c. Optimal number of production runs per year d. Optimal cycle time (time between run starts) e. Run length in working days
Q#3 · Let p + 3q/2 = 27 be an equation involving two variables p (price) and q (quantity). Indicate the meaningful domain and range of this function when (a) the price (b) the quality are considered independent variables.
8b) 7,000 drivers from Barrie drive southbound 5 days a week to see a billboard ad on Highway 400 (You cannot see the billboard going north). If we assume there are 200,000 total people in Barrie, what would the GRP per week for the billboard be for the target market of "the entire city of Barrie"?
29) XYZ Company The XYZ Company uses 175 handles per day. The company operates 300 days per year. It costs $2.00 to carry one handle in inventory for one year. When handle inventory is low, an order is sent to the fabrication department to manufacture more handles. Fabrication can produce handles at a rate of 1500 per day and send the handles over to assembly while production is in progress. The setup for each production run costs $500. In order to calculate the EOQ, the XYZ company utilizes the __________ model. Group of answer choices a) Basic EOQ b) Production Quantity c) Optimal Production
The GIIC -Company must determine a policy for ordering coal to operate 15 smelters. Each smelter requires exactly 5 tons of coal per day to operate, and the firm operates 360 days per year. The purchasing manager has negotiated a contract to obtain the coal for 5 BD per ton for the coming year. The purchasing manager has determined that the ordering cost is 40 BD per order, and the cost of holding coal is 20% per ton of its value. i. Determine the optimal quantity of coal to receive in each order. ii. Determine the total inventory-related costs associated with the optimal ordering policy (do not include the cost ii. If five days' lead time is required to receive an order of coal, how much coal should be on hand when an iv. Optimal quantity 1837.11 Tons, Total cost 1837.11 BD, Inventory during LT 275 Tons of the coal). order is placed? i. Optimal quantity 1469.694 Tons, Total cost 1469.694 BD, Inventory during LT 375 Tons ii. Optimal quantity 734.85 Tons, Total cost 1649.694 BD,…
3) A mgr. must set up an invty system for two (2) new production items, P34 & P35. P34 can be ordered at any time, but P35 can only be ordered once every 4 weeks. The co. operates 50 weeks a year and the weekly usage rates for both items are normally distributed. The mgr. has gathered the following information about the items: Item P34 Item P35 Average wkly demand Standard deviation 60 units 70 units 4 units per wk $15 5 units per wk $20 Unit cost Annual Holding cost 40% 40% Ordering cost Lead time $70 $30 2 weeks 2 weeks Acceptable stockout risk 5% 5% a) When should the manager reorder each item? b) Compute the order quantity for P34 c) Compute the reorder point for P35 if 110 units are on hand at the time the order is placed.
Demand for portable music players for joggers has caused Nancy Industries (Nancy) to grow almost 50 percent over the past year. The number of joggers continues to expand, so Nancy expects demand for music player to also expand, because, as yet, no safety laws have been passed to prevent joggers from wearing them. Demands for the players for last year was as follows : Month Demand (units) Jan 4200 Feb 4300 Mar 4000 Apr 4400 May 5000 Jun 4700 Jul 5300 Aug 4900 Sep 5400 Oct 5700 Nov 6300 Dec 6000 Question : From the choice of simple moving average, weighted moving average, exponential smoothing, and linear regression analysis, which forecasting technique would you consider the most accurate to Nancy Industries? Why?