For the below given data, Reuben wanted to accomplish a Monte Carlo simulation to study the effect of variation in unit variable cost on the final decision. While using the data table function in Excel, which cell should he reference to in the Column Input Cell field of the Data Table dialog?

A.

He should enter the cell reference that contains the "if formula."

B.

He can enter any blank cell in the spreadsheet.

C.

He can enter any cell reference that has a pre-defined formula in it.

D.

He should enter the cell reference that contains the demand volume.

Outsourcing Decision Model Data Manufactured in-house Fixed cost Unit variable cost $50,000 $125 Purchased from supplier Unit cost $175 Model Demand volume 1500 Total manufacturing cost Total purchased cost Difference $237,500 $262,500 $ (25,000) Decision Manufacture Outsourcing Decision Model Data Manufactured in-house Fixed cost Unit variable cost $50,000 $125 Purchased from supplier Unit cost $175 Model Demand volume 1500 Total manufacturing cost Total purchased cost Difference $237,500 $262,500 $ (25,000) Decision Manufacture