We can work on Biology: The Cell

  1. Part 1 of this assignment is ungraded, but will assist you greatly in understanding how a table is set up to run Solver.
    a) Open the Module Six Assignment Spreadsheet and make sure you are on the tab (worksheet) titled Solver Part 1. You will see a spreadsheet that
    has been set up to use Solver. (Note: There is more than one way to set up and program a table; the tables used for this exercise illustrate one
    method.) The table highlighted in gray shows the specific amounts of material, fabrication time, and output needed for each chair and table, as
    well as the total cost of producing each item. The table in blue calculates total profit from producing both tables and chairs. The table in green
    tracks the amount of materials and fabrication consumed to produce the volume that will be decided. Lastly, the yellow cells on the green table
    indicate the materials and fabrication time as well as the output volume minimums set by management.
    b) Click on each cell to observe the programing used, but do not change anything.
    c) After you have reviewed the programing, click on the red cell, go to the menu bar at the top of the page, and click on the Data tab. Then click on
    Solver. The Solver dialog box should open, and you can observe which cell has been identified as the target cell, which cells Solver will change,
    and how the constraints have been entered. Do not run Solver at this time; simply click Close on the dialog box.
  2. Now you will practice running Solver and viewing two of its associated reports. Click on the tab at the bottom on the screen titled Solver Parts 2 and 3.
    You will see the same data tables from Part 1. Follow these steps:
    a) At the top of the worksheet, click on Data, then Solver.
    b) On the Solver Parameters dialog box, click Solve.
    c) See how the cells with the zeros now have been assigned values.
    d) Do not close out of the Solver Results dialog box.
    e) On the Solver dialog box, run a Sensitivity and a Limits report.
    f) In the area indicated in the Part 2 section of the Solver Parts 2 and 3 tab, type a short paragraph explaining what these reports indicate.
  3. In this step, you will adjust the variables and constraints and run Solver again.
    a) Suppose management has altered their decision and has increased fabrication time from 480 minutes to 600 minutes and increased the
    minimum number of chairs to be produced from 10 to 16. Run Solver again and list the number of tables and chairs that should be produced in
    the provided table under Part 3a of the worksheet.
    b) Now suppose too many tables have been rejected by quality assurance, and the production line for tables will be slowed, increasing fabrication
    time to 26 minutes. However, management has also found a way to decrease fabrication time on the chairs to three minutes. Use the original
    constraints for fabrication time (480 minutes) and the minimum tables (4) and chairs (10) and run Solver again. List the number of tables and
    chairs that should be produced in the provided table under section Part 3b of the worksheet.
  4. Use the tab labeled Solver Part 4 to complete the following:
    a) Create and program a spreadsheet with data based on the following scenario:
    Scenario
    Your company has two trucks that it wishes to use on a specific contract. One is a new truck the company is making
    payments on, and one is an old truck that is fully paid for. The new truck’s costs per mile are as follows:
     Fuel/additives: 54¢
     Truck payments: 24¢
     Driver: 36¢
     Repairs: 12¢
     Miscellaneous: 1¢
    The old truck’s costs are as follows:
     Fuel/additives: 60¢
     Truck payments: 0¢
     Rookie driver: 32¢
     Repairs: 24¢
     Miscellaneous: 1¢
    The company knows that truck breakdowns lose customers, so they have capped estimated repair costs at $14,000. The
    total distance involved is 90,000 miles (to be divided between the two trucks). After you set up and program your table,
    be sure to provide a rationale statement.
    b) Use Solver to determine the number of miles each truck should be driven.

Sample Solution

facebook Share on Facebook

Twitter Tweet

Follow Follow us
custom Share
custom Share
custom Share
custom Share
custom Share

entrepreneurs. Since the credits granted translate into real physical assets, the problem of inflationary money creation will no longer arise. Indeed, the intervention of Islamic banks cannot be inflationary because they are based on participation. Also the redistribution of wealth through Zakat will allow households to be less willing to own the means of spending, which will increase their purchasing power, which results in increasing demand and generating economic development. Islamic banks have a special nature in all their financing and investment activities. This nature is based on the principles and principles of Islamic Sharia, which are based on an integrated and harmonized set of methods, methods and rules that are consistent with the provisions of the supreme legislation. Islamic finance intervenes on two levels: the participatory equity contribution, invested directly in production channels, and banking facilities to consolidate its tools. Thus, these financing techniques, considered more solidary, combined with the skills, capacities and know-how of credit institutions, allows companies to finance themselves with stable complementary resources, mobilized directly and exclusively to support the growth of the economy. Companies can benefit from this momentum of dynamic partnership and the liquidity generated by the support put in place. The mobilization of funds is essential to obtain recurring profitability and profits. This can help further develop a wide range of sectors, including, for example, the economies of knowledge and technologies needed to develop qualified and apt human capital. A real assertion is that this dynamic does consolidate and accelerate the pace of growth of the productive economy. To do this, Islamic products, in addition to deposit accounts, can adapt to the needs of the economy and investors given the developments in the financial engineering of products like: Mudaraba (profit sharing or trust financing), Murabaha (mark up financing), Ijara (leasing), Istisna, Qard Hassan (benevolent loans), Ar Rahnu (Pawn broking) and many more. As Islamic finance products raise and evolve more, customer believe and trust also grow together which make Islamic products in the limelight right now.>

Is this question part of your Assignment?

We can help

Our aim is to help you get A+ grades on your Coursework.

We handle assignments in a multiplicity of subject areas including Admission Essays, General Essays, Case Studies, Coursework, Dissertations, Editing, Research Papers, and Research proposals

Header Button Label: Get Started NowGet Started Header Button Label: View writing samplesView writing samples