Premium Essay


In: Business and Management

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


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

Free Essay


...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......

Words: 326 - Pages: 2

Premium Essay

Programming Language Using Oojavacom 121

...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 Development Object oriented Analysis and Design STRUCTURED SYSTEMS DESIGN (LOGICAL) Logical Database Design Entity-Relationship Modelling; Transforming the Entity Models to a Relational Schema; Normalisation; Denormalisation; Views Logical Process Design Context Diagrams; Data Flow Diagrams; State Transition Diagrams; Entity Life Histories; Decision Tables; Structured English OBJECT ORIENTED DESIGN (LOGICAL) Main Concepts Objects; Classes; Messages; Methods; Inheritance; Encapsulation; Static Modelling Formatted: Indent: Left: 0.5", First line: 0.5" Formatted: Indent: Left: 0.5", First line: 0.5" Formatted: Indent: Left: 0.5", First line: 0.5" Formatted: Indent: Left: 0.5", First line: 0.5" 2 30/09/1123/09/10 Class Hierarchies (generalisation -specialisation......

Words: 2312 - Pages: 10

Free Essay


...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 amount on the-iverkslteet at the end of this letter. - The......

Words: 609 - 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”

...Delivered by facilitators from training institutions Strategy #2 • Three-day off site user training • Delivered by master facilitators Strategy #3 • Four-day on-site end-user + mentor training • Delivered by MOH county-level facilitators • 1-2 Champion Mentors per site cascade training to other HCW Results January-March 2013: Strategy 1 Cost per participant $2,345 121 managers attended Health Manager Orientations 67 HCW attended KenyaEMR User Training April – September 2013: Strategy 2 Cost per participant $577 165 managers attended Health Manager Orientations 131 HCW attended KenyaEMR User Training October 2013 – September 2014: Strategy 3 Cost per participant $325 216 managers attended Health Manager Orientations 1123 HCW attended KenyaEMR User Training 120 Champion mentors involved in mentorship Challenges • Transfer of trained staff across health facilities resulting into a capacity gap hence the advent of mentorship • Disruption of onsite trainings as health workers are occasional pulled out to attend to patients • Inadequate training space at facilities; nevertheless, I-TECH is keen to continue training on-site to have users experience the same familiar environment Unmet goals • Tracking HCW mentored at health facilities by champion mentors and keeping tabs of the retention rates Conclusions The evolution of I-TECH’s training strategy has resulted in a lower-cost training model, with greater availability of on-site support......

Words: 458 - Pages: 2

Premium Essay


...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......

Words: 649 - Pages: 3

Premium Essay


...nouns and pronouns (coordinate adjectives) Hint: if you can put ‘and’ between the adjectives, you need to put a comma between the adjectives-if in doubt do not put in a comma. Examples: My dog is a soft, cuddly puppy. Exercises: insert comma when needed or “and” to correct the sentence: 1. The yellow green car is ugly. 2. The Beatles lived in a metal yellow submarine. 3. Tome ate all the sweet sour candy. 4. Red yellow tulips grace our yard. G. Put commas in dates, addresses, and titles: **When only month and year are listed do not use the comma: Examples: November 19, 2002, is the date for the conference. Exercises: insert comma when needed: 1. Tyrone lives at 1123 S. Timberlane Drive Phoenix Arizona. 2. September 11 2001 will live in infamy as will December 7 1941. 3. Dr. Lloyd a cancer specialist will present her research at the conference. 4. October 27 1964 is my birthday. H. Put commas around direct contrasts and short questions and after interjections and adverbs such as yes and no. Examples: You were there, weren’t you? Exercises: insert comma when needed: No I hate chocolate Well I guess so. Yes John Jacob Jinglehimer Schmitt is my name, too. Huh I don’t understand the question. I. Put commas around names or words used in direct address (when someone is speaking directly to someone else): Examples: I think......

Words: 740 - 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......

Words: 782 - Pages: 4

Free Essay

Online Blood Management System

...Ali and et al,. American Journal of Engineering Research (AJER) e-ISSN: 2320-0847 p-ISSN : 2320-0936 Volume-4, Issue-6, pp-123-136 * A New Concept of Blood Bank Management System using Cloud Computing for Rural Area (INDIA) Javed Akhtar Khan and M.R. Alony International Journal of Electrical, Electronics ISSN No. (Online): 2277-2626 and Computer Engineering 4(1): 20-26(2015) * Blood Bank Management Information System in India By Vikas Kulshreshtha, Dr. Sharad Maheshwari , International Journal of Engineering Research and Applications(IJERA) ISSN: 2248-9622 Vol. 1, Issue 2, pp.260-263 * A Study on Blood Bank Management By A. Clemen Teena, K. Sankar and S. Kannan, Middle-East Journal of Scientific Research 19 (8): 1123-1126, 2014 ISSN 1990-9233 © IDOSI Publications, 2014 DOI: 10.5829/idosi.mejsr.2014.19.8.1120...

Words: 731 - Pages: 3

Premium Essay


...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

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. ......

Words: 434 - Pages: 2

Premium Essay

Eng 227 Routine Message

...the move. 2. Explain the reason for the rerouting and how this will affect them. 3. Prepare vouchers for directions where to pass and short cuts, if any. 4. Social Media (i.e. Facebook, Twitter and Instagram) pertaining to the change. 5. Use media maneuvers such as broadcasts on television and the radio, including newspaper advertisements. Following are additional pertinent information: Contact Details Name | Position | Phone Number/Cell Phone | Email | John Joffe | Team Leader | 706-555-1234 | | Tarsha Gray | Documentation Coordinator | 706-555-5678 | tgray@ | Tiffany Johnson | Driver | 706-555-9101 | tjohnson@ | Alex Haddad | Driver | 706-555-1123 | ahaddad@ | Meeting Times * Conference calls Tuesday and Thursday, 12:00 p.m. EST * Group Chat: Monday Wednesday and Friday 7:00 p.m. EST * Group Emails going out daily Analytical Report Tasks Task | Owner | Due Date | Problem discussion | | | Identification of alternatives and solutions | | | Resolution | | | Conclusion | | | Doing business in Indonesia requires a lot of patience considering the cultural make up of its people. They are personable and base their decisions on relationships established between the Indonesian company and the foreign company, but they take business deals seriously. In the case of E227 GS, following the above recommendations can very well......

Words: 799 - Pages: 4

Premium Essay


...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......

Words: 4433 - Pages: 18

Free Essay

Civil Liberties and Terrorism

...having their civil liberties dismantled. It doesn't just affect terrorists and foreigners, it affects us all” Bianca Jagger. The USA Patriot Act is completely unconstitutional and we need to rid ourselves of it completely because with this act still in place, it will lead to us as Americans losing all of our rights. As per the words of Abraham Lincoln “Don't interfere with anything in the Constitution. That must be maintained, for it is the only safeguard of our liberties.” Reference Page O'Conner, K., Sabato, L. J., & Yanus, A. B. (2011). American Government Roots and Reform (2011 ed.). Pearson Education, Inc. Kashan, S. (2010). The usa patriot act: Impact on freedoms and. Retrieved from Brainy quote. (2012). Retrieved from ...

Words: 969 - Pages: 4

Premium Essay


... Email: JRS Medical Supplies 7730B Trinity Road, Suite 125 Cordova, Tennessee 38018 United States Telephone: 877-359-6716. Fax: 901-755-6963. Web: Email: Black Ice LLC 9160 Highway 64 Suite 12, No. 301 Lakeland, Tennessee 38002 United States Telephone: 901-937-8129. Fax: 901-380-9327. Web: Allied Medical (Pyramid Rehab) 690 S. Mendenhall Memphis, Tennessee 38117 United States Telephone: 800-422-2126 or 901-683-3543. Fax: 901-683-0109. Web: No known web address. Adamo Industries Inc 1182 Pallwood Road Memphis, Tennessee 38122 United States Telephone: 800-682-7702 or 901-682-1123. Web: No known web address. Email: Access Industries, Inc. 2509 Summer Avenue Memphis, Tennessee 38112 United States Telephone: 800-264-4304 or 901-323-5438. Web: Email: InvoTek, Inc. 1026 Riverview Drive Alma, Arkansas 72921 United States Telephone: 479-632-4166. Fax: 479-632-6457. Web: Email: T.K. Martin Center for Technology and Disability The T.K. Martin Center of Mississippi State University provides comprehensive, multi-disciplinary evaluations and offers assistive technology recommendations, training, and product customization/adaptation to remove or minimize limitations caused by certain......

Words: 562 - Pages: 3

Free Essay


...Lancaster tried to buy 99 Cents’ lease, but the company refused. Lancaster then used its power of eminent domain to condemn the 99 Cents property for the purpose of making it available to Costco. The city noted that blight might follow if Costco left, and the city contrasted 99 Cents’ under $40,000 per year in sales taxes generated with Costco’s more than $400,000. 99 Cents then sued the city seeking an order blocking the effort to take the 99 Cents property. a. How would you have ruled on the case when it was tried in 2001? Explain. b. Would the result be any different today after the Supreme Court’s 2005 decision in the New London, Connecticut, case? Explain. See 99 Cents Only Stores v. Lancaster Redevelopment Agency, 237 F. Supp. 2d 1123 (C.D. Cal. 2001). Appeal dismissed, 2003 U.S. App. LEXIS 4197. a. In 2001 is would of ruled in favor of the 99 cents store because it was privately owned. Only the government was benefiting from Costco due to the taxes. So I do not see how it could have been for public use. b. I think the result would be the same because the Supreme Court held that the taking by the city and sale to a private development company did qualify as a valid exercise of eminent domain under the Fifth Amendment, as the "public purpose" could also be interpreted as a "public use" under the Fifth Amendment. Kelo v. City of New London, 549 U.S. 469 (2005). Thus, after the New London case, it would be a permissible use of eminent......

Words: 665 - Pages: 3