CMR282 Miami Module 4 EL2 Excelsheet Assignments Help To Do: Assessments 1, 2, 3, and 4 CMR 282 Module 4 textbook assignments Submit the following files

CMR282 Miami Module 4 EL2 Excelsheet Assignments Help To Do:

Assessments 1, 2, 3, and 4

Don't use plagiarized sources. Get Your Custom Essay on
CMR282 Miami Module 4 EL2 Excelsheet Assignments Help To Do: Assessments 1, 2, 3, and 4 CMR 282 Module 4 textbook assignments Submit the following files
Just from $13/Page
Order Essay

CMR 282 Module 4 textbook assignments

Submit the following files:

(1) EL2-C2-A2-RSROctLabor-2.xlsx
(2) EL2-C2-A3-PrecisionWarehouse.xlsx
(3) EL2-C2-A4-ACPremiumReview.xlsx

I already uploaded the files needed. All the instructions are in the word file. Make sure this assignment is do by yourself, not copy from others or Internet. We have turnitin to check if it was copied. CMR 282
Chapter 2 – Module 4
Assessment 1
Create Range Names and Use the Lookup Function
1.
2.
3.
4.
5.
Open RSROctLabor.xlsx.
Save the workbook with the name EL2-C2-A1-RSROctLabor
Modify the range named LaborCost to include cell F22.
Change the range name for the range named Hr to Hours.
In cell E7, create a VLOOKUP formula to return the correct hourly rate based on the technician
code in cell D7. Use the range name RateChart within the formula to reference the hourly rate
chart. Make sure Excel will return values for exact matches only.
6. Create or copy the following formulas:
a. Copy the VLOOKUP formula in cell E7 and paste it into the range E8:E22.
b. In cell F7, multiply the values in the range named Hours by the hourly rate in cell E7. Add
the ROUND function to ensure that all labor costs are rounded to the nearest cent (two
decimal places).
c. Copy the formula in cell F7 and paste it into the range F8:F22.
d. Create the formula in cell F23 to sum the values in the column.
7. Preview and then print the worksheet.
8. Save and then close EL2-C2-A1-RSROctLabor
Assignment 2
Use Conditional Statistical and Math Functions
Note: For all the functions in Assessment 2 except those in Step 3, use range names in the formulas to
reference sources.
1. Open EL2-C2-A1-RSROctLabor
2. Save the workbook with the name EL2-C2-A2-RSROctLabor
3. Using the range named TechCode, create COUNTIF formulas in these cells:
I9: Count the number of calls made by technician 1.
I10: Count the number of calls made by technician 2.
I11: Count the number of calls made by technician 3.
4. In cell I14, create a COUNTIFS formula to count the number of calls made by technician 3 for
which the hours logged were greater than three. Use range names (TechCode and Hours) where
possible.
5. Using the ranges named TechCode and LaborCost, create SUMIF formulas in these cells
indicated:
J9: Add the labor cost for calls made by technician 1.
J10: Add the labor cost for calls made by technician 2.
J11: Add the labor cost for calls made by technician 3.
6. Using the ranges named TechCode, LaborCost, and Hours, create a SUMIFS formula in cell J14 to
add the labor cost for calls made by technician 3 (criteria 1) in which the hours logged were
greater than three (criteria 2).
7. Using the named ranges TechCode and LaborCost, create AVERAGEIF formulas in these cells:
J18: Average the labor cost for calls made by technician 1.
J19: Average the labor cost for calls made by technician 2.
J20: Average the labor cost for calls made by technician 3.
8. Ensure that the Comma format has been applied to the cells or ranges:
J9:J11
J14
J18:J20
9. Save, print, and then close EL2-C2-A2-RSROctLabor
Assessment 3
Use the PMT and PPMT Financial Functions
1. Open PrecisionWarehouse.xlsx.
2. Save the workbook with the name EL2-C2-A3-PrecisionWarehouse
3. Using cell references, create a PMT formula in cell D8 to calculate the monthly loan payment for
a proposed loan from NewVentures Capital Inc.
a. Note: The PMT function uses the same arguments as the PPMT function with the
exception, that there is no Per criterion. Remember to divide the rate by 12 and multiply
the nper by 12 to use monthly units.
4. Using cell references, create PPMT formulas to find the principal portion of the loan payment for
the first loan payment in cell D10 and the last loan payment in cell D11.
5. In cell D13, create a formula to calculate the total cost of the loan by multiplying the monthly
loan payment times the amortization period in years times 12.
6. Print the worksheet.
7. Save and then close EL2-C2-A3-PrecisionWarehouse
Assessment 4
Use Logical Functions
1. Open ACPremiumReview.xlsx.
2. Save the workbook with the name EL2-C2-A4-ACPremiumReview. The following range names
have been created:
B4:B23 Claims
C4:C23 AtFault
D4:D23 Rating
E4:E23 Deductible
3. Using named ranges, create a formula in cell G4 to display Yes if the number of at fault claims is
greater than one and the current rating is greater than two. Both conditions must test true to
display Yes; otherwise, display No in the cell. Hint: Use a nested IF and AND formula.
4. Using named ranges, create a formula in cell H4 to display Yes in the cell if either the number of
claims is greater than two or the current deductible is less than $1,000.00; otherwise, display No
in the cell. Hint: Use a nested IF and OR formula.
5. Center the results in cells G4 and H4 and then copy and paste the formulas into the ranges
G5:G23 and H5:H23, respectively. Deselect the range after copying.
6. Save, print, and then close EL2-C2-A4-ACPremiumReview.
Hourly Rate Chart
RSR Computer Services
Description
Code
Rate
Labor Cost Report
Technician 1
Technician 2
Technician 3
1
2
3
$ 13.50
$ 17.00
$ 20.75
In-Home Computer Service Billings
Date
Work Order
Number
10/1/2018 IH-90010
10/2/2018 IH-90011
10/4/2018 IH-90012
10/8/2018 IH-90013
10/8/2018 IH-90014
10/9/2018 IH-90015
10/10/2018 IH-90016
10/12/2018 IH-90017
10/13/2018 IH-90018
10/16/2018 IH-90019
10/20/2018 IH-90020
10/22/2018 IH-90021
10/23/2018 IH-90022
10/26/2018 IH-90023
10/29/2018 IH-90024
10/31/2018 IH-90025
TOTAL LABOR COST
Hours
Logged
2.25
3.75
1.50
2.75
3.00
4.25
3.75
2.25
1.50
2.25
2.75
4.50
5.25
3.25
2.75
5.50
51.25
Technician
Code
1
3
1
1
3
2
2
1
2
1
3
1
1
3
3
2
Hourly
Rate
WO Labor
Cost
Labor Cost Statistics
By Technician Code
Technician 1
Technician 2
Technician 3
Calls
Billed
Total
Labor
Technician 3 calls over 3 hours
Technician 3
By Technician Code
Technician 1
Technician 2
Technician 3
Average
Labor
AllClaims Insurance Brokers
Insurance Policy Premium Review
Policy ID
Number of
Claims
At Fault
Claims
Current
Rating
6388569
4236512
6974583
2563845
2215473
6952384
4668457
8512475
6984563
4856972
6845962
8457326
4968532
5741356
2486597
7134586
4234875
3894124
6845216
8663418
3
2
1
0
0
2
4
3
2
2
1
1
1
0
0
0
3
0
2
0
1
1
0
0
0
1
2
3
1
1
1
1
0
0
0
0
2
3
1
0
2
2
3
4
2
4
3
5
5
4
3
2
2
1
3
2
4
4
2
1
Deductible
500.00
750.00
1,000.00
1,000.00
250.00
500.00
1,000.00
2,000.00
1,000.00
2,500.00
500.00
1,000.00
250.00
250.00
750.00
500.00
1,000.00
2,000.00
250.00
500.00
Claims
Cost
Estimate
16,300.00
6,524.00
10,500.00
7,275.00
18,562.00
21,475.00
10,500.00
16,741.00
6,475.00
8,752.00
3,150.00
14,755.00
19,855.00

