I need support with this Excel question so I can learn better.

# Part 1: Goal Seek

The purpose of this project is to practice and apply what you have learned about using the Goal Seek tool in Excel. In this project, you will create a spreadsheet to help determine what score you need to earn on a final exam or project to get the desired letter grade in one of your classes. Please read the instructions carefully because you will have to customize your worksheet to fit your own needs and the class you choose.

Requirements:

1.Open a new Excel workbook. Use “GoalSeek” for the name of the spreadsheet—you will add additional spreadsheets to this workbook in parts 2 and 3.

2.Choose any one of your current classes and create a spreadsheet that includes at least the following headings: Category, Points Possible, Estimated Percentage, Estimated Points. You are free to include any additional headings that are useful to you.

3.Under Category, list the categories of the major components (assignments, quizzes, projects, exams, etc.) that make up your grade for that class. You don’t need to list the individual items in that category, just list the category (i.e., use “Quizzes” instead of “Quiz 1”, “Quiz 2”, etc.). However, list the final exam or final project separately from your other exams, as shown in the example screenshot. (If you don’t have any exams in the class, use the final project or whatever major graded activity that falls near the end of the semester.)

4.Under Points Possible, enter the total number of possible points for each category. (If you have ten quizzes in the class and each quiz is worth 10 points, the points possible for quizzes is 100.) When you get to the final exam or project, list the possible points for that one exam or that one project and be sure to exclude those points from the general exam’s category.

5.Underestimated Percentage, enter your best guess for the percentage of points you think you will earn for each category. If you think you will average 80% on the quizzes or the other exams, enter in 80% for that category. Do this for all the categories in your spreadsheet.

6.Use a formula to calculate the estimated points using the points possible and the estimated percentage. Do this for all the categories in your spreadsheet.

7.In the three rows immediately below the last grade category in your spreadsheet, enter three labels: Total Points, Points Possible, and Percent Score. In the column directly to the right of those labels, use formulas or enter the total estimated points, the actual points possible for the class, and the percentage score (Total Points/Points Possible) based on your estimated points for the categories. The screenshot below shows a partial version of the table you are creating. Yours should not be exactly like this, but it should have at least the headings and labels as shown.

8.Use the Goal Seek tool to determine the percent score that you need to get on the final exam or project to get an A (90%) in the class. In a cell beneath the table you just created, record what score you need to get on the final exam to earn an A in the class and also comment on whether you think it is likely you will achieve that.

9.Use the Goal Seek tool again to determine the percent score that you need to get on the final exam or project to get a B (80%) in the class. In a cell beneath your first comment, record what score you need to get on the final exam to earn an B in the class and also comment on whether you think it is likely you will achieve that.

Save your progress and proceed to Part 2.

## Part 2: Solver

The purpose of this part of the project is to practice and apply what you have learned about the Solver tool. You will use Solver to determine an optimal combination and number of products to produce to maximize profit.

Requirements:

2.Enter in the labels and numbers as shown in the following screenshot. This table shows the profit and requirements for three different products. Each product requires a certain number of hours and materials. The company only has so many resources available, so the solution has to fit within what is available.

3.Cells F5, F6, and G8 use functions or formulas. All other numbers should be entered in exactly as shown in the screenshot.

A.Cell F5 holds the calculation for the total number of hours used, based on the production size for each product. This is calculated by taking the hours required multiplied by the production size for Product 1, added to the hours required multiplied by the production size for Product 2, added to the hours required multiplied by the production size for Product 3. The easiest way to calculate this is to use the SUMPRODUCT function for the hours cells and the production size cells. (Look up the SUMPRODUCT function on Google if you need help figuring out how to use it.)

B.Cell F6 holds the calculation for the total number of materials used, based on the production size for each product. Use the SUMPRODUCT function to calculate this value similar to what you did with hours.

C.Cell G8 is the total profit. It is calculated using a formula that takes the sum of the product profits multiplied by the production sizes. Use SUMPRODUCT for this cell as well.

4.Use the Solver tool to determine the optimal mix and number of products to produce.

A.Your goal is to maximize total profit.

B.You achieve this by allowing Solver to change to production sizes for all the products.

