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
Oxana [17]
3 years ago
10

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. July August September Budgeted sales $ 60,000 $ 76,000 $ 52,000 Budgeted cash payments for Direct materials 16,960 14,240 14,560 Direct labor 4,840 4,160 4,240 Factory overhead 21,000 17,600 18,000 Sales are 30% cash and 70% 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,800 in accounts receivable; and a $5,800 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,800 per month), and rent ($7,300 per month).
Part 1 (1) Prepare a cash receipts budget for July, August, and September.
Part 2 (2) Prepare a cash budget for each of the months of July, August, and September. (Negative balances and Loan repayment amounts (if any) should be indicated with minus sign. Enter your final answers in whole dollars.)
Business
1 answer:
balandron [24]3 years ago
7 0

Answer:

(1) Total cash receipts:

July = $63,800      

August = $64,800

September = $68,800

2-a. Ending Cash Balance:

July = $15,00

August = $21,173

September = $35,873

2-b. Loan Balance End of Month:

July = $2,898

August = $0

September = $0

Explanation:

(1) Prepare a cash receipts budget for July, August, and September.

Note: See part (1) of the attached excel file for the cash receipts budget for July, August, and September.

From the attached excel file, we have:

Total cash receipts:

July = $63,800      

August = $64,800

September = $68,800

(2) Prepare a cash budget for each of the months of July, August, and September.

Note: See part (2) of the attached excel file for the cash budget for July, August, and September.

In the attached excel file, the following calculation is made:

July loan repayment = July preliminary cash balance - Minimum cash balance required = $17,902 - $15,000 = $2,902

From the attached excel file, we have:

2-a. Ending Cash Balance:

July = $15,00

August = $21,173

September = $35,873

2-b. Loan Balance End of Month:

July = $2,898

August = $0

September = $0

Download xlsx
You might be interested in
Ralph was considering hiring George to work in his grocery store as a shelf stocker. In order to ensure that George is a citizen
aliya0001 [1]

Answer:

I-9 Employment Eligibility Verification form

Explanation:

Based on the information provided within the question it can be said that Ralph should ask George to complete the I-9 Employment Eligibility Verification form. This is a form that is used in order to make sure that the individual is legally authorized to  work as a paid employee within the United States of America. Which is what Ralph needs to veirfy George's identity and authorization to work.

5 0
3 years ago
Aggregate supply definitions The short-run aggregate supply curve shows How firms respond to changes in interest rates Changes i
scoundrel [369]

Answer:The real Gdp

Explanation:

Short run aggregate supply curve is upward sloping and it shows the relationship between the price level and output. it is upward sloping because the quantity supplied increases when the price rises. Real GDP or otherwise known as changes in aggregate demand and aggregate supply is assumed to remain unchanged because they are not caused by changes in the price level. Economic growth are one of the things that can cause change in real Gdp. Things that cause changes along a given short run supply curve can include the following: wages, increase in physical capital or advancement in technology.

3 0
3 years ago
Ella had been using an imported brand of shampoo for several years, but she could no longer find it anywhere. As she was conside
defon

Answer:

A. rebranded.

Explanation:

Based on the information provided within the question it can be said that the new ads suggest that Head & Shoulders has been rebranded. In a business context, this refers to changing the corporate image of the company by changing the name, symbol, design, concept, or even a combination of these traits in order to develop a new identity for the brand. Which is what Head & Shoulders seem to be doing by changing their concept of being a dandruff shampoo to a health-oriented glamorous shampoo.

7 0
3 years ago
ecord adjusting journal entries for each of the following for year ended December 31. Assume no other adjusting entries are made
k0ka [10]

Answer: Please Refer to Explanation

Explanation:

Please see complete question attached to this answer.

A.

As the company has not paid the salary but they recognize it is an expense, it should be credited to Salaries payable from the salary expense account.

DR Salary Expense $ 18,500

CR Salary Payable $18,500

( To record Salary Expense incurred but not paid)

B.

As the company has not paid the interest but they recognize it is an expense, it should be credited to Interest Payable from the interest expense account until it is paid.

DR Interest Expense $400

CR Interest Payable $400

( To record interest expense on loan not paid )

C.

As the company has not paid the mortgage interest but they recognize it is an expense, it should be credited to mortgage payable from the mortgage account expense account

DR Mortgage Interest Expense $1,025

CR Mortgage Interest Payable $1,025

( To recording interest expense on mortgage not paid for the year).

3 0
4 years ago
In order for a business to be really successful,
poizon [28]

it would be a as a team I hope this helps

3 0
2 years ago
Other questions:
  • Trago Company manufactures a single product and has a JIT policy that ending inventory must equal 20% of the next month's sales.
    8·1 answer
  • The following transactions occur for the Panther Detective Agency during the month of July:
    12·1 answer
  • You’ve just joined the investment banking firm of Dewey, Cheatum, and Howe. They’ve offered you two different salary arrangement
    9·1 answer
  • The issuance of common stock and declaration and payment of cash dividends will result in the following:
    9·1 answer
  • Shares of ABBO stock are currently selling for $14.43 a share. The last annual dividend paid was $1.61 a share, and dividends in
    12·2 answers
  • Kesterson Corporation has provided the following information: Cost per Unit Cost per Period Direct materials $ 6.75 Direct labor
    6·1 answer
  • An indicator of the impact of technology on U.S. jobs has been an increase in manufacturing production (output) while employment
    10·1 answer
  • Recognizing something as a revenue instead of as a liability has a positive effect on the reported financial statements because:
    8·1 answer
  • Kitchen and Laundry and More has annual credit sales of $2,473,701 and cost of goods sold of $1,838,207. The average accounts re
    12·1 answer
  • what type of analytics takes past purchasing data as inputs into a model that recommends the best pricing strategy across all fl
    13·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!