*Complete and show all your work in Excel.

#1 Bismarck Manufacturing intends to increase capacity through the addition of new equipment. Two vendors have presented proposals. The fixed cost for proposal A is $65,000 and for proposal B, $32,000. The variable cost for A is $12 and for B, $14. The revenue generated by each unit is $18. a. What is the break-even point for each proposal? b. If the expected volume is 8,300 units, which alternative should be chosen?

#2 A silver dollar is flipped twice. Calculate the probability of each of the following occurring: a. a head on the first flip b. a tail on the second flip given that the first toss was a head c. two tails d. a tail on the first and a head on the second e. a tail on the first and a head on the second or a head on the first and a tail on the second f. at least one head on the two flips