Prepare a cash budget for the quarter ending september

Assignment Help Financial Accounting
Reference no: EM13879148

Problem: prepare a case budget

Rocklin Company gathered the following budget information for the quarter ending September 30, 2014:

Sates

$540,000

Purchases

450,000

Salaries and wages

194,000

Rent

10,000

Supplies

8,000

Insurance

2,000

Other cash expenses

12,000

A cash balance of $36,000 is planned for July 1. Accounts receivable are expected to be $60,000 on July 1. All but one-half of 1% of the July 1 Accounts Receivable balance will be collected in the quarter ending September 30. The company's sales collection pattern is 95% in the quarter of sale and 5% in the quarter after sale. Accounts payable will be $30,000 on July I and will be paid during the coming quarter. The company's purchases payment pattern is 75% in the quarter of purchase and 25% in the quarter after purchase. Expenses are paid in the quarter in which they are incurred.

Prepare a cash budget for the quarter ending September 30, 2014.

Reference no: EM13879148

Questions Cloud

Compute a five-year weighted moving average using weights : IListed below is the number of movie tickets sold at the Library Cinema-Complex, in thousands, for the period from 2001 to 2013. Compute a five-year weighted moving average using weights of 0.1, 0.15, 0.25, 0.12, and 0.38, respectively. Describe the ..
Differences in challenges that are faced by learners : differences in challenges that are faced by learners for whom English is a second language
Write the lp problem to minimize transportation costs : A producer wholesaler has three factories, and the fruit and vegetables it ships are supplied to four different distribution centers. The table below gives unit shipping costs to each warehouse, along with factory capacities and warehouse demands.
How csr is defined by small and medium enterprises : Write a report on Social Responsibility of Private Firms,How CSR is defined by small and medium enterprises...
Prepare a cash budget for the quarter ending september : Rocklin Company gathered the following budget information for the quarter ending September 30, 2014: Prepare a cash budget for the quarter ending September 30, 2014.
The correct statistical test/procedure : 1)  In order to choose the correct statistical test/procedure, it is necessary for investigators to take into account all of the following except:  -Hypotheses -Type of variables
Diverse parental and community involvement : Diverse Parental and Community Involvement
Find the shipping schedule to minimize costs : They also have two distribution centers, d1 and d2; however, only d1 has the necessary environmental controls to handle the sen- sitive single malt. They have capacities of 550 and 650 cases, respectively. Given the following per case transport co..
Measured pressure drop : Kerosene at 20°C flows at 18 m3/h in a 5-cm-diameter pipe. If a 2-cm-diameter thin-plate orifice with corner taps is installed, what will the measured pressure drop be, in Pa?

Reviews

Write a Review

Financial Accounting Questions & Answers

  Economic ordering quantity computation

Economic ordering quantity computation and calculate the EOQ/ELS for the following two cases

  How much will be the companys expectation

Critically analyse and evaluate the arguments for and against, for the above paragraph and which argument do you consider to be more compelling.

  Advantages and disadvantages of using ratios for analysis

Do you find the balance sheet, income statement or other measures such as ratios the most informative? Comment on the advantages and disadvantages of using ratios for analysis.

  Prepare the correcting entry necessary when these errors

Prepare the correcting entry necessary when these errors are discovered. Assume that the books for 2011 are closed. (Ignore income tax considerations.) (For multiple debit/credit entries, list amounts from largest to smallest eg 10, 5, 3, 2.)

  Question regarding the present financial data

Important point: in the appendices you present financial data and your ratio analysis calculations.  Within the narrative sections, you are to analyze the data and describe what the data is indicating.

  Compute and compare the inventory turnover ratios

Compute and compare the inventory turnover ratios and days to sell inventory for Coca-Cola and PepsiCo for 2007. Indicate why there might be a significant difference between the two companies.

  What is the best way to determine what depreciation method

What is the best way to determine what depreciation method a company uses when referring to the financial statements?

  Prepare an amortization table for sycamore

Prepare an amortization table for Sycamore Co. assuming the effective interest method is used and prepare an amortization table for Sycamore Co. assuming the market rate was 6% and the effective interest method is used

  Which bonds value will be affected most

Which bonds value will be affected most if interest rates rise to 13 percent? which will be affected least?

  Q1 conan companys monthly activity level ranged from a low

q1. conan companys monthly activity level ranged from a low of 17000 units in may to a high of 26000 units in october.

  Activity affect the contribution margin and the net profit

Explain how changes in activity affect the contribution margin and the net profit. Be sure to discuss both sales activity changes and production activity changes. Use the Contribution Income statement format as a framework for your discussion.

  What was the amount of net income reported

What was the amount of net income reported by Chipo Corp. in 2012 - A small stock dividend was declared and issued in 2012. The market value of the shares was $11,100.

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