Angel Consulting is considering 8 projects. Each project has a cost and an associated return. The budget at Angel is $580. Angel would like to choose the set of projects that maximize the total project return. This data below is provided in the workbook that accompanies this quiz. Project 1 2 3 4 5 6 7 8 Cost $130 $100 $165 $180 $225 $190 $140 $185 Return $205 $225 $350 $285 $400 $325 $265 $375 Which of the following are true for Angel Consulting's project choice problem? O When executing the Greedy Solution Heuristic for this problem, the first project selected is project 5. O When executing the Greedy Solution Heuristic for this problem, the second project selected is project 3. O Exactly two answers are correct. O The Greedy Solution Heuristic completely ignores the project costs and only looks at the project returns. O The solution found using the Greedy Solution Heuristic for this problem will have 3 projects.

Angel Consulting is considering 8 projects. Each project has a cost and an associated return. The budget at Angel is $580. Angel would like to choose the set of projects that maximize the total project return. This data below is provided in the workbook that accompanies this quiz. Project 1 2 3 4 5 6 7 8 Cost $130 $100 $165 $180 $225 $190 $140 $185 Return $205 $225 $350 $285 $400 $325 $265 $375 Which of the following are true for Angel Consulting's project choice problem? O When executing the Greedy Solution Heuristic for this problem, the first project selected is project 5. O When executing the Greedy Solution Heuristic for this problem, the second project selected is project 3. O Exactly two answers are correct. O The Greedy Solution Heuristic completely ignores the project costs and only looks at the project returns. O The solution found using the Greedy Solution Heuristic for this problem will have 3 projects.

COMPREHENSIVE MICROSOFT OFFICE 365 EXCE

1st Edition

ISBN:9780357392676

Author:FREUND, Steven

Publisher:FREUND, Steven

Chapter9: Formula Auditing, Data Validation, And Complex Problem Solving

Section: Chapter Questions

Problem 8AYK

See similar textbooks

Similar questions

