Premium Essay

1123

In:

Submitted By awais12345
Words 1012
Pages 5
Unit 6 Advanced Spreadsheet Skills
Assignment 6.1
This assignment covers the following grading criteria (P1, P2, P5, M1, and D1)

The assessed tasks in this unit are based on the scenario below

Scenario

MNK is a local company who publish 10 different magazines/newspapers in a variety of languages specifically for the Bradford area. They have been approached by other cities interested in their work. MNK are therefore looking to expand their operation to at least one more large city. To achieve this they will need to apply for extra funding from their bank.

To support the funding application, the company needs to analyse and review the sales data and costs for the last financial year, which is included in Appendix A. This will require the production of a working spreadsheet model which will enable the production of suitable reports and graphs of current and predicted sales and financial data.

You have been approached by MNK to create this spreadsheet model. By using the MNK Sales Data provided, your spreadsheet will hopefully show that MNK is a well run business, capable of expansion. You need to carry out the tasks listed below. Successful completion of these tasks may enable you to achieve the following grading criteria:

P1 - create a complex spreadsheet that is fit for purpose and check accuracy
P2 - use formulae and functions to solve a complex problem
P5 – use conversion facilities to export the contents of a spreadsheet to an alternative format
M1 - check accuracy of a spreadsheet using a range of appropriate techniques and explain the choice of techniques used
D1 - evaluate a spreadsheet, its fitness for purpose and its effectiveness in providing information to meet a particular user need

Task 1 (P1) • Produce a spreadsheet and input the sales data from Appendix A. • Ensure that your spreadsheet includes complex formulae

Similar Documents

Premium Essay

1123

...Feedback Factor I : Extraversion (AKA Surgency) This trait reflects preference for, and behavior in, social situations. People high in extraversion are energetic and seek out the company of others. Low scorers (introverts) tend to be more quiet and reserved. Compared to other people who have taken this test, your score on this dimension (25) is about average. Factor II : Agreeableness (AKA Friendliness) This trait reflects how we tend to interact with others. People high in agreeableness tend to be trusting, friendly and cooperative. Low scorers tend to be more aggressive and less cooperative. Compared to other people who have taken this test, your score on this dimension (22) is relatively low. Factor III : Conscientiousness (AKA Will or Dependability) This trait reflects how organized and persistent we are in pursuing our goals. High scorers are methodical, well organized and dutiful. Low scorers are less careful, less focussed and more likely to be distracted from tasks. Compared to other people who have taken this test, your score on this dimension (33) is about average. Factor IV : Neuroticism This trait reflects the tendency to experience negative thoughts and feelings. High scorers are prone to insecurity and emotional distress. Low scorers tend to be more relaxed, less emotional and less prone to distress. Compared to other people who have taken this test, your score on this dimension (24) is about average. Factor V : Openness (AKA Culture or Intellect) This...

Words: 382 - Pages: 2

Premium Essay

1123

...Create an Effective Advertising Plan Product, Price, Place, & Promotion Your marketing plan has positioned your company in terms of product, price, and place. You have made decisions about what market segment you will compete in. You have considered products and services, distribution, pricing, guarantees, quality, policies, etc. You have set objectives and goals. Now it’s time to decide how you will promote your company to achieve those objectives and goals. Define Your Customers. The number one reason advertising fails is because it is poorly targeted. No advertising is going to be successful if its target audience is not well defined and understood. Talk to your customers and potential prospects. Listen to them. Understand them. We have provided you with some excellent strategies for defining your customers. Please read the Market Targeting Strategy and the Generating Better Qualified Prospects chapters. These two chapters will give you insight into defining your customers, and knowing what they need, want, and desire. There are a few things to note here about your customers. First, your target group does not include the whole world. If you try to advertise to the whole world, you will go out of business. Second, in many companies, 20% of the customers account for 80% of sales, and often 100% of the profits. These are the high usage customers that you want to target. Define who they are. Third, one out of ten people strongly influence the...

Words: 4433 - Pages: 18

Premium Essay

Programming Language Using Oojavacom 121

