Analyze Good Health Hospital’s records and itemize recent nosocomial infections that occurred within the past year. In your report, categorize the different parameters (i.e., person, time, place, ethnicity, and gender) used in the compilation of data into the information summative.

/in /by
  • If you are using the Blackboard Mobile Learn iOS App, please click “View in Browser”
    Click the link above to submit your assignment.

    Students, please view the “Submit a Clickable Rubric Assignment” in the Student Center.
    Instructors, training on how to grade is within the Instructor Center.
    Assignment 1: Applications of Epidemiology – A Case Study
    Due Week 3 and worth 280 points
    The  situation at Good Health Hospital has become a bit overwhelming ever  since the outbreak of E. coli in Ward 10 on the second floor. It appears  that there are six (6) cases of the disease. To better understand the  situation, communication with the CDC has revealed that this particular  bacterium can be found in many everyday items. The CDC recommends that  investigation begins in the hospital kitchens, since E. coli can be  transmitted via contaminated vegetables, as well as delicatessen meats  such as salami and other cold cuts. The following table shows the number  of cases identified so far:
    Case Age Gender   1 23 M   2 21 F   3 15 M   4 42 F

    After meeting yesterday with chief administrator Joe Wellborn, it has  been decided that the litigation issues with one (1) of the patients may  need further information to determine if the patient was already  symptomatic with the bacteria prior to admission.
    Research has  indicated that hospitals operating in the Tampa Bay area have been known  to have cases of E. coli contamination. This substantiates the need for  further investigations by the County Health Department.
    Due to  the severity of the cases, and the potential for further spread, it is  recommended that the hospital seek alternate vending services since the  present suppliers cannot verify sanitation protocols for their products.
    In  conclusion, the study done at Good Health Hospital has indicated that  the E. coli outbreak was in fact caused by spoil food from the  cafeteria.
    As a social science researcher working for a regional  hospital, you are placed in charge of contacting the DOH from your home  state, as well as the CDC for statistical data on nosocomial diseases  that frequently cause illness at your health care facility. Using  information from both agencies, evaluate the data on common nosocomial  diseases and compile a treatment contingency plan for dealing with the  hospital infections.
    Write a five to six (5-6) page evaluation report in which you:

  1. Analyze  Good Health Hospital’s records and itemize recent nosocomial infections  that occurred within the past year. In your report, categorize the  different parameters (i.e., person, time, place, ethnicity, and gender)  used in the compilation of data into the information summative.
  2. Propose  at least six (6) questions for the health care administrator at Good  Health Hospital, regarding potential litigation issues with infections  from the nosocomial diseases. Rationalize, in your report, the logic  behind your six (6) questions.
  3. Identify a targeted audience  within Good Health Hospital, and prepare an implementation plan based on  your hypothetical meeting with the hospital health care administrator.  Propose four (4) steps that will be useful in the final implementation  plan.
  4. Suggest at least five (5) recommendations to your  department head based on the steps taken in the implementation plan.  Provide rationale for your suggestions.
  5. Using these approved  recommendations, design a safety protocol itinerary that must be placed  in public access areas of the hospital.
  6. Use at least four (4)  peer-reviewed academic resources in this assignment. These must come  from journal sources. Note: Fact Sheets, Wikipedia, and non-academic  Websites do not qualify as academic resources.
  7. Your assignment must follow these formatting requirements:
  • Be  typed, double spaced, using Times New Roman font (size 12), with  one-inch margins on all sides; citations and references must follow APA  or school-specific format. Check with your professor for any additional  instructions.
  • Include a cover page containing the title of the  assignment, the student’s name, the professor’s name, the course title,  and the date. The cover page and the reference page are not included in  the required assignment page length.
  • The specific course learning outcomes associated with this assignment are:
  • Examine epidemiology as it relates to population, environment, transmission, and prevention.
  • Examine the application of epidemiology to specific diseases.
  • Use technology and information resources to research issues in managerial epidemiology.
  • Write clearly and concisely about managerial epidemiology using proper writing mechanics.
  • Click here to view the grading rubric for this assignment.
 

"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"

In this section, you will assist the sales manager in categorizing the company’s revenue sources and how each one relates to each other. You will use formulas and functions to create totals and/or averages of the revenue data following the instructions below. Make sure you are in the Formulas&Functions active worksheet before you begin:

/in /by