C.You must implement the following bounds and constraints:

1. You cannot use more resources than you have available.

2.The minimum production size for each product is 5.

3.The production size must be in whole numbers or integers—no partially products produced.

5.After you have successfully used Solver to maximize total profit, save your spreadsheet in that state without changing the numbers or your Solver settings. The optimal total profit should be around \$6,700.

Save your progress and proceed to Part 3.

## Part 3: Data Tables

The purpose of this part of the project is for you to practice and apply what you have learned about data tables. You will create two different data tables that show how loan interest rates and terms affect your total and monthly payments.

Requirements:

2.Copy a mortgage table from a previous example or project or create a new one. Your table should be similar to the one in the screenshot below. Be sure to use \$300,000 for the home price, a 20% down payment amount, a 3.5% interest rate, and a 30 year loan.

3.To the right of the mortgage table, create a one-variable data table using the Data Table tool that shows the monthly payments and total amounts paid for the range of interest rates between 3.250% and 4.000%. Your completed data table should match the one below. You must use the Data Table tool; do not simply manually enter the numbers into the table.

4.Below your first data table, create a second data table. This should be a two-variable data table that shows how the number of years determines the total amounts paid for the loan for the interest rates between 3.250% and 4.000%. You must use the Data Table tool, and your completed table should match the one below.

Submit your Excel workbook with all three spreadsheets to Blackboard before 5pm on Friday.

I need an explanation for this Computer Science question to help me study.

1.What other strategic processes are closely tied to ERM?

Performance measurement and budgeting are closely tied to ERM.

2.What three kinds of risks are identified within the City of Edmonton?

The City has strategic, project, and operating risks.

3.What two criteria must be balanced in a successful ERM model?

An ERM model should be simple enough to understand while being complex enough to add value.

4.Who is responsible for dealing with and mitigating risks?

The risk owner is responsible.

5.To what body must the City’s strategic risks be reported?

Risks are reported to the City Council, through the Audit Committee.

Major Homework Requirements

The homework assignments are not opinion compositions, or a book, chapter, or article review. These assignments are positional arguments that are entirely supported by empirical evidence and well-known industry facts. You can include your personal experiences and ideas if it directly relates to the topic, or reinforces your position. However, you must support all statements with evidence. All submissions must adhere to APA guidelines. APA writing is an academic standard; therefore, it is not optional, it is mandatory.

Points are deducted if your submission does not adhere to the following requirements:

1. Be a scholarly submission
1. Include a title page
2. Times New Roman font, 1-inch margin, and double-spaced
3. Be at least two pages in length
• Should not consist of any bullet-points
• d.Have a reference page with at least three academic references
• You CANNOT use Wikipedia, LinkedIn articles, blogs, paid vendors, certification websites, or similar sources in academic writing. You CAN use reputable industry articles from publications similar to ComputerWeekly, PCMag, Wall Street Journal, New York Times, or similar sources. Academic journals and popular industry articles are accessible in the university’s library databases and Google Scholar. All references should not have a publication date older than 2005.
1. Be written in a clear and concise manner
• Contains contractual phrases, as an example “shouldn’t” “couldn’t” or “didn’t,” or similar
• Uses vague words such as “proper,” “appropriate,” “adequate,” or similar to describe a process, function, or a procedure.
• As an example, “proper incident response plan,” “appropriate IT professional,” “adequate security,” or similar. These words are subjective because they have a different meaning to different individuals.
1. Does not adhere to the University’s academic dishonesty and plagiarism policies.

I need support with this Excel question so I can learn better.

# Part 1: Goal Seek

The purpose of this project is to practice and apply what you have learned about using the Goal Seek tool in Excel. In this project, you will create a spreadsheet to help determine what score you need to earn on a final exam or project to get the desired letter grade in one of your classes. Please read the instructions carefully because you will have to customize your worksheet to fit your own needs and the class you choose.

Requirements:

1.Open a new Excel workbook. Use “GoalSeek” for the name of the spreadsheet—you will add additional spreadsheets to this workbook in parts 2 and 3.

