Question & Answer: Question 3 Prepare cash budget from financial statements The Red Bean Company processes and distributes beans. The beans are packed…..

Question 3 Prepare cash budget from financial statements The Red Bean Company processes and distributes beans. The beans are packed in 500 gram-plastic bags and sold to grocery chains for $0.50 each in boxes of 100 bags. During March the entity anticipates selling 16 000 boxes (sales in February were 14 000 boxes). Typically, 80 per cent of the entitys customers pay within the month of sale, 18 per cent of the customer pay the month after, and 2 per cent of sales are never collected. The entity buys beans from local farmers. The farmers are paid S0.20 per 500 grams, cash. Most of the processing is done automatically. Consequently, most ($80 000) of the entitys factory overhead is depreciation expense. The entity advertises heavily. For March managers expect to publish $75 000 worth of advertisements in popular magazines. This amount is up from Februarys $60 000. The entity pays for 10 per cent of its advertising Marchs budgeted income statement and statement of cost of goods manufactured and sold follow. All costs and expenses are paid for as incurred unless specifically indicated otherwise. The entity will begin March with a cash balance of $25 000, and pays a monthly dividend of $15 000 to the owners. in the month the advertisements are run and 90 per cent in the following month. Statement of profit or loss $800000 540000 260000 80000 69 000 75000 16000 $ 20000 Cost of sales Gross margin Administrative salaries Sales commissions Bad debts expense Operating income Statement of cost of goods manufactured and sold 20000 Beginning balance direct materials Direct materials purchases Materials available for use Ending balance direct materials Direct materials used Labour costs incurred Overhead costs 320000 90000 115000 525000 45000 570000 30000 $540000 Cost of good manufactured Beginning finished goods balance Goods available for sale Ending finished goods balance Cost of sales Required From the information provided, prepare a cash budget for March.

Question 3 Prepare cash budget from financial statements The Red Bean Company processes and distributes beans. The beans are packed in 500 gram-plastic bags and sold to grocery chains for $0.50 each in boxes of 100 bags. During March the entity anticipates selling 16 000 boxes (sales in February were 14 000 boxes). Typically, 80 per cent of the entity’s customers pay within the month of sale, 18 per cent of the customer pay the month after, and 2 per cent of sales are never collected. The entity buys beans from local farmers. The farmers are paid S0.20 per 500 grams, cash. Most of the processing is done automatically. Consequently, most ($80 000) of the entity’s factory overhead is depreciation expense. The entity advertises heavily. For March managers expect to publish $75 000 worth of advertisements in popular magazines. This amount is up from February’s $60 000. The entity pays for 10 per cent of its advertising March’s budgeted income statement and statement of cost of goods manufactured and sold follow. All costs and expenses are paid for as incurred unless specifically indicated otherwise. The entity will begin March with a cash balance of $25 000, and pays a monthly dividend of $15 000 to the owners. in the month the advertisements are run and 90 per cent in the following month. Statement of profit or loss $800000 540000 260000 80000 69 000 75000 16000 $ 20000 Cost of sales Gross margin Administrative salaries Sales commissions Bad debts expense Operating income Statement of cost of goods manufactured and sold 20000 Beginning balance direct materials Direct materials purchases Materials available for use Ending balance direct materials Direct materials used Labour costs incurred Overhead costs 320000 90000 115000 525000 45000 570000 30000 $540000 Cost of good manufactured Beginning finished goods balance Goods available for sale Ending finished goods balance Cost of sales Required From the information provided, prepare a cash budget for March.

Expert Answer

 

Don't use plagiarized sources. Get Your Custom Essay on
Question & Answer: Question 3 Prepare cash budget from financial statements The Red Bean Company processes and distributes beans. The beans are packed…..
GET AN ESSAY WRITTEN FOR YOU FROM AS LOW AS $13/PAGE
Order Essay

The Red Bean Company

Cash Budget

For the month of March

$ $
Beginning cash balance 25,000
Add Receipts from sales
February Sales 126,000
March Sales 640,000 766,000
Total cash available 791,000
Less: Disbursements
Direct Material Purchases 330,000
Labor Costs 90,000
Cash Overheads ( $ 115,000 – $ 80,000) 35,000
Advertising 61,500 *
Sales Commissions 69,000
Administrative Salaries 80,000
Dividends 15,000
Total cash disbursements 680,500
Ending cash balance 110,500

* Amount paid for advertising during March : $ 60,000 x 0.90 + $ 75,000 x 0.10 = $ 54,000 + $ 7,500 = $ 61,500

Grand Paper Writers
Order NOW For A 10% Discount!
Pages (550 words)
Approximate price: -

Our Advantages

Plagiarism Free Papers

All papers are written by the best professional writers to ensure 100% originality. We always provide plagiarism reports whenever we deliver completed papers.

Free Revisions

All papers by Grand Paper Writers are completed and submitted on time. This timely delivery of papers gives you time to go through the paper before the official deadline.

Title-page

As an additional service, we will provide a title page that precedes the contents of your paper. Here, you will provide your personal details.

Bibliography

We also ensure that we provide an extra page for the references or bibliographies following referencing rules.

Originality & Security

At Grandpaperwriters.com, we guarantee students for the provision of security and original work. All your personal information is handled with confidentiality and is not shared with third parties. Additionally, we ensure that we provide original content with accompanying plagiarism reports to show originality.

24/7 Customer Support

Our customer support team is always available 24/7 to provide instant responses to any queries raised by students.

Try it now!

Calculate the price of your order

We'll send you the first draft for approval by at
Total price:
$0.00

How it works?

Follow these simple steps to get your paper done

Place your order

Fill in the order form and provide all details of your assignment.

Proceed with the payment

Choose the payment system that suits you most.

Receive the final file

Once your paper is ready, we will email it to you.

Our Services

Grandpaperwriters.com has the best professional essay writers for quality services.

Pricing

Flexible Pricing

Here, a Grandpaperwriters.com, we do not compromise on the time of our clients. We always deliver all completed papers on or before the deadlines.

Communication

Admission Help & Client-Writer Contact

Grandpaperwriters.com provides an interactive portal where students can communicate directly to their writers.

Deadlines

Paper Submission

Here, a Grandpaperwriters.com, we do not compromise on the time of our clients. We always deliver all completed papers on or before the deadlines.

Reviews

Customer Feedback

Grandpaperwriters.com appreciates feedback from our clients to help us improve the delivery of essay writing services. As such, we are constantly changing our policies to ensure maximum customer and writer satisfaction.