The International Conference on Mathematical Sciences and Technology, Math Tech, is a biennial conference organised by the School of Mathematical Sciences, USM. This event is open to all national and international experts, practitioners, researchers, and academics to gather and share their knowledge. The details of fees for participation in the conference are shown in the following table. Category Local (RM) International (USD) Presenter 990 260 Observer 600 150 Note: 1 USD = RM4.20 Assignment Requirement Part 1: Create Invoice Construct a C++ program to do the following tasks: a. Enter the participant's name, category, nationality, accommodation (Yes/No). b. If the answer for the question on accommodation is Yes, the program will ask for the number of days. Then the program will call function calcAccommodation() to calculate the accommodation charges. calcAccommodation() receives accommodation (Yes/No), number of days and participation type (local/international) as parameters and…
Each salesperson at IdzaaraAisya Inc. receives a commission based on the amount of his or her sales. The commission rates and additional payment amounts are shown below. Sales ($) Commission 1–5,999.99 10% of sales 6,000–29,999.99 $600 plus 13% of the sales over 6,000 30,000 and over $3,720 plus 14% of the sales over 30,000 Additional $500 if the salesperson has worked at the company for over 10 years and the sales amount is at least $10,000. $700 if the salesperson travels. Draw a flow chart. Calculate the commission, any additional amount, and the total due only when the sales amount is greater than 0; otherwise, display $0.00 as the commission, additional amount, and total due
The following is a table of applicants to be considered for admission into 07BSAM: POINTS MATH SYMBOL 123 450 NAMES STUDENT NUMBER ENG SYMBOL To qualify for admission, an applicant should have at least 25 points, minimum of B symbol in Mathematics and a minimum of E symbol in English. If an applicant has a C symbol in Mathematics, then the applicant must pass an entrance test to be considered for admission. Hints: There are three modes of study: The Full-time mode, the Part-time mode and the Distance mode. Applicants can choose which mode they want provided there is space in that mode. Each of the Full- time and the Part-time modes cannot accommodate more 30 admitted students. After these two modes are full, every other qualified applicant is admitted in the Distance mode. The admission exercise is first come first served. Write a pseudocode that identifies the applicants that qualify for admission and outputs their names, student numbers and modes of study. Use a FOR-LOOP /…
3.Rose Theater Company For this assignment you will modify the Rose Theater Company assignment created in chapter 2. Rose Theater company sells tickets to their productions. There are three seating options for purchase at Rose's theater; Orchestra seats, Center Stage seats, and Outer Stage seats. Orchestra seats cost $75 each, Center Stage seats cost $50 each, and Outer Stage seats cost $25 each. The theater company also gives a discount of 5% on tickets to the local theater group members. The user will enter the number of Orchestra, Center State, and/or Outer stage seats the customer wants to purchase along with whether the customer is a member of the local theater group. The program will calculate and display the income from each type of seat sale along with the discount, and total sale. Requirements Must include use of named constants Must include meaningful variable names Must include a main function with a call to the main function. Must include at least one value returning…
Q :Draw a flow chart for Grade calculation. i :Refer to undergraduate prospectus
If a team is unable to complete all the points of work allocated for an iteration, the team should use the number of points that were completed as basis for the work for the next iteration. True/False
Look up student MAJOR and ROOM information based on the student NAME. Enter formula into B2. 1 NAME MAJOR ROOM 2 58 3 4 NAME MAJOR ROOM 5 $1 CIS DBH 6 S2 7 3 A/F DBH A/F DBH 8 $4 мом SCI 9 S5 мом DBH 10 56 CIS SCI 11 S7 CIS DBH 12 S8 A/F 13 S9 мом 14 S10 CIS Size Color Price Item T. 15 Size L T M 16 Color R. 17 Price 28 H. 29 30 XL R. 18
Using Tableau create a variable for following situation student classification Graduate undergraduate HONOR (based on classification) for graduate GPA>90 then "GOLD" for undergraduate GPA>80 then "gold ribbon"
Calculate BEP for the following information. Year o Year 1 Year 2 Year 3 Total benefit 0 49561 61635 70565 Total cost 80848 11671 12472 14009 Enter BEP (Round the value to 2 decimal point. Ex: 2.09, 3.50, 4.65 etc)
Camille needs to identify the number of projects that have a final cost of more than $100,000 and those that were completed in 2019.Create formulas that provide this information as follows: In cell K11, create a formula using the DCOUNT function to count the number of projects with final costs of more than $100,000, using the data in the entire Projects table (Projects[#All]) and counting the values in the column of final costs ("Final Cost") that are equal to the values in the range J9:J10. In cell K15, create a formula using the DCOUNTA function to count the number of projects completed in 2019, using the data in the entire Projects table (Projects[#All]) and counting the values in the column of completion dates ("Completed") that are equal to the values in the range J13:J14.
in a shop ,there are 10 employee and 20 kinds of goods，goods id between 1-20 EMPLOYEE id first name last name gender 10001, 'Tom', 'Brown', 'F'10002, 'Elizabeth', 'Tremblay', 'F'10003, 'Gladys', 'Julie', 'F10004, 'John', 'Taylor', 'M10005, 'Amelia', 'Smith'10006, 'Logan', 'Katherine'10007, 'Leo', 'Brown'10007, 'Lem', 'Thompson'10009, 'Tom' 'Smith'10010, 'Emma', 'Campbell' ------------ and I want to add a name library in it ,like this how could i create a HTML file ,with will randomly create customers with these employee . there is a start button on the page . press "start "bottom ,and it will It will randomly match 10 items, customers, and goods, display goods id ,customername and gender ,employer name , id and gender . how to do such a page ?
Based on the ERD below, for each project calculate the difference between the project value and the project balance. Display the result in a new column name “Remaining Balance”. Include the project number and project name in the result output.