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

  Explain why the ending inventory balance

Explain why the ending inventory balance (assuming it is not zero) computed under full costing will always be greater than the ending inventory balance computed under variable costing.

  Possible customer returns or account adjustments

On July 15, Mann Company sold $600,000 in accounts receivable for cash of $500,000. The factor withheld 10% of the cash proceeds to allow for possible customer returns or account adjustments. An Allowance for Bad Debts of $80,000 had previously been ..

  Discuss difficulties related with allocating overhead costs

Covers a range of important cost and management accounting topics. The main purpose of this assignment is to provide students with the opportunity to extend their knowledge, skills, attitudes and values in connection with some of the topics cover..

  Denote the set of positive integers

In this assignment, N will denote the set of positive integers, Z the set of all integers, Q the set of all rational numbers, and R the set of all real numbers. After any problem statement, feel free to hit the Enter key as often as you need to ma..

  Which machine should be purchased if the required rate

Determine the net present value for each machine and decide which machine should be purchased if the required rate of return is 10 percent. Ignore taxes.

  How has technology impacted the verbal and nonverbal cues

Response, analyze how the use of technology has impacted organizational communication both positively and negatively. How has technology impacted the verbal and nonverbal cues used in interpreting messages?

  Calculate profit as a percent of sales in the prior year

Calculate profit as a percent of sales for the new level of sales and explain why the percent is greater than the one calculated in part a.

  Compute and assess cash flow yield and free cash flow

Compute and assess cash flow yield and free cash flow yield and free cash flow for 2010. What is your assessment of  Alvin's cash-generating ability?

  Main components of cvp

Write down the main components of cost-volume-profit (CVP) analysis. How does a CVP income statement aid management make decisions?

  Prepare a bar graph for each of three environmental variable

Using the data, prepare a bar graph for each of the three environmental variables provided (registrations, energy, and greenhouse gases).

  Preview of financial accountant-forecasting

Generally forecasting and planning is considered the preview of the financial accountant or the forecasting and planning department.

  Prepare the manufacturing overhead cost budget

Prepare the direct material usage budget and the direct material purchases budget and prepare the direct manufacturing labour cost budget - prepare the manufacturing overhead cost budget.

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