hii attached my assignment below please have a look
Delete this page before submission Delete this page before submission MATH 1053 - Quantitative Methods for Business Assignment 1 (SP5 2020) DUE: Thursday 10th September at 10:00 AM (Morning) This assignment must be completed using this template. You may add extra sections to this template, change the visual style including font, colour, you can add a company logo, extra figures, tables, etc., as you see fit, however the questions must be answered in either the Report Body or Appendix, as indicated in this template, otherwise the answer will not be marked. Submission Instructions · Assignment submission is via learnonline. If you have problems submitting, keep proof of your submission attempt and shoot me an email at
[email protected] · Once submitted do not edit any electronic files of your work. Assignment Instructions · This assignment covers Weeks 0-3 and counts for 15% of your overall grade: Assignment component Mark Business report 40 Appendix 50 Presentation 10 TOTAL 100 · Assignments submitted late, without an extension being granted, will attract a penalty of 10 marks per each working day or any part thereof beyond the due date and time. Please refer to the Course Outline for the course policy regarding extensions. · An incorrectly or partially filled cover sheet will result in lost marks and delays in the marking and return of your assignment. · Not deleting the pages/text as requested will result in a loss of presentation marks. · Your assignment submission should be typed and observe the page limits. Hand-written answers will be disregarded. Delete this page before submission Delete this page before submission Plagiarism If you are unsure about what constitutes Academic Integrity after reading the information below you are always welcome to check with us before submitting. Plagiarism is a specific form of academic misconduct. We encourage and support working in groups and seeking help, however your final submission must always represent your individual work, opinions and recommendations. If plagiarism is found, all parties involved will be penalised. You need to retain all your assignment computer files (Excel, Word etc.), which must remain unchanged after submission, for the purposes of checking, if required. Plagiarism covers, but is not limited to, the following actions: · Direct copying of the work of other persons, from one or more source, without clearly indicating the origin; · Sending your files to another student for any reason whatsoever, even for the purposes of checking or comparing work; · Submitting another student’s work in whole or in part; · Submitting work that has been written by someone else on the student’s behalf; · Copying computer files without clearly indicating their origin; · Submitting work that has been derived, in whole or in part, from another student’s work by a process of mechanical transformation (e.g. changing variable names in computer files, paraphrasing); · A group-based effort to produce one assignment shared between individuals. Working together is encouraged, however each written assignment submitted by each student must be written in its entirety by the individual student, including running analyses, producing Excel spread sheets other than the templates provided on the Course website and report writing. Working together where one individual types the collective thoughts of a group/produces analyses and/or spread sheets and then shares these files will be investigated for plagiarism. All parties found to be involved in academic misconduct will incur, if appropriate, a penalty and a record in the University's Academic Integrity Database (UniSA Assessment and Procedures Manual 2020, Section 9, Clause 9.2.3 i.). Delete this page before submission Q-Constructions – building your future Q-Constructions is a company that is trying to get the edge in and be recognised on the forefront of building custom construction projects. The company’s strategy is to use mathematical techniques to produce accurate insights that can increase their profits, inform their clients and provide them with the most affordable contracts. You have just been recruited by Q-Constructions to work in the back office to analyse and provide insights into their business model across project management, marketing and financial analysis. They believe you possess the skills to deal with their data and the number crunching mind to propel the company forward – lucky you! The big boss has a list of tasks and objectives for you to get started with which are highly relevant to the company’s progression. The first task is to analyse the past financial data and produce insights on their yearly profit margins. It is noticed that someone didn’t do their job correctly and forgot to lodge their net profit a few years back, so you will have to use your maths skills to figure it out. The company has received a fairly large commercial building proposal that they want you to analyse and assess its financial viability and whether they should proceed. They have provided you with the cash-flow breakdowns per month for the length of the project for your analysis. Another important question they want you to determine is at what stage in the project proposal is needed to be completed such that it will be financially viable. Finally, they usually have a few projects on the go at any one time during a financial year, they need you to analyse the number of projects they need per year to break-even. They can see that the hard-working onsite workers have been in contact with the construction union and feel like they deserve a pay-rise and their salary should be converted to a percentage of a project price. Otherwise, they are ready to strike if their demands are not met. Q-Constructions need to ensure the workers’ demands are meet and provide them with important insights. On the other hand, the company has ongoing costs and they need to be covered, and profit needs to be made overall to keep moving forward. The company is funded by some confidential investors, and they don’t want the developments you will be working on getting out! They are relying on your Quants knowledge so far to solve their problems. They have granted you access to the internet to use Google and calculators too, however; they don’t want you sharing secrets with your friend who might be working at a rival company. They are currently planning their incentives for you as well…because happy staff means positive results and they want to build your future…so a coffee and muffin is on them plus the potential of 15% raise on your course . UNIVERSITY OF SOUTH AUSTRALIA Assignment Cover Sheet – Internal An Assignment cover sheet needs to be included with each assignment. Please complete all details clearly. When submitting the assignment online, please ensure this cover sheet is included at the start of your document. (Not as a separate attachment.) Please check your Course Information Booklet or contact your School Office for assignment submission locations. Name: Student ID Email: Course code and title: MATH 1053 – Quantitative Methods for Business School: Info. Tech. & Mathematical Sciences Program Code: Course Coordinator: Dr Nick Fewster-Young Tutor: Day, Time, Location of Tutorial: Assignment number: 1 Due date: by 10 AM, Thursday 10th September, 2020 Assignment topic as stated in Course Outline: Case Study Report Further Information: (e.g. state if extension was granted and attach evidence of approval, Revised Submission Date) I declare that the work contained in this assignment is my own, except where acknowledgement of sources is made. I authorise the University to test any work submitted by me, using text comparison software, for instances of plagiarism. I understand this will involve the University or its contractor copying my work and storing it on a database to be used in future to test work submitted by others. I understand that I can obtain further information on this matter at http://www.unisanet.unisa.edu.au/learningconnection/student/studying/integrity.asp Note: The attachment of this statement on any electronically submitted assignments will be deemed to have the same authority as a signed statement. Signed: Date: Date received from student Assessment/grade Assessed by: Recorded: Dispatched (if applicable): [ENTER REPORT TITLE INCLUDING THE NAME OF THE COMPANY] Delete this page before submission The report length needs to be as follows: Introduction: At most 3 paragraphs where 1 paragraph is 3-5 sentences. · Should appear on a separate page as indicated in the template · The introduction should discuss the aims of all sections of the report Infographic: Exactly 1 page as indicated and with the elements in the presented order · The infographic should start on a separate page after the introduction · The infographic must contain the elements indicated in the allocated spaces. · DELETE the text in <> as indicated in the infographic · You are welcome to customise/decorate the rest of this area as you like Report Body: A maximum of 1 page of writing, excluding the infographic. Ensure you stay within these limits. · The report body should start on a separate page after the infographic · Use the questions given to guide your discussion of the results in Appendices 1-3. · Clearly stated results and interpretations will help to earn maximum presentation marks. · Do not include numerical calculations or spreadsheets · Do quote quantitative (the final answer!) results. · You should have no more than 1 page of writing (the infographic is excluded ) Conclusion & Recommendations: At most 2 paragraphs where 1 paragraph is 4-6 sentences. You should discuss the analyses that were presented for all three report body questions and provide recommendations. · Should appear on a separate page as indicated in the template · The conclusion summarises the results – do not introduce new information although recommendations are fine Font Type: up to you, but keep in mind it should be easy to read – make it easy for us to give you marks! Font Size: minimum 11pt (it shouldn’t look smaller than this!) Any text or font size smaller than this sentence will incur 0 marks. (this is too small! Don’t make your text this small!!! ) Delete this page before submission Delete this page before submissionSuggested Assignment Work Timeline If you’re not sure how to start the assignment, a suggested work breakdown schedule is below + course resources you can use. Feel free to use it (or ignore it) as you like Some people like to complete each appendix and then write it up in the report, others prefer to complete all appendices and then write up the report in one go. Do whichever suits you! The weeks below indicate a suggested work breakdown by week as well as which week the lecture covers the material. The report can be written at any time (we don’t cover this in lectures ). · Week 2: Appendix 1 (Week 0 notes). Easier · You’ll need the Excel booklet + the Excel Videos page on the course website. · Week 2/3: Appendix 2 (Week 2 notes). Medium · We have an NPV Excel