Using tha above information, prepare the following: 1. Prepare a cash receipts budget for the six months 2. Prepare a cash payments budget for the six months 3. Prepare a budgeted pfofit and loss to Gross Profit for the six months

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
Beached is a retail outlet situated in a very popular tourist town not far from Canberra. It is very popular during school holidays, with the
peak tourist season being in December and January.
Sales consist of cash sales to retail customers (70%) and credit sales to tourist operators (30%). Credit sales are collected 20% in the month of
sale, 60% in the month following the sale and 20% in the second month following the sale.
Opening Accounts Receivable are $120,000.
Inventory is marked-up 70% on cost and inventory opening balances are required to be 60% of the month's expected sales.
Inventory is purchased on credit with 40% paid in the month following the purchase and the remainder paid two months following the
purchase. Opening Accounts Payable is $80,000.
Using tha above information, prepare the following:
1. Prepare a cash receipts budget for the six months
2. Prepare a cash payments budget for the six months
3. Prepare a budgeted pfofit and loss to Gross Profit for the six months
Jan
Feb
Mar
Apr
May
Jun
Sales
150,000
120,000
115,000
135,000
110,000
125,000
Transcribed Image Text:Beached is a retail outlet situated in a very popular tourist town not far from Canberra. It is very popular during school holidays, with the peak tourist season being in December and January. Sales consist of cash sales to retail customers (70%) and credit sales to tourist operators (30%). Credit sales are collected 20% in the month of sale, 60% in the month following the sale and 20% in the second month following the sale. Opening Accounts Receivable are $120,000. Inventory is marked-up 70% on cost and inventory opening balances are required to be 60% of the month's expected sales. Inventory is purchased on credit with 40% paid in the month following the purchase and the remainder paid two months following the purchase. Opening Accounts Payable is $80,000. Using tha above information, prepare the following: 1. Prepare a cash receipts budget for the six months 2. Prepare a cash payments budget for the six months 3. Prepare a budgeted pfofit and loss to Gross Profit for the six months Jan Feb Mar Apr May Jun Sales 150,000 120,000 115,000 135,000 110,000 125,000
Expert Solution
steps

Step by step

Solved in 3 steps with 3 images

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