Simone Limited distributes specialist wines on wholesale basis to its customers. Some of his sales will be for cash from a shop that he intends to rent. It also plans to sell some wine on credit to local restaurants and hotels. The details of his business plan are as follows:   It will rent a shop for GH¢10,000 per annum payable quarterly in The landlord also requires a deposit of GH¢5,000 to be paid when the rental starts in June.   It will invest GH¢12,000 from its own savings and a bank will loan it GH¢8,000. Interest is to be charged at a rate of 5% per annum payable   It will purchase and pay for GH¢12,000 of wine in June and To maintain that level of stock, he will continuously purchase wine to replace what is sold.   Suppliers will allow one month’s credit and credit customers will expect one month’s   Sales levels are predicted to be:     Total sales GH¢ Cash sales GH¢ Credit sales GH¢ June 6,000 3,000 3,000 July 6,500 3,000 3,500 August 7,000 3,000 4,000 September 8,000 3,500 4,500 October 9,500 4,500 5,000 November 12,000 5,000 7,000   Wine will be sold at a gross profit margin of 20%.   It intends to withdraw GH¢500 per month for private use and will employ a part-time assistant for GH¢400 per   It will need to purchase and install shelving that will be delivered and paid for at the beginning of June at a cost of GH¢3,800.   It will also lease a van at a cost of GH¢450 per Other anticipated costs are: GH¢ June                                                            500 July                                                      380 August                                                400 September                                           500 October                                               550 November                                           600   Required Prepare a cash budget for Simone Limited for first 6 months’ trading to 30 November

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

Simone Limited distributes specialist wines on wholesale basis to its customers. Some of his sales will be for cash from a shop that he intends to rent. It also plans to sell some wine on credit to local restaurants and hotels. The details of his business plan are as follows:

 

  • It will rent a shop for GH¢10,000 per annum payable quarterly in The landlord also requires a deposit of GH¢5,000 to be paid when the rental starts in June.

 

  • It will invest GH¢12,000 from its own savings and a bank will loan it GH¢8,000. Interest is to be charged at a rate of 5% per annum payable

 

  • It will purchase and pay for GH¢12,000 of wine in June and To maintain that level of stock, he will continuously purchase wine to replace what is sold.

 

  • Suppliers will allow one month’s credit and credit customers will expect one month’s

 

  • Sales levels are predicted to be:

 

 

Total sales GH¢

Cash sales

GH¢

Credit sales GH¢

June

6,000

3,000

3,000

July

6,500

3,000

3,500

August

7,000

3,000

4,000

September

8,000

3,500

4,500

October

9,500

4,500

5,000

November

12,000

5,000

7,000

 

  • Wine will be sold at a gross profit margin of 20%.

 

  • It intends to withdraw GH¢500 per month for private use and will employ a part-time assistant for GH¢400 per

 

  • It will need to purchase and install shelving that will be delivered and paid for at the beginning of June at a cost of GH¢3,800.

 

  • It will also lease a van at a cost of GH¢450 per
  • Other anticipated costs are: GH¢ June                                                            500

July                                                      380

August                                                400

September                                           500

October                                               550

November                                           600

 

Required

Prepare a cash budget for Simone Limited for first 6 months’ trading to 30 November

 

Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps with 1 images

Blurred answer
Knowledge Booster
Avoiding and Correcting Credit Mistakes
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
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