Solution-Prepare a three-month cash budget

Prepare a three-month cash budget

Assignment Help Accounting Basics

Reference no: EM132064930

Question - 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
$820,000
$123,000
$90,000
$65,600
$140,000
$312,000
$155,000

NOVEMBER
$780,000
$119,000
$85,000
$62,400
$140,000
$310,000
$155,000

DECEMBER
$850,000
$125,000
$96,000
$68,000
$140,000
$315,000
$155,000

Sales were $770,000 in August and $790,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: EM132064930

Questions Cloud

The expected real risk-free interest rate over the next year : YOP, Inc has a 3-year outstanding bond with 13% yield. Investors expect to earn an average of 3% in real rate of return.

What is the maximum capacity of system : Assuming that only large pizzas are sold at lunch, what is the maximum capacity of this system during the 2 hour lunch period?

Table of random numbers : Use a table of random numbers, or the random number button on a calculator, to simulate the operation of amachine for 12 months and hence

Marketing philosophy of commercial bank of ethiopia : 1. Assess the marketing philosophy of Commercial Bank of Ethiopia. Which of the philosophies discussed, do you think, is adopted by the bank.

Prepare a three-month cash budget : Sales were $770,000 in August and $790,000 in September. Prepare a three-month cash budget, including a schedule for cash collections and material payments

Getting line of sight : A recently published research paper (Smith, Jones and Brown, 2015) concluded that, globally, most large organisations, in both the private and public sectors

Case on diack restaurant : Next month managers at Diack's, a chain of over 40 restaurants in the UK, will show their appreciation for their staff's efforts with a week of events

What roles do accountants play in managing government : Prepare a paper of no more than 700 words that addresses - What roles do accountants play in managing government and not-for-profit organizations

Strategic review of coaching : Following a strategic review of coaching, the Metropolitan Police Service (MPS) is swiftly moving from using coaching as an ad hoc, disparate activity

User Account

All Pages

Prepare a three-month cash budget

Reference no: EM132064930

Reference no: EM132064930

Questions Cloud

Reviews

Write a Review

Accounting Basics Questions & Answers

How much control does fed have over this longer real rate

Coures:- fundamental accounting principles

Accounting problems

Theory of interest - term structure of interest rates

Write a report on internal controls

Prepare the bank reconciliation for company

Cost-benefit analysis

Theory of interest

Liquidity and profitability

What is the expected risk premium on the portfolio

Simple interest and compound interest

Capm and venture capital

Assured A++ Grade

Academics

Major Subjects

Majors

Get In Touch

TERMS & POLICIES

HELP & SUPPORT