Purchase Solution

Preparing a Schedule of Cash Collections

Not what you're looking for?

Ask Custom Question

I am not understanding how to break these figures down quarterly. The examples in the textbook are done by quarters byt he assignment is asking for monthly figures:

Duffy Corporation has prepared the following sales budget:
Month Cash Sales Credit Sales
May $16,000 $68,000
June 20,000 80,000
July 18,000 74,000
August 24,000 92,000
September 22,000 76,000

Collections are 40% in the month of sale, 45% in the month following the sale, and 10% two months following the sale. The remaining 5% is expected to be uncollectible.

Required:
Prepare a schedule of cash collections for July through September.

Purchase this Solution

Solution Summary

The solution assists in preparing a schedule of cash collections.

Solution provided by:
Education
  • B. Sc., University of Nigeria
  • M. Sc., London South Bank University
Recent Feedback
  • "Thank you."
  • "thank you Chidi Ngene.. if you have any APA references would be great"
  • "Thank you so much for your help, your explanations were easy to understand and apply!"
  • "are you able to highlight the equations used either on the xlsx or a word doc as to how each graph was formed- overall looks fine i just need help understanding this myself"
  • "Chidi Ngene, M. Sc. Was extremely helpful as without the help and guidance I would have failed, but with the help I passed. I still have a lot to learn and in need of the guidance to understand and learn more on the subject. I would recommend Chidi Ngene and BrainMass to anyone that are in need of help. Thank you!!"
Purchase this Solution


Free BrainMass Quizzes
Writing Business Plans

This quiz will test your understanding of how to write good business plans, the usual components of a good plan, purposes, terms, and writing style tips.

IPOs

This Quiz is compiled of questions that pertain to IPOs (Initial Public Offerings)

Transformational Leadership

This quiz covers the topic of transformational leadership. Specifically, this quiz covers the theories proposed by James MacGregor Burns and Bernard Bass. Students familiar with transformational leadership should easily be able to answer the questions detailed below.

Business Processes

This quiz is intended to help business students better understand business processes, including those related to manufacturing and marketing. The questions focus on terms used to describe business processes and marketing activities.

Balance Sheet

The Fundamental Classified Balance Sheet. What to know to make it easy.