Recently your car has begun to have some maintenance issues, so you decide to do some initial research into buying a replacement car. You find a great website that has pricing and efficiency data
for a large variety of used vehicles made in the years 2013-2017. You are wondering which auto
manufacturer offers the lowest maintenance costs for 2017 vehicles. Follow the steps to create a
more refined way to view and sort through the data you found on a car-pricing website in order to
make a buying decision.
Once your data formatted in a uniform manner and is easy to read, turn the data into a
table in a new tab.
2
Add a new column named Lowest to the right of the 2017 column that calculates the
lowest price for each model across the five years.
4
3
In a new worksheet Pivot Table, create a Pivot Table report to analyze the lowest prices
of each manufacturer and model by year.
4
Properly format values and column headings if they require adjustment.
5
5
You recently read an article that said cars with an efficiency rating of 3 are the most
cost efficient (have the lowest maintenance costs) in the long run. Adjust your report so
that you are only shown totals for cars with this rating. (Hint: add a report filter)
Sort the most recent data to determine which model/manufacturer is the best to start
with in order to keep maintenance costs low. Highlight your answer.
6
7
Now that you know which manufacturer to start with, go back to the Data tab and copy
the data from the best manufacturer into a new tab.
8
Create a new pivot table with the most recent cost data and determine which model of
car you should consider buying to meet your objective.
9
9
Highlight your result
10

Uppose that the federal reserve purchases a bond for $100,000 from donald truck, who deposits the proceeds in the manufacturer’s national bank. what will be the impact of this purchase on the supply of money? the money supply will increase by $100,000. the money supply will increase by $80,000. the money supply will increase by $500,000. this action will have no effect on the money supply. if the reserve requirement ratio is 20 percent, what is the maximum amount of additional loans that the manufacturer’s bank will be able to extend as the result of truck’s deposit? the maximum additional loans is $100,000. the maximum additional loans is $80,000. the maximum additional loans is $20,000. the maximum additional loans is $500,000. given the 20 percent reserve requirement, what is the maximum increase in the quantity of checkable deposits that could result throughout the entire banking system because of the fed’s action? this action will have no effect on the money supply. the money supply will eventually increase by $80,000. the money supply will eventually increase by $500,000. the money supply will eventually increase by $100,000.

Explain whether each of the following events increases or decreases the money supply. a. the fed buys bonds in open-market operations. b. the fed reduces the reserve requirement. c. the fed increases the interest rate it pays on reserves. d. citibank repays a loan it had previously taken from the fed. e. after a rash of pickpocketing, people decide to hold less currency. f. fearful of bank runs, bankers decide to hold more excess reserves. g. the fomc increases its target for the federal funds rate.

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