...oriented approach. The systems design activity will be studied in the context of these trends. Students should make themselves familiar with at least one traditional approach (e.g. SSADM) and one object oriented approach (e.g. UML). Aims: To understand the role of systems design within various systems development life cycles To develop awareness of the different approaches that may be taken to systems design To understand and apply the tools and techniques that are currently used by systems designers Formatted: Superscript      Objectives: Describe different life cycle models and explain the contribution of systems design within them Discuss various systems development approaches and explain their strengths and weaknesses 1 30/09/1123/09/10 Evaluate the tools and techniques that may be used by a system designer in a given context Use appropriate methods to produce a system design for a given scenario     Provide suitable systems documentation for a design Discuss the CASE tools currently available Content: Week 1- 3 Week 4-5 Week 6-8 Week 9-12 SYSTEMS DEVELOPMENT LIFE CYCLE MODELS Traditional Waterfall Model Alternative Models Iterative; Spiral; Rapid Application Development; Prototyping; Joint Application Design; User Participation SYSTEMS DEVELOPMENT APPROACHES An overview of the following approaches and role of design within them: Structured Systems...

Words: 2312 - Pages: 10

Free Essay

Czairrah

...Czairrah Mae C. Manalo Filipino 101 GE-1123 1. Parirala Ang matanda ay naglaba. Ang bata ay masaya. Naglilinis ang babae sa bahay. Gumagawa ng proyekto ang mag-aaral. Si Rhea Ay Magaling na guro. Sugnay Ang mga ibon ay nawala na nang nakalbo ang kagubatan. Hindi maganda si Flor ngunit matalino naman. Natulog ako kahapon sapagkat antok na antok ako. Pagkatapos ng palabas, mamasyal tayo sa Luneta. Pag marami ng naipon si Armie, pwede na siyang mag-enroll. 2. Dalawang Uri ng Sugnay a. Punong Sugnay o Sugnay na Makapag-iisa Nagbabasa ako ng libro upang makasagot bukas. Bibili ako ng libro upang makapag aral ako Si Kim Chiu ay sumasayaw. Si Xian Lim ay kumakanta. Ang bata ay naglalaro ng piko. b. Panulong na Sugnay o Sugnay na di makapag-iisa Likas na tahimik ang mga Ilokano. Walang hanganan ang teritoryo nila. Kapag ipinagpatuloy mo ang iyong mithiin. Kung magbabago ang iyong mga paniniwala sa buhay. Habang naghihintay ako sa parke 3. Pangungusap: Uri, Anyo, Katangian Di-ganap Ganap a. Panaguring Pangngalan Ang aking kaibigan ay si Lea. Luntiang Rebolusyon ang paksa ng pulong.   b. Panaguring Panghalip Ang aking kaibigan ay siya.  Ako ang tinatawanan ng buong klase.  Siya ay mayroong malabong mata. Sila ang magagaling na manggagawang pilipino na napilitang mangibang-bansa. Kayong mga kabalat namin ang aming inaasahan sa kilusang ito.  c. Panaguring Pang-uri Siya ay mabait. Si Maria ay malungkot...

Words: 326 - Pages: 2

Free Essay

Comp 2 Practice Essay

...Eng 1123 27 January 2013 Practice Essay Three New Year’s Resolutions At the beginning of every year people always have resolutions. These resolutions are set to accomplish something to better that person. Most people think they will come easy and usually they don’t achieve them, but if they would dedicate themselves it would surprise them how much easier it would be. A resolution to me is a challenge to better myself in the year. I have three New Year’s resolutions in order to make 2013 a successful year. My first resolution is to maintain my 4.0 grade point average. I worked hard throughout the 2012 fall semester to have a perfect GPA and accomplished it. Now that 2013 is here I plan to keep my grades up. Accomplishing this resolution will be difficult due to nearly sixty baseball games and practices throughout this spring semester, but I will continue to push myself and come out on top. This is my top resolution because it will help me achieve going on to a four year college and aid being successful in life. The second resolution I have is being a starter on the Hinds baseball team. Dedication is the key to accomplishing this task. I have to work hard and be the best I can be every day. Being surrounded by talented players on my team will make this hard to achieve, but I have to prove that I’m the one of the guys that needs to be in the lineup in order to win. This will be difficult, but by pushing myself I know I can succeed in this resolution. My...

Words: 434 - Pages: 2

Premium Essay

Feminism As Portrayed In My Last Duchess And Barbie Doll

