Prepare the lp model which allows kevin to maximize his

Reference no: EM13389786

Kevin Smith received a welcome surprise in this management science class; the instructor has decided to let each person define the percentage contribution to their grade for each of the graded instruments used in the class. These instruments were: homework, an individual project, a mid-term exam, and a final exam. Kevin's grades on these instruments were 75, 94, 85, and 92, respectively. However, the instructor complicated Kevin's task somewhat by adding the following stipulations:

homework can account for up to 25% of the grade, but must be at least 5% of the grade;

the project can account for up to 25% of the grade, but must be at least 5% of the grade;

the mid-term and final must each account for between 10% and 40% of the grade but cannot account for more than 70% of the grade when the percentages are combined; and

the project and final exam grades may not collectively constitute more than 50% of the grade.

a) Formulate an LP model that allows Kevin to maximize his numerical grade.

b) Create a spreadsheet model for this problem and solve it using Solver.

c) What is the optimal solution?

Use Solver to create a Sensitivity Report and answer the following questions:

d) Is there anything Kevin can request of his instructor to improve his final grade ?(Hint, for example he may ask the instructor to increase or/and decrease the weights of certain graded instruments)

e) Kevin has been approved by his instructor to increase the total weight allowed for the project and final exam by 5%. What will his new final grade score be?

Reference no: EM13389786

Questions Cloud

Draw aggregate expenditure ae curve and point out : in an economy in which government expenditure is 100 billion exports are 60 billion imports are 15 percent of real gdp

Gaap provides guidelines for inclusion of interest in : gaap provides guidelines for the inclusion of interest in the initial cost of a self-constructed asset.required1. what

Coogly company is attempting to determine its weighted : coogly company is attempting to identify its weighted average cost of capital for the coming year and has hired you to

Every time the order is placed for more item x it costs 10 : item x is a standard item stocked in a companys inventory of component parts. each year the firm on a random basis uses

Prepare the lp model which allows kevin to maximize his : kevin smith received a welcome surprise in this management science class the instructor has decided to let each person

As the partner in charge of audits at dewey wright and : as the partner in charge of audits at dewey wright and moore you have decided to accept av imports and exports as a new

Instead of the increase in the profit coefficient x1 to 3 : consider the following lp problem developed at jeff spencers san antonio optical scanning firmmaximize profit 1 x1 1

Describe the concept of depreciation which of the : a variety of depreciation methods are used to allocate the cost of an asset to all of the accounting periods benefited

It is the controllers belief that the switch in inventory : the controller of sagehen enterprises believes that the company should switch from the lifo method to the fifo method.

User Account

All Pages