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

  Peter mary and paul are planning on creating a new business

peter mary and paul are planning on creating a new business to buy restore and sell classic cars. the three individuals

  Allowance for uncollectable accounts

How do you post transaction to the following accounts: cash, accounts receivable, and allowance for uncollectable accounts?

  Compute warrens actual return on plan assets

For Warren Corporation, year-end plan assets were $2,144,800. At the beginning of the year, plan assets were $1,755,200. During the year, contributions to the pension fund were $120,000, and benefits paid were $200,000.

  Examine how the sox framework can prevent business model

examine how the sox framework can prevent business model fraud in managerial accounting and financial accounting.

  What demand would you project for sir grapefellow

What demand would you project for Sir Grapefellow for the current year and do you think Sir Grapefellow will sell enough to break even? Should he introduce his namesake cereal brand in North Jersey?

  What are the expected cash receipts for each month

What are the expected revenues for S2BU for each month, April through September? Revenues are recorded in the month of the occasion and what are the expected cash receipts for each month, April through July?

  Compute the partnerships ordinary income

Compute the partnership's ordinary income and separately stated items and show Mark's and Pamela's shares of the items in Part a.

  Note that snyder department store uses a periodic system

At the end of Snyder Department Store's fiscal year on November 30, 2012, these accounts appeared in its adjusted trial balance.

  Determine the price for this job

The company has just received a contract calling for another SO units of production. It wants to add a 50 percent markup to the cost of materials and labor and labor-related costs. Determine the price for this job.

  Explain the department and its function

Explain the department and its function and what do you think are most significant direct costs incurred by this support department?

  Determine the depreciation for the month

A diesel-powered tractor with a cost of $185,000 and estimated residual value of $37,000 is expected to have a useful operating life of 40,000 hours. During February, the generator was operated 140 hours.

  Compute cost of goods sold for august 2010

Prepare an income statement for August 2010. Assume that Petersham's income tax rate is 40 percent. Sales for August 2010 were $985,000.

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