Report-Shanice Butcher.edited

docx

School

Nairobi Institute of Technology - Westlands *

*We aren’t endorsed by this school

Course

Subject

Management

Date

Nov 24, 2024

Type

docx

Pages

Uploaded by dannetke

1 Comprehensive Report for All Players around SG Merchandising Inc. Name Institution Affiliation Course Name Instructor’s Name Date

2 Table of Contents Introduction ............................................................................................................................................... 3 Analysis Outcome ...................................................................................................................................... 3 Loan Repayment Option – Insight ........................................................................................................... 4 Introduction 3 Analysis Outcome 3 Figure 1: Visualization of Sales per Agent 4 Loan Repayment Option – Insight 4 Figure 2: Loan Repayment Terms Comparison 4

3 Introduction The fundamental importance of data is to ensure it generates information that is reasonable and easy to explain at first glance. As a result, generating 3D figures such as Pivot tables and summary reports is crucial to ensure data becomes sensible. These figures create excellent visual images that are easy to analyze and use without employing data scientists who may demand a fortune to make this data make sense. These figures are vital in identifying underperforming agents and other details that may be crucial when making essential business decisions. The graphical instruments simplify all the details and make it easy to make decisions without much time consumption every time the records are updated, and the need for analysis becomes imminent. Computer generation helps reduce errors a human being could make during plotting. Analysis Outcome As mentioned earlier, historical data is crucial for any organization since it helps the management and key decision-makers to make informed decisions. Investors often make erroneous decisions while following intuition rather than concrete dependency on previous data. In this analysis, data visualization is the focal point to ensure that data is portrayed in the simplest form possible, which may affect significant decisions such as which financial institution to use for their financial services, the locations from which an organization may establish other branches to suffice all customers in that location. The organization could also set up more agents to help reduce the workload in these locations. As a result, the organization can gauge the agents depending on the workload, which may be confused with underperformance. The organization can also understand consumer preferences essential to creating a consumer-oriented organization.

Your preview ends here

Eager to read complete document? Join bartleby learn and gain access to the full version

Access to all documents
Unlimited textbook solutions
24/7 expert homework help

4 The figure below shows the pivot table indispensable for promoting and motivating agents within the organization. CB HA HM MB MS NB OM OR 14500 15000 15500 16000 16500 17000 17500 18000 18500 19000 Total Sales per Agent Total Figure 1: Visualization of Sales per Agent Loan Repayment Option – Insight Y-ko-V-ah Bank is preferable because loan repayment terms are the primary and only consideration. Using the PMT function in Spreadsheets, which is helpful in calculations based on interests, considering ABC Bank, the organization would have to repay with an overdue of about USD 408, USD 347 monthly for Last Resort International Bank, and about USD 290 for the favorite in this scenario. Logically, it is safe to argue that Y-ko-V-ah Bank is the best candidate. Interest Rate 10% 8% 6% Loan Amount $45,000 Terms (years) 25 Monthly Repayment $408.92 $347.32 $289.94 Figure 2: Loan Repayment Terms Comparison

Related Documents

Effective Contract Management Strategies in Project Procurement.edited.docx

ChocoTreat.docx

PS4S30_Week 7 Workshop-Debating ethical audits_Monday_Workshop (1).pptx

Discussion 8.docx

W8.docx

This webinar stressed that our hypothetical company would benefit from an Employee Assistance Progra

IPH.docx

Project P3846 n.1.docx

Leadership Skills and Mindset Reflection.edited (1).docx

Contemporary Global Hospitality Enterprise.docx

Order 464962 Assignment.docx

Subway Operations (1).docx

Recommended textbooks for you

Understanding Business

Management

ISBN:9781259929434

Author:William Nickels

Publisher:McGraw-Hill Education

Management (14th Edition)

Management

ISBN:9780134527604

Author:Stephen P. Robbins, Mary A. Coulter

Publisher:PEARSON

Spreadsheet Modeling & Decision Analysis: A Pract...

Management

ISBN:9781305947412

Author:Cliff Ragsdale

Publisher:Cengage Learning

Management Information Systems: Managing The Digi...

Management

ISBN:9780135191798

Author:Kenneth C. Laudon, Jane P. Laudon

Publisher:PEARSON

Business Essentials (12th Edition) (What's New in...

Management

ISBN:9780134728391

Author:Ronald J. Ebert, Ricky W. Griffin

Publisher:PEARSON

Fundamentals of Management (10th Edition)

Management

ISBN:9780134237473

Author:Stephen P. Robbins, Mary A. Coulter, David A. De Cenzo

Publisher:PEARSON

SEE MORE TEXTBOOKS

Recommended textbooks for you

Understanding Business
Management
ISBN:9781259929434
Author:William Nickels
Publisher:McGraw-Hill Education
Management (14th Edition)
Management
ISBN:9780134527604
Author:Stephen P. Robbins, Mary A. Coulter
Publisher:PEARSON
Spreadsheet Modeling & Decision Analysis: A Pract...
Management
ISBN:9781305947412
Author:Cliff Ragsdale
Publisher:Cengage Learning
Management Information Systems: Managing The Digi...
Management
ISBN:9780135191798
Author:Kenneth C. Laudon, Jane P. Laudon
Publisher:PEARSON
Business Essentials (12th Edition) (What's New in...
Management
ISBN:9780134728391
Author:Ronald J. Ebert, Ricky W. Griffin
Publisher:PEARSON
Fundamentals of Management (10th Edition)
Management
ISBN:9780134237473
Author:Stephen P. Robbins, Mary A. Coulter, David A. De Cenzo
Publisher:PEARSON