Hi, anyone able to do an excel spreadsheet with this given information? Thank you very much!

You have been given information about a student below. You will need to construct a spreadsheet and use solver to resolve the constrained optimisation problem outlined below. You should have your solution open and accessible to you when you open the online test. During the test you will also be given a new constraint for one of the scenarios and asked to perform a new optimisation. You should create a copy of your spreadsheet scenario so that you can reconfigure the optimisation calculation as required. After taking the test you will also be required to upload your excel workbook to the Turnitin system under the name "Student Number.xlsx" where the text "Student Number" is replaced with your own numeric student number. 1 The Scenario A student is trying to work out how to allocate the hours of their week and has asked you to help them plan out their week using Solver. The student has given you the following information: They have a part time job which pays them 11.20 per hour they spend working. They take three university courses (A, B and C) and they aim to score at least 60 in each of these courses. For each module the student tells you a) what score they expect to get with no study and b) how much they expect their grade to increase with each additional hour of study per week for that course. The information is summarised below: Course No Study Score Score per hour A 30 3.1 B 25 3.4 10 2.1 The student must pay 50 for groceries and 75 for rent on a weekly basis. The student must sleep at least 6 hours a night on average). The student also enjoys leisure activities, which they have cost them 10 per hour and exercise, which costs 4 per hour. The student has no savings The student's overall wellbeing is measured via the below equation wellbeing = score%3 score 4 score: Sleepo.5 Leisure0.9 Exercise 0.4Work-0.4 Where score A, scores and scorec are the scores from course A, B and C respectively. The other variables in this equation represent the time spent working, exercising, sleeping and leisure. A higher value for this equation represents a higher level of wellbeing, Every hour in the week must be accounted for between work, studying for one of the three courses, leisure, sleep and exercise. Hours can only be allocated to activities as whole hours and not as partial hours. You have been given information about a student below. You will need to construct a spreadsheet and use solver to resolve the constrained optimisation problem outlined below. You should have your solution open and accessible to you when you open the online test. During the test you will also be given a new constraint for one of the scenarios and asked to perform a new optimisation. You should create a copy of your spreadsheet scenario so that you can reconfigure the optimisation calculation as required. After taking the test you will also be required to upload your excel workbook to the Turnitin system under the name "Student Number.xlsx" where the text "Student Number" is replaced with your own numeric student number. 1 The Scenario A student is trying to work out how to allocate the hours of their week and has asked you to help them plan out their week using Solver. The student has given you the following information: They have a part time job which pays them 11.20 per hour they spend working. They take three university courses (A, B and C) and they aim to score at least 60 in each of these courses. For each module the student tells you a) what score they expect to get with no study and b) how much they expect their grade to increase with each additional hour of study per week for that course. The information is summarised below: Course No Study Score Score per hour A 30 3.1 B 25 3.4 10 2.1 The student must pay 50 for groceries and 75 for rent on a weekly basis. The student must sleep at least 6 hours a night on average). The student also enjoys leisure activities, which they have cost them 10 per hour and exercise, which costs 4 per hour. The student has no savings The student's overall wellbeing is measured via the below equation wellbeing = score%3 score 4 score: Sleepo.5 Leisure0.9 Exercise 0.4Work-0.4 Where score A, scores and scorec are the scores from course A, B and C respectively. The other variables in this equation represent the time spent working, exercising, sleeping and leisure. A higher value for this equation represents a higher level of wellbeing, Every hour in the week must be accounted for between work, studying for one of the three courses, leisure, sleep and exercise. Hours can only be allocated to activities as whole hours and not as partial hours