Prepare cash budget for the month of April, May, and June 2019. Balance at the end of March 2019 shows an overdraft balance of RM48,000.

Preparing an operating budget Clipboard Office Supply's March 31, 2020, balance sheet follows: CLIPBOARD OFFICE SUPPLY Balance Sheet March 31, 2020 Assets Current Assets: Cash $ 28,000 Accounts Receivable 11,500 Merchandise Inventory 15,000 Prepaid Insurance 1,000 Total Current Assets $ 55,500 Property, Plant, and Equipment: Equipment and Fixtures 55,000 Less: Accumulated Depreciation (20,000) 35,000 Total Assets $ 90,500 Liabilities Current Liabilities: Accounts Payable $ 10,500 Salaries and Commissions Payable 1,200 Total Liabilities $ 11,700 Stockholders' Equity Common Stock 25,000 Retained Earnings 53,800 Total Stockholders' Equity 78,800 Total Liabilities and Stockholders' Equity $ 90,500

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

USING EXCEL, DEVELOP A PERSONAL CASH BUDGET COVERING MARCH 2023 - DECEMBER 2023

Shown below are the totals from 2025 period budgets.               Revenue budget                                                          $100,000             Materials usage from production budget                        15,000             Labor cost budget                                                           20,000             Manufacturing overhead budget                                     20,000             General and administrative budget                                 30,000             Capital expenditure budget                                             20,000             Work in Progress Inventories             Beginning of 2002                                                          10,000             End of 2002                                                                      5,000             Finished Goods Inventory             Beginning of 2002                                                          15,000             End of 2002…

Preparing a financial budget—budgeted income statement and balance sheet Bradley Company has the following post-closing trial balance on December 31, 2018 The company’s accounting department has gathered the following budgeting information for the quarter of 2019: Additional information: Direct materials purchases are paid 70°/o in the quarter purchased and 30% in the next quarter. Direct labor, manufacturing overhead, selling and administrative costs, and income tax expense are paid in the quarter incurred. Accounts payable at December 31, 2018 are paid in the first quarter of 2019. Requirements Prepare Bradley Company’s budgeted income statement for the first quarter of 2019. Prepare Bradley Company’s budgeted balance sheet as of March 31, 2019.

Prepare schedules for cash receipts and cash payments, and determine the ending balances for the relevant balance sheet accounts. E10.30 (LO 4, 5) Service Environmental Landscaping Inc. is preparing its budget for the first quarter of 2022. The next step is to prepare a cash receipts schedule and a cash payments schedule. The following information has been collected: 1. Clients usually pay 50% of their fee in the month when the service is provided, 40% the next month, and 10% in the second month after receiving the service. 2. Actual service revenues for 2021 and expected service revenues for 2022 are as follows: November 2021, $90,000; December 2021, $70,000; January 2022, $110,000; February 2022, $120,000; and March 2022, $130,000. 3. The company pays for purchases of landscaping supplies (direct materials) 60% in the month of purchase and 40% the following month. Actual purchases for 2021 and expected purchases for 2022 are: December 2021, $14,000; January 2022, $13,000; February…

Prepare Cash Budget from Budgeted Transactions 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…