Finally, EuroWatch has a third order for $100$ watches. The customer has agreed to pay $$50,000$ for the order$$that is$,$ $$500$ per watch. If EuroWatch sends more than $100$ watches to the customer, its revenue doesn$$t increase; it can never exceed $$50,000.$ Its unit cost of producing a watch is $$450,$ regardless of which line it is assembled on$.$ The order will be filled entirely from a single line, and EuroWatch plans to send slightly more than $100$ watches to the customer.

If the customer opens the shipment and finds that there are fewer than $100$ defect$-$free watches $($which we assume the customer has the ability to do$),$ then he will pay only for the defect$-$free watches$$EuroWatch$\text{'}$s revenue will decrease by $$500$ per watch short of the $100$ required$$and on top of this, EuroWatch will be required to make up the difference at an expedited cost of $$1000$ per watch. The customer won$$t pay a dime for these expedited watches. $($If expediting is required, EuroWatch will make sure that the expedited watches are defect$-$free. It doesn$$t want to lose this customer entirely.$)$

You have been asked to develop a spreadsheet model to find EuroWatch's expected profit for any number of watches it sends to the customer. You should develop it so that it responds correctly, regardless of which assembly line is used to fill the order and what the shipment quantity is$.($Hints: Use the BINOM.DIST function, with last argument $0,$ to fill up a column of probabilities for each possible number of defective watches. Next to each of these, calculate EuroWatch's profit. Then, use a SUMPRODUCT to obtain the expected profit. Finally, you can assume that EuroWatch will never send more than $110$ watches. It turns out that this large a shipment is not even close to optimal.$)$