{"id":53034,"date":"2022-04-16T13:03:30","date_gmt":"2022-04-16T13:03:30","guid":{"rendered":"https:\/\/assignmenttutors.net\/blog\/valentinebudget-computer-science-homework-help\/"},"modified":"2022-04-16T13:03:30","modified_gmt":"2022-04-16T13:03:30","slug":"valentinebudget-computer-science-homework-help","status":"publish","type":"post","link":"https:\/\/assignmenttutors.net\/blog\/valentinebudget-computer-science-homework-help\/","title":{"rendered":"Valentinebudget | Computer Science homework help"},"content":{"rendered":"
\n

\u00a0\u00a0\u00a0\u00a0\u00a0<\/p>\n

1<\/p>\n

\u00a0\u00a0\u00a0Download and open the file named exploring_e06_grader_Capstone2.xlsx.<\/em>
Rename it LastNameFirst_Assignment5__ \u00a0\u00a0ValentineBudget.xlsx<\/em><\/p>\n

\u00a0<\/p>\n

2<\/p>\n

Use \u00a0\u00a0Goal Seek to achieve a $0<\/strong> \u00a0\u00a0balance by changing the Ticket Price per Person.
\u00a0<\/p>\n

\u00a0\u00a0Hint: -Use of the correct cells in Goal Seek dialog box
\u00a0\u00a0-Apply Goal Seek correctly
\u00a0\u00a0-Correct solution<\/p>\n

\u00a0<\/p>\n

\u00a0<\/p>\n

3<\/p>\n

Beginning \u00a0\u00a0in cell E3, complete the series of substitution values ranging from 200<\/strong> to 500<\/strong> \u00a0\u00a0at increments of 20<\/strong> \u00a0\u00a0students vertically down column E.
\u00a0<\/p>\n

\u00a0\u00a0Hint:
\u00a0\u00a0On the Home tab, in the Editing group, use the Fill tool to complete the \u00a0\u00a0substitution values.
\u00a0\u00a0-Series begins in E3
\u00a0\u00a0-Correct incrementation
\u00a0\u00a0-Values range from 200 to 500<\/p>\n

\u00a0<\/p>\n

\u00a0<\/p>\n

4<\/p>\n

Enter \u00a0\u00a0cell references to the Total Income, Total Expenses, and Balance formulas (in \u00a0\u00a0that order) for a one-variable data table in cells F2, G2, and H2 \u00a0\u00a0respectively.
\u00a0<\/p>\n

\u00a0\u00a0Hint:
\u00a0\u00a0Create linking formulas to C20, C32, and C34. Cell references are preceded by \u00a0\u00a0the =<\/strong> \u00a0\u00a0sign.
\u00a0\u00a0Correct cell references to
\u00a0\u00a0-Total Income formula
\u00a0\u00a0-Total Expenses formula
\u00a0\u00a0-Balance formula<\/p>\n

\u00a0<\/p>\n

\u00a0<\/p>\n

5<\/p>\n

Apply \u00a0\u00a0custom number formats to make the formula references appear as the following: \u00a0\u00a0F2- Revenue<\/strong>, \u00a0\u00a0G2 \u2013 Expenses<\/strong>, \u00a0\u00a0H2 \u2013 Balance<\/strong>.
\u00a0<\/p>\n

\u00a0\u00a0Hint: Custom number formats make formula references to
\u00a0\u00a0-F2- as Revenue
\u00a0\u00a0-G2- as Expenses
\u00a0\u00a0-F2- as Balance<\/p>\n

\u00a0<\/p>\n

\u00a0<\/p>\n

6<\/p>\n

Create \u00a0\u00a0a one-variable data table for the range E2:H18 using the Number of Attendees \u00a0\u00a0as the column input cell. Format the results with Accounting Number Format \u00a0\u00a0with two decimal places.
\u00a0<\/p>\n

\u00a0\u00a0Hint:
\u00a0\u00a0-One-variable data table created for range E2:H18
\u00a0\u00a0-Number of Attendees used as column input
\u00a0\u00a0-Results formatted with Accounting number format
\u00a0\u00a0-Format has two decimal places
\u00a0\u00a0-Correct values in Data table <\/p>\n

\u00a0<\/p>\n

\u00a0<\/p>\n

7<\/p>\n

Copy \u00a0\u00a0the Number of Attendees substitution values from the one-variable data table \u00a0\u00a0(in cells E3:E18), and then paste the values starting in cell E22.
\u00a0<\/p>\n

\u00a0\u00a0Hint: -Number of Attendees from one-variable data table copied correctly
\u00a0\u00a0-Pasted values starts from E22<\/p>\n

\u00a0<\/p>\n

\u00a0<\/p>\n

8<\/p>\n

Type \u00a0\u00a0$50<\/strong> \u00a0\u00a0in cell F21 and complete the series of substitution values from $50 to $100<\/strong> at $10<\/strong> \u00a0\u00a0increments.
\u00a0<\/p>\n

\u00a0\u00a0Hint: -Correct value in cell F21
\u00a0\u00a0-Correct incrementation
\u00a0\u00a0-Values from $50 to $100<\/p>\n

\u00a0<\/p>\n

\u00a0<\/p>\n

9<\/p>\n

Enter \u00a0\u00a0the cell reference to the Balance formula (C34) in the cell E21 for a \u00a0\u00a0two-variable data table, then complete the table using cell B9 as the row \u00a0\u00a0input cell and B4 as the column input cell. Format the results with \u00a0\u00a0Accounting Number Format with two decimal places.
\u00a0<\/p>\n

\u00a0\u00a0Hint: -Cell reference to Balance formula (C34 )in cell E21
\u00a0\u00a0-Two-variable table completed with cell B9 as row input
\u00a0\u00a0-Two-variable table completed with cell B4 as column input
\u00a0\u00a0-Results formatted with Accounting number format
\u00a0\u00a0-Format has two decimal places
\u00a0\u00a0-Correct values in Data table<\/p>\n

\u00a0<\/p>\n

\u00a0<\/p>\n

10<\/p>\n

Apply \u00a0\u00a0a Red, Accent 2, Lighter 60% fill color to the three cells closest to \u00a0\u00a0break-even without creating a deficit.
\u00a0<\/p>\n

\u00a0\u00a0Hint: -Correct color fill used
\u00a0\u00a0-Correct 3 cells highlighted<\/p>\n

\u00a0<\/p>\n

\u00a0<\/p>\n

11<\/p>\n

Apply \u00a0\u00a0custom number format to cell E21 to display # Attend<\/strong>.
\u00a0<\/p>\n

\u00a0\u00a0Hint: -Custom number format applied to cell E21
\u00a0\u00a0-#Attend displayed on cell<\/p>\n

\u00a0<\/p>\n

\u00a0<\/p>\n

12<\/p>\n

Create \u00a0\u00a0a scenario named 500 Attend<\/strong> \u00a0\u00a0using the Number of Attendees, Caterer\u2019s \u00a0\u00a0Meal Cost per Person, Ticket Price per Person, and Ballroom Rental variables \u00a0\u00a0as the changing cells. Deselect Prevent changes. Enter these values for the \u00a0\u00a0scenario: 500<\/strong>, \u00a0\u00a015.95<\/strong>, \u00a0\u00a075<\/strong>, \u00a0\u00a0and 12500<\/strong>.
\u00a0<\/p>\n

\u00a0\u00a0Hint: -Scenario created with correct values for
\u00a0\u00a0-Number of Number of Attendees
\u00a0\u00a0– Caterer\u2019s \u00a0\u00a0Meal Cost per Person
\u00a0\u00a0-Ticket Price per Person
\u00a0\u00a0-Ballroom Rental
\u00a0\u00a0-Prevent changes deselected
\u00a0\u00a0-Correct scenario name<\/p>\n

\u00a0<\/p>\n

\u00a0<\/p>\n

13<\/p>\n

Create \u00a0\u00a0a second scenario named 400 Attend<\/strong>, \u00a0\u00a0using the same changing cells. Deselect Prevent changes. Enter these values \u00a0\u00a0for the scenario: 400<\/strong>, \u00a0\u00a017.95<\/strong>, \u00a0\u00a085<\/strong>, \u00a0\u00a0and 12500<\/strong>.
\u00a0<\/p>\n

\u00a0\u00a0Hint: -Scenario created with correct values for:
\u00a0\u00a0-Number of Number of Attendees
\u00a0\u00a0– Caterer\u2019s \u00a0\u00a0Meal Cost per Person
\u00a0\u00a0-Ticket Price per Person
\u00a0\u00a0-Ballroom Rental
\u00a0\u00a0-Prevent changes deselected
\u00a0\u00a0-Correct scenario name<\/p>\n

\u00a0<\/p>\n

\u00a0<\/p>\n

14<\/p>\n

Create \u00a0\u00a0a third scenario named 300 Attend<\/strong>, \u00a0\u00a0using the same changing cells. Deselect Prevent changes. Enter these values \u00a0\u00a0for the scenario: 300<\/strong>, \u00a0\u00a019.95<\/strong>, \u00a0\u00a090<\/strong>, \u00a0\u00a0and 11995<\/strong>, \u00a0\u00a0respectively.
\u00a0<\/p>\n

\u00a0\u00a0Hint: -Scenario created with correct values for
\u00a0\u00a0-Number of Number of Attendees
\u00a0\u00a0– Caterer\u2019s \u00a0\u00a0Meal Cost per Person:
\u00a0\u00a0-Ticket Price per Person
\u00a0\u00a0-Ballroom Rental
\u00a0\u00a0-Prevent changes deselected
\u00a0\u00a0-Correct scenario name<\/p>\n

\u00a0<\/p>\n

\u00a0<\/p>\n

15<\/p>\n

Create \u00a0\u00a0a fourth scenario named 200 Attend<\/strong>, \u00a0\u00a0using the same changing cells. Deselect Prevent changes. Enter these values \u00a0\u00a0for the scenario: 200<\/strong>, \u00a0\u00a022.95<\/strong>, \u00a0\u00a095<\/strong>, \u00a0\u00a0and 11995<\/strong>, \u00a0\u00a0respectively.
\u00a0<\/p>\n

\u00a0\u00a0Hint: -Scenario created with correct values for :
\u00a0\u00a0-Number of Number of Attendees
\u00a0\u00a0– Caterer\u2019s \u00a0\u00a0Meal Cost per Person
\u00a0\u00a0-Ticket Price per Person
\u00a0\u00a0-Ballroom Rental
\u00a0\u00a0-Prevent changes deselected
\u00a0\u00a0-Correct scenario name<\/p>\n

\u00a0<\/p>\n

\u00a0<\/p>\n

16<\/p>\n

Generate \u00a0\u00a0a scenario summary report using the Total Income, Total Expenses, and Balance \u00a0\u00a0as the results. Mac users should click OK in any error messages that are \u00a0\u00a0displayed until the summary report is generated.
\u00a0<\/p>\n

\u00a0\u00a0Hint: Scenario Summary report created using as results
\u00a0\u00a0-Total Income,
\u00a0\u00a0-Total Expenses,
\u00a0\u00a0-Balance
\u00a0\u00a0-Correct scenario summary<\/p>\n

\u00a0<\/p>\n

\u00a0<\/p>\n

17<\/p>\n

Load \u00a0\u00a0the Solver add-in if it is not already loaded. Click the Budget worksheet and \u00a0\u00a0launch Solver. Set the objective to calculate the highest balance possible.
\u00a0<\/p>\n

\u00a0\u00a0Hint: -Budget worksheet selected
\u00a0\u00a0-Solver launched
\u00a0\u00a0-Objective set to calculate highest balance possible<\/p>\n

\u00a0<\/p>\n

\u00a0<\/p>\n

18<\/p>\n

Use \u00a0\u00a0the Number of Attendees and the Ticket Price per Person as changing variable \u00a0\u00a0cells.
\u00a0<\/p>\n

\u00a0\u00a0Hint: -Changing variable cells set to
\u00a0\u00a0-Number of Attendees
\u00a0\u00a0-Ticket Price per Person<\/p>\n

\u00a0<\/p>\n

\u00a0<\/p>\n

19<\/p>\n

Set \u00a0\u00a0a constraint so that the Number of Attendees entered in the Input Section of \u00a0\u00a0the workbook does not exceed the specified limitation in cell B12.
\u00a0<\/p>\n

\u00a0\u00a0Hint: -Constraint set properly with correct cells
\u00a0\u00a0-Number of Attendees does not exceed the specified limitation in B12
\u00a0\u00a0-Correct formula used in the constraint<\/p>\n

\u00a0<\/p>\n

\u00a0<\/p>\n

20<\/p>\n

Set \u00a0\u00a0constraints so that the Ticket Price per Person entered in the Input Section \u00a0\u00a0meets the requirements set in the range A14:B15.
\u00a0<\/p>\n

\u00a0\u00a0Hint: -Constraint set properly with correct cells
\u00a0\u00a0-Ticket Price per Person meets the requirements range A14:B15
\u00a0\u00a0-Correct formula used in the constraint<\/p>\n

\u00a0<\/p>\n

\u00a0<\/p>\n

21<\/p>\n

Set \u00a0\u00a0an appropriate integer constraint.
\u00a0<\/p>\n

\u00a0\u00a0Hint: -Constraint set properly with correct cell
\u00a0\u00a0-Correct formula used in the constraint<\/p>\n

\u00a0<\/p>\n

\u00a0<\/p>\n

22<\/p>\n

Set \u00a0\u00a0a constraint that ensures the Valet Parking expense is less than or equal to \u00a0\u00a0the product of the Maximum Parking Stalls and the Valet Parking per Car (in \u00a0\u00a0that order). Note, Mac users should NOT perform this step.
\u00a0<\/p>\n

\u00a0\u00a0Hint: -Constraint set properly with correct cells
\u00a0\u00a0-Valet Parking expense is less than the product of the Maximum Parking Stalls \u00a0\u00a0and the Valet Parking per Car
\u00a0\u00a0-Valet Parking expense is equal to the product of the Maximum Parking Stalls \u00a0\u00a0and the Valet Parking per Car
\u00a0\u00a0-Correct formula used in the constraint<\/p>\n

\u00a0<\/p>\n

\u00a0<\/p>\n

23<\/p>\n

Solve \u00a0\u00a0the problem, but keep the original values in the Budget worksheet. Generate \u00a0\u00a0the Answer Report.
\u00a0<\/p>\n

\u00a0\u00a0Hint: -Solver used to solve the problem
\u00a0\u00a0-Answer Report generated
\u00a0\u00a0-Original values kept in the Budget worksheet <\/p>\n

\u00a0<\/p>\n

\u00a0<\/p>\n

24<\/p>\n

Ensure \u00a0\u00a0that the worksheets are correctly named and placed in the following order in \u00a0\u00a0the workbook: Scenario Summary, Answer Report 1, Budget. Save the workbook. \u00a0\u00a0Close the workbook and then exit Excel. Submit the workbook as directed.<\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"

\u00a0\u00a0\u00a0\u00a0\u00a0 1 \u00a0\u00a0\u00a0Download and open the file named exploring_e06_grader_Capstone2.xlsx.Rename it LastNameFirst_Assignment5__ \u00a0\u00a0ValentineBudget.xlsx \u00a0 2 Use \u00a0\u00a0Goal Seek to achieve a $0 \u00a0\u00a0balance by changing the Ticket Price per Person.\u00a0 \u00a0\u00a0Hint: -Use of the correct cells in Goal Seek dialog box\u00a0\u00a0-Apply Goal Seek correctly\u00a0\u00a0-Correct solution \u00a0 \u00a0 3 Beginning \u00a0\u00a0in cell E3, complete the series of […]<\/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-53034","post","type-post","status-publish","format-standard","hentry","category-education"],"_links":{"self":[{"href":"https:\/\/assignmenttutors.net\/blog\/wp-json\/wp\/v2\/posts\/53034","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=53034"}],"version-history":[{"count":0,"href":"https:\/\/assignmenttutors.net\/blog\/wp-json\/wp\/v2\/posts\/53034\/revisions"}],"wp:attachment":[{"href":"https:\/\/assignmenttutors.net\/blog\/wp-json\/wp\/v2\/media?parent=53034"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/assignmenttutors.net\/blog\/wp-json\/wp\/v2\/categories?post=53034"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/assignmenttutors.net\/blog\/wp-json\/wp\/v2\/tags?post=53034"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}