I believe the answer would be $63,600.
Hope this helps ;}
Answer:
x= 2 and y= -1
Step-by-step explanation:
x=7 +5y
14+16y=−2
y=−1
Substitute y=-1y=−1 into x=7+5yx=7+5y.
x=2
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
multiply 40 by 3/4
40 x 3/4 = 40*3 = 120, 120/4 = 30
he answered 30 correctly
40-30 = 10, he missed 10
