Calculate the profit for each demand and order quantity combination using Excel Data Table method. Calculate the Expected profit for each order quantity.
[20 points] Import the Exam 1 Data.txt dataset into Excel. Answer following questions. [10 points] Refer to Question 5 data set. Use conditional formatting in Excel and perform following operations. Highlight the “Customers” who have ordered between 01/01/2013 and 06/30/2013 and ordered 500 or less per order. (red) Highlight the “Order ID” which have shipped from PLANT01 … Read more