CMPTR
3rd Edition
ISBN: 9781337681872
Author: PINARD
Publisher: Cengage
expand_more
expand_more
format_list_bulleted
Concept explainers
Question
error_outline
This textbook solution is under construction.
Students have asked these similar questions
Beginning in cell f4, enter a formula using IFS function to calculate the commission rate based on the following table
if annual sales are
>=225,000
>=175,000
>=100,000
<100,000
then commission rate is:
6%4%2%0%
Write valid C expression
1. Semiannual Interest=600/10%
2.Commission = (sales X 10/100) * 25/100
3. Convert amount in peso to euro.
(d) Write a formula in cell I24 to compute the discount amount on the server. Discount Amount = Percent Discount * Rate per hour. Copy the formula to I25 to I41.
(e) Write a formula in cell J24 to compute the rate per hour after the discount. Rate per hour after discount = Rate per hour - Discount Amount. Copy the formula from J25 to J41.
(f) Write a formula in cell K24 to compute the Total cost for the given server. Total Cost = Rate per hour after discount * # of hours Rented. Copy the formula from K25 to K41.
Screenshots attached below
use them to find formula thanks
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.Similar questions
- (d) Write a formula in cell I24 to compute the discount amount on the server. Discount Amount = Percent Discount * Rate per hour. Copy the formula to I25 to I41. (e) Write a formula in cell J24 to compute the rate per hour after the discount. Rate per hour after discount = Rate per hour - Discount Amount. Copy the formula from J25 to J41.arrow_forward(c) Compute the percent decline or increase in the mobile website visitors, write a formula in cell E26 and copy to cell E27. (d) In cell F26, Use the IF Function to create a formula to print "Yes" if there is cannibalization; else, the formula should print "No". Copy the formula to cell F27.Hint: If the percent increase is negative then there is cannibalization, else there is no cannibalization. Screenshot is attached below thx!!arrow_forwardIn C++, Also don’t forget to covert term and rate to month before calculating the monthly payment.arrow_forward
- Use python please. Include bounds and risk. You are the manager of a £100 million portfolio, and you have 6 investment options: - First Mortgages: return 9% and risk score 3- Second Mortgages: return 12% and risk score 6- Personal Loans: return 15% and risk score 8- Commercial Loans: return 8% and risk score 2- Government Securities: return 6% and risk score 1- Saving Account: return 3% and risk score 0 The current regulation requires that the amount allocated in second mortgages and personal loans (combined) should not exceed the amount allocated in first mortages. Given this information: a) Ignoring the risk involved in the different investment options, what is the profit maximizing allocation of resources? What are the expected profits? b) Now, you have to consider the risk associated with the investments. The average risk of your portfolio cannot exceed 5. What is the profit maximizing allocation of resources? What are the expected profits? The average risk is computed as…arrow_forwardPS:Please type not write on paper 7) Simplify the following Boolean functions correctly:arrow_forwardIf you deposit 25 000 which yields returns of 5000 at the end of each of the first 6 years then establish the mathematical equation to calculate the rate of return, r, from this investment. can use MATLAB (or any other programming language) and calculate the value of r; attach the code and results from this code.arrow_forward
- (b) Using IF function, write a formula in cell range D24 to display your recommendation. Hint: IF the Weighted Score of VDI is more than DaaS, then VDI should be recommended, else DaaS should be recommended. Thanks screenshot attached thanks thankzarrow_forward(i) Using the IF function, write a formula in cell L24 to determine if the number of hours rented for the given server is more than the average. Copy the formula from K25 to K41. (j) Using the IF function, write a formula in cell M24 to determine if the number of hours rented for the given server is more than the average. Copy the formula to M25 to M41. Screenshots attached below thank you!arrow_forwardWhich of the given statement satisfies this condition: Calculate the remainder after the variable product is divided by divisor and assign the result to product. a. product % divisor == 0;b.product =% divisor:c. None of the aboved. product%= divisor:arrow_forward
arrow_back_ios
arrow_forward_ios
Recommended textbooks for you
- Np Ms Office 365/Excel 2016 I NtermedComputer ScienceISBN:9781337508841Author:CareyPublisher:Cengage
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:9781337508841
Author:Carey
Publisher:Cengage