Ivory Garments, a rapidly expanding garments producer based in Jordan, is in theprocess of formulating plans for 2022. The Director of Marketing has completed his2022 forecast and is confident that sales estimates will be met or exceeded.The following forecasted sales figures show the growth expected and will provide theplanning basis for other corporate departments.SALESSALES$4,600,0005,000,0004,600,0005,400,0006,000,0006,600,000JanuaryFebruaryJulyAugustSeptemberOctoberNovemberDecember$7,000,0007,000,0007,400,0007,400,0007,000,000MarchAprilMayJune7,800,000The Financial Controller of Ivory Garments has been given the responsibility forformulating the cash flow projection, a critical element during a period of rapidexpansion. The following information will be used in preparing the cash analysis:1. Most of the customers of Ivory Garments have a good track record in makingthe payments when due. The company collects 20% of its billings in the monthof the sale, 50% in the month after the sale and 30% in the second month afterthe sale. Uncollectible accounts are insignificant and should not be consideredin the analysis.2. The purchase of fabric is Ivory Garments' largest expenditure; the cost of theseitems equals 50% of sales. The company receives 60% of the fabrics onemonth prior to sale and 40% during the month of sale. Prior experience showsthat accounts payable are paid by Ivory Garments one month after receipt ofthe purchased fabrics.Administrative expenses are projected to be $4,280,000 for 2022. All of theseexpenses are incurred uniformly throughout the year except the property taxeswhich are paid in four equal instalments in the last month of each quarter. Thecomposition of administrative expenses is:Salaries$ 960,000Promotion320,000480,000720,000600,0001,200,000$4,280,000Property taxesInsuranceUtilitiesDepreciationTotal3. 4.Income tax payments are made by Ivory Garments in the first month of eachquarter based on income for the prior quarter. Ivory's income tax rate is 30%.Ivory's net income for the first quarter of 2022 is projected to be $1,350,000.5.Ivory Garments uses a calendar year reporting period.Required:a) Assuming that the closing cash balance at the end of the first quarter is$450,000, prepare a budgeted schedule of cash receipts and disbursements forIvory Garments by month, for the second quarter of 2022 (i.e., for the months ofApril, May and June).

Particulars Jan Feb March April May June July (a) (b) (c) (d) (e) (f) (g) Sales…

Assuming that the closing cash balance at the end of the first quarter is $450,000, prepare a budgeted schedule of cash receipts and disbursements for Ivory Garments by month, for the second quarter of 2022 (i.e., for the months of April, May and June).

Assuming that the closing cash balance at the end of the first quarter is $450,000, prepare a budgeted schedule of cash receipts and disbursements for Ivory Garments by month, for the second quarter of 2022 (i.e., for the months of April, May and June).

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

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
Waterways Corporation is preparing its budget for the coming year, 2020. The first step is to plan for the first quarter of that coming year. The company has gathered information from its managers in preparation of the budgeting process. Sales Unit sales for November 2019 111,000 Unit sales for December 2019 101,000 Expected unit sales for January 2020 113,000 Expected unit sales for February 2020 113,000 Expected unit sales for March 2020 118,000 Expected unit sales for April 2020 124,000 Expected unit sales for May 2020 137,000 Unit selling price $12 Waterways 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, totaled $181,800.Direct MaterialsDirect materials cost 80 cents per pound. Two pounds of direct materials…
In 2021 the company “AROFAH” will prepare a cash budget. The cash receipts and disbursements plan for the first six months (January to June) are as follows: Admission Plan: Sales Receipts: Sales are made in cash as much as 50% and 50% credit of sales. Of credit sales, 60% is received one month after the month of sale and the remaining is received 2 months after the month of sale. The total receipts of receivables in January and February are IDR 200,000 and IDR 300,000, respectively. The acceptance plans are: A. The amount of sales are: B. Other receipts are: January IDR 1,400,000 January IDR 200,000 February IDR 1,500,000 February IDR 300,000 March IDR 1,500,000 March IDR 100,000 April IDR 1,600,000 April IDR 200,000 May IDR 1,700,000 May IDR 400,000 June IDR 1,650,000 June IDR 500,000 2. Expediture Plan : A. Purchase of raw materials: B. Purchase of…
Cheddar's Café is preparing its cash budget for August. At the beginning of the month, the café expects to have $17,500 in total available cash. Over the course of the month, it expects to make $12,250 in cash disbursements and obtain $3,750 in financing. What is Cheddar's anticipated ending cash balance for August? O $9,000 O $5,250 O $26,000 O $1,500
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? А 200 В 1,700 c) 1,500 D
Colter Company prepares monthly cash budgets. Relevant data from operating budgets for 2022 are as follows. Sales Direct materials purchases Direct labor Manufacturing overhead Selling and administrative expenses Other data: 1. 2. 3. January February $360,000 $400,000 125,000 100,000 4. 120,000 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 $1,000 of depreciation per month. 90,000 70,000 79,000 75,000 85,000 Credit sales: November 2021, $250,000; December 2021, $320,000. Purchases of direct materials: December 2021, $100,000. Other receipts: January-Collection of December 31, 2021, notes…
Perez Company, which expects to start operations on January 1, 2018, will sell digital cameras in shopping malls. Perez has budgeted sales as indicated in the following table. The company expects a 12 percent increase in sales per month for February and March. The ratio of cash sales to sales on account will remain stable from January through March. Required a. Complete the sales budget by filling in the missing amounts. b. Determine the amount of sales revenue Perez will report on its first quarter pro forma income statement. Complete this question by entering your answers in the tabs below. Required A Required B Complete the sales budget by filling in the missing amounts. (Round intermediate calculations and final answers to 2 decimal places.) Sales January February March $ 46,000 116,000 Cash sales Sales on account Total budgeted sales $ 162,000
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.
Oriole Company is preparing its budgeted income statement 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,040,000 units. Quarterly sales are 19%, 26%, 27%, and 28%, respectively. The unit selling price is expected to be $41 for the first three quarters and $46 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 pounds of raw materials at a cost of $11 per pound. Management desires to maintain raw materials inventories at 10% of the next quarter's production requirements. Assume the production requirements for first quarter of 2023 are 468,000 pounds. Oriole budgets 0.4 hours of direct labor per unit, labor costs…
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…
Calculate for 2020: inventory turnover accruals debt ratio common stock net fixed assets turnover cash flow from operating activities cash flow from financing cash flow from investing activities net operating working capital please don't upload image
4. 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 $ 50,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?