Prepare a master budget for the three-month period ending June 30 that includes a schedule of expected cash collections, by month and in total. Case 8-33 (Algo) Master Budget with Supporting Schedules [LO8-2, LO8-4, LO8-8, LO8-9, LO8-10]You have just been hired as a new management trainee by Earrings Unlimited, a distributor of earrings to various retail outlets locatedin shopping malls across the country. In the past, the company has done very little in the way of budgeting and at certain times of theyear has experienced a shortage of cash. Since you are well trained in budgeting, you have decided to prepare a master budget forthe upcoming second quarter. To this end, you have worked with accounting and other areas to gather the information assembledbelow.The company sells many styles of earrings, but all are sold for the same price-$17 per pair. Actual sales of earrings for the last threemonths and budgeted sales for the next six months follow (in pairs of earrings):January (actual)February (actual)March (actual)April (budget)May (budget)23, 600 June (budget)29,600 July (budget)43,60068,600103,60053,60033,60031,60028,600August (budget)September (budget)The concentration of sales before and during May is due to Mother's Day. Sufficient inventory should be on hand at the end of eachmonth to supply 40% of the earrings sold in the following month.Suppliers are paid S5.80 for a pair of earrings. One-half of a month's purchases is paid for in the month of purchase; the other half ispaid for in the following month. All sales are on credit. Only 20% of a month's sales are collected in the month of sale. An additional70% is collected in the following month, and the remaining 10% is collected in the second month following sale. Bad debts have beennegligible.Monthly operating expenses for the company are given below:Variable:Sales commissions4% of salesF1d:$ 380,00036,000$ 142,000$ 16,000$ 4,800$ 32,000AdvertisingRentSalariesUtilitiesInsuranceDepreciationInsurance is paid on an annual basis, in November of each year.The company plans to purchase $25,000 in new equipment during May and $58,000 in new equipment during June; both purchaseswill be for cash. The company declares dividends of $28,500 each quarter, payable in the first month of the following quarter. The company's balance sheet as of March 31 is given below:AssetsCashAccounts receivable ($50, 320 February sales; $592,960March sales)InventoryPrepaid insuranceProperty and equipnent (net)Total assets92,000643,280159,15230,0003,130,000$ 2,054,432Liabilities and Stockholders' EquityAccounts payableDividends payableCommon stockRetained earningsTotal liabilities and stockholders' equity118,e0028,5001,160,e0e747,932$ 2,054,432The company maintains a minimum cash balance of $68.000. All borrowing is done at the beginning of a month; any repayments aremade at the end of a month.The company has an agreement with a bank that allows the company to borrow in increments of S1,000 at the beginning of eachmonth. The interest rate on these loans is 1% per month and for simplicity we will assume that interest is not compounded. At the endof the quarter, the company would pay the bank all of the accumulated interest on the loan and as much of the loan as possible (inincrements of $1.000), while still retaining at least $68,000 in cash.Required:Prepare a master budget for the three-month period ending June 30. Include the following detailed schedules:1. a. A sales budget, by month and in total.b. A schedule of expected cash collections, by month and in total.C. A merchandise purchases budget in units and in dollars. Show the budget by month and in total.d. A schedule of expected cash disbursements for merchandise purchases, by month and in total.2. A cash budget. Show the budget by month and in total. Determine any borrowing that would be needed to maintain the minimumcash balance of $68,000.3. A budgeted income statement for the three-month period ending June 30. Use the contribution approach.4. A budgeted balance sheet as of June 30.Complete this question by entering your answers in the tabs below.Reg 1AReg 18Reg 10Reg 10Reg 2Reg 3Req 4Prepare a master budget for the three-month period ending June 30 that includes a schedule of expected cash collections, bymonth and in total.Earrings UnlimitedSchedule of Expected Cash CollectionsAprilMayJuneQuarterFebruary salesMarch salesApril salesMay salesJune salesTotal cash collections

Budgeting: It is a process of planning the work to be performed. Under this process a formal plan is made to utilize the available resources or to calculate the amount of resources needed to complete the work. By doing this process, an organization will know the funds it will require to acquire the resources required. Cash budget: It is a budget of estimated cash receipts and payments for a period. The cash receipts are the expected revenues from the business and the payments include operating and non-operating expenses, asset acquisitions etc.

Answered: Prepare a master budget for the…

Business

Accounting

Prepare a master budget for the three-month period ending June 30 that includes a schedule of expected cash collections, by month and in total.

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

