A furniture manufacturer produces two types of tables – country and contemporary – using three types of machines. The time required to produce the tables on each machine is given in the following table: Machine Country Contemporary Total Machine Time Available Per Week Router 3.5 4.0 1,000 Sander 4.5 6.5 2,000 Polisher 3.0 2.0 1,500 Country tables sell for $395 and contemporary tables sell for $515. Management has determined that at least 25% of the tables made should be country and at least 38% should be contemporary. How many of each type of table should the company manufacture if it wants to maximize its revenue? Formulate an LP model for this problem Create the spreadsheet model and use Solver to solve the problem.

A furniture manufacturer produces two types of tables – country and contemporary – using three types of machines. The time required to produce the tables on each machine is given in the following table: Machine Country Contemporary Total Machine Time Available Per Week Router 3.5 4.0 1,000 Sander 4.5 6.5 2,000 Polisher 3.0 2.0 1,500 Country tables sell for $395 and contemporary tables sell for $515. Management has determined that at least 25% of the tables made should be country and at least 38% should be contemporary. How many of each type of table should the company manufacture if it wants to maximize its revenue? Formulate an LP model for this problem Create the spreadsheet model and use Solver to solve the problem.

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter4: Linear Programming Models

Section: Chapter Questions

Problem 111P

See similar textbooks

Similar questions

