PR 22-4A Cash budget OBJ. 5 The controller of Sonoma Housewares Inc. instructs you to prepare...
Fantastic news! We've Found the answer you've been seeking!
Question:
![image text in transcribed](https://s3.amazonaws.com/si.experts.images/answers/2024/05/66578b794519a_36966578b793ee54.jpg)
![image text in transcribed](https://s3.amazonaws.com/si.experts.images/answers/2024/05/66578b7984b8b_36966578b7980bbc.jpg)
Transcribed Image Text:
PR 22-4A Cash budget OBJ. 5 The controller of Sonoma Housewares Inc. instructs you to prepare a monthly cash bud- get for the next three months. You are presented with the following budget information: Sales Manufacturing costs. Selling and administrative expenses Capital expenditures May $86,000 34,000 15,000 June July $90,000 $95,000 39,000 44,000 16,000 22,000 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 re- mainder 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 pe- riod 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. PR 22-4A Cash budget OBJ. 5 The controller of Sonoma Housewares Inc. instructs you to prepare a monthly cash bud- get for the next three months. You are presented with the following budget information: Sales Manufacturing costs. Selling and administrative expenses Capital expenditures May $86,000 34,000 15,000 June July $90,000 $95,000 39,000 44,000 16,000 22,000 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 re- mainder 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 pe- riod 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.
Expert Answer:
Posted Date:
Students also viewed these accounting questions
-
The following stream is at 200 psia and 200?F. Determine whether it is a subcooled liquid or a superheated vapor, or whether it is partially vaporized, without making a flashcalculation. Component...
-
LaShonda Blake, an unmarried employee, works 48 hours in the week ended January 12. Her pay rate is $12 per hour, and her wages are subject to no deductions other than FICASocial Security, PICA...
-
In 2006, Sunbeam Corporation acquired a silver mine in eastern Alaska. Because the mine is located deep in the Alaskan frontier, Sunbeam was able to acquire the mine for the low price of $50,000. In...
-
Problem #8: Consider the following function. e&x+5 Problem #8(a): Problem #8(b). f(x) 8-5e&r (a) Find the two horizontal asymptotes of f. (b) Find the vertical asymptote of f. Enter your answer...
-
Uncle Scrooge also has a company that is in the process of being sold: The offer on the is 10x Book Value. The balance sheet reflects 100,000,000 R/E Shares authorized 1,000,000 Share out standing...
-
Do size and value effects mean that small stocks outperform large stocks or value stocks outperform growth stocks in every year/every month? Explain.
-
Calculate approximately how far the shoes traveled betweenCalifornia and Hawaii. They traveled around 2,000mi betweenCalifornia and Hawaii. Considering the distance you figured in #6, and the time...
-
Assume that due to staff shortages, two junior cyber security technicians have been assigned responsibilities above their expertise level. They are happy with the new job but concerned about their...
-
Exercise 12-8A (Algo) Determining cash flow from investing activities LO 12-3 On January 1, Year 1, Shelton Company had a balance of $271,000 in its Land account. During Year 1, Shelton sold land...
-
Please create the model of a library database. Describe the one-to-many relationships in the library database What is the name of the DDL file you exported in step 2.3 Generate DDL ? Create a...
-
The following data concerns a proposed equipment purchase: Cost $156,000 Salvage value Estimated useful life Annual net cash flows 4,500 4 years $ 52,100 Straight-line Depreciation method Ignoring...
-
You have the opportunity to work on an internship in a foreign country for an audit firm with an office in that country. What would be the pros and cons of such an experience, and what would you do...
-
It was mentioned in the chapter that KPMG has reorganized itself around five national industry-focused teams that consist of assurance, tax, and consulting professionals concentrating on each...
-
What are some different ways auditing firms can service their global clients? What are the strengths and weaknesses of each approach?
![Mobile App Logo](https://dsd5zvtm8ll6.cloudfront.net/includes/images/mobile/finalLogo.png)
Study smarter with the SolutionInn App