Al-Nahdha company is preparing its cash budget for the first half of the year 2022. The company records shows that it has $20,000 in the cash at the start of the period. Cash collections from customers for the period are budgeted at $56,000. Purchases of inventory as budgeted will cost cash payment during the period of $60,000. The Company intends to keep its cash balance at the end of the period at $10,000. Other operating expenses for this period are budgeted at $30,000, which includes $4,000 depreciation and any cash expenses are paid in the month incurred. How much borrowing will the company need in the first half of 2022? O a $12,000 O b. $10,000 OC None of the given answers O d. $20,00O O e. $22,000

Al-Nahdha company is preparing its cash budget for the first half of the year 2022. The company records shows that it has $20,000 in the cash at the start of the period. Cash collections from customers for the period are budgeted at $56,000. Purchases of inventory as budgeted will cost cash payment during the period of $60,000. The Company intends to keep its cash balance at the end of the period at $10,000. Other operating expenses for this period are budgeted at $30,000, which includes $4,000 depreciation and any cash expenses are paid in the month incurred. How much borrowing will the company need in the first half of 2022? O a $12,000 O b. $10,000 OC None of the given answers O d. $20,00O O e. $22,000

FINANCIAL ACCOUNTING

10th Edition

ISBN:9781259964947

Author:Libby

Publisher:Libby

Chapter1: Financial Statements And Business Decisions

Section: Chapter Questions

Problem 1Q

See similar textbooks

Similar questions

