Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Question 1 A The SAVE-IT COMPANY operates a reclamation center that collects four types of solid waste materials and treats them so that they can

Question 1 A

The SAVE-IT COMPANY operates a reclamation center that collects four types of solid waste materials and treats them so that they can be amalgamated into a salable product. (Treating and amalgamating are separate processes.) Three different grades of this product can be made (see the first column of Table 1), depending upon the mix of the materials used. Although there is some flexibility in the mix for each grade, quality standards may specify the minimum or maximum amount allowed for the proportion of a material in the product grade. (This proportion is the weight of the material expressed as a percentage of the total weight for the product grade.) For each of the two higher grades, a fixed percentage

Table 1

image text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribed
\fdema 8 .5 .8 6 .3 .5 1 .2 .2 .5 .3 .7 5 .3 nd 5 4 O 2 U 6 4 7 8 3 2 7 0 6 lead 4 .7 .3 .5 .6 .2 .5 1 0 O A time 4 5 6 4 U Use the following headings lead- SOCOC TC Month OI URA I RN D D FEI SO order RN time ICRandom Numbers To Be Used in the Simulation Customer 2 3 4 5 6 7 8 9 10 11 12 13 14 15 Interarrival time 0.08 0.87 0.15 0.04 0.52 0.46 0.96 0.1 0.02 0.76 0.32 0.1 0.62 0.25 0.9 Service Time 0.72 0.46 0.96 .00 0.27 0.73 0.76 0.25 0.11 0.47 0.28 0.83 0.52 0.39 0.68 Use the following headings to complete the simulation Time Wait Time Customer RN Between Arrival Begin for RN Service End in Arrivals Time Service service Time Service SystemMicrosoft Excel 15.0 Answer Report Worksheet: [Assignment 1 s1 2022-23 solution.xlsx]Q2 Report Created: 10/14/2022 9:25:10 PM Result: Solver found a solution. All Constraints and optimality conditions are satisfied. Solver Engine Engine: Simplex LP Solution Time: 0.063 Seconds. Iterations: 2 Subproblems: 0 Solver Options Max Time Unlimited, Iterations Unlimited, Precision 0.000001, Use Automatic Scaling Max Subproblems Unlimited, Max Integer Sols Unlimited, Integer Tolerance 1%, Assume NonNegative Objective Cell (Max) Cell Name Original Value Final Value $E$4 profit 0 16200 Variable Cells Cell Name Original Value Final Value Integer $B$3 number of units Rockin chair 0 0 Contin $C$3 number of units Dining table 10 Contin OO $D$3 number of units Armoire 15 Contin Constraints Cell Name Cell Value Formula Status Slack $E$6 Assembly (minutes LHS 3600 $E$6

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

WebAssign For Differential Equations With Boundary-Value Problems

Authors: Dennis G Zill

9th Edition

1337879762, 9781337879767

More Books

Students also viewed these Mathematics questions