You participated in an evaluation of proposals for consulting services. At the end of the Technical Evaluation which required a minimum of 70 points, you got the following results:   CONSULTANTS KANYIHAMPA MUSANGILA Technical Score 75.17 76.17 Amount USD475,000.00 USD625,000.00   The lowest evaluated financial proposal (Fm) is given the maximum financial score of 100. The formula for determining the financial score is as follows: SF = 100 x Fm /F in which SF is the financial score, Fm is the lowest price and F is the price of the proposal under consideration. The weights given to the Technical and Financial proposals are 80 and 20 respectively. Calculate for each consultant below (a – c): Weighted Technical score. Financial score Combined weighted Technical and weighted Financial score Indicate the best evaluated bidder and their points

Q: Provide a summary of customer balance characteristics for customers who made purchases. Include the…

A: Actually the given information is Minimum Balance 0.00 Maximum Balance 345.86 Average Balance 70.30

Q: During the month of January, an employer incurred the following payroll taxes: FICA Social Security…

A: Debit Payroll Tax Expense: $819 Credit FICA Social Security Taxes Payable: $372 Credit FICA…

Q: In cell D5, construct a formula to calculate the % of Total Projected Investments for Pooled…

A: According to the information given:-We haev to define above scenario in excel.

Q: Calculate the profit (profit) as the retail price minus the wholesale price

A: Note: Since programming language is not mentioned in the question, we will answer this program in…

Q: In the above Excel file that contains a data sheet 'Profit Goal', each quarter's net profit of 2023…

A: The question asks how to use Excel's Goal Seek feature to determine the Gross revenue needed in the…

Q: Write SQL statements to list the name of Lee’s subordinate employee.    (Data Update)     Write…

A: Lees Employee ID is 2 So, to get the lees subordinate then we need to search for this employee ID in…

Q: Based on the ERD below, write the SQL statement to display the average hourly job charge for a job.

A: Query to display the average hourly job charge for a job. To get average hourly job charge for all…

Q: Using an UPDATE statement, give all cardiologists in hospital 'H120' a 13 % salary increase. Your…

A: Actually, database is used to stores the data or information.

Q: Show all female’s first names and their salary.  Show the branchno that has a supervisor whose…

A: Relational database is a type of database which stores and provides the access to data which are…

Q: repare the loan amortization table/schedule from scratch (not the Excel template) for a $300,000,…

A: Please refer the table we have calculated the loan value as 520000 = 650000*(1-0.80) as 20% is down…

Q: You are given the following data tables: Employees(Employeel D, LastName, FirstName, BirthDate,…

A: In this question, we have been given the data tables and we have to write a query where to find all…

Q: D5, create a formula using the VLOOKUP function to determine the cost per participant for the Game…

A: The VLOOKUP function in Excel is a powerful tool that can be used to look up values in a table based…

Q: What is the final value of variable num DECLARE num NUMBER := 5; BEGIN num = num + 2; IF num> 8 THEN…

A: From the given block of code : initially num=5 after that num = num +2                num = 5 + 2…

Q: (h) Using the SUMIF function, write a formula in cell F46 to compute the project's variance. (i)…

A: Solution:   Given,

Q: Course evaluation must have a student, the students relation contains a unique student id, full name…

A: An Entity–relationship model (ER model) describes the structure of a database with the help of a…

Q: 2. 3. Which of the following is true of GROUP BY clauses? (Select all that apply.) a). GROUP BY…

A: group by clause is used to group columns so that aggregate operations can be performed on them.…

Q: Muscat Special Cleaning Service company has been providing building maintenance and cleaning service…

A: ALGORITHM:- 1. Take input details from the user for 5 houses. 2. Calculate the total maintainence…

Q: Write SQL statements for each task:

A: 1. The query for the first part is as follows: Select e.equipmentCode AND e.name AND e.description…

Q: Find the listing of customers who did not make purchases during the invoicing period. Sort the…

A: SQL: SQL (Structured Query Language) is a programming language used to manage and manipulate data in…

Q: Task 6: Find the ID, first name, and last name of each customer for which an invoice was not created…

A: Queries are given below :