Prepare a cash budget for the months of july

Assignment Help Managerial Accounting
Reference no: EM13523318

The Gannon Company has budgeted sales revenues as follows:

JUNE JULY AUGUST
Credit sales $27,000 $29,000 $18,000
Cash sales 18,000 51,000 39,000
Total sales $45,000 $80,000 $57,000

Past experience indicates that 60% of the credit sales will be collected in the month of sale and the remaining 40% will be collected in the following month.

Purchases of inventory are all on credit and 50% is paid in the month of purchase and 50% in the month following purchase. Budgeted inventory purchases are:

June $60,000
July 50,000
August 21,000

Other cash disbursements budgeted: (a) selling and administrative expenses of $9,500 each month, (b) dividends of $22,700 will be paid in July, and (c) purchase of a computer in August for $5,000 cash.

The company MUST maintain a minimum cash balance of $10,000 at the end of each month. The company borrows money from the bank at 9% per year interest if necessary to maintain the minimum cash balance of $10,000. Borrowed money is repaid in months when there is an excess cash balance. The beginning cash balance on July 1 was $10,000 of which none is borrowed.

Instructions:

Prepare a cash budget for the months of July and August and Prepare separate schedules for expected collections from customers and expected payments for purchases of inventory.

Reference no: EM13523318

Questions Cloud

Explain how many milliliters of naoh are required to titrate : How many milliliters of 0.0820 M NaOH are required to titrate each of the following solutions to the equivalence point. (a) 40.0 mL of 0.0950 M HNO3
Find the rotational speed of the surface of earth : Washington D.C is roughly 3000 miles from San Francisco. When it is 8:00 a.m. in San Francisco, it is 11:00 a.m. in Washington D.C. Using this information, find the rotational speed of the surface of Earth
What was your original speed : Driving along a crowded freeway, you notice that it takes a time t to go from one mile marker to the next. What was your original speed
Explain the diatomic molecule oh exists in the gas phase : The diatomic molecule OH exists in the gas phase. The length and bond energy have been measured to be 97.06pm and 424.7 kJ/mol, respectively.
Prepare a cash budget for the months of july : Prepare a cash budget for the months of July and August and Prepare separate schedules for expected collections from customers and expected payments for purchases of inventory.
How much mass does the water in the cloud have : One cubic centimeter of a cumulus contains 330 water drops, which have a typical radius of 10 ?m. How much mass does the water in the cloud have
What is your average speed from houston back to san antonio : You drive on Interstate 10 from San Antonio to Houston, half the time at 51 km/h and the other half at 98 km/h. What is your average speed from Houston back to San Antonio
Explain what would the ph be of a mixture of nah2po4 : What would the ph be of a mixture of 100 ml each of 0.01 M of NaH2PO4 and 0.01 MNa2HPO4
Explain the chemical formulas for two substances : Choose the answer which presents the chemical formulas for two substances in order of decreasing melting point (highest melting point first) and gives a valid reason for this order.

Reviews

Write a Review

Managerial Accounting Questions & Answers

  Manage budgets and financial plans

Explain the budgeting process and its importance to a business, identifying the components of different budgets, forecast estimates for inclusion in the budgets.

  Prepare a retained earnings statement

Prepare a retained earnings statement for the year and Prepare a stockholders' equity section of given case.

  Prepare a master budget for the three-month period

Prepare a master budget for the three-month period.

  Construct the companys direct labor budget

Construct the company's direct labor budget for the upcoming fiscal year, assuming that the direct labor workforce is adjusted each quarter to match the number of hours required to produce the forecasted number of units produced.

  Evaluate the predetermined overhead rate

Evaluate the Predetermined Overhead Rate

  Determine the company''s bid

Determine the company's bid if activity-based costing is used and the bid is based upon full manufacturing cost plus 30 percent.

  Compute the pool rates for the different activities

Complete the schedule to compute the pool rates for the different activities.

  Prepare Company financial statements

Prepare Company financial statements

  Prepare an analysis of terracycles

This individual assignment is based on the TerraCycle Inc.

  Discuss the ethical issues

Discuss the ethical issues

  Political resources in emerging markets

Calculate the GDP in Income Approach  and Expenditure Approach

  Management accounting - ehsan electronics company

A new plant accountant suggested that the company may be able to assign support costs to products more accurately by using an activity based costing system that relies on a separate rate for each manufacturing activity that causes support costs.

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