workk
3 years ago
10
266FC6A3-E531-4DFB-B914-0F1B88EB2DBB.pdf
Book1.xlsx
- Screenshot2023-12-06112642.png
- Screenshot2023-12-061126421.png
266FC6A3-E531-4DFB-B914-0F1B88EB2DBB.pdf
The members of our group for the upcoming project presentation and to present our proposal are as follows:
1. Abhishek Devanal
2. Lakshmi Deepthi Anyam
Project Proposal:
We are excited to present our proposal for the project, which involves the application of linear optimization techniques in the context of employee scheduling and cost minimization. Our project aims to address the scheduling challenges faced by a software company named Minsyst Consulting, with a focus to minimize marketing costs where the company is choosing different mediums to advertise the new developed product to reach maximum customers while minimizing the cost.
The software industry is known for its dynamic nature, and efficient resource allocation is crucial to maintain competitiveness. By utilizing linear optimization methods, we plan to create a scheduling model that ensures the most efficient utilization of employees’ time while minimizing expenses avoiding the extras. This approach will not only benefit Minsyst Consulting but also contribute to the broader understanding of optimization techniques in management.
If you require any additional information or have any suggestions, please let us know.
Book1.xlsx
Sheet1
| Certainly! Here's the data in a table format that you can easily copy and paste into Excel: |
| ```plaintext |
| +-------------+-----------------------+-----------------------------+------------------+------------------------+ |
| | Employee ID | Name | Role | Preferred Hours | Days Off | |
| +-------------+-----------------------+-----------------------------+------------------+------------------------+ |
| | 1 | Arjun Sharma | Developer | 9 am - 5 pm | Saturday, Sunday | |
| | 2 | Ananya Patel | QA Engineer | 10 am - 6 pm | Sunday, Monday | |
| | 3 | Rohan Kapoor | Designer | 8 am - 4 pm | Friday, Saturday | |
| | 4 | Priya Desai | Project Manager | 10 am - 6 pm | Monday, Wednesday | |
| | 5 | Rahul Gupta | Analyst | 9 am - 5 pm | Thursday, Sunday | |
| | 6 | Aditi Choudhary | Software Engineer | 9 am - 6 pm | Tuesday, Friday | |
| | 7 | Vikram Mehta | Data Scientist | 10 am - 7 pm | Wednesday, Sunday | |
| | 8 | Neha Reddy | UX Designer | 8:30 am - 4:30 pm | Thursday, Saturday | |
| | 9 | Krish Singh | Network Engineer | 10 am - 6 pm | Monday, Friday | |
| | 10 | Asha Sharma | HR Specialist | 9 am - 5 pm | Wednesday, Sunday | |
| | 11 | Pranav Kapoor | Frontend Developer | 9 am - 6 pm | Tuesday, Saturday | |
| | 12 | Anita Verma | Business Analyst | 8:30 am - 5:30 pm | Thursday, Sunday | |
| | 13 | Sanjay Patel | Database Administrator | 10 am - 7 pm | Monday, Wednesday | |
| | 14 | Mira Singh | Marketing Coordinator | 9 am - 5 pm | Wednesday, Friday | |
| | 15 | Rajesh Kumar | System Architect | 10 am - 6 pm | Thursday, Sunday | |
| | 16 | Shreya Gupta | Software Developer | 9 am - 5 pm | Monday, Wednesday | |
| | 17 | Rajiv Kapoor | QA Tester | 10 am - 6 pm | Thursday, Sunday | |
| | 18 | Anjali Desai | UX/UI Designer | 8 am - 4 pm | Wednesday, Friday | |
| | 19 | Aditya Sharma | Project Coordinator | 9:30 am - 5:30 pm | Monday, Thursday | |
| | 20 | Meera Reddy | System Analyst | 10 am - 6 pm | Tuesday, Saturday | |
| | 21 | Karan Patel | Database Developer | 9 am - 5 pm | Friday, Sunday | |
| | 22 | Nisha Singh | Marketing Specialist | 8:30 am - 4:30 pm | Wednesday, Saturday | |
| | 23 | Vivek Mehta | Network Administrator | 10 am - 7 pm | Monday, Friday | |
| | 24 | Priyanka Kapoor | HR Manager | 9 am - 5 pm | Tuesday, Thursday | |
| | 25 | Suresh Kumar | Frontend Engineer | 10 am - 6 pm | Wednesday, Sunday | |
| | 26 | Divya Sharma | Software Tester | 9 am - 5 pm | Thursday, Saturday | |
| | 27 | Amit Verma | Data Analyst | 10 am - 6 pm | Monday, Sunday | |
| | 28 | Anushka Patel | UI/UX Designer | 8 am - 4 pm | Tuesday, Friday | |
| | 29 | Kunal Kapoor | Business Intelligence Analyst | 9 am - 5 pm | Wednesday, Sunday | |
| | 30 | Shweta Singh | IT Support Specialist | 10 am - 6 pm | Thursday, Saturday | |
| | 31 | Manoj Kumar | Software Architect | 9 am - 5 pm | Friday, Sunday | |
| | 32 | Ritu Desai | Product Manager | 8:30 am - 4:30 pm | Monday, Wednesday | |
| | 33 | Rajat Sharma | Security Analyst | 10 am - 7 pm | Tuesday, Saturday | |
| | 34 | Sakshi Kapoor | Content Writer | 9 am - 5 pm | Wednesday, Sunday | |
| | 35 | Arnav Patel | DevOps Engineer | 10 am - 6 pm | Thursday, Saturday | |
| | 36 | Ananya Sharma | Full Stack Developer | 9 am - 5 pm | Monday, Wednesday | |
| | 37 | Prateek Patel | Quality Assurance Analyst | 10 am - 6 pm | Thursday, Sunday | |
| | 38 | Sneha Kapoor | Graphic Designer | 8 am - 4 pm | Tuesday, Friday | |
| | 39 | Deepak Mehta | Project Analyst | 9 am - 5 pm | Wednesday, Sunday | |
| | 40 | Neha Kumar | System Administrator | 10 am - 6 pm | Thursday, Saturday | |
| | 41 | Vikas Sharma | IT Consultant | 9 am - 5 pm | Friday, Sunday | |
| | 42 | Pooja Desai | UX Researcher | 8:30 am - 4:30 pm | Monday, Wednesday | |
| | 43 | Rohit Kapoor | Network Engineer | 10 am - 7 pm | Tuesday, Friday | |
| | 44 | Anjali Singh | HR Coordinator | 9 am - 5 pm | Wednesday, Saturday | |
| | 45 | Krish Mehta | Frontend Developer | 10 am - 6 pm | Thursday, Sunday | |
| +-------------+-----------------------+-----------------------------+------------------+------------------------+ |
| ``` |
| Copy this table and paste it into Excel or any other spreadsheet software. If you have any further requests or modifications, feel free to let me know! |
Sheet2
| ID | Name | Post | Availability | Days off | cost of the employee | (cons) Min needed for the shift |
| 1 | Arjun Sharma | Developer | 9 am - 5 pm | Saturday, Sunday | ||
| 2 | Ananya Patel | QA Engineer | 10 am - 6 pm | Sunday, Monday | ||
| 3 | Rohan Kapoor | Designer | 8 am - 4 pm | Friday, Saturday | ||
| 4 | Priya Desai | Project Manager | 10 am - 6 pm | Monday, Wednesday | ||
| 5 | Rahul Gupta | Analyst | 9 am - 5 pm | Thursday, Sunday | ||
| 6 | Aditi Choudhary | Software Engineer | 9 am - 6 pm | Tuesday, Friday | ||
| 7 | Vikram Mehta | Data Scientist | 10 am - 7 pm | Wednesday, Sunday | ||
| 8 | Neha Reddy | UX Designer | 8:30 am - 4:30 pm | Thursday, Saturday | ||
| 9 | Krish Singh | Network Engineer | 10 am - 6 pm | Monday, Friday | ||
| 10 | Asha Sharma | HR Specialist | 9 am - 5 pm | Wednesday, Sunday | ||
| 11 | Pranav Kapoor | Frontend Developer | 9 am - 6 pm | Tuesday, Saturday | ||
| 12 | Anita Verma | Business Analyst | 8:30 am - 5:30 pm | Thursday, Sunday | ||
| 13 | Sanjay Patel | Database Administrator | 10 am - 7 pm | Monday, Wednesday | ||
| 14 | Mira Singh | Marketing Coordinator | 9 am - 5 pm | Wednesday, Friday | ||
| 15 | Rajesh Kumar | System Architect | 10 am - 6 pm | Thursday, Sunday | ||
| 16 | Shreya Gupta | Software Developer | 9 am - 5 pm | Monday, Wednesday | ||
| 17 | Rajiv Kapoor | QA Tester | 10 am - 6 pm | Thursday, Sunday | ||
| 18 | Anjali Desai | UX/UI Designer | 8 am - 4 pm | Wednesday, Friday | ||
| 19 | Aditya Sharma | Project Coordinator | 9:30 am - 5:30 pm | Monday, Thursday | ||
| 20 | Meera Reddy | System Analyst | 10 am - 6 pm | Tuesday, Saturday | ||
| 21 | Karan Patel | Database Developer | 9 am - 5 pm | Friday, Sunday | ||
| 22 | Nisha Singh | Marketing Specialist | 8:30 am - 4:30 pm | Wednesday, Saturday | ||
| 23 | Vivek Mehta | Network Administrator | 10 am - 7 pm | Monday, Friday | ||
| 24 | Priyanka Kapoor | HR Manager | 9 am - 5 pm | Tuesday, Thursday | ||
| 25 | Suresh Kumar | Frontend Engineer | 10 am - 6 pm | Wednesday, Sunday | ||
| 26 | Divya Sharma | Software Tester | 9 am - 5 pm | Thursday, Saturday | ||
| 27 | Amit Verma | Data Analyst | 10 am - 6 pm | Monday, Wednesday | ||
| 28 | Anushka Patel | UI/UX Designer | 8 am - 4 pm | Tuesday, Friday | ||
| 29 | Kunal Kapoor | Business Intelligence Analyst | 9 am - 5 pm | Wednesday, Saturday | ||
| 30 | Shweta Singh | IT Support Specialist | 10 am - 6 pm | Thursday, Saturday | ||
| 31 | Manoj Kumar | Software Architect | 8:30 am - 4:30 pm | Friday, Sunday | ||
| 32 | Ritu Desai | Product Manager | 10 am - 7 pm | Monday, Wednesday | ||
| 33 | Rajat Sharma | Security Analyst | 9 am - 5 pm | Tuesday, Saturday | ||
| 34 | Sakshi Kapoor | Content Writer | 10 am - 6 pm | Wednesday, Sunday | ||
| 35 | Arnav Patel | DevOps Engineer | 9 am - 5 pm | Thursday, Saturday | ||
| 36 | Ananya Sharma | Full Stack Developer | 10 am - 6 pm | Monday, Wednesday | ||
| 37 | Prateek Patel | Quality Assurance Analyst | 9 am - 5 pm | Thursday, Sunday | ||
| 38 | Sneha Kapoor | Graphic Designer | 10 am - 6 pm | Monday, Wednesday | ||
| 39 | Deepak Mehta | Project Analyst | 8:30 am - 4:30 pm | Thursday, Saturday | ||
| 40 | Neha Kumar | System Administrator | 10 am - 7 pm | Friday, Sunday | ||
| 41 | Vikas Sharma | IT Consultant | 9 am - 5 pm | Monday, Wednesday | ||
| 42 | Pooja Desai | UX Researcher | 10 am - 6 pm | Tuesday, Friday | ||
| 43 | Rohit Kapoor | Network Engineer | 9 am - 5 pm | Wednesday, Saturday | ||
| 44 | Anjali Singh | HR Coordinator | 10 am - 6 pm | Thursday, Saturday | ||
| 45 | Krish Mehta | Frontend Developer | 9 am - 5 pm | Wednesday, Sunday | ||
| Total cost (obj)(min) |
Sheet3
| Project 1 | Project 2 | Project 3 | Project 4 | Project 5 | Total Capital Available | |||
| Profit($) | 200,000 | 350,000 | 278,000 | 395,000 | 425,000 | 2 Million | ||
| Project expense | 750,000 | 690,000 | 800,000 | 918,000 | 775,000 | 20,000,000 | ||
| Manpower | 65 | 72 | 58 | 70 | 62 | 200 |