Operational Analysis

MMWC buys the equipment to expand their services. Present a recommendation supporting the type of financial impact the expansion of services will have on MMWC.

Clearly label the calculation of the impact of food costs and the financial impact costs. Use formulas to calculate the costs and format the cells to insert a comma if there is more than three numbers and round to the nearest whole number.

two-to-three page Word document (not including title and reference pages) and your Excel worksheet. Paper should be formatted according to APA style. Cite at least two scholarly sources in addition to the textbook.

Case study

The Mead Meals on Wheels Center (MMWC) provides meals every day to the homebound elderly. The city of Wabash pays MMWC \$32 per week for each person it serves. There is no shortage of demand for MMWC’s services among the elderly citizens of Wabash, and MMWC can find qualified recipients for as many meals as it can deliver. Each person helped by MMWC receives two hot emails per day, seven days per week, for a total of 14 meals every week.

To service the contract, MMWCs has a central kitchen that has the capacity to produce a maximum of 9,600 meals per day. It costs MMWC an average of \$36,000 per week to operate the kitchen and other central facilities regardless of the number of meals that MMWC serves. This covers all of WWWC’s fixed costs (e.g., rent, equipment costs, and its personnel including administrative staff) as well as its fixed seasonal service contract costs (utilities, snow removal, etc.)

Question 1: the executive director has come to you to calculate how much MMWC can spend per week, per person and still break even. What do you tell the executive director?

Using your work to define MMWC’s spending limit, the executive director prepared a request for bids and sent it to all of the food purveyors in and near Wabash. The best bid came in at \$.50 (fifty cents) below the number the number that you have calculated as MMWC’s break-even per person-week. Using the lowest bid and the information given earlier, the executive director wants you to prepare a budget for MMWC’s in a format that will allow her to monitor MMWC’s performance on a quarterly basis for the coming year.

For budgeting purposes, the executive director has told you to assume that there are 13 weeks in each quarter. You know for your experience that the fixed expenses for the organization vary by season. Fixed costs average \$38,000 per week in the winger (first quarter), \$34,000 per week in the second quarter, \$35,000 in the third quarter, and \$37,000 in the fourth quarter.

Question 2: Prepare a budget for the next four quarters of operation for the executive director and summarize it for the full year.

The first quarter of operation was in the midst of a very severe winter. As a result MMWC was only able to get food to, 4,600 people per week on average. In addition, the cold weather and snow caused MMWC to exceed the limits of its snowplowing and heating oil contracts. As a result, MMWC’s fixed costs were \$2,000 per week above what you had forecast. Luckily, a food purveyor from outside the Wabash city limits responded to MMWC’s request for bids just before the quarter began and gave MMWC a bid that was \$.75 (seventy-five cents) per person-week below the quote that was used in your budget. That is a full \$1.25 below the break-even level that you calculated.

The executive director knows that something has happened because the budgeted numbers and the actual results that she sees on her quarterly operating statement don’t match. She wants you to tell her why.

Question 3. Prepare an analysis of variances for the first quarter of the year to help her understand what caused the differences between the results. Provide her with as much detail as you can give the available information, that is, volume variance, price variance, and quantity variance. Be sure to indicate whether those variances were favorable or unfavorable. Don’t forget to look at the fixed-cost variance as well.

1. Prepare a revenue variance analysis.
2. Prepare a food expense variance analysis.
3. Calculate the net impact of the severe winter weather and lower food prices on MMWC’s first quarter result. Was MMWC better off or worse off?
4. Was the overall aggregate variance large enough to have a significant impact on MMWC during the first quarter? Is it significant when compared to projected annual profits or losses?

During the year, you conducted an analysis of MMWC’s kitchen operations and determined that you could increase the capacity of the kitchen to 10,400 meals per day. You see a chance to increase the number of meals that MMWC can deliver to the elderly, as well as a way to increase your weekly revenue. However, expanding the kitchen’s capacity will require you to purchase \$700,000 worth of equipment. The equipment has a useful life of five years. The executive director is interested in any idea that will expand service delivery. But, she is concerned about being able to pay for the equipment. She tells you that MMWC’s cost of capital is 9 percent and asks if MMWC should purchase the equipment.

