Colonial Furniture produces hand-crafted colonial style furniture. Plans are now being made for the production of rocking chairs, dining room tables, and/or armoires for the next week. These products go through two stages of production (assembly and finishing). The following table gives the time required for each item to go through these two stages, the amount of wood required, and the corresponding unit profits, along with the amount of each resource available next week. Rocking Chair (RC) Dining Room Table (DRT) Armoire (ARM) Available Assembly (minutes) 100 180 120 3,600 Finishing (minutes) 60 80 80 2,000 Wood (pounds) 30 180 120 4,000 Unit Profit $240 $720 $600 Formulate a complete linear programming model that would determine the production levels that would maximize profit. Make sure to identify the decision variables, objective function and constraints. Using Excel’s Solver: what is the optimal solution? In other words, how many of each piece of furniture should be produced and what is the overall profit? Which constraints are binding and what does that mean?

Colonial Furniture produces hand-crafted colonial style furniture. Plans are now being made for the production of rocking chairs, dining room tables, and/or armoires for the next week. These products go through two stages of production (assembly and finishing). The following table gives the time required for each item to go through these two stages, the amount of wood required, and the corresponding unit profits, along with the amount of each resource available next week. Rocking Chair (RC) Dining Room Table (DRT) Armoire (ARM) Available Assembly (minutes) 100 180 120 3,600 Finishing (minutes) 60 80 80 2,000 Wood (pounds) 30 180 120 4,000 Unit Profit $240 $720 $600 Formulate a complete linear programming model that would determine the production levels that would maximize profit. Make sure to identify the decision variables, objective function and constraints. Using Excel’s Solver: what is the optimal solution? In other words, how many of each piece of furniture should be produced and what is the overall profit? Which constraints are binding and what does that mean?

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

