Question: Use excel (GRAPHICAL SOLUTION) and Excel Solver to solve this problem. A poultry raiser wants to mix two types of grain: A and B :

Use excel (GRAPHICAL SOLUTION) and Excel Solver to solve this problem.

A poultry raiser wants to mix two types of grain:A and B: Each grain of A cost P40.00 and contains 20 grams offat, 10 grams of protein and 800 calories. Each unit of grain B costP48.00 and contains30 grams of fat, 30 grams of protein and 600 calories.

Suppose the poultry raiser wants each unit of the final product to yield at least180 grams offat, at least120 gramsofprotein and at least 4800 calories. How many unit of each type of grain should the poultry raiser use to minimize his cost?

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!

Formulate a Linear Program Model: A poultry raiser wants to mix two types of grain: A and B. Each unit of grain A costs Php 40 and contains 20 grams of fat, 10 grams of protein, and 800 calories....

Here is the new homework question. Please review the General Homework instructions due to the instructor being so strict. Were there any podcasts or Homework document notes that you needed me to...

Hi Erylee88, I would like to utilize your service again. Same format different questions. Please find attached document for your review. Let me know. Thank you, Sam...

Each of the following passages may be plausibly criticized by some who conclude that it contains a fallacy, but each may be defended by some who deny that the argument is fallacious. Discuss the...

On March 31, 2018, Susquehanna Insurance purchased an office building for $12,000,000. Based on their relative fair values, one-third of the purchase price was allocated to the land and two-thirds to...

Modify the matrices Y 11 , Y 12 Y 11 , Y 12 , and Y 22 Y 22 determined in Problem 11.22 for (a) the case when circuit breakers B32 and B51 open to remove line 3-5; and (b) the case when the load P L...

When Sandra drives back home from work, she has to pass through two sets of traffic lights. The probability that she has to stop at the first is 0.35, while the probability that she has to stop at...

At the beginning of the school year, Priscilla Wescott decided to prepare a cash budget for the months of September, October, November, and December. The budget must plan for enough cash on December...

Molander Corporation is a distributor of a sun umbrella used at resort hotels Data concerning the next month's budget appear below: Selling price per unit Variable expense per unit Fixed expense per...

The Green Bank originates a pool of containing 100 30-year fixed-rate mortgages with loan amount of $250,000 each.All mortgages in the pool carry a rate of 6.5% with monthly payments. The servicing...

What are the maximum likelihood estimates for o and B in the distribution. Px(x) = 1 B-a ,axs B What are the maximum likelihood estimates for and in the distribution Px(x) I rr

Employees at a large manufacturer are surprised to find that cameras have been installed throughout the plant and all email communications are being monitored. Many are concerned about privacy and...

Compute Wynn Memorial Nursing Home's days in accounts receivable. Compute Wynn Memorial Nursing Home's average payment period. Balance Sheet for Wynn Memorial Nursing Home Wynn Memorial Nursing Home...

10. Three polarizing disks have planes that are parallel and centered on a common axis. The direction of the transmission axis (dashed line) in each case is shown relative to the common vertical...

Read the following passage: "Mary had been asking her neighbor to repair the fence on his goat pen all summer, but he'd only laughed at her and insisted the animals could not get out. So she was...

A machine costing $209,000 with a four-year life and an estimated $17,000 salvage value is installed in Luther Company's factory on January 1. The factory manager estimates the machine will produce...

Janette is concerned that the front desk employees might not be ringing things up correctly. She also mentioned that there were outstanding insurance claims that have not been processed. These issues...

On March 31, 2018, Gardner Corporation received authorization to issue $30,000 of 9 percent, 30-year bonds payable. The bonds pay interest on March 31 and September 30. The entire issue was dated...

Intermediate Products Ltd produces four types of water pump. Two of these (A and B) are sold by the business. The other two (C and D) are incorporated, as components, into another of the businesss...

Deduce the full (absorption) cost of a unit of output in a multi-product environment. AppendixLO1

Gandhi Ltd renders a promotional service to small retailing businesses. There are three levels of service: the 'basic', the 'standard' and the 'comprehensive'. On the basis of past experience, the...