You must complete this assignment in a group of three of four students from the same lecture section. Any deviation from this group requirement will be penalized 20% unless you have prior approval from the instructor. Create a new Word document. On the title page of the Word document file, put the names and student numbers of all of your team members. Open a new Excel Workbook and create a Worksheet for each of questions 1-5. The teaching assistant/marker should be able to easily find the answers for each question on its Worksheet. Provide a summary of your answers to all of these questions in the Word document. Question 6 should be answered in your Word document only. For question 7, create a new database in MS Access and summarize your answers in the Word document. Select one member of your team to submit the following files into Sakai (Assignment 1): 1. Submit the MSWord file with all of the answers to the questions in sentence format. 2. Submit the Excel file that shows your calculations.
3. Submit the Access file with your database for question 7
All submissions must be received before 11:00 pm on Tuesday December 3, 2013. You are responsible for ensuring that the files you submit can be opened and that they contain the correct information. Linear and Integer Programming
Jared is a business student at Brick University. He has just finished a course in Information Technology which had a midterm exam, a final exam, assignments and class participation. He earned 82% on the midterm exam, 79% on the final exam, 94% on the assignments and 100% on participation. The instructor is letting the student choose their own weighting scheme for the final course mark, with the following restrictions: Participation can be no more than 10% of the total course mark. The weighting for the final exam must be at least 1.5 times the weighting for the midterm exam. The total of the midterm and final exams must count for more than twice the assignment mark Each component must count for at least 10% of the total course mark. The marks assigned to the four components must total 100 and be non-negative.
Provide a write-up of your model formulation in the Word document; define your decision variables, state the objective function, and list all constraints. In Excel, use Solver to find the optimal values for the decision variables. State your solution on the Word document. (5 marks) Question 2
Sproule and Sproule Engineering provide design-build engineering services. There are currently eight building projects out for tender that Sproule and Sproule can bid on. All of the projects have a 10 week duration. Each project will require mechanical engineering, civil engineering and electrical engineering hours as shown in Table 1 below.
Sproule and Sproule have also determined the amount of funds that must be available to support the project through to completion, and the amount that they would bid for the project. (The bid amount is the amount that they would be paid on project completion.) The firm’s profit is the difference between the bid price and the funding required.
Sproule and Sproule have $1,100,000 available to fund projects over this 10 week time frame. Staff engineers are available as shown in Table 2. (There is no cost for staff engineers as the firm must keep them on salary whether there is project work or not.) Engineers work a 40 hour week. They can also hire contract engineers at $100/hour. The maximum contract hours available are also shown in Table 2.
Please join StudyMode to read the full document