2.Choose any one of your current classes and create a spreadsheet that includes at least the following headings: Category, Points Possible, Estimated Percentage, Estimated Points. You are free to include any additional headings that are useful to you.

3.Under Category, list the categories of the major components (assignments, quizzes, projects, exams, etc.) that make up your grade for that class. You don’t need to list the individual items in that category, just list the category (i.e., use “Quizzes” instead of “Quiz 1”, “Quiz 2”, etc.). However, list the final exam or final project separately from your other exams, as shown in the example screenshot. (If you don’t have any exams in the class, use the final project or whatever major graded activity that falls near the end of the semester.)

4.Under Points Possible, enter the total number of possible points for each category. (If you have ten quizzes in the class and each quiz is worth 10 points, the points possible for quizzes is 100.) When you get to the final exam or project, list the possible points for that one exam or that one project and be sure to exclude those points from the general exam’s category.

5.Underestimated Percentage, enter your best guess for the percentage of points you think you will earn for each category. If you think you will average 80% on the quizzes or the other exams, enter in 80% for that category. Do this for all the categories in your spreadsheet.

6.Use a formula to calculate the estimated points using the points possible and the estimated percentage. Do this for all the categories in your spreadsheet.

7.In the three rows immediately below the last grade category in your spreadsheet, enter three labels: Total Points, Points Possible, and Percent Score. In the column directly to the right of those labels, use formulas or enter the total estimated points, the actual points possible for the class, and the percentage score (Total Points/Points Possible) based on your estimated points for the categories. The screenshot below shows a partial version of the table you are creating. Yours should not be exactly like this, but it should have at least the headings and labels as shown.

8.Use the Goal Seek tool to determine the percent score that you need to get on the final exam or project to get an A (90%) in the class. In a cell beneath the table you just created, record what score you need to get on the final exam to earn an A in the class and also comment on whether you think it is likely you will achieve that.

9.Use the Goal Seek tool again to determine the percent score that you need to get on the final exam or project to get a B (80%) in the class. In a cell beneath your first comment, record what score you need to get on the final exam to earn an B in the class and also comment on whether you think it is likely you will achieve that.

Save your progress and proceed to Part 2.

## Part 2: Solver

The purpose of this part of the project is to practice and apply what you have learned about the Solver tool. You will use Solver to determine an optimal combination and number of products to produce to maximize profit.

Requirements:

2.Enter in the labels and numbers as shown in the following screenshot. This table shows the profit and requirements for three different products. Each product requires a certain number of hours and materials. The company only has so many resources available, so the solution has to fit within what is available.

3.Cells F5, F6, and G8 use functions or formulas. All other numbers should be entered in exactly as shown in the screenshot.

A.Cell F5 holds the calculation for the total number of hours used, based on the production size for each product. This is calculated by taking the hours required multiplied by the production size for Product 1, added to the hours required multiplied by the production size for Product 2, added to the hours required multiplied by the production size for Product 3. The easiest way to calculate this is to use the SUMPRODUCT function for the hours cells and the production size cells. (Look up the SUMPRODUCT function on Google if you need help figuring out how to use it.)

B.Cell F6 holds the calculation for the total number of materials used, based on the production size for each product. Use the SUMPRODUCT function to calculate this value similar to what you did with hours.

C.Cell G8 is the total profit. It is calculated using a formula that takes the sum of the product profits multiplied by the production sizes. Use SUMPRODUCT for this cell as well.

4.Use the Solver tool to determine the optimal mix and number of products to produce.

A.Your goal is to maximize total profit.

B.You achieve this by allowing Solver to change to production sizes for all the products.

C.You must implement the following bounds and constraints:

1. You cannot use more resources than you have available.

2.The minimum production size for each product is 5.

3.The production size must be in whole numbers or integers—no partially products produced.

5.After you have successfully used Solver to maximize total profit, save your spreadsheet in that state without changing the numbers or your Solver settings. The optimal total profit should be around \$6,700.

Save your progress and proceed to Part 3.

## Part 3: Data Tables

The purpose of this part of the project is for you to practice and apply what you have learned about data tables. You will create two different data tables that show how loan interest rates and terms affect your total and monthly payments.

Requirements: