Is there a trend you can observe in the data

Assignment Help Operation Management

Reference no: EM132390074

In MS Excel, complete the exercises in part 1 and part 2

Part 1

1. A community hospital in Pennsylvania has a 15% supply expense ratio. If total operating expenses are $1 million this month, what is the total annual cost of supplies?

2. A hospital buys certain supplies for $50 each. The average markup is 100%. Additional selling costs are 25% of the total cost. What is the net realizable value?

3. Assume this same product has a current replacement cost of $40. What is the lower of cost or market?

Part 2

1. Assume the following time series data:

January 100

February 200

March 300

April 400

Is there a trend you can observe in the data? What is it called?

2. If a product has utilization of 50 in Period 0 and a slope of 10 each subsequent period, what is the expected forecasted value in Period 2?

Reference no: EM132390074

Questions Cloud

Senior management for future strategic planning : Explain an approach that you would present to senior management for future strategic planning.

Enhance negotiations between different foreign cultures : Describe how international negotiators can utilize nonverbal communication to enhance negotiations between different foreign cultures.

Global thinking in multicultural business environment : Explain what Alpia will need to consider in regards to global thinking in a multicultural business environment.

Strategic Airport Planning and Development Assignment : Strategic Airport Planning and Development Assignment - write a report regarding 2 airports to use as case studies for the teams

Is there a trend you can observe in the data : Assume this same product has a current replacement cost of $40. What is the lower of cost or market? Is there a trend you can observe in the data? What is it ca

Analyze current corporate culture : Analyze Current Corporate Culture. How has the current corporate culture facilitated the development of the current issue?

Explain how affordable care act affect break-even analysis : Explain how the Affordable Care Act affect break-even analysis? Discuss non-financial factors do the authors believe need to be included in break-even analysis?

High level processes the organization accomplishes : Discuss one or more high level processes the organization accomplishes? Which department do you think is the lead for this process?

Sustainability-led innovation offers to environment : Evaluate at least three benefits that sustainability-led innovation offers to environment, the company's operations systems change, and to various stakeholders.

User Account

All Pages