Instruction: Answer the following systematically. Strictly follow the format of the solution (Example problem + complete solution is provided in the photos below). I WON'T LIKE YOUR ANSWER IF IT IS NOT PROPERLY FOLLOWED AND INCORRECT)A small generator burns two types of fuel – low sulfur and high sulfur – to produce electricity. For one hour, each gallon of low sulfur emits 3 units of sulfur dioxide, generates 4 kilowatts electricity, and cost P600. Each gallon of high sulfur emits 5 units of sulfur dioxide, generates 4 kilowatts, and costs P500. The Environmental Protection Agency insists that the maximum amount of sulfur dioxide that can be emitted per hour is 15 units. Suppose that at least 16 kilowatts must be generated per hour, how many gallons of low sulfur and how many gallons of high sulfur must be utilized per hour to minimize the cost of fuel? Objective: minimize EXAMPLE PROBLEM + SOLUTION(PLEASE FOLLOW THE FORMAT OF HOW TO SOLVE PROPERLY)Four foods X, X, X , and X, are to be purchased. X, contains 2 calories, no vitamin and costs1"2'P40 per piece. X, contains no calorie, 2 units of vitamin and costs Pl00 per piece. X, contains 1unit of calorie, 1 unit of vitamin and costs P120 per piece. X, contains 3 units of calories, 2 unitsof vitamins and costs P150 per piece. The minimum calories required is 18 units and theminimum amount of vitamins is 8 units. How much of each food must be purchased to satisfy thecalorie and vitamin requirements to minimze the cost?C = 40x, + 100x, + 120x, + 150x,2x, + x, + 3x, 2 182x, + x, + 2x, 2 8Minimize:Subject to:*, 2C= 40x, + 100x, + 120x, + 150x, + 0s, + os, + 1000A, + 1000A,2x, + x, + 3x, - S, + A, = 182x, + x, + 2x, - S, + A, = 8Minimize:Subject to:+ A = 8*, S, A 2 0Table 1.4010012015010001000VarQtyX2A,A,1000A,183-11000A,2-126000 20005000 -1000 -10001000200020001000z,-1960-1900-18804850100010002.2. Table 2.C,4010012015010001000VarQtyA,Az1000-3-1/2-13/2-3/215041/2-1/21/2z,200015010006600-2850-425-10001425-1425C, - Z,-196029505451000-14252425Table 3.4010012015010001000VarQty40-3/2-1/4-1/23/41/2-3/41501/2-1/21/2720409065150-20452045z,1055204580955'z -'5Decision:Food X, = 3,Food X, = 0,Food X, = 0,Food X, = 4,Minimum Cost of P720.

Objectives: Minimize Cost = 600x + 500y subject to 3x + 5y <= 15 sulfur constraint…

Answered: A small generator burns two types of…

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...

See similar textbooks

Related questions

Question

100%

Instruction: Answer the following systematically. Strictly follow the format of the solution (Example problem + complete solution is provided in the photos below). I WON'T LIKE YOUR ANSWER IF IT IS NOT PROPERLY FOLLOWED AND INCORRECT)

A small generator burns two types of fuel – low sulfur and high sulfur – to produce electricity. For one hour, each gallon of low sulfur emits 3 units of sulfur dioxide, generates 4 kilowatts electricity, and cost P600. Each gallon of high sulfur emits 5 units of sulfur dioxide, generates 4 kilowatts, and costs P500. The Environmental Protection Agency insists that the maximum amount of sulfur dioxide that can be emitted per hour is 15 units. Suppose that at least 16 kilowatts must be generated per hour, how many gallons of low sulfur and how many gallons of high sulfur must be utilized per hour to minimize the cost of fuel?

Objective: minimize