Question
Do it on excel and reply with the screenshots. How is the IF function written Complete watching the assigned videos: Excel is Fun Basics Video
Do it on excel and reply with the screenshots. How is the IF function written
Complete watching the assigned videos: Excel is Fun Basics Video 26, and https:// www.youtube.com/watch?v VTKLHvchL7M re Formulas, Slope0, andI Using the data provided on the following page complete the following in Excel: 1. ntercept 2. a. For worksheet 1: Use the data worksheet provided on Canvas but save using filename per #3 below. ii. Use the SUMO and IFO functions to check your data entry. (Use IF fa to ensure sum of columns is equal to sum of rows, with "Not equal" as message if they don'). ii Format the columns using appropriate formats b. For worksheet 2 you will be performing an analysis of the data. i. Create a schedule for each of the following expense categories by putting each expense and its annual amount under one of the following headings: 1. Direct Materials 2. Direct Labor 3. Manufacturing Overhead Each schedule should be in alphabetical order and have a total, and there should be a grand total to ensure total expenses tie in to worksheet 1, and "not equal" message if they don't. ii. Review the quarterly cost behavior in worksheet 1 and use your judgement to estimate whether each expense is: 1. Fixed 2. Variable (based on direct labor hours), or 3. Mixed (i.e, has both Fixed and Variable components) Document this in the column to the right of the annual amount. ii.In the two columns to the right of your initial judgement (from i), use the SlopeO (to 3 decimal places) and Intercept0 (to the cent) functions to determine the fixed and variable components of each cost type and category iv. In one (or three) columns to the right of those for (ii), use IF and AND functions based on (ii) to determine if type of cost is fixed, variable, or mixed. Do the results of (ii) change your classification of any of the expenses from (ii) (NOTE: ignore fixed costs of less than $200 per quarter)? If so, Note the revised category in the column to the right of the column(s) for (iv). v. Using results of your analysis in (ii) create a cost function per year for each expense in a new column. Use the following format for your answers: Fixed Cost + Variable Cost per DLH $200.00 + .457 DLH Cost = e.g, Delivery Expense = vi. Format your columns and outputs appropriately
Complete watching the assigned videos: Excel is Fun Basics Video 26, and https:// www.youtube.com/watch?v VTKLHvchL7M re Formulas, Slope0, andI Using the data provided on the following page complete the following in Excel: 1. ntercept0 fns 2. a. For worksheet 1: Use the data worksheet provided on Canvas but save using filename per #3 below. ii. Use the SUMO and IFO functions to check your data entry. (Use IF fa to ensure sum of columns is equal to sum of rows, with "Not equal" as message if they don'). ii Format the columns using appropriate formats b. For worksheet 2 you will be performing an analysis of the data. i. Create a schedule for each of the following expense categories by putting each expense and its annual amount under one of the following headings: 1. Direct Materials 2. Direct Labor 3. Manufacturing Overhead Each schedule should be in alphabetical order and have a total, and there should be a grand total to ensure total expenses tie in to worksheet 1, and "not equal" message if they don't. ii. Review the quarterly cost behavior in worksheet 1 and use your judgement to estimate whether each expense is: 1. Fixed 2. Variable (based on direct labor hours), or 3. Mixed (i.e, has both Fixed and Variable components) Document this in the column to the right of the annual amount. ii.In the two columns to the right of your initial judgement (from i), use the SlopeO (to 3 decimal places) and Intercept0 (to the cent) functions to determine the fixed and variable components of each cost type and category iv. In one (or three) columns to the right of those for (ii), use IF and AND functions based on (ii) to determine if type of cost is fixed, variable, or mixed. Do the results of (ii) change your classification of any of the expenses from (ii) (NOTE: ignore fixed costs of less than $200 per quarter)? If so, Note the revised category in the column to the right of the column(s) for (iv). v. Using results of your analysis in (ii) create a cost function per year for each expense in a new column. Use the following format for your answers: Cost -Fixed Cost+Variable Cost per DLH e.g, Delivery Expense -$200.00+ 457 DLH vi. Format your columns and outputs appropriatelyStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started