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: Draw flow chart to estimated salary for the proportion of workers 6 people 5 ID per hour where…

A: 1) For start and stop we have to use oval symbol  2)For calculation we have to use rectangle  3)For…

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: A- determine the type of relationships (generally) between: - orderNo : itemNo - date : orderNo B-…

A: The given problem is related to database normalization where the normalization is a process of…

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: If there is no % specified, how can we calculate EF?

A: Introduction: Calculation of the Exposure Factor (EF) The Exposure Factor indicates a percentage…

Q: Question 2 The following would return Select VIN, sum(Expen) From VExpense; the sum of expenses an…

A: Objective: An SQL query is given whose outcome will be determined through several options. The query…

Q: Please see the attached and assist with below question. Using the “Aggregates” worksheet, complete…

A: The given problem is to complete the given excel for an income tax calculation using MS EXCEL and…

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: Normalize the below given Student Course Plan to First Normal Form, Second Normal Form and Third…

A: Normalization : is the process of minimizing redundancy from a relation or set of relations.   1NF :…

Q: A5. Identify week entity in the following scenario: "Students registered in a particular course…

A:

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: Analyze the given tables showing the information of different candidates and departments. You are…

A: => here in the question given 2 tables one is Candidates and other one is Departments

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: Calculate BEP for the following information. Year o Year 1 Year 2 Year 3 Total benefit 0 49561 61635…

A: Here, I have to provide a solution to the above question.

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: Normalize the below given Student Course Plan to First Normal Form, Second Normal Form and Third…

A: From the given question we can identify the below functional dependencies which are violating the…

Q: Ryan Car Rental LLC. Quarterly Turnover Report Report ID.: 7686 Reporting period: Jan 2019-Mar 2019…

A: Need to find First Normal Form, Second Normal Form and Third Normal Form of the given database :

Q: For calculating the delivery charges, customers are divided into two categories: those whose sales…

A: In this question we have to understand about the given Scenario:Customers are divided into two…

Q: complete the income statement for Thom-Pierre consultants for the  year ended 31 december.…

A: total expenses bedpre taxes= 460000+195000+55000+25200=735200 Total taxeble income=  2073500-735200=…

Q: aC program to enter the midterm marks of 4 courses for 3 students. Calculate the average mark for…

A: For this program, the concept of parallel arrays will be used. Algorithm for writing the program is…

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: Muscat Special Cleaning Service company has been providing building maintenance and cleaning service…

A: Required:

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: Define the term " relational equal " .

A: Please find the answer below :

Q: There are 9 workers for ASH Development Sdn. Bhd. as shown in Table Q4. Unfortunately, there are…

A: According to question there are 9 workers and 4 rooms. The Ids of workers selected for the jobs are…

Q: Table (A): Income tax rates assessment year 2020 Chargeable Income (101) Calculation (RM) Rate %…

A: int tax_calculate(int inc){ if(inc>0 && inc <= 5000) { return 0; }…

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: Table (A) shows the individual income tax rates for assessment year 2020. Table (A): Income tax…

A: #include<stdio.h> float calculate_tax(float i){    if(i>=0 && i<=5000)    {…

Q: Financial Aggregated Data Average Revenue Largest Expenses Lowest Revenues Smallest Expenses # of…

A: the answer is

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: Table below shows the number of students enrolled in public university for the study field of…

A: In a binary search tree the values been inserted are accordingly: The smaller one a inserted to the…

Q: Using a flow chart, show the flow of funds from fund suppliers to fund demanders!

A: Here is the chart of the flow between the suppliers to demanders.

Q: Nizwa AC Maintenance company has been providing Air conditioners maintenance and service for their…

A: Required:

Q: Write a report of all films shown in August 2021 more than 16 times, give the films name, how many…

A: In the question there is no source related to the tables is given. So, we consider the table name as…

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 :