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

As a potential owner of a club known as Club Salida, you are interested in determining the necessary volume of sales in dollars to reach the breakeven next year. You decided to break down the club's sales into. four categories, where beer is the first. Your estimate of the sale of beer is that it will serve 30,000 servings. The selling price per unit will average $ 1.50; its cost is $ .75. The second category is food, of which you expect sell 10,000 units with an average unit price of $ 10.00 and a cost of $ 5.00. The third category is desserts and wine, of which you also hope to sell 10,000 units, but with an average unit price of $ 2.50 and a cost of $ 1.00. The last category is inexpensive lunches and sandwiches, of which you expect sell a total of 20,000 units with an average price of $ 6.75 and a cost per unit of $ 3.25. Your fixed costs (i.e. rent, utilities, etc.) are $ 1,800 a month plus $ 2,000 a month for entertainment. a) What is your breakeven point in dollars per month? b)…
A. You are thinking about opening an oil change shop. Your fixed costs will be $13,000 per month. You will charge customers $28 for a lube-oil filter. The cost of materials is in addition to your fixed costs and is estimated at $8 per customer. How many customers must you have each month in order to break even? Hint: "Break Even" means revenues equal expenses, so we could say "fixed costs+variable costs=revenues" B. If your shop is open an average of 25 days each month., how many customers do you need each day to break even? Answer for a: 650 customers Answer for b: 26 customers per day please help me set up the equation needed to solve and get the correct answer.
You are the owner of Caché, a chain of women's clothing boutiques. Your state has a sales tax of 7%, and your city has an additional sales tax of 1.5%. Each quarter you are responsible for making these tax deposits to the city and state. Last quarter your stores had total revenue, including sales tax, of $488,250. a) How much of this revenue was sales (in $) and how much was sales tax (in $)? sales sales tax b) How much sales tax (in $) should be sent to the city? c)How much sales tax (in $) should be sent to the state?
I know this is on Bartleby, but the solution is still not leading me to understand it. Can I have a more in-depth explanation? We are thinking of opening a small copy shop. It costs us $5000 to rent a copier for a year. It costs us $0.03 per copy to operate the copier. Other fixed costs of running the store amount to $400 per month. We charge an average of $0.10 per copy. We are open 365 days per year. Each copier can make up to 100,000 copies per year. Formulate a model for annual profit.a. Create a two-way table for 1 to 5 copiers rented and daily demands of 500, 1000, 1500, and 2000 copies per day. That is, compute annual profit for each of these combinations of copiers rented and daily demand.b. If we rent three copiers, what daily demand for copies will allow us to break even?c. Using the data table from part a, chart profit as a function of the number of copiers; for a daily demand of 500 copies, and for a daily demand of 2000 copies. Show both lines on the same chart. Interpret…
Please show all work and explain answer. OneRing Company sells memorabilia to residents of Middle-Earth. They are about to invest $6 million in a new ring making plant. Fixed costs of operating the plant are $1 million a year. The ring costs $60/unit to manufacture (variable cost) and will be sold for $200/unit. The plant will last for 5 years, and will be depreciated over 5 years to zero using the straight-line method. The plant will have no salvage value after five years. Net working capital requirements are negligible for this project. Assume there are no taxes in Middle-Earth, and that the appropriate discount rate for the project is ten percent. How many rings per year must OneRing sell in order to break even?
1. You are starting a business selling ferrets. • You need a pen and supplies which will cost you $100. Also, each ferret costs $10 each. Fill the table for cost. You will sell the ferrets for $15 each. Fill the table for Money. Plot and graph both lines for Cost and Money Use the provided paper (looks like this), take a picture and submit. 400 Money ($) Cost 0. 10 10 200 20 20 30 30 40 40 50 50 10 20 30 40 50 Edit View Insert Format Tools Table 12pt v Paragraph v BIUA v 8888- Ferrets Bought 888- Ferrets sold Money ($)
Need answer ASAP. Please include the solution for the problem. Thank you.
Refer to the payoff table below of profits in ($000). Which decision alternative results from using the Conservative (Pessimestic) Decision Rule? PAYOFF TABLE High Demand Small Medium Large 35 300 550 -10 Moderate Demand 35 150 75 -10 Low Demand Do Nothing O A. Large O B. Do nothing OC. Medium O D. Small O E. Cannot be determined since relative frequencies are missing. 35 50 -45 -10
1) Which of the following translates business plan into productionplanningAPPMPSMRPNone of the Above2) Master production schedule is a medium-range planning and it isused for quantity and timing ofcomponents and raw materialFinished goodsBoth A & B3) The manufacturing strategy which deploys hiring and laying ofworkers in order to match its production rate to demand is calledLevel Production StrategyChase Production StartegyHybrid StrategyNone of the above4) "In a level production strategy, if the firm makes annual 120,00units per annum, the permonth production can be estimatted by""120,00 /12""120,00 / 365"The information is not complete5) The Bill of material is an engineering documments that showsinclusive listing and sub-components to be used for end productTRUEFALSE6) A lead capacity usually increases or decreases its capacity in anticipation of demand, this is known as "Match strategyLead Capacity StrategyLag capacity strategy7) The most important output of MRP isBOMPlanned…
you are serving a wine special: a 5 ounce glass of wine for $7.00. you purchase 2 cases of 750-ml bottles of wine (12 per case) for $215.76. At the end of the week 3 bottles remain. what is the percent of wine that remains, how many glasses of wine did you sell and what is the beverage cost percent?
Use the table provided below showing rooms available, rooms sold and rooms revenue for 7 properties (subject hotel + comp set) for one month to compute occupancy index for the subject hotel. Rooms Available (Supply) Rooms Sold (Demand) Revenue The subject hotel 10'000 7'000 700'000 Hotel A 9'000 3'000 400'000 Hotel B 9'000 8'000 700'000 Hotel C 10'000 7'000 700'000 Hotel D 000י7 5'000 500'000 Hotel E 11'000 8'000 700'000 Hotel F 8'000 4'000 400'000
Use the table provided below showing rooms available, rooms sold and rooms revenue for 7 properties (subject hotel + comp set) for one month to compute occupancy index for the subject hotel. ITI Rooms Available (Supply) Rooms Sold (Demand) Revenue The subject hotel 10'000 7'000 700'000 Hotel A 9'000 3'000 400'000 Hotel B 9'000 8'000 700'000 Hotel C 10'000 7'000 700'000 Hotel D 7'000 5'000 500'000 Hotel E 11'000 8'000 700'000 Hotel F 8'000 4'000 400'000 Select one: a. None of the above b. 106.67 c. 108.00 / d. 92.59

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