Homework Help is Here – Start Your Trial Now!
Business
Accounting
Required: Prepare a cash budget for September and October.

Required: Prepare a cash budget for September and October.

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

Please do not give solution in image format ? And Fast Answering Please And Explain Proper Step by Step ?

Use the following data and information in order to put together a cash budget for September and October for Rakgwatha Confectionery. • Budgeted sales for September are 65 000 cupcakes and 98 000 cupcakes in October. Each cupcake sells for R3,50. • On average 60% are cash sales and 40% are sold on account. • The company expects to collect 75% of credit sales in the month of the sale and 20% in the month after the sale. • All necessary raw materials are purchased on account. Purchases are paid 85% in the month of the purchase and 15% in the following month. Purchases for September are estimated to be R200 000 and R290 000 in October. • Monthly expenses include: o Wages R10 000 o Rent R4 000 o Utilities R3 500 o Insurance R2 500 o Advertising R2 290 • Cash balance on September 1st was R6 000. • The company has a policy to maintain a minimum cash balance of R5 000. If necessary, the company will borrow to meet its short-term needs. All borrowing is done at the beginning of the month and all payments on principal and interest are made at the end of the next month. The annual interest rate is 7%. The company must borrow in multiples of R1 000. • August sales were 43 000 cupcakes and raw materials purchased equaled R230 000. Required: Prepare a cash budget for September and October.
Transcribed Image Text:Use the following data and information in order to put together a cash budget for September and October for Rakgwatha Confectionery. • Budgeted sales for September are 65 000 cupcakes and 98 000 cupcakes in October. Each cupcake sells for R3,50. • On average 60% are cash sales and 40% are sold on account. • The company expects to collect 75% of credit sales in the month of the sale and 20% in the month after the sale. • All necessary raw materials are purchased on account. Purchases are paid 85% in the month of the purchase and 15% in the following month. Purchases for September are estimated to be R200 000 and R290 000 in October. • Monthly expenses include: o Wages R10 000 o Rent R4 000 o Utilities R3 500 o Insurance R2 500 o Advertising R2 290 • Cash balance on September 1st was R6 000. • The company has a policy to maintain a minimum cash balance of R5 000. If necessary, the company will borrow to meet its short-term needs. All borrowing is done at the beginning of the month and all payments on principal and interest are made at the end of the next month. The annual interest rate is 7%. The company must borrow in multiples of R1 000. • August sales were 43 000 cupcakes and raw materials purchased equaled R230 000. Required: Prepare a cash budget for September and October.
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 4 steps

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
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
SEE MORE TEXTBOOKS