Prepare a cash budget for january and february

Assignment Help Managerial Accounting
Reference no: EM131243937

Exercises

Exercise 7-6

Sally Rice is unable to reconcile the bank balance at January 31. Sally's reconciliation is shown here.

Cash balance per bank


$4,243.20

Add: NSF check


649.00

Less: Bank service charge


41.87

Adjusted balance per bank


$4,850.33

 



Cash balance per books


$4,541.20

Less: Deposits in transit


576.13

Add: Outstanding checks


969.00

Adjusted balance per books


$4,934.07

(a) What is the proper adjusted cash balance per bank?

The proper adjusted cash balance per bank

(b) What is the proper adjusted cash balance per books?

The proper adjusted cash balance per books

(c) Prepare the adjusting journal entries necessary to determine the adjusted cash balance per books.

Exercise 7-7

At April 30, the bank reconciliation of Longacre Company shows three outstanding checks: No. 254 $673, No. 255 $871, and No. 257 $496. The May bank statement and the May cash payments journal are given here.

Bank Statement
Checks Paid

Date


Check No.


Amount

5-4


254


$673

5-2


257


496

5-17


258


162

5-12


259


344

5-20


260


1,000

5-29


263


480

5-30


262


794

Cash Payments Journal
Checks Issued

Date


Check No.


Amount

5-2


258


$162

5-5


259


344

5-10


260


1,000

5-15


261


452

5-22


262


794

5-24


263


480

5-29


264


391

List the outstanding checks at May 31.

Exercise 7-8

The following information pertains to Joyce Company.

1. Cash balance per bank, July 31, $7,847.

2. July bank service charge not recorded by the depositor $49.

3. Cash balance per books, July 31, $7,883.

4. Deposits in transit, July 31, $3,219.

5. Note for $2,519 collected for Joyce Company in July by the bank, plus interest $47 less fee $31. The collection has not been recorded by Joyce Company, and no interest has been accrued.

6. Outstanding checks, July 31, $697.

Prepare a bank reconciliation at July 31, 2014.

Journalize the adjusting entries at July 31 on the books of Joyce Company. (Credit account titles are automatically indented when amount is entered. Do not indent manually.)

Exercise 7-14

Enright Company expects to have a cash balance of $62,900 on January 1, 2014. These are the relevant monthly budget data for the first two months of 2014.

1. Collections from customers: January $87,900, February $162,900.

2. Payments to suppliers: January $56,900, February $91,900.

3. Wages: January $30,121, February $40,121. Wages are paid in the month they are incurred.

4. Administrative expenses: January $21,121, February $24,121. These costs include depreciation of $1,000 per month. All other costs are paid as incurred.

5. Selling expenses: January $15,121, February $20,121. These costs are exclusive of depreciation. They are paid as incurred.

6. Sales of short-term investments in January are expected to realize $12,121 in cash. Enright has a line of credit at a local bank that enables it to borrow up to $25,000. The company wants to maintain a minimum monthly cash balance of $36,900.

Prepare a cash budget for January and February.

Attachment:- exercises.rar

Verified Expert

In this solution we have made calculation for bank reconciliation statement. A part from that cash budget is also prepared.

Reference no: EM131243937

Questions Cloud

Find the car speed for each part of the trip : Greg drove at a constant speed in a rainstorm for 246 miles. He took a break, and the rain stopped. He then drove 176 miles at a speed that was 3 miles per hour faster than his previous speed. If he drove for 10 hours, find the car's speed for ea..
Woodworking supply shop unfinished : At the local woodworking supply shop unfinished oak boards cost $3.97 per board foot. A board foot is a piece of wood 12 in by 12 in by 1 in. How much would an unfinished oak board cost if it was six inches wide, one inch thick and nine feet long?
Find thr number of each coin : A bank teller had 42 coins in her cash drawer. The coins are nickels, dimes, and quarters. There is an equal number of nickels and dimes and the coins worth $4.55. Find thr number of each coin.
Why is planned investment called an injection : What effect will each of the changes listed in Study Question 3 of Chapter 27 have on the equilibrium level of GDP in the private closed economy? Explain your answers.
Prepare a cash budget for january and february : Prepare a cash budget for January and February - What is the proper adjusted cash balance per books and Prepare the adjusting journal entries necessary to determine the adjusted cash balance per books.
Identify two mechanisms you would use to address security : Describe an appropriate software architecture for www.buycomputer.com then Identify two mechanisms you would use to address security and two otheryou would use to address scalability and availability
Discuss the evolution of american philosophies or ideals : Discuss the evolution of American philosophies or ideals. Describe the innovations and impact of the American System. Discuss the political fight that emerged in the wake of the Corrupt Bargain and its impact on the Era of Good Feelings.
What are the economic strengths and weaknesses in both : Locate the current Beige Book report and compare consumer spending for the entire U.S. economy with consumer spending in your Federal Reserve District. What are the economic strengths and weaknesses in both? Are retailers reporting that recent sal..
Calculate the mean and median for these data : The following data give the total food expenditures (in dollars) for the past one month for a sample of 20 families.

Reviews

Write a Review

Managerial Accounting Questions & Answers

  What is the product cm ratio

Stratford Company distributes a lightweight lawn chair that sells for $120 per unit. Variable expenses are $60.00 per unit, and fixed expenses total $180,000 annually.

  Why anyone take trouble to study the history of management

Why would anyone take the trouble to study the history of management accounting? Identify the benefits and beneficiaries of such a study, examining critically the work already carried out in this area.

  Piaggio''s statement of cash flows in appendix a

1.Refer to Piaggio's statement of cash flows in Appendix A. What investing activities result in cash outflows for the year ended December 31, 2011? List items and amounts.

  What journal entry would be made for the days

Explain. What journal entry would be made for the days worked and what entry would be made when the wages are paid on Saturday?

  In preparation for developing its statement of cash flows

In Millennium's statement of cash flows, what were net cash inflows (or outflows) from investing activities for 2011?

  What activities appear to be good candidates

Comment on the insights provided by the ABM study to date. Where's the low-hanging fruit? In other words, what activities appear to be good candidates for further study and significant cost savings?

  Annual cash flows over the expected life of the equipment

Based on the information calculate the following items for this proposed equipment purchase,  Annual cash flows over the expected life of the equipment, Payback period, Annual rate of return, Net present value, Internal rate of retur

  Prepare the company''s planning budget for october

The company expects to wash 8,000 cars in October and to collect an average of $5.90 per car washed.

  Provide commentary on the differences between the two system

Provide a brief commentary on the differences between the two systems for each situation, addressing the possible advantages of the activity-based view over the functional-based view.

  Compute cost of goods sold for year

1.Compute cost of goods sold for year 2013 using the following information.

  How much would projected cash inflow for end of year five

How much would the projected cash inflow for the end of Year 5 have to increase for the project to be acceptable? How much would the projected cash inflow for the end of Year 5?

  A zero coupon bond

a zero coupon bond with an 11% interest rate and maturity of 20 years is issued by JWU co. What is the price of the bond and how many would JWU need to sell if it needed to raise $10 million?

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