**Sonoma Housewares, Inc. Cash Budget***For the Three Months Ending July 31, 2021*This document presents the estimated cash budget for Sonoma Housewares, Inc. spanning the months of May, June, and July 2021. The budget is structured to detail both cash inflows and outflows, along with calculations for changes in cash balance over this period.### Estimated Cash Receipts:- **Cash sales**: Expected cash received from sales.- **Collection of accounts receivable**: Cash expected from outstanding invoices.**Total Cash Receipts**: This is the sum of cash sales and the collection of accounts receivable.### Estimated Cash Payments:- **Manufacturing costs**: Payments related to production costs.- **Selling and administrative expenses**: Payments for operational and administrative expenses.- **Capital expenditures**: Payments for long-term investments or purchases.- **Other purposes**: - **Income tax**: Estimated tax payments. - **Dividends**: Payments made to stockholders.**Total Cash Payments**: Cumulative total of all estimated cash outflows.### Cash Flow Calculation:- **Cash increase or (decrease)**: The net change in cash, calculated by subtracting total cash payments from total cash receipts.- **Cash balance at beginning of month**: Starting cash balance at the start of each month.- **Cash balance at end of month**: Ending cash balance after accounting for the cash increase or decrease.- **Minimum cash balance**: Required minimum amount of cash to be maintained.- **Excess or (deficiency)**: The difference between the cash balance at the end of the month and the minimum cash balance.This cash budget template helps in assessing the financial planning and liquidity of the company over the three-month period. The shaded columns represent cells in the spreadsheet that may require formula computations, as indicated by the "Formula Bar" label. **PR 22-4A Cash Budget**The controller of Sonoma Housewares Inc. instructs you to prepare a monthly cash budget for the next three months. You are presented with the following budget information:| | May | June | July ||------------------|-------|-------|-------|| Sales | $86,000 | $90,000 | $95,000 || Manufacturing costs | 34,000 | 39,000 | 44,000 || Selling and administrative expenses | 15,000 | 16,000 | 22,000 || Capital expenditures | - | - | 80,000 |The company expects to sell about 10% of its merchandise for cash. Of sales on account, 70% are expected to be collected in the month following the sale and the remainder the following month (second month following sale). Depreciation, insurance, and property tax expense represent $3,500 of the estimated monthly manufacturing costs. The annual insurance premium is paid in September, and the annual property taxes are paid in November. Of the remainder of the manufacturing costs, 80% are expected to be paid in the month in which they are incurred and the balance in the following month.Current assets as of May 1 include cash of $33,000, marketable securities of $40,000, and accounts receivable of $90,000 ($72,000 from April sales and $18,000 from March sales). Sales on account for March and April were $60,000 and $72,000, respectively. Current liabilities as of May 1 include $6,000 of accounts payable incurred in April for manufacturing costs. All selling and administrative expenses are paid in cash in the period they are incurred. An estimated income tax payment of $14,000 will be made in June. Sonoma’s regular quarterly dividend of $5,000 is expected to be declared in June and paid in July. Management desires to maintain a minimum cash balance of $30,000.**Instructions:**1. Prepare a monthly cash budget and supporting schedules for May, June, and July 2016.

Solution 1: Computation of Collection from Customer Particulars May June July Collection for…

The controller of Sonoma Housewares Inc. instructs you to prepare a monthly cash bu get for the next three months. You are presented with the following budget information May June July Sales .. $86,000 $90,000 $95,000 Manufacturing costs.. Selling and administrative expenses . Capital expenditures 34,000 39,000 44,000 15,000 16,000 22,000 80,000 The company expects to sell about 10% of its merchandise for cash. Of sales c account, 70% are expected to be collected in the month following the sale and the r

The controller of Sonoma Housewares Inc. instructs you to prepare a monthly cash bu get for the next three months. You are presented with the following budget information May June July Sales .. $86,000 $90,000 $95,000 Manufacturing costs.. Selling and administrative expenses . Capital expenditures 34,000 39,000 44,000 15,000 16,000 22,000 80,000 The company expects to sell about 10% of its merchandise for cash. Of sales c account, 70% are expected to be collected in the month following the sale and the r

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

