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
frosja888 [35]
3 years ago
5

Built-Tight is preparing its master budget for the quarter ended September 30. Budgeted sales and cash payments for product cost

s for the quarter follow: JulyAugustSeptemberBudgeted sales$64,000 $80,000 $48,000 Budgeted cash payments for Direct materials 16,160 13,440 13,760 Direct labor 4,040 3,360 3,440 Factory overhead 20,200 16,800 17,200 Sales are 20% cash and 80% on credit. All credit sales are collected in the month following the sale. The June 30 balance sheet includes balances of $15,000 in cash; $45,000 in accounts receivable; and a $5,000 balance in loans payable. A minimum cash balance of $15,000 is required. Loans are obtained at the end of any month when a cash shortage occurs. Interest is 1% per month based on the beginning-of-the-month loan balance and is paid at each month-end. If an excess balance of cash exists, loans are repaid at the end of the month. Operating expenses are paid in the month incurred and consist of sales commissions (10% of sales), office salaries ($4,000 per month), and rent ($6,500 per month).rev: 03_17_2020_QC_CS-2046792. Prepare a cash budget for each of the months of July, August, and September.
Business
1 answer:
Inessa05 [86]3 years ago
7 0

Answer and Explanation:

The Preparation of cash budget for each of the months of July, August, and September is shown below:-

                                              Cash budget

                             For the month of July, August and September

                                             July           August          September

Beginning cash balance   $15,000      $15,000         $25,505

Cash receipts from

customer (Working note) $57,800      $67,200        $73,600

Total cash available         $72,800      $82,200       $99,105

Less:

Cash disbursements

Direct Materials                 $16,160         $13,440         $13,760

Sales commission             $6,400         $8,000          $4,800

(10% of sales)

Office salaries                   $4,000          $4,000          $4,000

Rent                                    $6,500         $6,500          $6,500

Direct Labor                       $4,040         $3,360           $3,440

Overhead Cost                 $20,200       $16,800         $17,200

Interest on bank loan    

For July (5,000 × 1%)             $50  

For August                                                  $46            

($5,000 - $4,550) × 1%))

For September                                                                  $0

Preliminary Cash

balance                                    $15,450    $30,055      $49,405

Repayment of loan to

Bank                                          $450        $4,550

                                                                ($5,000 - $450)

Ending cash balance              $15,000     $25,505     $49,405

Working Note

The ending balance of the particular month should be treated as a opening balance of next month

August ending balance will be forwarded in Sept as a opening balance.

Working Note

                                        July           August          September

Sales                            $64,000      $80,000            $48,000

Less:

Ending accounts

receivable

(80% of sales)            $51,200       $64,000             $38,400

Cash sales                 $12,800        $16,000              $9,600

Last month cash

collection                   $45,000         $51,200          $64,000

Cash receipts from

customer                    $57,800      $67,200        $73,600

Therefore we added the cash receipts as it increase the cash balance and deduct all cash payment as it decrease the cash balance

You might be interested in
Stockholders invest $30,000 in exchange for common stock of the corporation. 2 Hires an administrative assistant at an annual sa
Black_prince [1.1K]

Answer:

Explanation:

1)

Dr Cash $30,000  

Cr Common Stock  $30,000

2) No Entry  

3)

Dr Office Furniture $3,800  

Cr Accounts Payable  $3,800

6)

Dr Accounts receivables $10,800  

Cr Service Revenue (Commission) $10,800

10)

Dr Cash $140  

Cr Service Revenue (Commission)  $140

27)

Dr Accounts Payable $700  

Cr Cash  $700

30)

Dr Salary Expense $3,000  

Cr Cash  $3,000

8 0
3 years ago
Joe is a pizza delivery worker. the pizza shop he works for has a 30 minutes or less delivery guarantee or else the customer doe
USPshnik [31]
If Joe has good morals he would stop and help the women. He could have the money taken out of his pay check to possible keep his job but if he does not stop and help the women he will have live with his decision for the rest of his life, the guilt would eat him alive. He can always get another job but we only have one life to live and if he could help save someone else, he should do that. 
7 0
3 years ago
When an organization adopts the ______ concept, it has made the attempt to know as much about the consumer as possible and has d
Alexandra [31]

Answer:

c. Marketing concept

Explanation:

Marketing concept -

It is the strategy adopted by the organisation , in order to meet the demands of the consumers , tackle the competition , increase the profit margin and increase sale , is referred to as the marketing concept .

Hence , the marketing department of the organisation , tries to focus on the consumers , in order to beat the upcoming competition.

Hence , the given information of the question,

The correct option is c. Marketing concept  .  

6 0
3 years ago
Identify whether the following paragraph uses a direct, indirect, or semi-indirect organizational pattern.
Anna007 [38]

Answer:

Correct answer is B that is <u>Indirect Organizational Pattern</u>

6 0
3 years ago
Read 2 more answers
Which of the following is a feature of a good budget?
kiruha [24]

B and C, are bad feautures. A makes more sense, than D, so A should be your answer.

4 0
3 years ago
Read 2 more answers
Other questions:
  • Ricardo conducts a survey to learn where consumers get information for buying used cars. This is an example of _____.
    7·1 answer
  • A team consists of employees from the same department who meet for a few hours each week to discuss ways of improving the work e
    5·1 answer
  • You are considering investing in one of several mutual funds. All the funds under consideration have various combinations of fro
    9·1 answer
  • T or F 25 percent is a good interest rate on a used car?
    11·1 answer
  • You are considering investing $1,000 in a complete portfolio. The complete portfolio is composed of treasury bills that pay 5% a
    10·1 answer
  • Bryant Company designs and builds fancy dining room tables for individual customers. On July 1, there were two jobs in process:
    15·1 answer
  • Explain why market power leads to deadweight loss. Firms with market power create deadweight loss because they A. charge a price
    14·1 answer
  • Tariffs, quotas and subsidies are examples of
    13·1 answer
  • Characteristics of budgets include: (Check all that apply.) Multiple select question. a focus on the past. typically span a mont
    12·1 answer
  • Randy has established a successful fast-food restaurant chain named randy’s in the united states. He currently has 12 locations
    15·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!