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
Small businesses are important to the U.S. economy because
horsena [70]

Answer:

D) They create about 65% of new jobs each year and generate over 50% of the U.S. GDP.

Explanation:

Small businesses employ over 99 percent of all the private-sector employees in the US. In figures, they hire over 130 million people. Besides that, 60 to 80 percent of all new jobs created every year come from small businesses.

In revenue generation, Small business makes 54 percent of US sales. They contribute over six trillion-dollars to the economy or 50 percent of the country's GDP

6 0
3 years ago
Phipps Company borrowed $25,000 cash on October 1, 2016, and signed a nine-month, 8% interest-bearing note payable with interest
anzhelika [568]

Answer:

The correct option is C,$500

Explanation:

The amount of interest accrual is the interest on the sum borrowed from October 1 2016 to 31 December 2016,that is 3 months of interest,which is computed below:

Accrued interest =principal*stated interest rate*number of accrued months/12

principal is $25,000

stated interest is 8%

number of accrued months is 3

accrued interest =$25,000*8%*3/12=$500

The accrued interest is to be debited interest expense  because it is an increase in expense  and credited to interest payable as a liability

5 0
3 years ago
There are many unstated assumptions in the problem given above. Even if the mathematical solution is to make only one or two typ
Genrish500 [490]

Answer:

The unstated assumptions in the problems given is that the company may require more units of aluminium and steel, which would allow for producing more bicycles.A linear programming model cannot account for this.

Explanation:

Linear programming model: this is an algebraic description of te objectives to be minimized and the constraints to be satisfied by the variables.

3 0
3 years ago
Suppose Compco Systems pays no dividends but spent $ 5.18 billion on share repurchases last year. If​ Compco's equity cost of ca
shusha [124]

Answer:

Market capitalization - $155.26

Stock price - $26.77

Explanation:

The computation of the market capitalization is shown below:

= last year dividend × (1 + growth rate) ÷  (cost of capital - growth rate)

= $5.18 billion × ( 1 + 7.9%) ÷ (11.5% - 7.9%)

= $5.58,922 billion ÷ 3.6%

= $155.26

And, the stock price would be

= Market capitalization ÷ outstanding shares

= $155.26 ÷ 5.8 billion

= $26.77

3 0
3 years ago
When Marcus sent his daughter to college, he purchased a house near campus for $95,000. Empty lots in the area sold for approxim
Ugo [173]

Answer:

correct answer is (A) $85,000

Explanation:

given data

purchased house = $95,000

Empty lots area sold = $10,000

fair market value = $160,000

land price rise = $20,000

solution

we can say here that fair market value is more than the fair preface of home

so adjusted introduce will be explanation behind weakening

and

basis depreciation of the house will be

basis depreciation of the house = $95000 - $10000

basis depreciation of the house = $85000

so correct answer is (A) $85,000

5 0
3 years ago
Other questions:
  • Some​ governments, particularly in developing and emerging​ markets, are attempting to reduce losses that can occur when interna
    13·1 answer
  • Which would you trade on a stock exchange?<br> A) shares<br> B) bonds<br> C) annuities
    12·2 answers
  • Stressors and negative emotions are both
    15·1 answer
  • Farmers in developing countries want the united states to reduce the subsidies that it gives to u.s. farmers because subsidized
    14·1 answer
  • Which is a quality of an effective reward incentive?
    12·2 answers
  • Why do you think it's better to invest in a variety of stocks, rather than in just one?
    11·2 answers
  • What your body language can tell someone is an example of
    13·1 answer
  • Which of the following sources of income is money made from tenants who live in a property that you own?
    8·2 answers
  • according to the international data corporation (idc), what is that crucial ability that will make cloud computing essential for
    13·1 answer
  • Suppose Ernie gives up his job as financial advisor for P.E.T.S., at which he earned $30,000 per year, to open up a store sellin
    5·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!