Question: Complete the following table Inputs LCAT Level Location Clearance Start Month Survey Wage Rates Hours Analyst Journeyman Boston Secret MAR $ 47.00 500 Analyst Journeyman

Complete the following table

Inputs
LCATLevelLocationClearanceStart Month Survey Wage Rates Hours
AnalystJourneymanBostonSecretMAR $ 47.00500
AnalystJourneymanBostonTop SecretFEB $ 50.001500
AnalystJuniorBostonSecretJUL $ 30.002000
AnalystJuniorBostonTop SecretAPR $ 35.001000
AnalystSeniorBostonSecretMAY $ 65.00500
AnalystSeniorBostonTop SecretJUN $ 62.001500
EngineerJourneymanBostonSecretAUG $ 52.002000
EngineerJourneymanBostonTop SecretSEP $ 57.001000
EngineerJuniorBostonSecretJAN $ 40.00500
EngineerJuniorBostonTop SecretOCT $ 40.001500
EngineerSeniorBostonSecretJUN $ 70.002000
EngineerSeniorBostonTop SecretNOV $ 75.001000
AnalystJourneymanWashingtonSecretJAN $ 50.00500
AnalystJourneymanWashingtonTop SecretFEB $ 55.001500
AnalystJuniorWashingtonSecretMAR $ 32.002000
AnalystJuniorWashingtonTop SecretAPR $ 37.001000
AnalystSeniorWashingtonSecretDEC $ 67.00500
AnalystSeniorWashingtonTop SecretJUN $ 70.001500
EngineerJourneymanWashingtonSecretJUL $ 60.002000
EngineerJourneymanWashingtonTop SecretAUG $ 60.001000
EngineerJuniorWashingtonSecretSEP $ 45.00500
EngineerJuniorWashingtonTop SecretOCT $ 42.001500
EngineerSeniorWashingtonSecretNOV $ 72.002000
EngineerSeniorWashingtonTop SecretOCT $ 77.001000


Outputs 1
LCATLevelLocationClearanceStart MonthSurvey Wage Rates Hours
INDEX MATCH
DEC
SUMIFS
AnalystJuniorBoston
AnalystJuniorWashington
AnalystJourneymanBoston
AnalystJourneymanWashington
AnalystSeniorBoston
AnalystSeniorWashington
Total Analyst Hours -


Outputs 2
Use AVERAGEIFS for Lookup
LCATLevelLocationClearanceStart Month Survey Wage Rates Hours
AnalystJuniorBostonSecret
AnalystJuniorBostonTop Secret
AnalystJuniorWashingtonSecret
AnalystJuniorWashingtonTop Secret
EngineerJuniorBostonSecret
EngineerJuniorBostonTop Secret
EngineerJuniorWashingtonSecret
EngineerJuniorWashingtonTop Secret
AnalystJourneymanBostonSecret
AnalystJourneymanBostonTop Secret
AnalystJourneymanWashingtonSecret
AnalystJourneymanWashingtonTop Secret
EngineerJourneymanBostonSecret
EngineerJourneymanBostonTop Secret
EngineerJourneymanWashingtonSecret
EngineerJourneymanWashingtonTop Secret
AnalystSeniorBostonSecret
AnalystSeniorBostonTop Secret
AnalystSeniorWashingtonSecret
AnalystSeniorWashingtonTop Secret
EngineerSeniorBostonSecret
EngineerSeniorBostonTop Secret
EngineerSeniorWashingtonSecret
EngineerSeniorWashingtonTop Secret

Step by Step Solution

★★★★★

