Evaluation Only. Created with Aspose.Words. Copyright 2003-2018 Aspose Pty Ltd. 1. Surfing USA, an Internet service provider, is considering to offer a service in Laramie County, WY, that connects a device directly to televisions and allows customers to either watch TV or access the Internet. The expected price of the service per customer is $26 per month and the variable cost per customer to provide the service is expected to be $17 per month. The number of customers in Laramie County that are expected to subscribe to the service at that price is 20,000 per month a) Develop an Excel model to find the maximum monthly fixed cost that Surfing USA would pay to offer the service in Laramie County and not operate at a loss. b) Assume that Surfing USA's monthly fixed costs are $100,000 and monthly service cost per customer is $17. The price per customer will affect the monthly demand for the service. Assume that for a monthly price of $26 per customer, the demand will be 20,000 customers and for each $1 increase in price demand will fall by 2,700 customers Develop an Excel model to recommend a monthly price to Surfing USA and examine the sensitivity of monthly profit to changes in price for prices from $20 to $30. 2. A Blending Problem. Douglas E. Starr, the manager of Heavenly Hound Kennels, Inc., provides lodging for pets. The kennels' dog food is made by mixing three grain products to obtain a well- balanced dog diet. The data for the three products are shown in the following table. If Douglas wants to make sure that each of his dogs consumes at least 8 ounces of protein, 1 ounce of carbohydrate, and no more than 0.5 ounces of fat each day, how much of each grain product should each dog be fed in order to minimize Douglas's cost? (Note: 16 ounces = 1 pound.) GRAIN COST PER PRODUCT POUND ($) PROTEIN(%) CARBOHYDRATE (%) FAT(%) 0,45 0,38 0,27 A B 62 55 36 5 10 20 3 2 1 Evaluation Only. Created with Aspose.Words. Copyright 2003-2018 Aspose Pty Ltd. 1. Surfing USA, an Internet service provider, is considering to offer a service in Laramie County, WY, that connects a device directly to televisions and allows customers to either watch TV or access the Internet. The expected price of the service per customer is $26 per month and the variable cost per customer to provide the service is expected to be $17 per month. The number of customers in Laramie County that are expected to subscribe to the service at that price is 20,000 per month a) Develop an Excel model to find the maximum monthly fixed cost that Surfing USA would pay to offer the service in Laramie County and not operate at a loss. b) Assume that Surfing USA's monthly fixed costs are $100,000 and monthly service cost per customer is $17. The price per customer will affect the monthly demand for the service. Assume that for a monthly price of $26 per customer, the demand will be 20,000 customers and for each $1 increase in price demand will fall by 2,700 customers Develop an Excel model to recommend a monthly price to Surfing USA and examine the sensitivity of monthly profit to changes in price for prices from $20 to $30. 2. A Blending Problem. Douglas E. Starr, the manager of Heavenly Hound Kennels, Inc., provides lodging for pets. The kennels' dog food is made by mixing three grain products to obtain a well- balanced dog diet. The data for the three products are shown in the following table. If Douglas wants to make sure that each of his dogs consumes at least 8 ounces of protein, 1 ounce of carbohydrate, and no more than 0.5 ounces of fat each day, how much of each grain product should each dog be fed in order to minimize Douglas's cost? (Note: 16 ounces = 1 pound.) GRAIN COST PER PRODUCT POUND ($) PROTEIN(%) CARBOHYDRATE (%) FAT(%) 0,45 0,38 0,27 A B 62 55 36 5 10 20 3 2 1