m Minden Company is a wholesale distributor of premium European chocolates. The company's balance sheet on...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
m Minden Company is a wholesale distributor of premium European chocolates. The company's balance sheet on April 30 is as follows: MINDEN COMPANY Balance Sheet April 30 Assets Cash Accounts receivable, customers Inventory Buildings and equipment, net of depreciation Total assets Liabilities and Shareholders' Equity Accounts payable, suppliers Note payable Capital shares, no par Betained earnings Total liabilities and shareholders' equity $ 15,000 61,500 34,500 237,000 $340,000 $ 72,000 17,500 210,000 48,500 $340,000 The company is in the process of preparing budget data for May. A number of budget items have already been prepared. as follows: a. Sales are budgeted at $500,000 for May. Of these sales, $150.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 are collected in the following month. All of the April 30 receivables will be collected in May. b. Purchases of inventory are expected to total $300,000 during May. These purchases will all be on account. 30% 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 $100,000. d. Operating expenses for May are budgeted at $180,000, exclusive of depreciation. These expenses will be paid in cash. Depreciation is budgeted at $5,000 for the month. e. The note payable on the April 30 balance sheet will be paid during May, with $90 in interest. (All of the interest relates to May.) f New refrigerating equipment costing $9,500 will be purchased for cash during May g. During May, the company will borrow $50.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. note will be due in one year. Required: 1. Prepare a cash budget for May. (Any "Repayments" and "Interest" should be indicated by a minus sign.) MINDEN COMPANY Cash Budget For the Month Ended May 31 Cash balance, beginning Add: Receipts from customers Total cash available Deduct: Disbursements: Total cash disbursements Excess of receipts over disbursements Financing Total financing $ 15,000 15,000 0 0 2. Prepare a budgeted income statement for May. Cost of goods sold: MINDEN COMPANY Budgeted Income Statement For the Month Ended May 31 Goods available for sale Cost of goods sold 0 es 3. Prepare a budgeted balance sheet as of May 31. Total assets MINDEN COMPANY Budgeted Balance Sheet as of May 31 Assets Liabilities and Shareholders' Equity Total liabilities and shareholders' equity $ $ m Minden Company is a wholesale distributor of premium European chocolates. The company's balance sheet on April 30 is as follows: MINDEN COMPANY Balance Sheet April 30 Assets Cash Accounts receivable, customers Inventory Buildings and equipment, net of depreciation Total assets Liabilities and Shareholders' Equity Accounts payable, suppliers Note payable Capital shares, no par Betained earnings Total liabilities and shareholders' equity $ 15,000 61,500 34,500 237,000 $340,000 $ 72,000 17,500 210,000 48,500 $340,000 The company is in the process of preparing budget data for May. A number of budget items have already been prepared. as follows: a. Sales are budgeted at $500,000 for May. Of these sales, $150.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 are collected in the following month. All of the April 30 receivables will be collected in May. b. Purchases of inventory are expected to total $300,000 during May. These purchases will all be on account. 30% 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 $100,000. d. Operating expenses for May are budgeted at $180,000, exclusive of depreciation. These expenses will be paid in cash. Depreciation is budgeted at $5,000 for the month. e. The note payable on the April 30 balance sheet will be paid during May, with $90 in interest. (All of the interest relates to May.) f New refrigerating equipment costing $9,500 will be purchased for cash during May g. During May, the company will borrow $50.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. note will be due in one year. Required: 1. Prepare a cash budget for May. (Any "Repayments" and "Interest" should be indicated by a minus sign.) MINDEN COMPANY Cash Budget For the Month Ended May 31 Cash balance, beginning Add: Receipts from customers Total cash available Deduct: Disbursements: Total cash disbursements Excess of receipts over disbursements Financing Total financing $ 15,000 15,000 0 0 2. Prepare a budgeted income statement for May. Cost of goods sold: MINDEN COMPANY Budgeted Income Statement For the Month Ended May 31 Goods available for sale Cost of goods sold 0 es 3. Prepare a budgeted balance sheet as of May 31. Total assets MINDEN COMPANY Budgeted Balance Sheet as of May 31 Assets Liabilities and Shareholders' Equity Total liabilities and shareholders' equity $ $
Expert Answer:
Answer rating: 100% (QA)
1 Cash Budget for May Receipts Cash sales 150000 Collections of receivables 150000 50 of 30... View the full answer
Related Book For
Managerial Accounting
ISBN: 978-0697789938
13th Edition
Authors: Ray H. Garrison, Eric W. Noreen, Peter C. Brewer
Posted Date:
Students also viewed these accounting questions
-
Minden Company is a wholesale distributor of premium European chocolates. The companys balance sheet as of April 30 is given below: The company is in the process of preparing budget data for May. A...
-
1. You have just been hired as a new management trainee by Earrings Unlimited, a distributor of earrings to various retail outlets located in shopping malls across the country. In the past, the...
-
Blueberry & Co. makes and sells two types of shoes, Plain and Fancy. Data concerning these products are as follows: Unit selling price Variable cost per unit Plain $60 $35 Fancy $125 $85 Seventy five...
-
Assume that you have been hired as a consultant by CGT, a major producer of chemicals and plastics, including plastic grocery bags, styrofoam cups, and fertilizers, to estimate the firms weighted...
-
Johns Co. expects its five departments to yield the following income for next year. Recompute and prepare the departmental income statements (including a combined total column) for the company under...
-
News Corp has been heavily criticised by investors and fund managers for both large bonuses paid to executives, and its focus on short-term performance. The company recently restructured its...
-
At a ski resort, water at \(40{ }^{\circ} \mathrm{F}\) is pumped through a 3-in.diameter, 2000-ft-long steel pipe from a pond at an elevation of \(4286 \mathrm{ft}\) to a snow-making machine at an...
-
Gasoline is sold through local gasoline stations under perfectly competitive conditions. All gasoline station owners face the same long-run average cost curve given by AC = .01q 1 + 100/q and the...
-
17. Mass of Jupiter Io is one of the moons of Jupiter. It has a semi- major axis of 0.042 100 m and an orbital period of 1.769 days. Use these data to estimate the mass of Jupiter.
-
A small bank is trying to determine how many tellers to employ. The total cost of employing a teller is $100 per day, and a teller can serve an average of 60 customers per day. On average, 50...
-
Suppose that you would like to open your own auto garage. You have picked out a location, obtained the proper permits, signed a lease. and found people who want to work for you. Now you need to...
-
Explain the distinctions between single collections and embedded documents. Give an example of when utilizing a single collection is preferable to using embedded documents. Give an example of when...
-
Walmart is the largest retailer in the world with overall sales surpassing $ 5 0 0 billion. In fact, Walmart is still more than 3 x the size of Amazon Retail ( ~$ 1 6 3 billion ) in terms of overall...
-
Harris Company manufactures and sells a single product. A partially completed schedule of the company's total costs and costs per unit over the relevant range of 59,000 to 99,000 units is given...
-
2. Yust Corporation determined that $1,700,000 of the research credit on its current-year tax return was uncertain, but that it was more likely than not to be sustained on audit. Management made the...
-
24. Consider the following classical recursive algorithm for computing the factorial n! of a non-negative integer n: FACTORIAL(n): if n=0 else return 1 return n FACTORIAL (n - 1) (a) How many...
-
During the last week in October, Ezekiel worked a total of 45 hours and had no idle time. He is paid P500 per hour for regular time, and is paid an additional of 50% of the regular rate for all hours...
-
ABC company leased new advanced computer equipment to STU Ltd on 1 January 2019.STULtd has to pay annual rental of $290,000 starting at 1 January 2019. It is a four years lease with ultimate rental...
-
Paul Swanson has an opportunity to acquire a franchise from The Yogurt Place, Inc., to dispense frozen yogurt products under The Yogurt Place name. Mr. Swanson has assembled the following information...
-
Han Products manufactures 30,000 units of part S-6 each year for use on its production line. At this level of activity, the cost per unit for part S-6 is: Direct materials . . . . . . . . . . . . . ....
-
Data for Hermann Corporation are shown below: Fixed expenses are $30,000 per month and the company is selling 2,000 units per month. Required: 1. The marketing manager argues that a $5,000 increase...
-
In financial reporting of inventory for a manufacturing company, which of the following statements is true or false? Please explain. a. Both fixed and variable manufacturing overhead costs are...
-
Under what conditions may a lithium-ion battery pack for electric vehicles be considered as raw material, work in progress, or a finished good?
-
The following data relate to the manufacturing activities of MilTech company during November: 1. Sales $400,000 2. Purchases $60,700 3. Expenses include: Light and power for manufacturing: $2,700 ...
Study smarter with the SolutionInn App