A software company sells a package that retails for $100. Quantity discounts are given according to the following tables. Quantity 10-19 Discount 20% 30% 40% 50% 20-49 50-99 100 or more Asks for the number of units sold and computes the total cost of the purchase.
Q: Question 41: Match each reference or formula to its best description. =$A$6 =$B7…
A: =$A$6 =$B7 =SUM(AVERAGE(A1:!6), B7) Absolute cell…
Q: please draw flow chart clear and easy
A: Steps - start Initialize variables n for height, i, j, and space take user input for n decrement…
Q: Student Number ending in Non-Prime Number: Determine the decision if, weather:sunny, parents:yes,…
A: The decision tree is the flow chart structure in which each internal node represents the test on the…
Q: An IF function will be entered into an Excel worksheet to evaluate the contents of two cell…
A: Let's see the answer:
Q: Input the Product name in upper case if the quantity is less than or equal to 20, and lower case if…
A: product name=input("enter the name") quantity=int(input("enter the value") if (quantity<=20):…
Q: please answer Exercise 4-7
A: In this question we have to answer the bash related question Let's code and answer
Q: Use python please. Include bounds and risk. You are the manager of a £100 million portfolio, and…
A: Python is widely used in a variety of applications, including web development, scientific computing,…
Q: Display the cost of landscaping a backyard with sod that is sold by the square foot and fencing that…
A: This code calculates the cost of landscaping a backyard with sod and fencing. The user inputs the…
Q: Explain the significance of using a parameter in a stored procedure.
A: Stored Procedure : A stored procedure is a precompiled and stored database program that can be…
Q: Write a program that asks the user to enter the material they wish to purchase (wood, brick, or…
A: def wood(n): costSingle = 0 shippingCharge = 0 if(n>=1 and n<100): costSingle…
Q: Based on the following EER diagram, select the correct statements. ISBN Edition Publication Title…
A: EER stands for Enhanced Entity Relationship diagram which is an advanced database diagrams that are…
Q: Due to class time restrictions, the lecturer is unable to respond to all the students' queries.
A: Please Specify More information regarding the same.
Q: The expression =IF(A1 > 8, 12*A1, 7*A1) is used in a spreadsheet. Find the result if A1 is 5 Find…
A: We have expression IF(A1>8, 12*A1, 7*A1) When A1>8, then the result = 12*A1 Else A1≤8 then the…
Q: GreenLawn a local lawn care company has different pricing policies for its customers. GreenLawn…
A: GreenLawn, a local lawn care company, has different pricing policies for its customers. The company…
Q: Explain difference between procedure and function.
A: Procedures: They are collections of statements that carry out a particular operation or action in a…
Q: To calculate the monthly End Inventory, the following formula is used: Average (Start inventory, end…
A: We are going to see which formula can be used to calculate monthly End Inventory from the given…
Q: .... variables are the best starting market segments.
A: Variable is defined as the characteristics of the people and are used to find similar people which…
Q: s of enrolment number - 308 Let a, b and c denote the last three digits of your enrolment number…
A:
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: Evaluate: C(6,2) 8900 Evaluate: P(9,3)
A: The question is solved in step2
Q: In an arithmetic equation with nested parentheses, which pair of parentheses is evaluated first?
A: Introduction: When parentheses are nested, the most extensive arrangement of parentheses is…
Q: Employee view attendance report The employee must be logged in to the system to perform this…
A: One Actor? Answer: Employee One Use Case Name? Answer: A use case describes a function that a…
Q: Determine the kind of books that are currently available in the library's collection. There should…
A: Introduction: A vast array of books has always been housed in the libraries of colleges and…
Q: Whether the statement "If A → B, B → C, C → D, and C→ A are all true, then D → B must be true." is…
A: According to the information given:- We have to verify the mentioned statement is true or not.
Q: Question 20 Unknown value can be represented in a table as O NULL O Zero O Unknown ΝΑ
A: Introduction: When working with data in a table or database, it is common to encounter missing or…
Q: The following is a table of applicants to be considered for admission into 07BSAM: POINTS MATH…
A: - We need to provide pseudocode for the modes of study for students using FOR-LOOP. - I have…
Q: R&R Travel and Tours offers special promotion flight fare from Kuala Lumpur to Kota Bharu on…
A: The program reads air code, category, and number of persons. These are should be in a while loop…
Q: At a local university, each engineering major requires a different number of credits for graduation.…
A: Ask the user to the enter the engineering program they want the grades for. Then according to the…
Q: Note: “breadth” is a boolean indicating whether or not a course satisfies the breadth requirement…
A: Question: Department and cNum of all courses that have been taught in every term when csc448 was…
Q: The operator that returns the remainder of a division between A and B A/B A/=B A%B A |= B
A: correct answer is A%B
Q: What is MINR minimum value across a range of value?
A: MINR: To do complex mathematical calculations, the math instruction “Calculate Expression” is used.…
Q: Find the number of employees hired in January of all years
A: The select statement is used to select tuples (Raw) from the table.The cout(*) is used to count all…
Q: Calculate the total resistance using the following formula
A: Given R1=9 , R2=18
Q: What types of relationships between numeric values can you test with relational operators?
A: Relationship between values with relational operators Relational operators are used in forming…
Q: Look up student MAJOR and ROOM information based on the student NAME. Enter formula into B2. 1 NAME…
A: Question given- A Table is given, Lookup student MAJOR and ROOM information based on student name.…
Q: Rewrite the age = age + 1; statement using an arithmetic assignment operator.
A: Required:
Q: How many select statements may be concatenated from the same table?
A: Intro The combination of similar statements increases the likelihood of a false positive (false…
Q: The most important rule when assigning wherein the assignment operation always takes place from…
A: when we assign any value to a variable; programming language always uses right to left rule like…
Trending now
This is a popular solution!
Step by step
Solved in 2 steps with 3 images
- 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 /…Richardson Ski Racing (RSR) sells equipment needed for downhill ski racing. One of RSR's products is fencing used on downhill courses. The fence product comes in 150-foot rolls and sells for $215 per roll. However, RSR offers quantity discounts. The following table shows the price per roll depending on order size: Quantity Ordered From To Price per Roll 1 30 $215 31 60 $195 61 ཙཙ 120 $175 121 and up $155 Click on the datafile logo to reference the data. (a) Use the VLOOKUP function with the preceding pricing table to determine the total revenue from these orders. $ (b) Use the COUNTIF function to determine the number of orders in each price bin. From To Price per Roll Number of Orders 1 30 $215 31 60 $195 61 120 $175 121 and up $155 172 12Find your group number• The remainder after division of second to last digit of your student id by 3 is a.• The last digit of your student id is b.• Your group number is ab, which is an integer between 0 and 29.• If your group number is equal to ab=00 then take it as ab=01.Examples:• Student Id = 290316027 → Group = 27• Student Id = 290315043 → Group = 13• Student Id = 280315061 → Group = 01• Student Id = 270316085 → Group = 25• Student Id = 290315027 → Group = 27 my student Id is 280316014 but i didnt calculate ab.Can you help me .Thank you.
- Richardson Ski Racing (RSR) sells equipment needed for downhill ski racing. One of RSR's products is fencing used on downhill courses. The fence product comes in 150-foot rolls and sells for $215 per roll. However, RSR offers quantity discounts. The following table shows the price per roll depending on order size: Quantity Ordered To Price per Roll From 1 70 $215 71 140 $195 141 280 $175 281 and up $155 Click on the datafile logo to reference the data. DATA file (a) Use the VLOOKUP function with the preceding pricing table to determine the total revenue from these orders. (b) Use the COUNTIF function to determine the number of orders in each price bin. From Number of To Price per Roll 70 $215 !!! 140 $195 280 $175 and up $155 1 71 141 281 Orders 172calculate_new_balance Given a starting balance (a number), and a list of transaction tuples, calculate the final balance for an account. Transaction tuples are of the shape ("description", amount, "withdrawal") , or ("description", amount, "deposit"). The last entry in the tuple will be either "withdrawal" or "deposit". Every withdrawal decreases the balance of the account by the specified amount, and every deposit increases the balance. The return value is the new account balance, as a number. (which could be negative) Sample calls should look like: >>> calculate_new_balance(100, [("payday", 20, "deposit"), ("new shoes", 50, "withdrawal"), ("illicit winnings", 200, "deposit")])270>>> calculate_new_balance(100, [])100¥ Question Completion Status: Given a truth table below with the first two columns of truth values provided: b. (p.q) 1 2 T F 4. Which of the answers below contains the truth values for the third column when f(p,q) = p q ? Column 3 Column 3 Column 3 truth values: Column 3 truth Column 3 truth values: truth values: truth values: values: 1 T 1 F 1 F 1 F 1 T None of the other answers O 2 F O 2 T 2 T 2 T provided is correct. 2 F 3 F 3 F 3 T 3 T 3 F 4 T 4 F 4 T 4 F 4 T Save All Answers Save and Su Click Save and Submit to save and subrmit. Click Save All Answers to save all answers. 0 日 la (99+ here to search 3.
- 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 duein 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 ?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
- Don't want copy paste answerR&R Travel and Tours offers special promotion flight fare from Kuala Lumpur to Kota Bharu on February 2015. Passengers under 12 years old will be subjected to Children rates. The special rates are shown in Table 1. Table 1: Special rates from Kuala Lumpur to Kota Bharu Airlines Airlines Rates Code Adult Children 1 Air Asia RM 100 RM 20 2 Malaysia Airlines RM 210 RM 50 3 Malindo Air RM 90 RM 10 Calculate the total amount of flight fares according to Table 1. Use loops to ask if customer wants to add more booking. Program to calculate Flight Fares Enter Airlines Code : 1 : A Enter Category (A- Adult, C - Children) Enter number of persons : 2 Enter more? (Y- yes, N- No) : Y Enter Airlines Code : 1 Enter Category (A- Adult, C - Children) : C Enter number of persons : 1 Enter more? (Y- yes, N- No) : N Total Amount : RM 220.00 (i) (ii) Draw flowchart of the solution. Write a complete C program based on the problem.The following list shows the items and prices for a restaurant order. Calculate the total amount if there is 7.5% tax and the customer leaves a 15% gratuity. 1 appetizer: $8.99 2 entrees: $14.99 each 1 entree: $12.99 3 drinks: $1.99 each a. $70.96 b. $71.62 c. $75.31 d. $75.97 Please select the best answer from the choices provided A Mark this and retum No hand written and fast answer with explanation