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
Tems11 [23]
2 years ago
7

Wheeling company is a merchandiser that provided a balance sheet as of september 30 as shown below:

Business
1 answer:
likoan [24]2 years ago
3 0

Answer:

Wheeling Company is a merchandiser that provided a balance sheet as of September 30 as shown below:

Cash $69,800, Accounts Receivable 98,000, Inventory 37,800, Building and Equipment, net of depreciation 310,000 Total Assets 515,600. Accounts payable $145,100, Common Stock 216,000, and Retained Earnings 154,500, Total Liabilities and Equity 515,600

The company is in the process of preparing a budget for October and has assembled the following data:

Sales are budgeted at $280,000 for October and $290,000 for November. Of these sales, 35% will be for cash; the remainder will be credit sales. Forty percent of a month’s credit sales are collected in the month the sales are made, and the remaining 60% is collected in the following month. All of the September 30 accounts receivable will be collected in October.

The budgeted cost of goods sold is always 45% of sales and the ending merchandise inventory is always 30% of the following month’s cost of goods sold.

All merchandise purchases are on account. Thirty percent of all purchases are paid for in the month of purchase and 70% are paid for in the following month. All of the September 30 accounts payable to suppliers will be paid during October.

Selling and administrative expenses for October are budgeted at$80,000, exclusive of depreciation. These expenses will be paid in cash. Depreciation is budgeted at $3,100 for the month.

Required:

1. Using the information provided, calculate or prepare the following:

a. The budgeted cash collections for October.

b. The budgeted merchandise purchases for October.

c. The budgeted cash disbursements for merchandise purchases for October.

d. The budgeted net operating income for October.

e. A budgeted balance sheet at October 31.

Solution:

1)

a. The budgeted cash collections for October:

Cash Sales 35% of $280,000               =   $98,000

Cash Collection 40% of 65% $280,000 = $72,800

September Receivables                        =   $98,000

Total                                                          $268,800

b. The budgeted merchandise purchases for October:

Cost of Goods Sold: 45% of $280,000      = $126,000

Ending Inventory: 30% of 45% $290,000  =   $39,150

Total Cost of Goods Available for sale       =  $165,150

Less Beginning Inventory                            =   $37,800

Purchases for the month                             = $127,350

c. Merchandise Cash Disbursements for October:

October: 30% of $127,350         =  $38,205

September Accounts Payable    = $145,100

Total                                             = $183,305

d. The budgeted net operating income for October.

Sales                                    $280,000

Cost of Sales                          126,000

Gross profit                            154,000

Less Selling & Admin.            (80,000 )

Less Depreciation on Equip.    (3,100 )

Net Income                              70,900

e. A budgeted balance sheet at October 31.

Cash                                      $75,295

Accounts Receivable            109,200

Inventory                                39,150

Building and Equipment      310,000  

Total Assets                       $533,645

Accounts payable                  $89,145

Common Stock                      216,000

Retained Earnings                225,400

Depreciation                              3,100

Total Liabilities & Equity    $533,645

(2) 50% of a month’s credit sales are collected in the month the sales are made and the remaining 50% is collected in the following month, (2) the ending merchandise inventory is always 10% of the following month’s cost of goods sold, and (3) 20% of all purchases are paid for in the month of purchase and 80% are paid for in the following month. Using these new assumptions, calculate or prepare the following:

a. The budgeted cash collections for October:

Cash Sales 35% of $280,000         =          $98,000

Cash Collection 50% of 65% $280,000 =  $91,000

September Receivables                  =          $98,000

Total                                                            $287,000

b. The budgeted merchandise purchases for October:

Cost of Goods Sold: 45% of $280,000      = $126,000

Ending Inventory: 10% of 45% $290,000   =   $13,050

Total Cost of Goods Available for sale       = $139,050

Less Beginning Inventory                           =   $37,800

Purchases for the month                            =  $101,250

c. The budgeted cash disbursements for merchandise purchases for October:

Cash October: 20% of $101,250 =  $20,250

September Accounts Payable     = $145,100

Total                                              = $165,350

d. The budgeted net operating income for October:

Sales                                  $280,000

Cost of Sales                       126,000

Gross profit                         154,000

Less Selling & Admin          (80,000 )

Less Depreciation                 (3,100 )

Net Income                          70,900  

e. A budgeted balance sheet at October 31:

Cash                                      $111,450

Accounts Receivable                91,000

Inventory                                  13,050

Building and Equipment        310,000  

Total Assets                         $525,500

Accounts payable                 $81,000

Common Stock                     216,000

Retained Earnings                225,400

Depreciation                              3,100

Total Liabilities & Equity    $525,500

Explanation:

1. Cash Budget:

Beginning Balance $69,800

Cash Collections   $268,800

Cash Disbursement: $263,305

  Merchandise    $183,305

  Selling & Admin $80,000

Ending Balance $75,295

