accounting Excel

timer Asked: Jun 28th, 2018
account_balance_wallet $10

Question description

I am finish the excel project but please check it and correction if you find any questions.

thank you

Office 2016 – myitlab:grader – Instructions Excel Project YO16_XL_CH03_GRADER_PS1_HW - Renovations 1.1 Project Description: Lesa Martin, a member of the support/coordination staff for the conference center at Painted Paradise Golf Resort and Spa, has created a worksheet to keep track of the renovations being made to the three rooms that are used for conferences and the two technology centers that are used for computer-based presentations and interactive sessions. The technology centers are equipped with workstations, are networked, and have Internet accessibility. This spreadsheet is simple and designed only for Lesa and her associates to keep a handle on the renovation progress and estimate the increase in capacity and revenue that might occur as a result of the renovations. Instructions: For the purpose of grading the project you are required to perform the following tasks: Step Instructions 1 Start Excel. Open the file named e02ch03_grader_hw_Renovations.xlsx. Save the file with the name e02ch03_grader_hw_Renovations_LastFirst, replacing LastFirst with your last and first name. 2 On the Renovations worksheet in cell G6, enter a formula using an absolute reference to determine the new capacity that the Musica Room will hold based on the capacity in cell F6 and the percentage in cell B13. Copy this formula to the range G7:G10. 3 Assign the named range IncreaseInRevenue to cell B14. Points Possible 0.000 8.000 6.000 4 In cell I6, enter a formula to determine the projected revenue for the Musica Room based on the revenue figure in cell H6 and the percentage in cell B14. Use the named range in cell B14 when entering this formula. Copy this formula to the range I7:I10. 8.000 5 In cell D6, enter the appropriate date function to determine the length in days of the expected renovation for the Musica Room. Copy this function to the range D7:D10. 12.000 6 In cell B15, enter the function to calculate the median length of renovations in days. Assign the named range MedianDays to the cell. 10.000 7 8 9 In cell J6, enter a logical function to display the word Under in the cell if the renovations are going to take fewer than or equal to the median number of days calculated in cell B15; otherwise, have the word Over display. Use the named range for B15 when entering this function. Copy this function to the range J7:J10. In cell B21, enter a function that will calculate the monthly payment for the loan amount in cell B18, based on the Annualized Rate in B19, and the number of years in the Term in cell B20. Display the monthly payment as a positive value. Assign the named range RoomClassification to A24:B27. Updated: 01/03/2017 1 15.000 15.000 6.000 Current_Instruction.docx Office 2016 – myitlab:grader – Instructions Step 10 11 12 Excel Project Points Possible Instructions In cell K6, using a VLOOKUP, create a function to determine the projected room classification based on the projected quarterly revenue after renovations in cell I6. Use the named range RoomClassification when entering this function. Copy this function to the range K7:K10. Add the File Name in the left footer of the Renovations sheet. 5.000 Save the workbook. Close the workbook and then exit Excel. Submit the workbook as directed. Total Points Updated: 01/03/2017 2 15.000 0.000 100.000 Current_Instruction.docx
Painted Paradise Golf Resort & Spa Banquet Room Renovations Created by Lesa Martin The Muisca Room The Eldorado Room The Pueblo Room Technology room 1 Technology room 2 Renovations Length of Renovations Started Renovations Completed in Days 1/6/2018 5/10/2018 124 3/15/2018 7/15/2018 122 9/10/2018 11/30/2018 81 8/1/2018 10/1/2018 61 2/15/2018 4/15/2018 59 Increase in Capacity Increase in Revenue Median Renovation Length in Days Loan Information Amount of Loan Annualized Rate Term (in Years) Monthly Payment Room Classification 0 Bronze 250,000 Silver 500,000 Gold 750,000 Platinum 30% 40% 81 125,000 6% 5 7,163 Original Capacity 500 100 25 45 25 New Capacity 650 130 33 59 33 Quarterly Revenue Prior to Renovations 290,000 575,000 225,000 150,000 75,000 Projected Quarterly Revenue after Renovations 406,000 805,000 315,000 210,000 105,000 Renovation Projected Projection Room Schedule Classification Over #NAME? Over #NAME? Under #NAME? Under #NAME? Under Bronze

Tutor Answer

School: UIUC


flag Report DMCA

Awesome! Exactly what I wanted.

Similar Questions
Hot Questions
Related Tags

Brown University

1271 Tutors

California Institute of Technology

2131 Tutors

Carnegie Mellon University

982 Tutors

Columbia University

1256 Tutors

Dartmouth University

2113 Tutors

Emory University

2279 Tutors

Harvard University

599 Tutors

Massachusetts Institute of Technology

2319 Tutors

New York University

1645 Tutors

Notre Dam University

1911 Tutors

Oklahoma University

2122 Tutors

Pennsylvania State University

932 Tutors

Princeton University

1211 Tutors

Stanford University

983 Tutors

University of California

1282 Tutors

Oxford University

123 Tutors

Yale University

2325 Tutors