Chapter 2, Problem 1AYK

Sumif, Countif Functions                                 Kindly following the instructions below and enter           the appropriate formula in cell.                                 Name Electronics SELLING PRICE Results           Patricia King Laptop  $        6,665.00   Sum all Electronics that equals "Monitor" and enter in D8.   Patricia King Monitor  $        5,000.00             Charles Monaghan Printer  $        7,300.00             Fred Jones Projector  $        6,500.00   In cell D11 count all electronics for Patricia King.   John Paul Headset  $        5,248.00             Charlie Brown Laptop  $        6,000.00             Pink Panter Monitor  $        4,400.00  $     4,400.00                                               ITEM CAR MODEL SELLING PRICE Results           Retro Style Billet Grille Chevy  $             319.00   In cell D17 Sum all Car Models that equals "Dodge".   Hood Vent Dodge  $                55.00             Rear Spoiler…

Sumif, Countif Functions                             Kindly following the instructions below and enter         the appropriate formula in cell.                             Name Electronics SELLING PRICE Results         Patricia King Laptop  $        6,665.00   Sum all Electronics that equals "Monitor" and enter in D8. Patricia King Monitor  $        5,000.00           Charles Monaghan Printer  $        7,300.00           Fred Jones Projector  $        6,500.00   In cell D11 count all electronics for Patricia King. John Paul Headset  $        5,248.00           Charlie Brown Laptop  $        6,000.00           Pink Panter Monitor  $        4,400.00  $     4,400.00                                         ITEM CAR MODEL SELLING PRICE Results         Retro Style Billet Grille Chevy  $             319.00   In cell D17 Sum all Car Models that equals "Dodge". Hood Vent Dodge  $                55.00           Rear Spoiler Mustang  $             220.00…

TP Company has 100 workers. Every worker is paid based on the numbers of working hours and their positions as shown in Table 2. A declaration of workers information is shown in Program Segment B. By referring to this declaration, answer question a and b. Table 2: Working hour rate with position respectively Position                                Rate/hourSupervisor (S)                        20/hourAssistant Supervisor (A)        15/hourOperator (O)                           8/hour   const int SIZE 100;string worker_ID[SIZE];char worker_position[SIZE];int working_hour[SIZE];float salary[SIZE];Program Segment B a. Write a program segment to input data into the arrays declared in Program Segment B b. Write a program segment to calculate salary for each worker and print their workerID number and salary.

A company has 45 employers, 25 work as system developers (D) and (N) work as sales representer while (M) of them work as IT technicians. This company deals with 450 products. In the products table, each product has a name, price, size, and weight.  Draw a flowchart on exel to find how many numbers of the products have a Small size(s), where there are 3 product sizes (S, M, L).

Write collection of production rules to calculate electricity bill as per following rules: •If the units consumed are less than and equal to 300, then the cost is Rs 10/- per unit. •If the units consumed are more than 300 and less than and equal to 500, then the cost is Rs 12/- per unit. •If the units consumed are more than 500 and less than 1000, then the cost is Rs 15/- per unit and surcharge of 15% of bill is added. •If the units consumed are more than 1000, then the cost is Rs 15/- per unit and surcharge of 25% of bill is added. Trace the production rules for the sample execution of the system given below;Write collection of production rules to calculate electricity bill as per following rules: •If the units consumed are less than and equal to 300, then the cost is Rs 10/- per unit. •If the units consumed are more than 300 and less than and equal to 500, then the cost is Rs 12/- per unit. •If the units consumed are more than 500 and less than 1000, then the cost is Rs 15/- per unit…

Write a simple interest function that calculates simple interest with VBA. (can be try at excel.)

Python Programming Problem: The first line consist a number X i.e., the number of test cases. The first line consists three space-separated integers N, Q1, and Q1. Then Q1 lines follow, each containing a description of a road proposed0. Each of these lines contains three space-separated integers p, q, and r, where p and q denote the end points of the road and r denotes the associated cost. Then Q1 lines follow, each containing a description of a road proposed by Brian's company in the same format. Output a single line for each test case. If it is impossible to choose a subset of the roads in such a way that for each pair of cities, there is exactly one path of roads connecting them, output a single line containing "No way" for that test case. Otherwise, output a single line containing two space-separated integers: the maximum profit Brian can gain and the minimum total cost of the chosen roads that yields the maximum profit. Input: 1 3 1 1 0 1 1 0 1 3 Output: No way

(e) In cell E37, write a formula to compute Total Actual Visitors, copy the formula to cell E38. (f) Compute the percent increase in the Total Actual Visitors as compared to Expected mobile website visitors, write the formula in cell G37 and copy to cell G38. (g) In cell H37, Use the IF Function to create a formula to print "Yes" if the App Launch was beneficial to the firm; else, the formula should print "No". Copy the formula to cell H38.Hint: If the Percent increase is positive, then the launch is beneficial; else, it is not beneficial. SCREENSHOT ATTACHED THNAKS

pleaseUsing the below table, Fill in the regrettable Success Moderate Success Failure Sell Company 150 150 150 Form Joint Venture 500 593.00 131.00 Sell Software on own 887.00 400 -500 Regret Table Success Moderate Success Failure Sell Company Form Joint Venture Sell Software on own Based on the MiniMax Regret Method, what is the value for the Decision Alternative Sell company Submit Answer format: Number: Round to: 2 decimal places.