A manufacturer of office furniture makes conference tables in two styles Premier and Executive. Each style...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
A manufacturer of office furniture makes conference tables in two styles Premier and Executive. Each style is available in either walnut or cak Matching chairs are also manufactured in both styles, in either walnut or oak. The material and labor requirements for each product are given below Assume there is no distinction between walnut and oak in these requirements. Wood (sq ft) Labor (hrs) Premier Executive Premier Table Table Chair Walnut Oak 100 9 The selling prices for each product are given below. Premier Table 140 12 $1200 1000 Executive Table 16 4 $1500 1200 Premier Chair $200 180 Executive Chair 20 5 Executive Chair $250 220 Furniture-grade walnut costs $5 per square foot, and oak costs $4. Labor costs $18 per hour. Only 3000 hours of labor are available per week. Develop a linear optimization model to determine the most profitable weekly production schedule. (Hint: There are eight different products: two walnut tables, two oak tables, two walnut chairs, and two oak chairs. Let x, be the number of units of the ith product manufactured per week. where i=1,2,..., 8.) Solve the problem using Excel's Solver feature. A manufacturer of office furniture makes conference tables in two styles Premier and Executive. Each style is available in either walnut or cak Matching chairs are also manufactured in both styles, in either walnut or oak. The material and labor requirements for each product are given below Assume there is no distinction between walnut and oak in these requirements. Wood (sq ft) Labor (hrs) Premier Executive Premier Table Table Chair Walnut Oak 100 9 The selling prices for each product are given below. Premier Table 140 12 $1200 1000 Executive Table 16 4 $1500 1200 Premier Chair $200 180 Executive Chair 20 5 Executive Chair $250 220 Furniture-grade walnut costs $5 per square foot, and oak costs $4. Labor costs $18 per hour. Only 3000 hours of labor are available per week. Develop a linear optimization model to determine the most profitable weekly production schedule. (Hint: There are eight different products: two walnut tables, two oak tables, two walnut chairs, and two oak chairs. Let x, be the number of units of the ith product manufactured per week. where i=1,2,..., 8.) Solve the problem using Excel's Solver feature.
Expert Answer:
Related Book For
International Business Competing in the Global Marketplace
ISBN: 978-1259578113
11th edition
Authors: Charles W. L. Hill
Posted Date:
Students also viewed these accounting questions
-
Based on past sales experience, an appliance store stocks five window air conditioner units for the coming week. No orders for additional air conditioners will be made until next week. The weekly...
-
Kelson Sporting Equipment, Inc., makes two different types of baseball gloves: a regular model and a catcher's model. The firm has 800 hours of production time available in its cutting and sewing...
-
Let S = {{a}, b, {a, {b}}, c}. Which one of the following relations on S is a strict partial order? Select one: a. {(c, {a}), (b, {a}), ({a, {b}}, {a})} b. {({a}, {a}), (b, b), (c, c)} c. {({a}, b),...
-
Susan recently quit working for a local firm and has yet to find a new job. She knows she can maintain her health insurance from her old employer due to COBRA. How much will it likely cost her for...
-
a. Why did options trading fall into disrepute in the United States during the early de cades of the twentieth century? b. What was the SECs original stance towards options trading? c. What was the...
-
Danton plc has 10 million ordinary shares in issue with a current market value of 2.00 per share. The expected dividend for next year is 16p per share and this is expected to grow each year at a...
-
How is the California court system structured?
-
Matilda owns a condominium on the beach in Rehoboth, Delaware. During the current year, she incurs the following expenses related to the property: Mortgage interest ...... $8,000 Property taxes...
-
Roy is an executive in the computer industry, and he is in the process of leaving his former employer to work for a relatively new company. He and his wife Rowena have two children: Roland, age 24,...
-
A job shop consists of 6 different machines and 4 different jobs are to be processed through these machines. The job interarrival time follows Exp(15) mins. Each job is processed on a series of...
-
5 Year Budget a budget that will improve the operations and gain market share for the organization, one has to make the following assumptions: Net revenue for the organization will increase by 1% due...
-
Explain how the federal cash management system is considerably different from those of state and local governments ?
-
From your experiences working with and/or around HR department representatives are they performing as they should be and focusing on the right things? What are some examples of activities where HR is...
-
Write a proposal about the gap in employee education and training in your company to your boss. Conduct your findings and recommendations. Complete your research report. Your boss wants you to...
-
Cost of sales for the year ended June 30, 2020 $ 510,000 Inventory balance on June 30, 2019 125,000 Inventory balance on June 30, 2020 165,000 Based on the values given above, what would...
-
What was Elton Mayo's most important improvement brought about by the Hawthorne studies?
-
investigate a social media public relations (PR) campaign by an organization. Some examples of platforms are LinkedIn, Twitter, Facebook, Google+, Pinterest, and YouTube. The organizations can be...
-
Is times interest earned meaningful for utilities? Why or why not?
-
Who benefits from subsidies to U.S. sugar producers? Who loses?
-
Why does Microsoft continue to hold so much cash overseas, rather than returning it to the United States? What do you think are the opportunity costs of holding tens of billions of dollars of cash in...
-
A firm based in California wants to export a shipload of finished lumber to the Philippines. The would-be importer cannot get sufficient credit from domestic sources to pay for shipment but insists...
-
The equations of motion of a two-degree-of-freedom system are given by where \(F_{1}(t)\) denotes a rectangular pulse of magnitude 5 acting over \(0 \leq t \leq 2\). Find the solution of the...
-
Find the response of a simple pendulum numerically by solving the linearized equation: \[\ddot{\theta}+\frac{g}{l} \theta=0\] with \(\frac{g}{l}=0.01\) and plot the response, \(\theta(t)\), for \(0...
-
Find the response of a simple pendulum numerically by solving the exact equation: \[\ddot{\theta}+\frac{g}{l} \sin \theta=0\] with \(\frac{g}{l}=0.01\) and plot the response, \(\theta(t)\), for \(0...
Study smarter with the SolutionInn App