tailieunhanh - beginning excel what if data analysis tool phần 3

Xác định bao nhiêu để tính phí cho mỗi vé trẻ em giả sử vé trẻ em bán ra, một văn phòng hộp thu nhập vé người lớn được bán tại , và vé cao cấp bán tại. Nhập các giá trị sau trong các tế bào sau: . Nhấp vào Công cụ. Trong các loại di động Set, | CHAPTER 1 GOAL SEEK 17 Ticket Prices In this next set of exercises you will goal seek to find the amount to charge for child adult and senior tickets to achieve a specified box office income. Goal Seeking for the Child Ticket Price Determine how much to charge per child ticket assuming 150 child tickets sold a box office income of 2 750 250 adult tickets sold at and 150 senior tickets sold at . 1. Type the following values in the following cells C2 150 B3 6 C3 250 B4 5 C4 150 2. Click Tools Goal Seek. 3. In the Set Cell box type or click cell B6. 4. In the To Value box type 2750. 5. In the By Changing Cell box type or click cell B2. 6. Click OK and click OK again. Answer The amount to charge per child ticket assuming 150 child tickets sold a box office income of 2 750 250 adult tickets sold at and 150 senior tickets sold at is . Goal Seeking for the Adult Ticket Price Determine how much to charge per adult ticket assuming 125 adult tickets sold a box office income of 2 500 200 child tickets sold at and 110 senior tickets sold at . 1. Type the following values in the following cells B2 4 C2 200 C3 125 B4 C4 110 2. Click Tools Goal Seek. 3. In the Set Cell box type or click cell B6. 4. In the To Value box type 2500. 18 CHAPTER 1 GOAL SEEK 5. In the By Changing Cell box type or click cell B3. 6. Click OK and click OK again. Answer The amount to charge per adult ticket assuming 125 adult tickets sold a box office income of 2 500 200 child tickets sold at and 110 senior tickets sold at is . Goal Seeking for the Senior Ticket Price Determine how much to charge per senior ticket assuming 225 senior tickets sold a box office income of 4 000 175 child tickets sold at and 200 adult tickets sold at . 1. Type the following values in the following cells B2 5 C2 175 B3 C3 200 C4 225 2. Click Tools Goal Seek. 3. In the Set Cell box type or click cell B6. 4. In the To Value box type 4000. 5. In the By Changing Cell .