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
Sonbull [250]
3 years ago
7

How do u calculate the bill total for the week by summing the daily bill amounts

Business
1 answer:
tino4ka555 [31]3 years ago
3 0

Answer:

Calculating the bill total for the week:

The Sum Function in excel is a very easy mathematical operation to sum the daily bill amounts.  In the cell for the sum, you can manually enter the sum function by typing (=sum), then you define the parameters (=sum(C50:I50).  One you press the "enter" the result is automatically displayed.  This can also be automatically done by pressing the Sum Function on the Ribbon or Alt + =.

Explanation:

In Microsoft Excel, the Sum Function is a mathematical operation or syntax that provides the formula for adding, subtracting, or getting the total numerical content of indicated cells. With the Sum Function of Excel you can add, subtract, multiply, and divide, for example A1 * A4, C20/A2, A4 - A5, and so on.

You might be interested in
The following information applies to the questions displayed below] A local Chevrolet dealership carries the following types of
myrzilka [38]

Answer:

Chevrolet Dealership

A) The total cost of the entire inventory is:

= $575,000

B) Each inventory would be reported at the LCNRV:

Inventory Items  Quantity  Reporting Cost/Value

Vans                        4              NRV

Trucks                     7              NRV

2-door sedans        3              Cost

4-door sedans        5              Cost

Sports cars              1              Cost

SUVs                       6              NRV

C) Journal Entry:

Debit Cost of goods sold $27,000

Credit Inventory $27,000

To write-down costs to net realizable values.

D) TRUE.

Explanation:

a) Data and Calculations:

Inventory Items  Quantity    Cost per unit      NRV per Unit      LCNRV

Vans                        4           27000 $108,000      25000        $100,000

Trucks                     7            18000   126,000       17000           119,000

2-door sedans        3           13000     39,000      15000            39,000

4-door sedans        5           17000     85,000     20000            85,000

Sports cars              1          37000      37,000     40000            37,000

SUVs                       6         30000    180,000     28000           168,000

Total Cost                                      $575,000                         $548,000

3 0
3 years ago
Many cities in southeast Michigan are struggling with financial problems due to current economic conditions. At the same time, s
asambeis [7]
The best and most correct answer among the choices provided by the question is the third choice. The direct result of the problems is that <span>less city workers to plow the streets causing an increase in the number of car accidents during the winter months. </span>I hope my answer has come to your help. God bless and have a nice day ahead!
3 0
3 years ago
A waiter believes the distribution of his tips has a model that is slightly skewed to the left​, with a mean of ​$8.90 and a sta
postnew [5]

Answer:

A. 0.3204    B. $14.669

Explanation:

Mean = 8.9      SD = 4.5

Required probability = P (X >/= 550/50)

P(X>/=11) = 1 - P[(X - mean/SD) < (11 - mean)/SD]

              = 1 - P(Z < (11-8.9)/4.5)

P(X>/=11) = 1 - P(Z < 0.4666667)

Using Excel NORMDIST(0.4666667,0,1,1)

P(X>/=11) = 1 - 0.6796 = 0.3204

The probability that she will earn at least $550 = 0.3204

b. P ( X  >  x )  =  0.10

1  −  P ( X  −  mean)/SD  ≤  (x  −  mean) /SD = 0.10

P ( Z  ≤  z )  =  0.90

Where,

z  =  (x  −  mean )/SD

Excel function for the value of z:

=NORMSINV(0.9)

=1.282

Hence (x - mean)/SD = 1.282

= (x - 8.9)/4.5 = 1.282

x = (1.282*4.5) + 8.9

x = 14.669

He earns $14.669 on the best 10% of such weekends.

3 0
3 years ago
The marketing department of a reputable firm wants to improve strategic decision making, track the actions of other players in t
Snowcat [4.5K]

Answer:

The answer is C. competitive marketing intelligence

Explanation:

Competitive marketing intelligence may be a powerful research-based method employed by a company to collect, analyze, and use information collected on competitors, economic conditions, customers etc to a achieve business's competitive advantage.

The information-gathering analysis process can help a corporation develop its strategy or identify competitive gaps. It identifies threats and opportunities within the business

3 0
3 years ago
A company assigns overhead cost to completed jobs on the basis of 113% of direct labor cost.the job cost sheet for job 313 shows
Zielflug [23.3K]

A) total manufacturing cost
10,500×(113÷100)=11,865

B) total manufacturing cost
27,235+10,500+11,865=49,600
the unit product cost for job 313
49,600÷1,600=31

Hope it helps!

4 0
3 years ago
Other questions:
  • Barbara needs to add more staff in order to complete her project on time. Which pathway would best aid Barbara in finding qualif
    5·2 answers
  • "In the context of international trade, _____ is defined as selling goods in a foreign market at a price below their costs of pr
    12·1 answer
  • When either prices go down or income goes up, there is an increase in which
    10·2 answers
  • You are the operations manager of a firm that uses the continuous-review inventory control system. Suppose the firm operates 52
    9·1 answer
  • Sam has contracted with dave to purchase dave's racing bike, with payment and delivery of the bicycle to be in 10 days. three da
    9·1 answer
  • Rita Company buys merchandise on account from Linus Company for $590. Rita sells the goods to Ellis for $900 cash. Use a tabular
    6·1 answer
  • Kendra Enterprises has never paid a dividend. Free cash flow is projected to be $80,000 and $100,000 for the next 2 years, respe
    6·1 answer
  • 1.1.11 Advise SM on the negative impact of the socio economic issues identified in QUESTION 1.1.10 (6 )​
    9·1 answer
  • According to the master syllabus, should you purchase outside textbooks for the courses?
    10·1 answer
  • In the product markets of the circular flow model, households provide __________ to the business sector in exchange for goods an
    10·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!