1answer.
Ask question
Login Signup
Ask question
All categories
  • English
  • Mathematics
  • Social Studies
  • Business
  • History
  • Health
  • Geography
  • Biology
  • Physics
  • Chemistry
  • Computers and Technology
  • Arts
  • World Languages
  • Spanish
  • French
  • German
  • Advanced Placement (AP)
  • SAT
  • Medicine
  • Law
  • Engineering
Liula [17]
3 years ago
9

The Excel file Store and Regional Sales Database provides sales data for computers and peripherals showing the store identificat

ion number, sales region, item number, item description, unit price, units sold, and month when the sales were made during the fourth quarter of last year.2 Modify the spreadsheet to calculate the total sales revenue for each of the eight stores as well as each of the three sales regions.
Mathematics
1 answer:
zhannawk [14.2K]3 years ago
8 0

Answer:

Total sales revenue use  excel function : ( SUMIF. =sumif(range, criteria, [sum_range] )

For each of the stores: Use excel function: For Store 1: =sumif(B4:B99,1,I4:I99) then repeat same for Store 2 to store 8

Step-by-step explanation:

To modify the spreadsheet to calculate the total sales revenue we will add a column " sales revenue "

multiply values of column : ( unit sold * unit price )  to get Total sales revenue. then use  excel function : ( SUMIF. =sumif(range, criteria, [sum_range] ) to find Total sales revenue

calculate the total revenue for each of the 8 stores using a pivot table using  "store identification number" in row  and " sales revenue " in values field

To get the sales revenue ; replace " store identification value" with sales region " column

You might be interested in
Can someone please help me with this?!
Nimfa-mama [501]

(a) 1,1 (b) 3,2 (c) 3,2 (d) 1,5

5 0
3 years ago
Read 2 more answers
Is the following relation a function?<br> X. Y<br> -1. -2.<br> 2. 3<br> 3. 1<br> 6. -2
SSSSS [86.1K]

Answer:

Step-by-step explanation:

x y

−1 −2

2 3

3 1

6 −2

5 0
2 years ago
Read 2 more answers
Find the critical numbers of the function f(x) = x6(x − 1)5 what does the first derivative test tell you that the second derivat
patriot [66]
The given function is f(x) = x⁶(x-1)⁵

The first derivative is
f'(x) = 6x⁵(x-1)⁵ + 5x⁶(x-1)⁴
       = x⁵(x-1)⁴(6x - 6 + 5x)
       = x⁵(x-1)⁴(11x - 6)
The critical values are the zeros of f'(x). They are
x = 0, 6/11, and 1.
The critical values indicate that turning points exist for f(x) at the critical points. However, we do not know the nature of the turning points.

Write the first derivative in the form f'(x) = (x-1)⁴(11x⁶ - 6x⁵).
The second derivative is
f''(x) = 4(x-1)³(11x⁶ - 6x⁵) + (x-1)⁴(66x⁵ - 30x⁴)
        = (x-1)³(44x⁶ - 24x⁵ + 66x⁶ - 30x⁵ - 66x⁵ + 30x⁴)
        = (x-1)³(110x⁶ - 120x⁵ + 30x⁴)
        = 10x⁴(x-1)³(11x² - 12x + 3)
The sign of f''(x) at the critical values tell us the nature of the turning point.

f''(0) = 0, therefore a point of inflection exists at x = 0.
f''(6/11) > 0, therefore a local minumum exists at x = 6/11.
f''(1) = 0, therefore a point of inflection exists at x=1.

The graphs shown below confirm these results.

8 0
3 years ago
The owner of the Rancho Grande has 3,060 yd of fencing with which to enclose a rectangular piece of grazing land situated along
Pavel [41]

Answer:

1170450 yd^2

Step-by-step explanation:

The first thing is to calculate the necessary perimeter, which would be like this:

2 * a + b = 3060

if we solve for b, we are left with:

b = 3060-2 * a

Now for the area it would be:

A = a * b = a * (3060-2 * a )

A = 3060 * a -2 * a ^ 2

To maximize the area, we calculate the derivative with respect to "a":

dA / da = d [3060 * a -2 * a ^ 2

]/gives

dA / day = 3060 - 4 * a

If we equal 0:

0 = 3060 - 4 * a

4 * a = 3060

a = 3060/4

a = 765 and d

Therefore b:

b = 3060 - 2 * a = 3060 - 1530 = 1530

A = a * b

A = 765 * 1530

A = 1170450 and d ^ 2

3 0
3 years ago
If the sales tax rate is 7.52% in California, then how much would you pay in Los Angeles for a coat that costs $120.00?
taurus [48]

Answer:

$129.02

Step-by-step explanation:

$120 multiplied by the sales tax 1.0752 = $129.024; Round .024 to the nearest tenths to get .02

7 0
3 years ago
Other questions:
  • Which sentence is NOT a geometric progression?
    7·2 answers
  • A jar can fit up to 125 gumballs write an inequality to represent the number the jar can hold
    9·1 answer
  • The area of an equilateral triangle with a 6 inch apothem
    8·1 answer
  • A company is looking to design a new cover for their smartphone. The scale drawing of the design is shown below. The coordinates
    11·1 answer
  • Line CD passes through points (0, 2) and (4, 6). Which equation represents líne CD?
    13·1 answer
  • Score! U OT pt
    12·1 answer
  • Help please really need
    6·1 answer
  • What is the measure of angle y?
    5·2 answers
  • What inequality is represented by this graph? 12 2 3 0128 o a 128​
    5·1 answer
  • A right triangle is displayed.
    10·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!