Question

In: Statistics and Probability

use Excel Solver to answer the following question.You must provide sufficient evidence that you did the...

  • use Excel Solver to answer the following question.You must provide sufficient evidence that you did the work on your own. For example, what equations did you use in your model? How was the excel spread sheet laid out?

    A student at a local university has just completed a decision modeling course. On her assignments, she has earned a 86 on the mid-term, a 94 on the final, a 93 on problem sets, and 85 for participation. She has a unique professor who allows students to determine their own item weights with some restrictions:
    • The participation grade can be no more than 15% of the grade.
    • The midterm must count at least twice as much as the problem set score.
    • Each of the four items must have at least a 10% weight.
    • The weights must sum to 100% and be nonnegative.

Determine the item weights that maximize her score in the course using Solver.

Solutions

Expert Solution

Step 1 : Put the value in the excel sheet has show below.

Step 2 : take note of the formula used in each cell.

Step 3 : go to solver

Step 4 : Update the values and constraints as shown

Step 5: final output

orchestra answered 1 year ago
Next > < Previous

Related Solutions

Use the Excel Solver to answer the following questions. The owners of the appliance store want...
Use the Excel Solver to answer the following questions. The owners of the appliance store want to spend up to $250,000 on buying new stock. They need to buy at least 100 of each appliance. The prices of buying appliances and the profits derived from selling them are shown in the following table, along with the floor area the devices require when stacked in the warehouse. Appliance Price Profit Area (m2) Clothes dryer $200 $21 1.2 Coffee machine $300 $28...
Create a model and use Excel Solver to answer the following: A computer company manufactures two...
Create a model and use Excel Solver to answer the following: A computer company manufactures two types of computers. Each type of computer will require assembly time, inspection time, and storage space. The amounts of each of these resources that can be devoted to the production of the computers is limited. The manager wants to determine the quantity of each computer to produce to maximize the profit generated by sales of these computers. In order to develop a suitable model...
Unless you have sufficient evidence otherwise, you must assume that: Group of answer choices both the...
Unless you have sufficient evidence otherwise, you must assume that: Group of answer choices both the null and alternative hypotheses are true the alternative hypothesis is true neither the null nor alternative hypotheses are true the null hypothesis is true Question 2 Which of the following refers to the group you wish to generalize your results to? Group of answer choices population sample sampling error general group Question 3 If there is no difference between sample and population values, you...
Can you provide solution in the Excel using Solver for the below problem ? On Monday...
Can you provide solution in the Excel using Solver for the below problem ? On Monday morning, you have $3000 in cash on hand. For the next seven days, the following cash requirements must be met: Monday, $5000; Tuesday, $6000; Wednesday, $9000; Thursday, $2000; Friday, $7000; Saturday, $2000; Sunday, $3000. At the beginning of each day, you must decide how much money (if any) to withdraw from the bank. It costs $10 to make a withdrawal of any size. You...
Exercise 1 Construct an amortization table in Excel to answer the following questions. You must use...
Exercise 1 Construct an amortization table in Excel to answer the following questions. You must use the corresponding Excel financial formulas whenever possible. Upon graduation, Federico Hernández, borrows $20,000 to finance a late model used car. The loan is made by a family member who was able to obtain an 8 % annual percent rate (APR). The loan is going to be payback in equal monthly payments over 5 years. a) How much are the monthly payments? b) How many...
(For this part, you MUST present sufficient solution steps, and MUST apply specific Excel functions =NPV(…),...
(For this part, you MUST present sufficient solution steps, and MUST apply specific Excel functions =NPV(…), =IRR(…), =AVERAGE(…), =YIELD(…) whenever applicable). Please show excel formulas. Given the following information for Bajor Co.: Debt: Bajor’s long-term debt capital consists of bonds with 6.250 percent coupon rate (semiannual coupon payments), 9 years time to maturity, and current price of 106.61 percent of its par value (i.e., price = 106.61 relative to full amount redemption par of 100). Preferred stock: Bajor has not...
(For this part, you MUST present sufficient solution steps, and MUST apply specific Excel functions =PV(…),...
(For this part, you MUST present sufficient solution steps, and MUST apply specific Excel functions =PV(…), =FV(…), =PMT(…), =NPER(…), =RATE(…), =PRICE(…) or =YIELD(…) whenever applicable. Please show me the EXCEL functions that was used to help me better understand was equals what. Using Excel finance formulas You apply for a 20-year, fixed-rate (APR 6.48%) monthly-payment-required mortgage loan for a house selling for $150,000 today. Your bank requires 22% initial down payment of house value (to be paid in cash immediately),...
(For this part, you MUST present sufficient solution steps, and MUST apply specific Excel functions =NPV(…),...
(For this part, you MUST present sufficient solution steps, and MUST apply specific Excel functions =NPV(…), =IRR(…), =AVERAGE(…), =YIELD(…) Case Two (22 pts) Given the following information for Bajor Co.: Debt: Bajor’s long-term debt capital consists of bonds with 6.250 percent coupon rate (semiannual coupon payments), 9 years time-to-maturity, and current price of 106.61 percent of its par value (i.e., price = 106.61 relative to full amount redemption par of 100). Preferred stock: Bajor has not issued any preferred stocks....
(For this part, you MUST present sufficient solution steps, and MUST apply specific Excel functions =NPV(…),...
(For this part, you MUST present sufficient solution steps, and MUST apply specific Excel functions =NPV(…), =IRR(…), =AVERAGE(…), =YIELD(…) whenever applicable..) Ferengi, Inc. is subject to an applicable corporate tax rate of 21 percent, and the weighted average cost of capital (WACC) of 12.5 percent. There is no specific time constraint on investment project payback requirements. Q1: Ferengi is currently contemplating two capital investment plans. Plan A: the upgrade of an information system with an installed cost of $2,400,000. The...
(For this part, you MUST present sufficient solution steps, and MUST apply specific Excel functions =PV(…),...
(For this part, you MUST present sufficient solution steps, and MUST apply specific Excel functions =PV(…), =FV(…), =PMT(…), =NPER(…), =RATE(…), =PRICE(…) or =YIELD(…) whenever applicable. Please show me the EXCEL functions that was used to help me better understand was equals what. Using Excel finance formulas Case 3: We find the data for a municipal bond issued by the Illinois state government. The bond’s “last trade date” (i.e., settlement date) is June 05, 2019. The bond’s “maturity date” is March...
ADVERTISEMENT
Subjects
ADVERTISEMENT
Latest Questions
ADVERTISEMENT