Kelsey is preparing its master budget for the quarter ended

Assignment Help Cost Accounting
Reference no: EM13906847

Kelsey is preparing its master budget for the quarter ended September 30. Budgeted sales and cash payments for merchandise for the next three months follow:

2247_267-B-C-A-B (741).png

Sales are 20% cash and 80% on credit. All credit sales are collected in the month following the sale. The June 30 balance sheet includes balances of $15,000 in cash; $45,000 in accounts receivable; $4,500 in accounts payable; and a $ 5,000 balance in loans payable. A minimum cash balance of $15,000 is required. Loans are obtained at the end of any month when a cash shortage occurs. Interest is 1% per month based on the beginning of the month loan balance and is paid at each month-end. If an excess balance of cash exists, loans are repaid at the end of the month. Operating expenses are paid in the month incurred and consist of sales commissions (10% of sales), office salaries ($4,000 per month), and rent ($6,500 per month). 

(1) Prepare a cash receipts budget for July, August, and September. 

(2) Prepare a cash budget for each of the months of July, August, and September. (Round all dollar amounts to the nearest wholedollar.) 

Reference no: EM13906847

Questions Cloud

Design a system using a class called books : Design a system using a class called Books with suitable members
How technology might also affect the process : How technology might also affect the process
Compare the people''s comfort in the equilibria of two games : Compare the people's comfort in the equilibria of the two games. Suppose that each person cares only about her own comfort. Model the situation as a strategic game. Is this game the Prisoner's Dilemma?
Design a solution that prints the amount : Design a solution that prints the amount of pay a commissioned salesperson takes home. The more sales documented, the larger the commission rate. Allow the user to input a total sales amount for the week. Compute the commission based on the follow..
Kelsey is preparing its master budget for the quarter ended : Kelsey is preparing its master budget for the quarter ended September 30. Budgeted sales and cash payments for merchandise for the next three months follow:
Applying systems thinking to a public health issue : Applying Systems Thinking to a Public Health Issue
Display the equivalent prices : Test your application with 1.259 per liter against 4.50 per gallon. Once the decision is made, display the equivalent prices. (1 liter is 0.264172 gallons)
Label object displaying the saying : Under the Format selection, include options of Font and Color. Wire the Font and Color options to the Windows predefined Font and Color dialog boxes so that when their values are changed, the text in the Label object displaying the saying is chang..
Describes the probability that they will get to pearl rock : If the tourists start at Looloo with a full tank of fuel and intend to refuel every chance they get, which of the following fault trees (1-8) most accurately describes the probability that they will get to Pearl Rock without being delayed by havin..

Reviews

Write a Review

Cost Accounting Questions & Answers

  What is the direct labor cost for june

What is the direct material cost for June? What is the direct labor cost for June?

  Make the journal entry to record the sale

Prepare the journal entry to record the sale and assuming that the tractor was sold for $10,000, prepare the journal entry to record the sale.

  What does the price elasticity of demand measure

What does the price elasticity of demand measure? What is inelastic demand? What is elastic demand? According to the economists' approach to setting prices, the profit-maximizing price should depend on what two factors?

  Question 1richard traveled from new orleans to new york for

question 1richard traveled from new orleans to new york for both vacation and business. he spent 4 days conducting

  How might your company benefit from using abc

Why is overhead allocation required in most manufacturing environments?

  Compute the cash flow invested in net working capital

Current liabilities for the firm were $2,867,225 and $2,760,124 at the end of 2011 and 2010, respectively. Compute the cash flow invested in net working capital at Hillman Corporation during 2011.

  What is the breakeven point in both sales dollars

What is the breakeven point in both sales dollars and units for Orange Crush Sports? What is the margin of safety?

  Show the nonfinancial information that may be used to

show the nonfinancial information that may be used to estimate the performance of a college or university and suggest

  Q01nbsp june 1 lauryn made an investment in byte of

q01.nbsp june 1 lauryn made an investment in byte of accounting inc. by purchasing 2600 shares of its general stock for

  How much the weekend expenses may kristen deduct

Kristen, the regional manager for a national hardware chain, is based in Atlanta. During March and April of this year, she has to replace temporarily the district manager in Jackson, Mississippi. During this period, Kristen flies to Jackson on Sun..

  Identify the objective of financial reporting

Identify the objective of financial reporting and describe the level of sophistication expected of the users of financial information by the objective of financial reporting.

  Who are the main users of financial reports on profit

Who are the main users of financial reports on profit and financial position of an organisation? Are manufacturing statements an example of periodic or perpetual inventory systems? Explain.

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