#1. Our firm is about to introduce a new product. The Selling Price of the product is $45/unit. The per unit Procurement, Labor, and Transportations Costs are uncertain and are given in the table below as probability distributions.

#1.1 Use the information in the foregoing table to fill in the 20 empty cells in the table below. Use the random numbers that are given in the table.

Observation	Selling Price	Procurement Cost	RAND()	Labor Cost	RAND()	Transportation Cost	RAND()	Profit
1	45		.15		.05		.94
2	45		.16		.71		.22
3	45		.24		.43		.56
4	45		.21		.14		.41
5	45		.34		.03		.49

(This is a live table, and can be copied and pasted into an Excel spreadsheet.)

#1.2 Use the Descriptive Statistics Tool in Data Analysis to find the mean, the standard deviation, and the 95% confidence interval for Profit.

mean: stdev: 95% CI from to

(Show these four values to two decimal places.)