Loading...

Messages

Proposals

Stuck in your homework and missing deadline? Get urgent help in $10/Page with 24 hours deadline

Get Urgent Writing Help In Your Essays, Assignments, Homeworks, Dissertation, Thesis Or Coursework & Achieve A+ Grades.

Privacy Guaranteed - 100% Plagiarism Free Writing - Free Turnitin Report - Professional And Experienced Writers - 24/7 Online Support

Excel 2019 In Practice - Ch 9 Independent Project 9-5

17/10/2020 Client: mark2106 Deadline: 24 Hours

 These instructions are compatible with both Microsoft Windows and Mac operating systems.


At Placer Hills Real Estate, commission is split with other agencies based on price groups. You create a one-variable data table to display results for various split rates. Additionally, you create scenarios for selling price and commission and create a histogram about sales.


[Student Learning Outcomes 9.1, 9.3, 9.4, 9.6]


File Needed: PlacerHills-09.xlsx (Available from the Start File link.)


Completed Project File Name: [your name]-PlacerHills-09.xlsx


Skills Covered in This Project



  • Build a one-variable data table.

  • Use Solver.

  • Create and manage scenarios.

  • Create a histogram with a chart.



  1. Open the PlacerHills-09 start file. The file will be renamed automatically to include your name. Change the project file name if directed to do so by your instructor

  2. Enable the content security warning.

  3. Review formulas.

    1. Select cell C14 on the Calculator worksheet. The total commission is calculated by multiplying the selling price by the commission rate.

    2. Select cell C15. The IFS function checks the selling price (C12) to determine the split percentage (column D) based on the price group.

    3. Select cell C16. The IFS function checks the selling price (C12) to determine the administrative fee percentage (column E) and multiplies that percentage by the value in cell C15 to calculate the fee in dollars.

    4. Select cell C17. The net commission is calculated by subtracting the fees from the PHRE amount.



  4. Build one-variable data tables.

    1. Select cell C20 and create a reference to cell C15.

    2. Select cell D20 and create a reference to cell C17. Both formulas depend on cell C12, the one variable.

    3. Use cell D8 as the column input for the data table (Figure 9-87). (You can use any percentage from column D because its value is replaced by the proposed rates in column B in the data table.)ImagesFigure 9-87 Data table setup for commission rates

    4. Decrease the decimal two times for all values in the data table.



  5. Name cell ranges.

    1. Click the Price Solver worksheet tab.

    2. Click cell C12 and name the range Selling_Price. You cannot use spaces in a range name.

    3. Name cell C14 as Total_Commission and cell C17 as PHRE_Commission.



  6. Install the Solver Add-in and the Analysis ToolPak.

  7. Use Solver to find target PHRE net commission amounts.

    1. Build a Solver problem with cell C17 as the objective cell. For the first solution, set the objective to a value of 50000 by changing cell C12. Use the GRG Nonlinear solving method. Save the results as a scenario named $50,000.

    2. Restore the original values and run another Solver problem to find a selling price for a PHRE commission of 75000. Save these results as a scenario named $75,000.

    3. Restore the original values and run a third Solver problem to find a selling price for a net commission of $100,000. Save these results as a scenario and restore the original values.



  8. Manage scenarios.

    1. Show the $50,000 scenario in the worksheet.

    2. Create a Scenario summary report for cells C12, C14, and C17.



  9. Create a histogram for recent sales.

    1. Click the Sales Forecast sheet tab and select cell G13.

    2. Create a bin range of 10 values starting at 350,000 with intervals of 50,000, ending at 800,000 in cell G22.

    3. Use the Analysis ToolPak to create a histogram for cells E5:E26. Do not check the Labels box and select the bin range in your worksheet.

    4. Select cell H3 for the Output Range and include a chart.

    5. Position and size the chart from cell K3 to cell V19.

    6. Edit the horizontal axis title to display Selling Price and edit the vertical axis title to Number of Sales.

    7. Edit the chart title to display Sales by Price Group.

    8. Select and delete the legend.

    9. Delete cells G13:G22 (Figure 9-88).ImagesFigure 9-88 Histogram and chart for sales data



  10. Save and close the workbook (Figure 9-89).

  11. Upload and save your project file.

  12. Submit project for grading.

Homework is Completed By:

Writer Writer Name Amount Client Comments & Rating
Instant Homework Helper

ONLINE

Instant Homework Helper

$36

She helped me in last minute in a very reasonable price. She is a lifesaver, I got A+ grade in my homework, I will surely hire her again for my next assignments, Thumbs Up!

Order & Get This Solution Within 3 Hours in $25/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 3 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

Order & Get This Solution Within 6 Hours in $20/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 6 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

Order & Get This Solution Within 12 Hours in $15/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 12 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

6 writers have sent their proposals to do this homework:

Pro Writer
Assignments Hut
Solution Provider
Finance Homework Help
Custom Coursework Service
Financial Hub
Writer Writer Name Offer Chat
Pro Writer

ONLINE

Pro Writer

Hello, I can assist you in every kind of writing. I am a professional academic/research writer and an MBA in business and finance. Please connect in chat session to further discuss the details.

$95 Chat With Writer
Assignments Hut

ONLINE

Assignments Hut

I am 100% sure that I will meet your expectations in writing the essay . I have written over 4000 high quality plagiarism free papers and deliver within stipulated deadlines. I am familiar with a number of citation styles among them MLA, APA, APSA, Oxford, Chicago, OSCOLA, Harvard and Turabian. I believe that I am the right candidate for this project, and I guarantee quality work. I have a wide knowledge in this subject and I believe this will come a long way in giving you quality work. Thank you in advance

