Question
A Company allow 8% commission on the total sales to its
salesman but if the salesman is appointed on a fix salary of Rs. 10000 and 6% commission on the sales more than 30000. If in second condition the salesman receives 2400 more than the first condition. Find the total sales?Solution
Let the total sales be x 1st Condition Salesman gets = x × 8% 2nd Condition Salesman gets = 10000 + (x - 30000) × 6% The difference of 2nd and 1st condition is 2400 Therefore, 10000 + (x - 30000) × 6/100 – x × 8/100 = 2400 10000 + 6x/100 – 1800 - 8x/100 = 2400 10000 – 1800 – 2400 = 8x/100 - 6x/100 5800 = 2x/100 x = 290000
In data management, what role does metadata play when working with a large dataset of customer transactions?
Which of the following Excel functions is most appropriate for dynamically summarizing data from multiple tables by matching a key value?
A data analyst at an insurance company is tasked with assessing the probability of fraudulent claims by analyzing customer transaction data and claim hi...
When identifying business problems for data analysis, what is a critical first step?
Which of the following best describes the purpose of data wrangling?
Which of the following testing types focuses on validating that a system meets its functional requirements?
A company collects sales data from different regions, but the "Revenue" column uses inconsistent currency formats (USD, EUR, INR). What is the best appr...
Which of the following is the primary benefit of using APIs over web scraping for data collection from a website?
In the context of presenting data insights, which approach is most effective?
What is the primary difference between Type 1 and Type 2 hypervisors?