answer.
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
algol13
1 year ago
6

Each service starts on a different date because the services depend on each other. Enter the starting dates for the remaining se

rvices as follows:
a. In cell D6, enter a formula without using a function that adds 4 days to the value in cell 06.
b. In cell E6, enter a formula without using a function that subtracts 3 days from the value in cell C6
c. In cell F6, enter a formula without using a function that adds 2 days to the value in cell E6
d. In cell G6, enter a formula without using a function that adds 2 days to the value in cell C6.
Business
1 answer:
gladu [14]1 year ago
7 0

Answer:

a. Copy the range of cell D7:D9 then select cell D6 and paste the selection with date format selected. The function will be represented in formula bar with adding +4;365 days.

b. Copy the range of cell D7:D9 then select cell D6 and paste the selection with date format selected. The function will be represented in formula bar with adding -3;365 days.

c. In the formula bar type =365 days; +2 : E6

d. In the formula bar type =365 days ; +2 : C6

Explanation:

Excel is a software which helps the users to easily calculate complex calculation with just one function input. The users can create worksheets using the excel and then link those worksheets with each other. The data can be displayed in the form of table or simple text. It has multiple options to create annual day wise filtered worksheets.

You might be interested in
On January 1, 2020, the Oriole Company had $2,990,000 of $10 par value common stock outstanding that was issued at par and Retai
amm1812

Answer:

Oriole Company

Journal Entries:

July 1:

Debit Cash Account $2,336,000

Credit Common Stock $1,460,000

Credit Paid-in In Excess of Common Stock $876,000

To record the issuance of 146,000 shares of common stock, par $10 at $16 per share.

December 15:

Debit Retained Earnings $445,000

Stock Dividends Payable $445,000

To record the declaration of a 10% stock dividend.

Explanation:

a) Stockholders of record on December 31, 2020:

Number of shares in issue at beginning 299,000

Number of shares issued on July 1          146,000

Total                                                          445,000

10% of 445,000 = 44,500 shares

b) Stock Dividends declared on December 15 will result to the issuance of 44,500 shares to stockholders.  To finance this stock dividend, the Retained Earnings account is debited while the Stock Dividends Payable is credited.  When the shares are issued on January 15, the Stock Dividends Payable (Distributable) will be debited and the Common Stock credited with the par value.  The market price of $17 does not affect the company's records.

8 0
2 years ago
Wolfpack, Inc.provides goods and services to customers during the year totaling $100,000. Also during the year, customers are gr
inna [77]

Answer: $75000

Explanation:

Net revenue is simply defined as the total amount of money that an economic entity such as an individual or firm makes from sales minus the direct expenses. The net revenue accounts for the refunds, price reductions, and the direct expenses.

From the question, we've been informed that Wolfpack, Inc.provides goods and services to customers during the year totaling $100,000 and that during the year, customers are granted discounts, returns, and allowance of $20,000. Lastly, Wolfpack estimates that an additional $5,000 in discounts, returns, and allowances will occur next year.

The amount of net revenues Wolfpack will report in its current-year income statement will be:

= $100,000 - $20,000 - $5,0000

= $75,000

7 0
2 years ago
Warner Company's year-end unadjusted trial balance shows accounts receivable of $99,000, allowance for doubtful accounts of $600
dsp73

Explanation:

The journal entry to record the uncollectible is shown below:

On December 31

Bad debt expense $800

        To Allowance for doubtful debts $800

(Being the bad debt expense is recorded)

The computation is shown below:

= Sales × estimated percentage - credit balance of doubtful accounts

= $280,000 × 0.5% - $600

= $1,400 - $600

= $800

5 0
1 year ago
Assume you are the CEO of Black Diamond, a global organization. You realize that some of the people in your organization are hig
const2013 [10]

Answer:

a. High uncertainty avoidance.

Explanation:

Cultures that have high uncertainty avoidance have a low tolerance for situations that are unclear and vague. They tend to avoid risk, follow laid down rules, and favor well structured environments.

People from cultures with high uncertainty avoidance will be ideal for the Black Diamond team. They will function well in a structured team where members collaborate to achieve set goals.

3 0
2 years ago
Four roommates are planning to spend the weekend in their dorm room watching old movies, and they are debating how many to watch
gulaghasi [49]

Answer:

See the five answers below.

Explanation:

