Explain.The input in the box below will not be graded, but may be reviewed and considered by your instructor.d. If Cabinetmaker 2 has additional hours available, would the optimal solution change?Explain.The input in the box below will not be graded, but may be reviewed and considered by your instructor.Ye. Suppose Cabinetmaker 2 reduced its cost to $38 per hour. What effect would this change have on the optimal solution? If required, round your answers for the proportions to three decimal places, and for the total cost to two decimal places.Cabinetmaker 1 Cabinetmaker 2 CabinetmakerOak 01 -Cherry C₁-Total Cost - $02-||C₂ = [03-C3 =Explain.The input in the box below will not be graded, but may be reviewed and considered by your instructor.PreviousNext>G0 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

Note: Dear student, you have posted only subparts a,d and e. So i have solved only themGeorgia…

Answered: d. If Cabinetmaker 2 has additional…

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

n a manufacturing process, a molded part spends 7 hours in inventory before being placed in a deburring machine, where the part is processed for 2 minutes. After deburring, the part spends 4 hours in inventory waiting for its turn on the polishing machine. The part then spends 7 minutes in polishing before waiting 6 hours in line to be painted. The part goes through a painting process that takes 7 minutes, then spends 11 hours in inventory before being shipped to the customer. What is the percentage of value-added time for the part?
A Company Is Considering Buying One Of The Following Two Machines. Show the complete solution for each question.
A bicycle component manufacturer produces hubs for bike wheels. Two processes are possible for manufacturing, and the parameters of each process are as follows: Process 1 Production rate Daily production time Process 2 35 parts/hour 4 hours/day 20% 15 parts/hour 7 hours/day 9% Percent parts rejected Assume that the daily demand for hubs allows all defect-free hubs to be sold. Select the process that maximizes profit per day if each part is made from $4 worth of material and can be sold for $30. Both processes are fully automated, and variable overhead cost is charged at the rate of $40 per hour.
l AT&T ? C 2:01 PM ... mple Practice Math Flov Sample 1 You have an upstream Picking department that feeds two downstream packing departments: A and B. 75% of your Pick volume goes to department A, which has a packing rate of 150 units per labor hour (uph). 25% of the Pick volume goes to department B, which is for large items, and has a pack rate of 25 units per labor hour. Your pickers pick both large and small items throughout the day at an overall average rate of 100 units per labor hour. You have 25 people today for all 3 departments, and you absolutely must pack 7,500 units in department A to meet a customer promise metric. How do you allocate labor to balance the flow in your department if you work a 10 hour shift? Do not assume breaks or lunches in your answer Department % of Rate Реople Daily volume| (uph) volume Pick 100% 100 Pick A 75% 150 ? 7,500 Pick B 25% 25 ?
Solve the question below using the attached excel templates with formulas for renting both slow and fast copies (labeled in the excel tabs). Question: The Decision Sciences Department is trying to determine whether to rent a slow or a fast copier. The department believes that an employee’s time is worth $15 per hour. The slow copier rents for $4 per hour, and it takes an employee an average of 10 minutes to complete copying. The fast copier rents for $15 per hour, and it takes an employee an average of six minutes to complete copying. On average, four employees per hour need to use the copying machine. (Assume the copying times and interarrival times to the copying machine are exponentially distributed.) Which machine should the department rent to minimize expected total cost per hour?
Which of the following operational decisions correspond(s) to the price component ofthe consumer utility function?Instructions: You may select more than one answer.a. When will the demand be fulfilled?b. What are the shipping charges to the customer?c. What is the product or service to be delivered?d. Where will the demand be fulfilled?
The cost infomation of an old process unit that has a capacity of 5,400 ft'/hr and a total cost of $8,500,000 is used to find the cost of a new unit that has a capacity of 8,500 t'hr. Assuming the total cost of the new unit is $12,000,000 you are required to state: 1. The method and equation that you will use to find that cost, 2. The value of the corresponding factor, 3. Is the value calculated in (2) within the accepted range?
Charles Lackey operates a bakery in Idaho Falls, Idaho. Because of its excellent product and excellent location, demand has increased by 45%in the last year. On far too many occasions, customers have not been able to purchase the bread of their choice. Because of the size of the store, no new ovens can be added. At a staff meeting, one employee suggested ways to load the ovens differently so that more loaves of bread can be baked at one time. This new process will require that the ovens be loaded by hand, requiring additional manpower. This is the only production change that will be made in order to meet the increased demand.The bakery currently makes 1,800 loaves per month. Employees are paid $8 per hour. In addition to the labor cost, Charles also has a constant utility cost per month of $650 and a per loaf ingredient cost of $0.40. After increasing the number of work hours to 928 per month,what is the multifactor productivity =? loaves/dollar (round your response to…
How many years (t) can we expect to do business with a customer? Thetotal number of years is denoted by T.
In a job shop, effective capacity is only 88 percent of design capacity, and actual output is 69 percent of effective output. What design capacity would be needed to achieve an actual output of 11 jobs per week? What is its effective capacity?a. The Design Capacity needed to achieve the required actual job outputs =( ) (round to whole number)b. The Effective Capacity needed to achieve the required actual job outputs =( ) (round to whole number)
Please write the final answer as a percentage with one decimal.
Scenario analysis allows a firm to ask what - if type questions in capital budgeting. Question 22Select one: True False

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