Question
Nordic Company, a merchandising company, prepares its master budget on a quarterly basis. The following data have been assembled to assist in the preparation of
Nordic Company, a merchandising company, prepares its master budget on a quarterly basis. The following data have been assembled to assist in the preparation of the master budget for the second quarter of the year 2020.
- As of March 31, 20__ (the end of the prior quarter), the companys balance sheet showed the following account balances:
Cash |
| $9,000 |
|
|
Accounts Receivable |
| 36,000 |
|
|
Inventory |
| 12,600 |
|
|
Plant and Equipment (net) |
| 214,100 |
|
|
Accounts Payable |
|
|
| $24,000 |
Capital Stock |
|
|
| 190,000 |
Retained Earnings |
|
|
| 57,700 |
|
| $271,700 |
| $271,700 |
- Actual sales for March and budgeted sales for April July are as follows:
March (actual) $60,000
April .. 70,000
May ... 85,000
June . 90,000
July 50,000
- Sales are 40% for cash and 60% on credit. All payments on credit sales are collected in the month following the sale. The accounts receivable at March 31 are a result of March credit sales.
- The companys gross profit is 40% of sales.
- Monthly expenses are budgeted as follows: salaries and wages, $9,500 per month; shipping, 7% of sales; advertising, $8,000 per month; depreciation, $2,400 per month; other expenses, 5% of sales.
- At the end of each month, a minimum level of inventory is to be on hand equal to 30% of the following months sales needs.
- Half of a months inventory purchases are paid in the month of purchase and half in the following month after purchase.
- Equipment purchases during the quarter will be as follows:
April, $15,000; and June, $4,000.
- Dividends totaling $2,500 will be declared and paid in June.
- The company must maintain a minimum cash balance of $7,000. An open line of credit is available from a local bank. All borrowing is done at the beginning of a month, and all repayments are made at the end of a month.
Borrowings and repayments of principal must be in multiples of $1,000. Interest is paid only at the time of repayment of principal. The annual interest rate is 10%.
Required: Using the data above, prepare the following statements and schedules for the second quarter of the year 2020:
- Sales budget
- Cash collections from customers schedule
- Inventory purchases budget
- Cash disbursements for purchases schedule
- Operating expenses budget
- Cash disbursements for expenses schedule
- Cash budget
- Income statement for the quarter ending June 30, 2020
- Balance sheet as of June 30, 2020
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started