The roommates are debating how many movies they should watch.

This is the constraint; given that they have to pay to rent each movie.

<u>PART (A)</u>

Since their dormitory room is the 'cinema', meaning that it's just going to be 4 of them and a private good that they'll pay for; then the showing of a movie is not a public good!

Public goods are those general utilities usually provided by governments, for their citizens; e.g. public defense, clean drinking water, good roads, etcetera.

<u>PART (B)</u>

Given the 'willingness to pay' constraint, we need to find the optimal number of movies they can watch. It costs $8 to rent a movie, no matter how interesting it is or how much satisfaction the viewers derive from it. So the cost of the 1st film = the cost of the 2nd film = the cost of the 3rd film = the cost of the 4th film = the cost of the 5th film.

To get the total amount they're willing to pay for all 5 movies, sum up!

(10+9+6+3) + (9+7+4+2) + (8+5+2+1) + (7+3+0+0) + (6+1+0+0)

KEY: This arrangement should remind you of the law of diminishing marginal utility. The more movies they watch in one sitting or over a weekend, the less satisfaction they derive from the intangible commodity. Hence, the less they are willing to pay for more of the commodity.

So the sum is 28 + 22 + 16 + 10 + 7  =  83

Now to get the number of movies they should rent if they wish to maximize their total spending, divide the total willingness to pay by the cost for a movie:

83/8 = 10.375

Rounding up to the nearest whole number or in reality, that's 10 movies.

<u>PART (C)</u>

Suppose the roommates choose to rent this optimal number of movies - which is higher than the intended number of movies - and then split the cost equally, what will each roommate pay?

Here, we will use the approximated value 10.

10movies  x  $8  =  $80

Splitting the cost equally, divide by 4

$80 ÷ 4  = $20

This figure is just in obedience to the question's requirements which says the bill must be shared equally. In actual fact, some of the four roommates don't have a purchasing power or willingness that is up to $20! That's Felix and Larry.

<u>PART (D)</u>

Complete the given table by inputing each roommate's total willingness to pay for the 5 movies and the surplus each person obtains from watching the movies. Remember to assume that Van is the same person as Raphael.

Also, total cost for 5 movies is 8 x 5 = $40

Dividing this by 4, you have $10 per roommate. So a surplus would be the excess of each roommate's TWTP over $10.

                      <u>  TWTP($)          CS($)</u>

VAN                    40                   30

CARLOS             25                    15

FELIX                  12                      2

LARRY                 6                      -4

<u>PART (E)</u>

If the cost is divided up based on the benefits (remember how the price for movie was static despite the movie and satisfaction received by each viewer? That's about to change) or satisfaction each roommate receives, the practical problem with this 'solution' is that each roommate has an incentive to reduce the value of the movies to him; and this can only be measured by the efficient number (the number that rates the value each roommate derives from each movie). In this case, the incentive is the window given to each roommate to 'not tell the truth' about their level of satisfaction from watching each movie, because that would mean a higher bill for the individual.

KUDOS!

4 0
2 years ago
Other questions:
  • Assume Countries A, B, and C produce goods that are substitutes of each other and that these countries engage in trade with each
    10·1 answer
  • Brad purchased a company that is not profitable. What are two courses of action he could take to boost profits in the company?
    15·2 answers
  • The Human Resources department of Superior Catering conducted a training workshop on setting and achieving organization goals. D
    10·1 answer
  • Guillen, Inc. began work on a $7,000,000 contract in 2020 to construct an office building. Guillen uses the completed-contract m
    11·1 answer
  • Eleven years ago, Lynn Inc. purchased a warehouse for $315,000. This year, the corporation sold the warehouse to Firm D for $80,
    9·1 answer
  • A wood products firm uses available time at the end of each week to make goods for stock. Currently, two products on the list of
    9·1 answer
  • Tharaldson Corporation makes a product with the following standard costs: Standard Quantity or Hours Standard Price or Rate Stan
    13·1 answer
  • Recruitment sources are unlimited; therefore, an organization must decide how to reach the best sources of potential employees.
    10·1 answer
  • A car dealer acquires a used car for $12,000, with terms FOB shipping point. Compute total inventory costs assigned to the used
    13·1 answer
  • The charter of Vista West Corporation specifies that it is authorized to issue 209,000 shares of common stock. Since the company
    6·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!