question:What are the optimal number of Lounge Chairs and Small Sofas to produce and what is the total profit? Machine Hours1.5< 2003.8333per ItemMIN NUMBER OF 1> 25CHAIRSSolution->10016.66672116.667RANGING TABLEVariableValueReducedOriginalValLowerBoundUpperBoundCostLOUNGE CHAIRS1001712.520.83SMALL SOFA| 16.672520.4| 34Slack/SurplusConstraintDualValueOriginalValLowerUpperBoundBoundFRAMING LABOR per50500450Infinityitem320CUTTING LABOR peritem4.5300225Yards of Material perItem25850825InfinityMachine Hours per Item 3.83200180211.11MIN NUMBER OF7525100CHAIRS3. A company produces Lounge Chairs and Small Sofas. It uses Two Labor Types (Framing andCutting time per item in hours), Material and a Machine in the manufacturing process.Management has put a minimum on the number (25) of Lounge Chairs which must beproduced. The profit per Lounge Chair is $17.00 and per Small Sofa is $25.00. Below are theLP formulation and the QM results tables.PROBLEM STATEMENTLOUNGECHAIRSRHS Equation formSMALLSOFAMaximize1725Max 17LOUNGE CHAIRS +25SMALL SOFAFRAMING LABOR 3.56< 5003.5LOUNGE CHAIRS + 6SMALLper itemSOFA <= 500CUTTING LABOR 2.5per itemYards of Material 6.5per Item< 3002.5LOUNGE CHAIRS + 3SMALLSOFA <= 30010.5< 8506.5LOUNGE CHAIRS +10.5SMALL SOFA <= 850< 200Machine Hoursper Item1.531.5LOUNGE CHAIRS + 3SMALLSOFA <= 200MIN NUMBER OF 1CHAIRS> 25LOUNGE CHAIRS >= 25OPTIMAL SOLUTIONLOUNGESMALLRHSDualCHAIRSSOFAMaximize1725FRAMING LABOR 3.56< 500 0per itemCUTTING LABOR 2.5per item3< 3004.5Yards of Material6.510.5< 850per ItemLightshot Screenshot3.

Answered: Image /qna-images/answer/c466bac3-b3b6-41ba-a723-7f00eaafddc0.jpg

Answered: What are the optimal number of Lounge…

Business

Operations Management

What are the optimal number of Lounge Chairs and Small Sofas to produce and what is the total profit?

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter11: Simulation Models

Section: Chapter Questions

Problem 68P

See similar textbooks

Similar questions

