Calculate total budgeted cash payments for selling

Assignment Help Accounting Basics
Reference no: EM131769642

A manufacturingcompany's budgeted income statement includes the followingdata:

Data extracted from budgeted income statement Mar Apr May Jun
Sales $120,000 $90,000 $95,000 $100,000
Commission expense (15% of sales) 18,000 13,500 14,250 15,000
Salaries expense 30,000 30,000 30,000 30,000
Miscellaneous expenselong dash-4% of sales 4,800 3,600 3,800 4,000
Rent expense 3,600 3,600 3,600 3,600
Utility expense 1,900 1,900 1,900 1,900
Insurance expense 2,100 2,100 2,100 2,100
Depreciation expense 4,400 4,400 4,400 4,400

The budget assumes that60% of commission expenses are paid in the month they are incurred and the remaining40% are paid one month later. Inaddition, 50% of salary expenses are paid in the same month and the remaining50% are paid one month later. Miscellaneousexpenses, rent expense and utility expenses are assumed to be paid in the same month in which they are incurred. Insurance has been paid in advance for the year on January 1st.

Calculate total budgeted cash payments for selling and administrative expenses for the month of April.

Gamma Corp. has prepared a preliminary cash budget for the 3rd quarter as shown below:

Cash Budget Jul Aug Sep
Beginning cash balance $32,000 $4,400 $6,900
Plus: Cash collections 49,400 51,000 44,600
Cash available $81,400 $55,400 $51,500
Less: Cash payments:      
Purchases of inventory 36,000 9,000 11,000
Operating expenses 41,000 30,500 30,900
Capital expenditures 0 9,000 7,700
Ending cash balance $4,400 $6,900

$1,900

Subsequently, the marketing department revised its figures for cash collections. New data are as follows: $52,000 in July, $50,000 in August, and $42,000 in September. Based on the new data, calculate the new projected cash balance at the end of July.

Reference no: EM131769642

Questions Cloud

What should be the bolt spacing : A plate girder used as a simple beam 36 ft long must support a concentrated load of 180 000 lb at the middle of the span and 45 000 lb at each quarter point.
Discuss international standards on auditing correct : Is this description of International Standards on Auditing correct
Determine load based on allowable bending stress : A W12 x 72 A36 structural steel beam is used for a simple span of 12 ft and carries a uniformly distributed load.
How do ethical issues impact organizations and operations : Ethical behavior is a corporate issue that affects the company's bottom line. How do ethical issues impact organizations and operations?
Calculate total budgeted cash payments for selling : Calculate total budgeted cash payments for selling and administrative expenses for the month of April.
Describe three different specialty areas in public health : Describe three different specialty areas in public health to include the actual roles/careers, responsibilities, and organizations that employ these positions.
Determining that are the values within safe limits : A Douglas fir beam 10 by 12 in dressed size and 14 ft long is supported at the ends. The beam carries a total uniform load of 9000 lb and a concentrated load.
Question - Profitability Index versus NPV : Question - Profitability Index versus NPV - Based on the profitability index decision rule, rank these investments. Based on the NPV, rank these investments
How do you try to see things from anothers perspective : How do you try to see things from another's perspective? Did you recognize how your behavior affect others? Explain

Reviews

Write a Review

Accounting Basics Questions & Answers

  How much control does fed have over this longer real rate

Hubbard argues that the Fed can control the Fed funds rate, but the interest rate that is important for the economy is a longer-term real rate of interest.   How much control does the Fed have over this longer real rate?

  Coures:- fundamental accounting principles

Coures:- Fundamental Accounting Principles: - Explain the goals and uses of special journals.

  Accounting problems

Accounting problems,  Draw a detailed timeline incorporating the dividends, calculate    the exact Payback Period  b)   the discounted Payback Period. the IRR,  the NPV, the Profitability Index.

  Write a report on internal controls

Write a report on Internal Controls

  Prepare the bank reconciliation for company

Prepare the bank reconciliation for company.

  Cost-benefit analysis

Create a cost-benefit analysis to evaluate the project

  Theory of interest

Theory of Interest: NPV, IRR, Nominal and Real, Amortization, Sinking Fund, TWRR, DWRR

  Liquidity and profitability

Distinguish between liquidity and profitability.

  What is the expected risk premium on the portfolio

Your Corp, Inc. has a corporate tax rate of 35%. Please calculate their after tax cost of debt expressed as a percentage. Your Corp, Inc. has several outstanding bond issues all of which require semiannual interest payments.

  Simple interest and compound interest

Simple Interest, Compound interest, discount rate, force of interest, AV, PV

  Capm and venture capital

CAPM and Venture Capital

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd