Minden Company is a wholesale distributor of premium European chocolates. The company's balance sheet as of...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
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 Accounts receivable Inventory Buildings and equipment, net of depreciation Total assets Liabilities and Stockholders' Equity Accounts payable Note payable Common stock Retained earnings Total liabilities and stockholders' equity $ 14,600 55,000 43,500 223,000 $ 336,100 $ 74,500 15,000 180,000 66,600 $ 336,100 The company is in the process of preparing a budget for May and has assembled the following data: a. Sales are budgeted at $244,000 for May. Of these sales, $73,200 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. b. Inventory purchases are expected to total $130,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. c. The May 31 inventory balance is budgeted at $40,500. d. Selling and administrative expenses for May are budgeted at $84,300, excluding depreciation. These expenses will be paid in cash. Depreciation is budgeted at $3,950 for the month. e. New refrigerating equipment costing $7,800 will be purchased for cash during May. f. The note payable on the April 30 balance sheet will be paid during May, with $430 in interest. (All of the interest relates to May.) g. During May, the company will borrow $20,700 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. (Hint: In the financing section, make sure to denote cash outflows as negative numbers. In the cash disbursements section, the cash outflows should be written as positive numbers. I know this seems counterintuitive - accountants tend to write costs as positive numbers if they are listed in a section of the financial statements that is already labeled as "costs" or "expenses" or "disbursements" because then you know they are all outflows. But in a section where inflows and outflows are mixed, like in the financing section, they make the outflows negative numbers.) 4. Prepare a budgeted income statement for May. (Hint: here, the interest payment will have a positive sign. Another hint: Remember from ACTG 211 that Cost of Goods Sold = beginning inventory account balance + inventory purchase cost - ending inventory account balance.) 5. Prepare a budgeted balance sheet as of May 31. (Hint: You won't need every line on the worksheet. There should be four 'asset' items and four 'liability and owners' equity' items, matching the categories in the beginning balance sheet above. Another hint: Remember from ACTG 211 that "Buildings and Equipment, net of depreciation" is increased every month by any new building or equipment purchases, and decreased by any depreciation. May depreciation is given in part d above.) Complete this question by entering your answers in the tabs below. 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 Accounts receivable Inventory Buildings and equipment, net of depreciation Total assets Liabilities and Stockholders' Equity Accounts payable Note payable Common stock Retained earnings Total liabilities and stockholders' equity $ 14,600 55,000 43,500 223,000 $ 336,100 $ 74,500 15,000 180,000 66,600 $ 336,100 The company is in the process of preparing a budget for May and has assembled the following data: a. Sales are budgeted at $244,000 for May. Of these sales, $73,200 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. b. Inventory purchases are expected to total $130,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. c. The May 31 inventory balance is budgeted at $40,500. d. Selling and administrative expenses for May are budgeted at $84,300, excluding depreciation. These expenses will be paid in cash. Depreciation is budgeted at $3,950 for the month. e. New refrigerating equipment costing $7,800 will be purchased for cash during May. f. The note payable on the April 30 balance sheet will be paid during May, with $430 in interest. (All of the interest relates to May.) g. During May, the company will borrow $20,700 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. (Hint: In the financing section, make sure to denote cash outflows as negative numbers. In the cash disbursements section, the cash outflows should be written as positive numbers. I know this seems counterintuitive - accountants tend to write costs as positive numbers if they are listed in a section of the financial statements that is already labeled as "costs" or "expenses" or "disbursements" because then you know they are all outflows. But in a section where inflows and outflows are mixed, like in the financing section, they make the outflows negative numbers.) 4. Prepare a budgeted income statement for May. (Hint: here, the interest payment will have a positive sign. Another hint: Remember from ACTG 211 that Cost of Goods Sold = beginning inventory account balance + inventory purchase cost - ending inventory account balance.) 5. Prepare a budgeted balance sheet as of May 31. (Hint: You won't need every line on the worksheet. There should be four 'asset' items and four 'liability and owners' equity' items, matching the categories in the beginning balance sheet above. Another hint: Remember from ACTG 211 that "Buildings and Equipment, net of depreciation" is increased every month by any new building or equipment purchases, and decreased by any depreciation. May depreciation is given in part d above.) Complete this question by entering your answers in the tabs below.
Expert Answer:
Related Book For
Managerial Accounting
ISBN: 9781259275814
11th Canadian Edition
Authors: Ray H Garrison, Alan Webb, Theresa Libby
Posted Date:
Students also viewed these accounting questions
-
Suppose a city finds that its express highways into the city are congested and it is considering two remedies: (1) imposing a congestion charge on all users of its expressways during the peak periods...
-
The Green Corporation has only six shareholders. In the current year, it has AOGI of $540,000 and personal holding company income of $390,000. Its adjusted taxable income is $460,000. What is its...
-
what ways do metafictional techniques complicate the relationship between the author, reader, and narrative? provide examples from well-known metafictional works and analyze their effect on...
-
Exhaust (assumed to have the properties of standard air) leaves the 4-ft-diameter chimney shown in Video V5.4 and Fig. P5.42 with a speed of \(6 \mathrm{ft} / \mathrm{s}\). Because of the wind, after...
-
A large retailer of kitchen appliances has asked you for advice on how much to stock and how to price leftovers of its products. Here's a typical situation: Demand for espresso machines in the...
-
Bond X is a bond with a coupon rate of 18 percent that makes annual payments. It has a poor rating that bond issuer might not pay the interest and/or principal payments. Bond Y is a bond with a...
-
Calculate the price of the following corporate bond with a credit rating of BBB+ / Baa+: $1,000 par value, 9% semi-annual pay coupon, 8.40% yield to maturity, and six years to maturity.
-
Concept testing works best with people who are familiar with the new idea and the new product's purpose. This generally includes top management, the sales force, and research and development.* A....
-
When people think of innovation, the first that comes into their mind is product innovation.* A. TRUE B. FALSE Innovation is the process by which entrepreneurs convert opportunities into marketable...
-
Initial reaction is based on pure intuitive sense.* A. TRUE B. FALSE Concepts embodying new art and entertainment are easy to test.* A. TRUE B. FALSE
-
Seagate Limited is a steel manufacturing company which have a turnover of 543 Million Rupees. Recently, Mr. Ramanujan joined the Seagate Limited as a CEO. Mr. Ramanujan is a technically-educated CEO...
-
Entrepreneurs are always looking for unique opportunities to fill needs or wants.* A. TRUE B. FALSE The easiest step in the creative endeavor is the implementation and evaluation phase.* A. TRUE B....
-
Why did many registered users of EasyLife never purchase? Why was the secondary purchase rate so slow?
-
Which of the ocean zones shown would be home to each of the following organisms: lobster, coral, mussel, porpoise, and dragonfish? For those organisms you identify as living in the pelagic...
-
Verify that the log-likelihood of model (7.7) is \(\sum_{i=1}^{k}\left[n_{i} \lambda-\exp (\lambda) ight]\). (a) Compute MLE of \(\lambda\). (b) Compute the Pearson chi-square statistic and compare...
-
Think about the general concept of a relationship, not necessarily in a business setting, but just relationships in general between any two parties. What aspects of relationships are inherently...
-
Has transactional selling gone the way of the dinosaur? That is, are there ever any situations in which a transactional approach to selling would be an appropriate approach today? If so, what are...
Study smarter with the SolutionInn App