Express the model in algebraic form on the spreadsheet

Assignment Help Operation Management

Reference no: EM132112084

Bob Jones has 600 acres of land for planting soybeans and flax. The profit is $179 per acre for flax and $252 per acre for soybeans. It takes Bob 3 days to fertilize an acre of soybeans and 2 days to fertilize an acre of flax, and there are 312 days per year available for fertilizing. In addition, it takes Bob 0.5 days to harvest an acre of soybeans and 0.3 days to harvest an acre of flax, and there are 60 days per year available for picking.

• Model the problem on an Excel spreadsheet using best practices discussed in class

• Express the model in algebraic form on the spreadsheet.

• Identify the type of linear programming model represented by this problem

• Use Solver to find the optimal solution.

Reference no: EM132112084

Questions Cloud

Advertising agencies compensated by traditional commission : What are the advantages and disadvantages for the client of having advertising agencies compensated by the traditional commission?

Evc and break-even analysis : A homeowner has asked a local real estate agent for advice on the price he should set for his house.

The primary drivers of cisco acquisition strategy : Of the “Reasons for Acquisitions” section in the chapter, which reasons are the primary drivers of Cisco’s ’ acquisition strategy?

When should advertiser try to build primary demand : When should an advertiser try to build primary demand and when should it focus on building selective demand?

Express the model in algebraic form on the spreadsheet : Bob Jones has 600 acres of land for planting soybeans and flax. Express the model in algebraic form on the spreadsheet.

Types of research designs-exploratory-descriptive and causal : The marketing research company for which you work has two projects. Explain why each of the three types of research designs-exploratory, descriptive and causal

Two elements can be easily incorporated into linear program : Which of the above two elements two elements can be easily incorporated into a linear program formulation and how.

What are the threats in the external environment : Write a report on the company United Parcel Service (UPS) on what are the threats in the external environment that may adversley affect its performance.

Describe what the feasible region represents : Describe what the feasible region represents when graphically representing a linear programming model.

User Account

All Pages