For items 8 -12, consider the following: Chaka Furniture Shop located in Cavite makestwo kinds of products, cabinets and dressers, which pass through the assembly and the finishingdepartments. The Assembly department has 48 hours of work available each week, while thefinishing department has 36 hours each week. Making one cabinet needs 3 hours in Finishing and2 hours in Assembly, while it takes 3 hours to assemble a dresser and 4 hours to finish it.8. If the profit generated per cabinet is P80 and per dresser is P100, write the objective functionthat best describe the given problem where r is the number of cabinet produced, y is the numberof dresser produced and P is the profit.9. Construct the constraints that best describe the given problem where r is the number of cabinetproduced and y is the number of dresser produced.10. How many units of cabinet should the company produce to maximize the profit?11. How many units of dresser should the company produce to maximize the profit?12. What is the maximum profit for the given problem?

Linear programming is a process to reach the best outcome such as maximum profit or lowest cost in a…

Answered: If the profit generated per cabinet is…

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...

See similar textbooks

Similar questions

A small candy shop is preparing for the holiday season. The owner must decide how many bags of Deluxe Mix and how many bags of Standard Mix of Peanut/Raisin Delite to put up. The Deluxe Mix has 2/3 pound raisins and 1/3 pound peanuts, and the Standard Mix has 1/2 pound raisins and 1/2 pound peanuts per bag. The shop has 90 pounds of raisins and 60 pounds of peanuts to work with. Peanuts cost $0.60 per pound and raisins cost $1.50 per pound. The Deluxe Mix will sell for $2.90 per pound, and the Standard Mix will ell for $2.55 per pound. The owner estimates that no more than 110 bags of one type can be sold. If the goal is to maximize profits, how many bags of each type should be prepared?
Item5 Time Remaining 2 hours 52 minutes 12 seconds 02:52:12 eBookReferences Item 5 Time Remaining 2 hours 52 minutes 12 seconds 02:52:12 The production planner for Fine Coffees, Inc. produces two coffee blends: American (A) and British (B). He can only get 300 pounds of Colombian beans per week and 200 pounds of Dominican beans per week. Each pound of American blend coffee requires 12 ounces of Colombian beans and 4 ounces of Dominican beans, while a pound of British blend coffee uses 8 ounces of each type of bean. Profits for the American blend are $2.00 per pound, and profits for the British blend are $1.00 per pound. The goal of Fine Coffees, Inc. is to maximize profits.What is the constraint for Dominican beans? Multiple Choice 12A + 8B ≤ 4,800. 8A + 4B ≤ 3,200. 8A + 12B ≤ 4,800. 4A + 8B ≤ 3,200. 4A + 8B ≤ 4,800.
A manufacturing process has 12 workers and 6 stations. The process iscompleted in the order given below. Where there are multiple workers within a station,each worker works independently on his/her own unit. Assume inventory buffers areallowed between each station.Station Staffing Processing time (hoursper unit per worker)A 2 2.20B 1 1.25C 3 2.00D 2 2.60E 3 3.00F 1 0.75What is the maximum number of units per hour that can be produced? Assume they startthe day with inventory at each station to work on
Hi... I'm having trouble with the following: Min Jee wants to combine the sales data from each of the art fairs. Switch to the Combined Sales worksheet, and then update the worksheet as follows: In cell A5, enter a formula without using a function that references cell A5 in the Madison Copy the formula from cell A5 to the range A6:A8 without copying the formatting. In cell B5, enter a formula using the SUM function, 3-D references, and grouped worksheets that totals the values from cell B5 in the Chicago:Madison Copy the formula from cell B5 to the range B6:B8 without copying the formatting. Copy the formulas and the formatting from the range B5:B8 to the range C5:E8. (Hint: You can ignore the error about empty cells because Min Jee will enter the Madison sales data later.)
Each robot takes up a square area of 10 feet aside. To the left and to the right of each robot along each side are areas for work-in-process inventory that are 6 feet wide x 10 feet long, with the long side adjacent to the robot space. Robots are arranged on an aisle that is 14 feet wide; the area in the plant for the robots is rectangular, 212 feet long, and includes 20 feet and each end for lift trucks. Lift trucks are used to move work–in–process inventory and must be able to get to the robots from aisles on both sides. Assuming that 20 robots are needed, determine the area for robots, inventory control, and material handling. The outgoing inventory pallets are 6 feet x 8 feet high, and they can be stacked thee high. Outgoing inventory is kept for a minimum of two days. In addition to access for lift trucks, determine the amount of storage space that must be provided for these pallets.
A tricycle factory uses 3 tires , 1 frame, and 2 pedals . If the factory. has available 270 tires, 90 frames, and 170 pedals , which item would limit the number of complete tricycles that can be assembled ? Explain your choice. A)tires. B) frames C) pedals D) both tires and frames
A small candy shop is preparing for the holiday season. The owner must decide how many bags of deluxe mix and how many bags of standard mix of Peanut/Raisin Delite to put up. The deluxe mix has 2/3 pound raisins and 1/3 pound peanuts, and the standard mix has 1/2 pound raisins and 1/2 pound peanuts per bag. The shop has 90 pounds of raisins and 60 pounds of peanuts to work with. Peanuts cost $.60 per pound and raisins cost $1.50 per pound. The deluxe mix will sell for $4.60 for a one-pound bag, and the standard mix will sell for $4.10 for a one-pound bag. The owner estimates that no more than 270 bags of one type can be sold. a. If the goal is to maximize profits, how many bags of each type should be prepared? b. What is the expected profit?
The manager of the deli section of a grocery superstore has just learned that the department has112 pounds of mayonnaise, of which 70 pounds is approaching its expiration date and must beused. To use up the mayonnaise, the manager has decided to prepare two items: a ham spread anda deli spread. Each pan of the ham spread will require 1.4 pounds of mayonnaise, and each panof the deli spread will require 1.0 pound. The manager has received an order for 10 pans of hamspread and 8 pans of the deli spread. In addition, the manager has decided to have at least 10 pansof each spread available for sale. Both spreads will cost $3 per pan to make, but ham spread sellsfor $5 per pan and deli spread sells for $7 per pan.a. Determine the solution that will minimize cost.b. Determine the solution that will maximize profit.
Courtney Kamauf schedules production of a popularRustic Coffee Table at Kamauf Enterprises, Inc. The table requires a top, four legs, 1 8 gallon of stain, 1 16 gallon of glue, 2 short braces betweenthe legs and 2 long braces between the legs, and a brass cap that goeson the bottom of each leg. She has 100 gallons of glue in inventory,but none of the other components. All items except the brass caps, stain, and glue are ordered on a lot-for-lot basis. The caps are pur-chased in quantities of 1,000, stain and glue by the gallon. Lead time is 1 day for each item. Schedule the order releases necessary to pro-duce 640 coffee tables on days 5 and 6, and 128 on days 7 and 8.
T-Shirts Unlimited is a retailer that sells every kind of T-shirt imaginable. The different types of T-shirts are stored in departments that all take up the same amount of space. The available warehouse space is shown in the figure below. storage storage storage DOCK AISLE storage storage storage A from–to matrix showing the number of trips to and from each department is given below. From-To Matrix for T-Shirts Unlimited Department Category Trips to andfrom Dock 1 Sports T-Shirts 47 2 Men's T-Shirts 41 3 Women's T-Shirts 61 4 Children's T-Shirts 43 5 Fashion T-Shirts 63 6 Undershirts 58 Help T-Shirts Unlimited decide where to store each type of T-shirt. Fill the blanks with department numbers. (If two answers are acceptable, locate the greater numbers in the top row). enter an appropriate number enter an appropriate number enter an appropriate number…
A small candy shop is preparing for the holiday season. The owner must decide how many bags of deluxe mix and how many bags of standard mix of Peanut/Raisin Delite to put up. The deluxe mix has .70 pounds of raisins and .30 pounds of peanuts, and the standard mix has 0.45 pounds of raisins and 0.55 pounds of peanuts per bag. The shop has 90 pounds of raisins and 60 pounds of peanuts to work with. Peanuts cost $0.6 per pound and raisins cost $1.55 per pound. The deluxe mix will sell for $2.9 for a one-pound bag, and the standard mix will sell for $2.55 for a one-pound bag. The owner estimates that no more than 110 bags of one type can be sold. a. If the goal is to maximize profits, how many bags of each type should be prepared? b. What is the expected profit?
A producer has three products, A, B, and C, which are composed from many of the same raw materials and subassemblies by the same skilled workforce. Each unit of product A uses 15 units of Raw Material X, one Purge System Subassembly, one Case, one Power Cord, three Labour Hours in the Assembly Department, and one Labour Hour in the Finishing Department. Each unit of product B uses 10 units of Raw Material X, five units of Raw Material Y, two Purge System Subassemblies, one Case, one Power cord, five Labour Hours in the Assembly Department, and 90 minutes in the Finishing Department. Each unit of product C uses five units of Raw Material X, 25 units of Raw Material Y, two Purge System Subassemblies, one Case, a Power Cord, seven Labour Hours in the Assembly Department, and Three Labour Hours in the Finishing Department. Labour between the Assembly and Finishing departments is not transferable, but workers within each department work on any of the three products. There are three…

SEE MORE QUESTIONS

Recommended textbooks for you

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Operations Management

ISBN:

9781259667473

Author:

William J Stevenson

Publisher:

McGraw-Hill Education

Operations and Supply Chain Management (Mcgraw-hi…

Operations Management

ISBN:

9781259666100

Author:

F. Robert Jacobs, Richard B Chase

Publisher:

McGraw-Hill Education

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Operations Management

ISBN:

9781259667473

Author:

William J Stevenson

Publisher:

McGraw-Hill Education

Operations and Supply Chain Management (Mcgraw-hi…

Operations Management

ISBN:

9781259666100

Author:

F. Robert Jacobs, Richard B Chase

Publisher:

McGraw-Hill Education

Business in Action

Operations Management

ISBN:

9780135198100

Author:

BOVEE

Publisher:

PEARSON CO

Purchasing and Supply Chain Management

Operations Management

ISBN:

9781285869681

Author:

Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson

Publisher:

Cengage Learning

Production and Operations Analysis, Seventh Editi…

Operations Management

ISBN:

9781478623069

Author:

Steven Nahmias, Tava Lennon Olsen

Publisher:

Waveland Press, Inc.

SEE MORE TEXTBOOKS