Please solve it on excel using solver A furniture manufacturer produces two types of tables (country and contemporary) using threetypes of machines. The time required to produce the tables on each machine is given in the followingtable.Machine CountryRouterSanderPolisher1.53.02.5Contemporary2.04.51.5Total Machine Time Available per Week1,0002,0001,500Country tables sell for $350, and contemporary tables sell for $450. Management has determined thatat least 20% of the tables made should be country and at least 30% should be contemporary. Howmany of each type of table should the company produce if it wants to maximize its revenue?a. Formulate an LP model for this problem.b. Create a spreadsheet model for this problem, and solve it using Solver.c. What is the optimal solution?d. How will your spreadsheet model differ if there are 25 types of tables and 15 machine processesinvolved in manufacturing them?

Objective Functions and Constraints: Based on the given details, the objective…

Answered: A furniture manufacturer produces two…

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter12: Queueing Models

Section: Chapter Questions

Problem 59P

See similar textbooks

Similar questions

Because of its labor contract, a company must hire enough labor for 100 units ofproduction per week on one shift or 200 units per week on two shifts. It cannot hire,lay off, or assign overtime. During the fourth week, workers will be available fromanother department to work part or all of an extra shift (up to 100 units). There is aplanned shutdown for maintenance in the second week, which will cut production tohalf. Develop a production plan. The opening inventory is 200 units, and the desiredending inventory is 300 units
The Ace Manufacturing Company has orders for three similar products. Product A Min B C 1 2 Machine 3 Three machines are available for the manufacturing operations. All three machines can produce all the products at the same production rate. However, due to varying defect percentages of each product on each machine, the unit costs of the products vary depending on the machine used. Machine capacities for the next week and the unit costs are shown below. A A B B Ic C Product 1 12 3 Orders (units) 1,900 500 1,100 Capacity (units) 1,300 1,600 800 1 Machine 2 3 $1.00 $1.30 $1.10 $1.20 $1.40 $1.00 $0.90 $1.20 $1.20 (a) Develop the linear programming formulation of this problem. (Let XA1 be the number of units of product A produced by machine 1, X;; be the number of units of product i produced by machine j, etc.)
Structure Furniture, manufactures coffee tables. Structure Furniture has a policy of adding a 20% markup to full costs and currently has excess capacity. The following information pertains to the company's normal operations per month: Output units Machine-hours 30,000tables 8,000hours Direct manufacturing labour-hours 10,000hours Direct materials per unit Direct manufacturing labour per hour Variable manufacturing overhead costs Fixed manufacturing overhead costs Product and process design costs Marketing and distribution costs S100 S12 $322,500 $1,200,000 $900,000 $1,125,000 a) Structure Furniture is approached by an overseas customer to fulfill a one-time-only special order for 1,000 units. All cost relationships remain the same except for a one-time setup charge of $20,000. No additional design, marketing, or distribution costs will be incurred. What is the minimum acceptable bid per unit on this one-time-only special order? b) What is the Structure Furniture full product cost for…
Please answer it without using software.
Please Solve In 20mins
Prevost Chemicals manufactures an industrial solvent at its only processing plant. A liquid chemical and labor are the two primary inputs. All other resources are included in manufacturing overhead. The plant never has any work-in-process or finished goods inventories. Information from the previous four periods of production follows: Period 1 Period 2 Period 3 Period 4 Chemical input (gallons) 125,000 129,280 128,000 120,000 Labor input (hours) 12,500 11,200 15,000 10,100 Solvent sales (gallons) 110,000 113,120 120,000 103,020 Average price of chemical per gallon $ 2.00 $ 2.10 $ 1.95 $ 2.25 Average wage rate per hour 28.00 26.00 31.00 34.00 Average sales price per gallon 10.26 10.00 9.80 10.60 Manufacturing overhead (total) 236,000 245,312 245,400 243,080 Required: a. Compute the partial productivity measures for chemical for the four periods. b. Compute the partial productivity measures for labor for the four periods.
Prevost Chemicals manufactures an industrial solvent at its only processing plant. A liquid chemical and labor are the two primary inputs. All other resources are included in manufacturing overhead. The plant never has any work-in-process or finished goods inventories. Information from the previous four periods of production follows: Period 1 Period 2 Period 3 Period 4 Chemical input (gallons) 125,000 129,280 128,000 120,000 Labor input (hours) 12,500 11,200 15,000 10,100 Solvent sales (gallons) 110,000 113,120 120,000 103,020 Average price of chemical per gallon $ 2.00 $ 2.10 $ 1.95 $ 2.25 Average wage rate per hour 28.00 26.00 31.00 34.00 Average sales price per gallon 10.26 10.00 9.80 10.60 Manufacturing overhead (total) 236,000 245,312 245,400 243,080 Required: c. Compute the total factor productivity for the four periods.
Note: please do NOT use EXCEL
Four products are processed sequentially on three machines. The following table gives the pertinent data of the problem. Manufacturing time (hr) per unit Machine Cost of hr Product 1 Product 2 Product 3 Product 4 Capacity ($) 10 (hr) 1 2 3 4 500 2 3 2 2 380 3 4 7 3 1 450 Unit Selling Price ($) 75 70 55 45 Formulate the problem and find the optimum solution. After solving the problem, please generating Sensitivity Report. What should happen, if the capacity of Machine 1 is increased to 550 hours? A None of above B The profit is increased by $165 The profit is increased by $375 D The profit remains same
Atlas Engineering Ltd. Accepts a variety of jobs which require both and machine operations. The budgeted Profit & Loss Account for the period 2018-19 is as follows: (in lakhs of dollars) Sales 75 Cost: Direct Material 10 Direct Labour 5 Prime Cost 15 Production Overheads 30 Production Cost 45 Administration, Selling and Distribution Overheads 15 60 Profit 15 Other budgeted data : Labour hours for the period 25,000 Machine hours for the period 15,000 No. Of jobs for the period 300 An enquiry has been received recently from a customer and the production department has prepared the following estimate of the prime cost required for the job : Direct Material $ 2,500 Direct Labour $ 2,000 Prime Cost $ 4,500 Labour hours required = 80 Machine hours required = 50 You are required to: (a) Calculate by the different methods, six absorption rates for absorption of production overhead and comment on the suitable of each. (b) Calculate the production overhead cost of the order based on each of the…
A manufacturing company makes two types of water skis, a trick ski and a slalom ski. The relevant manufacturing data are given in the table. Labor-Hours per Ski Maximum Labor-Hours Department Fabricating Finishing Trick Ski Slalom Ski Available per Day 9. 432 63 If the profit on a trick ski is $30 and the profit on a slalom ski is $50, how many of each type of ski should be manufactured each day to realize a maximum profit? What is the maximum profit? The maximum profit is $ The maximum occurs when trick skis and slalom skis are produced.
Use the following information to answer the question(s) below. Cerebro Manufacturing produces four types of structural support fittings-plugs, rails, rivets, and clips-which are machined on two CNC machining centers. The machining centers have a capacity of 250,000 minutes per year. The gross margin per unit and machining requirements are shown in the spreadsheet below. D E F 11 2 3 A Cerebro Manufacturing Model 6 17 8 Product 14 Gross margin/unit Minutes/unit 15 Gross margin/minute Maximum production Profit B O 125,000 O 250,000 O None of the above C Machine Rivets Clips Capacity (mins./year) Plugs Rails $0.40 $ 1.20 $0.80 $1.10 13 1.5 250,000 Assuming that one half of the machine capacity is used for the production of plugs. What is the maximum possible production of plugs based on this capacity? O 166,666.67 83,333.33

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