Please solve the linear equation (LP) with clear steps and explanation Problem 1:A manufacturer of engine parts produces valves and pistons at its main plant. Bothparts are processed by the Machining Department and by the Finishing Department.Each valve requires 0.4 hours of machining time and 0.3 hours of finishing time, andeach piston requires 0.3 hours of machining and 0.5 hours of finishing. The productionprocess also requires 2 pounds of steel for each part.In drawing up a schedule for the coming month the plant manager knows that 300hours of production time will be available in the Machining Department and 400 hourswill be available in the Finishing Department. In addition, existing contracts provide forthe delivery of 1800 pounds of steel during the month.The market for valves and pistons is competitive, and the company can sell all the partsit produces during the month. At current prices the gross profit on each valve sold isOR3, while for each piston sold the gross profit is OR4. The plant manager would like tofind a production plan for the month that will maximise profits.Determine the optimal plan and the maximum possible profit.

Answered: Image /qna-images/answer/5e111561-bbb0-4b8e-81c0-5e9fd9f5c9a6.jpg

A manufacturer of engine parts produces valves and pistons at its main plant. Both parts are processed by the Machining Department and by the Finishing Department. Each valve requires 0.4 hours of machining time and 0.3 hours of finishing time, and each piston requires 0.3 hours of machining and 0.5 hours of finishing. The production process also requires 2 pounds of steel for each part.

A manufacturer of engine parts produces valves and pistons at its main plant. Both parts are processed by the Machining Department and by the Finishing Department. Each valve requires 0.4 hours of machining time and 0.3 hours of finishing time, and each piston requires 0.3 hours of machining and 0.5 hours of finishing. The production process also requires 2 pounds of steel for each part.

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

