Prepare monthly cash budgets

Assignment Help Financial Management

Reference no: EM133201074

Assignment:

To Industries prepares monthly cash budgets. The following budget information is available for April and May 2020

April	May
Sales	$650,000	$700,000
Direct material purchases	220,000	240,000
Direct labor	175,000	180,000
Manufacturing overhead	120,000	130,000
Selling and administrative expenses	150,000	150,000

All sales are credit sales. The company expects to collect 65% from customers in the month of the sale and the remaining 35% in first month following the sale. The company purchases direct materials on account. The company pays for 70% of the purchases in the month of the purchases and the remaining 30% in the first month following the purchase.Direct labor, manufacturing overhead, and selling and administrative expenses are paid in cash in the month incurred.

Additional information:

March 2020 credit sales were $600,000
March 2020 purchases of direct materials were $200,000
The company's cash balance on April 1, 2020 is expected to be $90,000
The company wants to maintain a minimum cash balance of $80,000 and has a line of credit in the amount of 1,000,000, with an annual interest rate of 6%, available to borrow if the budgeted cash balance falls below that level. Any amounts borrowed on the line of credit at the end of a month require a cash interest payment in the subsequent month. If the ending cash balance in a month exceeds the minimum balance, the excess amount is used to repay any amounts borrowed on the line of credit.

Required

Prepare a schedule of cash collections from credit sales for April and May 2020.
Prepare a schedule of cash disbursements for direct material purchases for April and May 2020.
Prepare a cash budget for April and May 2020 in columnar format.

Reference no: EM133201074

Questions Cloud

What can be done by both fiscal and monetary policies : Now that you have learned about how the economy works, what can be done by both fiscal and monetary policies. Diablo Valley College. econ 220.

Why is based budgeting vulnerable to political influence : Why is performance-based budgeting vulnerable to political influence? What are its shortcomings? Would you recommend it for your state? Why or why not?

Which market structure is most efficient in a static sense : Which market structure is the most efficient in a static sense? Which is most efficient in a dynamic sense? Explain your reasoning.

Would prefer world live in to a world of perfect competition : Discuss Why ( or why not) would you prefer the world we live in to a world of perfect competition?

Prepare monthly cash budgets : To Industries prepares monthly cash budgets. The following budget information is available for April and May 2020.

Principles of microeconomics-scarcity-social provisioning : Principles of Microeconomics: Scarcity and Social Provisioning. OpenStax Economics, Principles of Economics. OpenStax CNX. May 18, 2016.

How changes in expected inflation result in change : Explain how changes in expected inflation result in changes in the level of inflation. Use an equation to help explain your answer.

What is the company capital structure policy : Select a publicly traded company, preferable a company from your country that its securities trade in the U.S. capital market. University of the Cumberlands.

Determine the cost of those alternative sources of capital : How can the firm determine the cost of those alternative sources of capital? University of the Cumberlands.

User Account

All Pages