Prepare a monthly cash budget for citizens produce co-op

Assignment Help Corporate Finance
Reference no: EM13889922

Citizens Produce Co-op is one of the biggest produce operations in northern Texas. Credit sales to retailers in the area constitute 80 percent of Citizens Produce's business; cash sales to customers at the company's retail outlet make up the other 20 percent. Collection records indicate that Citizens Produce collects payment on 50 per- cent of all credit sales during the month of sale, 30 percent in the month after the sale, and 20 percent in the second month after the sale.

The company's total sales in May were $60,000; in June, they were $70,000. Antic- ipated sales in July are $75,000; in August, $80,000; and in September, $90,000. The company's produce purchases are expected to total $45,000 in July, $51,000 in August, and $60,000 in September. The company pays for all purchases in cash.

Projected monthly costs for the quarter include $1,000 for heat, light, and power; $400 for bank fees; $2,000 for rent; $1,120 for supplies; $1,705 for depreciation of equipment; $1,285 for equipment repairs; and $500 for miscellaneous expenses. Other projected costs for the quarter are salaries and wages of $18,700 in July, $19,500 in August, and $20,600 in September.

The company's cash balance at June 30 was $2,000. Effective July 1, the company has a new policy of maintaining a minimum monthly cash balance of $3,000 and can borrow from the bank in multiples of $100.

1. Prepare a monthly cash budget for Citizens Produce Co-op for the quarter ended September 30.

2. Should Citizens Produce anticipate taking out a loan during the quarter? If so, how much should it borrow, and when?

Reference no: EM13889922

Questions Cloud

Kinetic energy and gravitational potential energy : Energy [define work and energy; kinetic energy and gravitational potential energy (incl. trends); (total) energy; law of Conservation of Energy (LCE); dropping object as illustration of LCE (detail ); energy transformation
What other factors mitigate the dangers of nonperformance : What other factors mitigate the dangers of nonperformance in sequential trading relationships besides contracts?
Determining the primary action : Evaluated three scenarios described by determining the primary action(s) that you should take to limit liability and impact on operations; thoroughly specified which ethical theory best supports your decision.
Demands, along with selling price and material costs : The Morning Brew Coffee Shop sells Regular, Cappuccino, and Vienna blends of coffee. The shop's current daily labor cost is $320, the equipment cost is $125, and the overhead cost is $225.
Prepare a monthly cash budget for citizens produce co-op : Prepare a monthly cash budget for Citizens Produce Co-op for the quarter ended September 30. Should Citizens Produce anticipate taking out a loan during the quarter? If so, how much should it borrow, and when?
Focus of future developments in the business : This is a prediction of the focus of future developments in the Business Law course 10 years from the present. It includes how it will apply to a student's current or future career, including rationale, research, and if there are any alternative p..
Set fs script before processing records : Set FS script before processing records. This is also a good place to set up an array of month names in chronological order - you want to try sorting the catagory section.
Why might you expect there to be economies of scale : Why might you expect there to be economies of scale in airline transportation? How are the development of hub-and-spoke networks related to economies of scale and scope?
Describe an example of political tides : Describe an example of political tides having sway over public administration decisions. Is a public administrator who alters his/ her position due to political pressures merely responding to the will of the people or neglecting his/ her duties as..

Reviews

Write a Review

Corporate Finance Questions & Answers

  Intermediate financealways leave 4 decimals in the numbers

intermediate financealways leave 4 decimals in the numbers in your calculations e.g. pmt 10.8924 and particularly 6

  You are a partner of private equity firm tiger llc

you are a partner of private equity firm tiger llc acquiring firm and you have the following information for the

  What are the pros and cons methods of capital budgeting

What are the pros and cons of each of these 3 methods of capital budgeting: Simple Payback, Net Present Value, IRR and how does use of each of the 3 methods adjust for projects of varying risk.

  What can the stakeholders learn from specific situation

What can the stakeholders learn from specific situation and what have you learned from this case that you can apply immediately in your own career or life experience?

  Great lake clinic has been asked to provide exclusive

great lake clinic has been asked to provide exclusive healthcare services for next years world exposition. although

  Capital structure decisionsan understanding of the concepts

capital structure decisionsan understanding of the concepts of complete markets and spanning are essential for an

  Evaluate the criteria or mechanisms used by the organisation

Evaluate the criteria or mechanisms used by the organisation for deciding how best to acquire capital and analyse the capital structure of the company.

  Discussing the financial term

Identify at least two articles about one of these financial terms: EBITDAM, financial ethics, financial benchmarking, financial trend analysis, balance sheet, shareholder's equity, EBITDA, and ratio analysis.

  Computation of cost of goods sold

Computation of cost of goods sold from given data - The dollar value of its desired ending inventory is 25% of the following month's cost of goods sold.

  Computation of present value of bond

Computation of present value of bond to check whether it is overpriced - Ron Rhodes calles his broker to inquire about purchasing a bond of Golden Years Recreation Corporation

  How much would you expect to pay to purchase

What is the present value of $3,000, discounted at 8 percent interest per period, for two periods and  on an investment of $2,000, you'll earn 10 percent interest per year compounded semiannually. What is the future value of this investment after ..

  Calculation of the required ratios

Use formulas to compute ratios and format cells to insert comma if there is more than three (3) numbers. Give your answer to the nearest whole dollar.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd