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
Leokris [45]
3 years ago
11

Which formula can you use to extract the month number from the date entered in cell F5 as July 8, 2016?

Business
1 answer:
morpeh [17]3 years ago
5 0

Answer: =MONTH(F5)

Explanation:

The MONTH function in Excel returns the month, a number from 1 (January) to 12 (December).

It’s syntax is;

“=MONTH(serial_number)”

Where serial number refers to the date in question, which could either be a date itself or a cell reference.

The MONTH function is used to extract the month number from a date.

If cell F5 contains “July 8, 2016”, the formula “=MONTH(F5)” inputed in another cell will give the value “7”.

This is because the month July is the 7th month of the year.

You might be interested in
Excel Memory Company can sell all units of computer memory X and Y that it can produce, but it has limited production capacity.
KiRa [710]

Answer:

1. Contribution Margin per production hour

Product X = $12, Product Y = $15

2. Allocate all production capacity to product Y to generate $60,000 contribution

Explanation:

Step 1: Calculate The Contribution margin Per Production Hour

Product X,

= Contribution Margin per unit = $6

Number of Unit Produced in 1 hour= 2

Contrbution Per 1 Hour = $6 x 2 = $12

Product Y,

= Contribution Margin per unit = $5

Number of Unit Produced per  hour= 3 units

Contrbution Per  Hour = $5 x 3 = $15

Step 2: Calculate the Most Profitable Sales Mix

Option 1: Allocate all production capacity to product x

Number of Hours available = 4000 hours

Total Contribution = Contribution on hourly basis x total number of hours

Total Contribution = 12 x 4000= $48,000

Option 2: Allocate all production capacity to product Y

Number of Hours available = 4000 hours

Total Contribution = Contribution on hourly basis x total number of hours

Total Contribution = 15 x 4000= $60,000

Option 3: Allocate 40% of Capacity to Product X

Hours of total hours for product X = 40% x 4000 = 1600

Hours of toal hours for Product Y = 60% x 4000= 2400

Contribution therefore:

X= 12 x 1600= $19,200

Y= 15 x 2400= $36,000

Total Mix= $55,200

Option 4: Allocate 24% of Capacity to Product Y

Hours of total hours for product X = 76% x 4000 = 3040

Hours of toal hours for Product Y = 24% x 4000= 960

Contribution therefore:

X= 12 x 3040= $36,480

Y= 15 x 960= $14,400

Total Mix= $50,880

The Most Profitable Sales Mix is to allocate all Capacity to Product Y to generate $60,000

5 0
3 years ago
Suppose 2 athletes sign 10-year contracts for $80 million. In one case, we're told that the $80 million will be paid in 10 equal
maxonik [38]

Answer:

player 2 is signing a better contract

Explanation:

the present value of an annuity (player 1) = annual payment x annuity factor

assuming that the interest rate is 10%

present value = $10 million x 6.1446 (PV annuity factor, 10%, 10 periods) = $61.446 million

player 2's contract

the present value of a growing annuity = [payment / (i - g)] x {1 - [(1 + g) / (1 + i)]ⁿ} = [$10 / (10% - 5%)] x {1 - [(1 + 5%) / (1 + 10%)]¹⁰} = $200 x 0.372 = $74.398 million

4 0
3 years ago
What to do with office space to make money? How would you arrange them?
hoa [83]

Answer:

a bigger space

Explanation:

a bigger space because u have a alot to do. you can have more people working. or if it private then a room for secretary and your office in the business

7 0
3 years ago
Grameen Bank extends credit to the very poor to give them the opportunity to build better lives. Other businesses target poor pe
Dvinal [7]

Explanation:

Grameen bank is one of the pioneers in the world of Micro Finance Institutes, which not only provides the poor with access to financial capital but also helps them build a better business which allows them to escape from the poverty cycle. This lead to an overall upward economic movement in the society, improving the economic condition of a country as a whole. Through these micro finance loans, a number of SMEs (Small and Medium Enterprises) emerges which further provide employment opportunities to other people thus starting a virtuous cycle of economic growth.

As the economic condition of the poor becomes better, these poor people inturn becomes customer for these business for other products thus being a huge source of profit.

8 0
2 years ago
Exercise 11-13A Calculate financing cash flows (LO11-5) Dristell Inc. had the following activities during the year (all transact
Scilla [17]

Answer:

The net cash flows from financing activities is -$45,000

Explanation:

The computation of the net cash flows from financing activities is shown below:

=  Additional common stock issued - purchase of treasury stock - dividend paid - long term note payable issued

= $160,000 - $75,000 - $40,000 - $90,000

= -$45,000

The other items which are mentioned in the question have come under the investing activities

3 0
3 years ago
Other questions:
  • In an effort to reduce pipe breakage, water hammer, and product agitation, a French chemical company plans to install several ch
    6·1 answer
  • g on january 1 playa company acquires 90 percent ownership in seaside corporation for 180,000 the fair value of noncontrolling i
    9·1 answer
  • . Due to a car accident you receive a settlement from insurance of $50 a month for the next ten years. What is that worth to you
    9·1 answer
  • Yocum Company purchased equipment on January 1 at a list price of $120,000 and received a $2,400 cash discount. Yocum paid $6,00
    12·1 answer
  • ?????????????????????????help
    9·1 answer
  • A fatal accident at the production facility of GA Inc., a mobile manufacturer, has killed 58 factory workers. The company is now
    9·1 answer
  • Read the following sources and decide which have characteristics of reliable and unreliable information.
    13·1 answer
  • A grievance isGroup of answer choicesan implication that management has broken a management-union agreement, but it must be prov
    9·1 answer
  • Mrs. Jones offers a reward for the return of her dog Fifi and puts posters advertising the reward all over her neighborhood. Mr.
    10·1 answer
  • When a seismic wave crosses a boundary, it will change directions in the process of
    15·2 answers
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!