●Mins.t.0₁0₁0₁+Oak 01 =Cherry C1-0₂Total Cost - $0₂0₂+0302 =C₂-0303C₁Cabinetmaker 1 Cabinetmaker 2 Cabinetmaker 3C₁03 =C3-C₂C₁C₂01, 02, 03, C1, C2, C3 2 0C₂c. If Cabinetmaker 1 has additional hours available, would the optimal solution change?C3C3MANAd. If Cabinetmaker 2 has additional hours available, would the optimal solution change?C3S eBookProblem 8-25 (Algorithmic)Georgia Cabinets manufactures kitchen cabinets that are sold to local dealers throughout the Southeast. Because of a large backlog of orders for oak and cherry cabinets, the company decided to contract with three smaller cabinetmakers to do the final finishing operation.For the three cabinetmakers, the number of hours required to complete all the oak cabinets, the number of hours required to complete all the cherry cabinets, the number of hours available for the final finishing operation, and the cost per hour to perform the work areshown here:1Hours required to complete all the oak cabinetsHours required to complete all the cherry cabinetsHours availableCost per hourC₁Cabinetmaker 1 Cabinetmaker 2 Cabinetmaker 3506135$36proportion of Oak cabinets assigned to cabinetmaker 1proportion of Oak cabinets assigned to cabinetmaker 2proportion of Oak cabinets assigned to cabinetmaker 3proportion of Cherry cabinets assigned to cabinetmaker 1C2 proportion of Cherry cabinets assigned to cabinetmaker 2C-proportion of Cherry cabinets assigned to cabinetmaker 3=444625For example, Cabinetmaker 1 estimates that it will take 50 hours to complete all the oak cabinets and 61 hours to complete all the cherry cabinets. However, Cabinetmaker 1 only has 35 hours available for the final finishing operation. Thus, Cabinetmaker 1 can onlycomplete 35/50 0.7, or 70%, of the oak cabinets if it worked only on oak cabinets. Similarly, Cabinetmaker 1 can only complete 35/61 -0.57, or 57%, of the cherry cabinets if it worked only on cherry cabinets.a. Formulate a linear programming model that can be used to determine the proportion of the oak cabinets and the proportion of the cherry cabinets that should be given to each of the three cabinetmakers in order to minimize the total cost of completing both projects.Let 01O₂03$43323430$56

Cabinet Maker 1Cabinet Maker 2Cabinet Maker 3Hours required to complete all the oak…

Answered: Georgia Cabinets manufactures kitchen…

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