The Build-Em-Fast Company has agreed to supply its best customer with three widgets during each of the next 3 weeks, even though producing them will require some overtime work. The relevant production data are as follows: Week Maximum Production, Regular Time Maximum Production, Overtime Production Cost per Unit, Regular Time 1 2 2 $300 2 3 2 $500 3 1 2 $400 The cost per unit produced with overtime for each week is $100 more than for regular time. The cost of storage is $50 per unit for each week it is stored. There is already an inventory of two widgets on hand currently, but the company does not want to retain any widgets in inventory after the 3 weeks. Management wants to know how many units should be produced in each week to minimize the total cost of meeting the delivery schedule. Formulate this problem as a transportation problem by constructing the appropriate parameter table.
Alocal toy manufacturer is using a production line that runs 8 hours per day and produces a toy that requires a total of 7 tasks to be performied. The daily demand is 150 toys. Times of the tasks are 2.73, 2.01, 2.13, 2.0, 2.61, 2.71, and 2.95 minutes for A, B, C, D, E, F, and G, respectively. However, due to the nature of the product there are precedence rules that must be observed. Such that Task A does not need any predecessors; task B requires taskA to be completed. To start task Cand task D, each require task B to be completed. Task C must be completed prior to stating task E. Task F needs both task D and task Eto be completed. Finally, task G can start only once taskFis completed.What is the minimum number of workstations needed?
The following production data were taken from the records of the finishing department for June: Inventory in process, June 1, 25% completed 260 units Transferred to finished goods during June 5,000 units Equivalent units of production during June 5,495 units Determine the number of equivalent units of production in the June 30, finishing department inventory, assuming that the first-in, first-out method is used to cost inventories. The completion percentage of 25% applies to both direct materials and conversion costs. a.448 units b.840 units c.672 units d.560 units
Print Item Equivalent Units of Production Data for the two departments of Kimble & Pierce Company for June of the current fiscal year are as follows: Drawing Department Winding Department Work in process, June 1 10,000 units, 38% completed 4,000 units, 35% completed Completed and transferred to next processing department during June 60,000 units 60,500 units Work in process, June 30 11,500 units, 70% completed 3,500 units, 60% completed Production begins in the Drawing Department and finishes in the Winding Department. a. If all direct materials are placed in process at the beginning of production, determine the direct materials and conversion equivalent units of production for June for the Drawing Department. If an amount is zero, enter in "0". Drawing Department Direct Materials and Conversion Equivalent Units of Production For June Whole Units Direct MaterialsEquivalent Units ConversionEquivalent Units Inventory in process, June 1 fill…
Alocal toy manufacturer is using a production line that runs 8 hours per day and produces a toy that requires a total of 7 tasks to be performed. The daily demand is 100 toys. Times of the tasks are 2.73, 2.01, 2.13, 2.0, 2.61, 2.71, and 2.95 minutes for A, B, C, D, E, F, and G, respectively. However, due to the nature of the product there are precedence rules that must be observed. Such that Task A does not need any predecessors; task B requires task A to be completed. To start task Cand task D, each require task B to be completed. Task C must be completed prior to stating task E. Task Fneeds both task D and task E to be completed. Finally, task G can start only once task F is completed.Given we apply the most remaining tasks rule for balancing the assembly line, with ties broken according to longest task time first, What will the estimated idle time in minutes for FIRST workstation? J. 1 a. 0,09 b. 1.85 C. 0.06 O d. None is the correct answer e. 1.00 Finis
Alocal toy manufacturer is using a production line that runs 8 hours per day and produces a toy that requires a total of 7 tasks to be performed. The daily demand is 100 toys. Times of the tasks are 2.73, 2.01, 2.13, 2.0, 2.61, 2.71, and 2.95 minutes for A, B, C, D, E, F, and G, respectively. However, due to the nature of the product there are precedence rules that must be observed. Such that Task A does not need any predecessors; task B requires task A to be completed. To start task C and task D, each require task B to be completed. Task C must be completed prior to stating task E. Task Fneeds both task D and task E to be completed. Finally, task G can start only once task Fis completed. Given we apply the most remaining tasks rule for balancing the assembly line, with ties broken according to longest task time first, the tasks that will be assigned to the FIRST workstation are O a. A and B O b. None is the correct answer c. A only O d. A. B, and C О е. Вonly
An electricity power plant was redesigned so that the old system consisting of a single large display screen which could be seen by all of a team of three operators was replaced by individual workstation screens for operators. This worked well until there was a problem which resulted in dangerous gases being released. The team of operators had great difficulty in finding the source of the problem and deciding what to do. Because they no longer have access to all the information, they have to spend time explicitly co-ordinating their understanding of the situation by talking to each other. Under the old system, the knowledge would be shared – one operator would know what was happening with another’s area of the plant without explicit communication. Although the team’s individual responsibilities would still have been clearly divided, the knowledge of the system would be shared. How could the new system of individual workstations be modified to make better use of distributed cognition?
WAI uses two resources for each product that it builds: directlabor and machine time. From historical records, WAI calculatesthe following planning factors:Direct labor for standard corkscrew is 0.20 hour.Direct labor for deluxe corkscrew is 0.50 hour.Machine time for standard corkscrew is 0.10 hour.Machine time for deluxe corkscrew is 0.30 hour.Calculate the capacity needed for the MPS developed in Problem 4
An assembly plant for the Blood Pressure RX, a portable blood pressure device, has 400 minutes available daily in the plant for the device, and the average demand is 80 units per day. Final assembly requires 6 separate tasks. Information concerning these tasks is given in the following table. Task Performance Time (minutes) Task Must Follow Task Listed Below A 4 - B 1 - C 1 A, B D 3 C E 4 D F 2 E b) Given the demand, what is the cycle time for this operation? The cycle time for this operation is enter your response here minutes/unit (enter your response as a whole number). c) What is the theoretical minimum number of workstations? The theoretical minimum number of workstations is enter your response here stations (enter your response as a whole number and, if your unrounded answer includes decimal values,…
Tailwind, Inc., produces high-quality but expensive training shoes for runners. The Tailwind shoe, which sells for $210, contains both gas- and liquid-filled compartments to provide more stability and better protection against knee, foot, and back injuries. Manufacturing the shoes requires 10 separate tasks. There are 400 minutes available for manufacturing the shoes in the plant each day. Daily demand is 60. The information for the tasks is as follows: Performance Time Task Must Follow This Task ABCDEFGHI · Task (in minutes) А В Е Н 1 -324-325- - A B B C, D A F G E, H J 3 | Total 25 Required: a. Draw the precedence diagram showing the task precedence and their times b. Determine the cycle time associated with the rate of output required. c. What is the theoretical minimum number of work stations required to satisfy this output rate? d. Allocate the tasks to work stations taking into consideration the precedence requirements and using the LOT rule to break ties between feasible tasks.…
Alvis Construction Supply Company has a department that manufactures wood trusses (wood frames used in the construction industry). The following information is for the production of these trusses for the month of February: Work-in-process inventory, February 1 4,300 trusses Direct materials: 100% complete $ 10,780 Conversion: 30% complete $ 15,558 Units started during February 18,300 trusses Units completed during February and transferred out 17,300 trusses Work-in-process inventory, February 29 Direct materials: 100% complete Conversion: 30% complete Costs incurred during February Direct materials $ 59,340 Conversion $ 92,392 Required Using the weighted-average method, calculate the following: 1-a. Costs per equivalent unit. (Round your answers to 4 decimal places.) 1-b. Cost of goods completed and transferred out. (Round "Cost per EU" to 4 decimal places. Round final answer to nearest whole dollars.) 1-c. Costs remaining in the…
Ola Ltd, which uses a job costing system, had two jobs in process at the start of the year: Job L1 ($68,000) andJob L2 ($30,000). The following information is available:i) The company applies manufacturing overhead on the basis of machine hours. Budgeted overhead andmachine activity for the year were anticipated to be $1,000,000 and 25,000 hours, respectively.ii) The company worked on three jobs during the first quarter (i.e. from 1 January to 31 March). Directmaterials used, direct labour incurred and machine hours consumed were as shown in the following table: Job numbers Direct material Direct labour Machine hoursL1 $15,000 $30,000 900L2 - 33,000 1,600L3 45,000 65,000 2,000HI5017 Managerial AccountingPage 2 of 22iii) Manufacturing overhead incurred during the first quarter was $215,000.iv) Ola Ltd completed Job L1 and Job L2 during the first quarter. Job L2 was sold on credit, producing a profitof $30,000 for the company.Required:a) Calculate the company’s predetermined overhead…

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

GET THE APP

About FAQ Academic Integrity Sitemap Document Sitemap

Contact Bartleby Contact Research (Essays)High School Textbooks Literature Guides Concept Explainers by Subject Essay Help Mobile App

GET THE APP

Privacy

Your CA Privacy Rights

Your NV Privacy Rights

About Ads

Manage My Data

bartleby, a Learneo, Inc. business

	Rocking Chair (RC)	Dining Room Table (DRT)	Armoire (ARM)	Available
Assembly (minutes)	100	180	120	3,600
Finishing (minutes)	60	80	80	2,000
Wood (pounds)	30	180	120	4,000
Unit Profit	$240	$720	$600