It costs a pharmaceutical company 75,000 to produce a 1000-pound batch of a drug. The average yield from a batch is unknown but the best case is 90% yield (that is, 900 pounds of good drug will be produced), the most likely case is 85% yield, and the worst case is 70% yield. The annual demand for the drug is unknown, with the best case being 20,000 pounds, the most likely case 17,500 pounds, and the worst case 10,000 pounds. The drug sells for 125 per pound and leftover amounts of the drug can be sold for 30 per pound. To maximize annual expected profit, how many batches of the drug should the company produce? You can assume that it will produce the batches only once, before demand for the drug is known.
The Tinkan Company produces one-pound cans for the Canadian salmon industry. Each year the salmon spawn during a 24-hour period and must be canned immediately. Tinkan has the following agreement with the salmon industry. The company can deliver as many cans as it chooses. Then the salmon are caught. For each can by which Tinkan falls short of the salmon industrys needs, the company pays the industry a 2 penalty. Cans cost Tinkan 1 to produce and are sold by Tinkan for 2 per can. If any cans are left over, they are returned to Tinkan and the company reimburses the industry 2 for each extra can. These extra cans are put in storage for next year. Each year a can is held in storage, a carrying cost equal to 20% of the cans production cost is incurred. It is well known that the number of salmon harvested during a year is strongly related to the number of salmon harvested the previous year. In fact, using past data, Tinkan estimates that the harvest size in year t, Ht (measured in the number of cans required), is related to the harvest size in the previous year, Ht1, by the equation Ht = Ht1et where et is normally distributed with mean 1.02 and standard deviation 0.10. Tinkan plans to use the following production strategy. For some value of x, it produces enough cans at the beginning of year t to bring its inventory up to x+Ht, where Ht is the predicted harvest size in year t. Then it delivers these cans to the salmon industry. For example, if it uses x = 100,000, the predicted harvest size is 500,000 cans, and 80,000 cans are already in inventory, then Tinkan produces and delivers 520,000 cans. Given that the harvest size for the previous year was 550,000 cans, use simulation to help Tinkan develop a production strategy that maximizes its expected profit over the next 20 years. Assume that the company begins year 1 with an initial inventory of 300,000 cans.
Note :write the equations seperately A firm is making two products A & B. Each unit of A incurs a cost of production to the tune of $150 and that of B incurs a cost of $200. Product A carns a profit of $15/unit and B gets $20/unit. The estimated monthly demand of both A & B is at maximum 500 units. Monthly production budget is set at $50.000.How many units of A & B should the firm make in order to maximize profit. Conduct sensitivity analysis and answer the following questions: 1. State the optimal solution. 2. What is the objective function value? 3. Find out the range of profit for A in the objective function for which the above solution remains optimal.
Dana’s Ribbon World makes award rosettes. Following is information about the company: Variable cost per rosette $ 2.00 Sales price per rosette $ 6.00 Total fixed costs per month $ 6000.00 Required: 1. Suppose Dana’s would like to generate a profit of $1,120. Determine how many rosettes it must sell to achieve this target profit. 2. If Dana’s sells 2,140 rosettes, compute its margin of safety in units, in sales dollars, and as a percentage of sales. 3. Calculate Dana’s degree of operating leverage if it sells 2,140 rosettes. 4a. Using the degree of operating leverage, calculate the change in Dana’s profit if unit sales drop to 1,819 units. 4b. Prepare a new contribution margin income statement to verify change in dana's profit.
Maxwell Manufacturing makes two models of felt tip marking pens. Requirements for each lot of pens are given below. The profit for either model is $1000 per lot. Fliptop Model Tiptop Model Available Plastic 3 4 36 Ink Assembly 5 4 40 Molding Time 5 2 30 Formulate a LP Model for this problem.
An engineer at Fertilizer Company has synthesized a sensational new fertilizer made of just two interchangeable basic raw materials. The company wants to take advantage of this opportunity and produce as much as possible of the new fertilizer. The company currently has $40,000 to buy raw materials at a unit price of $8000 and $5000 per unit, respectively. When amounts x1 and x2 of the basic raw materials are combined, a quantity q of fertilizer results given by: q = 4x1 + 2x2 - 0.5x12 - 0.25x22 Part A: Formulate as a constrained nonlinear program. Clearly indicate the variables, objective function, and constraints. Part B: Solve the Program with Excel Solver (provide exact values for all variables and the optimal objective function).
Box Electric makes electronic components and has estimated the following for a new design of one of its products. Fixed cost = $24,975 Material cost per unit = $0.17 Labor cost per unit = $0.12 Revenue per unit = $0.66 Note that fixed cost is incurred regardless of the amount produced. Per-unit material and labor cost together make up the variable cost per unit. Assuming that Box Electric sells all that it produces, profit is calculated by subtracting the fixed cost and total variable cost from total revenue. Construct an appropriate spreadsheet model to find the profit based on a given production level and use the spreadsheet model to answer these questions. (a) Construct a one-way data table with production volume as the column input and profit as the output. Breakeven occurs when profit goes from a negative to a positive value; that is, breakeven is when total revenue = the total cost, yielding a profit of zero. Vary production volume from 0 to 100,000 in increments of 10,000.…
Patz Company produces two types of machine parts: Part A and Part B, with unit contribution margins of $400 and $800, respectively. Assume initially that Patz can sell all that is produced of either component. Part A requires two hours of assembly, and B requires five hours of assembly. The firm has 400 assembly hours per week. What if market conditions are such that Patz can sell at most 100 units of Part A and 80 units of Part B? Express the objective function with its associated constraints for this case. Objective function: Max Z = $400 A + $800 B Assembly-hour constraint fill in the blank 7 A + fill in the blank 8 B ≤ fill in the blank 9 Demand constraint for Part A A ≤ fill in the blank 10 Demand constraint for Part B B ≤ fill in the blank 11 Identify the optimal mix and its associated total contribution margin.Component A $fill in the blank 12 units Component B $fill in the blank 13 units Total contribution $fill in the blank 14
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…
A small candy shop is preparing for the holiday season. The owner must decide how many bags ofdeluxe mix and how many bags of standard mix of Peanut/Raisin Delite to put up. The deluxe mixhas 2⁄3 pound raisins and 1⁄3 pound peanuts, and the standard mix has 1⁄2 pound raisins and 1⁄2 poundpeanuts per bag. The shop has 90 pounds of raisins and 60 pounds of peanuts to work with.Peanuts cost $.60 per pound and raisins cost $1.50 per pound. The deluxe mix will sell for $2.90for a one-pound bag, and the standard mix will sell for $2.55 for a one-pound bag. The owner estimates that no more than 110 bags of one type can be sold.a. If the goal is to maximize profits, how many bags of each type should be prepared?b. What is the expected profit?
Mr Sng is a retiree in his late sixties. He has $100,000 to invest. He has no regular source of income and no other assets. He is evaluating between 3 different lump-sum financial products shown in Table 3. All products require a minimum investment sum of $100,000. Monetary returns represent the net gain after one year of investing in the product. For example, if Mr Sng chose to invest in Product B, he may lose $5,000 after one year if the GDP growth is negative. He will earn $8,000 if the GDP growth exceeds 2% at the end of the year. If you were in the shoes of Mr Sng, how would you select the appropriate investment product for a time horizon of one year? (i) Use the Optimistic, Conservative and Regrets payoff analysis approaches. State which product(s) Mr Sng should invest in and what monetary return he can expect from each approach (ii) As you have only enough funds for one product, identify the most appropriate investment product. [Hint: Be sure to consider the…
The Rio Credit Union has $250,000 available to invest in a 12-month commitment and wants to invest all of it. The money can be placed in Brazilian treasury notes yielding an 8% return or in riskier high-yield bonds at an average rate of return of 9%. Credit union regulations require diversification to the extent that at least 50% of the investment be placed in Treasury notes. It is also decided that no more than 40% of the investment be placed in bonds. The aim of the objective function for Rio Credit Union should be to Maximize the objective value. Decision variables: X = $ invested in Treasury notes Y = $ invested in Bonds Objective function (in decimals, eg., .07, NOT 7%): The optimal ROI occurs when: X = Y = (enter your response as a whole number). Optimal ROI value 'Z' = (enter your response as a whole number)