2. As part of a quality improvement initiative, Consolidated Electronics employees complete a three-day training program on teaming and a two-day training program on problem solving. The manager of quality improvement has requested that at least 8 training programs on teaming and at least 10 training programs on problem solving be offered during the next six months. In addition, senior-level management has specified that at least 25 training programs must be offered during this period. Consolidated Electronics uses a consultant to teach the training programs. During the next quarter, the consultant has 84 days of training time available. Each training program on teaming costs $10,000 and each training program on problem solving costs $8000. a. Formulate a linear programming model that can be used to determine the number of training programs on teaming and the number of training programs on problem solving that should be offered in order to minimize total cost. b. Determine the optimal…
9-7 The management of the Executive Furniture Corporation decided to expand the production capacity at its Des Moines factory and to cut back the production capacities at its other two factories. It also recognizes a shifting market for its desks and revises the requirements at its three warehouses. The table on this page provides the requirement at each of the warehouses, the capacity at each of the factories, and the shipping cost per unit to ship from each factory to each warehouse. Find the least-cost way to meet the requirements given the capacity at each factory.
The Wearever Carpet Company manufactures two brands of carpet—shag and sculptured— in 100-yard lots. It requires 8 hours to produce one lot of shag carpet and 6 hours to produce one lot of sculptured carpet. The company has the following production goals, in prioritized order: (1) Do not underutilize production capacity, which is 480 hours. (2) Achieve product demand of 40 (100-yard) lots for shag and 50 (100-yard) lots for sculptured carpet. Meeting demand for shag is more important than meeting demand for sculptured, by a ratio of 5 to 2. (3) Limit production overtime to 20 hours. a. Formulate a goal programming model to determine the amount of shag and sculptured carpet to produce to best meet the company’s goals. b. Solve this model by using the computer.
Gerald Glynn manages the Michaels Distribution Center. After careful examination of his database information, he has determined the daily requirements for part-time loading dock personnel. The distribution center operates 7 days a week, and the daily part-time staffing requirements are Day M T W Th F S Su Requirements 7 3 5 5 6 2 2 Find the minimum number of workers Glynn must hire. Prepare a workforce schedule for these individuals so that each will have 2 consecutive days off per week and all staffing requirements will be satisfied. Give preference to the S-Su pair in case of a tie. (Note: If there is a tie that cannot be broken by following the preference to the S-Su pair, choose the pair closest to the beginning of the considered week.) Part 2 The minimum number of workers is _________workers. (Enter your response as a…
Amy Zeng, owner ofZeng's Restaurant Distributions,supplies nonperishable goods to restaurants around the metroarea. She stores all the goods in a storage area with a single dockand one aisle. The goods are divided into five categories accordingto the following table. The table indicates the number of tripsper month to store or retrieve items in each category, as well asthe number of storage blocks taken up by each. The following picture of the storage area provides an identificationnumber for each of the 16 storage blocks. For each item category,indicate into which blocks it should be stored.
Gerald Glynn manages the Michaels Distribution Center. After careful examination of his database information, he has determined the daily requirements for part-time loading dock personnel. The distribution center operates 7 days a week, and the daily part-time staffing requirements are Day M T W Th F S Su Requirements 7 3 4 4 5 4 5 Find the minimum number of workers Glynn must hire. Prepare a workforce schedule for these individuals so that each will have 2 consecutive days off per week and all staffing requirements will be satisfied. Give preference to the S-Su pair in case of a tie. (Note: If there is a tie that cannot be broken by following the preference to the S-Su pair, choose the pair closest to the beginning of the considered week.) The minimum number of workers is 7 workers. (Enter your response as a whole number.) Specify the workforce schedule for each employee by indicating the day offs (other days are considered to be…
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.
Gerald Glynn manages the Michaels Distribution Center. After careful examination of his database information, he has determined the daily requirements for part-time loading dock personnel. The distribution center operates 7 days a week, and the daily part-time staffing requirements are LOADING... Day M T W Th F S Su Requirements 7 5 4 2 5 2 5 Find the minimum number of workers Glynn must hire. Prepare a workforce schedule for these individuals so that each will have 2 consecutive days off per week and all staffing requirements will be satisfied. Give preference to the S-Su pair in case of a tie. (Note: If there is a tie that cannot be broken by following the preference to the S-Su pair, choose the pair closest to the beginning of the considered week.) Part 2 The minimum number of workers is enter your response…
The manager of a medical center wants to schedule staff based on a pattern of 5 days working and 2 consecutive days off. Based on the history of their workload, below is their weekly staff requirement: Day Monday Tuesday Wednesday Thursday Friday Saturday Sunday Staff needed 6 5 4 4 6 4 3 a. Determine what days employee 3 does not need to work. multiple choice Saturday and Sunday Monday and Friday Tuesday and Thursday Wednesday and Friday b. Determine the minimum number of full time staff. c. Determine the minimum number of part time staff. Prev Question 9 of 10 Total9 of 10 Visit question mapNext
Problem 6. Rylon Corporation manufactures Brute cologne and Chanelle perfume. The raw material needed to manufacture each type of fragrance can be purchased for $60 per pound. Processing 1 pound of raw material requires 1 hour of laboratory time. Each pound of processed raw material yields 3 ounces of Regular Brute cologne and 4 ounces of Regular Chanelle perfume. Regular Brute can be sold for $140 per ounce and Regular Chanelle for $120 per ounce. Rylon also has the option of further processing Regular Brute and Regular Chanelle to produce Luxury Brute, sold at $360 per ounce, and Luxury Chanelle, sold at $280 per ounce. Each ounce of Regular Brute processed further requires an additional 3 hours of laboratory time and a $40 processing cost and yields 1 ounce of Luxury Brute. Each ounce of Regular Chanelle processed further requires an additional 2 hours of laboratory time and a $40 processing cost and yields 1 ounce of Luxury Chanelle. Each year, Rylon has 6000 hours of laboratory…
Maximize profit = 4X + 4Y Subject to: 3X +5Y ≤ 150 X – 2Y ≤ 10 5X + 3Y ≤ 150 X, Y ≥ 0 Required: a- The corner point method to obtain the optimal point. b- Specify the profit value. c- Calculate the Slack for each constraint and state its formula.
Gerald Glynn manages the Michaels Distribution Center. After careful examination of his database information, he has determined the daily requirements for part-time loading dock personnel. The distribution center operates 7 days a week, and the daily part-time staffing requirements areDay M T W Th F S SuRequirements 6 3 5 3 7 2 3Find the minimum number of workers Glynn must hire. Prepare a workforce schedule for these individuals so that each will have two consecutive days off per week and all staffing requirements will be satisfied. Give preference to the S–Su pair in case of a tie.