Increase
Premium?
Increase
Deductible?
Precision Design and Packaging
Proposed New Warehouse Construction
Financing through NewVentures Capital Inc.
Quoted interest rate per annum
Amortization period in years
Principal amount to be borrowed
Monthly loan payment
Principal portion of first loan payment
Principal portion of last loan payment
Total cost of loan
$
7.75%
18
1,750,000

Purchase answer to see full
attachment

Homework Market Pro
Calculate your paper price
Pages (550 words)
Approximate price: -

Our Unique Features

Custom Papers Means Custom Papers

This is what custom writing means to us: Your essay starts from scratch. Plagiarism is unacceptable. We demand the originality of our academic essay writers and they only deliver authentic and original papers. 100% guaranteed! If your final version is not as expected, we will revise it immediately.

Qualified and Experienced Essay Writers

Our team consists of carefully selected writers with in-depth expertise. Each writer in our team is selected based on their writing skills and experience. Each team member is able to provide plagiarism-free, authentic and high-quality content within a short turnaround time.

Free Unlimited Revisions

If you think we missed something, send your order for a free revision. You have 10 days to submit the order for review after you have received the final document. You can do this yourself after logging into your personal account or by contacting our support.

Prompt Delivery and 100% Assuarance

We understand you. Spending your hard earned money on a writing service is a big deal. It is a big investment and it is difficult to make the decision. That is why we support our claims with guarantees. We want you to be reassured as soon as you place your order. Here are our guarantees: Your deadlines are important to us. When ordering, please note that delivery will take place no later than the expiry date.

