Ahmed wants to gift his friend. He has 82.300 OMR. He wants the following products: Sport suite with 15.700 OMR Sport shoes with 32.00 OMR Sport water bottle with 4.50 OMR Headphone with 8.25 OMR iPod with 9.88 OMR Write an algorithm and draw a flowchart to check whether he can buy all the above items. Display the total, and the remaining amount in OMR that Ahmed will have if any.

Ahmed wants to gift his friend. He has 82.300 OMR. He wants the following products: Sport suite with 15.700 OMR Sport shoes with 32.00 OMR Sport water bottle with 4.50 OMR Headphone with 8.25 OMR iPod with 9.88 OMR Write an algorithm and draw a flowchart to check whether he can buy all the above items. Display the total, and the remaining amount in OMR that Ahmed will have if any.

COMPREHENSIVE MICROSOFT OFFICE 365 EXCE

1st Edition

ISBN:9780357392676

Author:FREUND, Steven

Publisher:FREUND, Steven

Chapter4: Financial Functions, Data Tables, And Amortization Schedules

Section: Chapter Questions

Problem 4EYW

See similar textbooks

Similar questions

Ahmed wants to gift his friend. He has 82.300 OMR. He wants thefollowing products:Sport suite with 15.700 OMRSport shoes with 32.00 OMRSport water bottle with 4.50 OMRHeadphone with 8.25 OMRiPod with 9.88 OMRWrite an algorithm and draw a flowchart to check whether he can buy all the aboveitems. Display the total, and the remaining amount in OMR that Ahmed will haveif any
A shop sells books, maps and magazines. Each item is identified by a unique 4– digit code. All books have a code starting with 1, all maps have a codestarting with 2 and all magazines have a code starting with 3. The code 9999is used to end the algorithm. Write an algorithm in the form of a flowchart thatinputs the codes for all items in stock and outputs the number of books,number of maps and the number of magazines in stock. Include anyvalidation checks needed.
One large chemical company pays its salespeople on a commission basis. The salespeople receive $200 per week plus 9% of their gross sales for that week. For example, a salesperson who sells $5000 worth of chemicals in a week receives $200 plus 9% of $5000, or a total of $650. Draw a FLOWCHART that will input each salesperson’s gross sales for last week and will calculate and display that salesperson's earnings. Process one salesperson's figures at a time.
NEED HELP ASAP PLEASE! THANK YOU! Consider a game with three dice, namely, A, B and C. Each die, when rolled, generates a number between 1 and 6 (inclusive) independently and uniformly at random. In each play, the three dice are rolled, then a monetary return is computed according to the values for dice A, B and C, using the following algorithm. ThreeDice(A, B, C) { money = -9; if (A == B and B == C) { money = money + 81; } else if (A == B or B == C or C == A) { money = money + 21; } return money; } Analyze this game by answering the following questions: (a) What is the largest possible return value of ThreeDice? (b) What is the probability of ThreeDice returning the largest possible value? Choose one from below. A. 1/18 B. 1/3 C. 1/216 D. 1/2 E. 1/6 F. none of these is correct G. 1/36 H. 1/12 (c) What is the smallest possible return value of ThreeDice? (d) What is the probability of ThreeDice returning the smallest possible value? Choose one from below. A. 5/54 B. 1/18 C. 5/9 D. 4/9…
6- Please I want answer of this question by typing. Many Thanks Bank Muscat sends the monthly transaction report to all its customers through email. When the customer opens the file send by the bank, the customer is required to enter a valid customer ID Number. The ID Number is a six character long ending with 2 uppercase letters. Examples of valid customer ID Numbers: 5678XY 2343WA 8987HL Write a Pseudocode and Draw Flowchart that will: Ask the customer to enter a valid ID Number if customer input is “E”, allow the customer to quit the program if the ID Number is too short, then tell the customer to renter if the last two characters do not follow the rules, then tell the customer allow the customer to keep entering customer ID Number.
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. A. Draw a flowchart to find the product that has very heavy weight B. Draw a flowchart to find how many numbers of the products have a Small size(s), where there are 3 product sizes (S, M, L).
Write an algorithm and draw a flowchart that calculate daily pocket money based upon one euro per year old if he is under 10 , and two euros per year if 10 or over
The ABC Company plans to give a year-end bonus to each of its employees. draw a flowchart which will compute the bonus of the employee. consider the following criteria: if employee's monthly salary is less than 10,000 pesos, the bonus is 50% of the salary; for employees with salaries greater than 10,000 the bonus is 10,000. print out the name and corresponding bonus of the employee.
Depict the pseudo code as a flowchart. READ A READ B READ C IF C>A THEN IF C>B THEN PRINT 'C must be smaller than at least one number' ELSE PRINT 'Proceed to next stage' ENDIF ELSE PRINT 'B can be smaller than C' ENDIF What is the minimum number of test cases required to guarantee 100% statement and 100% decision coverage?A. 2, 4B. 3, 2C. 3, 3D. 2, 3
Develop Pseudo-code (English-like) for :Also a Flowchart Develop an algorithm to compute gross pay. The inputs to your algorithm are the hours worked per week and the hourly pay rate. The rule for determining gross pay is to pay the regular pay rate for all hours worked up to 40, time-and-a-half for all hours over 40 up to 54, and double time for all hours over 54. Compute and display the value for gross pay using this rule. After displaying one value, ask the user whether he or she wants to do another computation. Repeat the entire set of operations until the user says no.
Hi, my CIT 105 teacher is horrible, and does not teach. She wants an IF equation in microsoft excel that reads:If the company earns over $200,000, shown in cell B10, then multiply this by 35%, if it is false, then multiply by 27%. The formula I came up with is =IF(B10>200000, 0.35, 0.27) This does not give the desired results, and if I type the formula to multiply, which is shown below: =IF(B10>200000, *0.35, *0.27) Then I get an error. Please show me the correct formula and explain how to use the IF function. My teacher isnt very good at her job, and it causes much unnecessary stress. Sincerely, Josh Portman
You sell regular coffee at 10 rs/bag, cappuccino coffee at 13 rs/bag, and mocha coffee for 15rs/bag. If the user buys more than 100rs worth, they get a 15rs discount. Ask the user how many bags of regular coffee s/he wants. Then ask about cappuccino, and then about mocha. Using the input, calculate the total amount the user will pay. If the total is over 100rs, subtract 15rs from their total. Print their receipt, by writing out how many bags of regular they purchased and how much that works out to, then how many bags of cappuccino and how much that works out to, and then how many bags of mocha they purchased and how much that works out to. Finally write out how much the total will be. So, for example, after executing the program, the output might look like this: You purchased 3 bags of regular, totaling 30rs. You purchased 2 bags of cappuccino, totaling 26 rs. You purchased 6 bags of mocha, totaling 90 rs. Your total purchase cost is 146 rs.