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 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 $135,000 162,000 $ 43,000 54,000 97,200 236,000 81,200 320,000 29,000 174,000 192,000 133,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, $9,500 per month; other expenses (excluding depreciation), 6% of sales. Assume that these expenses are paid monthly. Depreciation is $2,600 per month (includes depreciation on new assets). g. Equipment costing $3,200 will be purchased for cash in April. h. The company must maintain a minimum cash balance of $11,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).

Managerial Accounting: The Cornerstone of Business Decision-Making
7th Edition
ISBN:9781337115773
Author:Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger
Publisher:Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger
Chapter15: Financial Statement Analysis
Section: Chapter Questions
Problem 51E: Juroe Company provided the following income statement for last year: Juroes balance sheet as of...
icon
Related questions
icon
Concept explainers
Topic Video
Question
Please don't give image format
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
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
$ 43,000
54,000
97,200
236,000
81,200
320,000
29,000
$135,000
162,000
174,000
192,000
133,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, $9,500 per month; other expenses (excluding
depreciation), 6% of sales. Assume that these expenses are paid monthly. Depreciation is $2,600 per month (includes depreciation
on new assets).
g. Equipment costing $3,200 will be purchased for cash in April.
h. The company must maintain a minimum cash balance of $11,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).
Transcribed Image Text: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 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 $ 43,000 54,000 97,200 236,000 81,200 320,000 29,000 $135,000 162,000 174,000 192,000 133,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, $9,500 per month; other expenses (excluding depreciation), 6% of sales. Assume that these expenses are paid monthly. Depreciation is $2,600 per month (includes depreciation on new assets). g. Equipment costing $3,200 will be purchased for cash in April. h. The company must maintain a minimum cash balance of $11,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).
4. Prepare a cash budget by month and for the quarter in total. (Any "Repayments" and "Interest" should be indicated by a minus
sign.)
Total cash available
Deduct: Disbursements:
Total disbursements
Excess (deficiency) of cash
Financing:
Total financing
SHILOW COMPANY
Cash Budget
April
0
0
0
May
0
0
0
June
0
0
0
Quarter
0
0
0
Transcribed Image Text:4. Prepare a cash budget by month and for the quarter in total. (Any "Repayments" and "Interest" should be indicated by a minus sign.) Total cash available Deduct: Disbursements: Total disbursements Excess (deficiency) of cash Financing: Total financing SHILOW COMPANY Cash Budget April 0 0 0 May 0 0 0 June 0 0 0 Quarter 0 0 0
Expert Solution
steps

Step by step

Solved in 3 steps

Blurred answer
Knowledge Booster
Financial Statements
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Managerial Accounting: The Cornerstone of Busines…
Managerial Accounting: The Cornerstone of Busines…
Accounting
ISBN:
9781337115773
Author:
Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger
Publisher:
Cengage Learning