Carson Ltd. has prepared the following 2021 projections for its beverage company: Sales Month Cash Sales Credit Sales $ 16,000 20,000 May $ 68,000 June 80,000 July 18,000 74,000 August 24,000 92,000 September 22,000 76,000 Receivables have been historically collected at the following rates: • 40% in the month of sale 45% in the month following sale 15% two months after sale Inventory Purchases Month Purchase Amounts May $ 70,000 June 72,000 July 74,000 August 78,000 September 80,000 40% of purchases are paid for in cash in the month of sale, and the balance is paid the following month.
Q: Please prepare a Cash Receipts section, Cash payments section and use the template below for your…
A: The company makes 20 percent of its sales for cash and 80 percent on credit. Of credit sales, 50…
Q: Eddie's Bar and Restaurant Supplies expects its revenues and payments for the first part of the year…
A: Cash Budget is that Ledger / Account which is prepare on estimated figure basis for know the Cash…
Q: Jane MacDonald, Carroll Financial Analyst, prepared the following sales and cash disbursement…
A: Cash budget is the forecasting of the cash revenues and expenditures that an entity might plan to…
Q: Office World Inc. has "cash and carry" customers and credit customers. Office World estimates that…
A: WORKING NOTE : 1) The cash sales for any month will be: 0.20 * Sales of that month. 2) Cash…
Q: the following are forecasts of sales and purchases for a company. Sales…
A: Formula: Cash collections = Sales value x Amount collection percentage
Q: Star Co. was organized on August 1 of the current year. Projected sales for the next three months…
A: Schedule of Expected Cash Collections: Schedule of Expected Cash Collections from the customers…
Q: Sequoia Furniture Company's sales over the past three months, half of which are for cash, were as…
A: A. Collection period is 60 days. Half of the sales of each month are credit Thus credit sales of…
Q: The following forecasted sales pertain to Micah Company: Month Sales April $200,000 May 250,000…
A: Budgeted sales unit in April = Budgeted sales / sales price per unit = $200000/$10 = 20000 units…
Q: The Dilly Company (DC) began operations on December 1, 2021. All sales are credit sales with 50%…
A: cash collection is calculated by multiplying the collection % with the respective month sales.
Q: How much cash would be collected in June from sales? * NUBD Co. has the following sales forecasts…
A: The question is related to the Budgetory Control. In the question it is given that Cash Sales = 75%…
Q: Assume a merchandising company's estimated sales for January, February, and March are $105,000,…
A:
Q: NUBD Co. has the following sales forecasts for the selected three month period in 2021: Month April…
A: 75% of sales of June will be collected in June. 25 of sales of May will be collected in June.
Q: A company has the following collection pattern: month of sale 40%; month following sale, 60%. If…
A: Note : Sales of Feb Corrected : $200000 Statement of Computation of Cash Collection In February…
Q: Ralpha company is selling a product of $35 per unit. The estimated sales in units would be March,…
A: A budget is the projected financial statements of an organization for a specific period of time in…
Q: The following are forecasts of sales and purchases for KWANGYA Company: Sales Purchases April…
A: Cash payment is the amount of money paid in order to recompense the expenses.
Q: Magenta Corporation has the following sales forecasts for the selected three-month period for the…
A: Cash Budget: Cash Budget is a schedule to record cash inflows and outflows over a period with a view…
Q: 1.A financial analyst for Carroll Company has prepared the following sales and cash disbursement…
A: Cash budget is a pre-planned record of expenditures and revenues. It is used to estimate the…
Q: Dai Hing Bookshop Ltd. has a beginning cash balance of $44,000 on November 1. The firm has projected…
A: November collection = 15/30 x 61000 + 68000 x15/30 = $64500 December collection = 15/30 x 68000 +…
Q: A company's sales for the coming months are as follows: April, P175,000 June, P140,000 August,…
A: The Cash Budget is the total estimation of the total cash receipts and the total cash to be disburse…
Q: lion company expects $650,000 of credit sales in march and $800,000 of credit sales in april. lion…
A: The cash budget keeps the records of cash requirements in the business.
Q: 16. On December 31,2021, the Denjay Gift Shop had outstanding accounts receivable balance of…
A: Budget: A budget is an estimation to determine the income that will be earned and expenses that will…
Q: Dolittle and Dalley has $4,000 in purchases for January and $6,000 in purchases for February. It…
A: Total Cash payments for inventory in February = (Purchases for February ×70%) + (Purchases of…
Q: Simpson Glove Company has made the following sales projections for the next six months. All sales…
A: Answer - The Cash Receipts Schedule - A cash receipts schedule/ budget shows the pattern and…
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: OfficeMart Inc. has "cash and carry" customers and credit customers. OfficeMart estimates that 25%…
A: Prepare a schedule of cash collections from sales for October, November and December as shown below:…
Q: Planet Company purchased goods worth $50,000 in July and expects to purchase goods worth $70,000 in…
A: Solution:- Computation of total expected cash disbursement for the month of August as follows…
Q: A company estimates the following sales demand from Jan- July 2021: Sales (Units) 150,000 180,000…
A: The cash collection from the credit sale depends on the credit policy followed by the firm. A…
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: Roque Company has been accumulating operating data in order to prepare an annual profit plan.…
A: This is monthly budgeting of the company. Based on…
Q: Trapp Co. was organized on August 1 of the current year. Projected sales for the next three months…
A: A cash budget is an estimation of expected cash receipts and disbursements on the basis of past…
Q: Calculate the net accounting profit for December. Calculate the net cash flow for December. Comment…
A: net accounting profit for the month of December = sales - purchases…
Q: The following are expected sales figure of ABC Ltd. Month January February March April OMR OMR OMR…
A: Expected Cash collection for March=60%×Sale of Feb.+40%×Sale of…
Q: NUBD Company is developing a forecast of March 2021 cash receipts from credit sales. Credit sales…
A: opening Receivable =300000 Receivable represent January sale=300000/4=75000 Receivable represent Feb…
Q: NUBD Company is developing a forecast of March 2021 cash receipts from credit sales. Credit sales…
A: Accounts receivable from January sales = Beginning accounts receivable x 1/4 = 300000*1/4 = P75,000…
Q: The following are forecasts of sales and purchases for KWANGYA Company: Sales Purchases April…
A: Cash flows are the cash generated from the operation of the business organisation. In other words,…
Q: Sioux Corporation is estimating the following sales for the first four months of next year:…
A:
Q: The Runner Antique Mall expects to make purchases in the first quarter of 2021 as follows: January…
A: Introduction: A cash disbursement is a payment made in exchange for goods or services. A cash…
Q: Halifax Shoes has 30% of its sales in cash and the remainder on credit. Of the credit sales, 65% is…
A: The cash budget is prepared by the management to estimate the expected cash receipt and cash…
Q: Reed Merchandising Company expects to purchase P90,000 of materials in July and P105,000 of…
A: The cash budget is prepared to record the cash receipts and payment made during the period.
Q: Consider the following information for a given company. Month Cash Sales Credit Sales Jan $80.000…
A: Given, Cash sales = $80,000 for January
Q: Eastern Auto Parts Inc. has 20 percent of its sales paid for in cash and 80 percent on credit. All…
A: This question said that cash sales are 20% and credit sales are 80%. The credit sales are recovered…
Q: Trapp Co. was organized on August 1 of the current year. Projected sales for the first three months…
A: Working notes: Excel workings:
Q: tar Company was organized on August 1 of the current year. Projected sales for the next three months…
A: Cash account means where cash receipts is added to the opening cash balance and all cash payment…
Q: Aston Company reported the following balances at September 30, 2020: Sales Revenue $280,000 Sales…
A: Net sales of the business means sales revenue of the business after all the sales returns and…
Q: roughly evenly split between credit and cash sales, with half the credit sales collected in the…
A: Given information : December 31 2021 accounts receivable 20000 Month sales Oct-21 150000…
Q: Al Bahr Corporation, a wholesaler, provided the following information Month Sales January 64000…
A: The budget is prepared to estimate the cash collection in the future.
Q: HOM Enterprises estimated the following sales for the first six months of 2022: Month Estimated…
A: The cash budget is prepared by the management to estimate the expected cash collection and cash…
Q: Trapp Co. was organized on August 1 of the current year. Projected sales for the next three months…
A: Cash collections schedule represents the cash collected by an entity during a specific period by…
Q: Eddie's Bar and Restaurant Supplies expects its revenues and payments for the first part of the year…
A: Formula: Cash received amount = Total sales x collectible percentage of sales amount for the month.…
Step by step
Solved in 4 steps with 4 images
- The management of Kirkut Enterprises prepared the following forecasted total sales schedule for the five months ending December 2021 August September October November December R310 000 R330 000 R325 000 R340 000 R410 000 Additional information: Cash sales comprise 40% of total sales. These customers are entitles to a 4% discount. Credit sales are collected as follows: 40% in the month of sale - these customers get a 2% discount 55% in the month after the sale 5% is written off as bad debts Cash receipts for cash sales made for the period August to December will total: O A. R686 000 O B. R1 715 000 O C. R658 560 D. R1 646 400Shown below is the sales forecast for Cooper Inc. for the first four months of the coming year Apr $14,000 S70.000 Feb Cash sales Credit sales On average, 50% of credit sales are paid for in the month of the sale. 30% in the month following sale, and the remainder are paid two Jan $15.000 $100,000 $24,000 $120.000 Mar $20,000 $90,000 months after the month of the sale Assuming there are no bad debts, the expected cash intlow in March is:Data regarding a company's monthly sales for the last six months of the year and its projected collection patterns are shown below:Forecasated sales:July = P775,000August = P750,000September = P825,000October = P800,000November = P850,000December = P900,000Types of sales:Cash sales = 20%Credit sales = 80%Collection pattern for credit sales:In the month of sale = 40%In the first month following the sale = 57%Uncollectible = 3% The cost of merchandise averages 40% of its selling price. The company's policy is to maintain an inventory equal to 25% of the next month's forecasted sales. The inventory balance at cost is P80,000 as of June 30. How much is the total cash receipts that would be budgeted for the month of September?
- ABC LCC sells its products on a gross profit of 20% on sales. The following information Is extracted from its annual accounts for the year ended 31st March 2020. Amount $ 40,00,000 12,00,000 9,60,000 12,00,000 Manufacturing expenses (one month in arrears) Administration expenses (one month in arrears) 4,80,000 Sales promotion expenses (Payable half yearly in advance) 200,000 Sales (3months credit) Raw materials Wages (15 days in arrears) The company enjoys one month's credit from suppliers of raw materials and maintains 2 months stock of raw materials and one and a half months finished goods. Cash balance is maintained at $100,000 as a precautionary balance. Assuming a 10%margin, find out the working capital requirements of ABC LCC.Consider the following information for a given company: Month Cash Sales Credit Sales Jan $80.000 $350,000 Feb $60,000 $200,000 Mar $50.000 $145,000 Apr $45,000 $130,000 May $55,000 $170,000 Jun $50,000 $150,000 The firm's collection pattern is as follows: 60% in the month of sale 30% one month following sale 10% two months following sale The accounts receivable balance on 1 Jan is $70,000. Of this amount, $60,000 represents uncollected Dec sales and $10,000 represents uncollected Nov sales. Required: Determine the total cash collected during Jan. (INPUT YOUR ANSWER IN THOUSANDS USING A COMMA SEPARATOR. NO ROUNDING REQUIRED. FOR EXAMPLE: 100,000)The following forecasted sales pertain to Micah Company: Month Sales April $200,000 May 250,000 June 150,000 July 100,000 Collection pattern:60% in month of sale40% in month following the sale Accounts receivable as of March 31 $35,000 Finished goods inventory as of March 31 4,000 units The company has a selling price of $10 per unit and expects to maintain ending inventories equal to 20% of the next month's sales. How many units are expected to be produced in April?
- 32. Brown Company estimates that monthly sales will be as follows. January February March P100,000 150,000 180,000 Historical trends indicate that 40% of sales are collected during the month of sale, 50% are collected in the month following the sale, and 10% are collected two mon ths after the sale. Brown's accounts receivable balance as of December 31 totals P80,000 (P72,000 from December's sales and P8,000 from November's sales). The amount of cash Brown can expect to collect during the month of January is a. P76,800. b. P84,000. c. P108,000. d. P133,000.A company estimates the following sales demand from Jan- July 2021: Sales (Units) 150,000 180,000 120,000 240,000 210,000 180,000 240,000 Month Jan Feb March April Мay June July Cash sales account for 50% of the total sales. Debtors are granted 2 months credit, of which half is collected in the month following sales, and the other half after 2 months. Determine the collection from sales in each of the months from April – June 2021. Explain how the credit policy offered by a company affects the budgeting exercise. (All workings must be clearly shown)JoAnn Manufacturing has projected the following sales for the coming year 01 02 03 04 Sales $53,475 $59,725 $ 68,775 $ 74,050 The company places orders each quarter that are 30 percent of the following quarter's sales and has a 30-day payables period. What is the payment of accounts for the third quarter? Mutiple Choice O $21.360.00 121687.50 $22.22969 $19,72750
- Roque Company has been accumulating operating data in order to prepare an annual profit plan. Details regarding Roque’s sales for the first 6 months of the coming year are as follows: Forecasted sales January P600,000; February P650,000; March P700,000; April P625,000; May P720,000; June P800,000 Types of sales Cash sales 20% Credit sales 80% Collection Pattern for Credit Sales Month of sale 30% One month following sale 40% Second month following sales 25% Roque’s cost of goods sold averages 40% of the sales value. Roque’s objective is to maintain a target inventory equal to 30% of the next month’s sales in units. Purchases of merchandise for resale are paid for in the month following the sale. The variable operating expenses (other tan cost of goods sold) for Roque are 10% of sales and are paid for in the month following the sale. The annual fixed operating expenses are presented below. All of these are incurred uniformly throughout the year and paid monthly except for insurance and…Roque Company has been accumulating operating data in order to prepare an annual profit plan. Details regarding Roque’s sales for the first 6 months of the coming year are as follows: Forecasted sales January P600,000; February P650,000; March P700,000; April P625,000; May P720,000; June P800,000 Types of sales Cash sales 20% Credit sales 80% Collection Pattern for Credit Sales Month of sale 30% One month following sale 40% Second month following sales 25% Roque’s cost of goods sold averages 40% of the sales value. Roque’s objective is to maintain a target inventory equal to 30% of the next month’s sales in units. Purchases of merchandise for resale are paid for in the month following the sale. The variable operating expenses (other tan cost of goods sold) for Roque are 10% of sales and are paid for in the month following the sale. The annual fixed operating expenses are presented below. All of these are incurred uniformly throughout the year and paid monthly except for…Assume a merchandising company’s estimated sales for January, February, and March are $105,000, $125,000, and $115,000, respectively. Its cost of goods sold is always 30% of its sales. The company always maintains ending merchandise inventory equal to 10% of next month’s cost of goods sold. What are the required merchandise purchases for January?