Purchase Solution

Budgets : key information

Not what you're looking for?

Ask Custom Question

*Please describe how to calculate.

ABC company started business on January 1, 2010. The company estimated that sales for the first six months would be as attaches:

*Please look at the attachment

The Company sells all items on account and expects collections of accounts receivable to be as follows: 60% in the month of the sale, and the remaining 40% in the month after the sale.

A) Compute the expected cash collections during the months of January, February, March, April, May, and June.

B) The company has decided that finished goods inventory at the end of each month should ideally be equal to 40% of next month's sales. What should budgeted production be for each of the first four months?

C) It takes two pounds of raw material to make one unit of finished product. The company wants to keep an ending inventory of raw material equal to 30% of next month's production needs. How many pounds of raw material should be purchased in each of the first three months?

D) The raw material costs $2 per pound. The company pays for 70% of its purchases during the month of purchase and the remainder in the following month. How much cash will be disbursed during the month of March for the purchase of of raw material?

E) The projected cash balance on March 1 is $13,500. What is the estimated cash balance at the end of the month? (Prepare a formal cash budget for the month of March.)

Attachments
Purchase this Solution

Solution Summary

The solution explains how to calculate the expected cash collection, budgeted production, purchases and the ending cash balance

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.

Basic Social Media Concepts

The quiz will test your knowledge on basic social media concepts.

Paradigms and Frameworks of Management Research

This quiz evaluates your understanding of the paradigm-based and epistimological frameworks of research. It is intended for advanced students.

Organizational Behavior (OB)

The organizational behavior (OB) quiz will help you better understand organizational behavior through the lens of managers including workforce diversity.

Introduction to Finance

This quiz test introductory finance topics.