Jane MacFarlene wants a weekly schedule for two business services, X and Y. Each 'unit' of...

Jane MacFarlene wants a weekly schedule for two business services, X and Y. Each 'unit' of X delivered to customers needs one service package, while each unit of Y uses two of the packages, and Jane has a maximum of 110 packages available a week. Each unit of X and Y needs 10 hours of subcontracted work, and Jane has signed agreements with subcontractors for a weekly minimum of 130 hours and a maximum of 650 hours. Jane knows from market surveys that demand for Y is high, and she will have no trouble selling any number of units. However, there is a maximum demand of 50 units of X, despite a long-term contract to supply 10 units to one customer. The net profit on each unit of X and Y is $2000 and $3000 respectively.

State the objective function mathematically State the constraints mathematically Do not solve problem graphically Setup the model in excel and use solver to determine the optimized solution (please give step by step excel instructions).

Solutions

Expert Solution

MAthematical statement of objective function and constraints is as follows:

Decision variables: Let X and Y represent the number of units of each business service that Jane should plan each week

Objective function: Max Z = 2000X + 3000Y

Constraints:

X + 2Y <= 110

10X + 10Y <= 650

10X + 10Y >= 130

X <= 50

X >= 10

X,Y >= 0

orchestra answered 1 year ago

Next > < Previous

Related Solutions

Weekly production schedules are needed for the manufacture of two products X and Y. Each unit...

Weekly production schedules are needed for the manufacture of two products X and Y. Each unit of X uses one component made in the factory, while each unit of Y uses two of the components, and the factory has a maximum output of 80 components a week. Each unit of X and Y requires 10 hours of subcontracted work and agreements have been signed with subcontractors for a minimum weekly usage of 200 hours and a maximum weekly usage of...

Jane spends all of her $200 weekly income on two goods, X and Y. Her utility...

Jane spends all of her $200 weekly income on two goods, X and Y. Her utility function is given by U(X,Y) = 2XY, If the price of X = $4/ unit and the price of Y = $10 a unit, how much of Y should she buy?

Each unit of good X costs $2, and each unit of good Y costs $2. The...

Each unit of good X costs $2, and each unit of good Y costs $2. The following table contains information on Felix’s utility from goods X and Y. Units of Good X Total Utility of Good X Units of Good Y Total Utility of Good Y (Utils) (Utils) 1 28 1 22 2 54 2 40 3 78 3 52 4 100 4 60 5 120 5 64 Suppose Felix spends a total of $10 on good X and good...

The utility that Jane receives by consuming good X and good Y is given by u(X,Y)...

The utility that Jane receives by consuming good X and good Y is given by u(X,Y) = XY. 5.1) Draw the indifference curve associated with a utility level of 12 and the indifference curve associated with the utility level of 36. 5.2) Suppose that X costs $1 per unit and Y $3 per unit. Jane has $12 to spend on X and Y. Graph the budget line that she faces. 5.3) Derive Jane’s demand functions. What is the utility-maximizing choice...

hypothetically data on weekly family consumption expenditure Y and weekly family income X. Y = 70...

hypothetically data on weekly family consumption expenditure Y and weekly family income X. Y = 70 ,65, 90, 95, 110, 115, 120, 140, 155, 150. AND X = 80, 100, 120, 140, 160, 180, 200, 220, 240, 260. from the data given above ,you are required to obtain the estimates of the regression coefficients,their variances and standard errors, the correlation and coefficient of determination

A consumer has budgeted a total of K100 to spend on two goods, X and Y. She likes to consume a unit of good X in combination with a unit of good Y.

A consumer has budgeted a total of K100 to spend on two goods, X and Y. She likes to consume a unit of good X in combination with a unit of good Y. Any unit of good X that she cannot consume in combination with a unit of good Y is useless. Similarly, any unit of good Y that she cannot consume in combination with good X is useless. If the price of a unit of good X is K5...

A company has recorded data on the weekly sales for its product (y) and the unit...

A company has recorded data on the weekly sales for its product (y) and the unit price of the competitor’s product (x). The data resulting from a random sample of 7 weeks follows. Use Excel’s Regression Tool to answer the following questions. A company has recorded data on the weekly sales for its product (y) and the unit price of the competitor’s product (x). The data resulting from a random sample of 7 weeks follows. Use Excel’s Regression Tool to...

3. A consumer is willing to exchange two units of X for one unit of Y...

3. A consumer is willing to exchange two units of X for one unit of Y if he possesses at least as much X as Y . However, if he possesses more Y than X, then he is willing to exchange one unit of X for one unit of Y . Draw an indifference curve representing these preferences. 4. A consumer likes to eat apples but hates oranges. What can you infer about the MRS of this consumer?

A company has recorded data on the weekly sales for its product (y) ($10), the unit...

A company has recorded data on the weekly sales for its product (y) ($10), the unit price of the competitor's product (x1), and advertising expenditures (x2) ($10). The data resulting from a random sample of 7 weeks follows. Use Excel's Regression Tool to answer the following questions: Week Price Advertising Sales 1 .33 5 20 2 .25 2 14 3 .44 7 22 4 .40 9 21 5 .35 4 16 6 .39 8 19 7 .29 9 15 1....

Let (X, Y ) has a uniform density in the unit circle, i.e., f(x, y) =...

Let (X, Y ) has a uniform density in the unit circle, i.e., f(x, y) = c, x2 + y 2 ≤ 1, for some constant c > 0. • (a) Find E[X]. • (b) Find the conditional pdf of X given Y = y.

Subjects