Solution-Prepare a three-month cash budget

Prepare a three-month cash budget

Assignment Help Accounting Basics

Reference no: EM131756255

Can I have some help with this question, please? As soon as possible would be great, a few hours from now would be the best. I appreciate it.

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: EM131756255

Questions Cloud

Determine ending inventory cost by fifo method : Determine ending inventory cost by (a) FIFO method, (b) LIFO method, and (c) average cost method

Discuss the significant attributes of a wiki : Discuss the significant attributes of a wiki, and describe the overall manner in which IAL uses wikis for its internal collaboration.

Automobile manufacturing industry : What are 3 companies in the automobile manufacturing industry with most successful implementation of information systems. please give me a paragraph with source

Experimental investigation on scheffler type : Study of working of Scheffler concentrator and Identfy the parameters that affect the thermal performance of concentrator - Performance testing

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

Multi-state information sharing and analysis center : Along with working with the Multi-State Information Sharing and Analysis Center (MS-ISAC), who else could each city partner with to reduce the risks

Show the number of transmissions to manufacture : Prepare a production budget for both the second and third quarters that shows the number of transmissions to manufacture.

Create a visually interesting client handout based on case : Create a visually interesting client handout based on the case study chosen for the Psychiatric Diagnosis assignment.

Social implications of spending : What are the social implications of spending so many hours inside a virtual world? (5 lines at least)

User Account

All Pages

Prepare a three-month cash budget

Reference no: EM131756255

Reference no: EM131756255

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