Problem 4 Oui-Got Stuff is preparing its budget for the coming year. Below is information about the 2nd quarter, which is not yet finished. The following additional information is available: Budgeted Income statement for July 200x: The budgeted income statement for the 2nd quarter is: July $ 32,000 Oui-Got Stuff, Inc. Sales Budgeted Income Statement For the 2nd Quarter Ended 200x Cost of goods sold 21,000 Gross profit Less: 11,000 Sales April $ 22,000 May $ 25,000 June $ 28,000 Selling expenses 4,200 Cost of goods sold 11,000 13,000 16,000 Administrative expenses 3,600 Gross profit Less: 11,000 12,000 12,000 Total 7,800 Net income $3,200 Selling expenses 2,300 3,000 3,400 Administrative expenses 2,600 3,000 3,200 1. 80% of monthly sales are on account (i.e., for credit). The remainder is for cash. 2. Credit sales are collected as follows: Total 4,900 6,000 6,600 • 10% in the month of credit sales • 60% in the month following the credit sales • The remainder in the 2nd month following the credit sales Net income $6.100 $6.000 $5.400 Oui-Got Stuff has also completed the purchases budget, as follows: 3. Total budgeted sales for February are $15,000. 4. Total budgeted sales for March are $16,00o. 5. Oui-Got assumes it would pay for budgeted purchases 65% in the month of purchase and 35% in the month following the purchase. 6. Budgeted purchases for March are $12,000. 7. For the months of April and May, the company must make a $5,000 payment for an outstanding bank note. 8. Oui-Got must maintain a cash balance of at least $4,000 at the end of each month. 9. The budgeted cash balance at April 1 is $4,500. 10. When ending cash balances are less than $4,000, they make a short-term borrowing from their local bank. However, all borrowings must be made in multiples of $100. These short- term loans are repaid at the end of the year, which is December 31". Oui-Got Stuff, Inc. Purchases Budget For the 2nd Quarter Ended 200x April $ 11,000 June $ 16,000 Budgeted cost of goods sold Plus: desired ending inventory Total inventory needs Less: beginning inventory 3,250 14,250 (2,500) $11,750 May $ 13,000 4,000 17,000 5,250 21,250 (3,250) $ 13,750 (4,000) Budgeted purchases $ 17,250 The company needs to prepare its budgeted cash receipts, budgeted cash payments for purchases, and monthly cash budget schedules for April, May and June. Required: a. Prepare a monthly budgeted operating cash receipts schedule for the 2nd quarter, i.e. April, May, and June. b. Prepare a monthly budgeted cash disbursements schedule for purchases for April, May, and June. c. Prepare a monthly total cash budget for April, May, and June. In that schedule, show borrowings from the company's local bank as needed to maintain the minimum cash balance. (Note: In your schedules show all three months, i.e. in 3 columns, rather than preparing separate schedules for each month.)
Problem 4 Oui-Got Stuff is preparing its budget for the coming year. Below is information about the 2nd quarter, which is not yet finished. The following additional information is available: Budgeted Income statement for July 200x: The budgeted income statement for the 2nd quarter is: July $ 32,000 Oui-Got Stuff, Inc. Sales Budgeted Income Statement For the 2nd Quarter Ended 200x Cost of goods sold 21,000 Gross profit Less: 11,000 Sales April $ 22,000 May $ 25,000 June $ 28,000 Selling expenses 4,200 Cost of goods sold 11,000 13,000 16,000 Administrative expenses 3,600 Gross profit Less: 11,000 12,000 12,000 Total 7,800 Net income $3,200 Selling expenses 2,300 3,000 3,400 Administrative expenses 2,600 3,000 3,200 1. 80% of monthly sales are on account (i.e., for credit). The remainder is for cash. 2. Credit sales are collected as follows: Total 4,900 6,000 6,600 • 10% in the month of credit sales • 60% in the month following the credit sales • The remainder in the 2nd month following the credit sales Net income $6.100 $6.000 $5.400 Oui-Got Stuff has also completed the purchases budget, as follows: 3. Total budgeted sales for February are $15,000. 4. Total budgeted sales for March are $16,00o. 5. Oui-Got assumes it would pay for budgeted purchases 65% in the month of purchase and 35% in the month following the purchase. 6. Budgeted purchases for March are $12,000. 7. For the months of April and May, the company must make a $5,000 payment for an outstanding bank note. 8. Oui-Got must maintain a cash balance of at least $4,000 at the end of each month. 9. The budgeted cash balance at April 1 is $4,500. 10. When ending cash balances are less than $4,000, they make a short-term borrowing from their local bank. However, all borrowings must be made in multiples of $100. These short- term loans are repaid at the end of the year, which is December 31". Oui-Got Stuff, Inc. Purchases Budget For the 2nd Quarter Ended 200x April $ 11,000 June $ 16,000 Budgeted cost of goods sold Plus: desired ending inventory Total inventory needs Less: beginning inventory 3,250 14,250 (2,500) $11,750 May $ 13,000 4,000 17,000 5,250 21,250 (3,250) $ 13,750 (4,000) Budgeted purchases $ 17,250 The company needs to prepare its budgeted cash receipts, budgeted cash payments for purchases, and monthly cash budget schedules for April, May and June. Required: a. Prepare a monthly budgeted operating cash receipts schedule for the 2nd quarter, i.e. April, May, and June. b. Prepare a monthly budgeted cash disbursements schedule for purchases for April, May, and June. c. Prepare a monthly total cash budget for April, May, and June. In that schedule, show borrowings from the company's local bank as needed to maintain the minimum cash balance. (Note: In your schedules show all three months, i.e. in 3 columns, rather than preparing separate schedules for each month.)
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
Related questions
Question
please give details calculations thank you
![Problem 4
Qui-Got Stuff is preparing its budget for the coming year. Below is information about the 2nd quarter,
which is not yet finished.
The following additional information is available:
Budgeted Income statement for July 200x:
The budgeted income statement for the 2nd
quarter is:
July
$ 32,000
Qui-Got Stuff, Inc.
Budgeted Income Statement
For the 2nd Quarter Ended 200x
Sales
Cost of goods sold
21,000
Gross profit
11,000
June
$ 28,000
April
May
Less:
Sales
$ 22,000
$ 25,000
Selling expenses
4,200
Cost of goods sold
11,000
13,000
16,000
Gross profit
11,000
12,000
12,000
Administrative expenses
3,600
Total
7,800
Less:
Selling expenses
2,300
3,000
3,400
Net income
$ 3,200
Administrative expenses
2,600
3,000
3,200
1. 80% of monthly sales are on account (i.e., for credit). The remainder is for cash.
2. Credit sales are collected as follows:
Total
4,900
6,000
6,600
10% in the month of credit sales
Net income
$ 6,100
$ 6,000
$ 5,400
60% in the month following the credit sales
The remainder in the 2nd month following the credit sales
Qui-Got Stuff has also completed the purchases budget, as follows:
3. Total budgeted sales for February are $15,000.
4. Total budgeted sales for March are $16,000.
5. Qui-Got assumes it would pay for budgeted purchases 65% in the month of purchase and
35% in the month following the purchase.
6. Budgeted purchases for March are $12,000.
7. For the months of April and May, the company must make a $5,000 payment for an
outstanding bank note.
8. Qui-Got must maintain a cash balance of at least $4,000 at the end of each month.
9. The budgeted cash balance at April 1 is $4,500.
10. When ending cash balances are less than $4,000, they make a short-term borrowing from
their local bank. However, all borrowings must be made in multiples of $100. These short-
term loans are repaid at the end of the year, which is December 31st.
Qui-Got Stuff, Inc.
Purchases Budget
For the 2nd Quarter Ended 200x
April
May
$ 13,000
4,000
17,000
(3,250)
$ 13,750
June
Budgeted cost of goods sold
Plus: desired ending inventory
$ 11,000
$ 16,000
3,250
5,250
Total inventory needs
14,250
21,250
Less: beginning inventory
Budgeted purchases
(2,500)
$ 11,750
(4,000)
$ 17,250
The company needs to prepare its budgeted cash receipts, budgeted cash payments for purchases, and
monthly cash budget schedules for April, May and June.
Required:
a. Prepare a monthly budgeted operating cash receipts schedule for the 2nd quarter, i.e. April, May,
and June.
b. Prepare a monthly budgeted cash disbursements schedule for purchases for April, May, and June.
c. Prepare a monthly total cash budget for April, May, and June. In that schedule, show borrowings
from the company's local bank as needed to maintain the minimum cash balance.
(Note: In your schedules show all three months, i.e. in 3 columns, rather than preparing separate
schedules for each month.)](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2F3cca2471-f089-4df3-91eb-fc0372255974%2F81b78b04-41bf-4c31-8b5c-ba3b6e34c0cd%2Fsw2uhb5_processed.jpeg&w=3840&q=75)
Transcribed Image Text:Problem 4
Qui-Got Stuff is preparing its budget for the coming year. Below is information about the 2nd quarter,
which is not yet finished.
The following additional information is available:
Budgeted Income statement for July 200x:
The budgeted income statement for the 2nd
quarter is:
July
$ 32,000
Qui-Got Stuff, Inc.
Budgeted Income Statement
For the 2nd Quarter Ended 200x
Sales
Cost of goods sold
21,000
Gross profit
11,000
June
$ 28,000
April
May
Less:
Sales
$ 22,000
$ 25,000
Selling expenses
4,200
Cost of goods sold
11,000
13,000
16,000
Gross profit
11,000
12,000
12,000
Administrative expenses
3,600
Total
7,800
Less:
Selling expenses
2,300
3,000
3,400
Net income
$ 3,200
Administrative expenses
2,600
3,000
3,200
1. 80% of monthly sales are on account (i.e., for credit). The remainder is for cash.
2. Credit sales are collected as follows:
Total
4,900
6,000
6,600
10% in the month of credit sales
Net income
$ 6,100
$ 6,000
$ 5,400
60% in the month following the credit sales
The remainder in the 2nd month following the credit sales
Qui-Got Stuff has also completed the purchases budget, as follows:
3. Total budgeted sales for February are $15,000.
4. Total budgeted sales for March are $16,000.
5. Qui-Got assumes it would pay for budgeted purchases 65% in the month of purchase and
35% in the month following the purchase.
6. Budgeted purchases for March are $12,000.
7. For the months of April and May, the company must make a $5,000 payment for an
outstanding bank note.
8. Qui-Got must maintain a cash balance of at least $4,000 at the end of each month.
9. The budgeted cash balance at April 1 is $4,500.
10. When ending cash balances are less than $4,000, they make a short-term borrowing from
their local bank. However, all borrowings must be made in multiples of $100. These short-
term loans are repaid at the end of the year, which is December 31st.
Qui-Got Stuff, Inc.
Purchases Budget
For the 2nd Quarter Ended 200x
April
May
$ 13,000
4,000
17,000
(3,250)
$ 13,750
June
Budgeted cost of goods sold
Plus: desired ending inventory
$ 11,000
$ 16,000
3,250
5,250
Total inventory needs
14,250
21,250
Less: beginning inventory
Budgeted purchases
(2,500)
$ 11,750
(4,000)
$ 17,250
The company needs to prepare its budgeted cash receipts, budgeted cash payments for purchases, and
monthly cash budget schedules for April, May and June.
Required:
a. Prepare a monthly budgeted operating cash receipts schedule for the 2nd quarter, i.e. April, May,
and June.
b. Prepare a monthly budgeted cash disbursements schedule for purchases for April, May, and June.
c. Prepare a monthly total cash budget for April, May, and June. In that schedule, show borrowings
from the company's local bank as needed to maintain the minimum cash balance.
(Note: In your schedules show all three months, i.e. in 3 columns, rather than preparing separate
schedules for each month.)
Expert Solution
![](/static/compass_v2/shared-icons/check-mark.png)
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 3 steps with 6 images
![Blurred answer](/static/compass_v2/solution-images/blurred-answer.jpg)
Knowledge Booster
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.Recommended textbooks for you
![FINANCIAL ACCOUNTING](https://compass-isbn-assets.s3.amazonaws.com/isbn_cover_images/9781259964947/9781259964947_smallCoverImage.jpg)
![Accounting](https://www.bartleby.com/isbn_cover_images/9781337272094/9781337272094_smallCoverImage.gif)
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
![Accounting Information Systems](https://www.bartleby.com/isbn_cover_images/9781337619202/9781337619202_smallCoverImage.gif)
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
![FINANCIAL ACCOUNTING](https://compass-isbn-assets.s3.amazonaws.com/isbn_cover_images/9781259964947/9781259964947_smallCoverImage.jpg)
![Accounting](https://www.bartleby.com/isbn_cover_images/9781337272094/9781337272094_smallCoverImage.gif)
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
![Accounting Information Systems](https://www.bartleby.com/isbn_cover_images/9781337619202/9781337619202_smallCoverImage.gif)
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
![Horngren's Cost Accounting: A Managerial Emphasis…](https://www.bartleby.com/isbn_cover_images/9780134475585/9780134475585_smallCoverImage.gif)
Horngren's Cost Accounting: A Managerial Emphasis…
Accounting
ISBN:
9780134475585
Author:
Srikant M. Datar, Madhav V. Rajan
Publisher:
PEARSON
![Intermediate Accounting](https://www.bartleby.com/isbn_cover_images/9781259722660/9781259722660_smallCoverImage.gif)
Intermediate Accounting
Accounting
ISBN:
9781259722660
Author:
J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:
McGraw-Hill Education
![Financial and Managerial Accounting](https://www.bartleby.com/isbn_cover_images/9781259726705/9781259726705_smallCoverImage.gif)
Financial and Managerial Accounting
Accounting
ISBN:
9781259726705
Author:
John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:
McGraw-Hill Education