1. Muna Hsu is an assistant hospitality manager at the Icehouse Arena, home to the Springfield Sharks (the town’s amateur hockey team.) Muna is summarizing two years of sales data from her food vendors. Since each stand supports a different section of the arena, Muna will need to coordinate and consolidate sales data on multiple worksheets. Break the external link that exists in the worksheet, so that the formulas in cells B4, B5, B6, and B7 of the Vendor Information worksheet are replaced with static values. Then switch to the Vendor Information worksheet. 2. Muna wants to update the links in her workbook, so that she’ll be able to quickly pull up the Vendor pricing plans for the 2019-2020 season. In cell B9, create a hyperlink to the Icehouse Arena Vendor Refreshment Price listing for 2019-2020 season as described below: a. The hyperlink should link to the Support_NP_EX16_6a_VendorPrices1920.docx file, available on the SAM website. b. The hyperlink should use 2019-2020 Vendor Refreshment Prices as the text to display. c. The hyperlink should use Click here to view the Vendor Refreshment Price listing for the 2019-2020 season. as the ScreenTip text. 3. Edit the hyperlink Icehouse Arena website in cell B10 as described below: a. The hyperlink should use Icehouse Arena Vendor Website as the display text. b. The hyperlink should use Click here to access the Icehouse Arena Vendor website. as the ScreenTip text. 4. Muna now wishes to give a consistent look and feel to the worksheets submitted by each of the vendor stands. Group the North, East, and South worksheets together and then make the following formatting updates: a. Change the font size in the merged range A1:I1 to 28 pt. b. Apply the Heading 3 cell style to the merged range A2:I2. c. Bold the values in the range A5:A10. d. Apply the Accounting number format with zero decimal places and $ as the symbol to the range B5:I10. (Hint: Depending how you complete this step, the number format for this range may display as Custom.) Do not ungroup the worksheets. 5. With the North, East, and South worksheets still grouped, update the worksheet as described below: a. In cell A7, edit the text to read Shark Bites (instead of Pepperoni Bite). b. In cell A9, edit the text to read Pizza Frenzy (instead of Pizza). Do not ungroup the worksheets. 6. With the North, East, and South worksheets still grouped, select the range B11:H11. Using the AutoSum button, enter a formula using the SUM function that totals the sales for each month of the hockey season (shown in the range B5:H10). Ungroup the worksheets and then check to confirm that the formatting and formulas from steps 4-6 are present in all three worksheets. 7. Muna wants to create a copy of the formatted South worksheet to use for the West section of the arena’s sales data. Create a copy of the South worksheet between the South worksheet and the Consolidated Sales worksheet then update the worksheet as described below: a. Rename the copied worksheet using West as the name. b. In the merged range A2:I2, edit the text to read Feeding Frenzy (instead of Shark Tooth). c. Clear the contents of the range B5:H10. 8. Muna now wishes to consolidate the data from each of the vendor stands. Switch to the Consolidated Sales worksheet. In cell A5, enter a formula without using a function that references cell A5 in the North worksheet. Copy the formula from cell A5 to the range A6:A10 without copying the formatting. 9. In cell B5, enter a formula using the SUM function, 3-D references, and grouped worksheets that totals the values from cell B5 in the North:West worksheets. Copy the formula from cell B5 to the range B6:B10 without copying the formatting. Then copy the formulas and the formatting from the range B5:B10 to the range C5:H10. 10. Muna wants to compare the sales from the 2019-2020 season to the 2018-2019 season and needs to include the missing data. Open the support file Support_NP_EX16_6a_1819VendorSales.xlsx. Switch back to the NP_EX16_6a_FirstLastName_2.xlsx workbook and go to the Consolidated Sales worksheet. Create external references in the Consolidated Sales worksheet to the sales information found in the Support_NP_EX16_6a_1819VendorSales.xlsx workbook as described below: a. Using external cell references, link cell J5 in the Consolidated Sales worksheet to cell H5 in the Consolidated Sales 2018-2019 worksheet in the Support_NP_EX16_6a_1819VendorSales.xlsx workbook. b. Using external cell references, link cell J6 in the Consolidated Sales worksheet to cell H6 in the Consolidated Sales 2018-2019 worksheet in the Support_NP_EX16_6a_1819VendorSales.xlsx workbook. c. Using external cell references, link cell J7 in the Consolidated Sales worksheet to cell H7 in the Consolidated Sales 2018-2019 worksheet in the Support_NP_EX16_6a_1819VendorSales.xlsx workbook. d. Using external cell references, link cell J8 in the Consolidated Sales worksheet to cell H8 in the Consolidated Sales 2018-2019 worksheet in the Support_NP_EX16_6a_1819VendorSales.xlsx workbook. e. Using external cell references, link cell J9 in the Consolidated Sales worksheet to cell H9 in the Consolidated Sales 2018-2019 worksheet in the Support_NP_EX16_6a_1819VendorSales.xlsx workbook. f. Using external cell references, link cell J10 in the Consolidated Sales worksheet to cell H10 in the Consolidated Sales 2018-2019 worksheet in the Support_NP_EX16_6a_1819VendorSales.xlsx workbook. g. Do not break the links.

