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)

Reviews

Write a Review

Accounting Basics Questions & Answers

  Calculate the profit-sales percentage

The total joint cost of a process is £1,800. This gives an output of 700 kilos of Product X and 300 kilos of Product Y.

  Work in process beginning 10000 work in process ending

work in process beginning 10000 work in process ending 15000 direct labor costs incurred 4000 costs of good

  Losses on its current receivables

In its December 31, 2009 financial statements, E-Z Prices estimated that losses on its current receivables would be $10.2 million.

  May 21 obtained a 60-day extension on a 9000 trade account

otter corporation whose fiscal year endied june 30 2011 completed the following transactions involving notes payablemay

  Norr and caylor established a partnership on january 1 2013

norr and caylor established a partnership on january 1 2013. norr invested cash of 100000 and caylor invested 30000 in

  Information about savings

Hungry Bites produces corn chips. The cost of one batch is below: Direct materials $18; Direct labor 13.00; Variable overhead; 11.00; and Fixed overhead 14.00.

  Why global airlines not offering price guarantees for flight

Why is Global Airlines not offering a price guarantees for flights on Monday mornings and Friday evenings? Do you agree with this policy? Explain briefly

  How are generally accepted auditing standards used what

how are generally accepted auditing standards used?what analytical procedures are used during an audit?how is an audit

  From the enron case assume that you are new members of the

from the enron case assume that you are new members of the board of directors for enron. what questions would you ask?

  Determine the effect of its inventory and receivables

Carmen and Vanessa's Corporation wants to determine the effect of its inventory and receivables management on its cash flow cycle. Carmen and Vanessa's sales last year (all on credit) was $200,000, and earned a net profit % of 10%.

  Would you recommend a stock dividend or a stock split

Your company has been very profitable and expects continued financial success. Its stock price has reached a point where the company needs to make it more affordable. Would you recommend a stock dividend or a stock split? Why?

  Pension expense-journal entries

Compute pension expense and prepare the journal entry to record pension expense and the employer's contribution to the pension plan in 2010.

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