CSto searchYour Lego furniture company makes Tables and Chairs. Below, you are given the startinginventory, selling price, and Bill of Materials (recipe, or construction requirements). Youare to determine the number of Tables and Chairs to be built to maximize revenue.Your answer will be the amount of small wood pieces used by your production plan -rounded to the nearest whole dollar. (The number of tables and chairs must be a wholenumber.)Use Scenario 5Large wood per Table 1Small wood per Table 3Large wood per Chair 1Small wood per Chair 4Revenue per Table $27Revenue per Chair $17Large wood inventory 85Small wood inventory 80OScenario 1 Scenario 2 Scenario 3 Scenario 4 Scenario 5225322214Et$23$1690503₂.3$29$1910050323334$18$21801306$48$4320019085°F^(8)D

Answered: Image /qna-images/answer/d6a2766f-d8b7-4882-8dea-957917f44007.jpg

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

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…
In the prospectus for the Brazos Aggressive Growth fund, the fee table indicates that the fund has a 12b-1 fee of 0.35 percent and an expense ratio of 1.55 percent that is collected once a year on December 1. Joan and Don Norwood have shares valued at $114,500 on December 1. What is the amount of the 12b-1 fee this year? What is the amount they will pay for expenses this year?
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
A chef must decide how many chocolate lava cakes to prepare for the upcoming Mother's Day Dinner special. The chef can either prepare 50, 100, or 150 lava cakes. Assume that demand for the lava cakes can be 50, 100, or 150. Each dish costs $5 to make and is priced at for $7 on the menu. Unsold cakes are donated to a nearby charity center. Assume that there is no opportunity cost for lost sales. Which alternative should be chosen based on the maximax criterion?
Note:- Do not provide handwritten solution. Maintain accuracy and quality in your answer. Take care of plagiarism. Answer completely. You will get up vote for sure.
A student who is majoring in accounting has two jobs offers: one from PwC for $80,000 and one for E&Y for $76,000. She just found out that she has also received an offer from her dream company, Deloitte for $72,000. She also heard from friends that another student last year may have received an offer averaging around $90,000. She wants to take the Deloitte offer, but her OB professor tells her that she needs to negotiate with them for a better salary. In this negotiation, what is her BATNA? O a O b. $76,000 $72,000 $90,000 $18,000 (the difference between $90,000 and $72,000) OC O d. Oe. $80,000
Solve asap
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
What is the relative tax advantage of corporate debt if the corporate tax rate is Tc=0.21 , the personal tax rate on interest is TpD=0.37 , but all equity income is received as capital gains and escapes tax entirely ( TpE=0 )? How does the relative tax advantage change if the company decides to pay out all equity income as cash dividends that are taxed at 20%? Note: Do not round intermediate calculations. Round your answers to 4 decimal places.
An automobile company has two versions of the same model car for sale, a two-door coupe and full-size four doors. Suggest method to solve this problem and reason of using that method. Predict the maximum company's profit will be generated. Table 2 Cars production schedule Two-door Four-door Availability RM 17,000/car 20 h/car RM 21,000/car 22 h/car 300 cars 350 cars Profit Production time 11,000 h/year Storage Consumer demand 500 cars 600 cars 150,000 cars
Nippon Steel's expenses for heating and cooling a large manufacturing facility are expected to increase according to an arithmetic gradient beginning in year 2. If the cost is $550,000 this year (year 0) and will be $550,000 again in year 1, but then it is estimated to increase by $45,000 each year through year 12, what is the equivalent annual worth in years 1 to 12 of these energy costs at an interest rate of 11% per year? The equivalent annual worth is determined to be $

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