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
List THREE common aptitudes, attitudes, and skills of personal care services workers.
ANEK [815]

Answer:

Good communication skills

Problem solving skills

Critical thinking skills

Patience

Self perceptiveness

Explanation:

4 0
2 years ago
Usually, price elasticities of supply areA) positive, because higher prices yield larger quantities supplied.B) considered short
Anna35 [415]

Answer:

A) Positive, because higher prices yield larger quantities supplied.

Explanation:

The correct answer to the question is A) Positive, because higher prices yield larger quantities supplied. The price elasticity of supply determines the change in price as a response to the change in supply of the good or service supplied. This is usually calculated in a figure that determines that if price increases what will be the impact on its supply, which usually is a positive figure.

3 0
3 years ago
Roland Company began operations on December 1 and needs assistance in preparing December 31 financial statements, including its
uranmaximum [27]

Answer:Incomplete Question, You omitted the values for the following

supplies remaining at year-end: $700

Wages earned by workers but not yet paid at year-end: $500

Explanation:

1. To Record the journal entries required for December, excluding the December 31 year-end adjusting entries.

Cash Paid for prepaid insurance

Date            Account and Explanation     Debit         Credit

1st Dec   Prepaid Insurance                  $24,000

        Cash                                                                    $24,000

Supplies purchased in cash

7th Dec      Supplies                                   $2000

                 Cash                                                                   $2,000

13th Dec     No ENTRY            Roland Co agreed to do but has not done itr yet.

Advance received from ABX

24th Dec      Cash                                       $4,000

                    Unearned Revenue                                        $4,000

2. To Record the December 31 year-end adjusting entries for prepaid insurance,  supplies,  accrued wages, accrued revenue, and  unearned revenue.

Insurance expense

Date            Account and Explanation     Debit         Credit

31st Dec  Insurance Expense                   $1,000

        Prepaid Expense                                                    $1,000

Calculation.24 month insurance policy for $24,000 cash.

Insurance for a month = 24,000/24= 1000

Supplies Expense

Date            Account and Explanation     Debit         Credit

31st Dec  Supplies  Expense                   $1,300

              Supplies                                                     $1,300

Calculation :purchased supplies for $2,000 --supplies remaining at year-end, $700= $1,300

To record Wages earned by workers but not yet paid at year-end: $500

Date            Account and Explanation     Debit         Credit

31st Dec  Wages   Expense                   $500

               Wages Payable                                               $500

Service Revenue from  Telo

Date            Account and Explanation     Debit         Credit

31st Dec  Accounts receivable                 $6,000

               Service Revenue                                            $6,000

calculation=Job Completion at Year-End x received cash  of worth of work for Telo = 60% x 10,000 = %6,000

Service Revenue from  Abx

Date            Account and Explanation     Debit         Credit

31st Dec  Unearned Revenue                 $1,000

               Service Revenue                                                  $1,000

calculation=Job Completion at Year-End x cash in advance to perform work  = 25% x 4,000 = $1,000

3. Journal entry for January

Payment Of wages recorded

Date            Account and Explanation     Debit         Credit

5 Jan  Wages Payable                          $500

  Wages Expense (800-500)                 $300

               Cash                                                             $800

Payments from Telo Recorded

Date            Account and Explanation     Debit         Credit

12 Jan  Cash                                           $10,000            

      Account Receivable                                             $6,000

    Service Revenue(10,000-6000)                          $4,000

8 0
3 years ago
What cost advantage does e-commerce offer businesses
katovenus [111]
Small Business United Nations (UN) and Organization for Economic Cooperation and Development (OECD) Definition
Fewer than 500 employees
5 0
3 years ago
What are the steps you should follow after you have installed a software update?
alexira [117]

Answer:

You should make sure there are no more updates after that and if their are no more needed then you should be fine to just go on

Explanation:

5 0
2 years ago
Read 2 more answers
Other questions:
  • Shen has plans to go to an opera and already has a $100 nonrefundable, nonexchangeable, and nontransferable ticket. Now Valerie,
    12·1 answer
  • Shellshock do wheels affect your traction and speed
    12·2 answers
  • On December​1, Mountain and Meadow Tree Service prepaid $6,600 for six​ months' rent. Give the adjusting entry to record rent ex
    10·1 answer
  • The purchasing agent of an organization acquired some raw materials at a bargain price, even though she knew that their quality
    9·2 answers
  • Jonas is a 60% owner of Ard, an S corporation. At the beginning of the year, his stock basis is zero. Jonas's basis in a $20,000
    14·1 answer
  • As Timothy examines markets that might match his company’s investment requirements, he is particularly interested in the fact th
    6·1 answer
  • What happens to the percentage of an income that is taxed when income rises and the tax is a proportional one?
    7·2 answers
  • You sell 10 cups of lemonade for 1.50 each. You spent $5.00 on lemons and $1.00 for a bag of ice. What is your profit or loss?
    14·2 answers
  • Break-Even for a Service Firm Jonah Graham owns and operates The Green Thumb Company (GTC), which provides live plants and flowe
    12·1 answer
  • Allison has a horse stall cleaning business that has been growing rapidly since she started it three years ago. She estimates th
    15·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!