Prepare a three-month cash budget

Assignment Help Accounting Basics
Reference no: EM131755288

Could you please help me with my homework?  I am stuck here...

Presented below are selected budget data items for Globe Corporation for a three-month period:

Sales
Direct materials
Direct labor
Variable overhead
Fixed overhead
Selling and admin. costs
Fixed loan payments
OCTOBER
$960,000
$123,000
$90,000
$65,600
$140,000
$312,000
$140,000
NOVEMBER
$870,000
$119,000
$85,000
$62,400
$140,000
$310,000
$140,000

DECEMBER

$850,000

$125,000

$96,000

$68,000

$140,000

$315,000

$140,000

Sales were $770,000 in August and $840,000 in September. Material usage was $115,000 in August and $118,000 in September. All sales are on account, and accounts receivable is historically collected 15% in the month of sale, 65% in the month following sales, and the remainder two months after the sale. Materials are paid for 40% in the month used and 60% the following month. All other expenses are paid in the month incurred. The cash balance was $35,000 at the beginning of October, and management wants to determine if the company will have enough cash to pay a year-end bonus.

Prepare a three-month cash budget, including a schedule for cash collections and material payments.

Reference no: EM131755288

Questions Cloud

Essay is about write up of jesus walks song : How have you been able to apply knowledge gained through this class to other areas within and outside of academia? *How are you planning to use what you've lear
Identify a person that you consider a leader : Identify a person that you consider a leader. Explain his/her behavior using at least two leadership theories discussed.
Define the four perspectives of the balanced scorecard : Define the four perspectives of the balanced scorecard. Define the five sources of power and provide an example for each source of power.
Professional to ensure that you are acting ethically : Explain how you, as a professional, will utilize your assumptions, values, and biases to further social change.
Prepare a three-month cash budget : Prepare a three-month cash budget, including a schedule for cash collections and material payments.
Paradigms from the learning resources : Choose two social science paradigms from the Learning Resources this week (e.g., feminist, symbolic interactionism, critical race theory, etc.).
Describe cultural and legal factors that might influence : Business Environment: Describe cultural and legal factors that might influence promotional decisions. Identify specific objectives related to the promotion.
Who should benefit or suffer from the actions : For this Discussion, view the Sessions episode on the Parker family. As you do so, consider which, if any, ethical mandates or standards were violated.
Prepare paper on the evolution of teslas electric cars : What emerging technology? Please use the traditional filters of time, place, person, and theme to narrow this technology. This should be about three paragraphs.

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