Kelsey is preparing its master budget. Budgeted sales and cash payments for merchandise purchases for the...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Kelsey is preparing its master budget. Budgeted sales and cash payments for merchandise purchases for the next three months follow. Budgeted July Sales $ 64,000 40,400 August $ 80,000 33,600 September $ 48,000 34,400 Cash payments for merchandise purchases Sales are 20% cash and 80% on credit. Sales in June were $56,250. All credit sales are collected in the month following the sale. The June 30 balance sheet includes balances of $15,000 in cash and $5,000 in loans payable. A minimum cash balance of $15,000 is required. Loans are obtained at the end of any month when the preliminary cash balance is below $15,000. Interest is 1% per month based on the beginning-of-the-month loan balance and is paid at each month-end. If a preliminary cash balance above $15,000 at month-end exists, loans are repaid from the excess. 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 schedule of cash receipts from sales for July, August, and September. (2) Prepare a cash budget for July, August, and September. Complete this question by entering your answers in the tabs below. Required 1 Required 2 Prepare a schedule of cash receipts from sales for July, August, and September. KELSEY Schedule of Cash Receipts from Sales July September August 64,000 $ 80,000 $ 48,000 Sales $ Cash receipts from Cash sales Collections of prior period sales Total cash receipts Required 1 Required 2 Prepare a cash budget for July, August, and September. (Negative balances and Loan repayment amounts (if any) should be indicated with minus sign. Round your final answers to the nearest dollar.) KELSEY Cash Budget July August September Beginning cash balance Total cash available Less: Cash payments for Total cash payments. Preliminary cash balance Ending cash balance Loan balance - Beginning of month Additional loan (loan repayment) Loan balance - End of month Loan balance July $ 0 0 August 5,000 < Required 1 0 0 0 September Required 2 > Kelsey is preparing its master budget. Budgeted sales and cash payments for merchandise purchases for the next three months follow. Budgeted July Sales $ 64,000 40,400 August $ 80,000 33,600 September $ 48,000 34,400 Cash payments for merchandise purchases Sales are 20% cash and 80% on credit. Sales in June were $56,250. All credit sales are collected in the month following the sale. The June 30 balance sheet includes balances of $15,000 in cash and $5,000 in loans payable. A minimum cash balance of $15,000 is required. Loans are obtained at the end of any month when the preliminary cash balance is below $15,000. Interest is 1% per month based on the beginning-of-the-month loan balance and is paid at each month-end. If a preliminary cash balance above $15,000 at month-end exists, loans are repaid from the excess. 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 schedule of cash receipts from sales for July, August, and September. (2) Prepare a cash budget for July, August, and September. Complete this question by entering your answers in the tabs below. Required 1 Required 2 Prepare a schedule of cash receipts from sales for July, August, and September. KELSEY Schedule of Cash Receipts from Sales July September August 64,000 $ 80,000 $ 48,000 Sales $ Cash receipts from Cash sales Collections of prior period sales Total cash receipts Required 1 Required 2 Prepare a cash budget for July, August, and September. (Negative balances and Loan repayment amounts (if any) should be indicated with minus sign. Round your final answers to the nearest dollar.) KELSEY Cash Budget July August September Beginning cash balance Total cash available Less: Cash payments for Total cash payments. Preliminary cash balance Ending cash balance Loan balance - Beginning of month Additional loan (loan repayment) Loan balance - End of month Loan balance July $ 0 0 August 5,000 < Required 1 0 0 0 September Required 2 >
Expert Answer:
Answer rating: 100% (QA)
1 2 Cash Receipt Budget July 2000 8000 Total Sales Cash Sales Credit Sales Cash Sales Coll... View the full answer
Related Book For
Fundamental accounting principle
ISBN: 978-0078025587
21st edition
Authors: John J. Wild, Ken W. Shaw, Barbara Chiappetta
Posted Date:
Students also viewed these accounting questions
-
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: Sales are 20% cash and 80% on credit. All...
-
Built-Tight is preparing its master budget. Budgeted sales and cash payments follow. Sales to customers are 20% cash and 80% on credit. Sales in June were $56,250. All credit sales are collected in...
-
Is the PS assessment a valid predictor of performance as a store manager? Would you recommend the PS be used in the future to select sales people for promotion to store manager?
-
In a stock acquisition accounted for by the equity method, a portion of the purchase price often is attributed to goodwill or to specific assets or liabilities. How are these amounts determined at...
-
Tom Keenan is a vacation planner who specializes in outback adventures; he has a high presence at outdoor shows and gets most of his business from there. On May 1, 2023, Tom started his business...
-
Identify and distinguish between the two types of statistical sampling techniques.
-
Santana Rey created Business Solutions on October 1, 2011. The company has been successful, and Santana plans to expand her business. She believes that an additional $86,000 is needed and is...
-
Nuclear explosions cause a blast wave , a high-pressure shock wave generated by the heat from the fireball. These shock waves can travel in air at an average speed of 738 mph. (1 mile = 1609 meters)....
-
In this exercise, you modify the Chopkins Toys application from Exercise 11. Use Windows to make a copy of the Chopkins Solution folder. Rename the copy Modified Chopkins Solution. Open the Chopkins...
-
An investor wants to invest in a company that has paid the following historical dividend over the past six years. What is the most the investor should be willing to pay for this companys stock? Year;...
-
decribe the health sttsus of unit members (if any of the family describe below)Mother (29yo) and Father (32yo) 2 children (1 elementary, 1 high school) Origin: Mohawk (from Kahnawake) Address: 295,...
-
5. Consider uniform, inviscid, supersonic flow exhausting from a rocket engine nozzle. For fixed back pressure p (i.e., the ambient pressure outside the nozzle), qualitatively draw the first few wave...
-
What is the central concept in urban economics that says people/businesses being physically next together increases overall productivity? Why does it increase productivity?
-
Discuss the following: a) b) c) The usefulness of models in managerial decision-making within firms. (5 marks) Process of theory formulation/model building (using an example of a theory/model known...
-
4. (20 total points) Consider two firms, firm 1 and firm 2, producing identical products so that they are forced to charge identical prices. The sole strategic choice of the firms is the amount they...
-
a) "The transactions and the precautionary demand for money is income-determined, but the speculative demand for money is income-determining." Explain (5 marks) b) Briefly explain the sub-markets...
-
For a nonzero constant a, find the intercepts of the graph of (x 2 + y 2 ) 2 = a 2 (x 2 - y 2 ). Then test for symmetry with respect to the x-axis, the y-axis, and the origin.
-
Solstice Company determines on October 1 that it cannot collect $ 50,000 of its accounts receivable from its customer P. Moore. Apply the direct write-off method to record this loss as of October 1.
-
At the end of the current year, the following information is available for both Pulaski Company and Scott Company. Required 1. Compute the debt-to-equity ratios for both companies. 2. Comment on your...
-
Milano Gallery purchases the copyright on an oil painting for $ 418,000 on January 1, 2013. The copyright legally protects its owner for 10 more years. The company plans to market and sell prints of...
-
The y-intercept b0 of a least-squares regression line has a useful interpretation only if the x-values are either all positive or all negative. In Exercises 812, determine whether the statement is...
-
In general, the slope of the least-squares regression line is equal to the correlation coefficient. In Exercises 812, determine whether the statement is true or false. If the statement is false,...
-
At the final exam in a statistics class, the professor asks each student to indicate how many hours he or she studied for the exam. After grading the exam, the professor computes the least-squares...
Study smarter with the SolutionInn App