You will need Excel 2007, 2010, 2013, or 2016 for project. You will also need the following file(s): 1010excel.xlsx.

Project Background: You have been hired by the Bahamas Cruise Line as an analyst. You will assist the cruise line staff in record-keeping, revenue generation, and overall efficiency. Your project will be broken down into the following three sections: Worksheet& Workbook Management, Formulas & Functions, and Charts & Subtotals.

Should you need additional help for adding numbers in Excel, using functions, formulas, subtotals, or charts, please watch the following video: Rocks, D. (August 9, 2008). See the “big picture” with Excel’s subtotal function [Video file]. Retrieved from https://www.youtube.com/watch?v=X5w5uWJDct8

Part 1: Worksheet & Workbook Management—Rename and organize the worksheets within the workbook, and re-save the workbook itself by following the instructions below: CS 1010, Computer Essentials 2

1.  Click here to access and open 1010excel.xlsx.

2.  Save the 1010excel.xlsx file as your “student ID number_last name.xlsx” (ex: 12345_Jones.xlsx).

3.  Rename Sheet 1 to Formulas&Functions.

4.  Rename Sheet 2 to Chart.

5.  Rename Sheet 3 to Subtotals.

6.  Move the Chart worksheet to the right of the Subtotals worksheet.

7.  Place a fourth worksheet using your student ID number as the name.

8.  Save the file.

Part 2: Formulas & Functions—In this section, you will assist the sales manager in categorizing the company’s revenue sources and how each one relates to each other. You will use formulas and functions to create totals and/or averages of the revenue data following the instructions below. Make sure you are in the Formulas&Functions active worksheet before you begin:

1.  In cell B2, place a function that totals Jan. through Dec. sales for Online Reservations.

2.  In cell B3, place a function that totals Jan. through Dec. sales for Telephone Reservations.

3.  In cell B4, place a function that totals Jan. through Dec. sales for Sales Calls.

4.  In cell B5, place a function that totals Jan. through Dec. sales for Activity Companies.

5.  In cell B7, place a formula that adds the annual totals of all four categories using cells B2, B3, B4, and B5, which will give you the total annual revenue for the Bahamas Cruise Line.

6.  In cell C2, place a function that displays the average for online reservations from Jan. through Dec. Repeat this for the other three categories of revenue.

7.  Save the file.

Part 3: Charts & Subtotals— Put a pie chart that compares each revenue source in the month of January, and use the subtotals feature in Excel to total three separate categories of revenue. Use the following instructions: Make sure the Chart worksheet is active before you begin.

1.  Place a pie chart using the range A1 to B5.

2.  Slightly detach the sales calls piece of the pie from the rest of the pie chart.

3.  Save the file.

Make sure the Subtotals worksheet is active before you begin.

1.  1. Sort the list by category (Activities, Hotels, and Retail) and add a row underneath each category, titled “Subtotal.”

2.  2. Use the sum function in Excel to display totals for the three categories on this worksheet.

3.  3. Save the file and submit for grading.

Revenue Source

Annual Total

Monthly Average

Jan

Feb

Mar

Apr

May

Jun

Jul

Aug

Sep

Oct

Nov

Dec

Online Reservations

$        45,208

$        40,000

$        15,000

$        65,000

$        25,000

$        39,000

$        85,000

$        85,000

$        74,000

$        34,000

$        14,500

$        26,000

Telephone Reservations

$          6,717

$          2,200

$        20,000

$          4,900

$          3,100

$          1,500

$        12,100

$          6,100

$          3,000

$          2,300

$        10,600

$          7,600

Sales calls

$          7,271

$          5,600

$          7,500

$          5,800

$          4,000

$          1,800

$          2,300

$          8,800

$          6,200

$          4,850

$        26,000

$          4,900

Activity companies

$        80,449

$        10,500

$        65,000

$        49,000

$        55,000

$    1,55,000

$    1,05,889

$    1,00,000

$        69,000

$        63,000

$        68,000

$    1,63,000

Grand total:

Revenue Source

Jan

Online Reservations

$ 45,208

Telephone Reservations

$    6,717

Sales calls

$    7,271

Activity companies

$ 80,449

Description

Date Paid

Category

Amount

Nassau Store

11-8-2014

Retail

$    4,974.53

Atlantis Resort

11-5-2014

Hotels

$          78.34

Atlantis Resort

11-8-2014

Hotels

$          35.99

Atlantis Resort

