Big-Foot shoes manufacturer analyzes that, from his past business experience, next year's shoes sales demand will follow a normal distribution with a mean of 100,000 uni the company manager, the selling price is currently set at 110,000 won. In addition, the unit variable cost required in proportion to the number of units sold has an inherent un- distribution with parameter values of a mean of 25,000 won and a standard deviation of 5,000 won. And the fixed cost of the Big-Foot manufacturer has been confirmed at 2.500 simulation analysis on the net profit of the Big-Foot company for the next year, However, the number of simulation runs is set to 100, And for reference, use the formula below Reveaue - Demand x Unit Price 3.1) Perform a simulation analysis on the above and draw a histogram chart for net profit

.) Cost = Variable cost + Fixed cost = Unit variable cost x Demand +Fixed cost Net Profit = Return - Cost 3.2) Analyze descriptive statistics using tke "Descriptive statistic" in the data analysis provided by Excel. ()

3.3) Based on the significance level of 95%, calculate the interval estimate of net profit. [Hint: You can use the "Rank Percentile" the data analysis in Excel, or mor ercentile(net profit array, 2.5%), and the upper limit is percentile(net profit array, 97.5%).]