Flint, Inc. provided the following information: Projected merchandise purchases . March April $67,000 $75,000 Budgeted cash disbursements $ Flint pays for 40% of merchandise purchases in the month of the purchase and 60% in the following month. General operating expenses are budgeted to be $25,000 per month of which depreciation is $2,000 of this amount. Flint pays operating expenses in the month incurred. Calculate Flint's budgeted cash disbursements for May. May $81,000
Dog
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
Garden Depot is a retailer that is preparing its budget for the upcoming fiscal year. Management has prepared the following summary of its budgeted cash flows: Total cash receipts. Total cash disbursements 1st Quarter 2nd Quarter 3rd Quarter $ 210,000 $ 240,000 $ 281,000 $ 241,000 The company's beginning cash balance for the upcoming fiscal year will be $26,000. The company requires a minimum cash balance of $10,000 and may borrow any amount needed from a local bank at a quarterly interest rate of 3%. The company may borrow any amount at the beginning of any quarter and may repay its loans, or any part of its loans, at the end of any quarter. Interest payments are due on any principal at the time it is repaid. For simplicity, assume that interest is not compounded. Beginning cash balance Total cash receipts Total cash available Total cash disbursements Excess (deficiency) of cash available over disbursements Financing: Borrowings Repayments Interest $360,000 $ 251,000 Required: Prepare…
The management accountant at Miller Merchandising & More, Odail Russell is in the process of preparing the cash budget for the business for the fourth quarter of 2021. It is customary for thebusiness to borrow money during this quarter. Extracts from the sales and purchases budgets areas follows:Month cash sales sales on account purchasesAugust $85,000 $640,000 $420,000September $70,000 $550,000 $550,000October $88,550 $600,000 $500,000November $77,160 $800,000 $600,000December $174,870 $500,000 $450,000 i) An analysis of the records shows that trade receivables are settled according to the following credit pattern, in accordance with the credit terms 4/30, n90:50% in the month of sale30% in the first month following the sale20% in the second month…
The Puyer Corporation makes and sells only one product called a Deb. The company is in the process of preparing its Selling and Administrative Expense Budget for next year. The following budget data are available: Sales commissions Shipping Advertising Executive salaries Depreciation on office equipment Other Multiple Choice $ 50,000 $ 60,000 $ 20,000 $ 40,000 All of these expenses (except depreciation) are paid in cash in the month they are incurred. If the budgeted cash disbursements for selling and administrative expenses for April total $195,500, then how many Debs does the company plan to sell in April? 14,400 units 8.000 units Monthly Fixed Cost 10,200 units Variable Cost Per Deb Sold $ 0.90 $ 1.40 $ 0.20
Treasure Service anticipates the following sales revenue over a five-month period: Its collection history indicates that credit sales are collected as follows: E (Click the icon to view the sales data.) A (Click the icon to view the collections data.) The company's sales are 20% cash and 80% credit. How much cash will be collected in Janua More Info 25% in the month of the sale 50% in the month after the sale Complete the cash budget to determine how much cash will be collected in January, February, March and for the quarter in total. (Round your answers to the nearest whole do 20% two months after the sale Treasure Service 5% are never collected Cash Collections Budget For the Months of January through March January Data Table Print Done Cash sales Collection of credit sales: 25% Month of sale November December January February March 50% Month after Sales revenue....... 16,100 $ 10,000 $ 15,200 $ 12,000 $ 14,200 20% Two months after Total cash collections Print Done
Getty Company expects sales for the first three months of next year to be $205,000, $270,000 and $300,000, respectively. Getty expects 30 percent of its sales to be cash and the remainder to be credit sales. The credit sales will be collected as follows: 10 percent in the month of the sale and 90 percent in the following month. Compute a schedule of Getty's cash receipts for the months of February and March. February March Budgeted cash receipts
Refer to the picture for the problem and template. 1 picture has the info and prompt. The other picture has the template.
Z & J Merchandising & More is a family-owned auto-parts store. You are the management accountant of the concern and have been given the task of preparing the cash budget for the business for the quarter ending March 31, 2021. (i)Your data collection has yielded the following: Month November 2020 – March 2021 cash sales Sales on account Purchases November $151,100 $480,000 $390,000 December $145,500 $600,000 $360,000 January $159,025 $700,000 $505,000 February $169,350 $650,000 $400,000 March $176,200 $800,000 $518,000 (ii) An analysis of the records shows that trade receivables (accounts receivable) are settled according to the following credit pattern, in accordance with the credit terms 2/30, n90: 45% in the month of sale 30% in the first month following the sale 25% in the second month following the sale…
Jake Company needs to calculate the amount of cash it expects to collect for themonth of july using the following info: Month Credit SaIesMay　　　　200,000　budgetedJune　　　　230,000 budgetedJuIy　　　　 220,000　budgetedAugust　　　250,000　budgetedThe company has historically collected its receivables as follows:Collections in month of sale 30%Collections one month after the sale 50%ColIections two months after the sale 20%