Categories
Writers Solution

Osteology is the study of the structure and function of the skeleton and bony structures

1

ANTH-12 Osteology Research Assignment/Essay

Prompt: Osteology is the study of the structure and function of the skeleton and bony structures. Since hominin are only discovered as fossilized remains, the study of their bones and skeletons is very important for our understanding of human evolution! For this assignment, each student will write a short research paper on a hominin osteological feature (i.e. a bone or skeletal structure) of their choice. Students should pick a feature that is both interesting to them and important for our evolution. Look for skeletal features that aid in things like locomotion, bipedalism, and tool making etc. In the paper, students should describe the bone or skeletal trait in detail and explain how and why it is important to human evolution. Students may also want to include a discussion of key fossil hominin finds that feature their chosen subject. In addition, students are expected to include a detailed hand drawing of their chosen osteology feature to accompany their research paper. This drawing can be embedded in the submitted word document or included as a separate upload. A minimum of 3-4 scholarly references are required; non-academic sources are categorically not appropriate references. All references should be parenthetically cited and included in a works cited page at the end. Example of a topic: hyoid bone, calcaneus, non-opposable hallux, foot arch (tarsal and metatarsal bones), pelvis, knee joints, femur, vertebral column, thumb metacarpal, dentition/molars, wrist bones, clavicle, finger phalanges, hip joints, sagittal crest, bone density, etc. Due: Saturday, April 10th by 11:59pm PT. Submission: Online on Canvas Requirements: About 3 pages (approximately 600-650 words, not including bibliography page) Works Cited Page/Bibliography (3-4 citations) Drawing of bone (can be embedded in word document) Total Points: 20 points How to structure an essay: Introduction Thesis statement (A thesis statement is composed on three parts: context, subject and claim!) Body Paragraphs Conclusion How to Research: Website based internet sources are not a legitimate basis of information for this paper. Instead, try these sources: SJSU Library: https://libguides.sjsu.edu/sb.php?subject_id=2686 Google Scholar: https://scholar.google.com

Ø Example search: “human evolution hyoid bone”

GET THE COMPLETED ASSIGNMENT

ASSIGNMENT COMPLETED AT CapitalEssayWriting.com

MAKE YOUR ORDER AND GET THE COMPLETED ORDER

CLICK HERE TO ORDER THIS PAPER AT CapitalEssayWriting.com on Osteology is the study of the structure and function of the skeleton and bony structures

NO PLAGIARISM, Get impressive Grades in Your Academic Work

Categories
Writers Solution

split-brain and lateralization of function

This short answer exam consists of five questions. Each answer requires at least 300 words with an introduction that has a topic sentence, a body, a conclusion and at least 2 references in APA format. 

Make sure the questions are fully answered with key points from each topic. All your writing must be in your own words. No quotes! Paraphrase (restate what you read) rather than copying material from the course textbook or the Internet. No copying is permitted in this course and doing so will result in zero points on the exam. Answers must be written in narrative, paragraph form. 

Thank you also for your patience during the grading process. Each answer is graded manually, and the system will update after each answer. During this time, you may see a grade of 20, 40, and so on until all of the answers have been graded. 

  1. Discuss the literature on split-brain and lateralization of function. What does the research tell us about each hemispheres ability to function independently (e.g., cognitively, creatively, etc.) and in unison? What are the implications for the cognitive neuroscientist in terms of research?
  2. Discuss one of the psychiatric disorders. Be sure to address both the physiological and behavioral aspects of the disorder (signs and symptoms, biochemical or genetic theories, etc.), and pharmacological and behavioral treatments for the disorder. What is the role of the biopsychologist or neuroscientist in this type of research?
  3. Discuss sleep in terms of the normal sleep cycle. Be sure to address the stages of sleep and physiological correlates associated with each stage. How does dreaming fit into our conception of a normal sleep cycle? Address theories of dreaming. What are the consequences of disruption of sleep?
  4. Critically evaluate the theories that have been used to explain emotion. Which do you think is the best theory and why?
  5. What brain regions and neurochemical systems are known to be involved in the regulation of sleep? What is known about the neurobiology and endocrinology of circadian rhythms?

GET THE COMPLETED ASSIGNMENT

ASSIGNMENT COMPLETED AT CapitalEssayWriting.com

MAKE YOUR ORDER AND GET THE COMPLETED ORDER

CLICK HERE TO ORDER THIS PAPER AT CapitalEssayWriting.com on split-brain and lateralization of function

NO PLAGIARISM, Get impressive Grades in Your Academic Work

Categories
Writers Solution

Describe the functions carried out by healthcare managers, and give an example of a task in each function.

https://youtu.be/kjDTepXhNDo

Read your text and view video 1 above. Answer the questions below in detail:

Describe the functions carried out by healthcare managers, and give an example of a task in each function. Explain why interpersonal skills are important in healthcare management.Why is the healthcare manager’s role in ensuring high performance so critical? Explain

