Valentinebudget | Computer Science homework help

     

1

   Download and open the file named exploring_e06_grader_Capstone2.xlsx.
Rename it LastNameFirst_Assignment5__   ValentineBudget.xlsx

 

2

Use   Goal Seek to achieve a $0   balance by changing the Ticket Price per Person.
 

  Hint: -Use of the correct cells in Goal Seek dialog box
  -Apply Goal Seek correctly
  -Correct solution

 

 

3

Beginning   in cell E3, complete the series of substitution values ranging from 200 to 500   at increments of 20   students vertically down column E.
 

  Hint:
  On the Home tab, in the Editing group, use the Fill tool to complete the   substitution values.
  -Series begins in E3
  -Correct incrementation
  -Values range from 200 to 500

 

 

4

Enter   cell references to the Total Income, Total Expenses, and Balance formulas (in   that order) for a one-variable data table in cells F2, G2, and H2   respectively.
 

  Hint:
  Create linking formulas to C20, C32, and C34. Cell references are preceded by   the =   sign.
  Correct cell references to
  -Total Income formula
  -Total Expenses formula
  -Balance formula

 

 

5

Apply   custom number formats to make the formula references appear as the following:   F2- Revenue,   G2 – Expenses,   H2 – Balance.
 

  Hint: Custom number formats make formula references to
  -F2- as Revenue
  -G2- as Expenses
  -F2- as Balance

 

 

6

Create   a one-variable data table for the range E2:H18 using the Number of Attendees   as the column input cell. Format the results with Accounting Number Format   with two decimal places.
 

  Hint:
  -One-variable data table created for range E2:H18
  -Number of Attendees used as column input
  -Results formatted with Accounting number format
  -Format has two decimal places
  -Correct values in Data table

 

 

7

Copy   the Number of Attendees substitution values from the one-variable data table   (in cells E3:E18), and then paste the values starting in cell E22.
 

  Hint: -Number of Attendees from one-variable data table copied correctly
  -Pasted values starts from E22

 

 

8

Type   $50   in cell F21 and complete the series of substitution values from $50 to $100 at $10   increments.
 

  Hint: -Correct value in cell F21
  -Correct incrementation
  -Values from $50 to $100

 

 

9

Enter   the cell reference to the Balance formula (C34) in the cell E21 for a   two-variable data table, then complete the table using cell B9 as the row   input cell and B4 as the column input cell. Format the results with   Accounting Number Format with two decimal places.
 

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

 

 

10

Apply   a Red, Accent 2, Lighter 60% fill color to the three cells closest to   break-even without creating a deficit.
 

  Hint: -Correct color fill used
  -Correct 3 cells highlighted

 

 

11

Apply   custom number format to cell E21 to display # Attend.
 

  Hint: -Custom number format applied to cell E21
  -#Attend displayed on cell

 

 

12

Create   a scenario named 500 Attend   using the Number of Attendees, Caterer’s   Meal Cost per Person, Ticket Price per Person, and Ballroom Rental variables   as the changing cells. Deselect Prevent changes. Enter these values for the   scenario: 500,   15.95,   75,   and 12500.
 

  Hint: -Scenario created with correct values for
  -Number of Number of Attendees
  – Caterer’s   Meal Cost per Person
  -Ticket Price per Person
  -Ballroom Rental
  -Prevent changes deselected
  -Correct scenario name

 

 

13

Create   a second scenario named 400 Attend,   using the same changing cells. Deselect Prevent changes. Enter these values   for the scenario: 400,   17.95,   85,   and 12500.
 

  Hint: -Scenario created with correct values for:
  -Number of Number of Attendees
  – Caterer’s   Meal Cost per Person
  -Ticket Price per Person
  -Ballroom Rental
  -Prevent changes deselected
  -Correct scenario name

 

 

14

Create   a third scenario named 300 Attend,   using the same changing cells. Deselect Prevent changes. Enter these values   for the scenario: 300,   19.95,   90,   and 11995,   respectively.
 

  Hint: -Scenario created with correct values for
  -Number of Number of Attendees
  – Caterer’s   Meal Cost per Person:
  -Ticket Price per Person
  -Ballroom Rental
  -Prevent changes deselected
  -Correct scenario name

 

 

15