...return, whom she can see. This follows the theme of control that is found throughout the poem. It was men that decided societal rules for the Duchess to follow, and it was a man who judged her actions as impure with a punishment as death for the actions. Although the Duchess died because a man’s rule, it was societal pressures that caused death in “Barbie Doll” by Marge Piercy. At a young age, this girl is given toys that are seen as feminine, and they promoted a hard to reach ideal of what and who a woman is: “...presented dolls that did pee-pee/and miniature GE stoves and irons,” (Piercy 1123). Then, in adolescence, a fellow student told her she was overweight and her nose disproportionate. In contrast, she was a healthy girl. She was smart, strong, and didn’t have any health complications. In her mind, all people saw were her flaws: “Everyone saw a fat nose on thick legs,” (Piercy 1123). She was told to be alluring, yet shy. She was told to be in shape by exercise and dieting. Too soon, she couldn’t hold back her stress. She cuts off her legs and her nose, only wanting to be as pretty as she possibly could. In death, people commented on how pretty she was, possibly the prettiest she’s ever been: “Doesn’t she look pretty? everyone said,” (Piercy 1124). At last, the girl was able to receive the recognition she craved, but she was not alive to appreciate it. The poem’s anapestic trimeter gave the poem a child-like tone. This contrasts morbidly with the grotesque death...

Words: 1445 - Pages: 6

Premium Essay

Plagiarism

...Jzmyne Flakes September 7, 2015 Freshman Comp 1123 PLAGIARISM WORKSHEET Using someone else’s ideas or phrasing and representing those ideas or phrasing as our own, either on purpose or through carelessness, is a serious offense known as plagiarism. Using other people’s ideas or phrasing includes written or spoken material—from whole papers and paragraphs to sentences and parts of sentences. This also includes statistics, lab results, art work, etc. “Someone else” can mean a professional source, such as a published writer or critic in a book, magazine, encyclopedia, or journal; an electronic resource such as material we discover on the Internet; another student at our school or anywhere else; a paper-writing “service” (online or otherwise) which offers to sell written papers for a fee. Below is an original passage from a source followed by four passages that paraphrase and/or quote the source. For each of the four passages, identify whether it is or is not plagiarism and briefly explain your answer. This is the original text from Elaine Tyler May’s “Myths and Realities of the American Family”: Because women’s wages often continue to reflect the fiction that men earn the family wage, single mothers rarely earn enough to support themselves and their children adequately. And because work is still organized around the assumption that mothers stay home with children, even though few mothers can afford to do so, child-care facilities in the United States remain...

Words: 649 - Pages: 3

Premium Essay

Evolution of a Training Program in Use of Electronic Medical Records: Towards Efficiency and Quality Scale-Up “Doing More with Less”

...Evolution of a Training Program in Use of Electronic Medical Records: Towards Efficiency and Quality Scale-Up “Doing more with less” Introduction International Training and Education Center for Health (I-TECH) is a global network that supports the development of a skilled health work force to provide effective prevention, care, and treatment of infectious disease in the developing world I-TECH provides technical assistance to the Kenyan Ministry of Health for implementation of an open-source electronic medical record (EMR) system, called KenyaEMR (hosted on Open MRS platform) within 315 public health facilities in four regions of Kenya. Before implementation, I-TECH carried out a training needs assessment among personnel in 23 facilities. Distinct training needs for health managers and front-line health care workers identified Method I-TECH implemented three different strategies in delivering KenyaEMR trainings to users Trainings were delivered by three different groups (training institutions, centrally located facilitators, county facilitators) Training locations transitioned from off-site (hotel-based) trainings to on-site (facility-based) trainings in a bid to train more health care workers (HCW) Length and content of trainings was adjusted in response to curriculum evaluation and strategy changes to incorporate mentorship sessions Strategy #1 • Five-day off site user training • Delivered by facilitators from training institutions Strategy #2 • Three-day off...

Words: 458 - Pages: 2

Free Essay

What

