Question

How to

put this in excel
8-1 The student engineering society is building a snack cart to raise money. Members must decide what capacity the cart should be able to serve. To serve 100 customers per hour costs \( \$ 10,310 \),

Answer 1

Read below

Step-by-step explanation:

Step 1: Open Excel.

Step 2: In the first column (Column A), write down the numbers of customers per hour you want to consider, starting from cell A2. For example, write 50, 100, 150, and so on, in sequential cells.

Step 3: In the second column (Column B), in cell B2, write this formula:

=10310/A2

Step 4: Press Enter.

Step 5: Now, you can see the cost for serving the number of customers per hour you entered in Column A, in Column B next to each corresponding value.

Step 6: To calculate for more customer numbers, just drag the formula in cell B2 down to fill the cells below it.

That's it! Excel will automatically calculate the costs for different customer numbers.

Your sheet should look like this:

| A | B

----------------------------------

1 | Customers per Hour | Cost

2 | 50 | =10310/A2

3 | 100 | =10310/A3

4 | 150 | =10310/A4

5 | ... | ...