Please use excel solver. A diet for a sick person must contain at least 4500 units of vitamins, 45 units ofminerals and a maximum of 2500 calories. Two foods A and B are available at a cost ofRs.5 and Rs.4 per unit respectively. One unit of A contains 200 units of vitamins, 1 unitof mineral and 40 calories. The corresponding figures for one unit of B is 150 units ofvitamins, 3 units of minerals and 50 calories. What combination of foods to be used tohave least cost?

Decision Variables: Suppose -X be the quanity of food Type AY be the quanity of food Type B

Answered: A diet for a sick person must contain…

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

Bimala is interested in buying a new house and has found a house she likes in Surry Hills. Bimala comes to you for advice about which of the following items would pass to her automatically if she buys the house: • A plastic bird bath which rest on the ground in the back garden; • A concrete swimming pool in the back garden; • A tapestry attached by small tapestry nails to the wall of the living room; and • A barbecue on wheels on the back deck. Advise Bimala. In your advice, please ensure that you refer to relevant case law. *NOTE: This is business law question. can you write more details about the question and answer.
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…
She must travel to Kenya to check on quality and transportation. The trip will cost $2,500. The cost of the handbag is $10 and shipping to the United States can occur through the postal system for $2 per handbag or through a freight company which will ship a container that can hold up to 1,000 handbags at a cost of $1,000. The freight company charges $1,000 even if less than 1,000 handbags are shipped. Leslie will sell the handbags to retailers for $20. Assume there are no other costs and benefits. what is the output level that both shipping methods yield same profit? Ho
LPM Corp. produces and sells two types of frozen burgers, Turkey Burgers and Veggie Burgers. In the most recent month, the firm sold 12,000 Turkey Burgers and 8,000 Veggie Burgers. Turkey Burgers sold for $14.00 per box and variable costs were $7.40 per box. The Veggie Burgers sold for $16.00 per box and variable costs were $8.25 per box. The fixed expenses of the entire company were $41,160. If the sales mix were to shift toward the Turkey Burgers product line with total sales volume remaining constant at 20,000, the overall break-even point for the entire company:
Inayah is a rational consumer who consumes milk and cookies only from her monthly income of Rs. 1,500. If the price of milk is Rs. 500 per liter and the price of one pack of cookie is Rs. 300, answer the following questions: Assume that Inayah’s consumption of milk and cookies give her following level of utility: Quantity MU milk MU cookies 1 400 450 2 350 200 3 200 150 4 100 100 5 70 60 6 30 30 7 0 0 Find the optimal level of consumption. Find the consumer equilibrium using the two-dimensional labeled diagram.
A manufacturer that produces 100 different products is considering building a new warehouse because there is no room in raw material and product warehouses. Because although some products are more than in the warehouse, some demands that come due to the fact that the ban products are not enough in the warehouse are avoided. For this reason, it plans not to miss any demand by producing and storing enough of all its products, and of course it is considering building a new and larger warehouse to store more products. What can you suggest to this company, taking into account what is described in the course, describe your proposal in maximum detail with the concepts described in the course, as applicable activities.
The Frist Corporation has the followinginternal controls related to inventory:1. Only authorized inventory warehousing personnel are allowed in inventory storageareas.2. All inventory products are stored in warehousing areas that are segregated fromother storage areas used to house equipment and supplies.3. All inventory held on consignment at Frist Corporation is stored in a separatearea of the warehouse.4. The inventory purchasing system only allows purchases from pre-approved vendors.5. The perpetual inventory system tracks the average number of days each inventoryproduct number has been in the warehouse.6. Microchips are embedded in each product and when inventory items are removedfrom the warehouse to shipping, radio-frequencies signal a deduction of inventoryto the perpetual inventory system.7. On a weekly basis, inventory accounting personnel take samples of inventoryproducts selected from the perpetual inventory system and verify that the inventoryis on-hand in the warehouse…
d) A company can produce three products A, B and C. the products yield a contribution of Kshs.8, 5 and 10 respectively. The products use a machine which has 400 hours capacity. Each unit of the product uses 2, 3 and 1 hour respectively of the machines capacity. There are only 150 units available in the period of a special component which is used singly in product A and C. Only 200kgs of a special alloy is available in the period. The usage of special alloy is 2kgs per unit and 4kgs per unit respectively. There is an agreement with a trade association to produce no more than 50 units of product B in the period. Advise the company on the production plan that will maximize contribution.
Give the logical sequence of steps for formulating and constructing a (structured) LP model.
As a potential owner of a club known as Club Salida, you are interested in determining the necessary volume of sales in dollars to reach the breakeven next year. You decided to break down the club's sales into. four categories, where beer is the first. Your estimate of the sale of beer is that it will serve 30,000 servings. The selling price per unit will average $ 1.50; its cost is $ .75. The second category is food, of which you expect sell 10,000 units with an average unit price of $ 10.00 and a cost of $ 5.00. The third category is desserts and wine, of which you also hope to sell 10,000 units, but with an average unit price of $ 2.50 and a cost of $ 1.00. The last category is inexpensive lunches and sandwiches, of which you expect sell a total of 20,000 units with an average price of $ 6.75 and a cost per unit of $ 3.25. Your fixed costs (i.e. rent, utilities, etc.) are $ 1,800 a month plus $ 2,000 a month for entertainment. a) What is your breakeven point in dollars per month? b)…
The world's oceans contain on average of 0.9 oz of Au /ton of ocean water. There were 2 proposed novel process in mineral extraction to recover the Au and they were compared using Engineering Economic Analysis. Process X costs $600/ton of ocean water processed and a recovery of 90%, while Process Z costs $450/ton and a recovery of 60%. Both processes will need the same amount of capital investment and equal ounces of Au extracted daily. If the Au today is $2,200/oz, which process is more feasible considering the fact that the world's ocean can be inexhaustible? This problem requires the analysis to be on the basis of profit per ounce of Au extracted.
Imagine designing a conjoint for your b-school's café. In particular, you're in charge of the daily pizza orders. Pizzas are tricky-while they're a simple food, they can be created in a zillion combinations. What factors should you test in terms of your fellow students' likely preferences? Wheat crust vs. white, thick vs. thin, plain cheese vs. sausage vs. sausage and green pepper vs. vegetarian (you get the picture). Design a conjoint that would result in identifying 2 or 3 popular slices that your café managers could order every morning. The student body knows you're responsi ble-how do you make most of them happy?

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