In Excel Please

Create an Excel worksheet with formulas that show the calculations of profit. Show the results of each scenario described in the following three bullets. To maximize prots, the seller can do the following

To maximize prot from separate prices the seller charges $600 for the monitor and $1,300 for the computer. In this scenario Customers 3 and 4 buy the computer and Customers 1 and 2 buy the monitor yielding a prot of $1,200. To maximize prot with mixed bundling the seller can charge $799 for the monitor, $1,499 for the computer, and $1,700 for the bundle. Then Customer 1 buys just a monitor, Customer 4 buys just a computer, and Customers 2 and 3 buy the product bundle. The seller earns a prot of $1,798. If only the monitor and computer pure bundle is off ered, the seller should sell the pure bundle for $1,700. Then each customer will purchase the pure bundle and the seller earns a prot of $1,600.

A screenshot of a suggested layout follows.

Table 5-3: Mixed Bundling is optimal Customer Computer $900 $1,100 $1,300 $1,500 $1,000 Unit Cost Monitor $800 $600 $400 $200 $300