Reference no: EM1360008
Peter, a president of a company produces power transformers for personal computer manufacturers. Peter's choice of the various methods by which a new model of transformer can be built has been narrowed to 3 choices. He estimates the product life of the transformer to be one year. Marketing has estimated that it can sell 5,000 of these new transformers within the time period. The 3 alternatives are:
1. Use existing equipment and fixtures, and hire high -skilled machinists and technicians at $16.00 per hour (including benefits). With this method, each transformer will require 2 labor hours to assemble.
2. Use existing equipment, but invest $30,000 in new fixtures and instruction manuals to simplify some of the more complicated operations. Semiskilled workers can be employed at $12.00 per hour (including benefits), with each transformer requiring 1 labor hour to complete.
3. Invest $75,000 in new equipment, fixtures, and instruction manuals. This approach would eliminate all of the complicated procedures, thereby requiring only unskilled labor, which could be hired for $6.00 an hour (including benefits). With this method, each transformer would require 20 labor minutes to complete.
These are the questions that I am completely lost on. I have to do this in Excel.
A. Make a break-even chart using total cost versus volume for the above processes.
B. Calculate the 2 break-even volumes (i.e., those volumes at which you shift from one process to another).
C. Which alternatives would choose and why?
|
Explain how a bill become a law in order
: Explain how a bill become a law in order.the bill goes back to the floor of the senate for consideration. the house committee, compairised of members from both houses of congress,works outany differences concerning the bill.
|
|
Social discount rate
: The second discount rate is known as the social discount rate. It is based on judgments about the collective value that society attaches to a policy. Proponents argue that the social discount rate is preferred because it broadens the preferences cons..
|
|
Find the magnitude and direction of the acceleration
: Find the magnitude and direction of the acceleration. A 2.60 kg steel ball strikes a wall with a speed of 10.0 m/s at an angle of 60.0° with the surface. It bounces off with the same speed and angle. If the ball is in contact with the wall for 0.19..
|
|
Qualitative and quantitative data collection
: Explain the advantages and disadvantages of the various methods of data collection- Qualitative and Quantitative Data Collection
|
|
Make a break-even chart using total cost versus volume
: Peter, a president of a company produces power transformers for personal computer manufacturers. Peter's choice of the various methods by which a new model of transformer can be built has been narrowed to 3 alternatives.
|
|
Ways of implementing one-to-one relationships
: Describe the difference ways of implementing one-to-one relationships. Assume you are maintaining information on offices (office numbers, building, and phone numbers)
|
|
Why should john and karl live together
: Why should John and Karl live together. If they do, will there be dirty dishes in the sink. Explain
|
|
What is drucker saying with this quote
: What is Drucker saying with this quote and Do you agree or disagree? Does business really have other societal obligations besides making a profit?
|
|
How weight represents the amount of raw materials
: How weight represents the amount of raw materials. Data containing the weight in pounds from a sample of 368 pallets of Bridgetown shingles and 330 pallets of Holetown shingles are contained in Pallet data which can be downloaded from the class web..
|