The following data and information are provided to prepare a cash budget for November-December 2022:1. Budgeted sales for the last 2 months of 2022 are $156,600 (November) and $180,000 (December).2. All sales are credit sales. The company expects to collect 60% of credit sales in the month of thesale and 40% in the month after the sale.3. All necessary merchandise inventories are purchased on account. Purchases are paid 70% in the monthof the purchase and 30% in the following month. Purchases for November-December 2022 areestimated to be $108,000 (November) and $121,000 (December).4. Selling and administrative expenses for November and December are $15,000 and $12,000,respectively, excluding monthly depreciation expense $1,000.5. Equipment will be purchased in December 2022 for $43,000.6. $36,000 bonus will be distributed to shareholders in December 2022.7. Cash balance on November 1st was $8,200.8. The company has a policy to maintain a minimum cash balance of $5,000. If necessary, the companywill borrow to meet its short-term needs. All borrowing is done at the beginning of the month and allpayments on principal and interest are made at the end of the next month. The annual interest rate is9%. The company must borrow in multiples of $1,000.9. October sales were $140,400 and merchandise inventory purchased equal $101,000.Prepare the cash budget for November-December 2022.(No currency needed, no decimal needed, no thousand separators or "unit" needed. Example: the correctanswer is "2000000". If you answer "2.000.000" or "2,000,000.00" or "Rp 2 juta", they all will be consideredwrong. If the answer is zero, answer "0")Total cash disbursement for merchandise inventory purchased in Dec 2022Total cash disbursement for bonus in Dec 2022Total cash disbursement for selling and admin expense in Nov 2022Ending cash balance in Dec 2022Accounts Receivable at 31 Dec 2022

"Since you have posted a question with multiple sub-parts, we will solve the first three sub-parts…

Answered: Prepare the cash budget for…

Business

Accounting

Prepare the cash budget for November-December 2022.

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

(b) Another team member who is preparing the Budgeted Balance Sheet for the business forthe same quarter ending September 30, 2022, has asked you to furnish him with the figuresfor the expected trade receivables and payables to be included in the statement. Is that areasonable request? If yes, what should these amounts be? (c) Upon receipt of the budget, the team manager, Dannie Bruce, has now informed you that, inkeeping with industry players, the management of Salat Household Furnishings haveindicated an industry requirement to maintain a minimum cash balance of $155,000 eachmonth. He has also noted that management is very keen on keeping the gearing ratio of thebusiness as low as possible and would therefore prefer to cushion any gaps internally usingequity financing.Based on the budget prepared, will the business be achieving this desired industry target?Suggest three (3) internal strategies that may be employed by management to improve theorganization's monthly cash flow and…
Develop your enterprise budgeting policy for the second quarter of 2022 and prepare your cash budget for the period. (ii) The forecasted sales are as follows: January February March April May June RM 185,000 RM 200,000 RM 360,000 RM 320,000 RM 195.000 RM 250,500 (iii) Sales shall consist of cash and credit sales. Credit sales shall have at least TWO (2) patterns of the collection. (iv) You have a space on your premises that is available for rental. Determine the rental value and collection policy. (vi) What will be your purchase payment pattern? It needs to have at least THREE (3) patterns of settlement. (vii) List down FIVE (5) types of monthly business expenses. Describe the payment policy. (viii) Illustrate ONE (1) investment that your business had invested in. The return on investment will be received in April. (ix) Describe ONE (1) depreciation expenses of non-current assets in your enterprise. (x) The cash amount as of 31 March 2022 is expenses…
solve please with clear and proper explanation , calculation for each part and steps answer in text form underline explanation , computation for all
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
Prepare a direct materials budget for the first quarter of the financial year ending 30 September 2022. Prepare a cash budget for the first quarter of the financial year ending 30 September 2022 including any necessary schedules. Prepare a budgeted income statement for the first quarter of the financial year ending 30 September 2022.
Splish Company has accumulated the following budget data for the year 2022: 1. 2. 3. 4. 5. 6. 19 Sales: 27,900 units; unit selling price $82 Cost of one unit of finished goods: direct materials, 2 kg at $5 per kilogram; direct labour, 3 hours at $13 per hour; and manufacturing overhead, $6 per direct labour hour Inventories (raw materials only): beginning, 9,900 kg; ending, 14,100 kg Raw materials cost: $5 per kilogram Selling and administrative expenses: $201,000 Income taxes: 30% of income before income taxes
j
Hh2. Account
Arjuna Sdn Bhd is preparing its annual budgets for the year to 31 December 2016. It manufactures and sells one product, which has a selling price of RM130. The marketing Director believes that the prices can be increased to RM140 with effect from 1 July 2016 and that at this price the sales volume for each quarter of 2016 will be as follows: Sales Volume Quarter 1 Quarter 2 Quarter 3 Quarter 4 30,000 40,000 20,000 35,000 Sales for each quarter 2017 are expected to be 30,000 units. Each unit of the finished product requires four units of components A and three units of component B, together with a body shell C (Component C). These items are purchased from an outside supplier and their current prices are: RM Component A Component B Component C 7.00 each 4.00 each 20.00 each The component are expected to increase price by 10% with effect from 1 April 2016, no change is expected for the price of the shell. Assembly of the shell and components into the finished product requires 6 labour…
The Current Designs staff has prepared the annual manufacturing budget for the rotomolded line based on an estimated annual production of 3,960 kayaks during 2020. Each kayak will require 56 pounds of polyethylene powder and a finishing kit (rope, seat, hardware, etc.). The polyethylene powder used in these kayaks costs $1.00 per pound, and the finishing kits cost $150 each. Each kayak will use two kinds of labor-2 hours of type I labor from people who run the oven and trim the plastic, and 3 hours of work from type II workers who attach the hatches and seat and other hardware. The type I employees are paid $19 per hour, and the type II are paid $16 per hour. Manufacturing overhead is budgeted at $381,520 for 2020, broken down as follows. Variable costs Indirect materials Manufacturing supplies Maintenance and utilities Fixed costs Supervision Insurance Depreciation Total Polyethylene powder Finishing kits Type I labor Type II labor Indirect materials Manufacturing supplies Maintenance…
Why should an organization revise its budget for the fourth quarter?
Use the information provided below to prepare the following for November and December 2021: 1. Debtors Collection Schedule