12-20-2014

Hotels

$          25.12

Bahama Activities

10-31-2014

Activities

$        451.15

Tiamo Resort

11-5-2014

Hotels

$          11.68

Tiamo Resort

11-16-2014

Hotels

$        160.00

Tiamo Resort

12-7-2014

Hotels

$          46.00

Tiamo Resort

12-10-2014

Hotels

$          15.00

Fun in the Sun Tours

11-5-2014

Activities

$          99.75

Bahama Adventure Tours

10-22-2014

Activities

$    2,200.00

Bahama Water Park

10-26-2014

Activities

$ 13,300.00

Island Seas Resort

11-5-2014

Hotels

$    9,133.00

Island Seas Resort

12-21-2014

Hotels

$          52.75

Nassau Ocean Adventures

11-27-2014

Activities

$        230.00

Coco Cay Store

12-8-2014

Retail

$        445.33

Lucaya Store

12-9-2014

Retail

$        175.00

Ocean Tours Bahama

12-2-2014

Activities

$        590.00

Nassau Adventures

12-3-2014

Activities

$        130.00

Musha Cay Resort

12-10-2014

Hotels

$          45.97

Paradise Fun Company

11-29-2014

Activities

$        750.25

Alice Town Store

12-30-2014

Retail

$    1,452.67

Nassau Fun Activities

10-26-2014

Activities

$        884.75

Bay Street Store

12-30-2014

Retail

$        396.88

 

"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"

Choose a product or service you currently consume/use, such as apparel or educational services, that is included in the CPI’s “market basket.” Find the annual CPI index numbers for your chosen good or service for the years 1995, 2005, 2010, and 2015. Enter those index numbers in an Excel® file and calculate the percent change (inflation rates) in those index numbers from 1995 to 2005, from 1995 to 2010, and from 1995 to 2015.

/in /by

This assignment will introduce students to the U.S. Department of Labor’s Bureau of Labor Statistics (BLS) data and provide students with the skills to calculate inflation and interpret the Consumer Price Index (CPI). Note: The BLS is the primary source of information on inflation, but their data is re-posted in other sources, such as the St. Louis Federal Reserve FRED site, among others.

Assignment Steps

Resources: Tutorial help on Excel® and Word functions can be found on the Microsoft® Office website. There are also additional tutorials via the web offering support for Office products.

Use an internet search or the University Library to locate information on the Consumer Price Index (CPI). Internet sites you might find useful include the Bureau of Labor Statistics (BLS) and the Federal Reserve of St. Louis FRED web site although you are allowed to use other sources.

Develop a minimum 700-word analysis of inflation by including the following:

  • Choose a product or service you currently consume/use, such as apparel or educational services, that is included in the CPI’s “market basket.”  Find the annual CPI index numbers for your chosen good or service for the years 1995, 2005, 2010, and 2015.  Enter those index numbers in an Excel® file and calculate the percent change (inflation rates) in those index numbers from 1995 to 2005, from 1995 to 2010, and from 1995 to 2015.
  • Analyze the trends in overall inflation over the last five years and whether your income has kept pace with inflation.  How has inflation over the last five years affected you and/or your family?
  • Discuss how a business manager, such as a human resources manager, might use CPI statistics.

Cite a minimum of three scholarly, peer-reviewed references.

Format your paper consistent with APA guidelines.

 

"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"

how health information is used to develop performance indicators for management of cost centres

/in /by

Budget Paper
Assignment Requirements

Aim of Assessment This assessment aligns with unit learning outcomes 5-8. On completion of the unit the student will be able to: Critically analyse the reporting systems used by health and aged care organisations, including budget statements. Prepare budgets and economic appraisals of funding options.
Understand how health information is used to develop performance indicators for management of cost centres, be able to analyse budget variances and evaluate options eg in response to �budget blowouts�. Prepare an application for funding, with consideration of offsets and alternative funding strategies.

Details Develop a budget for a project, ward, unit or service USING A BUDGET TEMPLATE (you may use one from your own organisation), in an environment of scarce resources. Consider alternative options USING OPPORTUNITY COST ANALYSIS. Annotate the document to show the sources of data used for forecasting the expenditure for the budget period.

Marking criteria and standards: Assessment 2 Budget paper :

