Construct an influence diagram for profit in the single-period purchase decision (Newsvendor Model). Use Excel'sFormula Auditingcapability to demonstrate the relationship between the spreadsheet model and the influence diagram.

A B C D E Newsvendor Model Data Selling price $ 18.00 Cost $ 12.00 Discount price $ 9.00 Model Demand 41 Purchase Quantity 44 Quantity Sold 41 Surplus Quantity 3 Profit $ 237.00