How do you change the number of rows and columns displayed for an embedded Excel object on a PowerPoint slide?

Zarrin [17]

Answer:

Q. Gear Up Co. pays 65% of its purchases in the month of purchase, 30% in the month after the purchase, and 5% in the second month following the purchase. What are the cash payments if it made the following purchases in 2018?

February 2018 $90,000, March 2018 92,000, April 2018 101,000, May 2018 98,000, June 2018 99,500.

Answer) $440,775

Explanation:

Cash payments to be made in 2018 for the purchases given in question are:

Feb 2018 Mar 2018 Apr 2018 May 2018 June 2018

Cash Payments

65% of $90,000 58,500

30% of $90,000 27,000

5% of $90,000 4,500

65% of $92,000 59,800

30% of $92,000 27,600

5% of $92,000 4,600

65% of $101,000 65,650

30% of $101,000 30,300

5% of $101,000 5,050

65% of $98,000 63,700

30% of $98,000 29,400

65% of $99,500 64,675

Total $58,500 $86,800 $97,750 $98,600 $99,125

Total payments in 2018=$440,775

(58,500+86,800+97,750+98,600+99,125)

3 0

3 years ago

Donavan spent the day talking with a packaging company in Guam, a lighting specialist in Japan, a touchpad expert in the U.S., a

leva [86]

Answer:

C, distributed product development

Explanation:

Distributed product development can simply be defined as the distribution of the different parts/components of a product to different firms. Distributed product development is usually done when the best of partners are being consulted over a product. Te other firms usually are the best in the production of the components of the product and as such might not be based in the home country of the product's parent company.

From the above question, it is seen that Donavan is speaking to different companies all of the world as regards his product's components. The companies are the best in what they do and he has to have each of them contribute their best ideas to his product.

Cheers.

8 0

3 years ago

Plum Corporation began the month of May with $1,400,000 of current assets, a current ratio of 1.90:1, and an acid-test ratio of

matrenka [14]

Answer:

Plum Corporation

(1) current ratio = Current assets/current liabilities

(2) acid-test ratio = (Current asset -Inventory)/Current liabilities

(3) working capital = Current assets minus Current liabilities

(4) acid-test assets = quick assets

May 2 Purchased $75,000 of merchandise inventory on credit.

Current Assets: $1,400,000 + $75,000 = $1,475,000

Current Liabilities: $737,000 + $75,000 = $812,000

Inventory: $147,000 +$75,000 = $222,000

(1) current ratio = $1,475,000/$812,000

= 1.82:1

(2) acid-test ratio = $1,475,000 - $222,000/$812,000

= 1.54:1

(3) working capital = Current Assets - Current Liabilities

= $1,475,000 - $812,000

= $663,000

May 8 Sold merchandise inventory that cost $55,000 for $150,000 cash.

Current Assets: $1,475,000 -55,000 + 150,000 = $1,570,000

Current Liabilities: $812,000

Inventory: $222,000 - 55,000 = $167,000

Quick Assets = $1,570,000 - 167,000 = $1,403,000

(1) current ratio = $1,570,000/$812,000

= 1.93

(2) acid-test ratio = $1,403,000/$812,000

= 1.73

(3) working capital = $1,570,000 - $812,000

= $758,000

May 10 Collected $26,000 cash on an account receivable.

Current Assets: $1,570,000 ($26,000 - $26,000) = $1,570,000

Current Liabilities: $812,000

Inventory: 167,000

Quick Assets = $1,570,000 - 167,000 = $1,403,000

(1) current ratio = $1,570,000/$812,000

= 1.93

(2) acid-test ratio = $1,403,000/$812,000

= 1.73

(3) working capital = $1,570,000 - $812,000

= $758,000

May 15 Paid $29,500 cash to settle an account payable.

Current Assets: $1,570,000 - $29,500 = $1,540,500

Current Liabilities: $812,000 - $29,500 = $782,500

Inventory: 167,000

Quick Assets = $1,540,500 - 167,000 = $1,373,500

(1) current ratio = $1,540,500/$782,500

