Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Please answer Question 5b. Please write in this format (see below as an example) Question 5 Bluebird Ltd has provided the following forecasted items for

Please answer Question 5b.

image text in transcribed

Please write in this format (see below as an example)

image text in transcribed

Question 5 Bluebird Ltd has provided the following forecasted items for the months of July through to September 2020. July August Septembe $ $ $ Sales 14,000 15,000 13,000 9,400 Purchases 8,000 10,000 Operating expenses 3,600 6,400 5,000 Other Information: 35% of Sales are cash sales, the remaining 65% of credit sales which are collected as follows: o 30% in the month of the sale O 40% in the month after the sale o 28% in the 2nd month after the sale o 2% are never collected due to the customer going bankrupt Sales in the months of May and June were $11,000 and $10,000 respectively. . Operating expenses include depreciation expense. Depreciation expense each month is $900. All expenses and purchases are paid for in the same month that they are incurred. Bluebird expects to sell some old machinery for $7,000 in August. New machinery worth $9,500 will be purchased in September. The cash balance on 1st July 2020 is $5,700. Required: a. Prepare a schedule of the Cash receipts from Accounts receivable showing the collections for the three months of July through to September. (5 marks) b. Prepare a Cash budget for Bluebird Ltd for the three months of July through to September 2020. (10 marks) Cash Budget for July Cash Receipts July sales (80% of $80 000) June sales ((15% of $70 000) May sales (5% of $60 000) Total cash receipts $64 000 $10 500 3 000 $77 500 Cash Payments June purchases ($30 000 ~ 99%) Operating expenses Total cash payments $29 700 8 000 $37 700 Increase in cash Opening cash balance Closing cash balance 39 800 35 000 $74 800

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

GAO Financial Audit Manual Volume 2 Updated March 2021

Authors: United States Government GAO

2021 Edition

B091WM9DZW, 979-8733082875

More Books

Students also viewed these Accounting questions