please help me
Capstone, Inc. is preparing its budget for the coming year, 2020. The first step is to plan for the first quarter of that coming year. Capstone, Inc. gathered the following information from the managers. Sales Unit sales for November 2019 112500 Unit sales for December 2019 104,000 Expected unit sales for January 2020 116,000 Expected unit sales for February 2020 115,500 Expected unit sales for March 2020 117,000 Expected unit sales for April 2020 135,000 Expected unit sales for May 2020 145,000 Unit selling price $13.00 Capstone, Inc. likes to keep 10% of the next month’s unit sales in ending inventory. All sales are on account. 85% of the Accounts Receivable are collected in the month of sale, and 15% of the Accounts Receivable are collected in the month after sale. Accounts receivable on December 31, 2019,…
NUBD Company has budgeted its activity for October 2021 based on the following information:i. Sales are budgeted at P300,000. All sales are credit sales and a provision for doubtful accounts is made monthly at the rate of 3% of sales. ii. Merchandise inventory was P70,000 at September 30, 2021 and an increase of P10,000 was planned for the month. iii. All merchandise is marked-up to sell at invoice cost plus 50%. (Gross profit rate based on cost) iv. Estimated cash disbursements for selling and administrative expenses for the month are P40,000. v. Depreciation for the month is projected at P5,000. NUBD is projecting operating income for the month of October 2021 in the amount of:a. 96,000 b. 56,000 c. 55,000 d. 46,000
Windsor Company is preparing its master budget for 2022. Relevant data pertaining to its sales, production, and direct materials budgets are as follows. Sales: Sales for the year are expected to total 1,200,000 units. Quarterly sales are 25%, 25%, 25%, and 25%, respectively. The sales price is expected to be $41 per unit for the first three quarters and $44 per unit beginning in the fourth quarter Sales in the first Quarter of 2023 are expected to be 10% higher than the budgeted sales for the first quarter of 2022 Production: Management desires to maintain the ending finished goods inventories at 20% of the next quarter's budgeted sales volume. Direct materials Each unit requires 2 kg of raw materials at a cost of $10 per kilogram. Management desires to maintain raw materials inventories at 10% of the next quarter's production requirements. Assume the production requirements for the first quarter of 2023 are 410.000 kg. Prepare the Sales Budget by quarter for 2022.
MORGAN Merchandising is preparing its Production Budget for the 3rd Quarter of 2020. Its Sales Budget is prepared using a budgeted sales price per unit agreed upon at the beginning of the year. To help in the Production budget preparation, the following information are given: 1. Inventories at the end of 2019 can be sold for a total of P225,000 at a sales price of P250 per unit. 2. Production runs are only done at the start of each quarter. 3. A minimum of 200 units are to be maintained at the end of each quarter to serve as buffer stocks. 4. Budgeted quantities sold for the 1st quarter of 2020 is 4,500 units. 5. It is forecasted that the same quantities will be sold per month of each quarter. 6. It is estimated that quantities sold will increase by 500 units at the start of each quarter. 7. MORGAN Merchandising estimates a gross profit rate of 35%. What is the beginning inventory for March 2020? A 200 В 1,700 c) 1,500
Pelican Merchandising & More is a family-owned store. The business is now approaching the end of the year and is in the process of identifying its cash needs for the first quarter of the new year. You are the management accountant of the entity and have been tasked to prepare the cash budget for the business for the quarter ending March 31, 2022.(i) Extracts from the sales and purchases budgets are as follows:Month 2021 - 2022 Cash Sales Sales On Account Cash Purchases Purchases On Account November 2021 $138,100 $480,000 $345,000 December 2021 $156,500 $600,000 $25,800 $380,000 January 2022 $170,975 $650,000 $44,625 $400,000 February 2022 $135,740 $700,000 $30,400 $480,000 March 2022 $226,420 $800,000 $55,100 $540,000(ii) An analysis of the records shows that trade receivables (accounts receivable) are settled according to the following credit pattern, in accordance with the credit terms 4/30, n90:55% in the month of sale35% in the first month following the sale 8% in the second…
Rishi Sunak Manufacturing Pte. Ltd. is preparing its budget for next year. The company estimates that it will be making the following raw materials purchases in the last five months of 2021: $200,000 in August, $220,000 in September, $250,000 in October, $280,000 in November and $240,000 in December. The company anticipates that it will pay 55% of what is owed one month after the month of purchase, 30% of what is owed two months after the month of purchase and the remaining 15% three months after the month of purchase. What figure will be presented in the company’s cash budget for payments for raw materials purchases in December 2021? $233,500 $253,500 $262,000 $403,500
Scannell, Inc. sells tire rims. Its sales budget for the nine months ended September 30, 2024, and additional information follow: (Click the icon to view the budget.) (Click the icon to view additional information.) Prepare an inventory, purchases, and cost of goods sold budget for each of the first three quarters of the year. Compute cost of goods sold for the entire nine-month period. Plus: Less: More info Scannell, Inc. Inventory, Purchases, and Cost of Goods Sold Budget Nine Months Ended September 30, 2024 Quarter Ended March 31 In the past, cost of goods sold has been 40% of total sales. The director of marketing and the financial vice president agree that each quarter's ending inventory should not be below $15,000 plus 10% of cost of goods sold for the following quarter. The marketing director expects sales of $200,000 during the fourth quarter. The January 1 inv ory was $19,000. Print Done X Data table Cash sales, 30% Credit sales, 70% Total sales $ $ Quarter Ended June 30…
Pelican Merchandising & More is a family-owned store. The business is now approaching the end of the year and is in the process of identifying its cash needs for the first quarter of the new year. You are the management accountant of the entity and have been tasked to prepare the cash budget for the business for the quarter ending March 31, 2022. (i) Extracts from the sales and purchases budgets are as follows: Month Cash Sales Cash Purchases 2021 - 2022 Sales On Purchases On Account Account November 2021 December 2021 January 2022 February 2022 March 2022 $138,100 $156,500 $170,975 $135,740 $480,000 $345,000 $600,000 $650,000 $700,000 $800,000 $25,800 $44,625 $30,400 $380,000 $400,000 $480,000 $226,420 $55,100 $540,000 (ii) An analysis of the records shows that trade receivables (accounts receivable) are settled according to the following credit pattern, in accordance with the credit terms 4/30, n90: 55% in the month of sale 35% in the first month following the sale 8% in the second…
Use the following information to prepare a cash budget for Knightsbridge Corporation for the month of June 2020. In May, credit sales were $175,000; 80% of this amount is estimated to be collectible in June. June sales are estimated to be $340,000, all of which are credit sales. Only 20% of credit sales are collected in the month in which the sale is made. Total fixed expenses are $60,000 per month, including $26,000 depreciation. Variable expenses are 35% of sales. All expenses requiring payment are paid in cash when incurred. A $40,000 note payable must be paid on June 30. As of May 31, the cash balance is $94,000.
Coronado Company prepares monthly cash budgets. Relevant data from operating budgets for 2022 are as follows. January February Sales $331,200 $368,000 Direct materials purchases 110,400 115,000 Direct labor 82,800 92,000 Manufacturing overhead 64,400 69,000 Selling and administrative expenses 72,680 78,200 All sales are on account. Collections are expected to be 50% in the month of sale, 30% in the first month following the sale, and 20% in the second month following the sale. Sixty percent (60%) of direct materials purchases are paid in cash in the month of purchase, and the balance due is paid in the month following the purchase. All other items above are paid in the month incurred except for selling and administrative expenses that include $920 of depreciation per month.Other data: 1. Credit sales: November 2021, $230,000; December 2021, $294,400. 2. Purchases of direct materials: December 2021, $92,000. 3. Other…
BCAS Ltd is developing a cash budget for April, May and June 2022, and the following information was gathered: Cash Receipts 1 Sales revenue for February and March 2022 are $200,000 and $180,000 respectively. The forecasted sales revenue for April, May and June 2022 are $170,000, $220,000 and $280,000 respectively. Historically, 30% of the firm’s sales are in cash, 60% are collected in the next month, and the remaining 10% are collected in the second month following the sale. 2 Monthly rental income received is $60,000. 3 Interest income of $10,000 will be received in May 2022. Cash Disbursements 4 The expected purchases are $150,000, $110,000 and $190,000 for the months of April, May and June 2022 respectively. The company pays all its purchases in the month of purchase. 5 Monthly salaries paid is $70,000. 6 Commission is paid to its salesman at 2% of current month’s sales. 7 Renovation of all retail outlets amounting to $400,000…