Rparslow_M444_M7_A7.3Submit Chapters 11-12 Problems Complete the following problems at the end of Chapters 11 and 12. Chapter 11 Spreadsheet Problems: 1, 2 (p. 399-400) 1. The soft toys company has collected information on fixed and variable costs for four potential plant locations. Location A B C D Annual Fixed Cost $200,000 $300,000 $400,000 $600,000 Unit Variable Cost $50.00 $45.00 $25.00 $20.00 A: Plot the total cost curves for the four plant locations on a single graph. B: Compute the range of demand for which each location has a cost advantage. C: Which plant location is best if demand is 30,000 units? 2. The Bruhaha Brewery is planning to expand internationally. The company has identified six critical location factors and their relative weights. The scores for each of the three potential sites are shown in the following table. Which site should be selected? Critical Location Factors Labor cost Proximity to market Supplier base Quality of life Taxes Factor Weight (sum to 1) 0.15 0.25 Columbus scores (1-100) 70 100 Las Vegas scores (1-100) 90 90 Spokane scores (1-100) 50 80 0.2 0.3 0.1 80 90 60 100 60 80 70 60 90 Chapter 12 Problems: 1, 3, 5, 7 (p. 441-442) 1. For the previous month the Ellram Lounge served 1500 customers with very few complaints. Their labor cost was 3000.00 material cost was 800.00 energy cost was 200.00 and building lease cost was 1500.00. They were open 26 days of the month and the lounge has 20 seats. They are open 6 hrs per day and the average customer stay is 1 hour. A: Calculate the single factor productivities and the overall multiple factor productivity. How could they improve the productivity? B: Calculate the monthly capacity and the capacity utilization 3 For the office layout shown in question number 2, determine the closeness desirability rating using the rating table below. Treat the hallway as if it doesn't exist, can you find a more desirable layout? How could you use both the total distance traveled and the closeness desirability in assessing the layout alternatives? Can you find a layout resulting in relatively good scores using both types of criteria? 1 Management 5 Files (1) (2) (3) (4) (5) (6) (7) (2) 2 2 Production 6 Accounting 3 Engineering 7 Purchasing Closeness desirabilities between departments (3) (4) (5) (6) 2 -1 0 1 3 0 0 0 0 2 0 3 1 2 4 Reception 8 Sales (7) 3 3 2 2 2 0 (8) 3 1 3 2 1 2 1 5. Given the average service rate of twelve customers per hour, what is the probability the business can handle all the customers when the average arrival rate is 10 customers per hour? Use the Poisson distribution to calculate the probabilities for various customer arrivals 7. Stella can handle about ten customers per hour at her one person comic book store. The customer arrival rate averages about 6 customers per hour. Stella is interested in knowing the operating characteristics of her single channel single phase queuing system