Purchase Solution

Meeks Company: compute cash collections, budgeted inventory

Not what you're looking for?

Ask Custom Question

See attached file

All sales at Meeks Company, a wholesaler, are made on credit. Experience has shown that 70% of the accounts receivable are collected in the month of the sale, 26% are collected in the month following the sale, and the remaining 4% are uncollectible. Actual sales for March and budgeted sales for the following four months are given below:

The company's cost of goods sold is equal to 60% of sales. All purchases of inventory are made on credit. Meeks Company pays for one half of a month's purchases in the month of purchase, and the other half in the month following purchase. The company requires that end-of-month inventories be equal to 25% of the cost of goods sold for the next month.

Required:
a. Compute the amount of cash, in total, which the company can expect to collect in May.
b. Compute the budgeted dollar amount of inventory which the company should have on hand at the end of April.
c. Compute the amount of inventory that the company should purchase during the months of May and June.
d. Compute the amount of cash payments that will be made to suppliers during June for purchases of inventory.

Attachments
Purchase this Solution
Solution provided by:
Gaurav Agarwal, MS
Education
  • BE, Bangalore University, India
  • MS, University of Wisconsin-Madison
Recent Feedback
  • "Your explanation to the answers were very helpful."
  • "What does 1 and 0 means in the repair column?"
  • "Went through all of the formulas, excellent work! This really helped me!"
  • "try others as well please"
  • "Thank you, this helped a lot. I was not sure how to plug in those numbers to a formula. This was a great help. Now I have to figure out how to explain cost of capital is used in net present value analysis, and how cost of capital is used in net present value analysis. This stuff gets confusing."
Purchase this Solution
Free BrainMass Quizzes
Business Processes

This quiz is intended to help business students better understand business processes, including those related to manufacturing and marketing. The questions focus on terms used to describe business processes and marketing activities.

Lean your Process

This quiz will help you understand the basic concepts of Lean.

Understanding the Accounting Equation

These 10 questions help a new student of accounting to understand the basic premise of accounting and how it is applied to the business world.

Transformational Leadership

This quiz covers the topic of transformational leadership. Specifically, this quiz covers the theories proposed by James MacGregor Burns and Bernard Bass. Students familiar with transformational leadership should easily be able to answer the questions detailed below.

Learning Lean

This quiz will help you understand the basic concepts of Lean.

View More Free Quizzes
Related BrainMass Solutions

  • Compute Budgeted Purchases, Cash Collections, Cash Disburse

    Budgeted purchases $ 941850 (b) Compute the Budgeted purchases in dollars for September. (Omit the "$" sign in your response.) Budgeted purchases $ 724500 (c) Compute the Budgeted cash collections during August.

  • Expected Cash Collections and Disbursements Schedules

    Compute the budgeted dollar amount of inventory which the company should have on hand at the end of June. 3. Compute the amount of inventory that the company should purchase during the months of July and August. 4.

  • Compute a budgeted cash balance

    445032 Sherman Company: Compute a budgeted cash balance Sherman Company has a cash balance on January 1 of $123,219. Given the following data, compute Sherman's budgeted cash balance on March 31. Round all amounts to the nearest dollar.

  • Cash Budget and Cost Variance Analysis

    Payments for inventory are 70% in the month following purchase and 30% two months following purchase. Required: a) Compute the cash collections for December. b) Compute the cash disbursements for purchases during December.

  • cost accounting master budget

    The Inventory Purchases Budget 3. Budgeted Overhead Costs 4. The Cash Budget

  • Cash budget

    230452 Budgeted cash collections and disbursements Glover: Compute budgeted cash collections and disbursements for Company A, B & C CASH BUDGET Company A Company B Company C Beginning cash balance $100

  • Budgets : key information

    A) Compute the expected cash collections during the months of January, February, March, April, May, and June. B) The company has decided that finished goods inventory at the end of each month should ideally be equal to 40% of next month's sales.

  • Midwest Products

    Prepare a schedule of expected cash collections from sales, by month and in total, for the third quarter. 2. Assume that the company will prepare a budgeted balance sheet as of September 30. Compute the accounts receivable as of that date.

  • Managerial/Cost Accounting problems

    Prepare a schedule of expected cash collections from sales, by month and in total, for the second quarter. Assume that the company will prepare a budgeted balance sheet as of June 30. Compute the accounts receivable as of that date. 2.

View More Related Solutions