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...
-
Why might the importance of physical co-location in industrial clusters diminish relative to online networks or virtual hubs of specialists?
-
The average American family of four spends $5000 per year on food prepared at home. Assuming a normal distribution with a standard deviation of $1000 and a randomly selected American family of four,...
-
Transmissibility is the ratio of a. force transmitted and exciting force b. force applied and the resulting displacement c. input displacement and output displacement
-
Data for Maris Company are given in BE10-1. In the second quarter, budgeted sales were $380,000, and actual sales were $384,000. Prepare a static budget report for the second quarter and for the year...
-
Let's begin with an example of negligence that you could experience in normal, everyday life. Phillip is driving down Bard Street--a residential street with normally little traffic. The posted speed...
-
1. Determinewhether differences exist in the relationship status and the self rated fitness based on the product purchased ( TM195, TM498, TM798). 2. Write a report to be presented to the management...
-
William is a music composer who works at the NFL network. He often composes original short songs to play in various videos and clips shown on the network or their distributed products. Who will be...
-
8.5 moles of an ideal gas (monatomic) expand adiabatically, and performing 8300 J of work in the process. (a) What is the change in internal energy of the gas?. (b) What is the change in temperature...
-
When a 295 g piece of iron at 190C is placed in a 95 g aluminum calorimeter cup containing 250 g of a liquid at 10C, the final temperature is observed to be 38C. Determine the specific heat of the...
-
A glass window is 2.0 m wide and 1.5 m high and 7.5 mm thick. The temperature of the inner surface is 18 C and that of the outer surface is 11 C. (a) Find the rate of heat flow through the window....
-
On a clear day, a person lying on a beach. If the sun rays make an angle of 45 from the vertical, what is the rate of energy absorption from the Sun by the person? Assume the surface area of the...
-
1. Within 5.0 s of lift-off, a space shuttle reaches an altitude of 525 m, uniformly accelerating during the entire time. (a) What is its acceleration? (b) At what speed is the shuttle travelling...
-
Who is receiving the money in a "push" transaction?
-
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 life \(T\) in hours of a vibration transducer is found to follow exponential distribution \[p_{T}(t)= \begin{cases}\lambda e^{-\lambda t}, & t \geq 0 \\ 0, & t <0\end{cases}\] where \(\lambda\)...
-
Fill in the Blank. If any parameter of a vibrating system is not known precisely, the resulting vibration is called ____________ vibration.
-
The probability distribution function, \(P(\widetilde{x})\), denotes a. \(P(x \leq \tilde{x})\) b. \(P(x>\widetilde{x})\) c. \(P(\tilde{x} \leq x \leq \tilde{x}+\Delta x)\)
Study smarter with the SolutionInn App