Santos Company is preparing a cash budget for February. The company has $20,000 cash at the...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Santos Company is preparing a cash budget for February. The company has $20,000 cash at the beginning of February and budgets $74,000 in cash receipts from sales and $120,000 in cash payments during February. Prepare the cash budget for February assuming the company maintains a $5,000 minimum cash balance and will take a loan if necessary to maintain this balance. The company has no loans outstanding on February 1. (Negative cash balances, if any, should be indicated with minus sign.) SANTOS COMPANY Cash Budget Beginning cash balance Total cash available Preliminary cash balance Loan activity Ending cash balance Loan balance, end of month February QS 20-24 (Algo) Manufacturing: Cash budget LO P2 Using the following information: a. Beginning cash balance on March 1, $77,000. b. Cash receipts from sales, $302,000. c. Cash payments for direct materials, $137,000. d. Cash payments for direct labor, $72,000. e. Cash payments for overhead, $36,000. f. Cash payments for sales commissions, $8,000 g. Cash payments for interest, $140 (1% of beginning loan balance of $14,000) h. Cash repayment of loan, $14,000. Prepare a cash budget for March for Gado Company. Total cash available Less: Cash payments for Total cash payments Preliminary cash balance Loan activity Ending cash balance Loan balance, end of month GADO COMPANY Cash Budget March QS 20-28A (Algo) Merchandising: Computing purchases LO P4 Raider-X Company budgets sales of 19,000 units for April and 21,000 units for May. Beginning inventory on April 1 is 5,700 units, and the company wants to have 30% of next month's unit sales in inventory at the end of each month. The merchandise cost per unit is $2. Prepare a merchandise purchases budget for the month of April. RAIDER-X COMPANY Merchandise Purchases Budget April Budgeted sales units Next period budgeted sales units Ratio of inventory to future sales Total required units Units to be purchased Cost per unit Cost of merchandise purchases QS 20-30A (Algo) Merchandising: Computing merchandise purchases LO P4 Montel Company's July sales budget shows sales of $610,000. The company budgets beginning merchandise inventory of $56,000 and ending merchandise inventory of $33,000 for July. Cost of goods sold is 30% of sales. Determine the budgeted cost of merchandise purchases for July. Hint: Use the relation (Beginning Inventory + Purchases - Cost of Goods Sold - Ending Inventory) to solve for purchases. Budgeted Cost of Merchandise Purchases QS 20-21 (Algo) Schedule of cash receipts with uncollectibles LO P2 Wells Company reports the following budgeted sales: September, $62,000; October, $59,000; and November, $73,000. All sales are on credit, and 5% of those credit sales are budgeted as uncollectible. Collection of the remaining 95% of credit sales are budgeted as follows: 60% in the first month after sale and 35% in the second month after sale. Prepare a schedule of cash receipts from sales for November. Sales WELLS COMPANY Schedule of Cash Receipts from Sales Cash receipts from: November $ 73,000 Total cash receipts $ 0 QS 20-22 (Algo) Computing budgeted accounts receivable LO P2 Kingston budgets total sales for June and July of $460,000 and $488,000, respectively. Cash sales are 65% of total sales. Of the credit sales, 20% are collected in the month of sale, 60% are collected during the first month after the sale, and the remaining 20% are collected in the second month after the sale. Determine the amount of accounts receivable reported on the company's budgeted balance sheet as of July 31. Hint: Determine the percent of June and July sales that are uncollected at July 31. As of July 31 Sales month Total Sales Credit Sales Percent Uncollected Amount Uncollected June July Total $ 460,000 488,000 Santos Company is preparing a cash budget for February. The company has $20,000 cash at the beginning of February and budgets $74,000 in cash receipts from sales and $120,000 in cash payments during February. Prepare the cash budget for February assuming the company maintains a $5,000 minimum cash balance and will take a loan if necessary to maintain this balance. The company has no loans outstanding on February 1. (Negative cash balances, if any, should be indicated with minus sign.) SANTOS COMPANY Cash Budget Beginning cash balance Total cash available Preliminary cash balance Loan activity Ending cash balance Loan balance, end of month February QS 20-24 (Algo) Manufacturing: Cash budget LO P2 Using the following information: a. Beginning cash balance on March 1, $77,000. b. Cash receipts from sales, $302,000. c. Cash payments for direct materials, $137,000. d. Cash payments for direct labor, $72,000. e. Cash payments for overhead, $36,000. f. Cash payments for sales commissions, $8,000 g. Cash payments for interest, $140 (1% of beginning loan balance of $14,000) h. Cash repayment of loan, $14,000. Prepare a cash budget for March for Gado Company. Total cash available Less: Cash payments for Total cash payments Preliminary cash balance Loan activity Ending cash balance Loan balance, end of month GADO COMPANY Cash Budget March QS 20-28A (Algo) Merchandising: Computing purchases LO P4 Raider-X Company budgets sales of 19,000 units for April and 21,000 units for May. Beginning inventory on April 1 is 5,700 units, and the company wants to have 30% of next month's unit sales in inventory at the end of each month. The merchandise cost per unit is $2. Prepare a merchandise purchases budget for the month of April. RAIDER-X COMPANY Merchandise Purchases Budget April Budgeted sales units Next period budgeted sales units Ratio of inventory to future sales Total required units Units to be purchased Cost per unit Cost of merchandise purchases QS 20-30A (Algo) Merchandising: Computing merchandise purchases LO P4 Montel Company's July sales budget shows sales of $610,000. The company budgets beginning merchandise inventory of $56,000 and ending merchandise inventory of $33,000 for July. Cost of goods sold is 30% of sales. Determine the budgeted cost of merchandise purchases for July. Hint: Use the relation (Beginning Inventory + Purchases - Cost of Goods Sold - Ending Inventory) to solve for purchases. Budgeted Cost of Merchandise Purchases QS 20-21 (Algo) Schedule of cash receipts with uncollectibles LO P2 Wells Company reports the following budgeted sales: September, $62,000; October, $59,000; and November, $73,000. All sales are on credit, and 5% of those credit sales are budgeted as uncollectible. Collection of the remaining 95% of credit sales are budgeted as follows: 60% in the first month after sale and 35% in the second month after sale. Prepare a schedule of cash receipts from sales for November. Sales WELLS COMPANY Schedule of Cash Receipts from Sales Cash receipts from: November $ 73,000 Total cash receipts $ 0 QS 20-22 (Algo) Computing budgeted accounts receivable LO P2 Kingston budgets total sales for June and July of $460,000 and $488,000, respectively. Cash sales are 65% of total sales. Of the credit sales, 20% are collected in the month of sale, 60% are collected during the first month after the sale, and the remaining 20% are collected in the second month after the sale. Determine the amount of accounts receivable reported on the company's budgeted balance sheet as of July 31. Hint: Determine the percent of June and July sales that are uncollected at July 31. As of July 31 Sales month Total Sales Credit Sales Percent Uncollected Amount Uncollected June July Total $ 460,000 488,000
Expert Answer:
Related Book For
Financial And Managerial Accounting Information For Decisions
ISBN: 9781259726705
7th Edition
Authors: John Wild, Ken Shaw, Barbara Chiappetta
Posted Date:
Students also viewed these finance questions
-
Analyzing Primark's Financial Performance Using Financial Ratios and Models Please note that if you edit your initial response (Original Post), you will not get credit for the Original Post. The...
-
Part 1 of 4 Points: 0 of 3 An engineer wants to determine how the weight of a gas-powered car, x, affects gas mileage, y. The accompanying data represent the weights of various domestic cars and...
-
Access the Securities and Exchange Commission Links to an external site. website or another site to find the most recent 10-K filing for a company of your choice. Locate the financial statements and...
-
Explain the difference between impregnation and infiltration. Give some applications for each?
-
Dave and Betty Wilder arranged a loan for their company, Wilder Enterprises Ltd., and personally guaranteed the loan. Janson was the manager of their bank branch and told them that he thought he...
-
Factor the trinomial. (a) w2 - 7w + 10 (b) p2 + 6p + 8 (c) x2 + 6x + 5
-
Management uses a voucher system to help control and monitor cash disbursements. Identify at least four key documents that are part of a voucher system of control. Explain each documents purpose,...
-
The inventory and sales data for this year for G. Rabbit Company are as follows: Required Using the above data from G. Rabbit Company, compute the following: a. The accounts receivable turnover in...
-
On January 1, 2025, Norma Smith and Grant Wood formed a computer sales and service company in Soapsville, Arkansas, by investing $91,620 cash. The new company, Kingbird Sales and Service, has the...
-
"TCL is not the market leader. Explain with Porter Five Forces analysis"
-
how fix this error import java.util.*; import java.lang.*; import java.io.*; import java.lang.Math; publicclass Main { publicstaticint leftrightString(String S) { //this is default OUT int result =0;...
-
The answer given previously related to the Minimum Variance Portfolio. Please note this question is about the Optimal Risky Portfolio: You are a fund manager in ABC asset management and you wish to...
-
A 30-year interest rate swap with a notional principal of $10,000,000 requires quarterly payments in arrears, based on 90-day LIBOR. The swap was entered into on April 1, 2015. If the fixed rate in...
-
1. What type of securities offerings do not need to be registered with the SEC? 2. List the three types of bank participants in an underwriting syndicate and their core responsibilities, in order of...
-
CoursHeroTranscribedText Utica Manufacturing (UM) was recently acquired by MegaMachines, Inc. (MM), and organized as a separate division within the company. Most manufacturing plants at MM use an ABC...
-
Select a villain from any genre you wish the genre you choose from can be from a cartoon, movie, comic, or literature. Include the name of the villain and the name of film. Do not choose Megamind,...
-
Determine the values of the given trigonometric functions directly on a calculator. The angles are approximate. tan 0.8035
-
The CEO of Green Oil Company, Dwight Allen, gave a speech at the World Environmental Conference. In his speech, Mr. Allen spoke about Green Oils goal of doing no damage to the environment as a result...
-
Define the following: run ticket settlement statement thief gauging strapping Define the following and explain their relevance to oil and gas revenue accounting: Henry Hub West Texas Intermediate...
-
Jackson Oil Company used 100 Mcf of gas obtained from Lease A and valued at $8.40/ Mcf for gas injection on Lease B. Assume production taxes are 5% and the royalty on Lease A is a 1/6 RI. a. Give the...
Study smarter with the SolutionInn App