Loading...

Messages

Proposals

Stuck in your homework and missing deadline? Get urgent help in $10/Page with 24 hours deadline

Get Urgent Writing Help In Your Essays, Assignments, Homeworks, Dissertation, Thesis Or Coursework & Achieve A+ Grades.

Privacy Guaranteed - 100% Plagiarism Free Writing - Free Turnitin Report - Professional And Experienced Writers - 24/7 Online Support

Excel module 3 sam project 1

22/12/2020 Client: saad24vbs Deadline: 14 Days

New Perspectives Excel 2016 | Module 3: SAM Project 1a


C:\Users\akellerbee\Documents\SAM Development\Design\Pictures\g11731.png New Perspectives Excel 2016 | Module 3: SAM Project 1a


Snackin-Pak


PERFORMING CALCULATIONS WITH FORMULAS AND FUNCTIONs


GETTING STARTED

Open the file NP_EX16_3a_FirstLastName_1.xlsx, available for download from the SAM website.


Save the file as NP_EX16_3a_FirstLastName_2.xlsx by changing the “1” to a “2”.


0. If you do not see the .xlsx file extension in the Save As dialog box, do not type it. The program will add the file extension for you automatically.


With the file NP_EX16_3a_FirstLastName_2.xlsx still open, ensure that your first and last name is displayed in cell B6 of the Documentation sheet.


· If cell B6 does not display your name, delete the file and download a new copy from the SAM website.


PROJECT STEPS

Keith Herman works for Snackin-Pak, a recent start-up that sends boxed sets of packaged snacks to its subscribers on a weekly basis. He keeps track of the company’s sales and inventory, as well as relevant product information, in an Excel worksheet that is updated and distributed weekly.


Switch to the Orders worksheet. In cell A2, insert the NOW function to record the current date and time.


The data section called Transaction Growth shows how many boxed sets were sold each month. Keith entered a formula into the range O6:O10 to calculate the highest amount of each set sold over the course of the year. He notices that all of the values in the range are 1,408, even though more boxed sets than this were sold in some months.


Edit the formula in cell O6 so that it uses relative references instead of absolute references for the range B6:M6, and then copy the formula from cell O6 to fill the range O7:O10 without formatting.


In cell P6, create a formula using the MIN function to find the lowest number of the Fit Bits boxed set ordered (the range B6:M6). Copy the formula from cell P6 to fill the range P7:P10 without formatting.


The worksheet will also show the average number of orders fulfilled for each column in the section above.


In cell B12, create a nested formula using the AVERAGE and ROUND functions to first find the average number of boxed sets sold in January (the range B6:B9), and then round the answer to 0 digits.


Copy the formula from cell B12 to the range C12:N12.


The data section called Inventory Tracker shows how many of each boxed set component has been ordered by the company each month. Use AutoFill with the values in the range B15:D15 to extend the series of months to the range E15:M15.


In cell O16, create a formula using the MAX function to find the peak inventory number for the Bars/Clusters component (the range B16:M16). Copy the formula from cell O16 to fill the range O17:O23 without formatting.


Switch to the Product Lookup worksheet. This worksheet shows information on the boxed sets and the components that come in each set.


The last person to work on the workbook mistakenly pasted “one hundred” into cell B10, which created an error in cell B14. Change the value in cell B10 from “one hundred” to 100 to eliminate the error message in cell B14.


The data section called Boxed Set Information is incomplete.


In cell B16, create a formula using the SUM function to find the total calories in the Munchie Madness boxed set by totaling the calories from Baked Goods (cell B5), Bars/Clusters (cell B6), Granola (cell B9), and Popcorn (cell B11).


In cell C14, create a formula using the COUNTA function to count the number of components in the Fit Bits boxed set (the range B20:F20). Copy the formula from cell C14 to fill the range C15:C17 without formatting to count the number of components for the rest of the boxed sets.


The data section called Product Information Lookup uses a mix of user input cells, output cells, and calculated cells to display various information for a single boxed set. Format the section as follows:


a. Apply the Input cell style to cell I5.


b. Apply the Output cell style to the range I6:I8.


c. Apply the Calculation cell style to cell I9.


In cell I6, create a formula using the VLOOKUP function to display the number of calories in the selected boxed set. Use the boxed set listed in cell I5 as the lookup value, the range A14:D17 as the table array, column number 2 as the column index number, and FALSE as the range lookup value. Use absolute references for cell I5 and the range A14:D17.


In cell I9, create a formula without using a function that first adds the selected boxed set’s net weight (cell I8) to the packing weight (cell E5), and then divides the value by 16 to show the shipping weight in pounds.


The delivery service used by the company charges a higher rate for packages weighing over 3 lbs.


In cell I10, create a formula that uses the IF function to determine if a boxed set is overweight by checking if the shipping weight (cell I9) is greater than 3. If this condition is true, the cell should display Yes, and if it is false, the cell should display No. (Hint: Use “Yes” for the value if true, and “No” for the value if false.)


The company can make more profit by keeping shipping costs to a minimum. Keith has been put in charge of the packaging redesign project, and he needs to figure out what weight of packaging can keep even the heaviest boxed set from being overweight.


Perform a Goal Seek Analysis to find a packing weight that will bring the shipping weight of the Sweet Stuff boxed set down to 2.9 lbs. Use cell I9 as the cell to set, 2.9 as the target value, and cell E5 as the changing cell. Keep the values generated by the Goal Seek Analysis as the value for cells E5, I9, and I10.


Your workbook should look like the Final Figures on the following pages. (The value in cell E5 generated by the Goal Seek Analysis has been intentionally blurred out in Final Figure 1.) Save your changes, close the workbook, and then exit Excel. Follow the directions on the SAM website to submit your completed project.