Create   a fourth scenario named 200 Attend,   using the same changing cells. Deselect Prevent changes. Enter these values   for the scenario: 200,   22.95,   95,   and 11995,   respectively.
 

  Hint: -Scenario created with correct values for :
  -Number of Number of Attendees
  – Caterer’s   Meal Cost per Person
  -Ticket Price per Person
  -Ballroom Rental
  -Prevent changes deselected
  -Correct scenario name

 

 

16

Generate   a scenario summary report using the Total Income, Total Expenses, and Balance   as the results. Mac users should click OK in any error messages that are   displayed until the summary report is generated.
 

  Hint: Scenario Summary report created using as results
  -Total Income,
  -Total Expenses,
  -Balance
  -Correct scenario summary

 

 

17

Load   the Solver add-in if it is not already loaded. Click the Budget worksheet and   launch Solver. Set the objective to calculate the highest balance possible.
 

  Hint: -Budget worksheet selected
  -Solver launched
  -Objective set to calculate highest balance possible

 

 

18

Use   the Number of Attendees and the Ticket Price per Person as changing variable   cells.
 

  Hint: -Changing variable cells set to
  -Number of Attendees
  -Ticket Price per Person

 

 

19

Set   a constraint so that the Number of Attendees entered in the Input Section of   the workbook does not exceed the specified limitation in cell B12.
 

  Hint: -Constraint set properly with correct cells
  -Number of Attendees does not exceed the specified limitation in B12
  -Correct formula used in the constraint

 

 

20

Set   constraints so that the Ticket Price per Person entered in the Input Section   meets the requirements set in the range A14:B15.
 

  Hint: -Constraint set properly with correct cells
  -Ticket Price per Person meets the requirements range A14:B15
  -Correct formula used in the constraint

 

 

21

Set   an appropriate integer constraint.
 

  Hint: -Constraint set properly with correct cell
  -Correct formula used in the constraint

 

 

22

Set   a constraint that ensures the Valet Parking expense is less than or equal to   the product of the Maximum Parking Stalls and the Valet Parking per Car (in   that order). Note, Mac users should NOT perform this step.
 

  Hint: -Constraint set properly with correct cells
  -Valet Parking expense is less than the product of the Maximum Parking Stalls   and the Valet Parking per Car
  -Valet Parking expense is equal to the product of the Maximum Parking Stalls   and the Valet Parking per Car
  -Correct formula used in the constraint

 

 

23

Solve   the problem, but keep the original values in the Budget worksheet. Generate   the Answer Report.
 

  Hint: -Solver used to solve the problem
  -Answer Report generated
  -Original values kept in the Budget worksheet

 

 

24

Ensure   that the worksheets are correctly named and placed in the following order in   the workbook: Scenario Summary, Answer Report 1, Budget. Save the workbook.   Close the workbook and then exit Excel. Submit the workbook as directed.

Place your order
(550 words)

Approximate price: $22

Calculate the price of your order

550 words
We'll send you the first draft for approval by September 11, 2018 at 10:52 AM
Total price:
$26
The price is based on these factors:
Academic level
Number of pages
Urgency
Basic features
  • Free title page and bibliography
  • Unlimited revisions
  • Plagiarism-free guarantee
  • Money-back guarantee
  • 24/7 support
On-demand options
  • Writer’s samples
  • Part-by-part delivery
  • Overnight delivery
  • Copies of used sources
  • Expert Proofreading
Paper format
  • 275 words per page
  • 12 pt Arial/Times New Roman
  • Double line spacing
  • Any citation style (APA, MLA, Chicago/Turabian, Harvard)

Our guarantees

Delivering a high-quality product at a reasonable price is not enough anymore.
That’s why we have developed 5 beneficial guarantees that will make your experience with our service enjoyable, easy, and safe.

Money-back guarantee

You have to be 100% sure of the quality of your product to give a money-back guarantee. This describes us perfectly. Make sure that this guarantee is totally transparent.

Read more

Zero-plagiarism guarantee

Each paper is composed from scratch, according to your instructions. It is then checked by our plagiarism-detection software. There is no gap where plagiarism could squeeze in.

Read more

Free-revision policy

Thanks to our free revisions, there is no way for you to be unsatisfied. We will work on your paper until you are completely happy with the result.

Read more

Privacy policy

Your email is safe, as we store it according to international data protection rules. Your bank details are secure, as we use only reliable payment systems.

Read more

Fair-cooperation guarantee

By sending us your money, you buy the service we provide. Check out our terms and conditions if you prefer business talks to be laid out in official language.

Read more