Completed Budgets (April, May, June, and Quarter Total, 2021) please find the required numerical information from the images attached  REQUIRED: Prepare a cash budget . Show the budget by month and in total.  What will be reported on the budgeted balance sheet at June 30, 2021 for accounts receivable? Supporting calculations required to earn available points. What will be reported on the budgeted balance sheet at June 30, 2021 for merchandise purchases payable? Supporting calculations required to earn available points.

FINANCIAL ACCOUNTING
10th Edition
ISBN:9781259964947
Author:Libby
Publisher:Libby
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
icon
Related questions
icon
Concept explainers
Question
100%

Your friend, Catherine Ross, owns Knockoffs Unlimited, a nationwide distributor of low-cost imitation designer necklaces.   She has contacted you for some assistance because the accounting clerk, George Forrest, recently won a sum of money and decided to resign immediately. Catherine knows that you are completing an accounting course at Cape Breton University and hopes you can prepare the cash budget for the upcoming quarter (April, May and June, 2021).

 

Catherine has provided you with the budgets completed by George. She has also provided you with additional information that will assist with the completion of the cash budget.

 

Completed Budgets (April, May, June, and Quarter Total, 2021)

please find the required numerical information from the images attached 

REQUIRED:

  1. Prepare a cash budget . Show the budget by month and in total. 
  2. What will be reported on the budgeted balance sheet at June 30, 2021 for accounts receivable? Supporting calculations required to earn available points.
  3. What will be reported on the budgeted balance sheet at June 30, 2021 for merchandise purchases payable? Supporting calculations required to earn available points.

 

 

 

Sales Budget
Budgeted sales in units
Unit sales price
April
70,000
May
60,000
June
55,000
Quarter
185,000
10
10
10
10
Sales in dollars
$700,000
$600,000
$550,000
$1,850,000
April
$
May
June
Quarter
31,000
352,000
700,000
540,000
110,000
1,733,000
Cash Colletions Budget
February sales
31,000
308,000
140,000
March sales
$44,000
April sales
May sales
490,000
70,000
420,000
110,000
600,000
120,000
June sales
Total
479,000
654,000
May
60,000
22,000
82,000
24,000
58,000
4 $
$ 264,000 $ 232,000 $ 212,000 $
April
70,000
June
Merchandise Purchases Budget
Sales in units (storage systems)
Add: Budgeted ending inventory
55,000
20,000
75,000
Quarter
185,000
24,000
94,000
28,000
66,000
$
20,000
205,000
28,000
177,000
Total needs
Less: Beginning fini shed goods inventory
Required unit purchases
Unit cost
22,000
53,000
4 $
4 $
4
Required Purchases
708,000
April
May
June
Quarter
$
Cash Disbursements - Inventory Purchases
March purchases
April purchases
May purchases
June purchases
108,000
264,000
372,000
106,000
710,000
$
108,000
132,000
132,000
116,000
116,000
106,000
$ 240,000 $ 248,000 $ 222,000 $
Transcribed Image Text:Sales Budget Budgeted sales in units Unit sales price April 70,000 May 60,000 June 55,000 Quarter 185,000 10 10 10 10 Sales in dollars $700,000 $600,000 $550,000 $1,850,000 April $ May June Quarter 31,000 352,000 700,000 540,000 110,000 1,733,000 Cash Colletions Budget February sales 31,000 308,000 140,000 March sales $44,000 April sales May sales 490,000 70,000 420,000 110,000 600,000 120,000 June sales Total 479,000 654,000 May 60,000 22,000 82,000 24,000 58,000 4 $ $ 264,000 $ 232,000 $ 212,000 $ April 70,000 June Merchandise Purchases Budget Sales in units (storage systems) Add: Budgeted ending inventory 55,000 20,000 75,000 Quarter 185,000 24,000 94,000 28,000 66,000 $ 20,000 205,000 28,000 177,000 Total needs Less: Beginning fini shed goods inventory Required unit purchases Unit cost 22,000 53,000 4 $ 4 $ 4 Required Purchases 708,000 April May June Quarter $ Cash Disbursements - Inventory Purchases March purchases April purchases May purchases June purchases 108,000 264,000 372,000 106,000 710,000 $ 108,000 132,000 132,000 116,000 116,000 106,000 $ 240,000 $ 248,000 $ 222,000 $
ADDITIONAL INFORMATION:
Cash balance, April 1, 2021 = $8,000
• The company's monthly selling and administrative expenses are provided below. All
selling and administrative expenses are paid in the month incurred, with the exception of
depreciation and insurance. Insurance is paid on an annual basis in December of each
year.
Variable expenses:
Commissions
5% of sales
Fixed expenses:
Advertising
Rent
$19,000
20,500
125,000
9,000
3,000
18,000
Wages & salaries
Utilities
Insurance
Depreciation
• The company plans to purchase new equipment for cash in May ($18,000) and June
(S45,000).
• The company wants to have an ending cash balance each month of $40,000. All
borrowing is done at the beginning of the month. The interest on outstanding loans is 1%
per month. Loan repayments and interest is only paid at the end of the month when there
is sufficient cash to do so. (The company does not borrow to pay interest or repay loans.)
Transcribed Image Text:ADDITIONAL INFORMATION: Cash balance, April 1, 2021 = $8,000 • The company's monthly selling and administrative expenses are provided below. All selling and administrative expenses are paid in the month incurred, with the exception of depreciation and insurance. Insurance is paid on an annual basis in December of each year. Variable expenses: Commissions 5% of sales Fixed expenses: Advertising Rent $19,000 20,500 125,000 9,000 3,000 18,000 Wages & salaries Utilities Insurance Depreciation • The company plans to purchase new equipment for cash in May ($18,000) and June (S45,000). • The company wants to have an ending cash balance each month of $40,000. All borrowing is done at the beginning of the month. The interest on outstanding loans is 1% per month. Loan repayments and interest is only paid at the end of the month when there is sufficient cash to do so. (The company does not borrow to pay interest or repay loans.)
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 4 steps

Blurred answer
Knowledge Booster
Budgeting
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
Recommended textbooks for you
FINANCIAL ACCOUNTING
FINANCIAL ACCOUNTING
Accounting
ISBN:
9781259964947
Author:
Libby
Publisher:
MCG
Accounting
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
Accounting Information Systems
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
Horngren's Cost Accounting: A Managerial Emphasis…
Horngren's Cost Accounting: A Managerial Emphasis…
Accounting
ISBN:
9780134475585
Author:
Srikant M. Datar, Madhav V. Rajan
Publisher:
PEARSON
Intermediate Accounting
Intermediate Accounting
Accounting
ISBN:
9781259722660
Author:
J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:
McGraw-Hill Education
Financial and Managerial Accounting
Financial and Managerial Accounting
Accounting
ISBN:
9781259726705
Author:
John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:
McGraw-Hill Education