a. Insert a function in cellE5 to display the software cost for the first vendor, based on the Adjustment Code attached to each vendor and the table beginning on row 25. (Hint: you must multiply the percent value obtained from the table times the Initial Fee) (6 Points)
b. Insert a function in cell F5 to display the consulting cost for the first vendor, based on the Adjustment Code attached to each vendor and the table beginning on row 25. (Hint: you must multiply the percent value obtained from the table times the Initial Fee) (6 Points)
c. Insert a function in cellG5 to display the system compatibility cost for the first vendor, based on the Adjustment Code attached to each vendor and the table beginning on row 25. (5 Points)
d.Insert a function in cell H5 to calculate Total Vendor Cost for the first vendor. If the vendor needs a system compatibility expense, the total cost should include that column (System Compatibility Cost) amount along with their Initial Fee, Software Costs and Consulting Costs. If the vendor does not need a system compatibility expense then do not include that column but do include Initial Fee, Software Costs and Consulting Costs. (10 Points)
Answer a:
VLOOKUP($B5,$A$25:$D$30,2,0)*$D5
answer b:
VLOOKUP($B5,$A$25:$D30,3,0)*$D5
Answer c:
VLOOKUP($B5,$A$25:$D$30,4,0)
a. Insert a function in cellE5 to display the software cost for the first vendor, based...
questions 11-16 please!!!!
10 10 Insert the function in cell H5 to calculate the first customer's monthly payment, using appropriate relative and absolute cell references. Ensure the result is a positive number. Copy the formula down to complete column H. tior 11 00 8 Insert a function in cell H14 to calculate the total of all monthly payments in column Hand apply Currency Number Format to column H. 12 6 Insert a function in cell H18 to calculate the total...
spreadsheet and data base managment
File Edit Insert Table Format Arrange View Share Window Help Target's Monthly Stock Prices T - Chart Text Shape Media 125 zoom Insert Table Questions Data Finish the following technical steps in the EXCEL workboek and upload your file for grading 1. Add a new worksheet in your EXCEL workbook, rename this worksheet as Documentation and then input your full name in the Al cell, and input the test date in the A2 cell (10...
I need help with certain questions. Please.
18. 4 points
For each Rental, list the Rental ID,
Rental date, customer ID, customer first name, customer last name,
and count of disks rented; sort by Rental ID. Show the Rental date
formatted as ‘mm-dd-yyyy.’ Hint: use a GROUP BY clause.
19. 4 points
List the disk ID, title name, rating,
format description, and fee amount for all copies rented in Rental
3; sort by disk ID. Show the fee amount formatted...
What happens when you try to compile and run the following code? String query = "INSERT INTO Invoices (InvoiceDate InvoiceTotal) " + "VALUES ('2/10/01', '443.55')"; Statement statement = connection.createStatement(); statement.executeUpdate(query); a. A SQLException is thrown at runtime because the executeUpdate method can’t accept a String object. b. A SQLException is thrown at runtime because the SQL statement is coded incorrectly. c. An error occurs at compile time because the SQL statement is coded incorrectly. d. This code compiles and...
In cell B25, calculate fixed costs by use a nested IF function
to display the Low Risk Administrative Cost if the value in cell
B18 is Low, to display the High Risk Administrative Cost if the
value in cell B18 is High or display the Standard Risk
Administrative Cost. Format as Accounting with 0 decimal
places.
Bean Healthcare Beantacob - Excel Pile fx Home Insert Page Layout Formulas Data Review View Help 2 A @ @ Auto Sum Recently Financial...
To estimate the parameters of this cost function, the accountant first studied the behavior of last month's costs, when the company spent 318 service hours repairing 45 computer systems. Here are the results of her analysis: Cost Item Fixed Cost Variable Cost Utilities $229 $149 Office rent $3,819 $0 Administration $3,249 $165 Supplies $0 $3,437 Training $350 $308 Total $7,647 $4,059 Concerned that last month may not have been a typical month and her breakdown of fixed and variable costs...
Based on the case study below, fill out the Excel file and MUST
show math appropriate calculations in the right column.
CASE STUDY DATA
Larson Property Management Company
Supplemental Case Material
Building a Business Case
The system that Larson has chosen to support their recruiting
process costs $15,000 each quarter for use of the application.
The initial implementation costs to the vendor who will help
with project management is $50,000
Maintenance fees are included in the quarterly licensing fee,
but...
Daisy Consuling is going to manufacture billing software. During its first month of manufacturing, Daisy incurred the following manufacturing costs 囲(Click the icon to view the manufacturing costs.) Data Table Prepare a schedule of cost of goods manufactured for Daisy for the month ended January 31, 2018. (Co Daisy Consulting Schedule of Cost of Goods Manufactured Month Ended January 31, 2018 Beginning Ending Inventories Raw Materials Work-in-Process Finished Goods Other information Raw materials purchases Plan Sales salaries expense Delivery expense...
Use case diagram for Mail Order System Requirements(draw by use case diagram) This software system is developed to support mail order business operations. In particular software shall: - Keep track of sales (including orders, payments, and shipments). For each order a record shall be kept identifying the customer, the ZIP code, the salesperson, item ordered, the quantity, and amount due. - Record shall be kept for each customer who made a purchase in the past year. Such record shall include...
I have completed these but wanting to compare such as Question 14. Is the word "Total" added in the row or written as "Average" or "Total Average" Also Question 8 is not clear what fill color. Is it supposed to stay as blue and just select gradient fill? Very unclear questions. Thank you. Question: EX16_XL_VOL1_GRADER_CAP_AS – Travel Vacations 1.4 ( Excel, Chapter 4) Project Description: 1 Start Excel. Download and open the file named exploring_ecap_grader_a1.xlsx. 2 On the DC worksheet,...