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 40P

See similar textbooks

Similar questions

In Problem 12 of the previous section, suppose that the demand for cars is normally distributed with mean 100 and standard deviation 15. Use @RISK to determine the best order quantityin this case, the one with the largest mean profit. Using the statistics and/or graphs from @RISK, discuss whether this order quantity would be considered best by the car dealer. (The point is that a decision maker can use more than just mean profit in making a decision.)
Create a spreadsheet to calculate your projected total costs, total revenues, and total profits for giving a seminar on cost estimating. Make the following assumptions: You will charge $600 per person for a two-day class. You estimate that 30 people will attend the class, but you want to change this input. Your fixed costs include $500 total to rent a room for both days, setup fees of $400 for registration, and $300 for designing a postcard for advertising. Youwill not include your labor costs for this estimate, but you estimate that you will spend at least 150 hours developing materials, managing the project, and giving the actual class. You would like to know what your time is worth given different scenarios. Youwill order 5,000 postcards, mail 4,000, and distribute the rest to friends and colleagues. Yourvariable costs include the following: $5perperson for registration plus 4 percent of the class fee per person to handle credit card processing; assume that everyone pays…
you own a furniture store and you are in the process of planning the production of wooden chairs for the next six months. your demand forecast for wooden chairs for the next six months is 150,100,200,300,50,200. you currently stock 50 chairs in stock. one of your customers informed you that they would be returning 50 additional chairs to you and you expect to receive these returns in month 2. you currently employ 10 skilled employees who work entirely making chairs. in the last six months they were able to make 900 chairs working full time. you are considering two alternative production plans: constant workforce level for the next six months and meet all demand on time. adjust your workforce level only once over the next six months after month 0. ( no still backlogging). hiring cost per employee=$1000holding cost monthly per chair=$10 lay off cost per emloyee=$2000payroll cost monthly per employee=$2000 implement each alternative to obtain the least total cost. solve this question…
you own a furniture store and you are in the process of planning the production of wooden chairs for the next six months. your demand forecast for wooden chairs for the next six months is 150,100,200,300,50,200. you currently stock 50 chairs in stock. one of your customers informed you that they would be returning 50 additional chairs to you and you expect to receive these returns in month 2. you currently employ 10 skilled employees who work entirely making chairs. in the last six months they were able to make 900 chairs working full time. you are considering two alternative production plans: constant workforce level for the next six months and meet all demand on time. adjust your workforce level only once over the next six months after month 0. ( no still backlogging). hiring cost per employee=$1000holding cost monthly per chair=$10 lay off cost per emloyee=$2000payroll cost monthly per employee=$2000 implement each alternative to obtain the least total cost. solve this question with…
Barbara Flynn sells papers at a newspaper stand for $0.40. The papers cost her $0.30, giving her a $0.10 profit on each one she sells. From past experience Barbara knows that: a) 20% of the time she sells 150 papers. b) 20% of the time she sells 200 papers. c) 30% of the time she sells 250 papers. d) 30% of the time she sells 300 papers. Assuming that Barbara believes the cost of a lost sale to be $0.05 and any unsold papers cost her $0.30 and she orders 250 papers. Use the following random numbers: 14, 4, 13, 9, and 25 for simulating Barbara's profit. (Note: Assume the random number interval begins at 01 and ends at 00.) Based on the given probability distribution and the order size, for the given random number Barbara's sales and profit are (enter your responses for sales as integers and round all profit responses to two decimal places): Random Number Sales Profit 14 4 13 9 25
A manufacturer has a monthly fixed cost of $44,000 and a production cost of $9 for each unit produced. The product sells for $13/unit. (a) What is the cost function? C(x) = (b) What is the revenue function? R(x) = (c) What is the profit function? P(x) = (d) Compute the profit (loss) corresponding to production levels of 9,000 and 13,000 units. P(9,000) = P(13,000) =
I need assistance with Chapter 15 Problem 7. I keep getting an it incorrecrt despite calculating the sum and dividing everything by the quanitity. Thank you
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)…
Which of the following statements is correct regarding the EMH form? Select one: None of the answers are correct If the market is weak-form efficient, then it is also semistrong and strong-form efficient. If the market is semistrong form efficient, then it is also strong form efficient If a market is strong-form efficient, it is also semistrong and weak form efficient If the market is strong-form efficient, it is also semistrong but not weak-form efficient
Ruth Company currently has $1,000,000 in accounts receivable. Its days sales outstanding (DSO) is 50days. The company wants to reduce its DSO to the industry average of 32 days by pressuring more ofits customers to pay their bills on time. The company’s CFO estimates that if this policy is adopted thecompany’s average sales will fall by 10 percent. Assuming that the company adopts this change andsucceeds in reducing its DSO to 32 days and does lose 10 percent of its sales, what will be the level ofaccounts receivable following the change? Assume a 365-day year.
Monsanto sells genetically modified seed to farmers. It needs to decide how much seed to put into a warehouse to serve demand for the next growing season. It will make one quantity decision. It costs Monsanto $8 to make each kilogram (kg) of seed. It sells each kg for $45. If it has more seed than demanded by the local farmers, the remaining seed is sent overseas. Unfortunately, it only earns $3 per kg from the overseas market (but this is better than destroying the seed because it cannot be stored until next year). If demand exceeds its quantity, then the sales are lost—the farmers go to another supplier. As a forecast for demand, it will use a normal distribution with a mean of 300,000 and a standard deviation of 100,000. Round your answer to 2 digits after the decimal point if it is not an integer. Do NOT use comma in your numeric answers. Use excel for accurate numbers. Don't round until the end. Monsanto’s maximum profit for this seed is $[xa]. The underage cost is $[xb]. The…
In the spreadsheet model shown below, an analyst makes the following data entries. Cell B3 B4 B5 B6 Value 110,000 83,000 82,000 92,000 A 1 Revenue 2 Month Change (%) n/a Revenue 3 January 4 February 5 March =(B4-B3)/B3 =(B5-B4)/B4 6 April =(B6-B5)/B5 What values will be shown in the following cells? (Negative values should be indicated by a minus sign. Round your answers to 2 decimal places.) Cell Value C4 C5 % C6 %

SEE MORE QUESTIONS

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