= 1.97:1

(2) acid-test ratio = $1,373,500/$782,500

= 1.76:1

(3) working capital = $1,540,500 - $782,500

= $758,000

May 17 Wrote off a $5,000 bad debt against the Allowance for Doubtful Accounts account.

Current Assets: $1,540,500 - $5,000 = $1,535,500

Current Liabilities: $782,500

Inventory: 167,000

Quick Assets = $1,535,500 - 167,000 = $1,368,500

(1) current ratio = $1,535,500/$782,500

= 1.96:1

(2) acid-test ratio = $1,535,500/$782,500

= $1.96:1

(3) working capital = $1,535,500 - $782,500

=$753,000

May 22 Declared a $1 per share cash dividend on its 69,000 shares of outstanding common stock.

Current Assets: $1,535,500

Current Liabilities: $782,500

Inventory: 167,000

Quick Assets = $1,535,500 - 167,000 = $1,368,500

(1) current ratio = $1,535,500/$782,500

= 1.96:1

(2) acid-test ratio = $1,535,500/$782,500

= $1.96:1

(3) working capital = $1,535,500 - $782,500

=$753,000

May 26 Paid the dividend declared on May 22.

Current Assets: $1,535,500 -$69,000 = $1,466,500

Current Liabilities: $782,500

Inventory: 167,000

Quick Assets = $1,466,500 - 167,000 = $1,299,500

(1) current ratio = $1,466,500/$782,500

= 1.87:1

(2) acid-test ratio = $1,299,500/$782,500

= 1.66:1

(3) working capital = $1,466,500 - $782,500

= $684,000

May 27 Borrowed $120,000 cash by giving the bank a 30-day, 10% note.

Current Assets: $1,466,500 + $120,000 = $1,586,500

Current Liabilities: $782,500 + $120,000 = $902,500

Inventory: 167,000

Quick Assets = $1,586,500 - 167,000 = $1,419,500

(1) current ratio = $1,586,500/$902,500

= 1.76

(2) acid-test ratio = $1,419,500/$902,500

= 1.57

(3) working capital = $1,586,500 - $902,500

= $684,000

May 28 Borrowed $135,000 cash by signing a long-term secured note.

Current Assets: $1,586,500 + $135,000= $1,721,500

Current Liabilities: $902,500

Inventory: 167,000

Quick Assets = $1,721,500 - 167,000 = $1,554,500

(1) current ratio = $1,721,500/$902,500

= 1.91:1

(2) acid-test ratio = $1,554,500/$902,500

= 1.72

(3) working capital = $1,721,500 - $902,500

= $819,000

May 29 Used the $255,000 cash proceeds from the notes to buy new machinery.

Current Assets: $1,721,500 - $255,000 = $1,466,500

Current Liabilities: $902,500

Inventory: 167,000

Quick Assets = $1,466,500 - 167,000 = $1,299,500

(1) current ratio = $1,466,500/$902,500

= 1.62:1

(2) acid-test ratio = $1,299,500/$902,500

= 1.44:1

(3) working capital = $1,466,500 - $902,500

= $564,000

Explanation:

a) Data and Calculations:

May 1, Current Assets = $1,400,000

Ratio of current assets to current liabilities = 1.90:1

Acid -test ratio = 1.70:1

Therefore, current liabilities = $1,400,000/1.9 = $737,000

Current Assets minus Inventory/$737,000 = 1.7

Therefore, current assets minus inventory = $737,000 * 1.7 = 1,253,000

Inventory = Current Assets - (Current assets -inventory)

= $1,400,000 - $1,253,000

= $147,000

3 0

3 years ago

Read 2 more answers

15 points please help

arsen [322]

Answer:nenhuma das questões a cima

Explanation:

8 0

1 year ago

Scenario: You have advised the owner of Bond's Gym that the best thing to do would be to raise the price of a monthly membership

Lyrx [107]

Current members will pay more per month.

The quantity demanded for memberships will decrease.

The owner will make more money.

7 0

3 years ago

Read 2 more answers