You must answer part 1 through 6 of Q1 and all Q2 in a piece of paper (NICELY) and screenshot/scan your work and upload

[answerhappygod]

You Must Answer Part 1 Through 6 Of Q1 And All Q2 In A Piece Of Paper Nicely And Screenshot Scan Your Work And Upload 1 (84.01 KiB) Viewed 28 times

You Must Answer Part 1 Through 6 Of Q1 And All Q2 In A Piece Of Paper Nicely And Screenshot Scan Your Work And Upload 2 (84.01 KiB) Viewed 28 times

You must answer part 1 through 6 of Q1 and all Q2 in a piece of paper (NICELY) and screenshot/scan your work and upload it in canvas. Part 7 and 8 of Q1 show be presented in an excel file. Q1) For company X, annual ordering costs are $187.50 and annual quantity demanded is 1200, the holding cost is $20, and the purchase unit cost is $10.00. Sheet1 in Excel File 1. Determine the EOQ (50pt) 2. Determine the annual holding cost (50pt) 3. Determine the annual order cost (50pt) 4. Determine the annual purchasing cost (50pt) 5. Determine the total annual inventory cost (50pt) 6. Assuming that a year is 360 days, given the lead time equals 10 days, what is the reorder point (50pt) 7. In a single graph, show the holding cost, purchasing cost, order cost, and annual inventory cost developing different order quantities between 75 and 200 like what I showed in class. (100pt) depletion in Also, you 8. Using an excel graph, show the order quantity different cycles. Like the graph presented below. need to show the reorder point line parallel to the time axis. (100pt) Q2) Given the information in Q1, the company is offered discount price. Here is the policy. Any order between 200 and 299, the purchase unit price is $9.00, and for any order beyond 300 (including), the purchase unit price is $8.00. What is the best order quantity? (200pt) Tip: You need to determine the EOQ first and determine the annual inventory cost for the EOQ. Then you need to determine the annual inventory cost for the breaking points at 200 and 300. Any order quantity that yields the lowest annual inventory order cost is the best quantity. We call this system as economic discount quantity. I want to compare all four costs (order, holding, purchase, and total) in a table and compare different scenarios when the order quantity is EOQ versus 200, and 300 units. (Tip: a 3 by 4 table matrix). Finally, present a brief discussion on your finding as if you present the findings to your manager. (Open End discussion in 200 words)