All categories

2 years ago

Excel provides _____ in categories such as financial management and budgets.

Business

1 answer:

a_sh-v [17]2 years ago

7 0

Excel provides <u>Expenses</u> in categories such as financial management and budgets.

Excel is a Microsoft Office application designed to carry out variation functions, including financial analysis.

Microsoft Excel can be used in many ways. When it comes to finances, it can be used for budgeting or costing before a product or project is made, where each expense is categorized under a different heading.

Microsoft Excel can also carry out a valuation of expenses made, with each expense listed under different categories.

Hence, in this case, it is concluded that Microsoft Excel is a vital tool in financial management.

Learn more here: brainly.com/question/23960987

You might be interested in

BBB Company has been a successful manufacturer of quality electronics products for the past 20 years. It is a publicly traded co

OverLord2011 [107]

Answer:

Answer 1.

Beneath referenced pointers show that organization arranged the liquidation for recent years or something like that.

The way that there had been no interest in R&D for recent years which more likely than not brought about noteworthy cost putting something aside for the organization.
BBB bought expanded size of stock on layaway from providers in recent years which is a warning.
Indeed, even without bringing about any R&D cost for recent years, CFO of BBB moved toward the bank to expand the credit line of the organization and utilized all credit line without legitimate desk work.
CFO erroneously guaranteed the brokers about new product offering so as to look for advances/increment credit line.
Indeed, even with diminished deals, organization was indicating lower supply of stock. They more likely than not been offering the stock at cost to outsider or shrouded it at an undisclosed area to dupe the providers.
With no interest in R&D and declining business possibilities, organization couldn't have given new offers for subsidizing

Answer 2.

Yes, even if it is a fraudulent filing for bankruptcy, BBB organization despite everything can select to petition for financial protection or BBB can close the business through and through and escape with the reserve funds and continues from the offer of the stock. Indeed, even leasers and providers reserve the option to petition for automatic insolvency against the BBB in the event that BBB doesn't seek financial protection.

It thoroughly relies upon the BBB Company, in the event that it selects to declare financial insolvency under section 7, or 11 of the liquidation code. Be that as it may, it is just under section 11 liquidation procedures of the chapter 11 court it very well may be set up that BBB's aim and untrustworthy strategic policies establishes to insolvency misrepresentation.

3 0

2 years ago

According to the U.S. Department of Labor Statistics, _____ is the industry earning the highest average annual wage in 2009.

Alchen [17]

Answer:

B. federal government

4 0

3 years ago

Read 2 more answers

In a perpetual average cost system: a. The average is determined by dividing the total number of units sold by the cost of units

Sedaia [141]

In a perpetual average cost system a new weighted-average unit cost is calculated each time additional units are purchased.

Option B is correct

Explanation:

"Average" represents the mean expense of production items from the sale time below the perpetual method. This marginal cost is compounded by the numbers of distribution units, deducted from the stock in the possession and debited to the Expense of Items Sold balance.

Divide the prices of goods available on the market by the amount of available on the market to be using the median weighted practice, which results in the total average cost of units. The cost of the product available on the market is the amount of the original production and net sales in this estimate.

8 0

3 years ago

Each machine must be run by one of 19 cross-trained workers who are each available 35 hours per week. The plant has 10 type 1 ma

Mrac [35]

Answer:

The Linear programming model is given as below

Profit Function: $P=90X+120Y+150Z$

Constraints:

$2X+2Y+Z\leq 400$

$3X+4Y+6Z\leq 240$

$4X+6Y+5Z\leq 320$

$\dfrac{2X+2Y+Z}{40}\leq 10$

$\dfrac{3X+4Y+6Z}{40}\leq 6$

$\dfrac{4X+6Y+5Z}{40}\leq 8$

$\dfrac{2X+2Y+Z}{35}+\dfrac{3X+4Y+6Z}{35}+\dfrac{4X+6Y+5Z}{35}\leq 19$

Explanation:

As the question is not complete, the complete question is found online and is attached herewith.

Let the number of product 1 to be produced is X, that of product 2 is Y and product 3 is Z

so the maximizing function is the profit function which is given as

$P=90X+120Y+150Z$

Now as the number of hours in a week are 40 and there are a total of 10 type 1 machines so the total number of machine 1 hours are 40*10=400 hours

As from the given table product 1 uses 2 machine hours of machine 1, product 2 uses 2 machine hours of machine 1 and product 3 uses 1 hour of machine 1 so

$2X+2Y+Z\leq 400$

Now as the number of hours in a week are 40 and there are a total of 6 type 2 machines so the total number of machine 2 hours are 40*6=240 hours

As from the given table product 1 uses 3 machine hours of machine 2, product 2 uses 4 machine hours of machine 2 and product 3 uses 6 hour of machine 2 so

$3X+4Y+6Z\leq 240$

Now as the number of hours in a week are 40 and there are a total of 8 type 3 machines so the total number of machine 3 hours are 40*8=320 hours

As from the given table product 1 uses 4 machine hours of machine 3, product 2 uses 6 machine hours of machine 3 and product 3 uses 5 hour of machine 3 so

