I had attached the files .. I want you to complete that assignment.. 1. a projected cash budget base case for a new varsity team for the 2013 seven month operating period [Februarv to August). (exce

BUS2010 Group Case 2 – Bluewater Football Association In your assigned groups, complete the following required for the case, Bluewater Football Association. Required: Prepare a report to the executive members providing an analysis of whether or not to add a new varsity team. An excel template has been provided for the cash budget analysis (do not add/delete rows or columns within the given template area. Note not all cells within the template will have inputs required (for example, loan interest may not ap ply in all months)) . Your report should include the following items:  a projected cash budget (base case) for a new varsity team for the 2013 seven month operating period (February to August). (excel worksheet “base case“) (29 marks)  A revised cash budget t o reflect an increase in registration fees. (excel worksheet “ Inc Reg fees “) (8 marks)  A revised cash budget to reflect the decision that the new varsity team’s players must purchase their own equipment. (excel worksheet “ Buy Own Equip ”) (5 marks)  a revise d cash budget to combine both of the options (increase registration fees and team players buying their own equipment). (excel worksheet “Inc Reg and Buy Own ”) (5 marks)  decision criteria (3 marks)  evaluation of all the alternatives (both quantitative and q ualitative) (15 marks)  final recommendation with rationale (5 marks) 5 marks will be awarded for format, grammar, spelling and proper use of excel formulas. Total marks = 75 Submission Procedure: 1. On the cover sheet in the excel template indicate the gr oup member’s names that contributed to the assignment. 2. Upload the completed excel file to the assignment folder “Group Case 2” under the “Assessments” tab in Nexus. Only one file per groups needs to be submitted. 3. Upload your report to the assignment folder “Group Case 2” under the “Assessments” tab in Nexus. Only one file per groups needs to be submitted. Note: The excel file must be submitted so that proper use of excel formulas can be assessed. No late submissions will be accepted. Please review t he group work section in the course outline detailing the approach to group work. Also, note the “misuse of filesharing” and “sharing of case solutions” sections of the course outline. Any external resources (beyond course content resources) should be cite d using APA or MLA formats.