Your Lego furniture company makes Tables and Chairs. Below, you are given thestarting inventory, selling price, and Bill of Materials (recipe, or constructionrequirements). You are to determine the number of Tables and Chairs to be built tomaximize revenue.Your answer will be the revenue generated by your production plan - rounded to thenearest whole dollar. (The number of tables and chairs may not be a whole number,which is acceptable in this chapter.)Use Scenario 2Large wood per TableSmall wood per TableLarge wood per ChairSmall wood per ChairRevenue per TableRevenue per ChairLarge wood inventorySmall wood inventoryScenario 1321+$20$168580Scenario 2 Scenario 3 Scenario 44224$22$1690502233$19$1990502+34$18$2180130Scenario552260$25$22200190

The question stated to use scenario 2.

Answered: Your Lego furniture company makes…

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter7: Nonlinear Optimization Models

Section: Chapter Questions

Problem 50P

See similar textbooks

Similar questions

You want to take out a 450,000 loan on a 20-year mortgage with end-of-month payments. The annual rate of interest is 3%. Twenty years from now, you will need to make a 50,000 ending balloon payment. Because you expect your income to increase, you want to structure the loan so at the beginning of each year, your monthly payments increase by 2%. a. Determine the amount of each years monthly payment. You should use a lookup table to look up each years monthly payment and to look up the year based on the month (e.g., month 13 is year 2, etc.). b. Suppose payment each month is to be the same, and there is no balloon payment. Show that the monthly payment you can calculate from your spreadsheet matches the value given by the Excel PMT function PMT(0.03/12,240, 450000,0,0).
Finally, due to budget constraint, your inititial budget of $100,000 has been reduced to $75,000. SET YOUR CONSTRAINTS, DECIDE WHICH AREAS/TASKS BUDGET TO BE ADJUSTED AND USE EXCEL SOLVER TO CREATE YOUR FINAL BUDGET. Submit your plan and your reasoning behind the decisions and why your plan will make the event a success. Excel spreadsheet must show the distribution of your initial budget of $100,000 and your final budget of $75,000 with the constraints you set. Use the the excel spreadsheet image and show constraints.
PLEASE USE SIMPLEX METHOD. Thank you! Suppose a company manufactures different electronic components for computers. Component A requires 2 hours of fabrication and an hour of assembly. Component B requires 3 hours of fabrication and an hour of assembly, and component C requires 2 hours of fabrication and 2 hours of assembly. The company has upto 1,000 labor-hours for fabrication, 800 labor-hours of assembly time each work. If the profit on each component A, B, and C is $7, $8, and $10 respectively, how many of each should be produced to maximize profit?
A local finance company quotes a 16 percent interest rate onone-year loans. So, if you borrow $26,000, the interest for the year will be $4,160. Because you must repay a total of $30,160 in one year, the finance company requiresyou to pay $30,160y12, or $2,513.33, per month over the next 12 months. Is this a15 percent loan? What rate would legally have to be quoted? What is the effectiveannual rate?
Spein Company is a diversified company that discloses supplemental financial information on itssegments. The following information is available for 2019:Sales Traceable Costs Allocable CostsSegment X $400,000 $225,000Segment Y 300,000 240,000Segment Z 200,000 135,000Totals $900,000 $600,000 $150,0006Allocable costs are assigned based on the ratio of a segment’s income before allocable costs to totalincome before allocable costs. This is an appropriate method of allocation. Segment Y’s profit for 2019is ____________________.A. 32,400 Small; 8,100 Medium; 1,620 LargeB. 34,808 Small; 8,700 Medium; 1,740 LargeC. 37,010 Small; 9,250 Medium; 1,850 LargeD. 38,505 Small; 9,625 Medium; 1,925 Large
Answer the following true or false.a. The lead time is always less than the cycle time.b. The optimal lot size for a Type 1 service objective of X percent is always less than the optimal lot size for a Type 2 service objective of X percent for the same item.c. The newsvendor model does not include a fixed order cost.d. ABC analysis ranks items according to the annual value of their demand.e. For a finite production rate model, the optimal lot size to produce each cycle is equal to the maximum inventory each cycle.
I need help with d, e, and f. I already did a, b, and c. You do not need to use Solver or solve the problems. Just respond to the problem questions using the outputs provided in the problem. A picture in the attach image is a complete question. 1. Recall the Innis Investments problem (Chapter 2, Problem 39). Letting S= units purchased in the stock fund M= units purchased in the money market fund leads to the following formulation: Min 8S + 3M s.t. 50S + 100M≤ 1,200,000 funds available 5S + 4M≥ 60,000 Annual income M≥ 3,000 Units in money market S, M≥ 0 a. What is the optimal solution, and what is the minimum total risk? Already did this part b. Specify the objective coefficient ranges. Already did this part c. How much annual income will be earned by the portfolio? I also did this part too d. What is the rate of return for the portfolio? e. What is the dual value for the funds available constraint? f. What is the marginal rate of…
The operations manager of a mail order house purchases double (D) and twin (T) beds for resale. Each double bed costs $500 and requires 100 cubic feet of storage space. Each twin bed costs $300 and requires 90 cubic feet of storage space. The manager has $75,000 to invest in beds this week, and her warehouse has 18,000 cubic feet available for storage. Profit for each double bed is $300 and for each twin bed is $150. The manager’s goal is to maximize profits.What is the weekly profit when ordering the optimal amounts?
The operations manager of a mail order house purchases double (D) and twin (T) beds for resale. Each double bed costs $500 and requires 100 cubic feet of storage space. Each twin bed costs $300 and requires 90 cubic feet of storage space. The manager has $75,000 to invest in beds this week, and her warehouse has 18,000 cubic feet available for storage. Profit for each double bed is $300 and for each twin bed is $150. The manager’s goal is to maximize profits.What is the weekly profit when ordering the optimal amounts? Multiple Choice $54,000 $0 $42,000 $45,000 $30,000
Tyler is hoping to get a lot of custom cake and cookie orders in his new bakery for various parties and celebrations. He considers keeping a stock of celebratory helium balloons in his bakery so that he can sell them alongside the cakes and cookies to add more value for his customers. However, he knows that the demand for custom goods as well as the balloons is like to be probabilistic in nature instead of deterministic. He is trying to create a model of how many balloons to order to keep in stock to minimize the costs of inventory in his little bakery. He identifies the following characteristics and needs your help in filling out the table given below the information. Ordering Cost is $14.00 per order Cost of balloons is $4.00 per balloon The bakery uses the 20% annual holding cost rate for all inventory The lead time for a new order of helium balloons is 14 days. Data from other bakeries indicate that the demand during the 14-day lead time follows a normal probability distribution…
Answer the following questions. Make sure to number your answers when you upload your response. Suppose Alphonso’s town raised the price of bus tickets to $2.50 per trip (while the price of burgers stayed at $3.50 and his budget remained $11.50 per week.) Draw Alphonso’s new budget constraint. What happens to the opportunity cost of bus tickets? Suppose Alphonso’s town raises the price of bus tickets from $2.50 to $5 and the price of burgers rises from $3.50 to $7. Why is the opportunity cost of bus tickets unchanged? Suppose Alphonso’s weekly spending money increases from $11.50 to $23. How is his budget constraint affected from all three changes? Explain. Use this information to answer the following 4 questions: Marie has a weekly budget of $24, which she likes to spend on magazines and pies. If the price of a magazine is $4 each, what is the maximum number of magazines she could buy in a week? If the price of a pie is $12, what is the maximum number of pies she could buy in a…
A market analyst working for a small appliance manufacturer finds that if the firm produces and sells x blenders annually, a model for the total profit (in dollars) is P(x) = 8x + 0.3x2 − 0.001x3 − 372. Graph the function P in an appropriate viewing rectangle, and use the graph to answer the following questions. (a) When just a few blenders are manufactured, the firm loses money (profit is negative). (For example, P(10) = −263, so the firm loses $263.00 if it produces and sells only 10 blenders.) How many blenders must the firm produce to break even? (Round your answer to the nearest whole number.) blenders(b) Does profit increase indefinitely as more blenders are produced and sold? YesNo If not, what is the largest possible profit the firm could have? (If profit increases indefinitely, enter your answer as ∞. Otherwise, round your answer to the nearest cent.)

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