Scribd Logo
Upload

Welcome to Scribd!

  • 3 views

    Semifinals Quintana

    Uploaded by

    quintanamarfrancis

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd

    Semifinals Quintana

    Uploaded by

    quintanamarfrancis
    3 views6 pages

    Copyright

    © © All Rights Reserved

    Available Formats

    XLSX, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd
    Download as xlsx, pdf, or txt
    3 views6 pages

    Semifinals Quintana

    Uploaded by

    quintanamarfrancis

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd
    Download as xlsx, pdf, or txt
    You are on page 1of 6

    FitCare Fitness Center

    Products: Egg Bacon Oatmeal Milk Wheat toast


    Cost per unit: 0.1 0.12 0.1 0.16 0.07 Resources:
    Resources: Usage
    Calories 75 43
    Calcium 30 15
    Protein 7 3
    Fiber 0 0
    Fat 5 3.3
    Cholesterol 270 8.8

    Production:
    Egg
    Bacon
    Oatmeal
    Milk
    Wheat toast
    Cost:
    Resources:
    Constraints Available Left over
    Microsoft Excel 16.0 Answer Report
    Worksheet: [SEMIFINALS.xlsx]Problem B (3)
    Report Created: 30 Sep 2024 9:43:36 pm
    Result: Solver found a solution. All Constraints and optimality conditions are satisfied.
    Solver Engine
    Engine: Simplex LP
    Solution Time: 0.093 Seconds.
    Iterations: 0 Subproblems: 0
    Solver Options
    Max Time Unlimited, Iterations Unlimited, Precision 0.000001
    Max Subproblems Unlimited, Max Integer Sols Unlimited, Integer Tolerance 1%, Assume NonNegative

    Objective Cell (Max)


    Cell Name Original Value Final Value
    $B$18 Total Exposures = Televising Commercials 185000 185000

    Variable Cells
    Cell Name Original Value Final Value Integer
    $B$15 Television Commercials Televising Commercials 0 0 Contin
    $B$16 Radio Commercials Televising Commercials 0 0 Contin
    $B$17 Newspaper ads Televising Commercials 0 0 Contin

    Constraints
    Cell Name Cell Value Formula Status
    $E$10 Total ads and Commercials Actual 15 $E$10<=$G$10 Binding
    $E$7 TV Commercials Actual 1.8181 $E$7<=$G$7 Not Binding
    $E$8 Radio Commercials Actual 10 $E$8<=$G$8 Binding
    $E$9 Newspaper ads Actual 3.182 $E$9<=$G$9 Not Binding
    Slack
    0
    2.1819
    0
    3.818
    FitCare Fitness Center

    Type of Advertising: Televising Commercials Radio Commercials


    Exposure needed: 20000 12000
    Cost per unit: 15000 6000
    Resources:
    TV Commercials 1.8181 0
    Radio Commercials 0 10
    Newspaper ads 0 0
    Total ads and Commercials 1.8181 10
    Budget

    Production:
    Television Commercials 0
    Radio Commercials 0
    Newspaper ads 0
    Total Exposures = 185000
    Fitness Center

    Newspaper ads
    9000
    Resources:
    4000
    Actual Constraints Available Left over
    0 1.8181 <= 4 2.1819
    0 10 <= 10 0
    3.182 3.182 <= 7 3.818
    3.182 15 <= 15 0
    100000 <= 100000 0

    You might also like