代寫essay服務

五年專注悉尼代寫essay 信譽保證
turnitin檢測 保證原創率 高分通過

本公司成立以來,在代寫essay領域獲得了不錯的口碑,98%以上的客戶順利通過..歡迎大家進行咨詢和享受公司為你提供的全方位服務!不論你的essay有多難,deadline有多急,我們將給你帶來最專業可靠的代寫essay服務。

Order Now

BUAD 352 - Final Exam代寫

    Part 1 (15%): Data Validation and MATCH/ OFFSET
    BUAD 352 - Final Exam代寫
    ? Take note of the data in the sheet named RawData, then select the sheet named FindData
    ? Create the following names on this sheet:
    ? Name B3 theFindCountry
    ? Name C3 theFindYear
    ? Name D3 theLifeExpectancy
    ? Use Data Validation on the cell named theFindCountry so that values for this cell must be
    selected from the list of country names on the RawData sheet in cells C2:GQ2. It is not
    necessary to specify informational or error message.
    ? Use Data Validation on the cell named theFindYear so that values for this cell must be selected
    from the list of years on the RawData sheet in cells B3:B51. It is not necessary to specify
    informational or error message.
    ? In the cell named theLifeExpectancy, create a formula that retrieves the life expectancy value
    for the country whose name is in theFindCountry for the year indicated in theFindYear. This
    formula must be self-contained – it cannot rely on calculations performed in another cell.
    Part 2 (15%): Do Loops
    ? Select the sheet named Loops
    ? Create the following names on this sheet:
    ? Name B3 SlowCounter
    ? Name C3 FastCounter
    ? Name B5 TimeToStop
    ? Create a button named btnGo with caption Go. Place the button on top of the cell named
    TimeToStop
    ? Create code for btnGo that does the following when the button is clicked:
    ? Sets TimeToStop to 0
    ? Sets SlowCounter to 0
    ? Performs a loop that increments SlowCounter by 1 until it reaches 10 or until TimeToStop
    has a value of 1. However, each time that SlowCounter is incremented by 1 within this loop,
    the code must
    3
    ? set FastCounter to 0
    ? execute a DoEvents statement
    ? perform a loop that increments FastCounter by 1 until it reaches 10.
    ? Create a button named btnStop with caption Stop. Place the button beneath btnGo
    ? Create code for btnStop that sets TimeToStop to 1 in order to stop the loop in btnGo.
    ? Check: When you click Go, you should see SlowCounter begin counting up to 10 by 1, but
    between increments, FastCounter should be counting up to 10 by 1. If you click Stop, the
    counting should stop when FastCounter next gets to 10. Note that on some computers, you may
    need to use two consecutive DoEvents statements, and you may need to click btnStop several
    times in order for Excel to “hear” you.
    BUAD 352 - Final Exam代寫
    Part 3 (20%): Another OFFSET Function Example
    ? Select sheet tab VariableLeadTime
    ? The table headings are similar to the simulation model we developed in class, but this table is
    laid out horizontally rather that vertically, and rather than simulate a series of days using VBA,
    this version represents each day as a single row in the table. In this way, we can simulate the
    dynamics of orders, receipts and shipments for a single product at a single location for 1,000
    days (since there are 1,000 rows in the table).
    ? On this sheet, the “Replenishment Lead Time” cell in D2 indicates the number of days between
    the placing of an order and the receipt of that order. In our in-class model, we assumed that this
    was always 1 day, but in this model, we will allow it to vary.
    ? The values in the D-column of the table, “Today’s Receipts From Suppliers”, represent products
    received from suppliers as a result of orders placed on previous days, as indicated in the
    “Today’s Replenishment Order” column (column N). The D-column values also depend on the
    “Replenishment Lead Time” cell in D2, which indicates the number of days between the placing
    of an order and the receipt of that order. If we order 174 units of the product on Day 1 and the
    replenishment lead time is 4 days, for example, then the 174 units should appear in the D-
    column on day 5.
    ? Enter a formula in cell D8 (which can be copied downward to the remaining cells in that
    column) which does the following:
    ? If the Day represented by that row (column B) is greater than the “Replenishment Lead
    Time” value then return the value in the “Today’s Replenishment Order” column for the day
    that is “Replenishment Lead Time”-days earlier.
    ? Otherwise return 0.
    ? Do this in such a way that if the value of “Replenishment Lead Time” is changed, the values
    will be adjusted appropriately to reflect the new value.
    ? Notes:
    ? Your formula will involve both an IF statement and an OFFSET statement
    ? Remember that negative values for the row and column parameters tell OFFSET to move up
    or to the left, while positive values tell OFFSET to move down or to the right.
    4
    ? To enable the formula to perform correctly when copied downward, you will need to pay
    attention to $’s in one or more of the cell addresses. Alternatively, you could choose to name
    a cell.
    BUAD 352 - Final Exam代寫
    ? Check:
    ? When the value of “Replenishment Lead Time” is set to 5:
    ? On Day 9, since 9 > 5, we want the formula to return the value that was the order in
    Column N on Day (9 – 5), or Day 4, which was 168.
    ? On Day 3, since it is not the case that 3 > 5, we want the formula to return 0
    ? Check 1: When the value of “Replenishment Lead Time” is changed to 7, the values
    for the first few rows are as follows:
    ? Check 2: If the value of “Replenishment Lead Time” is changed to 10, the values
    for the first few rows are as follows:
    Part 4 (30%): Compound IF Statements and a Simple
    Simulation
    ? Select the sheet named CompoundIFs
    ? We are trying to decide if the following bet is one we should take: bet $100, and then roll three
    fair dice. If the total of the three rolls is 5 or less, we get $540 back. If not, if the total is less
    7
    1095
    90.00%
    88.80%
    Day Beginning
    Inventory
    Today’s
    Receipts From
    Suppliers
    Outstanding
    Orders From
    Suppliers
    Available To
    Ship
    Yesterday's
    Backorders
    Today’s
    demand
    Today’s late
    shipments to
    customers
    Today’s on-time
    shipments to
    customers
    Ending
    Inventory
    Backorders Inventory
    Position (EI-
    BO+OO)
    Today’s
    Replenishment
    Order
    1 1095 0 0 1095 4 170 4 170 921 0 921 174
    2 921 0 174 921 0 130 0 130 791 0 965 130
    3 791 0 304 791 0 151 0 151 640 0 944 151
    4 640 0 455 640 0 168 0 168 472 0 927 168
    5 472 0 623 472 0 172 0 172 300 0 923 172
    6 300 0 795 300 0 126 0 126 174 0 969 126
    7 174 0 921 174 0 166 0 166 8 0 929 166
    8 8 174 913 182 0 140 0 140 42 0 955 140
    9 42 130 923 172 0 144 0 144 28 0 951 144
    10 28 151 916 179 0 174 0 174 5 0 921 174
    11 5 168 922 173 0 172 0 172 1 0 923 172
    12 1 172 922 173 0 125 0 125 48 0 970 125
    13 48 126 921 174 0 156 0 156 18 0 939 156
    14 18 166 911 184 0 141 0 141 43 0 954 141
    15 43 140 912 183 0 137 0 137 46 0 958 137
    Replenishment Lead Time
    OUTL
    No-Stockout Prob Target
    No-Stockout Prob Actual
    5
    than or equal to 10, we get $55 back. If not, if the total is less than or equal to 13, we get $74
    back. If not, we get $154 back.
    ? The three dark blue cells at the top of the worksheet represent the rolls of the three dice. They
    will vary randomly between 1 and 6, and will re-calculate every time the worksheet is changed.
    ? The cell named RollSum will compute the sum of the three rolls and the cell named Payoff will
    calculate your winnings for each roll of the three dice.
    ? Do the following:
    o Enter formulae in cells B3, C3 and D3 that create random integers that very uniformly
    between 1 and 6 inclusive.
    o Enter a formula in the cell named RollSum that adds the values in B3, C3 and D3.
    o Enter a single formula in the cell named Payoff that does the following:
    ? If RollSum is less than or equal to 5, enter the value 540 in the cell.
    ? Otherwise, if RollSum is less than or equal to 10, enter the value 55 in the cell.
    ? Otherwise, if RollSum is less than or equal to 13, enter the value 74 in the cell.
    ? Otherwise, enter the value 154 in the cell.
    o Add a button named btnSimulate (with caption Simulate!) to the worksheet and create a
    click event handler to do the following:
    ? Clear any results from previous runs (the range of results is named ResultsClear – don’t
    clear the formats, just the contents)
    ? Create 100 “samples” of the value in Payoff in the list beneath the cell named Samples.
    To do this,
    ? Begin by setting the cell named Attempt to 1
    ? Then create a Do Loop that loops until the cell named Attempt reaches or exceeds
    100. Each time through the loop, place the value of the cell named Payoff into the
    next available spot in the list using the Offset operator.
    ? Hint: Refer to the sheet named VBAOffsets in the BasicSkillsFinal.xlsm – the
    statement to do this is similar to the second statement in the code under btnOffset,
    except here we want to use the value of the cell named Payoff, not the number 5.
    ? Remember to increment the cell named Attempt by 1 just before the loop statement.
    o Create a formula in the cell named Winnings to calculate the amount that you would have
    won (or lost) given the 100 Payoff values in the list (remember that each of the 100 rolls
    costs you $100.00).
    ? Check: I performed this simulation 100 times (that is, 100 observations of 100 rolls –
    essentially clicking the button 100 times). My average winnings were $88.74 for 100 rolls (i.e.:
    pretty close to 0, given each set of 100 rolls costs $10,000), the minimum was -$2,044 and the
    maximum was $2,693. If you are getting values outside this range regularly, then something is
    wrong. Also, you should see both losses and gains if you click your button several times.
    Part 5 (20%): Copy/Paste Using VBA
    ? Select the sheet named CopyPaste
    ? Create the following names on this sheet:
    ? Name I4 ChunkNumber
    ? Name B3 DataStart
    ? Name K4:O14 SourceRange
    6
    ? Add a button to the sheet named btnAddAChunk with caption “Add A Chunk” that does the
    following when clicked:
    ? Increments the cell named ChunkNumber by 1
    ? Copies the values in the range named SourceRange
    ? Pastes the values of the copied cells into the table beginning at the cell named DataStart.
    ? The copied values should be placed in the second column of the table (i.e.: beginning
    under Heading 1)
    ? The copied values should be placed in the rows of the table that correspond to the
    value of ChunkNumber. That is, if after incrementing ChunkNumber its value is 3,
    then the values should appear in the table beside the slot labeled Chunk 3.
    ? Important: The VBA code that you create must refer only to the three cells you named
    above.
    ? Note: No loop is required here – if I make ChunkNumber 0 and then click the button three
    times, I should see random values appear in the slots labeled Chunk 1, then Chunk 2 and
    then Chunk 3. After doing this, ChunkNumber should be 3.

在線客服

售前咨詢
售后咨詢
微信號
Badgeniuscs
微信