Introduction 15% Budget presented on appropriate template.(5) Budget period clearly stated.(5) Describes setting in which budget is to be applied.(5)
The template or design appropriate for recording the budget is used. The budget period including start and completion dates are stated. The setting in which the budget is described clearly and accurately.

Budget 35% Budget is detailed and correct. (20) Alternative options using opportunity cost analysis are discussed.(10) Document shows sources of data used for forecasting expenditure (5)
The budget is detailed with all relevant and important content included and correct. Alternative options using opportunity cost analysis are discussed in detail demonstrating strong understanding of the content. Sources of data used for forecasting expenditure are annotated on the budget. The sources are highly relevant to the budget.

Presentation 10% Uses correct grammar, spelling and punctuation. Correct application of APA used for in-text citation and for the reference list.
Your essay contains one or less minor errors in grammar, spelling and/or punctuation, but these do not interfere with meaning. You apply all conventions of APA correctly, use direct quotation sparingly and paraphrase effectively in most cases. You use the correct bibliographical format for reference list.
You

N.B. – All figures and circumstances given in a budget template are fictitious and have been put together for the purpose of this case study

 

"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"

Analyze Good Health Hospital’s records and itemize recent nosocomial infections that occurred within the past year. In your report, categorize the different parameters (i.e., person, time, place, ethnicity, and gender) used in the compilation of data into the information summative.

/in /by
  • If you are using the Blackboard Mobile Learn iOS App, please click “View in Browser”
    Click the link above to submit your assignment.

    Students, please view the “Submit a Clickable Rubric Assignment” in the Student Center.
    Instructors, training on how to grade is within the Instructor Center.
    Assignment 1: Applications of Epidemiology – A Case Study
    Due Week 3 and worth 280 points
    The  situation at Good Health Hospital has become a bit overwhelming ever  since the outbreak of E. coli in Ward 10 on the second floor. It appears  that there are six (6) cases of the disease. To better understand the  situation, communication with the CDC has revealed that this particular  bacterium can be found in many everyday items. The CDC recommends that  investigation begins in the hospital kitchens, since E. coli can be  transmitted via contaminated vegetables, as well as delicatessen meats  such as salami and other cold cuts. The following table shows the number  of cases identified so far:
    Case Age Gender   1 23 M   2 21 F   3 15 M   4 42 F

    After meeting yesterday with chief administrator Joe Wellborn, it has  been decided that the litigation issues with one (1) of the patients may  need further information to determine if the patient was already  symptomatic with the bacteria prior to admission.
    Research has  indicated that hospitals operating in the Tampa Bay area have been known  to have cases of E. coli contamination. This substantiates the need for  further investigations by the County Health Department.
    Due to  the severity of the cases, and the potential for further spread, it is  recommended that the hospital seek alternate vending services since the  present suppliers cannot verify sanitation protocols for their products.
    In  conclusion, the study done at Good Health Hospital has indicated that  the E. coli outbreak was in fact caused by spoil food from the  cafeteria.
    As a social science researcher working for a regional  hospital, you are placed in charge of contacting the DOH from your home  state, as well as the CDC for statistical data on nosocomial diseases  that frequently cause illness at your health care facility. Using  information from both agencies, evaluate the data on common nosocomial  diseases and compile a treatment contingency plan for dealing with the  hospital infections.
    Write a five to six (5-6) page evaluation report in which you:

  1. Analyze  Good Health Hospital’s records and itemize recent nosocomial infections  that occurred within the past year. In your report, categorize the  different parameters (i.e., person, time, place, ethnicity, and gender)  used in the compilation of data into the information summative.
  2. Propose  at least six (6) questions for the health care administrator at Good  Health Hospital, regarding potential litigation issues with infections  from the nosocomial diseases. Rationalize, in your report, the logic  behind your six (6) questions.
  3. Identify a targeted audience  within Good Health Hospital, and prepare an implementation plan based on  your hypothetical meeting with the hospital health care administrator.  Propose four (4) steps that will be useful in the final implementation  plan.
  4. Suggest at least five (5) recommendations to your  department head based on the steps taken in the implementation plan.  Provide rationale for your suggestions.
  5. Using these approved  recommendations, design a safety protocol itinerary that must be placed  in public access areas of the hospital.
  6. Use at least four (4)  peer-reviewed academic resources in this assignment. These must come  from journal sources. Note: Fact Sheets, Wikipedia, and non-academic  Websites do not qualify as academic resources.
  7. Your assignment must follow these formatting requirements:
  • Be  typed, double spaced, using Times New Roman font (size 12), with  one-inch margins on all sides; citations and references must follow APA  or school-specific format. Check with your professor for any additional  instructions.
  • Include a cover page containing the title of the  assignment, the student’s name, the professor’s name, the course title,  and the date. The cover page and the reference page are not included in  the required assignment page length.
  • The specific course learning outcomes associated with this assignment are:
  • Examine epidemiology as it relates to population, environment, transmission, and prevention.
  • Examine the application of epidemiology to specific diseases.
  • Use technology and information resources to research issues in managerial epidemiology.
  • Write clearly and concisely about managerial epidemiology using proper writing mechanics.
  • Click here to view the grading rubric for this assignment.
 

