Compute a monthly cash budget and supporting schedules

Assignment Help Financial Accounting
Reference no: EM131193862

Cash Budgets

The controller of Santa Fe Housewares Inc. instructs you to prepare a monthly cash budget for the next three months. You are presented with the following budget information:

                                                                   March       April         May
Sales . . . . . . . . . . . . . . . . . . . . . . . . . . . . $70,000   $84,000   $92,000
Manufacturing costs. . . . . . . . . . . . . . . . . . 32,000       39,000   42,500
Selling and administrative expenses . . . . . . .12,000       18,000   21,000
Capital expenditures . . . . . . . . . . . . . . . . . 20,000

The company expects to sell about 10% of its merchandise for cash. Of sales on account, 70% are expected to be collected in full in the month following the sale and the remainder the following month. Depreciation, insurance, and property tax expense represent $3,000 of the estimated monthly manufacturing costs. The annual insurance premium is paid in July, 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 March 1 include cash of $10,000, marketable securities of $40,000, and accounts receivable of $75,600 ($60,000 from February sales and $15,600 from January sales). Sales on account for January and February were $52,000 and $60,000, respectively. Current liabilities as of March 1 include a $12,000, 15%, 90-day note payable due May 20 and $4,000 of accounts payable incurred in February for manufacturing costs. All selling and administrative expenses are paid in cash in the period they are incurred. It is expected that $1,800 in dividends will be received in March. An estimated income tax payment of $16,000 will be made in April. Santa Fe's regular quarterly dividend of $3,000 is expected to be declared in April and paid in May. Management desires to maintain a minimum cash balance of $30,000.

Instructions

1. Prepare a monthly cash budget and supporting schedules for March, April, and May.

2. On the basis of the cash budget prepared in part (1), what recommendation should be made to the controller?

Reference no: EM131193862

Questions Cloud

How many different types of this shirt are made : A particular brand of shirt comes in 12 colors, has a male version and a female version, and comes in three sizes for each sex. How many different types of this shirt are made?
Second-degree price-discrimination scheme : Suppose that individual demand for a product is given by QD=1000-5P. Marginal revenue is MR=200-0.4Q, and marginal cost is constant at $20. Show that this second-degree price-discrimination scheme is more profitable than a single monopoly price.
Do you think is the most likely explanation : Read this brief essay by Chad Vance on the self -https://1000wordphilosophy.wordpress.com/2014/02/10/personal-identity/Which version of the self described by Vance (body, soul, or psychology) do you think is the most likely explanation or do you t..
Determining the discrete probability : Reflect on your work or your life. Discuss a time where you used discrete probabilities to help solve a problem. How did this type of thinking help you in that process?
Compute a monthly cash budget and supporting schedules : Prepare a monthly cash budget and supporting schedules for March, April, and May. On the basis of the cash budget prepared in part (1), what recommendation should be made to the controller?
Expansionary fiscal and monetary policies : Focus of the Final Paper In an effort to move the economy out of a recession, the federal government would engage in expansionary economic policies. Respond to the following points in your paper on the actions the government would take to address exp..
Do oligopolists always compete on the basis of price : Given the Federal Trade Commission's approval of Nestle's acquisition of Dreyer's Grand Ice Cream Inc., two multinationals, Nestle SA and Unilever prepared to engage in ice cream wars. Describe how ice cream industry fits the oligopoly model. How doe..
Draw a diagram indicating that inferior factors are possible : Show that if marginal cost decreases as the price of some factor increases, then that factor must be inferior.
What is name of the trust that is set up for an individual : What is the name of the trust that is set up for an individual that has physical or mental disabilities - Is there any limit on the number of trusts an individual can create?

Reviews

Write a Review

Financial Accounting Questions & Answers

  Straight line method

The premium will be amortized using the straight-line method

  Building a computer music library will go forward

The first letter is to be sent to Mr. Bernard Olsen, 155 Main Street, Elmsford, NY  10523 - Having reviewed more then 50 applications for our field representative position, you are our top choice for this exciting opportunity to join our excellent..

  Calculate the requested analysis values

Written Assignment - Financial Statement Analysis. Based on the balance sheet and income statement provided for ABC Bank below, calculate the requested analysis values.

  Which the materials price variance is favorable

What about the situation in which the materials price variance is favorable and the materials quantity variance is unfavorable? How would you explain that situation?

  The manufacturing overhead account shows debits

The Manufacturing Overhead account shows debits of $30,000, $24,000, and $28,000 and one credit for $86,000. Based on this information, manufacturing overhead not been applied. Shows a zero balance. Has been under applied. Has been over applied.

  What is each years working capital movement

Working capital values for accounts payable and inventory at the beginning of each year are to be calculated by applying the target working capital days to the appropriate forecast revenue and/or cost figures for the coming year.

  Give journal entries necessary on september

The dividend is payable on October 12 to the stockholders of record on September 30. Give journal entries necessary on September 15, September 30, and October 12, 2010.

  Calculation of overhead cost per unit total overhead

calculation of overhead cost per unit total overhead allocated to each product using traditional costing system and abc

  Calculate the rate of return on a stock purchased

Calculate the rate of return on a stock purchased for $12.00 per share at the beginning of the year, with a dividend of $0.15 per share paid during the year, and the price per share of the stock at the end of the year was $13.50

  Weighted-average shares of common stock

Weighted-average shares of common stock outstanding and the journal entry to record this transaction

  Evaluate the strengths and weaknesses of preview company

Harris has decided that one way to make the division more profitable is to manipulate the inventory because it represents a large amount of FD's balance sheet. He also knows that controls over inventory are weak. He views this inventory manipulati..

  Equipment to manufacture a line of high-quality luggage

Pack & Carry is debating whether to invest in new equipment to manufacture a line of high-quality luggage. The new equipment would cost $1,728,125, with an estimated five-year life and no salvage value. All revenue from the new luggage line and all e..

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd