can you please prepare my MS excel assignment I need it on 24th March at 10.00 Am and how much i need to pay for this
Sheet1 MonthShipperCrude TypeBarrels ShippedTankage UsedDelivery LocationCrude CodeFull NameSediment & Water % JanuaryWCS50,000YESHardistyWCSWestern Canadian Select0.20% JanuaryWCS25,000YESChicagoWTIWest Texas Intermediate0.15% JanuaryWTI60,000YESGulf CoastBRBrent0.05% JanuaryBR45,000NOMontrealSYNSynthetic Sweet Blend0.04% JanuaryLSB35,000YESChicagoLSBLight Sour Blend0.12% JanuaryWTI66,000YESGulf CoastCBHCanadian Heavy Blend0.35% JanuaryWTI75,000YESGulf Coast JanuaryCBH18,000NOHardisty JanuaryWCS25,000YESCushing JanuaryBR27,000NOMontreal JanuaryBR50,000NOChicago JanuaryWCS25,000YESCushing JanuaryWTI77,000YESChicago JanuaryBR25,000NOChicago JanuaryLSB56,000YESChicago JanuaryCBH10,000NOHardisty JanuaryCBH12,000NOChicago JanuaryBR24,000NOChicago JanuarySYN25,000YESHardisty JanuarySYN25,000YESMontreal JanuarySYN25,000YESGulf Coast FebruaryWTI90,000YESChicago FebruaryLSB20,000YESChicago FebruaryWCS50,000YESCushing FebruaryWTI65,000YESGulf Coast FebruaryBR37,000NOMontreal FebruaryWTI80,000YESGulf Coast FebruaryWTI88,000YESGulf Coast FebruaryBR29,500NOMontreal FebruaryBR28,000NOMontreal FebruaryLSB23,000YESChicago FebruaryWCS50,000YESHardisty FebruaryCBH15,000NOChicago FebruaryLSB28,000YESChicago FebruaryLSB30,000YESChicago FebruaryBR50,000NOChicago FebruaryCBH11,000NOHardisty FebruaryLSB33,000YESChicago FebruaryLSB27,000YESChicago FebruaryWTI65,000YESChicago FebruaryBR55,000NOMontreal FebruaryBR45,000NOChicago FebruaryBR30,000NOMontreal FebruaryLSB25,000YESChicago FebruarySYN25,000YESGulf Coast FebruarySYN25,000YESHardisty FebruarySYN25,000YESMontreal FebruarySYN25,000YESChicago MarchBR14,000NOMontreal MarchLSB12,000YESChicago MarchWCS10,000YESHardisty MarchCBH5,000NOHardisty MarchBR15,000NOChicago MarchLSB10,000YESChicago MarchWCS15,000YESChicago MarchWTI18,500YESChicago MarchWTI13,000YESGulf Coast MarchLSB18,000YESChicago MarchWCS5,000YESCushing MarchBR18,500NOChicago MarchCBH6,500NOChicago MarchLSB9,000YESChicago MarchBR9,000NOChicago MarchLSB14,000YESChicago MarchBR12,000NOMontreal MarchWTI25,000YESGulf Coast MarchWCS10,000YESChicago MarchSYN25,000YESChicago MarchSYN25,000YESHardisty MarchSYN25,000YESMontreal AprilSYN25,000YESHardisty AprilSYN25,000YESHardisty AprilSYN25,000YESChicago AprilLSB9,000YESChicago AprilBR11,000NOMontreal AprilCBH7,500NOChicago AprilLSB12,000YESChicago AprilWCS15,000YESHardisty AprilLSB11,000YESChicago AprilWTI19,000YESChicago AprilBR9,000NOMontreal AprilLSB8,000YESChicago AprilWCS5,000YESHardisty AprilBR10,000NOChicago AprilLSB14,000YESChicago AprilWCS5,000YESCushing AprilWTI15,000YESGulf Coast AprilCBH9,000YESChicago AprilLSB12,000YESChicago AprilBR9,500NOMontreal AprilWCS10,000YESCushing AprilCBH5,000NOHardisty AprilCBH7,000NOHardisty AprilBR9,000NOChicago AprilWCS15,000YESChicago MayBR20,000NOChicago MayWCS25,000YESHardisty MayWTI90,000YESChicago MayCBH16,000NOHardisty MayCBH11,000NOHardisty MayWTI66,000YESGulf Coast MayWCS25,000YESChicago MayBR25,000NOChicago MayLSB40,000YESChicago MayBR28,000NOChicago MayLSB39,500YESChicago MayLSB45,000YESChicago MayWCS25,000YESHardisty MayWCS25,000YESCushing MayBR24,000NOMontreal MayBR30,000NOMontreal MayLSB30,000YESChicago MayWCS25,000YESHardisty MayWCS50,000YESHardisty MayLSB29,000YESChicago MayLSB34,000YESChicago MayWTI75,000YESGulf Coast MayWTI80,000YESGulf Coast MayLSB35,000YESChicago MayBR35,000NOMontreal MayWCS25,000YESChicago MayBR48,000NOChicago MayLSB28,000YESChicago MayWTI77,000YESChicago MayCBH10,000NOChicago MayBR28,000NOMontreal MayCBH12,500NOChicago MayLSB25,000YESGulf Coast MayWCS25,000YESChicago MayWCS50,000YESCushing MaySYN25,000YESHardisty MaySYN25,000YESMontreal MaySYN25,000YESGulf Coast MaySYN25,000YESHardisty JuneWTI95,000YESGulf Coast JuneWCS25,000YESCushing JuneWCS25,000YESHardisty JuneWCS25,000YESCushing JuneWTI60,000YESGulf Coast JuneLSB25,500YESChicago JuneWTI65,000YESGulf Coast JuneLSB35,000YESChicago JuneBR45,000NOChicago JuneWCS50,000YESHardisty JuneCBH13,000NOChicago JuneBR55,000NOMontreal JuneWCS25,000YESHardisty JuneWCS50,000YESHardisty JuneWCS50,000YESCushing JuneLSB30,000YESChicago JuneWTI70,000YESChicago JuneCBH17,000NOHardisty JuneWTI75,000YESGulf Coast JuneWTI88,000YESGulf Coast JuneLSB44,000YESChicago JuneLSB38,000YESChicago JuneLSB29,000YESChicago JuneWCS50,000YESChicago JuneBR52,000NOChicago JuneBR49,000NOMontreal JuneWTI67,000YESChicago JuneWTI59,000YESGulf Coast JuneWTI80,000YESGulf Coast JuneCBH14,000NOChicago JuneLSB30,000YESChicago JuneLSB40,000YESChicago JuneWCS25,000YESChicago JuneBR47,500NOChicago JuneBR39,000NOMontreal JuneWCS25,000YESCushing JuneSYN25,000YESChicago JuneSYN25,000YESGulf Coast JuneSYN25,000YESMontreal JuneSYN25,000YESHardisty JuneSYN25,000YESGulf Coast JuneSYN25,000YESHardisty JulyWCS50,000YESChicago JulyWCS25,000YESHardisty JulyBR40,000NOMontreal JulyBR40,000NOChicago JulyLSB32,000YESChicago JulyLSB32,000YESChicago JulyCBH18,000NOHardisty JulyCBH16,000NOHardisty JulyWCS50,000YESHardisty JulyWCS25,000YESChicago JulyWTI90,000YESGulf Coast JulyWTI77,000YESGulf Coast JulyLSB35,000YESChicago JulyWCS25,000YESCushing JulyWCS25,000YESCushing JulyWTI45,000YESChicago JulyLSB28,000YESChicago JulyWCS50,000YESCushing JulyWTI40,000YESChicago JulyWCS25,000YESHardisty JulyBR59,000NOChicago JulyLSB25,000YESChicago JulyWTI55,000YESChicago JulyWTI48,500YESChicago JulyBR60,000NOChicago JulyBR30,000NOChicago JulyWTI77,000YESGulf Coast JulyWTI67,000YESGulf Coast JulyCBH13,500NOChicago JulyLSB25,000YESChicago JulyWTI59,000YESGulf Coast JulyLSB40,000YESChicago JulyBR40,000NOMontreal JulySYN25,000YESHardisty JulySYN25,000YESGulf Coast JulySYN25,000YESMontreal JulySYN25,000YESChicago AugustSYN25,000YESChicago AugustSYN25,000YESMontreal AugustSYN25,000YESHardisty AugustSYN25,000YESGulf Coast AugustSYN25,000YESHardisty AugustBR45,000NOMontreal AugustBR65,000NOMontreal AugustLSB30,000YESChicago AugustWCS50,000YESChicago AugustWTI88,000YESChicago AugustWTI92,000YESChicago AugustCBH14,500NOHardisty AugustCBH12,000NOChicago AugustLSB25,000YESChicago AugustWTI59,000YESGulf Coast AugustLSB28,500YESChicago AugustWTI68,000YESGulf Coast AugustWCS50,000YESChicago AugustWTI75,000YESChicago AugustWTI70,000YESGulf Coast AugustBR44,000NOChicago AugustWTI80,000YESGulf Coast AugustBR39,000NOChicago AugustLSB32,000YESChicago AugustLSB24,000YESChicago AugustLSB34,000YESChicago AugustBR42,000NOChicago AugustWCS50,000YESCushing AugustWCS50,000YESHardisty AugustCBH12,500NOChicago AugustWTI65,000YESGulf Coast AugustWCS50,000YESHardisty AugustBR57,000NOChicago AugustWTI74,000YESChicago AugustLSB35,000YESChicago AugustWCS50,000YESCushing AugustLSB40,000YESChicago AugustWCS50,000YESCushing AugustLSB38,000YESChicago AugustWTI72,000YESChicago AugustWCS25,000YESCushing AugustBR45,500NOMontreal AugustWCS25,000YESHardisty AugustBR35,500NOChicago AugustBR39,000NOChicago AugustWCS25,000YESChicago AugustWTI83,000YESChicago AugustLSB29,000YESChicago AugustLSB30,000YESChicago AugustWCS50,000YESChicago AugustBR45,000NOChicago SeptemberWCS50,000YESHardisty SeptemberBR42,000NOChicago SeptemberLSB35,000YESChicago SeptemberBR55,000NOChicago SeptemberBR55,500NOMontreal SeptemberBR38,500NOChicago SeptemberCBH11,000NOHardisty SeptemberCBH19,000NOChicago SeptemberLSB42,000YESChicago SeptemberBR40,000NOMontreal SeptemberLSB22,000YESChicago SeptemberBR40,000NOChicago SeptemberBR38,000NOChicago SeptemberWTI90,000YESGulf Coast SeptemberBR50,000NOMontreal SeptemberWCS25,000YESChicago SeptemberWCS50,000YESCushing SeptemberLSB32,000YESChicago SeptemberBR45,000NOMontreal SeptemberWTI69,000YESGulf Coast SeptemberWTI48,000YESChicago SeptemberBR50,000NOMontreal SeptemberWTI74,000YESGulf Coast SeptemberBR33,000NOMontreal SeptemberBR29,000NOChicago SeptemberLSB40,000YESChicago SeptemberLSB37,000YESChicago SeptemberBR41,500NOMontreal SeptemberBR38,500NOChicago SeptemberBR36,000NOChicago SeptemberSYN25,000YESChicago SeptemberSYN25,000YESGulf Coast SeptemberSYN25,000YESMontreal SeptemberSYN25,000YESHardisty SeptemberSYN25,000YESGulf Coast SeptemberSYN25,000YESChicago SeptemberSYN25,000YESHardisty SeptemberSYN25,000YESMontreal OctoberWCS25,000YESHardisty OctoberWCS50,000YESCushing OctoberWCS25,000YESCushing OctoberWCS50,000YESChicago OctoberBR44,000NOChicago OctoberBR50,000NOChicago OctoberLSB42,000YESChicago OctoberLSB41,000YESChicago OctoberCBH18,000NOChicago OctoberWTI85,000YESChicago OctoberLSB39,000YESChicago OctoberSYN25,000YESGulf Coast OctoberBR60,000NOChicago OctoberBR52,000NOMontreal OctoberSYN5,000YESHardisty OctoberSYN25,000YESHardisty OctoberLSB35,000YESChicago OctoberSYN25,000YESMontreal OctoberSYN25,000YESChicago OctoberLSB38,000YESChicago OctoberSYN25,000YESMontreal OctoberSYN25,000YESHardisty OctoberBR49,500NOMontreal OctoberSYN25,000YESHardisty OctoberWTI85,500YESGulf Coast OctoberWTI76,000YESGulf Coast OctoberCBH12,000NOHardisty OctoberBR44,000NOChicago OctoberLSB20,000YESChicago OctoberLSB40,000YESChicago OctoberLSB45,000YESChicago OctoberBR38,000NOChicago OctoberBR39,000NOMontreal NovemberSYN25,000YESMontreal NovemberSYN25,000YESChicago NovemberSYN25,000YESGulf Coast NovemberSYN25,000YESHardisty NovemberSYN25,000YESHardisty NovemberBR28,000NOMontreal NovemberWCS25,000YESChicago NovemberBR44,000NOChicago NovemberLSB50,000YESChicago NovemberWCS25,000YESCushing NovemberLSB55,000YESChicago NovemberCBH10,000NOHardisty NovemberCBH17,000NOChicago NovemberBR43,000NOMontreal NovemberWCS50,000YESHardisty NovemberWTI70,000YESChicago NovemberBR50,000NOChicago NovemberWTI75,000YESGulf Coast NovemberLSB40,000YESChicago NovemberBR29,000NOChicago NovemberLSB38,000YESChicago NovemberWTI82,000YESGulf Coast NovemberWCS50,000YESHardisty NovemberBR30,000NOChicago NovemberWTI80,000YESChicago NovemberLSB36,000YESChicago DecemberWCS25,000YESChicago DecemberWCS25,000YESChicago DecemberWCS50,000YESCushing DecemberWCS50,000YESHardisty DecemberWCS25,000YESHardisty DecemberSYN25,000YESHardisty DecemberSYN25,000YESMontreal DecemberSYN25,000YESChicago DecemberSYN25,000YESGulf Coast DecemberLSB31,000YESChicago DecemberBR40,000NOChicago DecemberLSB29,000YESChicago DecemberLSB30,000YESChicago DecemberBR45,000NOMontreal DecemberLSB35,000YESChicago DecemberLSB36,000YESChicago DecemberBR38,000NOMontreal DecemberWTI68,000YESGulf Coast DecemberLSB37,000YESChicago DecemberWTI89,000YESChicago DecemberCBH14,500NOChicago DecemberBR44,000NOChicago DecemberLSB27,500YESChicago DecemberBR39,000NOChicago DecemberWTI94,000YESGulf Coast DecemberCBH18,500NOHardisty MGMT2301 – Critical Thinking Assignment (15%) Scenario You are a Junior Analyst working for local pipeline company. Your pipeline company ship crude oil for many different producers (known as shippers), to different locations across North America. You provide a transportation service, and a storage (tankage) service, for shippers to move their product from their drilling sites to their refineries. The company transports many different types of crude oil through their complex pipeline system. “According to the Canadian Fuels Association, there are more than 150 different types of crude oil in the world. Heavy oil has a higher proportion of heavier hydrocarbons composed of longer carbon-plus-hydrogen molecule chains. Heavy crude oils are less expensive for a refinery to purchase but more expensive to refine, since they have greater costs from higher energy inputs and additional processing to meet environmental requirements.” (Quan, 2020) Your boss has asked you to review some of the activity for the last year for discrepancies, errors in data, and interesting trends. She knows you were hired for your excellent critical thinking, problem-solving skills, and ability to make reasonable assumptions should information not be presented, therefore she thought you would be the best person to complete this analysis and provide her with excellent data analysis and a summary of your findings. Your role as an analyst is to critically assess the information provided to you (the Excel document) and present it back to your boss with your analysis, any potential data errors you may have discovered, any data trends and any recommendations you may have. Utilize what you have learned so far in this class by applying multiple tools and visuals to determine what the data is saying and make your recommendations according to what you find. Assignment Instructions This is an individual assignment. As this is also an assignment based on critical thinking, no two assignments should be the same. Everyone assesses and presents in a different way. Turnitin is enabled for this project, and original work is expected. · Your focus for this project is to demonstrate your critical thinking skills (problem-solving, communicating, judgement of information, decision making, and thinking impartially). Utilize the skills you have learned in the course as a tool to aid in this. · Excel Document: · STEP 1: Create a drop-down list in Column C of six (6) Oil Companies of your choice from Appendix B. Allocate a company to each oil batch. · Utilize multiple different tools that you have learned throughout the semester to analyze/present the data in front of you. · Your Excel document will also be submitted as back up for your instructor to see your analysis, use of formulas, tools, and visual aids. · Word Document: · Part 1: Critical Thinking Approach · There are 4 different approaches within the critical thinking framework. Utilizing the material from the course, explain the critical thinking approach you took, and why it fits with yourself, and the scenario presented. · Part 2: Analysis/Findings · Clearly articulate the approach you took to analyzing the data, and what you have discovered. Add images from your analysis to assist. · Part3: Conclusion/Recommendations · In detail, clearly articulate any recommendations you have for the company, or your conclusion of the situation based on your analysis and findings. Deliverables Read the grading rubric prior to the start of this assignment to ensure you are aware of how you will be assessed. Submit the below into the dropbox by the due date. Late submissions will be accepted up to 2 days (48 hours) at a penalty of 20%/day. After 48 hours, no submissions will be accepted. You will submit the following for grading for this assignment: · Excel document with the original data and separate worksheets for your analysis, graphs, charts, etc. · Word document that explains which critical thinking approach you took and why (from the course content), highlights of your analysis, and details of your recommendations. Appendix A: Cognitive Skills that Underlie Critical Thinking · demonstrate a clear understanding of the assignment’s purpose · clearly define the issue or problem · accurately identify the core issues · appreciate depth and breadth of the problem · demonstrate fair-mindedness toward the problem · identify and evaluate relevant significant points of view · examine relevant points of view fairly, empathetically · gather sufficient, credible, relevant information: observations, statements, logic, data, facts, questions, graphs, themes, assertions, descriptions, etc. · include information that opposes as well as supports the argued position · distinguish between information and inferences drawn from that information · identify and accurately explain/use relevant key concepts · accurately identify assumptions (things taken for granted) · make assumptions that are consistent, reasonable, and valid · follow where evidence and reason lead in order to obtain defensible, thoughtful, logical conclusions or solutions · make deep rather than superficial inferences · make inferences that are consistent with each other · identify the most significant implications and consequences of the reasoning (whether positive and/or negative) · distinguish probable from improbable implications @Foundation for Critical Thinking (www.criticalthinking.org) Based on the work of Drs. Paul and Elder and created by Connie Wolfe, Surry Community College Appendix B: Petroleum Producer List Appendix C: Industry Information “Spring break-up describes the time of year when the oil industry, specifically across western Canada, slows down due to the melting snow and frost that causes the ground to become soft and muddy. Mud may not seem a good enough reason to halt an entire industry, but when you are dealing with equipment that weighs as much as oilfield equipment does, a little bit of mud can cause some big problems. As everything melts, the ground becomes softer – even under the roads. If the ground under the roads is not completely stable and heavy trucks or equipment are continuously using the roads there is a high chance that the roads can become damaged due to this weakened integrity. We all know Canada has too many potholes already, so to combat this issue and attempt to save the roads, the provincial and municipal governments have begun to implement weight restrictions on the roads during this time of year – these weight restrictions are essentially road bans that limit what type of vehicles can use the road. With road