Sales forecast for cbm over the next nine months

Assignment Help HR Management
Reference no: EM13748138

To avoid any uncertainty regarding his business' financing needs at the time when such needs may arise, Cyrus Brown wants to develop a Cash Budget for his latest venture- Cyrus Brown Manufacturing (CBM). He has estimated the following sales forecast for CBM over the next nine months:

March 2004 $250,000

April 275,000

May 320,000

June 450,000

July 575,000

August 700,000

September 825,000

October 350,000

November 285,000

He has also gathered the following collection estimates regarding the forecast sales: Collection within the month of sale, 10%; collection the month following sales, 65%, and collection the second month following sales, 25%. Payments for direct manufacturing costs like raw materials and labor are made during the month that follows the one in which such costs have been incurred. These costs are estimated as follows:

March 2004 $187,500

April 206,250

May 240,000

June 337,500

July 431,250

August 525,000

September 618,750

October 262,500

Administrative salaries will approximately amount to $35,000 a month; lease payments around $15,000 a month; depreciation charges, 15,000 a month; a one-time new plant investment in the amount of $95,000 is expected to be incurred and paid in June; income tax payments estimated to be around $ 55,000 will be due in both June and September; and finally, miscellaneous costs are estimated to be around $10,000 a month. Cash on hand on March 1 will be around $50,000; and a minimum cash balance of $50,000 shall be on hand at all times.

a. Prepare a monthly cash budget for Cyrus Brown Manufacturing for the nine month period, March through November.

b. Based on your findings in part b, will the company need any outside financing?

c. What is the minimum line of credit that CBM will need?

d. What do you think of CBM's cash position during the budget period? Do you see any concerns for the company in this regard?

e. If you were a bank manager would you want CBM as your client? Why or why not?

Reference no: EM13748138

Questions Cloud

Discuss the pros and cons of the tool providing evidence : Justify ten (10) techniques from the course that you would use to improve processes in an organization that you have chosen. Discuss the pros and cons of the tool providing evidence and examples of the use of the tool
How many tasks were not impacted : How many tasks were more difficult to perform without an opposable thumb? How many tasks were easier to perform with an opposable thumb? How many tasks were not impacted by the use of an opposable thumb
Comparing first-movers in technology : From the first and second e-Activities, analyze the key ways in which Intel and Microsoft capitalized on and reaped substantial first-mover advantages in pioneering new technologies. Provide a rationale to support your response.
What was nationalism : What was Nationalism? How did it propel European imperial powers down a road of dominance in Africa, Asia and the Americas?
Sales forecast for cbm over the next nine months : To avoid any uncertainty regarding his business' financing needs at the time when such needs may arise, Cyrus Brown wants to develop a Cash Budget for his latest venture- Cyrus Brown Manufacturing (CBM). He has estimated the following sales foreca..
Calculate the missing values in xyzs balance sheet : Calculate the missing values in XYZ's balance sheet and calculate net income for the year - Prepare the cash flow statement for the year using the indirect method.
Antibiotics : Your friend was diagnosed with strep throat 2 months ago. She was treated with antibiotics for 10 days, but 2 weeks after treatment, the symptoms returned. She was given a different antibiotic and her symptoms improved again, initially, but then g..
Identify the organization type : Identify the industry in which you are working, the organization type, and the general size of your hypothetical organization. Include the parameters of your choice in an Appendix A of the white paper.
When grand prince of moscow ivan iii stopped paying : When the grand prince of Moscow, Ivan III, stopped paying tribute to the Mongol Khan in 1848, it was seen as significant because?

Reviews

Write a Review

HR Management Questions & Answers

  Compensation and benefits explained in this solutionyou are

compensation and benefits explained in this solutionyou are the director of compensation and benefits for lansing-smith

  Dimensions of diversityin your role as a new manager you

dimensions of diversityin your role as a new manager you will be managing a workforce that has become increasingly

  If learning objectives focus around coaching judgment

if learning objectives focus around coaching judgment organizing planning and written communications can make an

  Department of a small retail company and upper management

Imagine that you are a member of the HR department of a small retail company and upper management has asked you to create a new employee customer service training class for all new employees.Write a five to six pages paper in which you:

  Small and midsized organizations have increasingly turned to

Small and midsized organizations have increasingly turned to outsourcing as a way to improve the quality of certain recruiting and hiring processes.

  Innovative idea for a new product or service

Go to the Wall Street Journal's Website and read "And the Most Innovative Entrepreneur Is...",. After reading the article, conceive an innovative idea for a new product or service. Imagine that you are going to start a business that offers that pr..

  What is a marketing plan

Explain what is a marketing plan and explain its main components giving examples.

  Strategy for negotiating a labour agreement

Formulate a strategy for negotiating a labour agreement and dealing with potential impasses in the bargaining process. Recommend policies and procedures to administer a labour contract and resolve disputes.

  Which of the following systems for planning and measuring

which of the following systems for planning and measuring the economic performance of a firm is best? the balanced

  Responsibility to successfully completing treatment goals

Reflect on a treatment plan for yourself as a drug counselor. Identify services you could use to meet your goals as a drug counselor. What is your responsibility in achieving your goal? How is this similar to your clients' responsibility to succes..

  Write down a 950 word paper in which you discuss the

write a 950 word paper in which you explain the importance of training in these areas pertaining to the organization

  Activities for a project based on the scenario

Define activities for a project based on the scenario you choose. You must include the following:

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