C&A; set up the tables as shown below so that Solver can be used to find an opti

Question

C&A; set up the tables as shown below so that Solver can be used to find an optimal shipping schedule. Which of the following cell ranges should contain a formula? Check all that apply. A. Factory A Factory B Factory C 2 Customer 14 3 Customer 23 4 Customer 3 1 5 Cus tomer 4 6 6 Supply 100 300 200 400 550 250 200 Factory A Factory BF Factory C 9 Customer 1 10 Customer 2 11 Customer 3 12 Customer 4 13|S | 14 15 16 Customer 1 17 Customer 2 18 Customer 3 19 Customer 4 20 Factory A Factory B Factory C Total Profit E20 B13:D13 O B16:D19 B9:D12 E16:D19

Explanation / Answer

Only Option (A)

E20

As the E20 is used to calculate the total profit, so the formula will be present in that cell.

Remaining options shows the supply and demand which we have to provide manually and there wont be formulas as they are datas.

Related Questions

Navigate

• Browse (All)
• Browse C
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.