Help ! Choice Bank receives credit card applications that need to be reviewed for a decision. There are two types of applications; preapproved, and non-preapproved. Preapproved applications only need a quick review and therefore take 6 minutes to process. Applications that are not preapproved need a secondary credit check and take 15 minutes to process. The bank receives 10 preapproved applications every hour and 6 applications that are not preapproved every hour. What is the utilization of the process? Group of answer choices 50 % 62.5 % 68.75 % 75 % 100 %
A manager must decide which type of machine to buy, A, B, or C. Machine costs (per individual machine) are as follows: Machine Cost A B C Product forecasts and processing times on the machines are as follows: $80,000 $70,000 $40,000 Annual Product Demand 1 25,000 2 22,000 3 20,000 4 9,000 A B PROCCESSING TIME PER UNIT (minutes) A B C A 5 3 3 5 B 4 1 1 Click here for the Excel Data File Total processing time in minutes per machine: 296,000 196,000 6 a. Assume that only purchasing costs are being considered. Compute the total processing time required for each machine type to meet demand, how many of each machine type would be needed, and the resulting total purchasing cost for each machine type. The machines will operate 10 hours a day, 250 days a year. (Enter total processing times as whole numbers. Round up machine quantities to the next higher whole number. Compute total purchasing costs using these rounded machine quantities. Enter the resulting total purchasing cost as a whole…
QuestionByron Sports is a manufacturer of sportswear. It produces all of its products in one department using a process costing system.The information for the current month is as follows:Beginning work in process (30% complete as to conversion cost) 12,000 unitsUnits started 90,000 unitsUnits completed and transferred out ?Ending work in process (70% complete as to conversion) 8,000 unitsCosts:Beginning work-in-process direct materials $28,800Beginning work-in-process conversion $5,040Direct materials added during month $216,000Conversion costs incurred during the month $139,200Direct materials are added at the beginning of the process. Conversion costs are incurred uniformlythroughout the production process. Costing is handled on a FIFO basis Required:a. Prepare a production cost worksheet using 5 steps approach.b. Under what conditions would a process costing system be more appropriate than a job order costing system? Explain.
Consider a law firm with 15 lawyers and 3 paralegals. The firm is struggling to keep up with the high demand for its services, particularly during the busy litigation seasons. It has been observed that the lawyers spend a significant amount of their time on administrative tasks that could potentially be handled by paralegals. After a careful study of the work distribution within the firm, it was determined that 35% of the activities carried out by the lawyers are administrative in nature. Given that each lawyer works 50 hours a week, please determine: (a) How many additional paralegals should the firm hire to handle the administrative tasks currently performed by the lawyers? (b) If the lawyers' time spent on administrative tasks is redirected to billable legal work, by what percentage could the firm potentially increase its billable hours?
A manager must decide which type of machine to buy, A, B, or C. Machines costs are as follows: Machine Cost A $40,000 B $30,000 C $80,000 Product forecast, processing times on the machines, and setup times are as follows: Processing Time Per Unit (minutes) Product Annual Demand A B C Setup Times (minutes) Production Lots (units) 1 16,000 3 4 2 20 200 2 12,000 4 5 3 35 100 3 6,000 5 6 3 60 50 4 30,000 2 4 1 15 500 Machines operate 10 hours a day, 250 days a year. The manager wants to have a capacity cushion of 10%. a. Assume that only purchasing costs are being considered. Which machines would have the lowest total cost, and how many of that machines would be needed? b. Consider this additional information: The machines differ in terms of hourly operating costs: The A machines have an hourly operating cost of $11 each, B machines have an hourly operating cost of $10 each, and C machines have an hourly operating cost of $12 each. Which alternative would…
A TV factory plans to add production lines for its new product and plans to produce as many as 800 units per hour. The production process, production time, and the production process to continue the next production process are described in the table below: (1 day = 8 working hours) Production Process Production Time (s) The production process that follows the next production according to the list below A 12 - B 15 A C 8 A D 5 B,C E 20 D Based on the data above. a. What is the cycle time for the production of the new product? (note: in seconds)b. What is the minimum number of workstations?c. Draw a diagram of the production process.d. With the diagram that you have described above, can the production process run properly according to the plan? Explain the process of each workstation that you have created!.
A manager must decide which type of machine to buy, A, B, or C. Machine costs (per individual machine) are as follows: Machine Cost $50,000 A B $40,000 C $70,000 Product forecasts and processing times on the machines are as follows: PROCCESSING TIME PER UNIT (minutes) Annual Product Demand 1 2 3 4 18,000 25,000 15,000 9,000 A 1 5 4 5 A B C B Click here for the Excel Data File 6531 Total processing time in minutes per machine: a. Assume that only purchasing costs are being considered. Compute the total processing time required for each machine type to meet demand, how many of each machine type would be needed, and the resulting total purchasing cost for each machine type. The machines will operate 8 hours a day, 220 days a year. (Enter total processing times as whole numbers. Round up machine quantities to the next higher whole number. Compute total purchasing costs using these rounded machine quantities. Enter the resulting total purchasing cost as a whole number.) C 2 1 2 6
A TV factory plans to add production lines for its new product and plans to produce as many as 800 units per hour. The production process, production time, and the production process to continue the next production process are described in the table below: (1 day = 8 working hours) Production Process Production Time (s) The production process that follows the next production according to the list below A 12 - B 15 A C 8 A D 5 B,C E 20 D Based on the data above. a. Draw a diagram of the production process.b. With the diagram that you have described above, can the production process run properly according to the plan? Explain the process of each workstation that you have created!.
A TV factory plans to add production lines for its new product and plans to produce as many as 200 units per hour. The production process, production time, and the production process to continue the next production process are described in the table below: (1 day = 8 working hours) Production Process Production Time (s) The production process that follows the next production according to the list below A 12 - B 15 A C 8 A D 5 B,C E 20 D Based on the data above. a. What is the cycle time for the production of the new product? (note: in seconds)b. What is the minimum number of workstations?
A company is setting up an assembly line to produce 90 units per hour. The table below identifies the work elements, times, and immediate predecessors. Work Element Time (Sec.) Immediate Predecessor(s) A 25 - B 18 A C 20 A D 5 B, C E 12 C F 8 E G 16 D, F H 12 G Use one of the heuristic decision rules described in Table below to balance the assembly line so that it will produce 90 units per hour. Clearly state the decision rule you use and complete the below table using the selected rule. Decision Rule Logic Longest work element Picking the candidate with the longest time to complete is an effort to fit in the most difficult elements first, leaving the ones with short times to “fill out” the station. Shortest work element This rule is the opposite of the longest work element rule because it gives preference in workstation assignments to those work elements that are quicker. It can be tried…
EU Company manufactures two different types of life vests (A and B) that are manufactured and assembled on three different workstations (W, X, and Y) using a small-batch process (see Figure 1). Batch setup times are negligible. The flowchart denotes the path each product follows through the manufacturing process, and each product’s price, demand per week, and processing times per unit are indicated as well. Purchased parts and raw materials consumed during production are represented by inverted triangles. EU can make and sell up to the limit of its demand per week; no penalties are incurred for not being able to meet all the demand. Each workstation is staffed by a worker who is dedicated to work on that workstation alone and is paid $6 per hour for an entire week, regardless of how much the worker is used. Total labor costs per week are fixed. Variable overhead costs are $1,500/week. The plant operates one 8-hour shift per day, or 40 hours/week. Which of the three workstations, W,…
Macnamara Corporation has two manufacturing departments--Casting and Finishing. The company used the following data at the beginning of the year to calculate predetermined overhead rates: Casting Finishing Total Estimated total machine-hours (MHs) 1,000 4,000 5,000 Estimated total fixed manufacturing overhead cost $ 4,800 $ 8,800 $ 13,600 Estimated variable manufacturing overhead cost per MH $ 1.80 $ 2.90 During the most recent month, the company started and completed two jobs--Job F and Job M. There were no beginning inventories. Data concerning those two jobs follow: Job F Job M Direct materials $ 11,500 $ 9,000 Direct labor cost $ 18,400 $ 7,400 Casting machine-hours 700 300 Finishing machine-hours 1,600 2,400 Assume that the company uses departmental predetermined overhead rates with machine-hours as the allocation base in both production departments. The manufacturing overhead applied to Job F is closest to: $4,620…