Complete the following table Inputs LCAT Level Location Clearance Start Month Survey Wage Rates Hours Analyst Journeyman

Fantastic news! We've Found the answer you've been seeking!

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	Boston	Top Secret	FEB	$ 50.00	1500
Analyst	Junior	Boston	Secret	JUL	$ 30.00	2000
Analyst	Junior	Boston	Top Secret	APR	$ 35.00	1000
Analyst	Senior	Boston	Secret	MAY	$ 65.00	500
Analyst	Senior	Boston	Top Secret	JUN	$ 62.00	1500
Engineer	Journeyman	Boston	Secret	AUG	$ 52.00	2000
Engineer	Journeyman	Boston	Top Secret	SEP	$ 57.00	1000
Engineer	Junior	Boston	Secret	JAN	$ 40.00	500
Engineer	Junior	Boston	Top Secret	OCT	$ 40.00	1500
Engineer	Senior	Boston	Secret	JUN	$ 70.00	2000
Engineer	Senior	Boston	Top Secret	NOV	$ 75.00	1000
Analyst	Journeyman	Washington	Secret	JAN	$ 50.00	500
Analyst	Journeyman	Washington	Top Secret	FEB	$ 55.00	1500
Analyst	Junior	Washington	Secret	MAR	$ 32.00	2000
Analyst	Junior	Washington	Top Secret	APR	$ 37.00	1000
Analyst	Senior	Washington	Secret	DEC	$ 67.00	500
Analyst	Senior	Washington	Top Secret	JUN	$ 70.00	1500
Engineer	Journeyman	Washington	Secret	JUL	$ 60.00	2000
Engineer	Journeyman	Washington	Top Secret	AUG	$ 60.00	1000
Engineer	Junior	Washington	Secret	SEP	$ 45.00	500
Engineer	Junior	Washington	Top Secret	OCT	$ 42.00	1500
Engineer	Senior	Washington	Secret	NOV	$ 72.00	2000
Engineer	Senior	Washington	Top Secret	OCT	$ 77.00	1000

Outputs 1

	LCAT	Level	Location	Clearance	Start Month	Survey Wage Rates	Hours
INDEX MATCH
					DEC
SUMIFS
	Analyst	Junior	Boston
	Analyst	Junior	Washington
	Analyst	Journeyman	Boston
	Analyst	Journeyman	Washington
	Analyst	Senior	Boston
	Analyst	Senior	Washington
Total Analyst Hours							-

Outputs 2

						Use AVERAGEIFS for Lookup
	LCAT	Level	Location	Clearance	Start Month	Survey Wage Rates	Hours
	Analyst	Junior	Boston	Secret
	Analyst	Junior	Boston	Top Secret
	Analyst	Junior	Washington	Secret
	Analyst	Junior	Washington	Top Secret
	Engineer	Junior	Boston	Secret
	Engineer	Junior	Boston	Top Secret
	Engineer	Junior	Washington	Secret
	Engineer	Junior	Washington	Top Secret
	Analyst	Journeyman	Boston	Secret
	Analyst	Journeyman	Boston	Top Secret
	Analyst	Journeyman	Washington	Secret
	Analyst	Journeyman	Washington	Top Secret
	Engineer	Journeyman	Boston	Secret
	Engineer	Journeyman	Boston	Top Secret
	Engineer	Journeyman	Washington	Secret
	Engineer	Journeyman	Washington	Top Secret
	Analyst	Senior	Boston	Secret
	Analyst	Senior	Boston	Top Secret
	Analyst	Senior	Washington	Secret
	Analyst	Senior	Washington	Top Secret
	Engineer	Senior	Boston	Secret
	Engineer	Senior	Boston	Top Secret
	Engineer	Senior	Washington	Secret
	Engineer	Senior	Washington	Top Secret

Related Book For answer-question

answer-question

Accounting

Accounting

ISBN: 978-0324662962

23rd Edition

Authors: Jonathan E. Duchac, James M. Reeve, Carl S. Warren

See More Books

Posted Date: Aug 06, 2021 03:48 AM

See More Questions

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...
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...
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...
What have researchers found about the use of job costing to record the cost of handproducing a bound book?
Do you think employers must choose between agreeable employees and top performers? Why or why not?
Estimate the value of y= Cp/Cv for carbon dioxide. Do this calculation with and without the vibrational contribution to the energy. Which is closer to the expected experimental value at 25C?
Journal entries for both buyer and seller periodic inventory system Non- GST version (a) Prepare general journal entries to record the following transactions (i) for Esther Ltd and (ii) for Barton...
Landmark Industries uses a cash payments journal. Prepare a cash payments journal using the same format and account titles as illustrated in the chapter. Record the following payments for merchandise...
How will the Information Assurance program benefit you in the future?
You are a recent MBA graduate with a specialty in data analytics. This has led to an excellent new career, as it complements your undergraduate business degree and CPA designation. Your new position...
PROBLEM#1 Funeral expenses P150,000 Judicial expenses 500,000 Medical expenses 400,000 Claims against the estate 200,000 Claims against insolvent persons 40,000 Taxes 25,000 Losses 60,000 Mortgage or...
General, Inc. has prepared the following direct materials purchases budget: Budgeted DM Purchases Month June July August September October $69,000 78,500 78,100 76,000 78,200 All purchases are paid...
An organization may be able to enhance service delivery efficiency and reduce administrative expenses by streamlining internal processes and removing bottlenecks. Would you say that your value stream...
Ann earns $6,900 per month as a gym teacher in California. Her state, local, and federal taxes represent 53% of her monthly gross income. What amount does Ann take home after taxes are deducted from...
To reduce an anticipated large number of applicants for a graphic designer position, a senior recruiter adds proficiency in the graphics design software she remembers learning about when she was in...
Discuss and analyze the effectiveness of the "The Barbershop Girls of India" campaign using the 6M framework for marketing communications, with citations?
Chapter 3 Homework i 10 points 2 Roxford Plastics manufactures and sells model airplane kits for hobbyists for a price of $14. The fixed costs amount to $171,000 per year, of which $106,000 is...
In your readings, there were many examples given for nurturing close family relationships in this ever-evolving technological society we live in Based upon your readings and research describe three...
Connect Lines Co. incurred the following costs related to trucks and vans used in operating its delivery service: 1. Replaced a trucks suspension system with a new suspension system that allows for...
What is the primary purpose of a stock split?
A company manufactures various sized plastic bottles for its medicinal product. The manufacturing cost for small bottles is $52 per unit (1,000 bottles), including fixed costs of $15 per unit. A...
You are provided with the worksheet for Norman Pty Ltd for the year ended 30 June 2019. The adjustments have already been made and the worksheet begins with the adjusted trial balance. Assume all...
The unadjusted trial balance of Innovative Computers Pty Ltd on 30 June 2019 is presented below. The following additional information is available. 1. The inventories as of 30 June 2019 were as...
Basic Chemicals Ltd produces a highly flammable chemical product. The company experienced a flood on 1 April 2019 that destroyed its entire work in process inventory but did not affect the raw...