$4X+6Y+5Z\leq 320$

Now as the machine 1 is used as 2X+2Y+Z in a week and the week is of 40 hours so the number of machines to be used are given as

$\dfrac{2X+2Y+Z}{40}\leq 10$

Now as the machine 2 is used as 3X+4Y+6Z in a week and the week is of 40 hours so the number of machines to be used are given as

$\dfrac{3X+4Y+6Z}{40}\leq 6$

Now as the machine 3 is used as 4X+6Y+5Z in a week and the week is of 40 hours so the number of machines to be used are given as

$\dfrac{4X+6Y+5Z}{40}\leq 8$

Now the workers are available for 35 hours so the worker available at the machine 1 is given as

$\dfrac{2X+2Y+Z}{35}$

That of machine 2 is given as

$\dfrac{3X+4Y+6Z}{35}$

That of machine 3 is given as

$\dfrac{4X+6Y+5Z}{35}$

As the total number of workers is 19 so the constraint is given as

$\dfrac{2X+2Y+Z}{35}+\dfrac{3X+4Y+6Z}{35}+\dfrac{4X+6Y+5Z}{35}\leq 19$

So the Linear programming model is given as below

Profit Function: $P=90X+120Y+150Z$

Constraints:

$2X+2Y+Z\leq 400$

$3X+4Y+6Z\leq 240$

$4X+6Y+5Z\leq 320$

$\dfrac{2X+2Y+Z}{40}\leq 10$

$\dfrac{3X+4Y+6Z}{40}\leq 6$

$\dfrac{4X+6Y+5Z}{40}\leq 8$

$\dfrac{2X+2Y+Z}{35}+\dfrac{3X+4Y+6Z}{35}+\dfrac{4X+6Y+5Z}{35}\leq 19$

4 0

3 years ago

On january 1, 2017, holland corporation paid $9 per share to a group of zeeland corporation shareholders to acquire 60,000 share

Illusion [34]

Answer:

Explanation:

a Consideration transferred by $540,000

Holland ($9.00 x 60,000 shares)

Fair value of the non-controlling 320,000

interest ($6.50 x 40,000 shares)

Total Zeeland fair value at January 1, 2017 $860,000

Zeeland book value at January 1, 2017 320,000

Excess acquisition-date fair over book value $540,000

To equipment (5-year remaining life) $50,000

To patent (10-year remaining life) 420,100 470,100

Goodwill $69,900

Goodwill allocation: Holland NCI

Acquisition-date fair value $540,000 $320,000

Share (60% and 40%) of identifiable * 474,060 316,040

net assets

Goodwill allocation $65,940 $3,960

*Zeeland identifiable net assets at acquisition-date fair value:

Current assets $15,700

Property and equipment ($329,700 + $50,000) 379,700

Patents ($212,100 + $420,100) 632,200

Liabilities (237,500)

Total fair value of net identifiable assets $790,100

b Investment in Zeeland

Initial value $540,000

Change in Zeeland’s RE × 60%

($439,400 – $220,000) × 60% 131,640

Excess amortization ($52,010 × 60% × 2 yrs.) (62,412)

Investment in Zeeland 12/31/18 609,228

HOLLAND CORPORATION AND ZEELAND CORPORATION

Consolidation Worksheet

For Year Ending December 31, 2018

Consolidation Entries Noncontrolling Consolidated

Accounts Holland Zeeland Debit Credit Interest Totals

Sales ($582,600) ($445,500) ($1,028,100)

Cost of 295,400 208,500 $503,900

goods sold

Depreciation 73,000 32,300 E 10000 115,300

expense

Amortization 15,700 19,300 E 42010 77,010

expense

Other operating 58,800 58,400 117,200

expenses

Equity in Zeeland -44,994 0 I 44994 0

earnings

Separate company ($184,694) ($127,000)

net income

Consolidated net income ($214,690)

Noncontrolling interest in CNI (29,996) 29,996

Controlling interest net income ($184,694)

Retained earnings ($821,900) ($342,400) S 342400 ($821,900)

, 1/1/18

Net income -184,694 -127,000 ($184,694)

Dividends declared 50,000 30,000 D 18000 12000 50000

Retained earnings, ($956,594) ($439,400) ($956,594)

12/31

Current assets $126,700 $98,500 $225,200

Investment in 609,228 0 D 18000 S 265,440

Zeeland, Inc

A1 250854

A2 65940

I 44994

Property and 854,000 276,000 A1 40000 E 10000 1,160,000

equipment (net)

Patents 152,400 168,500 A1 378090 E 42010 656,980

Goodwill 0 0 69900 69,900

Total assets $1,742,328 $543,000 $2,112,080

Liabilities -465,734 -3,600 -469,334

Common stock -320,000 -100,000 S 100000 -320000

Noncontrolling S 176960

interest

A1 167236

A2 3960 -348156 -366152

Retained earnings -956,594 -439,400 -956594

, 12/31

Total ($1,742,328) ($543,000) $1,045,394 $1,045,394 ($2,112,080)

liabilities and equities

6 0

3 years ago