Tiêu đề ITPR Problem Set-1.pdf ✅

2 Inaugural tea and snacks for delegates: Rs 100 per person. The inauguration is expected to be attended by the delegates, the organizing team,invited speakers, and about twenty other invitees. Lunch: Rs 200 per plate. Afternoon tea: Ps 50 per person. Breakfast: Rs 100 per person. Dinner: Rs 250 per person. Rental charge for the conference hall (including audio visual) Rs. 10000 per day. Accommodation charges are Rs 1500 per night; it is estimated that all delegates will arrive in the morning on the inaugural day, and leave by 7.00 P.M on the second day. Hence a delegate needs accommodation for only one night. Conference kit: Rs 500 per kit Breakfast, lunch and tea are to be provided on both days, whereas dinner is to be provided only on the first day. They are to be provided for all delegates, organizers, and invited speakers. For the dinner there will be some guests additionally, and their number is expected to be around fifteen. Similarly, the additional guests for inaugural function are expected to be twenty in number, and they will be invited for the tea following the inaugural function. The invited speakers are to be provided accommodation and are to be picked up and dropped back at the airport. In addition they are to be given return airfare which is estimated to be Rs ten thousand for each speaker. Each speaker is also given an honorarium of Rs 4000. The charges for local transport for pickup or drop are estimated to be Rs 200 each way. The conference kits are to be given to all delegates, organizers and invited speakers. Additional for administrative expenses like telephone, courier and clerical work, a sum of Rs 40,000 is to be set apart. Questions: If the entire expenditure of the conference is to be met by the registration fee alone, then what should be the registration fee per participant? To answer the above question, experiment with various possible values of parameters like number of delegates and sponsorship amount. Problem 3- Sales Commission at XYZ Corp The sales commission rate for a salesman at XYZ corporation depends on two factors, his year of service and amount of sales generated. The workbook has two tables giving sales commission, one for less than 3-year tenure and another giving three or more than three-year tenure. Provide a formula for cell D2 (to be copied through D3:D12) to compute the sales commission for various salesmens.
3 A B C D E E F G H I J 1 Sales Rep Years Sales Commission <3 Years Tenure 3+ Years Tenure 2 Birendra 2 120,000 Amt Sold Rate Amt Sold Rate 3 Domnic 1 210,921 0 1.50% 0 2.00% 4 Elias 1 100,000 5,000 3.25% 50,000 6.25% 5 Ganesh 2 87,401 10,000 3.50% 100,000 7.25% 6 Harveen 6 310,983 20,000 5.00% 200,000 8.25% 7 Kumar 3 43,902 50,000 6.00% 300,000 9.25% 8 Manoj - 2 121,021 100,000 7.00% 500,000 10.00% 9 Oswald 3 908 250,000 8.00% 10 Raghu 1 0 11 Vishwanath 4 359,832 12 William 4 502,983 Problem 4- Employee Data Analysis of XYZ Corp On the basis of the information about employees of XYZ Corporation given in the table, answer following questions. a) Compute average age of all males b) Provide steps to count all RPFC-II females. c) Compute average age of APFC males from Bombay d) Count number of females not from Bombay. e) Count number of employees who are either males not from Bombay or females only from Bombay. f) Compute maximum age of Male who is either APFC or RPFC-II. Rank NAME LOCATION AGE GENDER DESIGNATION 1 Jag Mohan Mumbai 37 Male RPFC-II 2 Shiv Kumar Ahmedabad 35 Male APFC 3 Dharmendra Kumar Singh Baroda 30 Male APFC 4 Jai.Prakash Chauhan HO 31 Female APFC 5 Maruti Bhoyi Bangalore 40 Male APFC 6 P Swaminathan Trivandrum 54 Male APFC 7 Vaishali Dhayal Patna 30 Female APFC 8 Sanjay Kumar HO 31 Male APFC 9 Krishna Chaudhary Rourkela 40 Male APFC 10 ES Sanjeeva Rao Hyderabad 40 Male APFC 11 NA Nair Bangalore 50 Male RPFC-II 12 R Subhash Kochi 49 Male RPFC-H 13 Shyam Veer Tonk Mumbai 29 Male APFC
4 14 KK Batra -' ._ Bathinda 53 Male RPFC-II 15 Manoj Kumar Yadav Kolhapur 26 Male APFC 16 C Baskaran Chennai 54 Male APFC 17 Kundrakpam Rupesh Si4igh Agartala 30 Male APFC 18 Alok Yadav HO 34 Male APFC 19 D Remmei Delhi 34 Male APFC Problem 5- Purchase Order Discount Analysis at XYZ Corp XYZ corporation has purchased several products from its supplier in a June 2015. There are four different types of products viz P1, P2, P3, and P4. If the quantity of purchase is greater than or equal to a certain threshold value then a certain percentage of discount is given by the supplier. For each product type the unit price, the threshold quantity for discount, and the percentage discount are given in Table 1 while the details of products purchased in last ten purchase orders are given in Table 2. Compute the total amount due to be paid on each purchase order. Table 1 Product Code Unit price Threshold Quantity % Discount P1 10 5000 10 P2 25 10000 15 P3 5 10000 2 P4 100 1000 5 Table 2 Purchase Order No. Product No. Quantity Purchased 1001 P2 500 1002 P3 1500 1003 P1 1000 1004 P4 10000 1005 P2 7500 1006 P2 1500 1007 P4 1000 1008 P3 2000 1009 P2 1700