Ask Question, Ask an Expert

+61-413 786 465

info@mywordsolution.com

Ask Accounting Basics Expert

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


March


Apr


May

Sales

$91,000


$114,000


$144,000

Manufacturing costs

38,000


49,000


52,000

Selling and administrative expenses

26,000


31,000


32,000

Capital expenditures

_


_


35,000

The company expects to sell about 10% of its merchandise for cash. Of sales on account, 60% 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 $8,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, 85% 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 $35,000, marketable securities of $49,000, and accounts receivable of $109,200 ($80,000 from February sales and $29,200 from January sales). Sales on account for January and February were $73,000 and $80,000, respectively. Current liabilities as of March 1 include a $46,000, 12%, 90-day note payable due May 20 and $8,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 $2,700 in dividends will be received in March. An estimated income tax payment of $14,000 will be made in April. Dash Shoes' regular quarterly dividend of $8,000 is expected to be declared in April and paid in May. Management desires to maintain a minimum cash balance of $27,000.

Questions 1: Prepare a monthly cash budget and supporting schedules for March, April, and May. Input all amounts as positive values except overall cash decrease and deficiency which should be indicated with a minus sign. Assume 360 days per year for interest calculations.

Question 2: On the basis of the cash budget prepared in Part 1, what recommendation should be made to the controller?

Accounting Basics, Accounting

  • Category:- Accounting Basics
  • Reference No.:- M9960818

Have any Question?


Related Questions in Accounting Basics

Question - redline publishers inc produces various manuals

Question - Redline Publishers, Inc. produces various manuals ranging from computer software instructional booklets to manuals explaining the installation and use of large pieces of industrial equipment. At the end of sol ...

Questions -1 discuss the importance of accurate product

Questions - 1. Discuss the importance of accurate product costing. In your discussion you should highlight the problems associated with using traditional costing system which Beztec has been using. 2. Calculate the cost ...

Accounting question - simon companys year-end balance

Accounting Question - Simon Company's year-end balance sheets follow: At December 31 2017 2016 2015 Assets       Cash $31,800 $35,625 $37,800 Accounts receivable, net 89,500 32,500 50,200 Merchandise inventory 112,500 82 ...

Question - maggie vitteta single works 38 hours per week at

Question - Maggie Vitteta, single, works 38 hours per week at $14.00 an hour. How much is taken out for federal income tax with one withholding exemption?

Question - chopin corporation had these transactions

Question - Chopin Corporation had these transactions pertaining to debt investments: Jan.1 Purchased 90 10%, $1,000 Martine Co. bonds for $90,000 cash. Interest is payable semiannually on July 1 and January 1. July1 Rece ...

Question - the following information is available for the

Question - The following information is available for the 21,000 units of X Company's one product sold in 2017: Selling price $46.00 Variable costs per unit $30.00 Total fixed costs $756,000 In 2018, X Company expects sa ...

Question - describe the allocation of inventoriable costs

Question - Describe the allocation of inventoriable costs may be made under any of the following assumptions as to the flow of costs (a) first-in, first-out (FIFO), (b) last-in, first-out (LIFO), or (c) average cost.

Question -sept 1 - the company sold shares of common stock

Question - Sept. 1 - The Company sold shares of common stock for $30,000 cash. Sept. 1 - The Company purchased a one-year insurance policy for $300 in cash. Sept. 1 - The Company purchased office equipment costing $8,000 ...

Questions answer the following questions all the questions

Questions: Answer the following questions. All the questions below are based on it. You are NOT allowed to cite information from other sources!!! It is based on Australian accounting system so do not rely too much on you ...

Question - paulson company issues 6 four-year bonds on

Question - Paulson Company issues 6%, four-year bonds, on December 31, 2017, with a par value of $200,000 and semiannual interest payments. Semiannual Period-End Unamortized Discount Carrying Value (0) 12/31/2017 $ 13,46 ...

  • 4,153,160 Questions Asked
  • 13,132 Experts
  • 2,558,936 Questions Answered

Ask Experts for help!!

Looking for Assignment Help?

Start excelling in your Courses, Get help with Assignment

Write us your full requirement for evaluation and you will receive response within 20 minutes turnaround time.

Ask Now Help with Problems, Get a Best Answer

Why might a bank avoid the use of interest rate swaps even

Why might a bank avoid the use of interest rate swaps, even when the institution is exposed to significant interest rate

Describe the difference between zero coupon bonds and

Describe the difference between zero coupon bonds and coupon bonds. Under what conditions will a coupon bond sell at a p

Compute the present value of an annuity of 880 per year

Compute the present value of an annuity of $ 880 per year for 16 years, given a discount rate of 6 percent per annum. As

Compute the present value of an 1150 payment made in ten

Compute the present value of an $1,150 payment made in ten years when the discount rate is 12 percent. (Do not round int

Compute the present value of an annuity of 699 per year

Compute the present value of an annuity of $ 699 per year for 19 years, given a discount rate of 6 percent per annum. As