Read your text and view video 2 above. Answer the questions below in detail:

  1. What is the difference between leadership and management?
  2. Are leaders born, or are they trained? How has the history of leadership in the United States evolved to reflect this question?
  3. What are the leadership domains and competencies? Can you be a good leader and not have all the competencies listed in this model?

HELPFUL TIP
In order to receive full credit for your Discussion Board assignment you must give complete and detailed answers for all the questions and cite a minimum of 2 references (Only 1 can be the textbook)

WE HAVE DONE THIS ASSIGNMENT BEFORE, WE CAN ALSO DO IT FOR YOU

GET SOLUTION FOR THIS ASSIGNMENT, Get Impressive Scores in Your Class

CLICK HERE TO MAKE YOUR ORDER on Describe the functions carried out by healthcare managers, and give an example of a task in each function.

Are You looking for Assignment and Homework Writing help? We Provide High-Quality Academic Papers at Affordable Rates. No Plagiarism.

TO BE RE-WRITTEN FROM THE SCRATCH

Categories
Writers Solution

an algebraic statement of the revenue function and the cost function

Description

Case studies are used to enable you to apply new concepts, use the tools you have mastered, and improve your technical skills you have attained. Through the individual case studies you will discover for yourself the usefulness of quantitative problem solving methods, how to apply them in practice, and their benefit to organizational decision-makers.

In this case study, you will act as a consultant for a company that crushes sunflower seeds to produce high quality refined sunflower oil for sale in the wholesale market. The company is looking for you to make a recommendation on the optimal blend of raw materials required for its next production cycle. You will use a number of decision analysis tools including time series forecasting, linear programming, and cost-profit-volume analysis to make the recommendation and provide analysis on the profitability of the company.

You will be required to submit a written report to management, and to include the spreadsheet models you used to generate price forecasts, optimize the raw material, and a perform the break-even analysis. All analysis should be done using Excel and the various models should be implemented on separate worksheets or in separate workbooks.

Scenario

TourneSol Canada, Ltd. is a producer of high quality sunflower oil. The company buys raw sunflower seeds directly from large agricultural companies, and refines the seeds into sunflower oil that it sells in the wholesale market. As a by-product, the company also produces sunflower mash (a paste made from the remains of crushed sunflower seeds) that it sells into the market as base product for animal feed.

The company has a maximum input capacity of 150 short tons of raw sunflower seeds every day (or 54,750 short tons per year). Of course the company cannot run at full capacity every day as it is required to shut down or reduce capacity for maintenance periods every year, and it experiences the occasional mechanical problem. The facility is expected to run at 90% capacity over the year (or on average 150 x 90% = 135 short tons per day).

TourneSol is planning to purchase its supply of raw sunflower seeds from three primary growers, Supplier A, Supplier B, and Supplier C. Purchase prices will not set until the orders are actually placed so TourneSol will have to forecast purchase prices for the raw material and sales prices for the refined sunflower oil and mash. The contract is written such that TourneSol is only required to commit to 70% of total capacity up front. Any amounts over that can be purchased only as required for the same price. Historical prices for the last 15 years are in the table below (note that year 15 is the most current year).

Historical Price DataMarketing YearSeed

Average Price Index

$/short ton

Oil

Average Price Index

$/short ton

Mash

Average Price Index

$/short ton

1127.7317.8632192.4465873242662.21054242668.21115274791.3124624273210872909511348347.2112315394361297.319310422.81312187114661416193125821664247135081317.4242144281182.4197154341334.4210​

Sunflower oil contains a number of fatty acids, some which are desirable in food products and others that are not. One desirable fatty acid is oleic acid. TourneSol produces high oleic oil for the wholesale market, and requires that the oleic acid content be a minimum of 77%. Sunflower oil also contains trace amounts of iodine. The market requires that that iodine content be a minimum of 0.78% and maximum of 0.88%

The oleic acid and iodine content for the sunflower seeds from the three suppliers is given in the table below.

SupplierOleic AcidIodineA72%0.95%B82%0.85%C65%0.72%​

For all three suppliers, it is expected that the average yield of oil from the seeds is 30%. There is no net loss of material, so the yield of mash from the same supply is expected to be 70%.

Because the oleic acid and iodine content varies across the three suppliers, so does the price. It is expected that the cost of supply from the suppliers will be a percentage of the market average price of seeds.

​SupplierCost as % of Average Market Price of SeedA85%B100%C90%

The company faces an additional variable production cost of $10/short ton and an estimated fixed cost of $1,750,000 over the upcoming production period.

The company is asking you to provide a recommendation on the amount of raw material it should purchase from each supplier to minimize its cost of feedstock.

Management is also looking for an analysis on the profitability of the company in the next production cycle. 

Suggested Approach

