(d) A company has three factories. Each factory produces three different products (A, B and C).Factory 1 has a daily production capacity production of 8 units of A, 4 units of B and 8 unitsof C. Factory 2 has a daily production capacity of 6 units of A, 6 units of B and 3 units of C.Factory 3 has a production capacity of 12 units of A, 4 units of B and 8 units of C. The totaldemand for product A is 300 units, for product B is 172 units and for product C is 250 units.The daily operating cost for Factory 1 is $55 for Factory 2 is $60 and for Factory 3How many days should each factory be operated in order to fill the total demand and thekeep the operating cost at a minimum?(i)(ii)(iii)$50.Show a model that represents the company's problem.Write down the dual maximization problem.Write down the initial simplex tableau.

Objective Functions and Constraints: Based on the given details, the objective…

Answered: (d) A company has three factories. Each…

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

paresh
13. The Bi-Product Company produces two products (A and B) that are similar in terms of labor con- tent and skills required. Company management wishes to "level" the number of employees needed each day so no hiring or layoffs will be required during the year. A complication to this problem is that the number of working days in each quarter varies. Demand Quarter Product A Product B Working Days 1 9,800 14,500 68 2 12,000 30,000 56 3 14,000 19,500 62 4 31,000 25,000 58 Beginning inventory: 2,400 units of Product A 900 units of Product B Inventory holding cost: $10 per unit per quarter (either product) No back orders allowed No variations in size of workforce allowed Output rate=25 units of either product per day per employee a. What daily production rate will be required to meet the demand forecast and yield zero in- ventory at the end of quarter 4? b. How many employees will be required each day? What are the inventory levels each quarter?
5.20
A company has the following demand data for the last three years of sales for their popular product B. There are currently 5 workers assigned to the production line, each capable of producing approximately 8 units per month. It is assumed that each month has the same number of production days. They can hire more workers at a hiring and training cost of $800 per worker. If they layoff any workers, the unemployment cost is $2,000 per worker. The product has a standard production cost (labor, material, and overhead) of $300 per unit. The extra cost to produce one unit on overtime is $50 and the maximum overtime is two units per month per worker. They can use inventory but it will cost them $25 per unit per month for any unit in inventory at the end of the month. Failure to meet market demand typically will imply the customer will buy from another supplier, and therefore cost the company $100 in profit. They currently have 0 units in inventory. a. Use the demand data to develop a forecast…
NO. 5 Jenny Company produces two types of pants: long pants and short pants. The cost of making a pair of short pants and a pair of long pants are RM 75 and RM 95 respectively. In one week, the company must produce at least 150 pants of cach type. The minimum weekly production is 500 pants. The short pants is sold for RM 120 cach and the long pants for RM 150 cach. Using the graphical method, find: a) The number of short pants and long pants to be made in a week in order to minimize the total production cost. b) The profit made at the minimum weekly production cost.
Rajan wanted a radio from Jacky's. It appears that Rajan is particularly interested in purchasing a Radio from the inexpensive retailer's sales manager for consumer electronics. He tells Jacky, the salesperson at the inexpensive store where he thinks he'll get the best deal, that his old radio died and he wants to listen to his favourite tunes. He wants a replacement radio as quickly as possible. In three and a half weeks, Rajan's favourite model will be 10% off.He suspects Rajan won't wait and will find another job. Jacky will earn less on the lowered price. He thinks that telling Rajan of the sale makes little sense.When Jacky tells Rajan that the radio set he wants is no longer available and won't be for another week, Rajan is enraged. Fearing losing the business, Jacky begs his sales manager, Michelle, to speed up delivery. Michelle says it's impossible and suggests Jacky tell Rajan the store can get the set in 24 hours and sell him the demo model. Michelle says the sample is new…
Alex target population for his study are the employees of hotels in mindanao. Since there are too many employees in this establishments, he randomly selected 10 hotels and then he considered all employees as participants in this study. What is its ssmpling procedures and its justification.
Mr Chan lives with his parents in Aberdeen. He owns a flat in causeway bay. The order of preference of ways for him to use his flats as follow 1st choice: run a restaurant. 2nd choice: rent it out. 3rd choice: live in it. Explain how the cost of using the flat to run the restaurant maybe affected if, a. The market rental rate sharply increases. b. His parents health deteriorates and there is an increasing need for him to take care of them. c. He has employed a cook at a salary lower than the market rate
A local semiconductor firm, Superchip, is planning its workforce and productionlevels over the next year. The firm makes a variety of microprocessors and usessales dollars as its aggregate production measure. Based on orders received and sales forecasts provided by the marketing department, the estimate of dollarsales for the next year by month is as follows:Production Predicted DemandMonth Days (in $10,000)January 22 340February 16 380March 21 220April 19 100May 23 490June 20 625July 24 375August 12 310September 19 175October 22 145November 20 120December 16 165Inventory holding costs are based on a 25 percent annual interest charge. It is anticipatedthat there will be 675 workers on the payroll at the end of the current year and inventorieswill amount to $120,000. The firm would like to have at least $100,000 of inventory at theend of December next year. It is estimated that each worker accounts for an average of$60,000 of production per year (assume that one year consists of 250…
Valencia Products makes automobile radar detectors and assembles two models: LaserStop and SpeedBuster. The firm can sell all it produces. Both models use the same electronic components. Two of these can be obtained only from a single supplier. For the next month, the supply of these is limited to 4,000 of component A and 3,500 of component B. The number of each component required for each product and the profit per unit are in the table below. This question is interested in maximizing the profit). a) Identify the decision variables, objective function, and constraints in simple verbal statements. b) Mathematically formulate a linear optimization model. Components Required/Unit A B Profit/Unit LaserStop 18 6 $124 SpeedBuster 12 8 $136 Solve this question in Excel by using SOLVER. Please clearly explain what is the optimal solution? What is the resulting output of the objective function at the optimal solution? P.S. please solve in Excel.
A shop is planning an order for a popular Christmas festive season product. Demand for the product usually starts from first week of December till first week of January and reduces sharply thereafter. For this reason, and to stimulate sales for leftovers, the product is sold at a significantly reduced price from the second week of January to the fourth week of January. Any leftover after the fourth week of January goes waste. The table below gives past data on total demand for the period from first week of December to first week of January, and from second week of January to fourth week of January, together with their respective chances of occurrence. The product can be purchased at a wholesale price of GHS60 per unit for a pack containing 600 products, GHS57 per unit for a pack containing 800 products, and GHS52 per unit for a pack containing 1000 products. The shop plans to sell the product for GHS80 per unit from first week of December to first week of January, and at a reduced…
1. A major supermarket chain has decided to sub-contract production of ready-to-eat sandwiches to your production plant. Your plant can make three kinds of sand- wiches, each of which take the following amounts of raw ingredients (measured in grams) to produce: Sandwich | Chicken Cheese Lettuce Tomato Bread 45 15 25 10 13 Chicken Salad Chicken Club Cheese and salad 920 0 20 30 Chicken Salad Chicken Club Cheese and Salad 15 10 20 The total amount of time (measured in minutes) to make one of each sandwich is listed below, together with the price that the supermarket will pay to purchase one of each: Sandwich | Time to Make Price 2.8 4.8 1.3 60 90 60 £1.25 £1.65 £0.95 For the sake of this problem you can treat ingredients used and number of sandwiches made as continuous quantities we could perhaps think of this as the average made per day over a longer period, in which case making 100.43 sandwiches per day would still make sense. (a) Suppose that you have 5000g of chicken, 2500g of…

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