Built-Tight is preparing its master budget for the quarter ended September 30. Budgeted sales and cash payments for product costs 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.

Question

30-05-2020
Business

contestada

Built-Tight is preparing its master budget for the quarter ended September 30. Budgeted sales and cash payments for product costs 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.

Respuesta :

Otras preguntas

Which on blue, light blue yellow or red?

The probability that a marksman will hit a target each time he shoots is 0. 89. If he fires 15 times, what is the probability that he hits the target at most 13

a nurse is applying a vaginal cream to a client with a fungal infection. which guideline is recommended for this application?

n the preceding question, you have calculated the frequency of a molecular vibration. the molecule can absorb light at this frequency. the light happens to be i

sn1 reactions where there is only one stereocenter and the leaving group is attached to that stereocenter will produce products racemization cannot be determine

What color is typically used for coins in games? A. blue B. green C. orange D. yellow

A musical genius, but also someone with strong anti-Semitic views, the man pictured above was one of the most influential composers of the Romantic Period. His

Archie Co. purchased a framing machine for $49,000 on January 1, 2021. The machine is expected to have a four-year life, with a residual value of $7,000 at the

you are assessing a 6-year-old girl with possible pneumonia. she has labored breathing and a fever of 102f. when you are assessing and classifying her respirat

PLEASE HELP ILL THANK YOU AND GIVE YOU FIVE STARS!!!!!!!!!!!!!!!!!!!!!! what is a good because/then thesis statement for an essay about poor water quality and t

ACCESS MORE EDU ACCESS

andromache andromache · Answer 1 · 2020-06-03T09:02:05+02:00

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

Preparation of the cash budget:

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

Learn more about cash here: https://brainly.com/question/14084480