Calculate the expected cash collections from customers

Assignment Help Managerial Accounting
Reference no: EM133127653

Question - Minden Company is a wholesale distributor of premium European chocolates. The company's balance sheet as of April 30 is given below:

Minden Company Balance Sheet April 30

Assets

Cash $9,000

Accounts receivable 54,000

Inventory 30,000

Buildings and equipment, net of depreciation 207,000

Total assets $300,000

Liabilities and Stockholders' Equity

Accounts payable $63,000

Note payable 14,500

Common stock 180,000

Retained earnings 42,500

Total liabilities and stockholders' equity $300,000

The company is in the process of preparing a budget for May and has assembled the following data:

1. Sales are budgeted at $200,000 for May. Of these sales, $60,000 will be for cash; the remainder will be credit sales. One-half of a month's credit sales are collected in the month the sales are made, and the remainder is collected in the following month. All of the April 30 accounts receivable will be collected in May.

2. Purchases of inventory are expected to total $120,000 during May. These purchases will all be on account. Forty percent of all purchases are paid for in the month of purchase; the remainder are paid in the following month. All of the April 30 accounts payable to suppliers will be paid during May.

3. The May 31 inventory balance is budgeted at $40,000.

4. Selling and administrative expenses for May are budgeted at $72,000, exclusive of depreciation. These expenses will be paid in cash. Depreciation is budgeted at $2,000 for the month.

5. The note payable on the April 30 balance sheet will be paid during May, with $100 in interest. (All of the interest relates to May.)

6. New refrigerating equipment costing $6,500 will be purchased for cash during May.

7. During May, the company will borrow $20,000 from its bank by giving a new note payable to the bank for that amount. The new note will be due in one year.

Required -

1. Calculate the expected cash collections from customers for May.

2. Calculate the expected cash disbursements for merchandise purchases for May.

3. Prepare a cash budget for May.

4. Prepare a budgeted income statement for May.

5. Prepare a budgeted balance sheet as of May 31.

Reference no: EM133127653

Questions Cloud

How does employee motivation impact organizational behavior : How does employee motivation impact organizational behavior? Provide details. What do you believe has the biggest impact on employee motivation? Why?
What is the minimum price huntley would accept : What is the minimum price Huntley would accept for an internal transfer of the 1000 units of the product if the division is operating at 100% capacity
Identify critical success factors for an industry : Identify critical success factors for an industry with which you are familiar (e.g, clothing retailers, automobile manufacturers, or mobile phone companies)
Prepare a Trial balance at December : The balance of ABC Inc.'s accounts all have a normal balance and the following amounts at December 31, 2021: Prepare a Trial balance at December 31, 2021
Calculate the expected cash collections from customers : Selling and administrative expenses for May are budgeted at $72,000, exclusive of depreciation. Calculate the expected cash collections from customers
VRIO analysis of resources and capabilities of organization : Undertake a VRIO analysis of the resources and capabilities of an organization with which you are familiar in order to identify which resources and capabilities
The argument uses any deceptive statistics : Determine whether or not the argument uses any deceptive statistics. Give your opinion on whether the argument has persuaded you. Explain why or not.
Prepare adjusting entries : Invoices representing $1,700 of services performed during the month of June have not been recorded as at June 30. Prepare adjusting entries
Terrorist attack-chemical accident-pandemic-an epidemic : What goals and procedures would you have in place in the event of a catastrophe such as a terrorist attack, a chemical accident, a pandemic, or an epidemic?

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