GRADUATE ATTRIBUTE 5: ENGINEERING METHODS, SKILLS, TOOLS, INCLUDING INFORMATION TECHNOLOGY Demonstrate competence to use appropriate engineering methods, skills and tools, including those based on information technology. Range Statement: A range of methods, skills and tools appropriate to the disciplinary designation of the program including: .Sub-discipline-specific tools, processes or procedures; . Computer packages for computation, modelling. simulation, and information handling; Computers and networks and information infrastructures for accessing, processing, managing, and storing information to enhance personal productivity and teamwork. 1. You have just been appointed as an Industrial Engineer in a manufacturing industry and the management gives you the following responsibilities in Table 1 below as your first task, to set the following problem up in transportation format and solve for the minimum cost plan, using Excel of the QM software. Note: do not do this manually [32] Table 1: Period, Capacity and Cost Information Period Feb Mar Apr Demand 55 70 75 Capacity Regular 50 50 50 Overtime 15 15 5 Subcontract 12 12 10 Beginning Inventory 10 Costs Table 1: Period, Capacity and Cost Information Period Feb Mar Apr Demand 55 70 75 Capacity Regular 50 50 50 Overtime 5 5 5 Subcontract 12 12 Beginning Inventory 10 Costs Regular time $60 per unit Overtime $80 per unit Subcontract $90 per unit Inventory carrying cost $1 per unit per month Back order cost $3 per unit per month 2. A foundry company has 3 plants that supply light and heavy steel castings to 4 different types of industries in South Africa. The associated supply (in tonnes) from each plant and demand of each industry is given in Table 2 below. The cost (in Rands) of sending a tonne of steel from a plant to the delivery location of each industry depends on the distance the steel castings must travel. Formulate the LP to minimize the cost of meeting each industry's peak steel demand. Solve with the Simplex Method, using Excel Solver. Note: do not do this manually [34] Table 1: Supply and Demand Information TO Agriculture Aircrafts Automobile Mining Supply 128 96 160 144 70 144 192 208 112 100 From Plant 1 Plant 2 10 Table 1: Supply and Demand Information TO Agriculture Aircrafts Automobile Mining Supply 128 96 160 144 70 192 208 112 100 144 256 80 80 40 60 60 3. A manufacturing process runs at a rate of 4 finished products per hour, according to a negative exponential distribution. Customers seeking the finished products arrive at the shop on the average of 3 per hour, following a Poisson distribution. They are served on a first-in, first-out basis and come from a very large (almost infinite) population of possible buyers. [34] Note: do not do this manually. Use MS Excel to obtain the following operating characteristics (the correct formulas should reflect in your excel cells): Average server utilisation (3) b) Average number of customers in the queue (3)