1 Instructions for Case - Introduction: What is the case, and what is the problem? - Answers: Each answer should have a paragraph explaining the answer and why it is the correct answer. - Ideas/Conclusion: Conclude your work with your ideas on the case (Analyze the result of each constraint and make suggestions according to these results) - Reference: Put every source you used in references even if you did not use it for citations. - Appendix: Put every calculation you did to solve questions in the appendix. Add screenshots of the "solver" part. Prepare in report format. (Do not forget to include the cover page and table of contents. Please consder the above guidance.) Also, do not forget to send your Excel files, word (or pdf) files and PowerPoint files by saving them with the surname and name of the group members. (For instance, if group members are Gene Simmons and Paul Stanley, they will save their files as "Simmons, Gene and Stanley, Paul") 2 Mosby Design Case Ted Mosby decided to open an architectural agency, "Mosby Design". He has contracted with five local architects he can work with in this agency. According to the agreement between the agency and the architects, a certain number of people from each architect's team will support the projects through the agency. The followving table shows the number of employees on each local architect's team. Before the agency was opened, market research was conducted and six citjes with high demand were identified and the studios belonging to the agency were opened to these cities. The number of employees who need to work in the studio varies acoording to the projects that need to be completed monthly. You can see the demand for employees in each studio within a month below. According to the agreement, each architect and his team have an average monthly period of time (hour/month) to complete projects through the studios. The table below shows bow much time the employees from each architect's team worked for each studio. For example, Marshall's office spend monthly 90 hour for architectural work in studio 1 or Lily's office spend monthly 70 hour for architectural work in studio 5. d) Lily Aldrin organized a training program to grow his team, and 10 people who were successful in this training program were included in Aldrin's team. In addition, due to the political and economic problems in Studio 5. Tracy MeConnell does not want anyone from his team to be assigned to this studio. Please find monthly time spent by the architects' teams in the studios and how many employees from each architects' team can work in which studios. e) Ted Mosby does not accept projects under a certain square meter. Since most of the projects in the city where Studio 2 is located are related to small square meter villa landscaping, there is less demand compared to other projects. Ten new landscape project applications have been made to Studio 2 by a new site built in the city and each of the projects is larger than the square meter set as the lower limit. Among the five architects who agreed, Robin and Lily's teams stand out with their landscape projects. Therefore, Ted Mosby has decided that Robin and Lily's teams will carry out all of the demand at Studio 2. However, since Robin has more employees, the number of people assigned to Robin's team should be greater than the number of people assigned to Lily's team. Please find monthly time spent by the architects' teams in the studios and how many employees from each architects' team can work in which studios. f) Ted Mosby decided to open a studio in the city of the company's headquarters to develop new projects. The distinctive feature of this studio is that entirely new architectural projects are tried and presented to the prospective customers. Two people from each architect's team will work in this studio to ensure variety in new projects to meet the demand. Below is the average monthly period of time (hour/month) for each architect's team to complete projects through new studio 7 (the studio located in the company's headquarters). Please find monthly time spent by the architects' teams in the studios and how many employees from each architects' team can work in which studios. 1 Instructions for Case - Introduction: What is the case, and what is the problem? - Answers: Each answer should have a paragraph explaining the answer and why it is the correct answer. - Ideas/Conclusion: Conclude your work with your ideas on the case (Analyze the result of each constraint and make suggestions according to these results) - Reference: Put every source you used in references even if you did not use it for citations. - Appendix: Put every calculation you did to solve questions in the appendix. Add screenshots of the "solver" part. Prepare in report format. (Do not forget to include the cover page and table of contents. Please consder the above guidance.) Also, do not forget to send your Excel files, word (or pdf) files and PowerPoint files by saving them with the surname and name of the group members. (For instance, if group members are Gene Simmons and Paul Stanley, they will save their files as "Simmons, Gene and Stanley, Paul") 2 Mosby Design Case Ted Mosby decided to open an architectural agency, "Mosby Design". He has contracted with five local architects he can work with in this agency. According to the agreement between the agency and the architects, a certain number of people from each architect's team will support the projects through the agency. The followving table shows the number of employees on each local architect's team. Before the agency was opened, market research was conducted and six citjes with high demand were identified and the studios belonging to the agency were opened to these cities. The number of employees who need to work in the studio varies acoording to the projects that need to be completed monthly. You can see the demand for employees in each studio within a month below. According to the agreement, each architect and his team have an average monthly period of time (hour/month) to complete projects through the studios. The table below shows bow much time the employees from each architect's team worked for each studio. For example, Marshall's office spend monthly 90 hour for architectural work in studio 1 or Lily's office spend monthly 70 hour for architectural work in studio 5. d) Lily Aldrin organized a training program to grow his team, and 10 people who were successful in this training program were included in Aldrin's team. In addition, due to the political and economic problems in Studio 5. Tracy MeConnell does not want anyone from his team to be assigned to this studio. Please find monthly time spent by the architects' teams in the studios and how many employees from each architects' team can work in which studios. e) Ted Mosby does not accept projects under a certain square meter. Since most of the projects in the city where Studio 2 is located are related to small square meter villa landscaping, there is less demand compared to other projects. Ten new landscape project applications have been made to Studio 2 by a new site built in the city and each of the projects is larger than the square meter set as the lower limit. Among the five architects who agreed, Robin and Lily's teams stand out with their landscape projects. Therefore, Ted Mosby has decided that Robin and Lily's teams will carry out all of the demand at Studio 2. However, since Robin has more employees, the number of people assigned to Robin's team should be greater than the number of people assigned to Lily's team. Please find monthly time spent by the architects' teams in the studios and how many employees from each architects' team can work in which studios. f) Ted Mosby decided to open a studio in the city of the company's headquarters to develop new projects. The distinctive feature of this studio is that entirely new architectural projects are tried and presented to the prospective customers. Two people from each architect's team will work in this studio to ensure variety in new projects to meet the demand. Below is the average monthly period of time (hour/month) for each architect's team to complete projects through new studio 7 (the studio located in the company's headquarters). Please find monthly time spent by the architects' teams in the studios and how many employees from each architects' team can work in which studios