Homework Help Question & Answers

numbers in column Al Add a 4th Column titled "Store Location" as shown below. Profit Revenue-...


numbers in column Al Add a 4th Column titled Store Location as shown below. Profit Revenue- 30,000 $ 100,000 $ Expenses 70,
QUESTION 2 What is the Profit earned at the store in Brooklyn? QUESTION 3 What is the Total Revenue earned from all stores? Q
numbers in column Al Add a 4th Column titled "Store Location" as shown below. Profit Revenue- 30,000 $ 100,000 $ Expenses 70,000 $ $ $ $ Profit Revenue Expenses 30,000 $ 100,000 $ 70,000 50,000 $ 160,000 $ 110,000 25,000 $ 90,000 $ 65,000 Store Location Queens Brooklyn Bronx Sums $ $ 105,000 $ 35,000 $ 350,000 $ 116,667 $ 245,000 81,667 Averages Calculating Sums: To calculate the "Sum of Profits," type "=SUM(A6:A8)" in Cell A10.
QUESTION 2 What is the Profit earned at the store in Brooklyn? QUESTION 3 What is the Total Revenue earned from all stores? QUESTION 4 What is the Average Expense of all stores combined?
0 0
Next > < Previous
ReportAnswer #1

Answer 2

Profit earned at the store in Brooklyn is $50,000

Answer 3

Total Revenue earned from all stores = $105,000 (See table below)

Answer 4

Average Expense of all stores = $81,667

Working Note:

Store Location Revenue Expense Profit Queens $100,000 $70,000 $30,000 Brooklyn $160,000 $110,000 $50,000 Bronx $90,000 $65,00

A B C D 1 Store Location Revenue Expense Profit 2 Queens 100000 70000 =+B2-C2 3 Brooklyn 160000 110000 =+B3-C3 4 Bronx 90000

I hope this clear your doubt.

Feel free to comment if you still have any query or need something else. I'll help asap.

Do give a thumbs up if you find this helpful.

Know the answer?
Add Answer of:
numbers in column Al Add a 4th Column titled "Store Location" as shown below. Profit Revenue-...
Your Answer: Your Name: What's your source?
Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
Free Homework App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.