Refer to the Draft TV Commercials case. Review the problem statement and influence chart that were generated for this case in conjunction with the corresponding exercises in Chapter 2. (If this has not yet been done, develop the problem statement and influence chart as preliminary steps.) Design a spreadsheet to determine the impact on ad quality of paying for three draft commercials.

The above exercises refer to the cases in the back of this book. Read the case description carefully, sketch an appropriate spreadsheet on paper, and then build and test a prototype model. The purpose of the model is specified in the question.