Hello Skgupta. I have a last assignment in Operations Management. I am kindly asking for help. I have attached the problems in a word doc. I will also attach an Excel spreadsheet that will help with the problems. Thnak You! Problems* *Use spreadsheet template provided.

1. Nadia Algar is the overworked IT resource person for her department. In the next round of computer purchases, she is determined to recommend a vendor who does a better job of documenting possible errors in the system and whose customer service line is more responsive to the needs of her colleagues. Nadia compiled the following data over an eight-week observation period. Assuming 40 hours per week, which computer vendor should Nadia pursue?

2. Although it will fulfill her lifelong dream, Patricia is not confident that demand for her Tiny Trisha doll will exceed the breakeven point computed in Problem 6-5. If she chooses a less appealing site and does more of the work by hand, her initial investment cost can be reduced to $5000, but her per-unit cost of manufacture will rise to $15 per doll.

a. What is the breakeven point for this new process? b. Compare this process to the process proposed in the previous problem. For what volume of demand should Patricia choose this process?