Spreadsheet Modeling & Decision Analysis: A Practical Introduction to Business Analytics (MindTap Course List)
Spreadsheet Modeling & Decision Analysis: A Practical Introduction to Business Analytics (MindTap Course List)
8th Edition
ISBN: 9781305947412
Author: Cliff Ragsdale
Publisher: Cengage Learning
bartleby

Concept explainers

Students have asked these similar questions
PharmaPlus operates a chain of 30 pharmacies. The pharmacies are staffed by licensed pharmacists and pharmacy technicians. The company currently employs 85 full-time-equivalent pharmacists (combination of full time and part time) and 175 full-time-equivalent technicians. Each spring management reviews current staffing levels and makes hiring plans for the year. A recent forecast of the prescription load for the next year shows that at least 250 full-time-equivalent employees (pharmacists and technicians) will be required to staff the pharmacies. The personnel department expects 10 pharmacists and 30 technicians to leave over the next year. To accommodate the expected attrition and prepare for future growth, management states that at least 15 new pharmacists must be hired. In addition, PharmaPlus’s new service quality guidelines specify no more than two technicians per licensed pharmacist. The average salary for licensed pharmacists is $40 per hour and the average salary for technicians…
Trips Logistics, a third-party logistics firm that provides warehousing and other logistics services, is facing a decision regarding the amount of space to lease for the upcoming three-year period. The general manager has forecast that Trips Logistics will need to handle a demand of 100,000 units for each of the next three years. Historically, Trips Logistics has required 1,000 square feet of warehouse space for every 1,000 units of demand. For the purposes of this discussion, the only cost Trips Logistics faces is the cost for the warehouse. Trips Logistics receives revenue of $1.22 for each unit of demand. The general manager must decide whether to sign a three-year lease or obtain warehousing space on the spot market each year. The three-year lease will cost $1 per square foot per year, and the spot market rate is expected to be $1.20 per square foot per year for each of the three years. Trips Logistics has a discount rate of k = 0.1.
In the​ past, Peter​ Kelle's tire dealership in Baton Rouge sold an average of 1,000 radials each year. In the past 2​ years, 240 and 240​, respectively were sold in​ fall, 350 and 320 in​ winter,150 and165 in​ spring, and 340 and 195 in summer. With a major expansion​ planned, Kelle projects sales next year to increase to 1,200 radials. Based on next​ year's projected​ sales, the demand for each season is going to be ​(enter your responses as whole​ numbers): Fall: Winter: Spring: Summer:
Knowledge Booster
Background pattern image
Management
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
SEE MORE QUESTIONS
Recommended textbooks for you
Text book image
Practical Management Science
Operations Management
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:Cengage,
Text book image
Purchasing and Supply Chain Management
Operations Management
ISBN:9781285869681
Author:Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson
Publisher:Cengage Learning