Ask Question, Ask an Expert

+61-413 786 465

info@mywordsolution.com

Ask Accounting Basics Expert

Question: Cash Budget The controller of Feinberg Company is gathering data to prepare the cash budget for July. He plans to develop the budget from the following information:

a. Of all sales, 40 percent are cash sales.

b. Of credit sales, 45 percent are collected within the month of sale. Half of the credit sales collected within the month receive a 2 percent cash discount (for accounts paid within 10 days). Thirty percent of credit sales are collected in the following month; remaining credit sales are collected the month thereafter. There are virtually no bad debts.

c. Sales for the second two quarters of the year follow.

                                 Sales

April                        $450,000

May                          580,000

June                         900,000

July                       1,140,000

August                   1,200,000

September              1,134,000

d. The company sells all that it produces each month. The cost of raw materials equals 26 percent of each sales dollar. The company requires a monthly ending inventory of raw materials equal to the coming month's production requirements. Of raw materials purchases, 50 percent are paid for in the month of purchase. The remaining 50 percent is paid for in the following month.

e. Wages total $105,000 each month and are paid in the month incurred.

f. Budgeted monthly operating expenses total $376,000, of which $45,000 is depreciation and $6,000 is expiration of prepaid insurance (the annual premium of $72,000 is paid on January 1).

g. Dividends of $130,000, declared on June 30, will be paid on July 15.

h. Old equipment will be sold for $25,200 on July 4.

i. On July 13, new equipment will be purchased for $173,000.

j. The company maintains a minimum cash balance of $20,000.

k. The cash balance on July 1 is $27,000.

Required: Prepare a cash budget for July. Give a supporting schedule that details the cash collections from sales.

Accounting Basics, Accounting

  • Category:- Accounting Basics
  • Reference No.:- M92502526
  • Price:- $15

Priced at Now at $15, Verified Solution

Have any Question?


Related Questions in Accounting Basics

Question - xyz ltd has a balance day of 31 december on 1

Question - XYZ Ltd has a balance day of 31 December. On 1 January 2XX3, it had an opening inventory balance of $12,000. XYZ Ltd purchased $23,000 worth of goods for resale. On 31 December 2XX3, the closing inventory bala ...

Question - buffalo industries markets cds of numerous

Question - Buffalo Industries markets CDs of numerous performing artists. At the beginning of March, Buffalo Industries had in beginning inventory 2,670 CDs with a unit cost of $7. During March, Buffalo Industries made t ...

Question - henry company manufactures two types of office

Question - Henry Company manufactures two types of office chairs, Model A and Model B. It estimates the following results for next year.   Model A Model B Sales Revenue $450,000 $50,000 Variable Expenses (total): $140,00 ...

Question - culver corporation reported net sales of 251600

Question - Culver Corporation reported net sales of $251,600, cost of goods sold of $134,100, operating expenses of $50,600, net income of $36,400, beginning total assets of $530,400, and ending total assets of $560,800. ...

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 - in 1990 flounder company completed

Accounting Question - In 1990, Flounder Company completed the construction of a building at a cost of $2,300,000 and first occupied it in January 1991. It was estimated that the building will have a useful life of 40 yea ...

Question - jalisco corporation has net income of 281000 for

Question - Jalisco Corporation has net income of $281,000 for the year ended December 31, 2010 and common shares outstanding of 100,000. The company did not issue or repurchase additional common shares during the year. J ...

Thinking of the middle east identify where you encounter

Thinking of the Middle East, identify where you encounter products, services, or food items that should be relatively uniform and are based on standard inputs or costs. Identify the items, their standard components, and ...

Question - blue co reported 150000 of net income for 2017

Question - Blue Co. reported $150,000 of net income for 2017. The accountant, in preparing the statement of cash flows, noted the following items occurring during 2017 that might affect cash flows from operating activiti ...

Question - vela enterprises inc would like to prepare

Question - Vela Enterprises Inc. would like to prepare summary cash budget for March. The following information is available: The cash balance at 1 March was estimated to be $8 000. March sales, all on account, were esti ...

  • 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