3.33 Rating (156 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock

Tab outputs 1 INDEX and MATCH Cell G3 Formula INDEXInputsA1G25MATCHF3InputsE1E2506 It is important to write before starting any formula The name of the function is INDEX Put brackets Then choose array ... View full answer

blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Document Format (1 attachment)

Excel file Icon

610a87a7b6db4_83810.xlsx

300 KBs Excel File

Students Have Also Explored These Related Civil Engineering Questions!

Q:

Complete the following table by indicating for (a) through (g) whether the proper answer is debit orcredit. Normal Balance Account Increase debit Decrease ( credit (a) Purchases Discounts Purchases...

Q:

Complete the following table by indicating for (a) through (g) whether the proper answer is debit orcredit. Normal Balance (b) credit (et Account Purchases Purchases Discounts Purchases Returns and...

Q:

Complete the following table by indicating for (a) through (g) whether the proper answer is debit orcredit. Normal Balance Account Increase Decrease Purchases Purchases Discounts Purchases Returns...

Q:

A hydraulically operated multidisk plate clutch has an effective disk outer diameter of 6.5 in and an inner diameter of 4 in. The coefficient of friction is 0.24, and the limiting pressure is 120...

Q:

The position of a pine wood derby car was observed at various times; the results are summarized in the following table. Find the average velocity of the car for (a) The first second, (b) The last 3...

Q:

An e-mail message can travel through one of two server routes. The probability of transmission error in each of the servers and the proportion of messages that travel each route are shown in the...

Q:

When different weights are hung on a spring, the spring stretches to different lengths as shown in the following table. (a) Make a graph of the applied force versus the extension of the spring. By...

Q:

Mareska Inc. is considering two alternatives to finance its construction of a new $2 million plant. (a) Issuance of 200,000 shares of common stock at the market price of $10 per share. (b) Issuance...

Q:

The data in the following table represent measurements of the masses and dimensions of solid cylinders of aluminum, copper, brass, tin, and iron. Use these data to calculate the densities of these...

Q:

At point A in a Carnot cycle, 2.34 mol of a monatomic ideal gas has a pressure of 1 400 kPa, a volume of 10.0 L, and a temperature of 720 K. It expands isothermally to point B, and then expands...

Q:

How would Vizio use net marketing contribution at the market level to increase its knowledge of the U.S. flat-panel television market?

Q:

Financial statements all have a goal. The cash flow statement does as well. Requirement 1. Describe how the statement of cash flows helps investors and creditors perform each of the following...

Q:

Convert the following integral to an equivalent polar form, but do not evaluate: 2 4 0 4 x - x 3 2 ( x 2 y 2 ) - 1 2 d y d x Please provide the integrand and the bounds for the equivalent polar...

Q:

Lyman Nurseries purchased seeds costing $25,000 with terms of 3/15 net 30 EOM on January 12. How much will the firm pay if it takes the cash discount? What is the approximate cost of giving up the...

Q:

Report Refer to the information for Alfombra Inc. above. The owner of Alfombra insisted on a formal report that provided all the details of the weighted average method. In the manufacturing process,...

Q:

The following information is for Polo Limited for 2017: Net income for the year ...................................................... $2,300,000 8% convertible bonds issued at par ($1,000 per bond),...

Q:

As auditor for Checkem & Associates, you have been assigned to review Tao Corporation's calculation of earnings per share for the current year. The controller, Mac Taylor, has supplied you with the...

Q:

Ottey Corporation issued $4 million of 10-year, 7% callable convertible subordinated debentures on January 2, 2017. The debentures have a face value of $1,000, with interest payable annually. The...

Q:

This is what I got for cart mass I'm not sure about measured period id give a value for k. Mg AX = 12cm = .120m Ax M=. 150kg K= (.130kg . 9.8 my/s*) /120 m K= 12.25 N/m

Q:

1. Definition of economic costs Bob lives in San Diego and operates a small company selling bikes. On average, he receives $778,000 per year from selling bikes. Out of this revenue from sales, he...

Q:

Special-Order Offer Relevant Analysis noting that, "This is a great way for us to make use of one of our most premier properties!". The annual costs incurred by Superior to fulfill 1,000,000 occupied...

Q:

"TC3 Making the Connection: Rel I'I egra IVE XerCISE Relevant Analysis, Cost-Based Pricing, Cost Behavior, and Net Present Value Analysis for Superior Stay Resorts SpeciahOrder Offer Relevant...

Q:

"TC3 Making the Connection: Rel I'I egra IVE XerCISE Relevant Analysis, Cost-Based Pricing, Cost Behavior, and Net Present Value Analysis for Superior Stay Resorts SpeciahOrder Offer Relevant...

Q:

"TC3 Making the Connection: Rel I'I egra IVE XerCISE Relevant Analysis, Cost-Based Pricing, Cost Behavior, and Net Present Value Analysis for Superior Stay Resorts SpeciahOrder Offer Relevant...

Q:

Special-Order Relevant Analysis Superior Stay Resorts provides luxurious hotel accommodations to its high-end customer base. Superior measures business volume by the total number of occupied guest...