the task of preparing the cash budget for the business for the quarter ending September 30, 2022. Your data collection has yielded the following:i) Extracts from the sales and purchases budgets are as follows:Month CashSales SalesOn Account CashPurchases PurchasesOn AccountMay $75,000 $480,000 $390,000June $135,000 $600,000 $36,000 $360,000July $86,800 $720,000 $61,700 $450,000August $105,600 $640,000 $68,800 $400,000September $112,500 $800,000 $77,250 $500,000ii) An analysis of the records shows that trade receivables (accounts receivable)…
Use the following information to prepare the June cash budget for Vox Company. It should show expected cash receipts and cash disbursement for the month and the cash balance expected on June 30. a. Beginning cash balance on June 1 is $66,000. b. Cash receipts from sales are expected to be $1,544,000. c. Cash payments for direct materials and direct labor are expected to be $206,400 and 501,050, respectively. d. Budgeted cash payments for variable overhead is $315,000. e. Budgeted depreciation, the only fixed overhead estimated for June: $18,000. f. Cash selling and administrative expenses budgeted for June are $328,000. g. Bank loan interest due in June: $9,000. i. Loan payment of $60,000 should be made if the preliminary cash balance is greater than $200,000
Assets Cash Accounts receivable Inventory Buildings and equipment, net of depreciation Total assets Liabilities and Stockholders' Equity Accounts payable Note payable Common stock Retained earnings Total liabilities and stockholders' equity Minden Company Balance Sheet April 30 $ 9,000 54,000 30,000 207,000 $300,000 $ 63,000 14,500 180,000 42,500 $300,000
(a) The business needs to have a sense of its future cash flows and therefore requires the preparation of the following:▪ A schedule of budgeted cash collections for trade receivables (sales on account) for each of the months January to March. ▪ A schedule of expected cash disbursements for accounts payable (purchases on account) for each of the months January to March. ▪ A cash budget, with a total column, for the quarter ending March 31, 2022, showing the expected cash receipts and payments for each month and the ending cash balance for each of the three months, given that no financing activities took place.
Which of the following budgets shows how many units will be produced each period?
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…
Mary Mouch is in the process of preparing budgets for the period October to December 2019. The following information has been provided to assist in the budgeting process: 1. Budgeted monthly sales revenue is as follows: October N$ 40 000 November N$ 70 000 December N$ 50 000 January 2020 N$ 45 000 Sales are 20% cash and 80% credit. Credit sales are collected over a three month periodd, 15% in the month of sale, 70% in the month following sale and 15% in the second month following sale. Bad debts of 5% are anticipated on all credit sales. Total revenue in August amounts to N$30 000 and September's total sales revenue amounts to N$ 36 000. 2. Cost of sales is expected to amount to 60% of sales revenue each month. 3. The business maintains its closing inventory levels at 75% of the following month's cost of sales. Inventory at the begining of October is expected to amount to N$ 18 000. 4. 50% of inventory purchased is paid in the month of purchase. The remaining 50% is paid…
Owe
A cash budget. Show the budget by month and in total. Determine any borrowing that would be needed to maintain the minimum cash balance of $57,000.
Lavage Rapide is a Canadian company that owns and operates a large automatic car wash facility near Montreal. The following table provides estimates concerning the company's costs: Fixed Cost Cost per per Month Car Washed Cleaning supplies Electricity Maintenance $ 0.80 $ 0.09 $ 0.20 $ 0.40 $ 1,400 $ 4,700 $ 8,000 $ 1,900 $ 1,600 Wages and salaries Depreciation Rent Administrative expenses $ 0.03 For example, electricity costs should be $1,400 per month plus $0.09 per car washed. The company expects to wash 8,000 carg in August and to collect an average of $6.30 per car washed. Required: Prepare the company's planning budget for August. Lavage Rapide Planning Budget
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.
Martin Clothing Company is a retail company that sells hiking and other outdoor gear specially made for the desert heat. It sells to individuals as well as local companies that coordinate adventure getaways in the desert for tourists. The following information is available for several months of the current year: Month May June July August Sales $ 99,000 118,000 135,000 132,000 Purchases $ 63,000 89,000 115,000 72,000 Required 1 Required 2 The majority of Martin's sales (65 percent) are cash, but a few of the excursion companies purchase on credit. Of the credit sales, 35 percent are collected in the month of sale and 65 percent are collected in the following month. All of Martin's purchases are on account with 55 percent paid in the month of purchase and 45 percent paid the following month. Required: 1. Determine budgeted cash collections for July and August. 2. Determine budgeted cash payments for July and August. Cash Expenses Paid $ 22,000 Complete this question by entering your…