Preparing a Comprehensive Master Budget CHECK FIGURES (2) May purchases: $64,800 (4) May 31 cash balance:...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Preparing a Comprehensive Master Budget CHECK FIGURES (2) May purchases: $64,800 (4) May 31 cash balance: $4,590 Following is selected information relating to the operations of Shilow Company, a wholesale distributor Current assets as of March 31: Cash Accounts receivable Inventory Plant and equipment, net $ 8,000 20,000 36,000 120.000 Accounts payable Capital shares Retained earnings a. Gross margin is 25% of sales. b. Actual and budgeted sales data are as follows: March (actual) April May June July 21,750 150.000 12,250 $50,000 60,000 72,000 90,000 48.000 c. Sales are 60% for cash and 40% on credit. Credit sales are collected in the month following sale. The accounts receivable at March 31 are a result of March credit sales. d. At the end of each month, inventory is to be on hand equal to 80% of the following month's sales needs, stated at cost. e. One-half of a month's inventory purchases are paid for in the month of purchase; the other half are paid for in the following month. The accounts payable at March 31 are a result of March purchases of inventory. f. Monthly expenses are as follows: salaries and wages. 12% of sales: rent, $2.500 per month: other expenses (excluding depreciation). 6% of sales. Assume that these expenses are paid monthly Depreciation is $900 per month (includes depreciation on new assets). & Equipment costing $1,500 will be purchased for cash in April. h. The company must maintain a minimum cash balance of $4,000. An open line of credit is available at a local bank. All borrowing is done at the beginning of a month, and all repayments are made at the end of a month; borrowing must be in multiples of $1,000. The annual interest rate is 12%. Interest is paid only at the time of repayment of principal; figure interest on whole months (1/12, 2/12. and so forth). Required: Using the preceding data: 1. Prepare a schedule of expected cash collections. 2. Prepare a schedule of inventory purchases and a schedule of expected cash disbursements for purchases. 3. Prepare a schedule of expected cash disbursements for operating expenses. 4. Prepare a cash budget by month and for the quarter in total. 5. Prepare an income statement for the quarter ended June 30. (Use the functional format in preparing your income statement, as shown in Schedule 9.) 6. Prepare a balance sheet as of June 30. Preparing a Comprehensive Master Budget CHECK FIGURES (2) May purchases: $64,800 (4) May 31 cash balance: $4,590 Following is selected information relating to the operations of Shilow Company, a wholesale distributor Current assets as of March 31: Cash Accounts receivable Inventory Plant and equipment, net $ 8,000 20,000 36,000 120.000 Accounts payable Capital shares Retained earnings a. Gross margin is 25% of sales. b. Actual and budgeted sales data are as follows: March (actual) April May June July 21,750 150.000 12,250 $50,000 60,000 72,000 90,000 48.000 c. Sales are 60% for cash and 40% on credit. Credit sales are collected in the month following sale. The accounts receivable at March 31 are a result of March credit sales. d. At the end of each month, inventory is to be on hand equal to 80% of the following month's sales needs, stated at cost. e. One-half of a month's inventory purchases are paid for in the month of purchase; the other half are paid for in the following month. The accounts payable at March 31 are a result of March purchases of inventory. f. Monthly expenses are as follows: salaries and wages. 12% of sales: rent, $2.500 per month: other expenses (excluding depreciation). 6% of sales. Assume that these expenses are paid monthly Depreciation is $900 per month (includes depreciation on new assets). & Equipment costing $1,500 will be purchased for cash in April. h. The company must maintain a minimum cash balance of $4,000. An open line of credit is available at a local bank. All borrowing is done at the beginning of a month, and all repayments are made at the end of a month; borrowing must be in multiples of $1,000. The annual interest rate is 12%. Interest is paid only at the time of repayment of principal; figure interest on whole months (1/12, 2/12. and so forth). Required: Using the preceding data: 1. Prepare a schedule of expected cash collections. 2. Prepare a schedule of inventory purchases and a schedule of expected cash disbursements for purchases. 3. Prepare a schedule of expected cash disbursements for operating expenses. 4. Prepare a cash budget by month and for the quarter in total. 5. Prepare an income statement for the quarter ended June 30. (Use the functional format in preparing your income statement, as shown in Schedule 9.) 6. Prepare a balance sheet as of June 30.
Expert 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
-
The registers values in AX and BX can be exchanged using stack operations that are: Select one: a. PUSH bx PUSH ax POP bx POP AX b. none C. PUSH ax PUSH bx POP ax POP bx d. PUSH ax POP ax PUSH bx POP...
-
A retailer prices her goods to cover operating expenses at 30% of cost and to generate a profit of 20% of cost. For an item she buys from her wholesaler at $49, determine: a. Its selling price. b....
-
The Port Authority sells a wide variety of cables and adapters for electronic equipment online. Last year the mean value of orders placed with the Port Authority was $47.28, and management wants to...
-
Examine the collaborative filtering mechanism used by an online shopping system. How effective do you think it is? Might there be more effective methods to achieve the same goal? What kinds of...
-
Robert Corporation's condensed comparative income statement and comparative balance sheets for 2011 and 2010 follow. Required 1. Prepare schedules showing the amount and percentage changes from 2010...
-
George's T-Shirt Shop produces 2,000 custom-printed T-shirts per month. George's fixed costs are $6,000 per month. The marginal cost per T-shirt is a constant $6. George's break-even price is per...
-
Students estimated the length of one minute without reference to a watch or clock, and the times (seconds) are listed below. Assume that a simple random sample has been selected. Use a 0.10...
-
In a high-profile criminal trial, the defendant alleges that their confession was coerced by law enforcement officers during interrogation. How might the court assess the admissibility of the...
-
Factors which might cause a reduction in management's assigned penalty are called: a. Last chances. b. Second chances. c. Mitigating circumstances. d. Discharge circumstances.
-
The DD-AA model predicts that a permanent increase in foreign money demand will lead to an improvement in the domestic current account. True/False/Uncertain, explain and support your answer with ONE...
-
Marshall's concept of external economies and diseconomies refers to: a) Changes in output resulting from changes in input levels b) The effects of production on the environment c) The benefits or...
-
The price of a car you want is $39,000 today. Its price is expected to increase by $1000 each year. You now have $23,500 in an investment account, which is earning 11% per year. How many years will...
-
Explain the newest trends in mission components and also differentiate between company philosophy and public image and why organizations should consider either or both in its overall mission.
-
The Adjusted Trial Balance columns of a 10-column work sheet for Webber Co. follow. Complete the work sheet by extending the account balances into the appropriate financial statement columns and by...
-
Assume that \(y\) is normally distributed with mean \(\mu\) and variance \(\sigma^{2}\). Let \(\phi(\cdot)\) and \(\Phi(\cdot)\) be the standard normal density and distribution functions,...
-
Use equation (17.2) to establish the following distributional relationships that are helpful for calculating quantiles. a. Assume that \(y_{0}=\alpha_{1} F / \alpha_{2}\), where \(F\) has an...
-
Consider a GB2 probability density function given in equation (17.3). a. Reparameterize the distribution by defining the new parameter \(\theta=e^{\mu}\). Show that the density can be expressed as...
Study smarter with the SolutionInn App