2. Accounts Receivable = 60% of 65% of $280,000 = $109,200

3. Accounts Payable = 70% of $127,350 = $89,145

4. Retained Earnings = $154,500 + 70,900 = $225,400

5. Cash Budget:

Beginning Balance $69,800

Cash Collections   $287,000

Cash Disbursement: $245,350

  Merchandise    $165,350

  Selling & Admin $80,000

Ending Balance $111,450

6. Accounts Receivable = 50% of 65% of $280,000 = $91,000

7. Accounts Payable = 80% of $101,250 = $81,000

8. Retained Earnings = $154,500 + 70,900 = $225,400

You might be interested in
About 35 percent of online consumers are interested in customizing product features or in purchasing build-to-order products tha
yaroslaw [1]

Answer: (D) Form Utility

Explanation:

  The form utility is one of the type of concept that helps in increasing the actual value of the products in the market and in the form utility following example are the type of finished product that the customers are willing to purchase are as follows:

  • Electronics products
  • Furniture type goods
  • Parts of vehicle

According to the given question, the given situation is helps in demonstrating that the electronic commerce plays an important contribution to the consumers value by the creating of the form utility.

 Therefore, Option (D) is correct answer.        

5 0
3 years ago
Which of the following is a common finding in looking at the statement of cash flows of a declining company?
mario62 [17]

Answer:

These are the options for the question:

a) A negative cash flow from operating activities

b) A negative cash flow from investing activities

c) A significant positive cash flow from financing activities

And this is the correct answer:

a) A negative cash flow from operating activities

Explanation:

Declining companies are characterized by a lack of revenue from regular operating activities.

If cash flow from operating activities is negative, it means that the company is not making enough money to meet its obligations, and that will likely cease to exist in the near future unless big changes happen.

5 0
3 years ago
A construction firm cannot obtain the necessary permits to begin building a shopping mall until it can show it either has or wil
Crazy boy [7]

Answer: Loan commitment or credit line

Explanation: A loan commitment refers to a promise under which the lender commit to provide a loan of a specified amount to the borrower. Similarly, a credit line refers to the amount of money that a credit card holder can use from that account.

In the given case, the construction firm wants to show that they can have necessary funding. Thus, they can use above tools to show that they have the back of banks in case of providing funding.

Thus, the correct option is C or D .

8 0
3 years ago
One of your customer accounts is a trust account. The trustee of the trust is inexperienced in investing.
Alinara [238K]

Answer:

A) The duty to diversify the trust portfolio to reduce risk

Explanation:

The Uniform Prudent Investor Act (UPIA) requires trustees to make investments following the Prudent Person Rule. This means that trustees should invest the trust funds as if the trustee was a prudent person investing his/her own assets.

The best way to comply with the prudent person rule is to invest in a diversified portfolio that reduces risk.

7 0
3 years ago
An investor must decide between putting $2,000 into a regular retirement plan or putting $1,440 into a Roth retirement plan. If
Novosadov [1.4K]

Answer:

They both produced the same cash amount

Explanation:

The regular retirement would have its deducted after withdrawal from the plan while Roth retirement plan's tax would have been deducted prior to investing funds in the plan

The future value of the $2000 is computed thus:

FV=PV*(1+r)^n

PV is the amount saved in the plan which is $2000

r is the growth rate of the funds in the plan which is 12%

n is the number of years the amount would be left in the plan

FV=$2000*(1+12%)^20=$ 19,292.59  

After tax amount=$ 19,292.59*(1-28%)=$ 13,890.66  

The future value of the $1,440 is computed thus:

FV=$1,440*(1+12%)^20=$ 13,890.66  

The Roth plan has not tax implication thereafter as tax was paid before savings.

7 0
3 years ago
Other questions:
  • Clement applies for a home loan at Global Bank Inc. As part of the process, he provides his personal details to the banker who i
    11·1 answer
  • On July 1, 2018, Crane Company issued for $9450000 a total of 90000 shares of $100 par value, 8% noncumulative preferred stock a
    7·1 answer
  • Q 7.28: A multi-location flower shop receives payment from customers in person, over the Internet, and through the mail. When ch
    12·1 answer
  • Adina deposits $1,000 in the bank. The bank can then use her savings to make _____ to/for _____.
    6·2 answers
  • On January 1, 2017, Dawson, Incorporated, paid $100,000 for a 30% interest in Sacco Corporation. This investee had assets with a
    9·1 answer
  • The manager of a major retail store has taken a random sample of 25 customers. The average sale was $52.50. The population stand
    14·1 answer
  • In March, Stinson Company completes Jobs 10 and 11.
    5·1 answer
  • Farris Billiard Supply sells all types of billiard equipment, and is considering manufacturing their own brand of pool cues. Mys
    8·1 answer
  • What step is most important for sellers to focus on.
    7·1 answer
  • Name any three (3) tests that Hornbill Holdings can use to assess the graduates
    14·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!