Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

image text in transcribedimage text in transcribedComplete 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 appropriately

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Auditing Principles Practice And Problems

Authors: Jagdish Prakash

1st Edition

9327244745, 978-9327244748

More Books

Students also viewed these Accounting questions