"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"

To finance the investment, Vestor has issued 20 year bonds with a $1,000 par value, 6% coupon rate and at a market price of $950. Preferred stock paying a $2.50 annual dividend was sold for $25 per share. Common stock of Vestor is currently selling for $50 per share and has a Beta of 1.2. The firm’s tax rate is 34%. The expected market return of the S&P 500 is 13% and the 10-Year Treasury note is currently yielding 3.5%. Determine what discount rate (WACC) Vestor should use to evaluate the warehousing facility project.

/in /by

Resources: Tutorial help on Excel® and Word functions can be found on the Microsoft® Office website. There are also additional tutorials via the web that offer support for office products.

Scenario: You work for an investment banking firm and have been asked by management of Vestor Corporation (not real), a software development company, to calculate its weighted average cost of capital, to use in evaluating a new company investment. The firm is considering a new investment in a warehousing facility, which it believes will generate an internal rate of return of 11.5%. The market value of Vestor’s capital structure is as follows:

Source of Capital Market Value

Bonds $10,000,000

Preferred Stock $2,000,000

Common Stock $8,000,000

To finance the investment, Vestor has issued 20 year bonds with a $1,000 par value, 6% coupon rate and at a market price of $950. Preferred stock paying a $2.50 annual dividend was sold for $25 per share. Common stock of Vestor is currently selling for $50 per share and has a Beta of 1.2. The firm’s tax rate is 34%. The expected market return of the S&P 500 is 13% and the 10-Year Treasury note is currently yielding 3.5%.

Determine what discount rate (WACC) Vestor should use to evaluate the warehousing facility project.

 

"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"

write a full report to compare between applying the periodic inventory system and the perpetual inventory system.

/in /by

Accounting project MAKE EDIT (1,2,3
Assignment Requirements

Students should write a full report to compare between applying the periodic inventory system and the perpetual inventory system. Applying one of these two methods should show significant difference. Therefore, students should discuss the following ideas:
1. Where each of these methods can be applicable and why.
2. What is the effect of using FIFO and WA methods on each of the two systems?
3. What is the requirements for applying any of these two systems?
4. What is the effect of applying the any of the two systems on the financial statements and in turn on the decisions of the users of the financial statements?

Your analysis must cover the following topics:
1. Demonstrate your understanding of the revenue recognition concept and its implications in the financial statements. Your analysis should include discussing some examples of the revenue recognition issues.
2. Demonstrate your understanding of the accounting concepts and their implications in the financial statements. Your analysis should include discussing some examples of the limitations of accounting information.
3. You need to demonstrate that you have been able to read and utilize the income statement, the statement of the financial position and the cash flow statement.

@@@@@@NOTE IMPORTANT .. I ALREADY ORDERED THAT REASEARCH PAPER AND I WILL ATTACH IT TO THIS ORDER, I WANT YOU TO ADD/EDIT:
1)ADD INTRODUCTION
2)PUT ALL REFERENCES (DONT PUT REFERENCES FROM BOOKS ONLY ONLY WEBSITES)
3)MAKE THE RESEARCH PAPER SOUND LIKE A STUDENT WORK PAPER AND NOT PROFFESSIONAL

###THESE 3 POINTS ARE MOST IMPORTANT POINTS

 

"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"

Compare the theories of Freidman and Carroll, and create a PowerPoint presentation on your comparative study. Your PowerPoint presentation should include the following elements: · Slide 1: Title page · Slide 2: Table of content or objective slide

/in /by

