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

  What types of problems was the consolidated city-county

1. what types of problems was the consolidated city-county government of denver colorado experiencing with document

  Use of a new predictor

The base rate is high, the selection ratio is low, and the validity coefficient is high for the current predictor. What would you advise your boss and why?

  Descriptions of effective teaching strategies

A curriculum guide is a packet of practical ideas for teaching that is written in a convenient format as practical teaching notes for use in the future by either you or your colleagues. It is a how-to guide that covers steps for achieving specific..

  Conflict identification and resolution

We live in a very complex and culturally diverse society. When we bring individuals together from diverse backgrounds in a work environment conflict can arise when expectations are not realized or met. Rather than hoping conflict will go away, thi..

  Calculate business profits for the past year

Nigel has gathered together his costs and revenues and is about to calculate his business's profits for the past year. Nigel thinks that if his business has made a loss over the year the answer is easy: increase the price of a jar of his honey. If..

  Sales management your response should be at least 350 words

your response should be at least 350 words in length. please use my course book only all sources used including the

  Show radical changes in hrm

Discuss that technological breakthrough has brought a radical changes in HRM - Cost cutting efforts have led to the decimation of unwanted layers in organizational hierarchy in recent times.

  Prepare the executive summary

As the leader of this project for human resources, you will be required to prepare the executive summary that will include the following information:

  How do you use the internet to support negotiations

How do you use the Internet to support negotiations? What are the advantages and disadvantages of e-negotiations? Write 300 words and references.

  What are challenges that multi-national corporations

What are challenges that multi-national corporations pose to unions and Why do some foreign countries present greater roadblocks to "one big global union" than others, explain?

  Discharges at the anderson cost club storeassuming that i

discharges at the anderson cost club storeassuming that i am the assistant manager my role is to deal with hr issues

  Discuss the types of teams that an organization might use

write 400-600 words that respond to the following questions with your thoughts ideas and comments. this will be the

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