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.

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…
Please refer to the attached file:
Please solve using Excel @Risk add-in the question is Textbook Problem from Practical Management Science 6th Edition Chapter 11.4 Problem 30P. In the solution please provided step-by-step excel formulas used. The full Question is attached in the image. Seas Beginning sells clothing by mail order. An important question is when to strike a customer from the company’s mailing list. At present, the company strikes a customer from its mailing list if a customer fails to order from six consecutive catalogs. The company wants to know whether striking a customer from its list after a customer fails to order from four consecutive catalogs results in a higher profit per customer. Thefollowing data are available:-> If a customer placed an order the last time she received a catalog, then there is a 20% chance she will order from the next catalog.-> If a customer last placed an order one catalog ago, there is a 16% chance she will order from the next catalog she receives.-> If a customer…
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.
Jack and Jill are starting a restaurant together. They want everyone at the restaurant to have a uniform look. Jack suggests they order black-and-pink outfits for everyone since the color scheme matches their branding. Jill suggests they simply ask everyone to wear black for work since everyone should own black pants and tops. Whose reasoning is more effectual? Jack's or Jill's typed answer correctly please. I ll rate
Jasmine owns 12 apartment buildings in a college town, which it rents exclusively to students. Each apartment building contains 120 rental units, but the owner is having cash flow problems due to an average vacancy rate of nearly 50 percent. The apartments in each building have comparable floor plans, but some buildings are closer to campus than others. Jasmine’s accumulated data from last year on the number of apartments rented, the rental price (in dollars), and the amount spent on advertising (in hundreds of dollars) at each of the 12 apartments are available below. These data, along with the distance (in miles) from each apartment building to campus, are presented below. Jasmine is looking for expert advice on the available data to inform administrative and business policy. By applying this scenario, help her regress the quantity demanded of her apartments on price, advertising, and distance datasets by using Excel or SPSS. Observation or (Number of Apartments) Quantity…
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
du/courses/423127/quizzes/3325 take/questions/60963079 Table on the right shows the net cashflow (NCF) and cumulative cashflow for two projects X and Y. Answer the following questions. 1- Based on Descarte's rule of signs, what is the max. number of real ROR (i*) for project X? (put numerical number) 2- Looking at cumulative CF of project X, can we tell that it has only one positive i* value? (put "yes" Project X Project Y Year NCF Cumulative CE NCF Cumulative CF or "no") 180 -100 20,000 20,000 1 50 -130 16,000 36,000 3- Based on Descarte's rule of signs, what is the 36,000 2 50 80 50 30 25,000 25,000 max. number of real ROR (i*) for project Y? (put 4 50 20 30,000 5,000 numerical number) 4- Looking at cumulative CF of project Y, can we tell that it has only one positive i* value? (put "yes" or "no")
Please provide formula and answer
Please do not give solution in image formate thanku. Develop a production plan and calculate the annual cost for a firm whose demand forecast is fall, 10,000; winter, 8,000; spring, 7,000; summer, 12,000. Inventory at the beginning of fall is 500 units. At the beginning of fall, you currently have 30 workers, but you plan to hire temporary workers at the beginning of summer and lay them off at the end of summer. In addition, you have negotiated with the union an option to use the regular workforce on overtime during winter or spring if overtime is necessary to prevent stock outs at the end of those quarters. Overtime is not available during the fall. Relevant costs are hiring, $100 for each temp; layoff, $200 for each worker laid off; inventory holding, $5 per unit-quarter; backorder, $10 per unit; straight time, $5 per hour; overtime, $8 per hour. Assume that the productivity is 0.5 unit per worker hour, with eight hours per day and 60 days per season.
10/Do not solve it in excel , please.

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