What is the forecast on the demand

Assignment Help Supply Chain Management
Reference no: EM132069834

Aggregate Planning

A large hospital must decide on how many surgical teams to staff for the following routine procedures.

These are the estimated number of procedures needed per month, and the CV for each one. Demand for  each of the 3 procedures is independent of the other ones.

Procedure
Forecast CV



a) Remove Appendix 120 30%
23.1% 0.5 0.15
b) Remove Kidney Stone 80 40%

0.333333 0.133333
c) Mend Intestinal Rupture 40 50%

0.166667 0.083333



240

21.2%
0.366667
Each surgical team can perform any of these operations, but can only perform a maximum of 2 per day. Also, each surgical team will work 20 days per month.

2.1 Given that each team works 20 days per month, how many teams must be hired to treat exactly the average number of operations forecast? (If solution is decimal, round UP.)

2.2 What is the forecast on the demand for all three procedures?

2.3. What is the forecast on the CV for all three procedures?

2.4 In order to meet the extra demand given by the CVt, how many extra teams (beyond original) are now needed? (Round up.)

2.5 The implied % of total surgical staffing which is need as buffer capacity is

Attachment:- Assignment.rar

Verified Expert

The assignment pertains to concept like coefficient of variation, mean etc.The buffer capacity is also involved as the part of he assignment.The linking has been done in the excel file.

Reference no: EM132069834

Questions Cloud

How you plan to get your new staff members up to speed : They have very little understanding of your project and you don't have a lot of time to educate them on the project's specifics.
How you would apply moneyballs management lessons : Moneyball highlights how people tend to overestimate the likelihood of success and end up facing financial loss-in this case, it meant forfeiting millions.
How much would you have in the investment account : You signed a contract for 3 years with a signing bonus today of 274,000$. how much would you have in the investment account at the end of 5 year?
Dissertation for urm and chair review : Prepare Ch. 3 (methodology) of your dissertation for URM and chair review. Your methodology should address the following areas:
What is the forecast on the demand : What is the forecast on the demand for all three procedures - What is the forecast on the CV for all three procedures - In order to meet the extra demand
Sunbeam owners spares club : The Sunbeam Owners Spares Club (In the actual exam, the case study is different but of a similar length) Sunbeam are the world's third oldest car company
Would you say that these voyages tended to hasten : The fifteenth and sixteenth century voyages of exploration produced lasting changes in the political and social structure of Western Europe.
What is the equity multiplier and net income : What is the equity multiplier? What is the return on equity?
What is the purpose of a code of conduct : Answer the following questions:What is the purpose of a code of conduct? Why is it important for a company to have a written code of conduct?

Reviews

inf2069834

10/6/2018 3:29:40 AM

Thank you very much for the perfection in the work you provided.

inf2069834

10/6/2018 3:29:07 AM

I thought the work would be more expensive but you guys quoted so cheap that it was affordable for my pocket.

Write a Review

Supply Chain Management Questions & Answers

  The internet as another channel of distribution option

What is the value of the Internet as another channel of distribution option? Does it increase sales or just displace sales?

  Merchandise of your favorite sport organization

Identify a new product image, mark, or logo for the merchandise of your favorite sport organization.

  Porters five forces strategic models in your analysis

Review the organization (Proctor and Gamble) and the industry before applying the strategic models below to your selected firm. Complete a PEST analysis for P&G. Be sure that this is based on research of the organization, not conjecture or opinion. S..

  What are the expected total costs

What are the expected total costs - What are the total costs if they complete only 3,500 repairs?

  Current supply chain and the proposed turnkey strategy

Analyze the differences between the current supply chain and the proposed turnkey strategy - What will the change mean for suppliers and their roles? What will it mean for current employees and their roles?

  Role that quality plays when considering e-commerce

Based on your own research on the use of e-commerce/e-procurement in the public and private sectors, what are those elements that you consider to be unique to each?

  Examine the reasons for confidentiality of the igce

Examine the reasons for confidentiality of the IGCE. Propose two (2) actions that should be taken in order to maintain the confidentiality of the IGCE.

  What specific activities form the supply chain in ace

Describe the supply chain for milk and Where does Ace Dairies fit into this? What specific activities form the supply chain in Ace Dairies

  Marketing strategies in each national market

Some international companies choose to follow a multinational (multi domestic) strategy—a strategy of adapting products and their marketing strategies in each national market to suit local preferences. Discuss how international strategies can be appl..

  Results from outside the performing organization

Project Procurement Management ________. Describes the processes required to procure products, services, or results from outside the performing organization. Involves processes to ensure that the project procures products, services, or results at the..

  Unethical business practices degrade the quality

How is the International Organization for Standardization trying to encourage ethical business behavior?

  Discuss the legal principles covering the passage

How may an offer be terminated and discuss the legal principles covering the passage of risk of property in transit

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd