Spreadsheet Modeling and Decision Analysis: A Practical Introduction to Business Analytics
7th Edition
ISBN: 9781285418681
Author: Cliff Ragsdale
Publisher: Cengage Learning
expand_more
expand_more
format_list_bulleted
Concept explainers
Videos
Textbook Question
Chapter 3, Problem 3.1C
Kelly Jones is a financial analyst for Wolverine Manufacturing, a company that produces engine bearings for the automotive industry. Wolverine is in the process of hammering out a new labor agreement with its unionized workforce. One of the major concerns of the labor union is the funding of Wolverine’s retirement plan for its hourly employees. The union believes the company has not been contributing enough money to this fund to cover the benefits it will need to pay to retiring employees. Because of this, the union wants the company to contribute approximately $1.5 million dollars in additional money to this fund over the next 20 years. These extra contributions would begin with an extra payment of $20,000 at the end of 1 year with annual payments increasing by 12.35% per year for the next 19 years.
The union has asked the company to set up a sinking fund to cover the extra annual payments to the retirement fund. The Wolverines’ CFO and the union’s chief negotiator have agreed that AAA rated bonds recently issued by three different companies may be used to establish this fund. The following table summarizes the provisions of these bonds.
According to this table, Wolverine may buy bonds issued by AC&C for $847.88 per bond. Each AC&C bond will pay the bondholder $80 per year for the next 15 years, plus an extra payment of $1,000 (the par value) in the fifteenth year. Similar interpretations apply to the information for the IBN and MicroHard bonds. A
Wolverine’s CFO has asked Kelly to determine how much money the company would have to invest and which bonds the company should buy in order to meet the labor union’s demands.
If you were Kelly, what would you tell the CFO?
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
The Los Angeles Department of Water and Power maintains a pension plan for its employees that is funded by both employer and employee contributions. The plan pays men and women retirees’ pensions with the same monthly benefits. However, because statistically women live, on average, several years longer than men, female employees are required to make monthly contributions to the pension fund that are 14.84 percent higher than the contributions required of male employees. Because employee contributions are withheld from paychecks, a female employee takes home less pay than a male employee earning the same salary. Does this practice violate Title VII? Explain your answer.
David works for Wool garments company as a production manager. He often participates in the annual budgeting process of the company. David is requested by the Chief Executive Officer Linda to submit his department’s budgeted production for the following year. Linda reviews and typically adds 10 percent to the production budget provide by David. The new amount becomes David’s target production level for the following year. David can receive a cash bonus if his department exceeds the projected production level.
Explain any incentive that David might have to be dishonest with Linda about the production level he thinks the department can achieve.
A company plans to manufacture a product and sell it for $3.00 per unit. Equipment to manufacture the product will
cost $250,000 and will have a net salvage value of $12,000 at the end of its estimated economic life of 15 years. The
equipment can manufacture up to 2,000,000 units per year. Direct labour costs are $o.25 per unit, direct material costs
are $0.85 per unit, variable administrative and selling expenses are $0.25 per unit, and fixed overhead costs are
$200,000. What is the number of units that the company must manufacture in order to breakeven?
Chapter 3 Solutions
Spreadsheet Modeling and Decision Analysis: A Practical Introduction to Business Analytics
Ch. 3 - Prob. 1QPCh. 3 - Prob. 2QPCh. 3 - Prob. 3QPCh. 3 - Prob. 4QPCh. 3 - Prob. 5QPCh. 3 - Prob. 6QPCh. 3 - Prob. 7QPCh. 3 - Prob. 8QPCh. 3 - Prob. 9QPCh. 3 - Prob. 10QP
Ch. 3 - Prob. 11QPCh. 3 - Prob. 12QPCh. 3 - Prob. 13QPCh. 3 - Prob. 14QPCh. 3 - Prob. 15QPCh. 3 - Prob. 16QPCh. 3 - Tuckered Outfitters plans to market a custom brand...Ch. 3 - Prob. 18QPCh. 3 - Prob. 19QPCh. 3 - Prob. 20QPCh. 3 - Prob. 21QPCh. 3 - Prob. 22QPCh. 3 - Prob. 23QPCh. 3 - Prob. 24QPCh. 3 - Prob. 25QPCh. 3 - A manufacturer of prefabricated homes has decided...Ch. 3 - Prob. 27QPCh. 3 - Prob. 28QPCh. 3 - Prob. 29QPCh. 3 - Prob. 30QPCh. 3 - Prob. 31QPCh. 3 - Prob. 32QPCh. 3 - Prob. 33QPCh. 3 - Prob. 34QPCh. 3 - Prob. 35QPCh. 3 - Prob. 36QPCh. 3 - Prob. 37QPCh. 3 - Prob. 38QPCh. 3 - Prob. 39QPCh. 3 - Prob. 40QPCh. 3 - Prob. 41QPCh. 3 - Prob. 42QPCh. 3 - Prob. 43QPCh. 3 - A natural gas trading company wants to develop an...Ch. 3 - Prob. 45QPCh. 3 - Prob. 46QPCh. 3 - The CFO for Eagle Beach Wear and Gift Shop is in...Ch. 3 - Prob. 48QPCh. 3 - Prob. 1.1CCh. 3 - Prob. 1.2CCh. 3 - Prob. 1.3CCh. 3 - Prob. 1.4CCh. 3 - Prob. 2.1CCh. 3 - Prob. 2.2CCh. 3 - Prob. 2.3CCh. 3 - Prob. 2.4CCh. 3 - Prob. 2.5CCh. 3 - Kelly Jones is a financial analyst for Wolverine...
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, management and related others by exploring similar questions and additional content below.Similar questions
- Lu is 26 years old and single with a master's degree in education. he is paralyzed and confined to a wheel chair as a result of an auto accident. he earns $32,000 per year. instead of the tradition "one benefit package fits all," the company is allocating an additional 25 percent of each employee's annual pay to be used for discretionary benefits. those benefits and their annual cost are as follows: a) supplementary health care for employee: plan A (no deductible and pays 90 percent) =$3000, plan B ($200 deductible and pays 80 percent)=$2000, plan C ($1000 deductible and pays 70 percent)=$500, s supplementary health care for dependents (same deductibles and percentages as above): plan A=$2000, Plan B=$1500, plan C=$500, supplementary dental plan =$500, life insurance: plan A ($25000 coverage)=$500, plan B (50,000 coverage)= $1000, plan C(100,000 coverage) =$2000, plan D ($250000 coverage)= $3000 mental health plan =$500, prepaid legal assistance =$300, vacation =2 percent of annual pay…arrow_forwardConsolidated Energy (CE) is a public utility company that generates and distributes electricity throughout a large portion of the US. The company is involved in all kinds of projects, including construction of new electrical generating and transmission equipment and facilities, upgrade and repair of existing equipment and facilities, information technology for customer service, and energy research projects. Much of this project work is contracted out, although CE units handle about half of it with internal expertise in construction, equipment upgrade and maintenance, information technology, and research. The company has construction units and equipment specialists in five cities, information technology specialists in three cities, and research units in two cities.The research units work on projects initiated by the corporate office, but the construction, equipment upgrade and maintenance, and IT units work on projects initiated by the five regional offices. Each of the units is assigned to…arrow_forwardNicole, an athletic trainer, believes if she has evidence that her program of exercise works, she can recruit more clients. She is planning to conduct a study to determine if working out for one hour per day with her fitness program causes a person to lose weight. She will track the participants’ progress over a twelve-week period. Nicole mandates that her clients at the gym participate in her study, and she asks them to each find one friend who is not a member of the gym to also participate. Each of the participants weighs in at the start and again after the twelve-week period has ended. At the conclusion of the study, she will compare the results of both groups. Unfortunately, because she has not had any formal training in research methodology, she is not certain how to label the different components in her study or identify any potential flaws. Help Nicole with the following components of this study Identify the following factors. Independent Variable Operational Definition of…arrow_forward
- Nicole, an athletic trainer, believes if she has evidence that her program of exercise works, she can recruit more clients. She is planning to conduct a study to determine if working out for one hour per day with her fitness program causes a person to lose weight. She will track the participants’ progress over a twelve-week period. Nicole mandates that her clients at the gym participate in her study, and she asks them to each find one friend who is not a member of the gym to also participate. Each of the participants weighs in at the start and again after the twelve-week period has ended. At the conclusion of the study, she will compare the results of both groups. Unfortunately, because she has not had any formal training in research methodology, she is not certain how to label the different components in her study or identify any potential flaws. Help Nicole with the following components of this study. Identify the following issues with the study described. Ethical Concerns…arrow_forwardIn 2007 San Francisco began its Healthy San Francisco Plan designed to provide health care for all San Francisco citizens. In 2007, it was estimated that San Francisco had 82,000 uninsured citizens. Under the plan, all uninsured citizens residing in San Francisco can seek care at the city's public and private clinics and hospitals. The basic coverage includes lab work, x-rays, surgery, and preventative care. The city plans to pay for this $203 million coverage by rerouting the $104 million the city currently spends treating the uninsured in the emergency rooms, mandating business contributions, and requiring income-adjusted enrollment fees. The plan requires all businesses with more than 20 employees to contribute a percentage toward the plan. Many business owners consider this a burden and warn they will not stay in the city. The Mayor sees universal health access as a moral obligation for the city. Take one of the following positions. San Francisco has an obligation to provide its…arrow_forwardMcGwire Aerospace expects to have net cash flow of $12 million. The company forecasts that its operating costs excluding depreciation and amortization will equal 75 percent of the company’s sales. Depreciation and amortization expenses are expected to be $5 million and the company has no interest expense. All of McGwire’s sales will be collected in cash, costs other than depreciation and amortization will be paid in cash during the year, and the company’s tax rate is 40 percent. What is the company’s expected sales?arrow_forward
- Sapphire Farm is a business that trains and boards horses and educates young riders about horse care, nutrition, and riding. The farm provides both a learning and a fun environment for young equestrians and their families. It also hosts horse shows for beginning riders to help them build confidence in the show ring and to prepare them for local horse shows by running shows in accordance with the rules and regulations of the National Hunter Jumper Association. Feedback from the horseshow judges are provided to all riders so they can do better at their next meet. In addition, all warm-up and training areas are fenced and monitored by adults for the children's safety. If the farm unintentionally hired someone to teach riding who was unable to deal effectively with small children, then a _____ would occur. A. service divergence B. quality underperformance C. performance breakdown D. product variation E. customer aberrationarrow_forwardSE STUDY John is a finance director of Nadim Product PLC, a company which manufactures and sells bathroom product such as baths, sinks and toilet. These product are sold through a selection of specialist shops and through larger store, customers include professional plumbers and also ordinary householder who are renovating their houses themselves. The company operates at the lower end of the market and does not have a strong reputation for service. Sales have been slowly declining whereas those of competitors have been improving. In order to encourage increased sales the board of directors has decided to pay senior staff a bonus if certain target is achieved. The two main targets are based on profit levels and annual sales. Two months before the end of the financial year the finance director asks one of his staff to check through the order and account to assess the current situation. He informed that without a sudden improvement in sales before the year end the important sales target…arrow_forwardMTE is a robotics firm that has clients all over the world but is based in the U.S., with offices in most major cities. Recently MTE has been experiencing an upsurge in discrimination lawsuits by women and minorities since they grew from 2,000 employees in 2016 to have 3,500 employees by the third quarter of 2019. A demand for their technology services exploded with the expansion of some of their clients’ high-technology needs in the medical industry. There are currently 3,000 employees in the Northeastern U.S., and 500 employees in other countries. The lawsuits claim that women and minorities are not being hired in equitable numbers due to a discriminatory hiring system. MTE has an automated hiring system on its hiring website. Applicants first submit their resumes, which are scanned for certain educational requirements (including top 10 university degrees) and key phrases. Then those applicants that pass the initial screening take an online technology test that is timed to see how…arrow_forward
- Laura is the associate director of a nonprofit agency that aids children and families. She is the head of a department that focuses on evaluating the skill-building programs the agency provides to families. She reports directly to the agency leadership. Overall, the agency has been cautious in hiring this year because of increased competition for federal grant funding. However, they have also suffered high staff turnover. Two directors, three key research staff, and one staff person from the finance department have left. Laura has a demanding schedule that requires frequent travel; however, she supervises two managers who in turn are responsible for five staff members each. Both managers have been appointed within the last six months. Manager 1: Kelly has a specific background in research. She manages staff who provide research support to another department that delivers behavioral health services to youth. Kelly supports her staff and is very organized; however, she often takes a very…arrow_forwardThe following information was gathered by the Budget Committee Chairman of ABC Corporation: ABC Co. produces and sells only one product. The selling price during the budget period is expected to be the prevailing price of ₱7.50 per unit. The company expects to sell 112,500 units of the product during the period. The desired finished goods inventory at the end of the period is 75,000 units while the expected beginning inventory is 62,500 units. Direct labor is ₱4.50 per hour. Each product requires 30 minutes to complete. Factory overhead is applied to production on the basis of direct labor hours. Variable factory overhead cost at the planned level of operations is budgeted at ₱49,800. Fixed budgeted overhead is ₱149,400. Each unit of product requires 1.5 kgs. of raw materials. Only one kind of raw material is used and it is expected to cost ₱0.30 per kilo. The desired ending inventory of raw materials is 12,000 kgs. the expected beginning inventory is 9,500 kilograms. Variable selling…arrow_forwardEthics and Professional Conduct in Business At the end of the current month, Jonni Rembert prepared a trial balance for Star Rescue Service. The credit side of the trial balance exceeds the debit side by a significant amount. Jonni has decided to add the difference to the balance of the miscellaneous expense account in order to complete the preparation of the current month's financial statements by a 5 o'clock deadline. Jonni will look for the difference next week when she has more time. Discuss whether Jonni is behaving professionally.arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
Practical Management ScienceOperations ManagementISBN:9781337406659Author:WINSTON, Wayne L.Publisher:Cengage,
Practical Management Science
Operations Management
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:Cengage,
Single Exponential Smoothing & Weighted Moving Average Time Series Forecasting; Author: Matt Macarty;https://www.youtube.com/watch?v=IjETktmL4Kg;License: Standard YouTube License, CC-BY
Introduction to Forecasting - with Examples; Author: Dr. Bharatendra Rai;https://www.youtube.com/watch?v=98K7AG32qv8;License: Standard Youtube License