In this task, you are asked to formulate the linear programming problem below and then solve it. A carpenter produces Tables (T) and Chairs (C). Each Table unit requires 6kg of wood and 1kg of plastic. Each Chair unit requires 4kg of wood and 4kg of plastic. The carpenter has only 100kg of wood and only 50kg of plastic in stock. On each sale, the carpenter makes a profit of £15 per Table unit sold and a profit of £30 per Chair unit sold. Required: Formulate the Linear Programming problem above by defining the variables, stating the object function and the constraints. You are required to produce the graph for all inequalities (copy image to Word) Find the quantity to make of Tables and Chairs to maximise profit.

In this task, you are asked to formulate the linear programming problem below and then solve it. A carpenter produces Tables (T) and Chairs (C). Each Table unit requires 6kg of wood and 1kg of plastic. Each Chair unit requires 4kg of wood and 4kg of plastic. The carpenter has only 100kg of wood and only 50kg of plastic in stock. On each sale, the carpenter makes a profit of £15 per Table unit sold and a profit of £30 per Chair unit sold. Required: Formulate the Linear Programming problem above by defining the variables, stating the object function and the constraints. You are required to produce the graph for all inequalities (copy image to Word) Find the quantity to make of Tables and Chairs to maximise profit.

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

1. The chili company produces three different types of chili sauce. To produce chili one pack requires the following ingredients: Chili type Sambal x Sambal y Sambal z Which is available Onion 8 6 1 48 Tomatoes Chilli 4 1 1 16 6 4 5 40 The profit from each product is that sambal x costs IDR 1,500/pack, sambal y IDR 2,500/pack, and sambal z IDR 900/pack. Determine what is the optimum production so that all resources are properly absorbed and get maximum profit! (Hint: solve with the simplex method)
SIMPLEX METHOD A factory makes tennis rackets and cricket bats. A tennis racket takes 1.5 hours of machine time and 3 hours of craftsman’s time in its making while a cricket bat takes 3 hour of machine time and 1 hour of craftsman’s time. In a day, the factory has the availability of not more than 42 hours of machine time and 24 hours of craftsman’s time. If the profit on a racket and on a bat is Php 20.00 and Php 10.00 respectively, find the maximum profit of the factory when it works at full capacity.
2. A machine part can be exhausted either from aluminum or steel. There is an order of 8,000 units.Steel costs 3.80Php/kg, while aluminum cost 8.70Php/kg. If steel is used, the steel per unit weighs110g and 30g for aluminum. In production, steel is 50 units/hr and 80units/hr with an aid of a toolcosting 640Php, which will be useless after the 8,000 units are finished. The cost of the machineoperator is 10.80Php/hr. if all other costs are identical, which material is more economical?a. Aluminum, by 1,264Php cost difference.b. Aluminum, by 1,653Php cost differencec. Steel, by 640Php cost difference.d. Steel, by 1,088Php cost difference.e. None of the above
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…
A company manufactures iron cutting machines. Investment amount made with respect to the machine It is 800 thousand TL. Energy costs will increase by 50 thousand and 6% each year. Personnel expenses 35 thousand and it increases by 15 thousand every year, on the other hand, financing expenses are 100 thousand TL and 20% each year will increase by the rate. Since it is planned to manufacture 250 machines per year, 12 years of life and For this manufacturing with 30% capital cost, the company will calculate how many TL in total for the machines manufactured each year. one has to charge an expense and what will be the expense per unit. Note: Solve according to the annual equivalent cost method.
14. Akali is the only nurse in lonia. lonia has 21 ninja households distributed one-tenth of a mile along the main street. Each ninja household goes to see Akali for her services at most one time per week. There are additional dangers on the street going there-and back again which are equal to $0.5 for every tenth of the mile. The reservation price of each ninja to pay for Akali services is $10. To serve each ninja, Akali incurs $2 costs. What the maximum price should Akali charge if she wants to serve the whole lonia? How much would she earn?
Maximize Profit=123 L + 136 S 17 L+11 S≤ 3000 6 L+9 S≤2500 L20 and S20 (Availability of component A) (Availability of component B) Show Transcribed Text Implement the linear optimization model and find an optimal solution. Interpret the optimal solution. The optimal solution is to produce LaserStop models and SpeedBuster models. This solution gives the possible profit, which is $. (Type integers or decimals rounded to two decimal places as needed.)
Problems LU - 2 Wally Beaver won a lottery and will receive a check for $2,500 at the beginning of each 6 months for the next 6 years. If Wally deposits each check into an account that pays 6%, how much will he have at the end of the 6 years?
Suppose Firm A can manufacture 100 pens and 20 umbrellas with a unit of labor, and Firm B can manufacture 80 pens and 10 umbrellas with a unit of labor. Which one of the following statements is true? Firm A has the comparative advantage in both pen and umbrella production.Firm B has an absolute advantage in umbrella production.Firm A has a comparative advantage only in pen production.Firm B has a comparative advantage in pen production.Neither firm has a comparative advantage in either pen or umbrella production.
An airline studied the data from their passenger records and noted that their customers turn up only about 95% of the time. A flight can accommodate 40 passengers and each seat costs 4,000 Php. Suppose each passenger books a ticket independently and the airline decides to sell 42 tickets for the flight. If more than 40 show up for the flight , then the extra passengers will be compensated PhP10,000 for rebooking and other expenses. 5. If Profit = Ticket sales-Compensation of Bumped passenger(s). What is the profit if 42 customers show up?
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
Manny signs a variable lease. He pays $10/ square foot. His index is 2.His utilities will cost $350.If his index goes up to 2.5 next year, how much will Manny payin rent? $25/square foot $12.50/square foot $8/square foot $50/square foot |