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 $ 10,000 62,750 32,750 219,000 $ 324,500 $ 69,000 22,700 180,000 52,800 $ 324,500 The company is in the process of preparing a budget for May and has assembled the following data: a. Sales are budgeted at $254,000 for May. Of these sales, $76,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 th April 30 accounts receivable will be collected in May. b. Purchases of inventory are expected to total $137,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 payab to suppliers will be paid during May. c. The May 31 inventory balance is budgeted at $45,000. d. Selling and administrative expenses for May are budgeted at $98,400, exclusive of depreciation. These expenses will be paid in cash. Depreciation is budgeted at $5,550 for the month. e. The note payable on the April 30 balance sheet will be paid during May, with $350 in interest. (All of the interest relates to May.) f. New refrigerating equipment costing $8,700 will be purchased for cash during May. g. During May, the company will borrow $27,400 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. Complete this question by entering your answers in the tabs below. Req 1 and 2 Req 3 Req 4 Req 5 1. Calculate the expected cash collections from customers for May. 2. Calculate the expected cash disbursements for merchandise purchases for May. Total cash collections Total cash disbursements Complete this question by entering your answers in the tabs below. Req 1 and 2 Req 3 Req 4 Req 5 Prepare a cash budget for May. Note: Cash deficiency, repayments and interest should be indicated by a minus sign. Minden Company Cash Budget For the Month of May Beginning cash balance Add collections from customers Total cash available Less cash disbursements: Purchase of inventory Selling and administrative expenses Purchases of equipment Total cash disbursements 0 0 Excess of cash available over disbursements 0 Financing: Borrowing-note Repayments-note Interest Total financing Ending cash balance SA 0 0 Complete this question by entering your answers in the tabs below. Req 1 and 2 Req 3 Req 4 Req 5 Prepare a budgeted income statement for May. Minden Company Budgeted Income Statement For the Month of May 0 Complete this question by entering your answers in the tabs below. Req 1 and 2 Req 3 Req 4 Req 5 Prepare a budgeted balance sheet as of May 31. Minden Company Budgeted Balance Sheet May 31 Assets Total assets 0 Liabilities and Stockholders' Equity Total liabilities and stockholders' equity 0 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 $ 10,000 62,750 32,750 219,000 $ 324,500 $ 69,000 22,700 180,000 52,800 $ 324,500 The company is in the process of preparing a budget for May and has assembled the following data: a. Sales are budgeted at $254,000 for May. Of these sales, $76,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 th April 30 accounts receivable will be collected in May. b. Purchases of inventory are expected to total $137,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 payab to suppliers will be paid during May. c. The May 31 inventory balance is budgeted at $45,000. d. Selling and administrative expenses for May are budgeted at $98,400, exclusive of depreciation. These expenses will be paid in cash. Depreciation is budgeted at $5,550 for the month. e. The note payable on the April 30 balance sheet will be paid during May, with $350 in interest. (All of the interest relates to May.) f. New refrigerating equipment costing $8,700 will be purchased for cash during May. g. During May, the company will borrow $27,400 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. Complete this question by entering your answers in the tabs below. Req 1 and 2 Req 3 Req 4 Req 5 1. Calculate the expected cash collections from customers for May. 2. Calculate the expected cash disbursements for merchandise purchases for May. Total cash collections Total cash disbursements Complete this question by entering your answers in the tabs below. Req 1 and 2 Req 3 Req 4 Req 5 Prepare a cash budget for May. Note: Cash deficiency, repayments and interest should be indicated by a minus sign. Minden Company Cash Budget For the Month of May Beginning cash balance Add collections from customers Total cash available Less cash disbursements: Purchase of inventory Selling and administrative expenses Purchases of equipment Total cash disbursements 0 0 Excess of cash available over disbursements 0 Financing: Borrowing-note Repayments-note Interest Total financing Ending cash balance SA 0 0 Complete this question by entering your answers in the tabs below. Req 1 and 2 Req 3 Req 4 Req 5 Prepare a budgeted income statement for May. Minden Company Budgeted Income Statement For the Month of May 0 Complete this question by entering your answers in the tabs below. Req 1 and 2 Req 3 Req 4 Req 5 Prepare a budgeted balance sheet as of May 31. Minden Company Budgeted Balance Sheet May 31 Assets Total assets 0 Liabilities and Stockholders' Equity Total liabilities and stockholders' equity 0
Expert Answer:
Answer rating: 100% (QA)
Req 1 Calculate the expected cash collections from customers for May Given Total budgeted sales for May 254000 Cash sales for May 76200 Accounts recei... View the full 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
-
What is the Central Limit Probability for the following numbers: where x is more than 238.82 for a population mean of 202, and standard deviation of 86.86 where the sample is 43
-
X 8.) Is the following graph a proportional relationship? Why or why not? * Total Cost ($) 40 30 20 10 0 2 468 Games
-
Example 2 a: Financial Statement Information Regarding Division X Income Statement Revenues $ 1 4 7 , 5 0 0 - Operating Expenses 1 0 0 , 0 0 0 Operating Income $ 4 7 , 5 0 0 - Interest Exp 2 , 0 0 0...
-
Zephre Company reported net income for the year of $56,000. Depreciation expense for the year was $12,000. During the year, accounts receivable increased by $4,000, inventory decreased by $6,000,...
-
A converging lens with a focal length of 15.0 cm and a diverging lens are placed 25.0 cm apart, with the converging lens on the left. A 2.00-cm-high object is placed 22.0 cm to the left of the...
-
Suppose that you pay $3 to play a game. The following is the instruction of the game. First, you toss two fair coins independently. If you observe two heads, then you will earn $8. Otherwise, you...
-
Question: Builder wants to develop 1,000 acres in rural Montana, land that is home to the Kite Owl. The Environmental Protection Agency (EPA) rules that the Kite Owl is an endangered species, and...
-
The pretax financial income of Truttman Company differs from its taxable income throughout each of 4 years, as shown on page 1058. Pretax financial income for each year includes a non-deductible...
-
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 company...
-
Tropikana Inc., a U.S firm, has just borrowed 1,000,000 to make improvements to an Italian fruit plantation and processing plant. If the interest rate in is 5.50% per year and the Euro depreciates...
-
A Potential Hybrid Strategy The local supplier has also offered another proposal that would allow Teens Forever to use both suppliers, each playing a different role. The Chinese supplier would...
-
Working on a paper on Netflix and submitted my third module. The instructor is taking points off for things I have the opportunity to correct, but am at a loss. She is asking me the specific cost of...
-
What is an Activity-Based Costing? How is it different to traditional accounting methods?
-
In the challenging world of retail sales, Macy's, Inc.'s (M's) revenues are declining while expenses are generally flat. Based on recent conversations with management at Macy's, analysts believe that...
-
what is the effect on the break-even point if the selling price per unit decreases and total fixed expenses increase while the variable costs per unit increase?
-
If your firm requests production of 40,000 units of a particular Sonite brand and demand by Markstrat consumers for your product is really 50,000 units (given its attributes, price, etc., relative to...
-
Variable overhead spending variance $ 1 4 0 0 0 unfavourable. Variable overhead efficiency variance $ 9 5 2 0 0 favourable. Fixed overhead spending variance $ 8 3 0 0 0 unfavorable what is the...
-
Show, if u(x, y) and v(x, y) are harmonic functions, that u + v must be a harmonic function but that uv need not be a harmonic function. Is e"e" a harmonic function?
-
Preble Company manufactures one product. Its variable manufacturing overhead is applied to production based on direct labour-hours, and its standard costs per unit are as follows: The company planned...
-
Problems experienced by Toyota Motor Corporation with accelerator pedals sticking and brakes malfunctioning in some of its vehicle models illustrate how important it is to identify and control...
-
Under what conditions is it appropriate to use a process costing system?
-
Write the schemes similar to (4.17), (4.18), and (4.19) for \(\partial^{2} u /\left.\partial y^{2} ight|_{i, j}\).
-
Write the central finite difference formulas of the second order for \(\partial u / \partial x\) and \(\partial^{2} u / \partial x^{2}\) of function \(u(x, y, t)\) at the grid point \(\left(x_{i+1},...
-
In the same way as in Problem 1, compare the performance of the central difference scheme (4.10) and the fourth-order scheme (4.15). Problem 1 Consider the function \(u=\sin x\). Apply the forward...
Study smarter with the SolutionInn App