Reference no: EM132843557
Question - The following data relate to the operations of Shilow Company, a wholesale distributor of consumer goods:
Current assets as of March 31:
Cash $7,800
Accounts receivable $21,200
Inventory $41,400
Building and equipment, net $130,800
Accounts payable $24,675
Common stock $150,000
Retained earnings $26,525
1. The gross margin is 25% of sales.
2. Actual and budgeted sales data:
March (actual) $53,000
April $69,000
May $74,000
June $99,000
July $50,000
1. 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.
2. Each month's ending inventory should equal 80% of the following month's budgeted cost of goods sold.
3. One-half of a month's inventory purchases is paid for in the month of purchase; the other half is paid for in the following month. The accounts payable at March 31 are the result of March purchases of inventory.
4. Monthly expenses are as follows: commissions, 12% of sales; rent, $2,600 per month; other expenses (excluding depreciation), 6% of sales. Assume that these expenses are paid monthly. Depreciation is $981 per month (includes depreciation on new assets).
5. Equipment costing $1,800 will be purchased for cash in April.
6. Management would like to maintain a minimum cash balance of at least $4,000 at the end of each month. The company has an agreement with a local bank that allows the company to borrow in increments of $1,000 at the beginning of each month, up to a total loan balance of $20,000. The interest rate on these loans is 1% per month and for simplicity we will assume that interest is not compounded. The company would, as far as it is able, repay the loan plus accumulated interest at the end of the quarter.
Required - Using the preceding data:
1. Complete the schedule of expected cash collections.
2. Complete the merchandise purchases budget and the schedule of expected cash disbursements for merchandise purchases.
3. Complete the cash budget.
4. Do an absorption costing income statement for the quarter ended June 30.
5. Do a balance sheet as of June 30.
|
What are the total expenses that sam can deduct
: What are the total expenses (associated with the beach house) that Sam can deduct on his tax return in 2019? What is his total taxable income from the activity?
|
|
What happens the breakeven point and the revenue generated
: If a product sales price decrease while COGS remains constant, what happens the breakeven point and the revenue generated from the same amount of sales.
|
|
Calculate the manufacturing costs for the year
: Calculate the manufacturing costs for the year and Prepare a statement of cost of goods manufactured - Prepare an income statement
|
|
What is the probability that the sample mean
: If a sample of 100 test scores is selected at random, what is the probability that the sample mean will be greater than 63.8?
|
|
Complete the merchandise purchases budget
: Complete the merchandise purchases budget and the schedule of expected cash disbursements for merchandise purchases
|
|
Why you communicate with your family in the ways that you do
: Do you ever wonder how and why you communicate with your family in the ways that you do? Every family unit has its own way of engagement and interaction.
|
|
Calculate ss-variance and standard deviation
: -Calculate SS, variance, and standard deviation for the following sample of n = 6 scores: 11, 0, 8, 2, 4, 5. (The definitional formula works well with these sco
|
|
What is jody ending owner equity on a statement of changes
: What is Jody's ending owner's equity on a statement of changes in owner's equity? If Jody's records show $2,000 in investment by owner, $10,000 in net income.
|
|
Compute the coefficient of correlation
: The file Cereals lists the calories and sugar, in grams, in one serving of seven breakfast cereals:
|