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

Prepare a cash budget for the month ended May 31, 2019. Campton Company anticipates a cash balance of $89,000 on May 1, 2019. The following budgeted transactions for May 2019 present data related to anticipated cash receipts and cash disbursements: 1. For May, budgeted cash sales are $65,000 and budgeted credit sales are $505,000. (Credit sales for April were $450,000.) In the month of sale, 40% of credit sales are collected, with the balance collected in the month following sale. 2. Budgeted merchandise purchases for May are $285,000. (Merchandise purchases in April were $240,000.) In the month of purchase, 70% of merchandise purchases are paid for, and the balance is paid for in the following month. 3. Budgeted cash disbursements for salaries and operating expenses for May total $170,000. 4. During May, $25,000 of principal repayment and $4,000 of interest payment are due to the bank. 5. A $20,000 income tax deposit is due to the federal government during May. 6. A new delivery…
Prepare a cash budget to Pasadena Home Health Agency for the months of May, June, and July. The company wishes to maintain a $200, 000 minimum cash balance during the period, and it presently has a $220, 000 balance as of April 30. Revenues are presented in the table below. Revenues for Pasadena Home Health Agency January $500,000 February $500,000 March $600,000 April $600,000 May $700, 000 June $800, 000 July $1,000,000 August $ 1,000,000 The agency collects 30% of its revenue in the month billing occurred, 30% in the next month, and 25% in the following month. The agency fails to collect 15% of its revenue because of either bad debt or contractual allowances. Expense budget relationships are presented below: Payroll = $50,000 per month plus 0.50 x revenues Supplies = 0.10 x revenues Rent = $50,000 per month Debt service = $150,000 in July Capital expenditures $75,000 in June Eighty percent of payroll expense is paid in the month this expense was incurred, and 20% is paid in the…
Hamlett Company has prepared its sales budget for the first two quarters of 2024. Expected sales in units are 600,000 in the first quarter and 800,000 in the second quarter Hamlett Company likes to maintain an inventory at the end of each quarter equal to one -fourth of the next quarter's expected sales . The company had 150,000 units in inventory at the beginning of the first quarter (January 1 , 2024 ). How many units will Hamlett Company need to produce during the first quarter of 2024 ? 800,000 units 600,000 units None of the listed choices are correct 650,000 units 950,000 units
J
Pargo Company is preparing its budgeted income statement for 2020. Relevant data pertaining to its sales, production, and direct materials budgets are as follows. Sales. Sales for the year are expected to total 1,800,000 units. Quarterly sales are 20%, 24%, 277%, and 29%, respectively. The sales price is expected to be $41 per unit for the first three quarters and 546 per unit beginning in the fourth quarter. Saies in the first quarter of 2021 are expected to be 12% higher than the budgeted sales for the first quarter of 2020. Production. Management desires to maintain the ending finished goods inventories at 199%6 of the next quarter's budgeted sales volume. Direct materials Each unit requires 2 pounds of raw materials at a cost of 59 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 2021 are 497,000 pounds. Pargo budgets 0.2 hours of direct labor per unit,…
On January 1, 2020, the Hassan Engineering Co has reached agreement on the following data for the 6 months ending June 30, 2020. Sales units: First quarter 5,000; second quarter 6,000; third quarter 7,000 Ending finished goods inventory: 30% of the next quarter’s expected sales units The ending finished goods inventories at December 31, 2019, follow the same percentage relationships to production and sales that occur in 2020. What is the budgeted production for Quarter 2?
AlNahdha 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 a. $12,000 b.$22,000 c. None of the given answers d. $20,000 e. $10,000
In May 2022, the budget committee of Concord Stores assembles the following data in preparation of budgeted merchandise purchases for the month of June. 1. 2. 3. 4. (a) Expected sales: June $430,000, July $516,000. Cost of goods sold is expected to be 75% of sales. Desired ending merchandise inventory is 30% of the following (next) month's cost of goods sold. The beginning inventory at June 1 will be the desired amount. Your answer is correct. Compute the budgeted merchandise purchases for June. (b) Budgeted Cost of Goods Sold Add V Total Less V CONCORD STORES Merchandise Purchases Budget For the Month Ending June 30, 2022 Desired Ending Merchandise Inventory Beginning Merchandise Inventory Required Merchandise Purchases eTextbook and Media V CONCORD STORES Budgeted Income Statement (Partial) $ Prepare the budgeted multiple-step income statement for June through gross profit. $ $ 322500 116100 438600 (96750) 341850 Attempts: 2 of 3 used
An entity is budgeting its cash payments for the last quarter of 2020. All purchases are made on account with 2% discount for early payments. The October purchases is set at P150,000, and purchases increase by 20% based on the previous month. 50% of purchases are paid on the month of purchase, availing of the purchase discount; 45% are paid the next month; and 5% are paid after 2 months from date of purchase. How much is the total cash payment to be made in December 2020?
Hayma Company's sales budget for 2022 in units for the next five months is as follows: January 20,000, February 26,000, March 32,000, April 40,000 and May 42,000. The Company's ending finished goods inventory policy is set for 25% of the following month's sales. January 1 beginning inventory is 2,800 units. How many units will be produced in ?January 34,000 .a O 40,500 .b О 16,300 .c O 27,500 .d C 23,700 .e O .None of the given answers .f O
Bramble 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 960,000 units. Quarterly sales are 22%, 27%, 27%, and 24%, respectively. The unit selling price is expected to be $42 for the first three quarters and $45 beginning in the fourth quarter. Sales in the first quarter of 2023 are expected to be 15% 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 $12 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 432,000 pounds. Prepare the sales budget by quarters for 2022.
The Mara Company expects sales in 2019 of 205,000 units of chairs. Mara’s beginning inventory for 2019 is 10,000 chairs and its target ending inventory is15,000 chairs.Compute the number of chairs budgeted for production in 2019.