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

Principles of Accounting Volume 2
19th Edition
ISBN:9781947172609
Author:OpenStax
Publisher:OpenStax
Chapter7: Budgeting
Section: Chapter Questions
Problem 14EB: Earthies Shoes has 55% of its sales in cash and the remainder on credit. Of the credit sales, 70% is...
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
  • SEE MORE QUESTIONS
Recommended textbooks for you
Principles of Accounting Volume 2
Principles of Accounting Volume 2
Accounting
ISBN:
9781947172609
Author:
OpenStax
Publisher:
OpenStax College