Assignment:
1. A newsvendor buys daily newspaper at the beginning of the day with a purchasing price $0.30/unit.
2. During the day, the newsvendor sells to customer with a selling price $1/unit; customer demand has a normal distribution with mean 100 and standard deviation 20.
3. At the end of the day, if there is unsold newspaper, the newsvendor can return them to the newspaper publisher with a salvage price $0.10/unit.
4. What is the optimal order (purchasing) quantity the newsvendor should buy at the beginning of the day? Upload your answer Excel file to your detailed calculations and support.