In 1970, Milton Friedman wrote an article titled “The Social Responsibility of Business is to Increase its Profits” that sparked a debate about corporate responsibility that remains heated to this day. Read the Schwartz and Saiia article, “Should Firms Go ‘Beyond Profits’? Milton Friedman versus broad CSR1,” pages 1-10, in order to gain a perspective on Mr. Friedman’s views on corporate responsibility. In addition to the Schwartz and Saiia article, read Archie Carroll’s “The Pyramid of Corporate Social Responsibility: Toward the Moral Management of Organizational Stakeholders.” Both articles are available in the Business Source Complete database in the CSU Online Library. These articles will help you develop an understanding of their business and ethical principles. You are encouraged to conduct additional research about Friedman and Carroll using outside sources.

Compare the theories of Freidman and Carroll, and create a PowerPoint presentation on your comparative study. Your PowerPoint presentation should include the following elements:

  • ·  Slide 1: Title page
  • ·  Slide 2: Table of content or objective slide
  • ·  Slide 3: A summary of Milton Friedman’s main points
  • ·  Slide 4: A summary of Archie Carroll’s main points
  • ·  Slide 5: The principles you would like implemented at your current place of work (or where you wish to work in       the future), and why you would include them
  • ·  Slides 6-7: Two detailed examples of organizations where Friedman’s theories are applied
  • ·  Slides 8-9: Two detailed examples of organizations where Carroll’s theories are applied
  • ·  Slide 10: Conclusion
  • ·  Slide 11: References in proper APA format

Please ensure that every slide has a title at the top explaining what the slide covers. Add citations in proper APA format, use applicable pictures or graphics (with citations), use a slide template, and avoid wordy slides by focusing on bullet points. Remember, this is an academic presentation.

Unit VIII PowerPoint Presentation 

Review the processes of invention and innovation. Then, select a new product that you have been introduced to in the past 12 months. You are encouraged to research this new product using outside sources. You can use the same company you have been researching, or pick a new one.

You are to create a PowerPoint presentation about future inventions this new product could help to inspire and what innovations could be developed to enhance and improve this product. Analyze how these two areas could impact the company. Perform an analysis or SWOT on potential impact of inventions or innovations. Your PowerPoint presentation should include the following elements:

  • ·  Slide      1: Title page
  • ·  Slide      2: Objective or table of contents
  • ·  Slide      3: Description of the new product
  • ·  Slide      4: Description of the importance of R&D to include lead users and      market research
  • ·  Slide      5: Discussion of appropriate structure and culture necessary to support      innovative ideas and products
  • ·  Slide      6: Exploration of future inventions inspired by the product
  • ·  Slide      7: Analysis of future innovations of this product (Was this a successful      invention leading to innovation?)
  • ·  Slide      8: ROI, shareholder value, economic value-added analysis, or a SWOT, on      innovation
  • ·  Slide      9: ROI, shareholder value, economic value-added analysis or a SWOT, on      invention
  • ·  Slide      10: Brief description of the benchmarking process as applied to this      company (What problems with performance measuring can be encountered?)
  • ·  Slide      11: Prediction of product demand in five years
  • ·  Slide      12: Conclusion
  • ·  Slide      13: List of sources using APA guidelines

Please ensure that every slide has a title at the top explaining what the slide covers. Add citations in proper APA format, use applicable pictures or graphics, use a slide template, and avoid wordy slides by focusing on bullet points. Remember, this is an academic presentation.

 

"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"

Evaluate operational priorities using managerial accounting principles and practices, including budgeting

/in /by

Decision Making
Assignment Requirements

Learning Outcomes Assessed:

Assignment 1 will examine a range of topics relating to the following learning outcomes:

Learning Outcome 1 – Apply appropriate decision-making approaches and techniques to business situations
Learning Outcome 2 – Evaluate operational priorities using managerial accounting principles and practices, including budgeting
Assessment Description

Question1

Costello Corporation produces two grades of wine from grapes that it buys from California growers. It produces and sells roughly 600,000 gallon jugs per year of a low cost, high-volume product called Valley Fresh. Costello also produces and sells roughly 200,000 gallons per year of a low-volume, high-cost product called Costello Valley. Costello Valley is sold in 1-liter bottles. Based on recent data, the Valley Fresh product has not been as profit table as Costello Valley. Management is considering dropping the inexpensive Valley Fresh line so it can focus more attention on the Costello Valley product. The Costello Valley product already demands considerably more attention than the Valley Fresh line.

