Bright Furnitures produces chairs and tables that go through M1 and M2. Making a 1 table and 1 chair takes the following time in hours: TABLE CHAIR M1 7 4 M2 5 5 Total of 200 hours are available on M1 and 400 hours on M2. Profit contribution from the sale of a chair is P300 and from a table is P400. Requirement: Determine the optimal mix of tables and chairs so as to maximize the contribution. Use Excel Solver.

Bright Furnitures produces chairs and tables that go through M1 and M2. Making a 1 table and 1 chair takes the following time in hours: TABLE CHAIR M1 7 4 M2 5 5 Total of 200 hours are available on M1 and 400 hours on M2. Profit contribution from the sale of a chair is P300 and from a table is P400. Requirement: Determine the optimal mix of tables and chairs so as to maximize the contribution. Use Excel Solver.

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

Assume the demand for a companys drug Wozac during the current year is 50,000, and assume demand will grow at 5% a year. If the company builds a plant that can produce x units of Wozac per year, it will cost 16x. Each unit of Wozac is sold for 3. Each unit of Wozac produced incurs a variable production cost of 0.20. It costs 0.40 per year to operate a unit of capacity. Determine how large a Wozac plant the company should build to maximize its expected profit over the next 10 years.
I need the excel formulas for the following, please! A concession stand manager at a baseball game must decide whether to have the souvenir vendors sell sun visors or umbrellas. There is a 30% chance of rain, a 15% chance of clouds, and a 55% chance of sunshine, according to weather predictions for the game. Because supplies can only be ordered 3 days before each game, the stand manager is unable to waituntil the day before the game to acquire the materials to be sold. The manager estimates the following profits will result from each decision, given the weather conditions. Given the following table, select the best decision using the following decision criteria.• Maximin• Maximax• Maximum likelihood criterion• Bayes’ decision rule Decision Rain Cloudy Sunny Sun Visors $-500 $-200 $1,500 Umbrellas $2,000 $0 $-900 Prior Probabilities 0.30 0.15 0.55
XYZ Corporation manufactures two products, Simple and Complex. The following annual information was gathered: Simple Complex Selling price per unit P47.00 P26.00 Variable cost per unit 42.00 22.00 Total annual fixed costs are P18,000. Assume XYZ Corporation can produce and sell any mix of Simple or Complex at full capacity. It takes 1.5 hours to make one unit of Complex. However, Simple takes 50% longer to manufacture when compared to Complex. Only 120,000 hours of plant capacity are available. How many units of Simple and Complex should XYZ Corporation produce and sell in a year to maximize profits?
XYZ Corporation manufactures two products, Simple and Complex. The following annual information was gathered: Simple Complex Selling price per unit P47.00 P26.00 Variable cost per unit 42.00 22.00 Total annual fixed costs are P18,000. Assume XYZ Corporation can produce and sell any mix of Simple or Complex at full capacity. It takes one hour to make one unit of Complex. However, Simple takes 50% longer to manufacture when compared to Complex. Only 120,000 hours of plant capacity are available. How many units of Simple and Complex should XYZ Corporation produce and sell in a year to maximize profits?
Production and Materials Purchases Budgets White Corporation’s budget calls for the following sales for next year:Quarter 1 90,000 units Quarter 3 68,000 unitsQuarter 2 76,000 units Quarter 4 96,000 unitsEach unit of the product requires 3 pounds of direct materials. The company’s policy is to begineach quarter with an inventory of product equal to 5% of that quarter’s estimated sales requirementsand an inventory of direct materials equal to 20% of that quarter’s estimated direct materials requirements for production.Required Determine the production and materials purchases budgets for the second quarter.
A company possesses two manufacturing plants, each of which can produce three products, X, Y, and Z, from a common raw material. However, the proportion in which the products are produced differs in each plant, and so are plant's operating costs per hour. Data on production per hour and costs are given below, together with current orders in hand of each product. Products Operating cost per hour Y Plant A 4 9. Plant B 4 2 10 Orders on hand 50 24 60 Formulate the above as a linear programming problem. Find the number of production hours needed to fulfill the orders on hand at minimum cost using the using Big M method.
You have been hired by Kia as manager for its Pakistan operations. Assume following is the short-run production function at their assembly plant outside Karachi: Q = 10L2 – 0.5 L3 where L is variable input labor, Q is output of Cars assembled a. At the end of the year it is expected that output will double with purchase ofnew equipment and machinery. The production function is estimated to be Q = 60L.30K.70 where L is labor and K is capital. Suppose initial L1 = 1 and K1 = 1. When inputs are in increased to L2 = 2 and K2 = 2, do you observe increasing, decreasing or constant returns to scale? b. Assume Kia Head Office is considering hiring more laborers either at their Gwadar plant or alternatively at the Karachi plant. What will be your advice if workers’ marginal product is 40 at wage of Rs=5/hour in Karachi and marginal product is 28 at wage of Rs=4/hour in Gawdar?
Western Chassis produces high-quality polished steel and aluminum sheeting and two lines ofindustrial chassis for the rack mounting of Internet routers, modems, and other telecommunicationsequipment. The contribution margin (contribution toward profit) for steel sheeting is $0.40 per poundand for aluminum sheeting is $0.60 per pound. Western earns $12 contribution on the sale of aStandard chassis rack and $15 contribution on a Deluxe chassis rack. During the next productioncycle, Western can buy and use up to 25,800 pounds of raw unfinished steel either in sheeting or inchassis. Similarly, 20,400 pounds of aluminum are available. One standard chassis rack requires 16pounds of steel and 8 pounds of aluminum. A Deluxe chassis rack requires 12 pounds of each metal.The output of metal sheeting is restricted only by the capacity of the polisher. For the next productioncycle, the polisher can handle any mix of the two metals up to 4,000 pounds of metal sheeting. Chassismanufacture can be…
Mark has a company that produces tables and chairs, both having two different models. The product models and related information are given in the following table. Wood costs 3000 $ per cubic meter and 200 m3 of wood are available for the upcoming month. The cost of labor is 40 $/hour and there are 6000 hours of labor available in a month. Mark sells his products to a big chain retail company. The company purchases all products whatever Mark produces. Mark formulates an LP as follows to determine the optimal monthly production plan such that he maximizes the total profit. Decision Variables: X1 : number of basic tables to be produced. X2 : number of elegant tables to be produced. X3 : number of basic chairs to be produced. X4 :number of elegant chairs to be produced. Max Z = 140 X1 + 345 X2 + 120 X3 + 260 X4 ( maximize total profit) Subject to 0.11 X1 + 0.13 X2 + 0.06 X3 + 0.07 X4 ≤ 200 (constraint on the available amount of wood) 2 X1 + 4.5 X2 + 1.5 X3 + 4 X4 ≤ 6000…
The interContinental Hotel at Tsim Sha Tsui has 100 total rooms available for Dec 31. There are two types of customers, business customers and leisure customers. InterContinental charges a high rate of $300/night and a low rate of $120/night. High-rate guests do not need pre-booking and has time flexibilities; low-rate guests need pre-booking. Assume business customers always take the high rate option and leisure customers always take the low rate option. Leisure customers always book far earlier before business customers and there are sufficient leisure customers. Which of the following actions would increase the optimal protection level for business customers? Increase both the high and low rates by a factor of two Decrease the high rate from $300 to $200 Decrease both the high and low rates by half O Decrease both the high and low rates by $20 O Increase both the high and low rates by $20
Solve the following problem with Excel Solver: (Leave no cells blank be certain to enter "0" wherever required. Do not round intermediate calculations. Round your answers to 2 decimal places.) Maximize Z= 3X+17Y 3X+8Ys 74 3X+11Y ≤ 78 Y s 35 Decision for X Decision for Y Total profit Resource A Resource B Resource C Resources Used Resource A Resource B Resource C
Western Chassis produces high-quality polished steel and aluminum sheeting and two lines of industrial chassis for the rack mounting of Internet routers, modems, and other telecommunications equipment. The contribution margin (contribution toward profit) for steel sheeting is $0.40 per pound and for aluminum sheeting is $0.60 per pound. Western earns $12 contribution on the sale of a Standard chassis rack and $15 contribution on a Deluxe chassis rack. During the next production cycle, Western can buy and use up to 25,800 pounds of raw unfinished steel either in sheeting or in chassis. Similarly, 20,400 pounds of aluminum are available. One standard chassis rack requires 16 pounds of steel and 8 pounds of aluminum. A Deluxe chassis rack requires 12 pounds of each metal. The output of metal sheeting is restricted only by the capacity of the polisher. For the next production cycle, the polisher can handle any mix of the two metals up to 4,000 pounds of metal sheeting. Chassis manufacture…