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

  Manage budgets and financial plans

Explain the budgeting process and its importance to a business, identifying the components of different budgets, forecast estimates for inclusion in the budgets.

  Prepare a retained earnings statement

Prepare a retained earnings statement for the year and Prepare a stockholders' equity section of given case.

  Prepare a master budget for the three-month period

Prepare a master budget for the three-month period.

  Construct the companys direct labor budget

Construct the company's direct labor budget for the upcoming fiscal year, assuming that the direct labor workforce is adjusted each quarter to match the number of hours required to produce the forecasted number of units produced.

  Evaluate the predetermined overhead rate

Evaluate the Predetermined Overhead Rate

  Determine the company''s bid

Determine the company's bid if activity-based costing is used and the bid is based upon full manufacturing cost plus 30 percent.

  Compute the pool rates for the different activities

Complete the schedule to compute the pool rates for the different activities.

  Prepare Company financial statements

Prepare Company financial statements

  Prepare an analysis of terracycles

This individual assignment is based on the TerraCycle Inc.

  Discuss the ethical issues

Discuss the ethical issues

  Political resources in emerging markets

Calculate the GDP in Income Approach  and Expenditure Approach

  Management accounting - ehsan electronics company

A new plant accountant suggested that the company may be able to assign support costs to products more accurately by using an activity based costing system that relies on a separate rate for each manufacturing activity that causes support costs.

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