Determine how the company can meet the goal

Assignment Help Mathematics
Reference no: EM131644079

Question: A manufacturing company makes two products. Each product can be made on either of two machines. The time (in hours) required to make each product on each machine is listed in the file P13_33.xlsx. Each month, 500 hours of time are available on each machine. Each month, customers are willing to buy up to the quantities of each product at the prices also given in the same file. The company's goal is to maximize the revenue obtained from selling units during the next two months.

a. Determine how the company can meet this goal. Assume that it will not produce any units in a month that it cannot sell in that month.

b. Use Solver Table to see what happens if customer demands for each product in each month simultaneously change by a factor 1+ k. Revise the model so that you can use Solver Table to investigate the effect of this change on total revenue as k varies from - 0.3 to 0.3 in increments of 0.1. Does revenue change in a linear manner over this range? Can you explain intuitively why it changes in the way it does?

Reference no: EM131644079

Questions Cloud

How to minimize the net cost incurred in meeting the demands : Determine how to minimize the net cost incurred in meeting the demands for the next four months.
Determine acquisition costs of land : Instructions - Indicate to which account Adama would debit each of the costs. Determine acquisition costs of land
How the optimal dessert plan varies : Use a two-way Solver table to see how the optimal dessert plan varies when the calories per snack bar and per ice cream vary.
Determine how the company can maximize its revenue : A furniture company manufactures tables and chairs. Each table and chair must be made entirely out of oak or entirely out of pine.
Determine how the company can meet the goal : Determine how the company can meet this goal. Assume that it will not produce any units in a month that it cannot sell in that month.
Investigate the effects of the minimal reductions : Use Solver Table to investigate the effects of increases in the minimal reductions required by the state. Specifically, see what happens to the amounts.
Solving problem related to the two types of trucks : A company manufactures two types of trucks. Each truck must go through the painting shop and the assembly shop. If the painting shop were completely devoted.
Discuss the changes in the selling prices of models : Discuss the changes in the selling prices of either or both models that would be necessary to make this corner point optimal.
Compare the optimal integer solution to noninteger solution : How does the optimal integer solution compare to the optimal noninteger solution in given problem? Are the changing cell values rounded versions.

Reviews

Write a Review

Mathematics Questions & Answers

  Writing a number set in builder notation form

This question is from Mathematics as well as it is about writing a number set in builder notation form.

  Second order differential equation

Convert the nonlinear, second order differential equation to the first order system and solve the differential equation

  Design a binary finite state automaton to accept strings

Your task is to design a binary finite state automaton (FSA) to accept all strings that represent valid messages (for your particular codes and parity property) and reject all others. This FSA must be DETERMINISTIC, REDUCED and must be in STANDARD..

  Find the function that describes the population of lubbock

Assuming exponential growth, find the function P(t) that describes the population of Lubbock, letting 1970 be time zero.

  What is the highest possible revenue

If we set the price of a ticket to $20, we can sell 600 tickets. If we raise the price by x dollar, 4x less people will buy the ticket. What is the highest possible revenue that we can obtain.

  Determine how graph theory has advanced the knowledge

Examine how these applications are being used in your specialization and determine how graph theory has advanced the knowledge in your area of specialization.

  Determine how long the bus traveled at each rate

a bus traveled at an average rate of 40 mile per hour and then reduced its average rate to 30 miles per hour for the rest of the trip. If 204-mile trip took 6 hours, determine how long the bus traveled at each rate.

  Write down the integral which gives the length of the curve

Write down the integral which gives the length of this curve. Simplify the integrand, but do not calculate the integral. Construct the integral which will compute the average temperature between 9 am and 9 pm.

  Find the intersection points of the curve

Use Newton's method to find the intersection points of the curve y = cos(x) and the circle of unit radius centred at (x, y) = (0.4, 1.7) correct to 3 decimal places.

  Moving headquarters overseas

A major MNE has incredible knowledge resources but they are often underutilized. The reason: often the knowledge that is needed within one part of the organization exists within that organization but normally there is no system by which those who ..

  Explain what the statement tells us about the rock

A rock is dropped from a window and falls to the ground below. The height, s (in meters), of the rock above ground is a function of the time, t (in seconds).

  Compare the utilization rates for both tom and jane

Compare the time that an average customer spends waiting in line for both Tom and Jane. Compare the utilization rates for both Tom and Jane.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd