Chapter 8, Problem 1AIP

You are creating part of an Excel model that will set the price of an item based on whether the customer is a preferred customer or not. The partially completed model in the attached file. <-- Click here to download the Excel file. In cell B6, you will enter the formula that will use this logic:When preferred status is Yes, the price is the preferred price. Otherwise the price is the regular price.= Answer ( Answer = "Yes" , Answer , Answer ) As an alternative, you could also use this logic to get the same results:When preferred status is No, the price is the regular price. Otherwise the price is the preferred price.= Answer ( Answer = "No" , Answer , Answer ) Note that these problems use short answer text boxes, and therefore can include any characters (not just numbers). Customer ID: 68YJW     Prices:           Regular $26.95 Customer Name Reggie Greene     Preferred $21.95 Preferred? Y/N: Yes                     Customer Price

The Paymore Rental Car Agency rents cars in a small town. It wants to determine how many rental cars it should maintain. Based on market projections and historical data, the manager has determined probability distributions for the number of rentals per day and rental duration (in days only) as shown in the following tables:  Number of customers per day Probability 0 .20 1 .20 2 .50 3 .10   Rental duration in days Probability 1 .10 2 .30 3 .40 4 .10 5 .10   Design a simulation experiment for the car agency and simulate using a fleet of four rental cars for 10 days. Compute the probability that the agency will not have a car available upon demand. Should the agency expand its fleet? Explain how a simulation experiment could be designed to determine the optimal fleet size for the Paymore Agency. Use the following random numbers in order (from left to right) for the simulation of number of customers per day: 0.62 0.48 0.96 0.86 0.86 0.29 0.79 0.22 0.08 0.62…

The owner of Barb’s Burgers has suggested the firm should invest in more moderntechnology and created a list of potential changes she thinks may be helpful as aninvestment. She has asked you to analyze the four potential choices and comment onwhat this would change in terms of cost:  Allow Barb’s Burgers to be delivered via the pre-existing food delivery systems.For example, allow people from Doordash/Uber Eats to pick-up orders and deliverthem. This would require the firm to make some minor changes and result in fewerparking spaces for customers dining at the restaurant. • Question: Argue how each of these is likely to change the cost of the firm once implemented (i.e. are any of these a fixed cost or a variable cost). How this adjust the amount of labour and/or capital currently necessary for the firm? Would the technology be a general technology, labour-saving, or capital-saving? Also mention the parking space.