If you had data in a spreadsheet and you wanted to make a large section of a spreadsheet empty, you would . click on each cell and press Delete and Enter click on each cell and press Delete and Enter highlight the section and use the clear command highlight the section and use the clear command highlight the section and press Backspace highlight the section and press Backspace start a new spreadsheet start a new spreadsheet

Exercise 18-15 sheffield appliance center is an experienced home appliance dealer. sheffield appliance center also offers a number of services for the home appliances that it sells. assume that sheffield appliance center sells ovens on a standalone basis. sheffield appliance center also sells installation services and maintenance services for ovens. however, sheffield appliance center does not offer installation or maintenance services to customers who buy ovens from other vendors. pricing for ovens is as follows. oven only $790 oven with installation service 850 oven with maintenance services 970 oven with installation and maintenance services 990 in each instance in which maintenance services are provided, the maintenance service is separately priced within the arrangement at $180. additionally, the incremental amount charged by sheffield appliance center for installation approximates the amount charged by independent third parties. ovens are sold subject to a general right of return. if a customer purchases an oven with installation and/or maintenance services, in the event sheffield appliance center does not complete the service satisfactorily, the customer is only entitled to a refund of the portion of the fee that exceeds $790. assume that a customer purchases an oven with both installation and maintenance services for $990. (b) indicate the amount of revenue that should be allocated to the oven, the installation, and to the maintenance contract.

Thomas kratzer is the purchasing manager for the headquarters of a large insurance company chain with a central inventory operation. thomas's fastest-moving inventory item has a demand of 6,000 units per year. the cost of each unit is $100, and the inventory carrying cost is $10 per unit per year. the average ordering cost is $30 per order. it takes about 5 days for an order to arrive, and the demand for 1 week is 120 units. (this is a corporate operation, and the are 250 working days per year.)a) what is the eoq? b) what is the average inventory if the eoq is used? c) what is the optimal number of orders per year? d) what is the optimal number of days in between any two orders? e) what is the annual cost of ordering and holding inventory? f) what is the total annual inventory cost, including cost of the 6,000 units?

Blue computers, a major pc manufacturer in the united states, currently has plants in kentucky and pennsylvania. the kentucky plant has a capacity of 1 million units a year and the pennsylvania plant has a capacity of 1.5 million units a year. the firm divides the united states into five markets: northeast, southeast, midwest, south, and west. each pc sells for $1,000. the firm anticipates a 50 perc~nt growth in demand (in each region) this year (after which demand will stabilize) and wants to build a plant with a capacity of 1.5 million units per year to accommodate the growth. potential sites being considered are in north carolina and california. currently the firm pays federal, state, and local taxes on the income from each plant. federal taxes are 20 percent of income, and all state and local taxes are 7 percent of income in each state. north carolina has offered to reduce taxes for the next 10 years from 7 percent to 2 percent. blue computers would like to take the tax break into consideration when planning its network. consider income over the next 10 years in your analysis. assume that all costs remain unchanged over the 10 years. use a discount factor of 0.1 for your analysis. annual fixed costs, production and shipping costs per unit, and current regional demand (before the 50 percent growth) are shown in table 5-13. (a) if blue computers sets an objective of minimizing total fixed and variable costs, where should they build the new plant? how should the network be structured? (b) if blue computers sets an objective of maximizing after-tax profits, where should they build the new plant? how should the network be structured? variable production and shipping cost ($/unit) annual fixed cost northeast southeast midwest south west (million$) kentucky 185 180 175 175 200 150 pennsylvania 170 190 180 200 220 200 n. carolina 180 180 185 185 215 150 california 220 220 195 195 175 150 demand ('000 units/month) 700 400 400 300 600