William works for a nationwide real estate agency. he uses the agency's website to promote the latest homes. he uses access to store information concerning the home and excel to analyze the data. fall open houses include homes in seattle, chicago, and denver. spring open houses include tours of homes in washington,

d. c., new mexico, alaska, and montana. summer home tours include paris, rome, denmark, and australia. william wants excel to automatically refresh the connection between his excel workbook and his access database whenever the workbook is opened. he should click the refresh data when opening the file check box in the connection properties dialog box. what steps should he take to open the connection properties dialog box?

Jamie lee is reviewing her finances one month later. she has provided the actual amounts paid below. use the cash budget table below to her identify the variances in her budget. each answer must have a value for the assignment to be complete. enter "0" for any unused categories. actual amounts income: monthly expenses: gross monthly salary $2,315 rent obligation $260 net monthly salary $1,740 utilities/electricity $130 savings allocation: utilities/water $10 regular savings $130 utilities/cable tv $155 rainy-day savings $20 food $160 entertainment: gas/maintenance $205 cake decorating class $90 credit card payment $25 movies with friends $50 car insurance $75 clothing $145 budgeted amounts assets: monthly expenses: checking account $1,850 rent obligation $225 emergency fund savings account $4,300 utilities/electricity $75 car $5,200 utilities/water $35 computer & ipad $1,100 utilities/cable tv $120 liabilities: food $115 student loan $6,600 gas/maintenance $95 credit card balance $1,000 credit card payment $45 income: car insurance $45 gross monthly salary $2,155 clothing $45 net monthly salary $1,580 entertainment: savings allocation: cake decorating class $90 regular savings $130 movies with friends $50 rainy day savings $20

At a student café, there are equal numbers of two types of customers with the following values. the café owner cannot distinguish between the two types of students because many students without early classes arrive early anyway (i.e., she cannot price-discriminate). students with early classes students without early classes coffee 70 60 banana 51 101 the marginal cost of coffee is 10 and the marginal cost of a banana is 40. the café owner is considering three pricing strategies: 1. mixed bundling: price bundle of coffee and a banana for 161, or just a coffee for 70. 2. price separately: offer coffee at 60, price a banana at 101. 3. bundle only: coffee and a banana for 121. do not offer goods separately. assume that if the price of an item or bundle is no more than exactly equal to a student's willingness to pay, then the student will purchase the item or bundle. for simplicity, assume there is just one student with an early class, and one student without an early class. price strategy revenue from pricing strategy cost from pricing strategy profit from pricing strategy 1. mixed bundling $ $ $ 2. price separately $ $ $ 3. bundle only $ $ $ pricing strategy yields the highest profit for the café owner.

Colter steel has $5,550,000 in assets. temporary current assets $ 3,100,000 permanent current assets 1,605,000 fixed assets 845,000 total assets $ 5,550,000 assume the term structure of interest rates becomes inverted, with short-term rates going to 10 percent and long-term rates 2 percentage points lower than short-term rates. earnings before interest and taxes are $1,170,000. the tax rate is 40 percent earnings after taxes = ?