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 9 months:
March $100,000
April $275,000
May $320,000
June $450,000
July $700,000
August $700,000
September $825,000
October $500,000
November $115,000
He has also gathered the following collection estimates regarding the forecast sales:
Payment collection within the month of sale = 25%
Payment collection the month following sales = 55%
Payment collection the second month following sales = 20%
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 $187,500
April $206,250
May $375,000
June $337,500
July $431,250
August $640,000
September $395,000
October $425,000
Additional financial information is as follows:
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.
please show all work, including formulas and calculations used to arrive at the financial values.
******prepare a monthly cash budget for Cyrus Brown Manufacturing for the 9-month period of March through November. Use Excel to prepare the monthly cash budget.
Related posts:
- To make sure you are up to date on the special guidelines the GASB has declared, your manager asked you to research GASB Statement No. 56. He also asked you to show him, side by side, how government accounting journal entries might differ from for-profit journal entries in these similar events. Write 500–750 words that addresses the following: When was GASB Statement No. 56 initiated? In your own words, what is the essence of the new ruling? Why did the GASB probably deem it as being necessary? How might GASB Statement No. 56 change the activities of any accountant performing governmental accounting? Create journal entries for all of the following situations. On 10/1/2010, a for-profit Company A provides $100,000 of service to Company B. Company B plans to pay their bill 90 days later. Create the journal entry when the service is provided. Create the journal entry when the cash is received. On 12/1/2010, the city's recreation department receives a government grant of $100,000 specifically to use for next year's park upgrades, which will begin on 1/1/2011. Create the journal entry made when the cash is received. Create the journal entry to be made on 1/1/2011. A for-profit retail store buys $200,000 of inventory on 9/1/2010. Create the proper journal entry to show purchase of this inventory. A local city park buys $200,000 of food merchandise for later resale. It uses the purchase method to account for inventory. Create the proper journal entry for when this purchase is made. A nonprofit organization receives a $250,000 donation on 12/1/2011, but the donor specifically wants it spent in 2012. Create the journal entry or entries to show the proper recording of revenue (this may require more than on journal entry). Create the subsequent journal entry to show spending of the funds.
- Budget Legislation Once the budget has been prepared by the various agencies, it is often moved forward to the legislative body for authorization. The legislation process can result in unintended outcomes and restrictions. Search the internet and news reporting services for a story on an unintended outcome of interest to you and answer the following questions: How did politics shape the outcome in unexpected ways? Did “pork” spending or “apportionments and allotments” budget amendments affect the legislation? Did a mid-year crisis or change in revenue expectations substantially impact the budget legislative action? Performance Budgeting Performance budgeting has been attempted at the local level in recent years. Address the issues of performance budgeting while answering the following questions: What attributes of performance budgeting make it particularly suitable to local government budgeting? Will the same attributes be as useful at the federal level? Respond to at least two of your classmates’ postings.
- Write a 1,050- to 1,400-word strategic objectives summary. Include your balanced scorecard and its impact on all stakeholders, and the communication plan. Identify key trends, assumptions, and risks in the context of your final business model. Develop the strategic objectives for your new division of the existing business in a balanced scorecard format in the context of key trends, assumptions, and risks. The strategic objectives are measures of attaining your vision and mission. As you develop them, consider the vision, mission, and values for your business and the outcomes of your SWOT analysis and supply chain analysis. Consider the following four quadrants of the balanced scorecard when developing your strategic objectives: Shareholder Value or Financial Perspective, which includes strategic objectives in areas such as: Market share Revenues and costs Profitability Competitive position Customer Value Perspective, which includes strategic objectives in areas such as: Customer retention or turnover Customer satisfaction Customer value Process or Internal Operations Perspective, which includes strategic objectives in areas such as: Measure of process performance Productivity or productivity improvement Operations metrics Impact of change on the organization Learning and Growth (Employee) Perspective, which includes strategic objectives in areas such as: Employee satisfaction Employee turnover or retention Level of organizational capability Nature of organizational culture or climate Technological innovation Evaluate potential alternatives to the issues and/or opportunities identified in the SWOT Analysis paper and table you completed in Week 3. Create at least three strategic objectives for each of the four balanced scorecard areas. Base your solutions on a ranking of alternative solutions that includes the following: Identify potential risks and mitigation plans Analyze a stakeholder and include mitigation and contingency strategies. Incorporate ethical implications Develop a metric and target for each strategic objective using a balanced scorecard format. Example: a strategic objective in the shareholder or financial perspective is to increase market share. A metric to actually measure this strategic objective of market share increase is, "The percentage of increase in market share." The target is the specific number to be achieved in a particular time period. The target for the metric of "Increase market share" could be "Increase market share by 2% for each of the next 3 years" of an increase of 2% per year for 3 years.) Outline a brief communication plan discussing how you will communicate the company's strategic objectives that includes the following: Define the purpose. Define the audience. Identify the channel(s) of communication and why you selected that channel. Format paper consistent with APA guidelines. Attachments Screen Shot 2016-04-05 at 9.17.03 PM.png Screen Shot 2016-04-05 at 9.17.08 PM.png
- You are a state court judge. You have a first time offender in your court. His charge is armed robbery but he tells you his reason for the robbery was to support his drug addiction. He also tells you that he got involved with drugs while he was hanging out with his friends. He has waived his right to a jury trial and has asked you to decide the case and grant him treatment rather than prison time
- There are two (2) very different target markets and sales forces discussed in the videos. Identify some of the key differences between the organizations’ sales forces and target markets. Explain the value of developing a sales force based on the target market. Use examples from each video to support your response
- Antitrust laws were essentially created to stop businesses that got too large from blocking competition and abusing their power. Mergers and monopolies can limit the choices offered to consumers because smaller businesses are not usually able to compete. Although free and open competition ensures lower prices and new and better products, it has the potential to significantly limit market diversity. Look at the 2 examples below of how mergers and acquisitions have affected the way in which companies do business. Read each of the 2 examples below. Prepare a APA formatted research paper that responds to the aligned questions. Specifically, your paper must: Identify the two firms with similar problems from different countries Conduct a comparative analysis of the firms Analyze political, social, ethical and legal differences and their impact on management decision making Provide substantive conclusion and recommendations Submitting your assignment in APA format means, at a minimum, you will need the following: TITLE PAGE. Remember the Running head: AND TITLE IN ALL CAPITALS ABSTRACT. A summary of your paper…not an introduction. Begin writing in third person voice. BODY. The body of your paper begins on the page following the title page and abstract page and must be double-spaced (be careful not to triple- or quadruple-space between paragraphs). The type face should be 12-pt. Times Roman or 12-pt. Courier in regular black type. Do not use color, bold type, or italics except as required for APA level headings and references. The deliverable length of the body of your paper for this assignment is 4-5 pages. In-body academic citations to support your decisions and analysis are required. A variety of academic sources is encouraged. REFERENCE PAGE. References that align with your in-body academic sources are listed on the final page of your paper. The references must be in APA format using appropriate spacing, hang indention, italics, and upper and lower case usage as appropriate for the type of resource used. Remember, the Reference Page is not a bibliography but a further listing of the abbreviated in-body citations used in the paper. Every referenced item must have a corresponding in-body citation. Example 1 Federal antitrust enforcers are investigating whether a multinational pharmaceutical company has attempted to minimize the impact of generic competition to one of its most profitable prescription drugs. This anti-depressant drug is the company's best seller, with sales last year of $2.11 billion, representing a 22% increase from the year before. The Federal Trade Commission (FTC) is conducting an investigation to determine whether the company has engaged in activities to prevent generic alternatives to the prescription drug from entering the market. Specifically, the FTC is challenging a practice among brand-name and generic-drug manufacturers to agree to delay the introduction of the lower priced generic drugs to the market. Answer the following questions: Why would the drug maker want to stymie generic competition? Explain. What types of legal barriers to market entry exist? What are the possible ethical dilemmas present in this example? Example 2 The boards of 2 major telecommunications companies recently agreed to a $16 billion-dollar merger that would create the world's largest telecommunications company in the world. Although some agree that the synergy between these companies could be dynamic, others feel consumers could ultimately pay the price for the merger depending on which company becomes dominant in the various service areas. Answer the following questions: Why do you think consumer advocates have expressed concern over such merger possibilities? Other than pricing, what are some pitfalls that consumers might have to deal with when 2 major companies merge? What are the possible ethical dilemmas present in this example?
- You are the Budget Director for Alamo Hospice a mid-size hospice organization. You will develop a comprehensive budget and create the associated performance story for Next Year that describes the results the organization is planning to produce.
- ROLE OF CONTROLLER: Juanita Veracruz, newly hired controller of Braxton Industries, had been lured away from a competitor to revitalize the controller’s department. Her first day on the job proved to be an eye-opener. One of her first interviews was with Adrian Belton, production supervisor in the Cleveland factory. Belton commented, “I really don’t want to talk to anyone from the controller’s office. The only time we see those accountants is when our costs go over their budget. They wave what they call a ‘performance report,’ but it’s actually just a bunch of numbers they make up. It has nothing to do with what happens on the shop floor. Besides, my men can’t afford the time to fill out all the paperwork those accountants want, so I just plug in some numbers and send it back. Now, if you’ll let me get back to important matters.…” Veracruz left quickly, but she was already planning for her next visit with Belton. 1. Identify some of the problems in the relationship between the controller’s department and the production departments (assuming that the Cleveland factory is representative of the production departments). 2. What should Juanita Veracruz do next?
- In Week One of this course, you were asked to find a child to observe. For this assignment, you will observe the child using the requirements below and summarize your observation. This can be done in one sitting, or it can be done in two since you will be conducting two different observations. Two is preferable for accuracy of assessment. For the observation you will need to: Be sure you have the permission of the child’s parent. Exclude any identifying information for this child (e.g., last name) Follow the guidelines on pages 141-144 of the course text regarding behaviors during the visit (ethical conduct, avoiding personal bias, etc.). Be sure you have the appropriate materials ready: You will need either a Running Record Form or an Anectodal Record Form, whichever you choose. For this form, you will choose one developmental domain to observe (e.g., cognitive, physical, motor, or language). You will need either a Time Sampling Form or an Event Sampling Form, whichever you choose. For this form, you will choose one developmental domain to observe (e.g., cognitive, physical, motor, or language). Example: Assessing “Bobby,” I would first observe his motor development using an anecdotal record form. In a different sitting, I would observe his cognitive development using an event sampling form. For the assignment, you will need to include: A title page. A copy of the completed Running Record Form or Anecdotal Record Form (remember this should address one domain). A copy of the completed Time-Sampling Form or Event Sampling Form (this should address a different domain). A one page summary of the observation(s). In this summary, include: How you felt the observation went and why. How receptive you feel the child was and why you feel that way (if using one of the video options state the reaction of the child upon being videotaped as you see it). The most challenging aspect of this observation. The most enjoyable aspect of this observation. What you learned from this experience. What you would change next time. A one-page paper providing some developmentally appropriate activities you might implement for this child in the classroom or daycare center to foster growth in each of the developmental domains you observed, and why those activities are a good fit for this child. Your two-page paper should be in proper 6th edition APA format. Remember to submit two written pages, both observation forms, and your title page in one document. Carefully review the Grading Rubric for the criteria that will be used to evaluate your assignment.
- Assignment 2 LASA 1 (Genesis Cash Budget Report)