From the course: Excel Supply Chain Analysis: Solving Inventory Problems

Unlock the full course today

Join today to access over 22,700 courses taught by industry experts or purchase this course individually.

Set up a worksheet to identify maximum profit

Set up a worksheet to identify maximum profit - Microsoft Excel Tutorial

From the course: Excel Supply Chain Analysis: Solving Inventory Problems

Start my 1-month free trial

Set up a worksheet to identify maximum profit

“

- [Instructor] When you are faced with a news-vendor problem, you assume that you want to sell items that are only in demand for a short time. One way to analyze this scenario is to create a worksheet that calculates the expected profit for each demand and order quantity level. In this movie, I will start to outline that solution. My sample file is 03 02 Outline. And you can find it in the chapter three folder of the exercise files collection. I've started us on our way in this workbook. You can see that I have the mean of the expected demand and we'll assume it's t-shirts sold for a conference. The mean the standard deviation. Also the sale price and the cost to have each of the shirts manufactured. I also have some headers which are visible. Order quantity, and probability and so on. And some formatting that you can't see yet but will save you time as you're working along with me. So let's assume that you can order a…

Contents