vendor information

North file

East file

South

Consolidated sales

Suppoort NPX16 6A 1819VENDORSALES.xls

Consolidated Sales 2018 2019

support NP EX16 vendorprices1920.docx

What is the expected output from the following program (3 answers)

______­­ ______namespace std; double insurance(int); void main() { int j; ______ mileage; ______ monthly_rent; for (j=______ j<4; j++) { mileage=1000*j; monthly_rent= 0.3*mileage + insurance(mileage); printf("Monthly rent for %4d.2f is : $ ______ . \n", mileage, monthly_rent); } } double insurance(int miles) { double mileage_charge; if (miles<=1000) { mileage_charge=100.0; }___ if ((miles>1000) && (miles<=2000)) { mileage_charge=150.0; }; ___ (miles>2000) { mileage_charge=200.0; }; return(mileage_charge);

sara is married and loved all year with her husband and two children. she will filt married filling separately and claim her two children as dependants. her son Glen, born may 1 2010 and her daughter, rona, born December 25 2000 are birth us citizens and did not provide any of their own support. Sara's wages were 40000 and she had no other income. her tax is 2155. Sara's child tax credit is:
a) 2155
b) 2000
c) 0
d) 1000

Consider the following production possibilities schedule for two goods- Tshirts and running shoes:

A) Suppose that this economy is currently producing 1000 running shoes per month (on its ppf). At this allocation what is the opportunity cost of producing 2000 more tshirts. Show the calculaitons

B) What are some differences between a PPF that is curved outward and one that is a straight line? Explain.

Given the following information what is the percentage change in the price of the bonds if interest rates suddenly rise by 3%?

Examine the fiscal policies in place at the start of your specific time period of 2000-2010 in relation to their effects on macroeconomic issues. For instance, consider level of government spending, taxation, subsidies, unemployment benefits, and so on.   

Analyze new fiscal policy actions undertaken by the U.S. government throughout the time period during 2000-2010 by describing their intended effects, using macroeconomic principles to explain the actions.  

Explain the impact of the new fiscal policy actions on individuals and businesses within the economy by integrating the macroeconomic data and principles.

Consider the utility function U(W) = W^0.5 where W = wealth

a) Perform the necessary calculations to demonstrate the order of preference of an investor with this utility function. Order them from most preferred to least preferred.

-Prospect 1: 50% chance of $1000, 50% chance of $2000

-Prospect 2: 25% chance of $500, 25% chance of $2000, 50% chance of $1000

-Prospect 3: $1000 for certain.

b) Explain the meaning of the expression certainty equivalent. (That is, Provide the definition)

c) Calculate the certainty equivalent of prospect 1.

1. Armando's body metabolizes caffeine at a rate of 13.6% per hour (so the amount of caffeine in Armando's body decreases by 13.6% each hour).

a) If Armando consumes a cup of coffee with 82 mg of caffeine in it, how long will it take for Armando's body to metabolize half of the 82 mg of caffeine?

b) If Armando consumes an energy drink with 208 mg of caffeine in it, how long will it take for Armando's body to metabolize half of the 208 mg of caffeine?

c) If Armando consumes a cup of coffee with c mg of caffeine in it, how long will it take for Armando's body to metabolize half of the c mg of caffeine? (Hint: your answer will be a numerical value.)

2. At the beginning of 2000 Cesar's house was worth 230 thousand dollars and Omar's house was worth 120 thousand dollars. At the beginning of 2003, Cesar's house was worth 190 thousand dollars and Omar's house was worth 158 thousand dollars. Assume that the values of both houses vary at an exponential rate.

a) Write a function f that determines the value of Cesar's house (in thousands of dollars) in terms of the number of years t since the beginning of 2000.

b) Write a function g that determines the value of Omar's house (in thousands of dollars) in terms of the number of years t since the beginning of 2000.

c) How many years after the beginning of 2000 will Cesar's and Omar's house have the same value?

Cowboy Corp. is about to expand its operations and they have several projects with various cash flows available in Excel upload file. Each project has an 8-year life and the firm has a cost of capital at 8%. The firm has $15,000 for the expansion and will invest in multiple projects with that capital constraint.

1. Calculate NPV for each project

2. Find the project combination that maximizes total NPV for Cowboy Corp. and calculate total capital spending

3. Find the optimum combination under following constraints; Project A and C can only be invested together and at least one out of Project E, F or G must be invested.

Cowboy Corp. is about to expand its operations and they have several projects with various cash flows available in Excel upload file. Each project has an 8-year life and the firm has a cost of capital at 8%. The firm has $15,000 for the expansion and will invest in multiple projects with that capital constraint.

1. Calculate NPV for each project

2. Find the project combination that maximizes total NPV for Cowboy Corp. and calculate total capital spending

3. Find the optimum combination under following constraints; Project A and C can only be invested together and at least one out of Project E, F or G must be invested.