eBook Problem 8-25 (Algorithmic) Georgia Cabinets manufactures kitchen cabinets that are sold to local dealers throughout the Southeast. Because of a large backlog of orders for oak and cherry cabinets, the company decided to contract with three smaller cabinetmakers to do the final finishing operation. For the three cabinetmakers, the number of hours required to complete all the oak cabinets, the number of hours required to complete all the cherry cabinets, the number of hours available for the final finishing operation, and the cost per hour to perform the work are shown here: 1 Hours required to complete all the oak cabinets Hours required to complete all the cherry cabinets Hours available Cost per hour C₁ Cabinetmaker 1 Cabinetmaker 2 Cabinetmaker 3 50 61 35 $36 proportion of Oak cabinets assigned to cabinetmaker 1 proportion of Oak cabinets assigned to cabinetmaker 2 proportion of Oak cabinets assigned to cabinetmaker 3 proportion of Cherry cabinets assigned to cabinetmaker 1 C2…
Subject: Strategic Information Systems for Business and Enterprise Q) Marketing system provides some useful insights regarding the sales order. Different departments use this information. For instance, the production process uses this information to forecast the expected sale for next month. The production clerk uses this to create an online production schedule. From this schedule, the system automatically prepares weekly online work orders to be used by the production department. The production supervisor assesses the work orders from his terminal and prepares the necessary paper-based move tickets and materials requisitions. Then, the move tickets and two copies of the materials requisitions are distributed to each work centre. Later, work centre employees submit the two copies of the materials requisitions to the warehouse in exchange for materials and sub-assemblies. If additional new materials are needed beyond the standard quantity, the supervisor issues additional materials…
eBook Problem 7-49 (Algorithmic) PharmaPlus operates a chain of 30 pharmacies. The pharmacies are staffed by licensed pharmacists and pharmacy technicians. The company currently employs 90 full-time-equivalent pharmacists (combination of full time and part time) and 175 full-time-equivalent technicians. Each spring management reviews current staffing levels and makes hiring plans for the year. A recent forecast of the prescription load for the next year shows that at least 300 full-time-equivalent employees (pharmacists and technicians) will be required to staff the pharmacies. The personnel department expects 10 pharmacists and 30 technicians to leave over the next year. To accommodate the expected attrition and prepare for future growth, management states that at least 15 new pharmacists must be hired. In addition, PharmaPlus's new service quality guidelines specify no more than two technicians per licensed pharmacist. The average salary for licensed pharmacists is $50 per hour and…
Required information [The following information applies to the questions displayed below.] The Air Force Museum Foundation has commissioned the purchase of 16 Four F Sixes, pre-World War II aircraft. They will be built completely from scratch to the exact specifications used for the originals. As further authentication, the aircraft will be made using the technology and manufacturing processes available when the originals were built. Each of the 16 airplanes will be flown to Air Force and aviation museums throughout the country for exhibition. Aviation enthusiasts can also visit the production facility to see exactly how such aircraft were built in 1938. Soren Industries wants to bid on the aircraft contract and asked for and received certain cost information about the Four F Sixes from the Air Force. The information includes some of the old cost data from the builders of the original aircraft. The available information is for the total accumulated time as the 1st, 8th, and 32nd…
Shipping and Receiving Background Information: Midge Watson had been working in the Bookkeeping Department of the Best Fits Sporting Goods Manufacturing Company for the four years since she graduated from high school. She was bright, attractive, and popular, and had done well in the company, as her recent promotion to senior Bookkeeper proved. One of her new job responsibilities required Midge to go to the warehouse once a week to check on and verify various inventory and shipment information. This meant that she often worked for three or four hours at a time in the Shipping Office. In order to reduce the noise from the operations around it, the office was completely walled in. On these trips to Shipping, Midge worked closely with the shipping clerk, Susan Adams. Susan, a veteran employee of ten years with Best Fit, was divorced. Susan maintained all the shipping and inventory information as it was processed. Since Midge had never before worked in an actual manufacturing and warehouse…
5. (Scenario Based Question) Your response to Simeon's phonecall: Hello, I need to speak to a manager now! Netflix has taken money out of my account when I cancelled the subscription ages ago. They have still charged me for their services. This has left me with no money. This is fraud! I need this money refunded straight away otherwise I will not be able to afford groceries for my kids this week. Please refund this money now! * (Write your response to the customer as if you were a COP at Monzo talking to Simeon, for example "Hi Simeon....". Show us your empathy and analytical problem solving skills, and how by being customer centric you'd help get the customer to a logical solution in this scenario
Saved Required information [The following information applies to the questions displayed below.] Raner, Harris & Chan is a consulting firm that specializes in information systems for medical and dental clinics. The firm has two offices-one in Chicago and one in Minneapolis. The firm classifies the direct costs of consulting jobs as variable costs. A contribution format segmented income statement for the company's most recent year is given: Office Sales Variable expenses Contribution margin Traceable fixed expenses Total Company $ 513,000 256,500 256, 500 143,640 Chicago $ 171,000 51,300 119,700 88,920 $ 30,780 Minneapolis $ 342,000 100.00% 50.00% 50.00% 28.00% 100.00% 30.00% 70.00% 52.00% 100.00% 205, 200 136,800 54,720 $ 82,080 60.00% 40.00% 16.00% Office segment margin 112,860 22.00% 18.00% 24.00% Common fixed expenses not traceable to offices 71,820 14.00% Net operating income $ 41,040 8.00% Required: 1-a. Compute the companywide break-even point in dollar sales. 1-b. Compute the…
Topic: Management information systems Please read and answer throughly beening a operational manager of the Marketing department The MGMT Insurance Ltd. accepts payments on various insurance policies from employees of businesses across the island. These businesses deduct payments from employees’ salaries and pay the insurance company a lump sum each month. This total amount deducted is shown on each employee’s payslip. Deductions are due at the end of each month and each participating business submits one payment for its employees to the insurance company via online payments through the bank. However, if payments were received after 11:00 a.m., the bank does not process them until the next business day. At the beginning of each month an administrative assistant at MGMT Insurance Ltd. downloads the deductions for each company and allocates payments to the various policies. These payments include the client’s unique number along with his/her relevant policy numbers and amounts due.…
Problem 7-09 (Algorithmic) Hawkins Manufacturing Company produces connecting rods for 4- and 6-cylinder automobile engines using the same production line. The cost required to set up the production line to produce the 4-cylinder connecting rods is $1,400, and the cost required to set up the production line for the 6-cylinder connecting rods is $3,100. Manufacturing costs are $15 for each 4-cylinder connecting rod and $18 for each 6-cylinder connecting rod. Hawkins makes a decision at the end of each week as to which product will be manufactured the following week. If a production changeover is necessary from one week to the next, the weekend is used to reconfigure the production line. Once the line has been set up, the weekly production capacities are 6,500 6-cylinder connecting rods and 8,200 4-cylinder connecting rods. Let X4 = the number of 4-cylinder connecting rods produced next week X6 = the number of 6-cylinder connecting rods produced next week S4= 1 if the production line is…
4 To meet the prelicensing education requirement, an Individual must successfully complete: A) 10 hours of education, Including include 3 hours of federal law and regulations training, 3 hours of ethics training, and 2 hours of training relate standards for the nontraditional mortgage product marketplace B) 15 hours of education, including 3 hours of federal law and regulations training, 3 hours of ethics training, and 2 hours of training related to the nontraditional mortgage product marketplace. C) 20 hours of education, Including 3 hours of federal law and regulations training, 3 hours of ethics training, and 2 hours of training the nontraditional mortgage product marketplace. D) 25 hours of education, Including 3 hours of federal law and regulations training, 3 hours of ethics training, and 2 hours of training related to lend the nontraditional mortgage product marketplace.
Maximization of Profit (Graphical Method) The Mariposa Furniture makes two products: tables and chairs, which must be processed through assembly and finishing departments. Assembly department is available for 60 hours in every production period, while the finishing department is available for 48 hours of work. Manufacturing one table requires 4 hours in the assembly and 2 hours in the finishing. Each chair requires 2 hours in the assembly and 4 hours in the finishing. One table contributes P180 to profit, while a chair contributes P100. The problem is to determine the number of tables and chairs to make per production period in order to maximize the profit. What is the profit? Minimization of Profit (Graphical Method) An animal food producer mixes two types of animal food: x and y. each unit of x costs P100 and contains 40 grams of fat, 20 grams of protein and 1,600 calories. Each unit of y cost P80 and contains 60 grams of fat, 60 grams of protein and 1,200 calories. Suppose…
Chapter 5. (M/M/s/K Model). Leia is responsible for 13 data units in the IT offices in a small business called DataWish. Each data unit runs on an average for 3 weeks and requires an average of ½ or 0.5 weeks to get reset by Leia before it can start up again. If we assign the Poisson distribution to the “arrival” of each data unit for service and an exponential distribution to the actual service provided, answer the following questions: a. The arrival rate would be units per week and the service rate would be units per week. b. Calculate the following operating characteristics for the M/M/s/K system: Utilization Factor (ρ) % Performance Measures P0 (probability that sytem is empty) % L (average units in system) units Lq (average units waiting in queue) units W (average time in the system) weeks Wq (average time in the queue) weeks c. If we assign a cost of waiting as $400 per week per data unit and $800 per…

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