This is a fairly complex problem. The following approach is suggested:

  • Use the historical price data set as input to a time series forecast model in order to generate forecasted prices for the average price of sunflower seeds, oil, and mash in the next production period. Use standard measures of error to decide between a three-period moving average model or an exponential smoothing model (with α = 0.2). Use the type of model for all three time series forecasts. That is, if you decide to use the moving average model, use a three-period moving average model to fit the relevant data for all three series. Don’t use the moving average for one time series and the exponential smoothing model for another time series.
  • Formulate a linear program to minimize the cost of raw sunflower seeds. Use the average price of seeds forecasted from the previous step in order to determine supplier prices.
  • Perform a cost-volume-price analysis (review the handout entitled Cost-Volume-Profit Analysis for details) using the average cost per short ton average selling price per short ton.
    • You can generate an effective cost per short ton by dividing the total cost of supply (from the linear program) by the total volume (that you assumed in the linear program).
    • You can generate an effective selling price per short ton from the expected percentage yields and the forecasted average price of sunflower oil and mash.
    • Because of the way that the contract is written, you can assume that the purchase of raw sunflower seeds is a variable cost (you only purchase what you require).

Recall that the cost-volume-price analysis requires you to provide:

  • an algebraic statement of the revenue function and the cost function,
  • a detailed break-even chart that includes lines for the revenue and for the total cost, fixed cost, and variable cost (a total of four lines), and
  • a calculation break-even point expressed in number of short tons and percent of capacity.

Management Report

Prepare a written management report that includes, at a minimum, the following sections:

  • Purpose of the Report
  • Description of the Problem
  • Methodology (which would include the model formulation)
  • Findings or Results
  • Recommendations or Conclusions

