{"id":94966,"date":"2022-09-13T02:37:24","date_gmt":"2022-09-13T02:37:24","guid":{"rendered":"https:\/\/assignmenttutors.net\/blog\/exp19_excel_ch06_hoeassessment_scholarship_dinner-computer-science-homework-help\/"},"modified":"2022-09-13T02:37:24","modified_gmt":"2022-09-13T02:37:24","slug":"exp19_excel_ch06_hoeassessment_scholarship_dinner-computer-science-homework-help","status":"publish","type":"post","link":"https:\/\/assignmenttutors.net\/blog\/exp19_excel_ch06_hoeassessment_scholarship_dinner-computer-science-homework-help\/","title":{"rendered":"Exp19_excel_ch06_hoeassessment_scholarship_dinner | Computer Science homework help"},"content":{"rendered":"<div>\n<p>\u00a0Exp19_Excel_Ch06_HOEAssessment_Scholarship_Dinner\u00a0<\/p>\n<p>\u00a0Exp19 Excel Ch06 HOEAssessment Scholarship Dinner<\/p>\n<p>Excel Chapter 6 Hands-On Exercise Assessment &#8211; Scholarship Dinner<\/p>\n<p>\u00a0\u00a0<\/p>\n<h2><strong>Project Description:<\/strong><\/h2>\n<p>You have recently been elected social coordinator for your University\u2019s student government association. As part of your duties, you are required to plan an annual scholarship dinner. The dinner is a fundraiser in which the proceeds are used to fund scholarships. You will perform What-If Analysis to calculate the budget information required for the event to be successful.<\/p>\n<p>\u00a0\u00a0\u00a0\u00a0\u00a0<\/p>\n<p>Start Excel. Download \u00a0\u00a0and open the file named <em>Exp19_Excel_Ch06_HOEAssessment_ScholarshipDinner.xlsx<\/em>. \u00a0\u00a0Grader has automatically added your last name to the beginning of the \u00a0\u00a0filename.\u00a0<\/p>\n<p>\u00a0<\/p>\n<p>Create range names \u00a0\u00a0based on the left columns in the ranges A4:B9, A20:B20, and A30:B30.\u00a0<\/p>\n<p>\u00a0<\/p>\n<p>Edit the named range <em>of_Guests_Using_Valet<\/em> to <em>Guests_Using_Valet<\/em>.<\/p>\n<p>\u00a0<\/p>\n<p>Enter a formula in \u00a0\u00a0cell B27 using Named Ranges to calculate projected cost of catering. The cost \u00a0\u00a0of catering is the cost per meal * the total number of tickets sold.<\/p>\n<p>\u00a0<\/p>\n<p>Enter a formula in \u00a0\u00a0cell B28 using Named Ranges to calculate total cost for room setup.<\/p>\n<p>\u00a0<\/p>\n<p>Enter a formula in \u00a0\u00a0cell B29 using Named Ranges to calculate the total valet expenses. The total \u00a0\u00a0valet expenses can be calculated by multiplying tickets sold * total guests \u00a0\u00a0using valet * valet cost per car.<\/p>\n<p>\u00a0<\/p>\n<p>Use a function to \u00a0\u00a0total all expenses in cell B30.<\/p>\n<p>\u00a0<\/p>\n<p>Enter a formula in \u00a0\u00a0cell C32 to calculate the remaining balance (<strong>Total_Income &#8211; Total_Expenses<\/strong>).<\/p>\n<p>\u00a0<\/p>\n<p>Enter a series of \u00a0\u00a0substitution values in the range E5:E20. The values should start at 50 and \u00a0\u00a0increase in increments of 5 stopping at 125.<\/p>\n<p>\u00a0<\/p>\n<p>Enter references to \u00a0\u00a0Total_income, Total_Expenses, and Balance in the correct locations (F4, G4, \u00a0\u00a0and H4) for a one-variable data table. Use range names where indicated.<\/p>\n<p>\u00a0<\/p>\n<p>Complete the \u00a0\u00a0one-variable data table in the range E4:H20 using cell B5 as the column input \u00a0\u00a0cell, and then format the results with Comma Style.<\/p>\n<p>\u00a0<\/p>\n<p>Type <strong>Price \u00a0\u00a0<\/strong>in \u00a0\u00a0cell E4 and apply custom number formats to make the formula references appear \u00a0\u00a0as descriptive column headings. In F4, <strong>Total Income<\/strong>; in G4, <strong>Total \u00a0\u00a0Expenses<\/strong>, \u00a0\u00a0in H2, <strong>Balance<\/strong>.\u00a0<\/p>\n<p>\u00a0<\/p>\n<p>Copy the range E5:E20 \u00a0\u00a0and paste it in the range J5:J20.<\/p>\n<p>\u00a0<\/p>\n<p>Type <strong>400 \u00a0\u00a0<\/strong>in \u00a0\u00a0cell K4. Complete the series of substitution values from 400 to 525 in \u00a0\u00a0increments of 25.<\/p>\n<p>\u00a0<\/p>\n<p>Enter the reference \u00a0\u00a0to the Balance formula in the correct location for a two-variable data table.<\/p>\n<p>\u00a0<\/p>\n<p>Complete the \u00a0\u00a0two-variable data table in the range J4:P20. Use cell B4 as the Row input \u00a0\u00a0cell and B5 as the Column input cell. Format the results with Comma Style \u00a0\u00a0formatting.<\/p>\n<p>\u00a0<\/p>\n<p>Apply a custom number \u00a0\u00a0format to make the formula reference appear as a descriptive column heading <strong>Price<\/strong>.\u00a0<\/p>\n<p>\u00a0<\/p>\n<p>Load the Solver \u00a0\u00a0add-in if it is not already loaded. Set the objective to calculate the \u00a0\u00a0highest Balance possible (C32).<\/p>\n<p>\u00a0<\/p>\n<p>Use Tickets Sold \u00a0\u00a0(cell B4) and Ticket Price (cell B5) as changing variable cells. Do not use \u00a0\u00a0range names.<\/p>\n<p>\u00a0<\/p>\n<p>Use the Constraints \u00a0\u00a0section of the spreadsheet model to set constraints for minimum ticket price, \u00a0\u00a0maximum ticket price, and ticket sales. The ticket price must be less than or \u00a0\u00a0equal to the maximum ticket price (cell B14). The ticket price must also be \u00a0\u00a0greater than or equal to the minimum ticket price (cell B13). The total \u00a0\u00a0tickets sold must be less than or equal to the ballroom capacity and the \u00a0\u00a0number of tickets sold must be an integer.\u00a0<\/p>\n<p>\u00a0<\/p>\n<p>Solve the problem. \u00a0\u00a0Generate the Answer Report and Keep Solver Solution.<\/p>\n<p>\u00a0<\/p>\n<p>Save and close<em> \u00a0\u00a0Exp19_Excel_Ch06_HOEAssessment_ScholarshipDinner.xlsx<\/em>. Exit Excel. Submit \u00a0\u00a0the file as directed.\u00a0<\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>\u00a0Exp19_Excel_Ch06_HOEAssessment_Scholarship_Dinner\u00a0 \u00a0Exp19 Excel Ch06 HOEAssessment Scholarship Dinner Excel Chapter 6 Hands-On Exercise Assessment &#8211; Scholarship Dinner \u00a0\u00a0 Project Description: You have recently been elected social coordinator for your University\u2019s student government association. As part of your duties, you are required to plan an annual scholarship dinner. The dinner is a fundraiser in which the proceeds [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[16],"tags":[],"class_list":["post-94966","post","type-post","status-publish","format-standard","hentry","category-education"],"_links":{"self":[{"href":"https:\/\/assignmenttutors.net\/blog\/wp-json\/wp\/v2\/posts\/94966","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/assignmenttutors.net\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/assignmenttutors.net\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/assignmenttutors.net\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/assignmenttutors.net\/blog\/wp-json\/wp\/v2\/comments?post=94966"}],"version-history":[{"count":0,"href":"https:\/\/assignmenttutors.net\/blog\/wp-json\/wp\/v2\/posts\/94966\/revisions"}],"wp:attachment":[{"href":"https:\/\/assignmenttutors.net\/blog\/wp-json\/wp\/v2\/media?parent=94966"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/assignmenttutors.net\/blog\/wp-json\/wp\/v2\/categories?post=94966"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/assignmenttutors.net\/blog\/wp-json\/wp\/v2\/tags?post=94966"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}