Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

The owner of Cupcake Heaven, Sarah Winter, needs some assistance in preparing her budget and budget reports. She has gone through her past records thoroughly

The owner of Cupcake Heaven, Sarah Winter, needs some assistance in preparing her budget and budget reports. She has gone through her past records thoroughly and has prepared a summary of what has happened and what is expected to happen. However, she is unsure how to determine cash receipts from debtors and cash payments from creditors.She has provided the following for your information

image text in transcribedimage text in transcribedimage text in transcribedimage text in transcribed
From balance sheet Balance of stock control Balance of debtors control Balance of creditors control Balance of cash at bank From the prot and loss statement Cash sales Credit sales Cost of sales Stock loss Wages Office expenses Discount expense Discount revenue Bad debts Actual 31 July 2017 $ 2600 2400 8600 3210 Actual 31 July 2017 6500 2750 4500 800 1 600 200 1 10 1 50 1 00 Predicted 31 August 2017 $ 36400 2800 9600 ? Predicted 31 August 2017 6600 2800 4600 800 1600 200 120 160 100 A. Reconstruction of ledger accounts for August 2017 Debtors Control Account Balance Discount expen 3e Sales Bad debts GST Cash at bank Balance Stock Control Account Balance Cost of sales Creditors Stock loss Balance Balance Creditors Control Account Discount revenue Balance Cash at bank Stock Control Balance Balance | Budgeted Cash Flow Statement for month ending 31 August 2017 Cash flow from operating activities Cash sales Collections from debtors GST collected Payments to creditors Wages Ofce Expenses GST paid Cash provided (used) by operating activities Net increase (decrease) by operating activities Cash held at beginning of month Cash held at end of month D. Budgeted Prot and Loss Statement for month ending 31 August 2017 Less Less Pius Less Revenue Cash sales Credit sales Cost of sales Stock loss Other revenue Discount revenue Expenses Wages Ofce expenses Discount expenses Bad debts Gross Prot Adjusted Gross Prot Net prot

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Horngrens Financial & Managerial Accounting The Financial Chapters

Authors: Tracie L. Miller Nobles, Brenda L. Mattison, Ella Mae Matsumura

4th Edition

0133255573, 978-0133255577

More Books

Students also viewed these Accounting questions

Question

2. What do the others in the network want to achieve?

Answered: 1 week ago

Question

1. What do I want to achieve?

Answered: 1 week ago