Be sure to address all relevant points, discuss any assumptions you are making, justify any modeling choices you have made (for example, the choice of time series forecast model), and highlight the following items in your report:

  • a forecast of the next production period’s average price index for raw sunflower seeds, sunflower oil, and sunflower mash,
  • a recommendation for the optimal purchasing strategy from the various suppliers,
  • a cost-volume-profit analysis using for the recommended purchase strategy and the forecasted sunflower oil and mash sales price,
  • a discussion of the risks and uncertainties that are faced by the company, and
  • an analysis and opinion on the profitability of the company in the next production period (accounting for the expected profit or loss and the inherent risks/uncertainties.

Remember that you are writing the report from the point of view of a consultant with senior management of TourneSol Canada, Ltd. as the intended audience.

SUBJECT: BUSINESS DECISION ANALYSIS 

WE HAVE DONE THIS QUESTION BEFORE, WE CAN ALSO DO IT FOR YOU

GET SOLUTION FOR THIS ASSIGNMENT, Get Impressive Scores in Your Class

CLICK HERE TO MAKE YOUR ORDER on

  • an algebraic statement of the revenue function and the cost function
  • TO BE RE-WRITTEN FROM THE SCRATCH

    Categories
    Writers Solution

    Describe how archaeologists use use-trace analysis to ascertain the probable function of artefacts

     Question 1Describe how archaeologists use use-trace analysis to ascertain the probable function of artefacts. Please confine your answer to half a page. (15 Marks)
    Question 2
    In his recent work, Qambela (2021) has challenged canonical theories of amaXhosa masculinities in anthropology. Additionally, anthropologists as Becker, Boonzaier and Owen (2005) have tasked us to pay attention to issues of power in fieldwork in order to produce politically and historically grounded ethnography. Starting with Qambela (2021), Becker, Boonzaier and Owen (2005) and others, write an essay wherein you critically unpack how we read and think about ethnographic “classics” in contemporary times. In your response, pay particular attention to issues of power in how we have read, understood and interrogated “classics” in contemporary ethnography. (35 Marks)
    Section B
    Answer one of the following essay questions:
    1. Bourdieu’s notion of ‘habitus’ explains how social structures endure, not how they change. Discuss.
    2. ‘In order to be effective, mimicry must continually produce its slippage, its excess, its difference’ (BHABHA 1994). Discuss.
    3. Why does Strathern say feminism and anthropology mock each other?
    4. ‘Foucault’s discourses on power cannot account for what produces power itself’(SANGREN 1995). Discuss.
    5. So, ‘Can the thing speak?’ (HOLBRAAD 2011)?
    (50 Marks)

    WE HAVE DONE THIS QUESTION BEFORE, WE CAN ALSO DO IT FOR YOU

    GET SOLUTION FOR THIS ASSIGNMENT, Get Impressive Scores in Your Class

    CLICK HERE TO MAKE YOUR ORDER

    TO BE RE-WRITTEN FROM THE SCRATCH

    GET SOLUTION FOR THIS ASSIGNMENT

    CLICK HERE TO MAKE YOUR ORDER

    TO BE RE-WRITTEN FROM THE SCRATCH

    NO PLAGIARISM

    • Original and non-plagiarized custom papers- Our writers develop their writing from scratch unless you request them to rewrite, edit or proofread your paper.
    • Timely Delivery– primewritersbay.com believes in beating the deadlines that our customers have imposed because we understand how important it is.
    • Customer satisfaction- Customer satisfaction. We have an outstanding customer care team that is always ready and willing to listen to you, collect your instructions and make sure that your custom writing needs are satisfied
    • Confidential- It’s secure to place an order at primewritersbay.com We won’t reveal your private information to anyone else.
    • Writing services provided by experts- Looking for expert essay writers, thesis and dissertation writers, personal statement writers, or writers to provide any other kind of custom writing service?
    • Enjoy Please Note-You have come to the most reliable academic writing site that will sort all assignments that that you could be having. We write essays, research papers, term papers, research proposals Describe how archaeologists use use-trace analysis to ascertain the probable function of artefacts
    Green Order Now Button PNG Image | Transparent PNG Free Download on SeekPNG
    Categories
    Writers Solution

    What is the purpose of command and control as a warfighting function?

    1. What is the purpose of command and control as a warfighting function? (M447)

    a. define command and control warfighting function in your words 

    b. explain in your own words command and control warfighting function

    c. provide a example in your own words command and control warfighting function

    each a paragraph

    GET SOLUTION BELOW

    CLICK HERE TO MAKE YOUR ORDER

    TO BE RE-WRITTEN FROM THE SCRATCH

    NO PLAGIARISM

    • Original and non-plagiarized custom papers. Our writers develop their writing from scratch unless you request them to rewrite, edit or proofread your paper.
    • Timely Delivery. capitalessaywriting.com believes in beating the deadlines that our customers have imposed because we understand how important it is.
    • Customer satisfaction. Customer satisfaction. We have an outstanding customer care team that is always ready and willing to listen to you, collect your instructions and make sure that your custom writing needs are satisfied
    • Privacy and safety. It’s secure to place an order at capitalessaywriting.com We won’t reveal your private information to anyone else.
    • Writing services provided by experts. Looking for expert essay writers, thesis and dissertation writers, personal statement writers, or writers to provide any other kind of custom writing service?
    • Enjoy our bonus services. You can make a free inquiry before placing and your order and paying this way, you know just how much you will pay. A verdict was rendered against three parent chaperones. How was the third parent included in the case?
    • Premium papers. We provide the highest quality papers in the writing industry. Our company only employs specialized professional writers who take pride in satisfying the needs of our huge client base by offering them premium writing services What is the purpose of command and control as a warfighting function?

    Get Professionally Written Papers From The Writing Experts 

    Green Order Now Button PNG Image | Transparent PNG Free Download on SeekPNG Our Zero Plagiarism Policy | New Essays
    Categories
    Writers Solution

    Write a function called calc_product_cost that returns the total cost of an item after the tax has been added to the product.

    Assignment 2

    Assignment 2 Weight 30% Marked out of 100 Due date: 8 October 2021

    Please submit the CODE in readable format (NOT SCREEN CAPTURE) and OUTPUT for all programming questions. You will submit this assignment electronically in the ASSESSMENT area of the Study Desk.
    For this assignment we will use the Brewers database Chapter 4 that comes with the textbook (script available under link to this file). The script to create the databases is included as a file in Assignment 1 section of the course website as well as Week 2 on the study desk. You will need to run the scripts to create the needed database tables. If you are using your own Oracle insulation the script should work as normal.
    IMPORTANT NOTES – PLEASE READ BEFORE YOU BEGIN WORK

    1. This assignment prepares you for the examination and you should consider each hour devoted to the assignment as an hour devoted to exam preparation.
    2. I urge you not to give up if you are unable to do all the questions. Do as many as you can and submit what you have done.
      For this assignment we will use the Brewers database that comes with the textbook. The script to create the databases is included as a file in the assignment 1 section of the Moodle course web site. You will need to run the scripts to create the needed database tables. If you are using your own Oracle insulation the script should work as normal.
      The structures and information about the tables is located in Appendix A (Page 423) of the Casteel textbook. The structure of the tables used in this assignment questions is reproduced at the end of this document.

    Please Read Carefully before starting.
    There are four(4) questions valued a total of 100 marks. You need to provide a well-structured and documented solution to the problems.
    With your code solution you also need to provide the source code in editable format copy and paste in the submission file (NOT SCREEN CAPTURE).
    The resulting output of the running solution you can use the screen capture or text copy and paste into the document. You can use the screen capture features of the OS you are using. For Windows you can use the ‘print current window capture’ key stroke ‘Alt-Shift-Print Screen’. Depending on your keyboard you may have to use the function key as well. You can also use the default capture tool, search for ‘Snipping Tool’ in start menu. For Apple Mac use ‘Command (?)-Shift-4’ and select screen to capture.
    Important Programming Requirements:
    • You must NOT use any Implicit Cursors, or Cursors with table joins, subqueries, set operators, group functions or SQL aggregate functions (such as COUNT).
    • Explicit Cursors should be declared as parametrized cursors when used in functions or procedures.
    • The PL/SQL anonymous block must be ONE block only to call the relevant procedures or functions. Do NOT write a block to perform each task of the specifications.
    Question 1 (30 marks)
    a)
    Write a function called calc_product_cost that returns the total cost of an item after the tax has been added to the product. The function has two IN parameters IDSHOPER and IDPRODUCT and returns a number as a result of the function execution. If IDSHOPER or IDPRODUCT or Customer STATE value does not exist in the relevant tables the function should return NULL as the result. You need to return the NULL result explicitly. The function calculates cost of an item based on the item cost and percentage tax charged for the state the customers address is in. (10 marks)
    b)
    Write an SQL statement that displays customer details (ID, First Name, Last, Name, State) and total to be paid for each customer for product in the BB_PRODUCT table whose ID is 2 by calling the calc_product_cost function. Rename the resulting filed from the function call TOTAL_COST. (5 marks)
    c)
    Write a function called sf_total_order_item_cost which takes in three IN parameters IDSHOPER, IDBASKET and IDPRODUCT. The function returns the total cost on the order for an item for the customer. The cost of the item is calculated by calling calc_product_cost and multiplying it by the quantity in the order. (5 marks)
    d)
    Write a procedure (called sp_report_on_products) that takes a single IN parameter Product ID and creates a report to the screen as follows. For every customer in the table create a report using the DBMS_OUTPUT module to print the Customer Last Name, First Name first character with full stop, State, Product Description, Product Cost, Tax, Total Cost, by calling the sf_total_order_item_cost function.
    Format for the line output.
    LASTNAME, FIRSTNAME, Product: ‘DESCRITION’ Cost: $9999.99, Tax: $9999.99, Total Cost: $9999.99.
    Example dummy output
    John, C. Product: ‘Some product description here’ Cost: $13.75, Tax: $0.56, Total Cost: $14.31.
    The tax calculated is the sum of tax that each customer would have for all the orders of that product.
    After processing all the customers display the following information.
    Total customers processed XXXX and total tax calculated for all orders is $9999.99.
    Call the procedure from an anonymous block and capture the results. (10 marks)
    Question 2 (20 marks)
    The Brewers Company is concerned about possible unauthorised changes to customer orders that may compromise the companys profit.
    Your task is to create a database trigger to monitor such changes to some important columns in the BB_BASKET table.
    Important Setup:
    Create a copy of the BB_BASKET table in your own schema by using the following command:
    CREATE TABLE CUSTOMER_COPY AS SELECT * FROM BB_BASKET;
    Create a table to store change logs (call the table TMP_CHANGELOG) to hold the following fields IDBASKET, QUANTITY, SUBTOTAL, TOTAL and LOG_DATE. You will need to refer to the relevant table for field types and sizes. The LOG_DATE field will contain the system date.

    1. Create a database trigger with the following specification:
      • fires AFTER an UPDATE on CUSTOMER_COPY table.
      • fires if there is any change to QUANTITY, SUBTOTAL or TOTAL columns of the CUSTOMER_COPY table.
      • fires for each row changed.
      • inserts a first row: the affected IDBASKET column, the OLD values of the QUANTITY, SUBTOTAL and TOTAL columns and the current date into the table TMP_CHANGELOG.
      • inserts a second row: the affected IDBASKET column, the NEW values of the QUANTITY, SUBTOTAL and TOTAL columns and the current date into the table TMP_CHANGELOG. (10 Marks)
    2. Test the trigger with the following specification:
      • Go ahead and make a change to CUSTOMER_COPY table by issuing the following command:
      UPDATE CUSTOMER_COPY
      SET QUANTITY = 99, TOTAL = 99.99
      WHERE IDBASKET = 12;
      (5 Marks)
    3. For second test write a DML statement that sets the SUBTOTAL value in CUSTOMER_COPY table for the IDBASKET 12 to 50% of the TOTAL value currently recorded for that row. (5 marks)
      Provide copy of your code and capture of the execution output.
      Question 3 (30 marks)
      This question has a few section (procedures and functions) described. You are free to write helper procedures or functions but they will have to have high cohesion and low coupling (do one thing only and not be reliant on external values).
      1) Create a PL/SQL procedure called sp_shopping_month which has an IN parameters for the year and the month. The procedure will display to the screen the following information for each basket created (DTCREATED) for that year/month. The information needs to be retrieved using an explicit cursor. (5 marks)
      Basket BASKEID has a total of BASKET_TOTAL plus SHIPPING total cost of order BASKET_TOATL_PLUS_SHIPING
      2) Write a function called sf_total_shipping which takes in the date parameter and returns the calculated cost of shipping for all the baskets which have been created in that year/month. (5 marks)
      3) Write a procedure called sp_uncommitted_order_month which reports on all the baskets created but where the order has not been placed (ORDERPLACED) for all the baskets in the table. The output should be as follows. (5 marks)
      There are COUNT numbers of orders created but not finalized with a total of $AMOUNT.XX and total shipping cost of $SHIPPING.XX.
      4) Write a procedure called sp_report_shopping_totals that will produce the following output in the format specified bellow. The procedure needs to use explicit cursor/s for each year starting with the oldest year and produces a summary of the shopping for that month.
      The years and month output needs to be in ascending order.
      Example dummy output only as a guideline. You will need to replace the uppercase fields with the necessary values
      Year YYYY
      January
      Basket BASKEID has a total of BASKET_TOTAL plus SHIPPING total cost of order BASKET_TOATL_PLUS_SHIPING
      Basket BASKEID has a total of BASKET_TOTAL plus SHIPPING total cost of order BASKET_TOATL_PLUS_SHIPING
      Total Shipping for the month $SHIPPING.99

    March
    Basket BASKEID has a total of BASKET_TOTAL plus SHIPPING total cost of order BASKET_TOATL_PLUS_SHIPING
    Total Shipping for the month $SHIPPING.99
    Year YYYY
    February
    Basket BASKEID has a total of BASKET_TOTAL plus SHIPPING total cost of order BASKET_TOATL_PLUS_SHIPING
    Total Shipping for the month $SHIPPING.99
    Total number of baskets processed COUNT total income of all orders is $AMOUNT.99 total shipping cost $SHIPPING.99.
    There are COUNT numbers of orders created but not finalized with a total of $AMOUNT.99 and shipping cost of $SHIPPING.99.
    (10 marks)
    Write an anonymous block should only have to call sp_report_shopping_totals which will contain the logic to display the requested output. Your solution for the final output needs to use the functions and procedures defined previously. Due to the data in the tables you will only have one year on the report. Your code needs to work when more data is added. (5 marks)
    Provide copy of your code and capture of the execution output.

    Question 4 (20 marks)
    a) Write a stored function called is_number which takes one IN parameter and returns a number if the input can be converted to a number otherwise the function should return an appropriate result. The function needs to correctly identify if the parameter can be converted to a numeric value. The function should work in PL/SQL as well as with SQL statements. (5 marks)
    b) Write an SQL statement to use is_number which passes in test values is_number(‘123’) and is_number(‘12a3’) and returns the result. Provide the SQL code and captured output. (make sure you change the quotes if copying from this document as Word uses the wrong characters for single quote characters) (5 marks)
    c) Write a stored procedure called sp_number_conversion which has a single IN parameter and a single OUT parameter. The IN parameter takes in a string to convert and the out parameter will contain a message depending on the success or fail of the conversion operation.
    On success
    ‘Converted ‘Input_Value’ to value XXXXX’.
    On failure
    ‘Unable to convert ‘Input_Value’ to a number’.
    where ‘Input_Value’ is the value passed to procedure as the IN parameter. (5 marks)
    d) Write an anonymous block of code that will loop and break up the string below into sections and pass them to sp_number_conversion procedure. Print out the result from calling the procedure for each data passes into the procedure
    String to process
    ‘12345, 3.14e3, a123, 123a, 12a3, SixtySix, -12.34, +12.56’
    (5 Marks)

    Table Structures with field types
    BB_SHOPPER

    BB_PRODUCT

    BB_BASKET

    BB_BASKETITEM

    BB_TAX

    BB_SHIPPING

    MARKING CRITERIA

    1. Specified procedures, functions with the requested parameters
    2. The code executes without error messages.
    3. The code produces the required output.
    4. The code addresses the specification and provides a solution to every element in the specification.
    5. The code is well structured and, where applicable, adopts an optimal and sophisticated approach to PL/SQL.
    6. The programing units have been separated into necessary functions and procedures.
    7. Exceptions need to be catered for appropriately in procedures and functions.
    8. Cursors used as specified in the specifications.
    9. The code is well commented and well structured.
      Academic misconduct
      Please ensure that you do not share any information about your assignment with anyone. Do not accidentally leave printouts or USB drives that contain your assignment details where someone else can access them. Make sure not to store your assignments on a computer where another student can access your assignment.
      Academic misconduct is unacceptable and includes plagiarism, collusion and cheating. You will find further explanation if you follow the link on the USQ home page to -Current Students- or https://social.usq.edu.au/study-tips/slides/keep-clear-plagiarism.
      • This assignment must be all your own work
      • The source of all information must be correctly cited and referenced
      • Do not leave printouts for other people to access your work
      • Do not leave USB with assignments plugged in public computers
      Assignment that do not adhere to these requirements have the potential to be deemed to be the result of academic misconduct. Please make sure to read the USQ policies.
      Should you have any queries regarding this assignment, please do not hesitate to email the course examiner.
      Assessment policy
      Please ensure to check the USQ assessment procedure http://policy.usq.edu.au/documents/14749PL.
      Late submission of Assignments
      Students can apply for an extension of time, to submit an assignment, at any time up to the deadline. You will see a specific Assignment extension request submission has been set up for this purpose. Any requests for extension must be made there and follow the USQ policies (Assessment: http://policy.usq.edu.au/documents/14749PL, Compassionate and Compelling Circumstances: http://policy.usq.edu.au/documents/131150PL).
      Please note the maximum number of days that can be applied for in http://policy.usq.edu.au/documents/14749PL.
      Grade calculation
      Please ensure that when you calculate your grade for an assignment to consider the weighting of the assessment as well

    GET SOLUTION BELOW

    CLICK HERE TO MAKE YOUR ORDER

    TO BE RE-WRITTEN FROM THE SCRATCH

    NO PLAGIARISM

    • Original and non-plagiarized custom papers. Our writers develop their writing from scratch unless you request them to rewrite, edit or proofread your paper.
    • Timely Delivery. capitalessaywriting.com believes in beating the deadlines that our customers have imposed because we understand how important it is.
    • Customer satisfaction. Customer satisfaction. We have an outstanding customer care team that is always ready and willing to listen to you, collect your instructions and make sure that your custom writing needs are satisfied
    • Privacy and safety. It’s secure to place an order at capitalessaywriting.com We won’t reveal your private information to anyone else.
    • Writing services provided by experts. Looking for expert essay writers, thesis and dissertation writers, personal statement writers, or writers to provide any other kind of custom writing service?
    • Enjoy our bonus services. You can make a free inquiry before placing and your order and paying this way, you know just how much you will pay. A verdict was rendered against three parent chaperones. How was the third parent included in the case?
    • Premium papers. We provide the highest quality papers in the writing industry. Our company only employs specialized professional writers who take pride in satisfying the needs of our huge client base by offering them premium writing services Write a function called calc_product_cost that returns the total cost of an item after the tax has been added to the product.

    Get Professionally Written Papers From The Writing Experts 

    Green Order Now Button PNG Image | Transparent PNG Free Download on SeekPNG Our Zero Plagiarism Policy | New Essays
    Categories
    Writers Solution

    The Excel function =RANDBETWEEN(a,b) generates a random integer value between a and b

    The Excel function =RANDBETWEEN(a,b) generates a random integer value between a and b. Open Excel. Copy and paste the Excel function into 30 cells (rows) starting at Column A at A1. Create 30 random values between 0 and 7 to simulate the response to the question, “How many times have you dined out in the past week?”  Note: Once you have your 30 random values in Column A, select all values, copy the values, and use “Paste Special – Values” to Column B starting at B1. This will keep the spreadsheet from recalculating and changing your results.

    Use Excel’s Data Analysis Tool Add-in to generate the Descriptive Statistics Summary Table for the values in Column B (as demonstrated in Section 3.2 of the text). Also use Excel’s Chart tools (as discussed in Section 3.4 of the text) to generate a box plot on the 30 responses. Comment on the measures and shape of the distribution. Do the measures and shape represent what you would expect based on randomly determined values? Why or why not?  Include the data set of the 30 random values and your output in your response. Provide references (Refer to Chapter 3 Review: Supplementary Exercises 62 in the Chapter 3 topic Resources in Essentials of Modern Business Statistics With Microsoft Office Excel in MindTap).

    GET SOLUTION BELOW

    CLICK HERE TO MAKE YOUR ORDER

    TO BE RE-WRITTEN FROM THE SCRATCH

    NO PLAGIARISM

    • Original and non-plagiarized custom papers. Our writers develop their writing from scratch unless you request them to rewrite, edit or proofread your paper.
    • Timely Delivery. capitalessaywriting.com believes in beating the deadlines that our customers have imposed because we understand how important it is.
    • Customer satisfaction. Customer satisfaction. We have an outstanding customer care team that is always ready and willing to listen to you, collect your instructions and make sure that your custom writing needs are satisfied
    • Privacy and safety. It’s secure to place an order at capitalessaywriting.com We won’t reveal your private information to anyone else.
    • Writing services provided by experts. Looking for expert essay writers, thesis and dissertation writers, personal statement writers, or writers to provide any other kind of custom writing service?
    • Enjoy our bonus services. You can make a free inquiry before placing and your order and paying this way, you know just how much you will pay. A verdict was rendered against three parent chaperones. How was the third parent included in the case?
    • Premium papers. We provide the highest quality papers in the writing industry. Our company only employs specialized professional writers who take pride in satisfying the needs of our huge client base by offering them premium writing services The Excel function =RANDBETWEEN(a,b) generates a random integer value between a and b

    Get Professionally Written Papers From The Writing Experts 

    Green Order Now Button PNG Image | Transparent PNG Free Download on SeekPNG Our Zero Plagiarism Policy | New Essays
    Categories
    Writers Solution

    Describe the purpose and function of financial management in an organization

    Competency

    In this project, you will demonstrate your mastery of the following competency:

    • Describe the purpose and function of financial management in an organization

    Scenario

    You have been an entry-level financial analyst for six months. Your supervisor, who is about to fill another entry-level financial analyst position on your team, has asked you to create a job aid about the financial analyst role to help the new hire transition smoothly. The job aid needs to describe the responsibilities of a financial analyst, the essential elements of the role, and the impact the role has on a business.

    Directions

    Create a job aid for a new hire to an entry-level financial analyst position. Your job aid should be thorough yet easy for someone new to the field of finance to understand. You are encouraged to use the Project One Financial Analyst Job Aid template in the Supporting Materials section to complete this assignment.

    Specifically, you must address the following:

    1. Financial Analyst Job Aid: In this job aid, you will give a general overview of financial management and its importance to a business.
      1. Financial Responsibilities: Describe the responsibilities of a financial analyst.
        1. In this section, outline the responsibilities a financial analyst has in terms of financial management. Add 5 to 7 specific bullet points outlining these responsibilities, and use complete sentences so that expectations are clear.
      2. Financial Management Decisions: Discuss the importance of using financial management for business decisions, and provide examples to support your claims.
        1. Consider the bullet points you outlined above. How do those responsibilities help to inform management decisions, and what would happen if management didn’t have this information? This should be a brief paragraph with examples.
      3. Accounting Principles: Explain how accounting principles are used to analyze a business’s financial health, and provide examples to support your claims.
        1. Write a brief paragraph that explains accounting principles and how they are used within financial management in relation to analyzing financial health. What accounting information and approaches do financial analysts rely on, and how do they use it? What would happen if that information was not available or was not accurate?
      4. Financial Statements: Describe how financial statements are used to help businesses make finance-related decisions, and provide examples to support your claims.
        1. Consider identifying the information contained in financial statements and what financial analysts would need in order to do their job. What types of finance-related business decisions would this information help to inform? Provide real or fictional examples to help show this.
      5. Financial Terminology: Explain how a financial analyst would use the financial terms in their day-to-day responsibilities in a clear, easy-to-understand way.
        1. Define each term listed below and provide a 1- to 2-sentence explanation of how a financial analyst might use the term, especially when communicating information to management or clients, or when relaying information to inform important decisions:
          • Financial statement
          • Liquidity
          • Working capital
          • Diversification
          • Time value of money

    What to Submit

    To complete this project, you must submit the following:

    Financial Analyst Job Aid
    Submit your job aid as a 2- to 3- page Word document with 12-point Times New Roman font, double spacing, and one-inch margins. Or, you may use the Project One Financial Analyst Job Aid template to help you complete this assignment. Sources should be cited according to APA style

    GET SOLUTION BELOW

    CLICK HERE TO MAKE YOUR ORDER

    TO BE RE-WRITTEN FROM THE SCRATCH

    NO PLAGIARISM

    • Original and non-plagiarized custom papers. Our writers develop their writing from scratch unless you request them to rewrite, edit or proofread your paper.
    • Timely Delivery. capitalessaywriting.com believes in beating the deadlines that our customers have imposed because we understand how important it is.
    • Customer satisfaction. Customer satisfaction. We have an outstanding customer care team that is always ready and willing to listen to you, collect your instructions and make sure that your custom writing needs are satisfied
    • Privacy and safety. It’s secure to place an order at capitalessaywriting.com We won’t reveal your private information to anyone else.
    • Writing services provided by experts. Looking for expert essay writers, thesis and dissertation writers, personal statement writers, or writers to provide any other kind of custom writing service?
    • Enjoy our bonus services. You can make a free inquiry before placing and your order and paying this way, you know just how much you will pay. A verdict was rendered against three parent chaperones. How was the third parent included in the case?
    • Premium papers. We provide the highest quality papers in the writing industry. Our company only employs specialized professional writers who take pride in satisfying the needs of our huge client base by offering them premium writing services Financial Analyst Job Aid:

    Get Professionally Written Papers From The Writing Experts 

    Green Order Now Button PNG Image | Transparent PNG Free Download on SeekPNG Our Zero Plagiarism Policy | New Essays
    Categories
    Writers Solution

    Discuss and forecast how innovation will impact Marketing function over the next 15 yrs?

    Total 18 minutes PowerPoint presentation. 5 Minutes on below each topic with a presentation script.

    1- Discuss and forecast how innovation will impact Marketing function over the next 15 yrs?

    2- What we want to know is how will that function evolve to influence the work we will be doing in the future?

    3- How will marketing influence the value chain and competitiveness?

    4- Why must we evolve (skills, leadership, tools, etc.) to manage that process?

    GET SOLUTION FOR THIS ASSIGNMENT, Get Impressive Scores in Your Class

    CLICK HERE TO MAKE YOUR ORDER

    TO BE RE-WRITTEN FROM THE SCRATCH

    GET SOLUTION FOR THIS ASSIGNMENT

    CLICK HERE TO MAKE YOUR ORDER

    TO BE RE-WRITTEN FROM THE SCRATCH

    NO PLAGIARISM

    • Original and non-plagiarized custom papers- Our writers develop their writing from scratch unless you request them to rewrite, edit or proofread your paper.
    • Timely Deliveryprimewritersbay.com believes in beating the deadlines that our customers have imposed because we understand how important it is.
    • Customer satisfaction- Customer satisfaction. We have an outstanding customer care team that is always ready and willing to listen to you, collect your instructions and make sure that your custom writing needs are satisfied
    • Confidential- It’s secure to place an order at primewritersbay.com We won’t reveal your private information to anyone else.
    • Writing services provided by experts- Looking for expert essay writers, thesis and dissertation writers, personal statement writers, or writers to provide any other kind of custom writing service?
    • Enjoy Please Note-You have come to the most reliable academic writing site that will sort all assignments that that you could be having. We write essays, research papers, term papers, research proposals. Discuss and forecast how innovation will impact Marketing function over the next 15 yrs?

    Get Professionally Written Papers From The Writing Experts 

    Green Order Now Button PNG Image | Transparent PNG Free Download on SeekPNG Our Zero Plagiarism Policy | New Essays