Mat 540 week 8 assignment – julia’s food booth – text & excel solver


Week 8 Assignment 1 Submission

 

Click the combine overhead to resign your consignment.

Students, gladden examination the "Submit a Clickable Rubric Assignment" in the Student Center.

Instructors, inoculation on how to pace is amid the Educator Center.

Assignment 1. Direct Programming Instance Study

Your educator get consign a direct programming contrivance for this consignment according to the forthcoming specifications.

It get be a collection after a while at smallest three (3) aggrievets and at smallest two (2) conclusion unsteadys. The collection get be restricted and contrivable. It get as-polite keep a unique optimum discerption (in other utterance, it won’t keep fluctuate optimal discerptions). The collection get as-polite conceive a content that involves sensitivity separation and the use of the image value.

You get be transforming in two (2) deliverables, a near transcribeup of the contrivance and the spreadsheet showing your production.

Writeup.

Your transcribeup should begin your discerption to the contrivance by describing the collection. Correctly fulfill what image of collection this is. For illustration, you should music if the collection is a maximization or minimization collection, as polite as fulfill the media that aggrieve the discerption. Fulfill each unsteady and expound the criteria implicated in setting up the design. This should be encapsulated in one (1) or two (2) compendious sections.

After the preparatory section, transcribe out the L.P. design for the collection. Conceive the extrinsic operation and all aggrievets, including any non-negativity aggrievets. Then, you should offer the optimal discerption, fixed on your production in Excel. Expound what the results medium.

Finally, transcribe a section addressing the distribute of the collection pertaining to sensitivity separation and image value.

Excel.

As previously musicd, gladden set up your collection in Excel and invent the discerption using Solver. Clearly label the cells in your spreadsheet. You get transform in the full spreadsheet, showing the setup of the design, and the results.

Click here to examination the grading rubric for this consignment.

Complete the "Julia's Food Booth"instance collection on page 109 of the passage. Address each of the issues A-D according the instructions dedicated.

Formulate and rerework-out an L.P. design for this instance.

Evaluate the probability of borrowing capital antecedently the earliest diversion.

Evaluate the probability of paying a ally $100/diversion to succor.

Analyze the application of uncertainties on the design.

 

Week 8 Assignment 1:

 

        Assignment #1: Instance Collection "Julia's Food Booth" 

Complete the "Julia's Food Booth" instance collection on page 109 of the passage. Address each of the issues A - D according the instructions dedicated.

 

·         (A) Formulate and rerework-out an L.P. design for this instance.

 

·         (B) Evaluate the probability of borrowing capital antecedently the earliest diversion.

 

·         (C) Evaluate the probability of paying a ally $100/diversion to succor.

 

·         (D) Analyze the application of uncertainties on the design.

 

Your transcribe up should begin your discerption to the contrivance by describing the collection. Correctly fulfill what image of collection this is. For illustration, you should music if the collection is a maximization or minimization collection, as polite as fulfill the media that aggrieve the discerption. Fulfill each unsteady and expound the criteria implicated in setting up the design. This should be encapsulated in one (1) or two (2) compendious sections.

 

After the preparatory section, transcribe out the L.P. design for the collection. Conceive the extrinsic operation and all aggrievets, including any non-negativity aggrievets. Then, you should offer the optimal discerption, fixed on your production in Excel. Expound what the results medium.

  

Finally, transcribe a section addressing the distribute of the collection pertaining to sensitivity separation and image value.