100% Originality & Confidentiality

Every paper we write for every order is 100% original. To support this, we would be happy to provide you with a plagiarism analysis report on request.We use several writing tools checks to ensure that all documents you receive are free from plagiarism. Our editors carefully review all quotations in the text. We also promise maximum confidentiality in all of our services.

24/7 Customer Support

We help students, business professionals and job seekers around the world in multiple time zones. We also understand that students often keep crazy schedules. No problem. We are there for you around the clock. If you need help at any time, please contact us. An agent is always available for you.

Try it now!

Calculate the price of your order

Total price:
$0.00

How it works?

Follow these simple steps to get your paper done

Place your order

Fill in the order form and provide all details of your assignment.

Proceed with the payment

Choose the payment system that suits you most.

Receive the final file

Once your paper is ready, we will email it to you.

Our Services

Our services are second to none. Every time you place an order, you get a personal and original paper of the highest quality.

Essays

Essay Writing Service

While a college paper is the most common order we receive, we want you to understand that we have college writers for virtually everything, including: High school and college essays Papers, book reviews, case studies, lab reports, tests All graduate level projects, including theses and dissertations Admissions and scholarship essays Resumes and CV’s Web content, copywriting, blogs, articles Business writing – reports, marketing material, white papers Research and data collection/analysis of any type.

Admissions

Any Kind of Essay Writing!

Whether you are a high school student struggling with writing five-paragraph essays, an undergraduate management student stressing over a research paper, or a graduate student in the middle of a thesis or dissertation, homeworkmarketpro.com has a writer for you. We can also provide admissions or scholarship essays, a resume or CV, as well as web content or articles. Writing an essay for college admission takes a certain kind of writer. They have to be knowledgeable about your subject and be able to grasp the purpose of the essay.

Reviews

Quality Check and Editing Support

Every paper is subject to a strict editorial and revision process. This is to ensure that your document is complete and accurate and that all of your instructions have been followed carefully including creating reference lists in the formats APA, Harvard, MLA, Chicago / Turabian.

Reviews

Prices and Discounts

We are happy to say that we offer some of the most competitive prices in this industry. Since many of our customers are students, job seekers and small entrepreneurs, we know that money is a problem. Therefore, you will find better prices with us compared to writing services of this calibre.