Your Lego furniture company makes Tables and Chairs. Below, you are given the startinginventory, selling price, and Bill of Materials (recipe, or construction requirements). You areto determine the number of Tables and Chairs to be built to maximize revenue. You mustmake 6 chairs for every table.Your answer will be the revenue generated by your production plan - rounded to the nearestwhole dollar. (The number of tables and chairs must be a whole number.)Use Scenario 4Scenario 1 Scenario 2 Scenario 3 Scenario 4 Scenario 548862441231454$88$75$45$338806657751,400Large wood per Table 6Small wood per Table 6Large wood per Chair 2Small wood per Chair 4Revenue per Table $35Revenue per Chair $29Large wood inventory 300Small wood inventory 500$42$2940050016$95$499004,000

To find: The number of chair and table for maximize revenue. Given: For scenario 4 the large wood…

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

Assume the demand for a companys drug Wozac during the current year is 50,000, and assume demand will grow at 5% a year. If the company builds a plant that can produce x units of Wozac per year, it will cost 16x. Each unit of Wozac is sold for 3. Each unit of Wozac produced incurs a variable production cost of 0.20. It costs 0.40 per year to operate a unit of capacity. Determine how large a Wozac plant the company should build to maximize its expected profit over the next 10 years.
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…
AutoTime, a manufacturer of electronic digital timers, has a monthly fixed cost of $50,000 and a production cost of $7 for each timer manufactured. The timers sell for $15 each. (a) What is the cost function C(x)?C(x) = (b) What is the revenue function R(x)?R(x) = (c) What is the profit function P(x)?P(x) = (d) Compute the profit (loss) corresponding to production levels of 3000, 6000, and 11,000 timers, respectively. (Input a negative value to indicate a loss.) 3000 timers $ 6000 timers $ 11,000 timers $
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) =
Each day, QBlitz, a Seattle-based startup, offers a single product through its website.The product is available for order only on one day, and no other products are availableduring that day. To add to this odd selling strategy, QBlitz does not post prices for itsproducts. Instead, for each product there is a reserve price. On the day a product is available, customers can submit bids. All of the bids that exceed the reserve price are told atthe end of the day that they “won” the product and they pay the price they bid. QBlitzthen adds up all of the winning bids and submits an order to a supplier for the neededquantity. If the supplier delivers that quantity, then QBlitz ships the product to the winners once the product is received. However, if the supplier delivers only a portion ofthe ordered quantity, then QBlitz ships the product to the highest bidders that it cansatisfy and notifies the others that they will receive a refund because they will not in factreceive the product. The…
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)…
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?
4. A publisher prints copies of a popular weekly tabloid for distribution and sale. The fixed costs are $500 per print run, with each copy printed costing an additional $0.40. If C(q) is the cost function (in $) of the price of the print run as a function of copies printed, what is the formula for C(q)? Select one: a. C(q) = 500 + 0.4q b. C(q) = 500q + 0.4 c. C(q) = (500 + 0.4)q d. C(q) = 500 - 0.4q e. C(q) = 500q - 0.4 5. A hot dog vendor sells an average of 50 hot dogs during a Little League baseball game. If the sales are Normally distributed with a standard deviation of 7 hot dogs, what is the probability the vendor will sell between 45 and 65 hot dogs? Select one: a. 74.50% b. 92.36% c. 99.78% d. 174.50% e. 2.14 f. -0.71 g. 0.71
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 package holiday company is about to block book hotel rooms for the coming season. The number of holidays actually booked is equally likely to be any number between 0 and 99 (for simplicity rather than reality). Each room booked costs the company $250 and they can sell them for $350. a) How many rooms should the company book if unsold rooms have no value? b) How many rooms should it book if unsold rooms can be sold as last-minute bookings for $100 each?
Suppose the amount of steel was decreased by D units.What is the impact on the optimum objective value?How large can the increase in steel availability be sothat the shadow price remains as 228 4/7 (1,600/7)?Suppose that steel becomes available at $545 perthousand pounds. Should you purchase the steel? Suppose that you could purchase a thousand pounds ofsteel for $205. Should you purchase the steel?
Dark beer is purchased by the case for $18.90. There are 24 bottles in each case, and each bottle contains 12 fluid ounces. You are making brine that requires 2 ½ quarts of dark beer. How much will the beer cost for the brine?

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