Final Figure 1: Product Lookup Worksheet




Final Figure 2: Orders Worksheet




2


Applied Sciences

Architecture and Design

Biology

Business & Finance

Chemistry

Computer Science

Geography

Geology

Education

Engineering

English

Environmental science

Spanish

Government

History

Human Resource Management

Information Systems

Law

Literature

Mathematics

Nursing

Physics

Political Science

Psychology

Reading

Science

Social Science

Home

Blog

Archive

Contact

google+twitterfacebook

Copyright © 2019 HomeworkMarket.com

Homework is Completed By:

Writer Writer Name Amount Client Comments & Rating
Instant Homework Helper

ONLINE

Instant Homework Helper

$36

She helped me in last minute in a very reasonable price. She is a lifesaver, I got A+ grade in my homework, I will surely hire her again for my next assignments, Thumbs Up!

Order & Get This Solution Within 3 Hours in $25/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 3 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

Order & Get This Solution Within 6 Hours in $20/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 6 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

Order & Get This Solution Within 12 Hours in $15/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 12 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

6 writers have sent their proposals to do this homework:

University Coursework Help
Helping Hand
Top Essay Tutor
Peter O.
Writer Writer Name Offer Chat
University Coursework Help

ONLINE

University Coursework Help

Hi dear, I am ready to do your homework in a reasonable price.

$62 Chat With Writer
Helping Hand

ONLINE

Helping Hand

I am an Academic writer with 10 years of experience. As an Academic writer, my aim is to generate unique content without Plagiarism as per the client’s requirements.

$60 Chat With Writer
Top Essay Tutor

ONLINE

Top Essay Tutor

I have more than 12 years of experience in managing online classes, exams, and quizzes on different websites like; Connect, McGraw-Hill, and Blackboard. I always provide a guarantee to my clients for their grades.

$65 Chat With Writer
Peter O.

ONLINE

Peter O.

Hello, I can assist you in writing attractive and compelling content on ganja and its movement globally. I will provide with valuable, informative content that you will appreciate. The content will surely hit your target audience. I will provide you with the work that will be according to the needs of the targeted audience and Google’s requirement.

$55 Chat With Writer

Let our expert academic writers to help you in achieving a+ grades in your homework, assignment, quiz or exam.

Similar Homework Questions

Jones electrical distribution case solution excel - Unlike its competitors in the online air travel industry - Rent the runway case study answers - Discussion 1 - Tina y linda duermen en un hotel de lima - 5 c's of leadership indra nooyi - Costco pet insurance uk - How many ml is a teaspoon of medicine - Ioof lifetrack personal superannuation - Conch republic electronics mini case - Problem Identification - Into what four categories does king divide writers - International Marketing: The Environment Coursework - Strategic IT Exam - Belt test sample paper - Pain neutralization technique dvds for sale - Ferrocare oil filtration machine - Crushed diamond bread bin - Early onset Schizophrenia - Maersk compensation philosophy - Formatting toolbar in powerpoint - Chuck e cheese age group - Mise en scene film studies - Exsum army - Wabco code sid 14 fmi 4 - WEEK 8 DISCUSSION - Urgent - ME - Main - Essay - York st john university moodle - List of hcpcs level ii modifiers - Proof of sinx x 1 - 5 components of fitness - Discussion: Quantitative Research Designs - Sensonics smell test answer key - Melzer v board of education - Characteristics of shakespeare comedy - Uts meaning in engineering - Practical connection - Information Technology - Acc 561 week 1 - Forum #2 - Capsim beginner level certification - How are new molecules of dna synthesized in living cells - Siklu default ip address - Peak by roland smith - Week 4 Discussion - Network management tools associated with policy compliance - Noel carroll the philosophy of horror pdf - Practical aviation & aerospace law workbook answers - How do you calculate plant utilization in capsim - A loving partner is a safe sheltera loving partner is a safe shelter - Big pun rhyme scheme - Leadership in Healthcare Organization DW5 - Identifying mystery gases lab answers - Zipcar case study pdf - What is data management math - Adg apartment design guide - Order # 10265 - Bloggers site feedback- discussion post- 250 words due 10/17 at 8pm EST - Is value chain analysis internal or external - Daniels print shop purchased new printer - Formulating leadership part ii powerpoint - Southern cross early entry - Tuesdays with morrie text - Speech 1311 Chapter 5: Discussion Board and Reply to a Classmate - Literature and writing process 11th edition pdf - Balanced scorecard customer perspective - Ethical Stories - Tammy and wyatt are sales associates - Round 216 to the nearest ten - Assignment: Regulation for Nursing Practice Staff Development Meeting,NURS 6050 Policy and Advocacy for Improving Population Health - Haribo nederland b v - 26 electrons 26 protons - 2 page essay on Organized Crime - Calcium chloride and potassium carbonate equation - Ambarvale high school uniform - Analyzing moral issues 6th edition pdf - Anti drug legislation matrix - Management action plan map - Video Essay - The most recent financial statements for cornwall, inc., are shown here: - The dynaco manufacturing company produces - Model hovercraft plans free - Cool automatic watches that are sure fire conversation starters - Partners healthcare case study analysis - Sample cover letter for healthcare position - Apply 5 - Toyota fleet novated lease - Give me liberty american history eric foner - Lesson 9 1 measures of center and spread worksheet answers - Edward taylor upon a spider catching a fly - Confederation bridge cost to build - 2 PAGES ESSAY - Meagher gummow and lehane 5th edition - Castle of Otranto - Example of quantitative research critique for nursing - Is hank hill autistic - Arbonne essentials tea ingredients - Kidney shortage inspires a radical idea organ sales - Easter show ride coupons