...conduct an interview with you on JuIy 16,2014 at 9:00AM. A representative called and confirmed this appointment date and time with you prior to it being scheduled If you have any questions, please call 866-572-8376 EXT 10854 and ask for Ms. Vizgirda. IT IS IMPORTANT THAT THIS APPOINTMENT BE KEPT OR YOUR APPLICATION MAY BE DENIED. IF WE DO NOT HEAR FROM YOU WITHIN 30 DAYS, YOUR CLAIM WILL BE DENIED. &a,a/ S"o anty 4/auktrafi'o,r Supplemental Security Income ffi @ Social Security Administration NotICe of Change in Paymenf w w g SOCIAL SECURITY 550 ST ROOM 2000 W ffi MAIN r : w ffi H M g B ffi w B 6 m m CINCINNATI OH 45202 z -l ie # 000002666 I=000000 387 1.1S1780n34503 1123 02 cd,t Date: November 30, 201,tr Claim Number: 401-86-8182 DI rl,rrr,ll'll1lllll,;'l'l',r1,1;ll;,lllllll'llt"llll,lltlrll,,ll 266a 1 t|B 0.432 q a 7. o 4 ttll:l:.t l:&s- TROY LEE PETTY A 6rrv?r ot f oo !g m & w @ E ffi M H!}# EEr 16s6 LLANFAIR AVE CINCINNATT oH Abzz4-zqgi w m ffi g m m m g We are writing to tell you about changes in your Supplemental Security Income (SSI) payments. The rest of tliis letter will tell you more about this chanEe. This letter also includes how to find information about affordable healt[ care. months where payment amounts change. a J! tn We explain how 'we fig,rred the nlonthly payment...

Words: 609 - Pages: 3

Premium Essay

Autism

...Smith & Nephew, Inc. (formerly Smith & Nephew Richards) 1450 Brooks Road Memphis, Tennessee 38116 United States Telephone: 800-238-7538 or 901-396-2121. Web: http://www.smith-nephew.com. Recreation Again LLC 211A Jones Chapel Road Leoma, Tennessee 38468 United States Telephone: 800-634-4351 or 931-852-5455. Web: http://www.recreationagain.com. Precision Lifts, a Division of Precision Ladders LLC P.O. Box 2279 Morristown, Tennessee 37816 United States Telephone: 800-535-4387. Fax: 423-586-2091. Web: http://www.precisionlifts.com. Email: info@precisionlifts.com. Mason Corporation 8114 Isabella Lane Brentwood, Tennessee 37027 United States Telephone: 800-821-4141 or 615-373-8787. Fax: 615-373-8796. Web: http://www.masoncorporation.com. Email: info@masoncorporation.com. Life@Home 3630-F Trousdale Drive Nashville, Tennessee 37204 United States Telephone: 800-653-1923 or 615-831-5411. Web: http://www.lifehome.com. Email: info@lifehome.com. Knowledge Products Inc. 722 Rundle Avenue Nashville, Tennessee 37210 United States Telephone: 800-876-4332 or 615-742-3852. Fax: 615-742-3270. Web: http://www.audioclassics.net. Email: information@audioclassics.net. JRS Medical Supplies 7730B Trinity Road, Suite 125 Cordova, Tennessee 38018 United States Telephone: 877-359-6716. Fax: 901-755-6963. Web: http://www.jrsmedical.com. Email: sales@jrsmedical.com. Black Ice LLC 9160 Highway 64 Suite 12, No. 301 Lakeland, Tennessee 38002 United...

Words: 562 - Pages: 3

Free Essay

Laws310

...Question 12 Page 170 On July 5, 1884, four sailors were cast away from their ship in a storm 1,600 miles from the Cape of Good Hope. Their lifeboat contained neither water nor much food. On the 20th day of their ordeal, Dudley and Stevens, without the assistance or agreement of Brooks, cut the throat of the fourth sailor, a 17- or 18-year-old boy. They had not eaten since day 12. Water had been available only occasionally. At the time of the death, the men were probably about 1,000 miles from land. Prior to his death, the boy was lying helplessly in the bottom of the boat. The three surviving sailors ate the boy’s remains for four days, at which point they were rescued by a passing boat. They were in a seriously weakened condition. a. Were Dudley and Stevens guilty of murder? Explain. b. Should Brooks have been charged with a crime for eating the boy’s flesh? Explain. See The Queen v. Dudley and Stephens, 14 Queen’s Bench Division 273 (1884). a. “The facts found on the special verdict shew that the prisoners were not guilty of murder, at the time when they killed Parker but killed him under the pressure of necessity. Necessity will excuse an act which would otherwise be a crime.”(justiceharvard) After reading this I believe that they did what they had to do in order to survive. They said the boy was weak and wouldn’t have made it anyway. They will have to live with the decision they made but they got to live because of it. b. No, he used it as a means to survive...

Words: 665 - Pages: 3

Premium Essay

Compare and Contrast

