PLEASE ALSO ANSWER THIS THRU EXCEL AND SHOW FORMULAS STEP BY STEP. THANK YOU I WILL UPVOTE I PROMISE. PROBLEM 4The Pee Tool Shop has four heavy presses it uses to stamp out prefabricated metal covers and housingsfor electronic consumer products. All four presses operate differently and are of different sizes.Currently the firm has a contract to produce three products. The contract calls for 400 units of product1; 570 units of product 2; and 320 units of product 3. The time (in minutes) required for each productto be produced on each machine is as follows:Product123135Product12340381P78Machine67842413637Machine 1 is available for 150 hours, machine 2 for 240 hours, machine 3 for 200 hours, and machine4 for 250 hours. The products also result in different profits, according to the machine they areproduced on, because of time, waste, and operating cost. The profit per unit per machine for eachproduct is summarized as follows:Machine33432332P78898143943403P8292904P796358The company wants to know how many units of each product to produce on each machine tomaximize profit. Solve the model by using the computer.

Linear programming is a mathematical technique that is commonly used in operations management…

Answered: The company wants to know how many…

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

A manager must decide which type of machine to buy, A, B, or C. Machines costs are as follows: Machine Cost A $40,000 B $30,000 C $80,000 Product forecast, processing times on the machines, and setup times are as follows: Processing Time Per Unit (minutes) Product Annual Demand A B C Setup Times (minutes) Production Lots (units) 1 16,000 3 4 2 20 200 2 12,000 4 5 3 35 100 3 6,000 5 6 3 60 50 4 30,000 2 4 1 15 500 Machines operate 10 hours a day, 250 days a year. The manager wants to have a capacity cushion of 10%. a. Assume that only purchasing costs are being considered. Which machines would have the lowest total cost, and how many of that machines would be needed? b. Consider this additional information: The machines differ in terms of hourly operating costs: The A machines have an hourly operating cost of $11 each, B machines have an hourly operating cost of $10 each, and C machines have an hourly operating cost of $12 each. Which alternative would…
A company makes two products (1 and 2). Each product requires time on two machines A and B. The specifications for each product are as follows; Product 1 Product 2 Processing time on machine A (hrs/unit) 2 2 Processing time on machine B (hrs/unit) 1 2 Material and labor cost (Sh./unit) 14 15 Selling price (Sh./unit) 16 18 Maximum possible sale (units) 130 150 The amount of time available on machine A is 360 hrs and on machine B is 260 hrs. Formulate the LP problem, which when solved, would indicate the number of product 1 and 2, which should be sold in order to maximize total…
Employees Layoffs at the University Medical Center The University Medical Center is medium-sized, 300-bed capacity hospital at Dasmarinas Cavites. The facilities have grown gradually over the years and are now the 2nd largest in the town of Dasmarinas. It is entirely nonunion and has never experienced an employee layoff since its inception. Sister Veronica Cornista, the Chief Executive Officer of the hospital for 8 years presented a rather bleak financial of the BOD. This according to her is the result of the declining occupancy rate which has affected the hospital’s revenues to such an extent that it ran a deficit for the first time last 1998. Such declines have not been unusual for this industry because of increasing competition. So far, the only response to these changes has been tightening of requirements for equipment or supply purchases. The projected deficit for the coming year is around 1,300,000 unless some additional revenues were identified or some additional savings…
5. During the construction of a house, six joists of 24 ft each must be trimmed to the correct length of 23 ft. The operations for cutting a joist involve the following sequence: Operation 1. Place joist on saw horses 2. Measure correct length (23 ft) 3. Mark cutting line for circular saw 4. Trim joist to correct length 5. Stack trimmed joist in a designated area Time (seconds) 15 5 5 20 20 Three persons are involved: Two loaders must work simultaneously on operations 1,2, and 5, and one cutter handles operations 3 and 4. There are two pairs of saw horses on which untrimmed joists are placed in preparation for cutting, and each pair can hold up to three side-by-side joists. Suggest a good schedule for trimming the six joists.
b) A company receives parts from suppliers to be used in its manufacturing departments. The quality control department must perform two operations when shipments are received: Operation A – draw a random sample, package, and deliver to testing; and Operation B – test the materials and issue a disposition report. There are currently six shipments waiting to be processed. The time estimates for processing these six shipments through quality control are given in the table below. Shipment Operation A (hours) Operation B (hours) A 1.5 1.0 В 1.1 2.7 1.2 1.4 D 0.7 1.6 E 1.6 1.5 F 1.9 2.9 Use Johnson's Rule to set the sequence of processing the shipments through Quality Control. i. ii. How much total time is required to process all the six shipments through Quality Control? Show all times on a Gantt Chart. w lu
William Beebe owns a small shoe store. He has 10 pairs of shoes that requireresoling and polishing. He has a machine that can resole one pair of shoes at atime, and the time required for the operation varies with the type and condition of theshoe and the type of sole that is used. Shoes are polished on a machine dedi-cated tothis purpose as well, and polishing is always done after resoling. His assistant generally does the polishing while Mr. Beebe does the resoling. The resoling and polishingtimes (in minutes) are Shoes Resoling Time Polishing Time1 14 32 28 13 12 24 6 55 10 106 14 67 4 128 25 89 15 510 10 5In what order should the shoes be repaired in order to minimize the total makespanfor these 10 jobs?
00:53:53 C k TB Problem Qu. 5-114 (Algo) Mccabe Corporation uses the weighted-average... for September. Mccabe Corporation uses the weighted-average method in its process costing. The following data pertain to its Assembly Department Mc Graw Hill control Work in process, September 1 Units started into production during September Units completed during September and transferred to the next department Work in process, September 30 Equivalent units of production Q A 2 Required: the weighted-average method. Compute the equivalent units of production for both materials and conversion costs for the Assembly Department for September using Z option W S # 3 X F3 Materials E H command D $ 4 DOD DOO F4 Conversion R C do 5 % F U * 8 N DII F8 Units 800 8,200 7,300 1,700 ( 9 F9 K M 0 Materials 55% F10 Percent Complete 75% L H P F11 > Help command Conversion 10% 25% + 11 Save & Exit 2 F12 option 2 Sub dele
The Holt Million Corporation’s plant manufactures two different products: X and Y. The plant has three different machines: A, B, and C. Each performs different tasks and can work on only one unit of material at a time. Details for each product are shown in the table below: Product X Y Demand Per Week 200 units 100 units Selling Price $150 $160 Machine Operation Required A, B, C B, B, C Operation Times in Minutes 20, 15, 15 15, 15, 15 Raw Materials Needed RM-1, RM-2 RM-2, RM-3 Raw Materials Costs RM-1 = $40/unit, RM-2 or RM-3 = $20/unit Each product uses raw materials with costs as shown in the above table where the processing times and the machine required for each operation are also shown. Each machine is available 4,800 minutes per week. There are no system foul-ups. Demand is deterministic (i. e., no uncertainty). Operating expenses, including labor (but excluding raw materials) total $12,000 per week. Assuming…
b. The Healthy Food Restaurant, a 24-hour restaurant, faces changing requirements from hour tohour. More workers are needed for peak hours, and fewer are needed in between. The followingTable 6 (below) shows the worker requirement for the first 12 hours in the restaurant:Table 6. Staff Requirement at the Healthy Food RestaurantTime Period 10AM11AM12PM1PM2PM3PM4PM5PM6PM7PM8PM9PMRequirement 8 10 12 12 9 7 6 7 9 10 12 8AssignedOn DutyOverstaffed8(i) You are required to apply the first-hour principle to staff each hour with the required number ofcafeteria staff, showing how many staff are on duty each given hour, the number of staffyou have assigned to work each hour and any overstaffing for each hour. i. Schedule the staff to work in 8-hour shifts.
The management of Hartman Company is trying to determine the amount of each of two products to produce over the coming planning period. The following information concerns labor availability, labor utilization, and product profitability: Labor-Hours Required Department A B с (hours/unit) Product 1 Product 2 Hours Available Production 1.00 0.30 Profit contribution/unit $30.00 0.20 38.27 0.35 0.20 0.50 $15.00 (a) Develop a linear programming model of the Hartman Company problem. Solve the model to determine the optimal production quantities of products 1 and 2. If required, round your answer to two decimal places. Product 1 Product 2 69.77 M 95 72.09 38 50 (b) In computing the profit contribution per unit, management does not deduct labor costs because they are considered fixed for the upcoming planning period. However, suppose that overtime can be scheduled in some of the departments. Which departments would you recommend scheduling for overtime? Dept A What is the upper limit of what…
John's printer works is involved in printing and binding works. The company has got orders from four of its customers: A, B, C, and D at the beginning of work. The processing time and due date of these jobs is given below: rules. Job (In order of Arrival) A B C D L H. 111. IV. V. Processing Time (Days) 3 5 4 2 Develop the order in which these jibs are to be processed by using the following dispatching Earliest Due Date (EDD) Longest Processing Time Shortest Processing time Due date (Days hence) First Come First Serve Slack time Remaining Also calculate the average delay of a job in each case. 4 7 6 5
Medical Solutions, Inc. has the following claims it must complete in the next week (40 hours). The jobs are as follows: Claim Type Spinal injury Number of Claims Setup (Changeover) to Process (Work Time per Claim Type (hours) Cancer treatment 15 Hip replacement Order Quantity) 14 10 SI Claims Workload: hours Processing Time per Claim (hours) HR Claims Workload: hours 3.0 1.1 2.5 0.9 1.5 All claims of the same type are processed together. Is 40 hours enough capacity? (Hint: use Equation 10.3.) Round your answers to one decimal place. CT Claims Workload: hours 0.5 Total workload is hours while capacity is 40 hours. The work -Select-cancannotItem 5 be completed using regular time hours.

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

The company wants to know how many units of each product to produce on each machine to maximize profit. Solve the model by using the computer.