Consider the data in Table 1. Table 1: Economy-wide Product…

Consider the data in Table 1. Table 1: Economy-wide Product and Prices by Year Item 2005 Price 2005 Quantity 2006 Price  2006 Quantity Apples $2.00 10 $2.25 12 Oranges $3.00 10 $3.50 8   Assuming that production in both years consisted entirely of apples and oranges, the nominal GDP growth rate between 2005 and 2006 was:

Question F10 – Use Excel File F10 for your answer. A typical…

Question F10 – Use Excel File F10 for your answer. A typical electric car dealer places new orders with the manufacturer in September. Jake’s car dealer is trying to determine how many model 2024 cars to order. Each car ordered in September costs $45,000. The demand for the new electric cars has the following probability distribution. Each car sells for $54,000. If the demand for 2024 cars exceeds the number of cars ordered in September, Jake must reorder at a cost of $50,000 per car. Excess electric cars can be salvaged at $39,000 per car. ​ Cars demand Probability 25 0.25 30 0.20 35 0.15 40 0.20 45 0.20   Assume Jake orders 60 cars in September. What is Jake’s average profit? Please build a simulation model to answer this question. Please complete and upload this partial template:  F_2023_Excel F10.xlsx 

Question F15 – Use Excel File F15 for your answer. Suppose D…

Question F15 – Use Excel File F15 for your answer. Suppose Dr. N invests 25% of his hard-earned cash in four stocks, Apple, Microsoft, Tesla, and Costco. The following table shows the mean and standard deviation of each stock’s annual return.   Distributions of Returns   Mean Standard Deviation Apple 16% 21% Microsoft 12% 13% Tesla 25% 38% Costco 18% 20%   The correlations between the annual returns on the four stocks are as follows.   Correlation Matrix   Apple Microsoft Tesla Costco Apple 1 0.75 – 0.7 0.2 Microsoft 0.75 1 -0.2 0.5 Tesla -0.7 -0.2 1 0.65 Costco 0.2 0.5 0.65 1   ​You can assume that he has invested equal amounts in each of these stocks. Also it is safe to assume lognormal distribution for each of the stock returns. Use the above simulation model to estimate the probability that Dr. N’s portfolio will lose money in one year. Please complete and upload this partial template: F_2023_Excel F15.xlsx 

A grocery store sells fresh produce, and its daily demand fo…

A grocery store sells fresh produce, and its daily demand follows a Poisson distribution with a mean of 40 units per day. The ordering lead time follows a triangular distribution with a minimum of 1 day, most likely of 2 days and a maximum of 4 days, meaning that lead times are uncertain. Reminder: lead time is the time between ordering and order arrival.  The store follows an inventory policy where it reorders 200 units when inventory drops below 100 units. Simulate the inventory system over a 60-day period to estimate the probability of a stockout (having zero inventory before a replenishment arrives). You need to create a template yourself for this problem. Rename it under your name before submitting it.

Question F13 – Use Excel File F13 for your answer. Suppose D…

Question F13 – Use Excel File F13 for your answer. Suppose Dr. N invests 25% of his hard-earned cash in four stocks, Apple, Microsoft, Tesla, and Costco. The following table shows the mean and standard deviation of each stock’s annual return.   Distributions of Returns   Mean Standard Deviation Apple 16% 21% Microsoft 12% 13% Tesla 25% 38% Costco 18% 20%   The correlations between the annual returns on the four stocks are as follows.     Correlation Matrix   Apple Microsoft Tesla Costco Apple 1 0.75 – 0.7 0.2 Microsoft 0.75 1 -0.2 0.5 Tesla -0.7 -0.2 1 0.65 Costco 0.2 0.5 0.65 1   You can assume that he has invested equal amounts in each of these stocks. Also it is safe to assume lognormal distribution for each stock return. Build a simulation that outputs this portfolio’s return. Please complete and upload this partial template: F_2023_Excel F13.xlsx

Question F14 – Use Excel File F14 for your answer. Suppose D…

Question F14 – Use Excel File F14 for your answer. Suppose Dr. N invests 25% of his hard-earned cash in four stocks, Apple, Microsoft, Tesla, and Costco. The following table shows the mean and standard deviation of each stock’s annual return.   Distributions of Returns   Mean Standard Deviation Apple 16% 21% Microsoft 12% 13% Tesla 25% 38% Costco 18% 20%   The correlations between the annual returns on the four stocks are as follows.   Correlation Matrix   Apple Microsoft Tesla Costco Apple 1 0.75 – 0.7 0.2 Microsoft 0.75 1 -0.2 0.5 Tesla -0.7 -0.2 1 0.65 Costco 0.2 0.5 0.65 1   ​You can assume that he has invested equal amounts in each of these stocks. Also it is safe to assume lognormal distribution for each of the stock returns. Use the above simulation model to estimate the probability that Dr. N’s portfolio’s annual return will exceed 22%. Please complete and upload this partial template:  F_2023_Excel F14.xlsx