Colter company prepares monthly cash budgets

Assignment Help Financial Accounting

Reference no: EM13925536

Colter Company prepares monthly cash budgets. Relevant data from operating budgets for 2017 are as follows:

	January	February
Sales	$426,960	$474,400
Direct materials purchases	142,320	148,250
Direct labor	106,740	118,600
Manufacturing overhead	83,020	88,950
Selling and administrative expenses	93,694	100,810

All sales are on account. Collections are expected to be 50% in the month of sale, 30% in the first month following the sale, and 20% in the second month following the sale. Sixty percent (60%) of direct materials purchases are paid in cash in the month of purchase, and the balance due is paid in the month following the purchase. All other items above are paid in the month incurred except for selling and administrative expenses that include $1,186 of depreciation per month.

Other data:

1.		Credit sales: November 2016, $296,500; December 2016, $379,520.
2.		Purchases of direct materials: December 2016, $118,600.
3.		Other receipts: January-Collection of December 31, 2016, notes receivable $17,790;
		February-Proceeds from sale of securities $7,116.
4.		Other disbursements: February-Payment of $7,116 cash dividend.

The company's cash balance on January 1, 2017, is expected to be $71,160. The company wants to maintain a minimum cash balance of $59,300.

Prepare schedules for (1) expected collections from customers and (2) expected payments for direct materials purchases for January and February.

Reference no: EM13925536

Questions Cloud

Contingency table by gender and department : Table 1 shows the number of applicants to graduate school at Berkeley for the six largest departments in 1973 by gender and department. Table 2 shows the number of rejected applicants by gender and department. Recall the notation GM, GF , DA, DB, ..

Disadvantages and challenges of global expansion : Write a short paper on the advantages, disadvantages and challenges of global expansion; Develop a suggested strategy for global expansion for your organization, another existing company, or an imaginary business (include a brief summary of whatev..

Malware paper - how effective it is at evading detection : Malware Paper, Note three kinds of malware that are active threats today. Note the following for each type: How common it is, A brief explanation of how it works and How effective it is at evading detection

What is your certainty equivalent return : If a portfolio has an expected excess return of 6 percent and risk of 20 percent, what is your certainty equivalent return, the certain expected excess return that you would fairly trade for this portfolio?

Colter company prepares monthly cash budgets : Colter Company prepares monthly cash budgets. Relevant data from operating budgets for 2017

Ethics is the study of : Question 1: Ethics is the study of Question 2: One studies ethics because

What are the firm''s major strengths and weaknesses : Calculate the 2013 profit margin, basic earning power (BEP), return on assets (ROA), and return on equity (ROE). What can you say about these ratios?

How should kb manager address issue of aging baby boomers : Which do you think are the most important environmental forces for KB Home? Why? Are there environmental forces besides those mentioned that you think KB management needs to focus on?

Natural gas producing firm is exposed to fluctuations : A natural gas producing firm is exposed to fluctuations in market prices of natural gas. If market conditions are favorable (high gas prices) the firm will realize a pre-tax operating profit of $300 million. If market conditions are unfavorable, then..

User Account

All Pages