Purchase Solution

Budgeting

Not what you're looking for?

Ask Custom Question

Express Company has budgeted sales for the first quarter of next year as follows: January $240,000 February $280,000 March $320,000. Sales are 70% credit and 30% cash. Credit sales are collected 80% in the month following sales and 20% in the second month following the sale. Cost of Goods is 65% of sales. Express Company desires an ending inventory equal to 60% of the next month's cost of goods sold. Purchases are paid for 25% in the month of purchase and 75% in the following month. A) What are the total cash collections in March? B) What is the budgeted March 31 Accounts Receivable? C) Prepare a purchases budget for February. D) How much will cash disbursements for purchases be in February? E) What is the budgeted February 28 Accounts Payable? F) What is the budgeted February 28 Inventory?

Purchase this Solution

Solution Summary

The following Excel file contains the solution to a problem involving cash budget

Purchase this Solution


Free BrainMass Quizzes
Understanding the Accounting Equation

These 10 questions help a new student of accounting to understand the basic premise of accounting and how it is applied to the business world.

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.

Business Ethics Awareness Strategy

This quiz is designed to assess your current ability for determining the characteristics of ethical behavior. It is essential that leaders, managers, and employees are able to distinguish between positive and negative ethical behavior. The quicker you assess a person's ethical tendency, the awareness empowers you to develop a strategy on how to interact with them.

Learning Lean

This quiz will help you understand the basic concepts of Lean.

Accounting: Statement of Cash flows

This quiz tests your knowledge of the components of the statements of cash flows and the methods used to determine cash flows.