Question 4: What do you tell her? Support your recommendation and present your findings in a way that the executive director will understand?

1. Assuming that you pay your suppliers quarterly and that you are paid by Wabash quarterly, what would you recommend doing?
2. Would you answer be different if you were paid by Wabash and pay your suppliers weekly? Annually?

You finish your capital budget analysis just in time to prepare the operating budget for the coming year. The executive director wants you to use last year’s budget as a starting point but to update it to reflect the higher fixed costs that occurred during this year’s winter operations (i.e. the first quarter). In addition, she has decided to accept your recommendation about the equipment. If you decide to go ahead with the purchase, a local bank will lend WC the full purchase price of the equipment and only charge MMWC for interest during the first year of the loan. Interest on the loan would be set at 8 percent per year. MMWC’s normal policy is to assume a 10 percent residual value on all kitchen equipment and to depreciate it over five years on a straight-line basis.

Question 5: Incorporating all of the things that have happened during the year, as well as your capital budgeting recommendation, prepare a new quarterly budget and an annual summary for MMWC for the coming year.

Question 6: Given the profits that MMWC expects to produce in the next fiscal year, should it expand and feed ore people? Why has it chosen not to feed more than 5,200 people? What would be required to expand MMWC beyond its current level of operations?

# Review the team report on MPBS located in the Case Study Overview. In this assignment you are expected to recommend the most appropriate method of job evaluation to use at MPBS and support your recommendations with your rationale. Your recommendation should consider the organization’s comprehensive job structure with major occupational groups including scientific, administrative, sales, management, and technical. Your rationale must be backed up with support from the text and/or other articles you may have researched. Your recommendations must cover the following: Describe your recommended approach and the expected impact of that approach on job performance. Address key HR and compensation issues identified at MPBS. Differentiate the components that would need to be included if MPBS were to use a point-based method as compared to a ranking and to a classification method. Provide a list of compensable factors for a point-based method and the factor weights you would suggest if using that method. Explain how your recommended method of job evaluation aligns with MPBS’s strategic focus. Describe the key challenges to effective implementation of the recommended approach to job evaluation at MPBS. To complete this assignment, write a 3–5 page report in Word format and provide rationale and support. Apply APA standards for writing style to your work.

Review the team report on MPBS located in the Case Study Overview.

In this assignment you are expected to recommend the most appropriate method of job evaluation to use at MPBS and support your recommendations with your rationale. Your recommendation should consider the organization’s comprehensive job structure with major occupational groups including scientific, administrative, sales, management, and technical. Your rationale must be backed up with support from the text and/or other articles you may have researched.

Your recommendations must cover the following:

• Describe your recommended approach and the expected impact of that approach on job performance.   Address key HR and compensation issues identified at MPBS.
• Differentiate the components that would need to be included if MPBS were to use a point-based method as compared to a ranking and to a classification method.
• Provide a list of compensable factors for a point-based method and the factor weights you would suggest if using that method.
• Explain how your recommended method of job evaluation aligns with MPBS’s strategic focus.
• Describe the key challenges to effective implementation of the recommended approach to job evaluation at MPBS.

To complete this assignment, write a 3–5 page report in Word format and provide rationale and support.   Apply APA standards for writing style to your work.

Volume, Risk, and Price Variances

Analyze the variances in the following scenario:

You are the nursing administrator for a medical group that expects a severe outbreak of the flu this winter.  You hire additional staff to treat the patients and administer shots.  Your special project budget was for 1,000 hours of part-time nurses’ services at \$40 per hour, for a total cost of \$40,000.  It was expected that these nurses would administer 400 flu shots and treat 1,600 flu patients.  The medical group typically charges \$50 for a flu shot and \$80 for treating a flu patient. Actually, the group had 1,200 patients who received the flu shot and 1,400 who had the flu and received treatment.  On average, it was able to collect \$55 per flu shot and \$70 per flu patient.

Compute the volume, mix, and price revenue variances.  How did things turn out for the group considering just revenues?  How did they turn out from a profit perspective? Use the approach from chapter 8 to solve.  Clearly label the calculations of the required variances using Excel.  Use formulas to calculate the three variances and format the cells to insert a comma if there is more than three numbers and round to the nearest whole number.  Explain the meaning of the variances in a two page Word document.

