due 12/16/16 , no plagirism , must cite work, apa format , please see attachment from the book for help

Option #1: Inventory Management

Solve the following inventory management problems at the end of Chapter 12 in the Heizer and Render (2014) textbook:

• 12.1.
• 12.9 a, b, c, and d.

You may solve the problems using: (a) pencil, paper, and calculator, or (b) MS Excel. You are encouraged to use Excel if you are familiar with the software, but how to use Excel is not taught in this course.

Be sure to find the example problems in Chapter 12 that list 12.1 and 12.9 in the Related Problems line of the example solutions, and practice these example problems before attempting 12.1 and 12.9.

Submit your solutions in an MS Word document only. You will provide a total of six answers, and you must show exactly how you calculated each of the six answers. Your submission will be graded based on the accuracy of your answers and the degree to which you clearly show each step of your analytical approach and calculations. Papers that are submitted with accurate answers, but do not include the details of how those answers were determined, will not be eligible for full credit. Papers that are submitted with accurate analytical methods and calculation approaches, but inaccurate final answers, will be eligible for some credit.