ranus sells wires and lLTeportS the foiiovng irom its sales buuget. Expected Sales amount: July RM 97,000 August RM117,000 September RM127,000 Cash sales are normally 30% of total sales and all credit sales are expected to be collected in the month following the date of sale. The total amount of cash expected to be received from customers in September is:
Q: Frankie's Chocolate Co. expects to sell the following units for $25/each. Expected Sales: July…
A: CASH BUDGET Cash Budget is a detailed budget of cash income and cash expenditure incorporating both…
Q: Schedule of Cash Collections of Accounts Receivable OfficeMart Inc. has "cash and carry" customers…
A: Projected sales are an estimate of revenue which is expected to be earned by the company in the near…
Q: Estimated sales for the next four months are as follows (in $ million): Month Cash sales Credit…
A: In accounting we often make cash budgets. A cash budget is a budget or a document that shows the…
Q: Culver Company has the following account balances: Sales Revenue $241,400, Sales Discounts $4,310,…
A: Journal Entry is first stage of Accounting Process. Journal Entry is the process of recording all…
Q: The company began business on January 1 of the current year. The first quarter sales are estimated…
A: First quarter mean January, February, March.
Q: Compute the Cash Collected in March. Total Sales January 40, 000 February 50,000 March 70,000 The…
A: The objective of the question is to calculate the total cash collected by the company in the month…
Q: Wells Company reports the following sales forecast: September, $55,000; October, $66,000; and…
A: Schedule of cash receipts: A schedule of cash receipts shows how much cash is expected from debtors…
Q: Vaughn Industries expects credit sales for January, February, and March to be $268,400, $317,200,…
A: Given, 75% of credit sales collected in month of sale 25% of credit sales will be collected in the…
Q: Schedule of cash collections of accounts receivable OfficeMart Inc. has "cash and carry" customers…
A: Cash BudgetThe estimates of cash received and cash payments for the future accounting periods are…
Q: Marlin Company projects the follwoing sales for the first thre months of the year: $11500 in…
A: Working Note Particulars January February March Total Budgeted Sales 11,500…
Q: Assume that your credit sales for March was $16,288,for April was $33,301 and May was $29,261. If…
A: The cash budget is prepared to know the estimated cash receipt and cash expenses. it helps in the…
Q: 1. Bongo Drumz Inc had the following pattern of sales for the months indicated: Sales Nov $48,000…
A: The objective of the question is to calculate the total cash receipts for the months of January,…
Q: Johnson Corporation has the following sales forecasts for the first three months of the current…
A: Computation of the cash balance at the end of January:Cash balance, January 1$25,000Add: Cash…
Q: OfficeMart Inc. has "cash and carry" customers and credit customers. OfficeMart estimates that 25%…
A: A cash budget is an estimation of expected cash receipts and disbursements on the basis of past…
Q: Frontier Ltd., a leader in solar technology, makes all sales on credit, offering terms 2/10 net 40.…
A: Cash Budget budget is to be prepared for April may and june month. Jan, Feb and march sales are…
Q: chedule of Cash Collections from Sales or the Three Months Ending December 31 October November…
A: Schedule of cash collections shows the cash receipts and cash inflows from different customers.…
Q: A firm has projected sales in May, June, and July of P10,000, P20,000, and P30,000, respectively.…
A: Usually, the Firm needs to assess the cash position to assess the cash requirement from time to…
Q: Homer Company expects credit sales for January to be $50,000. Cash sales are expected to be $30,000.…
A: Given, Credit sales for January = $50,000 Cash sales for January = $30,000 Increase in sales = 10%…
Q: Carla Vista Industries expects credit sales for January, February, and March to be $211,200,…
A: Step 1:Understanding meaning of budget:- Management prepares budget in order to estimate future…
Q: Ratchet Manufacturing anticipates total sales for August, September, and October of $300,000,…
A: Formula: Cash collection amount = Sales value x Cash collection ratio
Q: 2. Ann Marie Roopchand Company has forecast its sales as follows: $180,000 (actual) August September…
A: Budgets are made to determine the expected cash receipts and expected cash expenses to be incurred…
Q: June sales were $20,000, while projected sales for July and August were $50,000 and $71,000,…
A: The cash collection schedule is prepared to estimate the cash collection during the given period.…
Q: Here is a forecast of sales by National Bromide for the first 4 months of 2022 (figures in thousands…
A: Budgeting is a technique of estimating future sales, expenses, receipts and payments on the basis of…
Q: Here is a forecast of sales by National Bromide for the first four months of 2022 (figures in $…
A: The cash inflow calculation include calculating credit sales and cash sale . The total sales is…
Q: Schedule of Cash Collections of Accounts Receivable Office World Inc. has "cash and carry" customers…
A: Effective resource allocation includes the use of budgeting to allocate money, labor, and supplies.…
Q: Prepare a Sales Budget for all four months, showing breakdown between cash and credit sales Sales…
A: CASH BUDGET Cash Budget is a detailed budget of cash income and cash expenditure incorporating both…
Q: The Palos Company expects sales for June, July, and August of $48,000, $54,000, and $44,000,…
A: Credit sales: Sales are made to customer but payment will be delayed to a future date. Formulas:
Q: Schedule of Cash Collections of Accounts Receivable OfficeMart Inc. has "cash and carry" customers…
A: Schedule of cash collection is prepared to calculate the company's collection from receivables for…
Q: Power Ridge Corporation has forecast credit sales for the fourth quarter of the year as follows:…
A: Cash receipt schedule is an important tool any firm can use. One can estimate the receipt of the…
Q: Ballentine Company expects sales for June, July, and August of $65,000, $71,000, and $61,000,…
A: Cash sales for August (61,000 x 40%) = $24,400
Q: Compute the Cash Collected in March. Total Sales January 40,000 February 50,000 March 70,000 The…
A: Sure, let's display only the calculations: 1. **Cash Sales in March**: \[ \text{Cash Sales} =…
Q: In 2021, Chatsworth Company expects sales of $40,000 in July, $50,000 in August, and $30,000 in…
A: July sales = $40,000 July Cash sales = 40% July Credit sales = 60% Uncollectble amount = 5% of…
Q: Here is a forecast of sales by National Bromide for the first four months of 2019 (figures in $…
A: As per the given information: Month 1 Month 2 Month 3 Month 4 Cash sales 17 26 20 16…
Q: chedule of Cash Collections of Accounts Receivable OfficeMart Inc. has "cash and carry" customers…
A: Cash collection schedule is prepared to estimate the total receipts of a particular period. Total…
Q: Schedule of Cash Collections of Accounts Receivable OfficeMart Inc. has "cash and carry" customers…
A: A cash sale is a sale where the consideration(money) is received immediately for the goods sold or…
Q: n August 1 of the current year. Projected sales for the next three months are as follows: $100,000…
A: Schedule of Expected Cash Collections: Schedule of Expected Cash Collections from the customers…
Q: Hernandez Company expects credit sales for January to be $58,000. Cash sales are expected to be…
A: Total sales = Cash sales + Credit Sales The company will receive cash in February for Credit sales…
Q: A firm has projected sales in May, June, and July of $100, $200, and $300, respectively. The firm…
A: A quantity of money given to a company in exchange for goods or services: We add the cash receipts…
Q: J. Lo's Clothiers has forecast credit sales for the fourth quarter of the year: Fourth Quarter…
A: Clothiers for the fourth quarter, has the following amounts:September (actual): $73,000October:…
Q: Pacific Place has developed the following sales forecast for the following months. Month…
A: Introduction Cash budget: Cash budget is an estimate of cash receipts and cash payments for a future…
Q: The company began business on January 1 of the current year. The first quarter sales are estimated…
A: Formula: Amount to be collected in March = January month sale collected in March month + February…
Q: Swifty Industries expects credit sales for January, February, and March to be $176,000, $208,000,…
A: It is a financial plan that estimates the amount and timing of cash inflows from various sources,…
Q: Eastern Auto Parts Inc. has 20 percent of its sales paid for in cash and 80 percent on credit. All…
A: Solution:- Cash receipt budget is the budget prepared to forecast the upcoming cash receipts by the…
Q: XYZ sdn bhd estimating its cash requirement for the third quarter year 2011. The company's projected…
A: Cash budget was used to estimate a firm's both cash inflows and outflows for a period of time.
Step by step
Solved in 3 steps
- Schedule of Cash Collections of Accounts Receivable OfficeMart Inc. has "cash and carry" customers and credit customers. OfficeMart estimates that 25% of monthly sales are to cash customers, while the remaining sales are to credit customers. Of the credit customers, 20% pay their accounts in the month of sale, while the remaining 80% pay their accounts in the month following the month of sale. Projected sales for the next three months are as follows: October $127,000 November 159,000 December 232,000 The Accounts Receivable balance on September 30 was $85,000. Prepare a schedule of cash collections from sales for October, November, and December. Round all calculations to the nearest whole dollar. OfficeMart Inc.Schedule of Cash Collections from SalesFor the Three Months Ending December 31 October November December Receipts from cash sales: Cash sales $fill in the blank 1 $fill in the blank 2 $fill in the blank 3 September sales on account:…5 At Lyman Company, past experience reveals that 10% of sales are for cash and the remaining 90% are on credit. Lyman Company expects to collect 30% of its credit sales in the month of sale, 50% in the month following sale, and 18% in the second month following sale. Which ONE of the following is part of the cash collections expected to be made in January? O Cash sales from the preceding December O Cash collections of credit sales from the preceding December O Cash collections of credit sales from the preceding September O Cash sales from the preceding NovemberA company is preparing its cash buget for the month of May. Below is A/R information: Actual credit sale for March $130,000 Actual credit sale for April $160,000 Estimated credit sales for May $210,000 Estimated collections in the month of sale 25% Estimated collections in the first month after the month of sale 60% Estimated collections in the second month after the month of sale 10% Estimated provision of bad debts (made in month of sale) 5% ** Firm writes off all UNCOLLECTIBLE account receievables at the end of second month after the month of sale. Required: For the month of May, calculate the following: 1. Estimated cash receipts from account recievable collections. 2. The gross amount of A/R at the end of the month (after appropriate write off of uncollectiable amounts). 3. The net amount of A/R at the end of the month 4. Recalculate the requirement 1 & 2 under the assumption that estimated collections in the month of sale equal 60% and in the first…
- Whispering Company has the following sales projections for its second and third quarters: Аpril $300,000 Мay $320,000 June $340,000 July $360,000 August $350,000 September $330,000 Normal cash collection experience has been that 40% of sales are collected during the month of sale, 20% in the month following sale, and 35% in the second month following sale. The remaining 5% of sales is never collected.the second quarter of 2021: Credit sales Credit purchases Cash disbursements Wages, taxes, and expenses Interest Equipment purchases Beginning cash balance Cash receipts Cash collections from credit sales Total cash available Cash disbursements The company predicts that 5 percent of its credit sales will never be collected, 30 percent of its sales will be collected in the month of the sale, and the remaining 65 percent will be collected in the following month. Credit purchases will be paid in the month following the purchase. Purchases Wages, taxes, and expenses Interest In March 2021, credit sales were $190,000 and credit purchases were $130,000. Using this information, complete the following cash budget: (Do not round intermediate calculations. Leave no cells blank - be certain to enter "0" wherever required.) Equipment purchases April May June $320,000 $300,000 $360,000 128,000 151,000 176,000 Total cash disbursements 44,000 11,000 80,000 Ending cash balance 11,500 11,000 150,000 $…Bennett Inc. found that about 35% of its sales during the month were for cash. Bennett has the following accounts receivable payment experience: Percent paid in the month of sale 25 Percent paid in the month after the sale 68 Percent paid in the second month after the sale 5 Bennett's anticipated sales for the next few months are as follows: April $250,000 May 290,000 June 280,000 July 295,000 August 300,000 Required: 1. Calculate credit sales for May.$ Calculate credit sales for June.$ Calculate credit sales for July.$ Calculate credit sales for August.$ Feedback 2. Prepare a schedule of cash receipts for July and August. Round your answers to the nearest whole dollar, if necessary. If an amount box does not require an entry, leave it blank or enter "0". Be sure to enter percentages as whole numbers. Bennett Inc.Schedule of Cash ReceiptsFor July and August July…
- Neon Inc.’s forecast sales for July is $72,000. It has $15,000 in accounts receivable at the end of June. 30% of its total sales are expected to be cash sales. Of the remaining 70%, 80% are expected to be collected in the month of the sale and the remaining 20% in the month following the sale. Determine the amount of accounts receivable at the end of July. Group of answer choices $79,200 $61,920 $10,080 $40,320Star Company was organized on August 1 of the current year. Projected sales for the next three months are as follows: August $250,000 September 200,000 October 275,000 The company expects to sell 50% of its merchandise for cash. Of the sales on credit, 30% are expected to be collected in the month of the sale and the remainder in the following month. What is Star Company expected cash collection for September?Schedule of Cash Collections of Accounts Receivable OfficeMart Inc. has "cash and carry" customers and credit customers. OfficeMart estimates that 25% of monthly sales are to cash customer while the remaining sales are to credit customers. Of the credit customers, 20% pay their accounts in the month of sale, while the remainim 80% pay their accounts in the month following the month of sale. Projected sales for the next three months are as follows: October November December $109,000 136,000 199,000 The Accounts Receivable balance on September 30 was $73,000. Prepare a schedule of cash collections from sales for October, November, and December. Round all calculations to the nearest whole dolla OfficeMart Inc. Schedule of Cash Collections from Sales For the Three Months Ending December 31 November Receipts from cash sales: Cash sales September sales on account: Collected in October October sales on account: Collected in October Collected in November November sales on account: October…
- You collect 75% of a month's sales in the month of the sale and 25% of sales in the following month. May sales June sales July sales O $105 O $35 $120 Compute cash inflows for June. $135 $140 $100 not enough information, because sales revenue differsSchedule of cash collections of accounts receivable OfficeMart Inc. has "cash and carry" customers and credit customers. OfficeMart estimates that 25% of monthly sales are to cash customers, while the remaining sales are to credit customers. Of the credit customers, 30% pay their accounts in the month of sale, while the remaining 70% pay their accounts in the month following the month of sale. Projected sales for the next three months are as follows: October $58,000 November 65,000 December 72,000 The Accounts Receivable balance on September 30 was $35,000. Prepare a schedule of cash collections from sales for October, November, and December. Enter all amounts as positive numbers. OfficeMart Inc. Schedule of Cash Collections from Sales For the Three Months Ending December 31 Line Item Description Receipts from cash sales: Cash sales September sales on account: Collected in October October sales on account: Collected in October Collected in November November sales on account: Collected…Financial information for Strawberry’s Place is as follows: Cash at 1/1/20X1 is $10,000. The firm desires to maintain a minimum balance of $10,000 at the end of each month. Total monthly sales are as follows: DecemberJanuaryFebruary 20X020X120X1 $120,000150,000 (est.)160,000 (est.) The sales are 40 percent cash and 60 percent credit card. Visa is the only acceptable credit card at Strawberry’s, and assume the charges are converted to cash the day of the sale. The brokerage charge is 2 percent of the sale. Expected other income is $2,000 from interest to be received in February. In addition, in January, a range with a net book value of $300 is expected to be sold for cash, resulting in a $1,000 gain on the sale. Food and beverages are paid for the month following the sale and average 40 percent and 25 percent, respectively. Food sales are four times beverage sales. Total sales consist of only food and beverage sales. Labor is paid for the last day of the month and…