Perform a cash flow analysis

Assignment Help Financial Management
Reference no: EM131324350

The industry of medical devices involves a number of monitoring and reconstructive devices. Some of those devices include cardiac and diabetic care as well as hip and knee replacements. The owners of a medical device manufacturing firm called “JointsOrtho” have recently reviewed information about the expected growth of the aging population in the United States. Every day 10,000 Americans are turning age 65 every the population of older adults is expected to reach 89 million people by the year 2050. This figure is more than double the number of older adults in the United States in 2010. Orthopedic medical devices are one of the fastest growing areas in medical device manufacturing.

The owners of JointsOrtho or JO, manufacture full hip and knee replacements and would like to have your firm set up a financial plan for opening a new manufacturing plant that makes medical devices often used for Orthopedics. Specifically you will set up a plant that manufactures Full Hip Replacements in Delaware.

Each Full Hip Replacement will be sold throughout the United States at a cost of $36,750 each, including shipping, etc. Sales are expected to be between 1,000 and 1,200 hips per month. This figure is above what they are already producing in their first plant. Depreciation for equipment should be set to 10 years.

You will need to provide information to the owners of JointsOrtho that includes what it will cost to open a facility and hire workers and determine if the facility will breakeven within the first 12 months.

You will be hiring a total of 3 shift supervisors and a total of 45 employees (including shift supervisors) to do various manufacturing of the hips, clean up, shipping, etc.

The 45 workers will be paid as follows:

15 of the workers will be paid at the rate of $18/hour for 40 hours per week (molding specialists)

10 of the workers will be paid at the rate of $16/hour for 40 hours per week (machining specialists)

5 of the workers will be paid at the rate of $13/hour for 40 hours per week (cleaning and maintenance)

10 of the workers will be paid at the rate of $17/hour for 40 hours per week (shipping and receiving)

3 shift supervisors will be paid at the rate of $20/hour for 40 hours per week

1 plant manager will be paid a salary of $6,000 per month

1 administrative/human resources person at the rate of $15/hour for 40 hours per week

Transaction 1: Borrow $6,000,000.00 for building with 10 year mortgage at 10% annum

Transaction 2: Pay your salary of $6,000/month

Transaction 3: Pay for building: Set up what will be office space, manufacturing space and warehouse space. Set a depreciation schedule

Transaction 4: Hire managers & Workers. Pay salaries and fringe benefits and taxes

Transaction 5: Pay employee health, life and disability premiums, plus FICA, un-employment and withholding taxes

Transaction 6: Order $3,000,000 worth of machinery/equipment for manufacturing. Pay ½ down.

Transaction 7: Receive machines and pay remaining amount due

Transaction 8: Hire employees- Expense 1st Months’ salary/wages, set up machinery depreciation, set-up standing costs

Transaction 9: Place order for raw materials at a cost of $1,000,000 which will include Machining, Casting, Grinding, Polishing and metal injection molding materials. *Note: These raw materials will need to be ordered every 3 months.

Transaction 10: Receive 3 month supply of raw materials

Transaction 11: Start up production. Pay workers for the month

Transaction 12: Book depreciation and other manufacturing overhead costs for the month

Transaction 13: Finish manufacturing 2,000 hips and move them into finished goods inventory

Transaction 14: Pay for the 3 month supply of raw materials received in Transaction 10

Transaction15: Manufacture and months’ supply of hip replacements

Transaction 16: Take an order for 1,200 hip replacements Transaction 17: Ship and invoice customer for 1,200 hip replacements

Transaction 18: Receive payment for 1,200 hip replacements Based on the above information:

Perform a Cash Flow Analysis.

Reference no: EM131324350

Questions Cloud

How many neutrons does element : How many neutrons does element x have if it's atomic number is 42 and it's mass number is 154?
How englehardt concept of victory culture reflected in war : How has Englehardt's concept of "victory culture" been reflected in war toys, films & TV series since WWII?  (Be sure to cite specific examples from the 3 periods discussed in the book:  the peak, fall and potential revival of the "victory culture..
Differences between a recombining and non recombining tree : Discuss how a binomial model accommodates the possibility of early exercise of an option. Explain the differences between a recombining and non-recombining tree. Why is the former more desirable?
Make sure to identify all the entities and their attributes : Normalize the below Orders table to 3NF. Make sure to identify all the entities and their attributes, especially if you make any new items (such as entity or attributes).
Perform a cash flow analysis : The industry of medical devices involves a number of monitoring and reconstructive devices. Some of those devices include cardiac and diabetic care as well as hip and knee replacements. The owners of a medical device manufacturing firm called “Joints..
Brief history of the social origin of the product : For this assignment, you will select 4 fermented foods to include in a full course dinner menu. Not every dish in the menu needs to be fermented, but 4 fermented products have to be included. The menu should have an appealing design, and foods sel..
Create a windows application and add a database : Statement Create a C# Windows application (named EmployeeManagement) and add a database named EmployeeData.mdf. A button that, when clicked, sorts the data in ascending order by hourly pay rate.
Define the problem in the scenario that you have chosen : When faced with a problem, what do you do to solve it? This assignment asks you to apply a six-step to problem solving process to a specific problem scenario. You will write a paper that presents a synthesis of your ideas about solving the problem..
Book review - citizen coke : Book review in history book is "Citizen Coke" by Bartow J. Elmore. The purpose of the book review paper is to demonstrate your mastery of its material and offer the class background on the subject of your choice

Reviews

Write a Review

Financial Management Questions & Answers

  Foreign company acquisition

Acquisition by a foreign company and the effects of that decision and the results of foreign exchange in Euro and the exchange rate differences.

  Financial management for profit and non profit organizations

In this essay, we are going to discuss the issues of financial management in a non-profit organisation.

  Method for estimating a venture''s value

Evaluate venture's present value, cash and surplus cash and basic venture capital.

  Replacement analysis

This document show the Replacement Analysis of modling machine. Is replacement give profit to company or not?

  Business finance task - capital budgeting

Your company is considering using the payback period for capital-budgeting. Discuss the advantages and disadvantages of this technique.

  Analysis of the investment

In this project, you will focus on one of these: the additional cost resulting from the purchase of an apple press (a piece of equipment required to manufacture apple juice).

  Conduct a what-if analysis

Review the readings and media for this unit, including the Anthony's Orchard case study media. Familiarise yourself with the Anthony's Orchard company and its current situation.

  Determine operational expenditures

Organisations' behaviour is guided by financial data. In the short term, such data will help determine operational expenditures; in the long term, historical data may help generate forecasts aimed at determining strategic plans. In both instances.

  Personal financial management

How much will you have left over each half year if you adopt the latter course of action?

  Sources of finance for expansion into new foreign markets

A quoted company is considering several long-term sources of finance for expansion into new foreign markets.

  Long term financial planning

This assignment is designed for analyze Long term financial planning begins with the sales forecast and the key input in the long term fincial planning.

  Explain the role of fincial manager

This assignment explain the role of fincial manager, function of manger. And what are the motives of financial manager.

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