Your Lego furniture company makes Tables and Chairs. Below, you are given the starting inventory, selling price, and Billof Materials (recipe, or construction requirements). You are to determine the number of Tables and Chairs to be built tomaximize revenue.Your answer will be the number of small wood pieces used by your production plan. (The number of tables and chairs maynot be a whole number, which is acceptable in this problem; the number of pieces of wood should be rounded up the nexthighest whole number.)Use Scenario 5Large wood per TableSmall wood per TableLarge wood per ChairSmall wood per ChairRevenue per TableRevenue per ChairLarge wood inventorySmall wood inventoryScenario 16328$129$98285180Scenario 2ԼՐ5558$209$160400510Scenario 34366$195$119900500Scenario 47163$48$21820700Scenario 58488$155$189377298

Find the objective functions and Constraints below: Objective Functions: Maximize Z = 155 T + 189 C…

Answered: Your Lego furniture company makes…

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

plz solve it within 30-40 mins I'll give you multiple upvote
Hi... I'm having trouble with the following: Min Jee wants to combine the sales data from each of the art fairs. Switch to the Combined Sales worksheet, and then update the worksheet as follows: In cell A5, enter a formula without using a function that references cell A5 in the Madison Copy the formula from cell A5 to the range A6:A8 without copying the formatting. In cell B5, enter a formula using the SUM function, 3-D references, and grouped worksheets that totals the values from cell B5 in the Chicago:Madison Copy the formula from cell B5 to the range B6:B8 without copying the formatting. Copy the formulas and the formatting from the range B5:B8 to the range C5:E8. (Hint: You can ignore the error about empty cells because Min Jee will enter the Madison sales data later.)
standard mix of Peanut/Raisin Delite to put up. The deluxe mix has .68 pounds of raisins and .32 pounds of peanuts, and the standard mix has 0.5 pounds of raisins and 0.5 pounds of peanuts per bag. The shop has 80 pounds of raisins and 50 pounds of peanuts to work with. Peanuts cost $0.75 per pound and raisins cost $1.5 per pound. The deluxe mix will sell for $2.9 for 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? (Round your answers down to a whole number.) Deluxe Standard b. What is the expected profit? (Round your answer to two decimal places.) Expected profit
Suppose that you are running a factory, producing parts for cars that require steel as raw material. Your costs are predominantly human labour, which is €20/hour for your workers, and steel itself, which runs for €170/ton. Suppose that your revenue R is described as follows: R(h,s)=200h0,5s0,5, where h is hours of labour and s is tons of steel. Your total budget is €37950, what is the maximum possible revenue you could earn?
In a SGTA of 32, there are more students whose major is Marketing than any other majors, how many students could be in this class who are majoring in Marketing? A. Marketing students < = 16 B. Marketing students < 16 C. Marketing students >16 D. Marketing students > = 16
Please try to solve it within 1 hour
A company produces a component internally with a finite production rate P and the demand rate for the component is λ. The quantity needed for a production batch in period T is Q and the maximum inventory level in T is H. Use a graph to show that H will not exceed Q. Use T1 to denote uptime and T2 to denote down time.
Please refer to the attached file:
Choose the correct letter of answer If your objective is to maximize the profit for products x and y which earns a contribution margin of P2 and P3 respectively, your objective function must be: *a. P = 3x + 2yb. P = 2x + 3yc. P = x + y d. none of the above
You work for the Brad's Nailer Company which manufactures two types of nailers: a pneumatic model and a cordless model. You have contracted to supply a national retail chain with both pneumatic nailers and cordless nailers. However, Brad's nailer production capability is limited in three departments: production, testing, and packaging. Your answer will be the revenue for a production plan that maximizes revenue - rounded to the nearest whole dollar. (The number of nailers may not be a whole number, which is acceptable in this chapter.) Use Scenario 2 Pneum. Revenue Pneum. Prod Hrs Pneum. Test Hrs Pneum. Pkg Hrs Pneum. Sales Cordless Revenue Cordless Prod Hrs Cordless Test Hrs Cordless Pkg Hrs Cordless Sales Prod Hrs max Testing Hrs max Pkg Hrs max Scenario 1 Scenario 2 Scenario 3 42 0.3 0.3 0.1 21,000 67 0.3 0.4 0.1 15,000 11,000 15,000 4,800 55.50 0.4 0.3 0.1 24,500 69.75 0.3 0.5 0.1 12,000 14,000 15,000 4,800 38.50 0.25 0.4 0.1 18,000 44 0.4 0.4 0.2 14,000 14,000 15,000 4,800
A small candy shop is preparing for the holiday season. The owner must decide how many bags of deluxe mix and how many bags of standard mix of Peanut/Raisin Delite to put up. The deluxe mix has 2/3 pound raisins and 1/3 pound peanuts, and the standard mix has 1/2 pound raisins and 1/2 pound peanuts 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 $4.00 for a one-pound bag, and the standard mix will sell for $3.55 for a one-pound bag. The owner estimates that no more than 210 bags of one type can be sold. a. If the goal is to maximize profits, how many bags of each type should be prepared? Deluxe _____bags Standard ______bags b. What is the expected profit? Profit ________
Please provide formula and answer

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