Frankie Costello, president and founder of Costello, is sceptical about this idea. He points out that for many decades the company produced only the Valley Fresh line, and that it was always quite profitable. It wasn’t until the company started producing the more complicated Costello Valley wine that the profitability of Valley Fresh declined. Prior to the introduction of Costello Valley, the company had simple equipment, simple growing and production procedures, and virtually no need for quality control. Because Costello Valley is bottled in 1-liter bottles, it requires considerably more time and effort, both to bottle and to label and box, than does Valley Fresh. The company must bottle and handle 4 times as many bottles of Costello Valley to sell the same quantity as Valley Fresh, since there are approximately 4 litres in a gallon. Valley Fresh requires 1 month of aging; Costello Valley requires 1 year. Valley Fresh requires cleaning and inspection of equipment every 2,500 gallons; Costello Valley requires such maintenance every 250 gallons. Frankie has asked the accounting department to prepare an analysis of the cost per gallon using the traditional costing approach and using activity-based costing. The following information was collected.

Valley Fresh Costello Valley
Direct materials per gallon $1.35 $3.60
Direct labour cost per gallon $0.75 $1.50
Direct labour hours per gallon 0.05 0.10
Total direct labour hours 30,000 20,000

Activity Cost Pool Cost Driver Estimated overheads Expected use of cost drivers Expected use of cost drivers per product
Valley Fresh Costello Valley
Grape processing Cart of grapes $146,000 8,000 6,000 2,000
Aging Total months $420,000 3,000,000 600,000 2,400,000
Bottling and corking Number of bottles $210,000 1,400,000 600,000 800,000
Labelling and boxing Number of bottles $140,000 1,400,000 600,000 800,000
Maintain and inspect equipment Number of inspections $234000 1,040 240 800
Required:

Write a memo to Frankie Costello providing a brief description of what is activity based costing as well as an explanation of how the traditional approach can result in distortions.

Hint: You should support your discussion by calculating and comparing the total manufacturing cost per gallon for both products under both traditional costing systems as well activity based costing.

Question2

Curtis Rich, the cost accountant for Hi-Power Mower Company, recently installed activity based costing at Hi-Power’s St. Louis lawn tractor (riding mower) plant where three models—the 8-horsepower Bladerunner, the 12-horsepower Quickcut, and the 18-horsepower Supercut—are manufactured.

Curtis’s new product costs for these three models show that the company’s traditional costing system had been significantly under costing the 18-horsepower Supercut. This was due primarily to the lower sales volume of the Supercut compared to the Bladerunner and the Quickcut.

Before completing his analysis and reporting these results to management, Curtis is approached by his friend Ed Gray, who is the production manager for the 18-horsepower Supercut model. Ed has heard from one of Curtis’s staff about the new product costs and is upset and worried for his job because the new costs show the Supercut to be losing, rather than making, money.

At first, Ed condemns the new cost system, whereupon Curtis explains the practice of activity based costing and why it is more accurate than the company’s present system. Even more worried now, Ed begs Curtis, “Massage the figures just enough to save the line from being discontinued. You don’t want me to lose my job, do you? Anyway, nobody will know.” Curtis holds firm but agrees to recompute all his calculations for accuracy before submitting his costs to management.

Required:

Draft a response from Curtis to Ed Gray.

Question3

Gonzalez Company produces one product, Olpe. Because of wide fluctuations in demand for Olpe, the Assembly Department experiences significant variations in monthly production levels.

The annual master manufacturing overhead budget below is based on 300,000 direct labour hours. In July, 27,500 labour hours were worked. The master manufacturing overhead budget for the year and the actual overhead costs incurred in July are as follows.

Overhead costs Master budget Actual results for July
Variable
Indirect labour
$ 300,000 $ 26,000
Indirect material
$ 150,000 $ 11,350
Utilities
$ 90,000 $ 8,050
Maintenance
$ 60,000 $ 5,400
Fixed
Supervision
$ 144,000 $ 12,000
Depreciation
$ 96,000 $ 8,000
Insurance and taxes
$ 60,000 $ 5,000
Total $ 900,000 $ 75,800
Required:

(A) Prepare a budget report for the month of July 2014, comparing actual results with budget data based on the flexible budget. Were costs effectively controlled? Explain.

(B) Prepare the flexible budget graph showing total budgeted costs assuming monthly production levels range from 25,000 to 30,000 direct labour hours (use increments of 2,500 direct labour hours).

 

"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"