...Baleigh Holder Mrs. Withrow English 1123 1 October 2015 Parental influence to celebrity influence Every parent should have the natural desire to raise his/her child as independent and moral individuals. However, it is common for others to be influenced by their surroundings, such as social media sources, television shows, peers, family members, etc. Moreover, these models of behavior definitely contribute to how we form our perspectives of the world. Arguably, parents and celebrities are two of the most influential factors during childhood. Whether they are modeling positive or negative lifestyle choices, parents and celebrities alike face the consequences of those choices, and, subsequently, their children learn from seeing these experiences. Parents are very important when it comes to influencing their children’s lifestyle choices. Being if they live with them, children are with their parents almost all of the time. They teach their children everything from walking, talking, potty training, and etc. Children and young teens watch their parent’s everyday choices. Most parents can be a positive influence for their children, and raise them to be independent and moral. For instance, a parent can be a hard worker, providing for their family everyday, and teaching them that having an education is very important. On the other hand, parents can also show negative influences to young teens. For example, if a parent smokes and drinks all the time, and their children see their...

Words: 782 - Pages: 4

Free Essay

Online Blood Management System

...Blood Bank Management System Pakeeza Shah tatheer.fatima07@yahoo.com Department of Information Technology, Semester 7th Abstract: This paper is focused on the working of Blood Bank System. A blood bank is storage of blood or blood components, gathered from donors, stored and preserved for later use in blood transfusion. It is a web application that serves as a communication tool between recipients and blood donor. To become members of the system, donors need to create their profiles by providing fundamental information like name, blood group, email address, password, and exact location. Visitors can search blood donors from the home page by blood group and the place where blood is needed. The system will show the available donors along with their names, phone number and email address through arranging them by nearest place. Keywords- Blood Bank Management, Password, Web Applications, C# and Php I. Introduction There is a lot of communication gap donors, recipients, hospitals and blood banks .Medical facility is not available equally all over the country. A recipient, in case of need, has to contact his/her family, friends and other contacts. In case of failure blood banks and hospitals are searched for blood and in many cases this wastes so much time that patient dies for blood. Sometimes, if a donor is found, there is no time to check his eligibility to donate blood and blood is taken which may cause serious problems in future. The main objective is to reduce response...

Words: 731 - Pages: 3

Free Essay

Art Tatum Holy Toledo

...historic landmark where Art spent the bulk of his childhood. Take some pictures and just sort of soak in the vibe. I could not have been more dissapointed. Mrs. Ernistine Allen, a neighbor of the Tatums', has said "this was a respectable, middle- class neighborhood at the time," and that "Considering the times, they lived well- they had a very neat, clean house, and the kids were always well-dressed and they were very neat, the yard was always impeccably groomed and everything."(2) The Tatums took pride in their home as they were raising a young genius. Certainly we as a city can take that same pride after receiving the gift that was Art? In front of the house that sits at 1123 City Park Avenue is an...

Words: 1010 - Pages: 5

Free Essay

Pha Rao

...OM CHAPTER 7 PROCESS SELECTION, DESIGN, AND ANALYSIS DAVID A. COLLIER AND JAMES R. EVANS OM, Ch. 7 Process Selection, Design, and Analysis ©2009 South-Western, a part of Cengage Learning 1 Chapter 7 Learning Outcomes learning outcomes LO1 Describe the four types of processes used to produce goods and services. LO2 Explain the logic and use of the product-process matrix. LO3 Explain the logic and use of the service-positioning matrix. LO4 Describe how to apply process and value stream mapping for process design. process maps. LO5 Explain how to improve process designs and analyze LO6 Describe how to compute resource utilization and apply Little’s Law. OM, Ch. 7 Process Selection, Design, and Analysis ©2009 South-Western, a part of Cengage Learning 22 Chapter 7 Process Selection, Design, and Analysis called to make an airline flight reservation just an hour ago. The telephone rang five times before a recorded voice answered. “Thank you for calling ABC Travel Services,” it said. “To ensure the highest level of customer service, this call may be recorded for future analysis.” Next, I was asked to select from one of the following three choices: “If the trip is related to company business, press 1. Personal business, press 2. Group travel, press 3.” I pressed 1. I was then asked to select from the following four choices: “If this is a trip within the United States, press 1. International, press 2. Scheduled training, press 3. Related...

Words: 3556 - Pages: 15