$95 Chat With Writer
Solution Provider

ONLINE

Solution Provider

Hi.I have read your descriptions and i will provide you quality work.I am a Ph.D. writer with 5-6 years of experience. I have worked on several similar projects and can deliver quality works in a tight deadline. I am interested to hear more about the project and about the subject. If you award me the project I would be very glad to discuss this further and get started for you as soon as possible. Thanks You!

$95 Chat With Writer
Finance Homework Help

ONLINE

Finance Homework Help

I have a Master’s degree and experience of more than 5 years in this industry, I have worked on several similar projects of Research writing, Academic writing & Business writing and can deliver A+ quality writing even to Short Deadlines. I have successfully completed more than 2100+ projects on different websites for respective clients. I can generally write 10-15 pages daily. I am interested to hear more about the project and about the subject matter of the writing. I will deliver Premium quality work without Plagiarism at less price and time. Get quality work by awarding this project to me, I look forward to getting started for you as soon as possible. Thanks!

$95 Chat With Writer
Custom Coursework Service

ONLINE

Custom Coursework Service

Hey, Hope you are doing great :) I have read your project description. I am a high qualified writer. I will surely assist you in writing paper in which i will be explaining and analyzing the formulation and implementation of the strategy of Nestle. I will cover all the points which you have mentioned in your project details. I have a clear idea of what you are looking for. The work will be done according to your expectations. I will provide you Turnitin report as well to check the similarity. I am familiar with APA, MLA, Harvard, Chicago and Turabian referencing styles. I have more than 5 years’ experience in technical and academic writing. Please message me to discuss further details. I will be glad to assist you out.

$95 Chat With Writer
Financial Hub

ONLINE

Financial Hub

Hey, I have gone through your job posting and become very much interested in working with you.I can deliver professional content as per your requirements. I am a multi-skilled person with sound proficiency in the English language for being a native writer who worked on several similar projects of content writing and can deliver quality content to tight deadlines. I am available for both online and offline writing jobs with the promise of offering an incredibly responsive and supreme level of customer service. Thanks!

$95 Chat With Writer

Let our expert academic writers to help you in achieving a+ grades in your homework, assignment, quiz or exam.

Similar Homework Questions

Growth strategy of coca cola company - Air force esd phone number - Nib ambulance cover only - Case Brief - Kpiv and kpov template excel - Physics formula sheet nat 5 - Pathological Conditions in Older Adults - Leadership themes in the new testament - Critical review or analytical review realy - Three room dwelling nutshell solution - A stateful inspection firewall ________ - Electrical engineering - Caves arches stacks and stumps - Aami skilled drivers course - Caroma water wafer buttons - Week-15 - Aspects and impacts register - Output voltage of cfl bulb - Electrical meter box australia - Raging bull oscar winner crossword - How many g3p to make glucose - Ocean carriers case solution - Answer all questions that apply to the quantitative and/or qualitative study that you selected. Include a title page and article citation (APA format) on the title page. - Dicussion ( Management Concepts) Week 9 - Task - Intellectual interests - Flames and dangling wire date - Different types of logistics service providers - Chevron tco project kazakhstan - Gunned down the power of the nra worksheet - Higher isocost lines correspond to higher - Recycling old clothes for rags australia - The village practice thornton - Physics lab report outline - Agent based software development - Perceptual errors definition - Official beer pong rules - Iveco eurocargo body computer - Two stage cmos op amp - English-Romantic novels - Cultural relativism and universal human rights by carolyn fluehr lobban - Btec assessment tracking sheet - Help needed - Discussion: When the People You Love Don’t Think Like You - University rhode island change assessment scale - Infection disease - 8 1 mymarketinglab simulation activity market research answers - What is wovi inspection - Case Study 3 & 4 .Urinary Obstruction • Irritable Bowel Disease - Calculating time and distance - Irs 28 rate gain worksheet - Sony market segmentation targeting and positioning - Fe3+ scn fescn2+ equilibrium constant - Lee doyle solicitors glasgow - Nursing management of acute cholecystitis - Discussion boards - Information literacy lesson 2 exam - Rio salado chm 130 midterm answers - How to edit text in bluebeam - The damnation of a canyon is unconvincing - Esko bits and blades - Easter show ticket prices - Lady james hall irlam - A woman's hands poem by eva bezwoda analysis - THE FUTURE OF LIFE INSTITUTE. - True false making data secure means keeping it secret - Cloud Computing Week 4 Assignment - Stars hide your fires technique - Lake press distribution pty ltd - All else being equal socially responsible firms - Volume of copper wire - Deltav m-series wiring diagram - Challenges with realising aspirations of the common good - Socw 6456 - Partners healthcare case study analysis - SUBTITLES AND BULLET POINTS - What advantage does a bifurcated hearing give a probation officer? - Anyway poem kent keith - Shake it up rocky hurts her foot - Define standing wave ratio - How does 10 4 help you solve 30 4 - Mg90s servo motor specifications - Chapman university application essay prompt - Katch mcardle formula tdee - Essay about the food and grocery delivery - Explain the difference between lossy and lossless compression. - The most significant motivator of corporate social reporting is - Common divine role that recurs in world mythology - Psychology Writing Assignment - Autocad civil 3d cost - The visitors by ragnar kjartansson - Green computing report - Oracle e business suite support timelines - The injection molding department of a company uses - Apollo manual call point wiring diagram - Factoring and zero product property - Artifact of human creative expression examples - Thailand girl's supernatural power at the bus stop - Essay type - How jack welch changed ge