Submit to your instructor your two-to-three page Word document (not including the title and reference pages) and your Excel worksheet. Your paper should be formatted according to APA style, and you must cite at least three scholarly sources.

Part 1 (900 words Portion of Paper)

The President of EEC recently called a meeting to announce that one of the firm’s largest suppliers of component parts has approached EEC about a possible purchase of the supplier. The President has requested that you and your staff analyze the feasibility of acquiring this supplier. Discuss the following:

• What information will you and your staff need to analyze this investment opportunity?
• What will be your decision-making process? Discuss and evaluate the different techniques that could be used in capital budgeting decisions.
• Specifically, discuss how the time value of money affects capital budgeting. Capital budgeting differs from regular budgeting in that capital budgeting is for large investment decisions like plant expansion. The regular budgeting is for your day-to-day operations decisions.
• Which do you think EEC should use? Why?

Part 2 (Excel Sheet and Second Part of Paper (900 words)

Based on the following information, calculate net present value (NPV), internal rate of return (IRR), and payback for the investment opportunity: (EXCEL SHEET)

• EEC expects to save \$500,000 per year for the next 10 years by purchasing the supplier.
• EEC’s cost of capital is 14%.
• EEC believes it can purchase the supplier for \$2 million.

• Based on your calculations, should EEC acquire the supplier? Why or why not?
• Which of the techniques (NPV, IRR, or payback period) is the most useful tool to use? Why?
• Which of the techniques (NPV, IRR, or payback period) is the least useful tool to use? Why?
• Would your answer be the same if EEC’s cost of capital were 25%? Why or why not?
• Would your answer be the same if EEC did not save \$500,000 per year as anticipated?
• What would be the least amount of savings that would make this investment attractive to EEC?
• Given this scenario, what is the most EEC would be willing to pay for the supplier?

Prepare a memo to the President of EEC that details your findings and shows the effects if any of the following situations are true: (INCLUDE MEMO IN PAPER!)

• EEC’s cost of capital increases.
• The expected savings are less than \$500,000 per year.
• EEC must pay more than \$2 million for the supplier.

Assignment 2: LASA – Project Planning – Developing the Project Plan and Determining Critical Path

1. Using the District4WarehouseMove WBS.xls provided, create a project plan for the District 4 Warehouse Move project. Use the PDF document, Project Plan Check – District4Move, to check your work to be sure you have created your starting project plan correctly. ProjectLibre is required for this task. If you have not yet downloaded ProjectLibre, please click here and follow the directions to do so now.

Note: you will need to insert a column to include your WBS codes, then you will need to sequence the tasks to show tasks by work package.

1. Based upon the details in the WBS and the project case, determine which tasks need to be completed first and which tasks are dependent upon other tasks to be completed prior to starting. Using this information identify predecessors in your project plan’s predecessor column. Complete the predecessor column by entering the line number of tasks that must be completed in order for each task to start. This will create your project timeline.

1. Using ProjectLibre’s Network or flow diagram view, determine the critical path for this project. In a MS Word document, list the activities that are on the critical path. Considering the risks identified in the risk table below, identify which risks would be most likely to increase your project timeline. Justify your responses.
2. Submit both your completed project plan and your MS Word document.

District 4 Production Warehouse Move Project – Risk Table

# 1- What are the major issues surrounding access to healthcare in America today and what can be done to fix the problem? 2-can a low-income person receive access to high-quality care? Research the Patient Protection and Affordable Care Act (Obamacare). How does this new law impact such access?

1- What are the major issues surrounding access to healthcare in America today and what can be done to fix the problem? 2-can a low-income person receive access to high-quality care? Research the Patient Protection and Affordable Care Act (Obamacare). How does this new law impact such access?

# 850 word paper answering the following questions: 1.Considering that Hinduism lacks a uniting belief system, what makes up the Hindu religion? 2.What are the cultural and societal influences that have made Hinduism vital to the region in which it originated? 3 .Explain the desire for liberation from earthly existence.

850 word paper answering the following questions: 1.Considering that Hinduism lacks a uniting belief system, what makes up the Hindu religion? 2.What are the cultural and societal influences that have made Hinduism vital to the region in which it originated? 3 .Explain the desire for liberation from earthly existence.

Topic Selection Explanation Tips For this course, you’ll be writing one final paper to highlight the multiplicity of information that you have learned while at Grantham. As part of your degree plan, you were asked to concentrate in several areas. When writing your paper, your paper must combine two disciplines. These disciplines may be in courses that you have taken as an elective or actual concentrations you’ve completed. Unless you have a compelling argument for the professor, your disciplines must come from the following list:

Psychology Sociology Science Government History Computer Science Business Literature Economics Criminal Justice

In developing the consideration of your topic, first of all, think of something you are passionate about. Is it sports? Is it the criminal mind? Is it education? Whatever is passionate for you is what you should be writing your paper about. The second task you have is to take the topic you want to write about – and find two different disciplines to interweave it through to make a fantastic paper.

For instance, as a psychology professor, I am interested in relationships; specifically – why do people get divorced? When considering this paper, I might want to interweave Science and Psychology – and write a paper about “The effects of divorce on the mind and body.” Let’s say I am interested in this divorce topic, but government is something I am very interested in as well. I might change my topic to “The ramifications of divorce within the legal system and Government’s inability to address the problem.” (Long titles are fine!)

Needless to say – the critical thinking aspect of this course begins with this assignment. You are tasked with not only coming up with a topic, but being able to creatively intertwine it through your paper all semester long.

Extended Directions: On Assignment 1.1, you are to come up with three different topic ideas. It could be like I did above, where you take divorce and interweave it through different disciplines (Psychology and Science, Psychology and Government, Psychology and Criminal Justice (as a third?)). It could be three completely unrelated topics. As part of the assignment, you are to:

List the two disciplines you are intertwining (Discipline 1: XXXXXX, Discipline 2: XXXXXX) Give the title for the topic of the paper Write about 100 words detailing what you would accomplish in this paper

Although I will ultimately let you choose the paper topic you want, I will give you my opinions while understanding the different research that you are able to find. Your paper topic must be from approved disciplines and should be able to be exclusively researched using peer reviewed literature. If the primary research will come from the web, it will not be allowed.

As part of the work for the week, you will also upload your assignment to the discussion board for the week. You are then to comment on two other students and give your opinion to the other students which of their topics you think would be best for them to do. Hopefully you will get feedback from other students as well to craft your topic selection before submitting it to the professor. Ultimately, the decision lies with the student but perhaps you have knowledge on something that you can share in a collaborative effort with your fellow students. You will be graded on the assignment (as submitted to the weekly dropbox) and your participation with other students in giving ideas for the paper assignment.

# Prepare a Microsoft® PowerPoint® presentation of no more than 10 slides with speaker notes. Your audience will play the board of directors or a venture capital firm. The focus is to sell your recommendations to the board or venture capital firm and obtain approval for funding your plan. Format your plan and presentation consistent with APA guidelines. Click the Assignment Files tab to submit your assignment.

Prepare a Microsoft® PowerPoint® presentation of no more than 10 slides with speaker notes. Your audience will play the board of directors or a venture capital firm. The focus is to sell your recommendations to the board or venture capital firm and obtain approval for funding your plan.

Format your plan and presentation consistent with APA guidelines.

Click the Assignment Files tab to submit your assignment.

# Write a draft of no more than 1,800 words of the strategic plan for your organization, including the following: •Implementation plan ◦Objectives ◦Functional tactics ◦Action items ◦Milestones and deadlines ◦Tasks and task ownership ◦Resource allocation •Any required organizational change management strategies that would enhance successful implementation •Key success factors, budget, and forecasted financials, including a break-even analysis •Risk management plan, including contingency plans for identified risks

Write a draft of no more than 1,800 words of the strategic plan for your organization, including the following: •Implementation plan ◦Objectives ◦Functional tactics ◦Action items ◦Milestones and deadlines ◦Tasks and task ownership ◦Resource allocation •Any required organizational change management strategies that would enhance successful implementation •Key success factors, budget, and forecasted financials, including a break-even analysis •Risk management plan, including contingency plans for identified risks