I have an Accounting excel assignment due wednesday night. I need someone to solve it for me. if you need me to send you the excel sheet let me know how to send it. I cant find the answer for this assignment on chegg.

thats all I have the questions are attached

21.test3 W20-3 Layout References Mailings Review View A A A A E 15 ** AA EE a ACC 381 - Accounting Information Systems Lab Excel Assignment 3 You are analyzing production costs at a furniture-making plant, where wood and hardware is cut, painted and finished by carpenters into individual pieces. Each piece is then packaged in one or more boxes and information and advertising stickers added to make a finished box ready for sale. Remember to carefully plan the layout of the requested schedules to provide a professional, clear and easily understood presentation. (Total 291 pts) 1. Complete watching the assigned videos: Excel is Fun Basics Video 26, and https://www.youtube.com/watch?v=VTKLHVchL7M re Formulas, Slope, and Intercept() fns 2. Using the data provided on the following page complete the following in Excel: a. For worksheet 1: i. Use the data worksheet provided on Canvas but save using filename per #3 below. Format to show cents, and Direct Labor Hours to 2 decimal places. ii. Use the SUMO and IFO) functions to check your data entry. (Use IF fn to ensure surn of columns is equal to sum of rows, with "Add Error" as message if they don't). (37 pts) Ill. Format the columns using appropriate formats. (35 pts) 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 - costs associated with operation of the plant and its equipment that are not directly associated with finished goods shipped out of the plant Each schedule should be in alphabetical onder and have a total, and there should be a grand total to ensure total expensestie in de worksheet 1, and not equal" message if they don't. (54 pts) il 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 (ie, has both Fixed and Variable components) Document this in the column to the right of the annual amount (18 pts) m. In the two columns to the night of your initial judgement (from ii), use the Slope (to 2 decimal nees which is in the center Du t Internet the functions to determine the five MacBook Air 31-Excels3 W20-3.12 Design Layout References Malings Review - 12 AA AA EE View 9. T ube Alte AaBCD DE AaBb C b. For worksheet 2 you will be performing an analysis of the data 1. 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 -costs associated with operation of the plant and its equipment that are not directly associated with finished goods shipped out of the plant Each schedule should be in alphabetical onder and have a total, and there should be a grand total to ensure total expenses tie in de worksheet 1, and not equal message if they don't. (54 pts) ii. Review the quarterly cost behavior in worksheet land use your judgement to estimate whether each expense is 1. Fixed I 2Variable (based on direct labor hours), or 3. Mixed (ie, has both Fixed and Variable components) Document this in the column to the right of the annual amount (18 pts) it. In the two columns to the right of your initial judgement (from in, use the Slope (to 2 decimal places which is to the cent per DLH and Intercept (to the cent) functions to determine the fixed and variable components of each cost type and category (14 pts) iv. In one (or three columns to the right of these for use IF and AND functions based on(i) to determine if type of cost is fixed variable, or mixed. Do the results of (m) change your classification of any of the expenses from (NOTE: ignore fixed costs of less than 500 per qua n d variable costs less than (54 pts) If so, Note the revised category in the column to the right of the columns) for (iv) (10 pts) V. Using results of your analysis in create a cost function car for each expense in a new column. It must display the formula (not a number) in the following format: (18 pts) Cost - Fixed Cost + Variable Cost per DLH e Delivery Expense S200.00+ 45 DLH vi. Format your columns and outputs appropriately. (21 pts) 3. Upload your worksheet using the following aming convention: UNIQUENAME Excel3.XLSX on Canvas. MacBook Air on . AutoSaver GE D Home Insert Draw Page Layout Formulas X Times New Roman 12 A A Ib BTU DA Data 3 Review = Wrap Text Merge & Center H23 F G Advertising Stickers Apprentice Carpenter Labor Carpenter Labor Cleaning supplies Depreciation Painting finishing Supplies al Supplies Hardware Indirect Sales G Quarterly Costs 01 02 03 04 Annual Total $ 4352 50 S509750 S 6,075 75 57.146.25 $ 22.625 22.463 50 27.357 50 31,543.75 40,931.25 124 325 35 132 50 49 817 50 52 54.75 64225.75 194.925 5.102 60117004311313 91 275 275 91275 275.00 365,100 88052 50 107 397 131,577 154.596.25 481.625 9.115.00 9 115.00 9,11500 115.00 37,460 21.552 50 25197 50 375 7965 116.925 TIX 500.00 11x 500.00 500.00 TIR 00.00 474.000 2,426 25 109.75 12.619 18 15.4 .13 46.13 3,115.00 3.115.00 11500 115.00 12,400 21.523.75 25,4635 41301938 2 3 70125 4.523.75 5.551 7 7663 419.5 4969.75 1 18 5.65.13 20.273 1175 0,75 00 61.1941 1942 11.27.00 15.112.00 12.451.00 21.610.00 19.27500 19.275.00 19.275.00 19.275.00 5422 50667.50 14.03.75 995,0.25 BOX 125 51040SO SE 32035144117 20170455,402,716 Master Cat her Finished Gods Package Equipe Parts and Rap Shipping Costs Utilities Warehouse Rent Total Expenses ( HD | TH Du harus Lav 7.996 6.544 207 MacBook Ai 21.test3 W20-3 Layout References Mailings Review View A A A A E 15 ** AA EE a ACC 381 - Accounting Information Systems Lab Excel Assignment 3 You are analyzing production costs at a furniture-making plant, where wood and hardware is cut, painted and finished by carpenters into individual pieces. Each piece is then packaged in one or more boxes and information and advertising stickers added to make a finished box ready for sale. Remember to carefully plan the layout of the requested schedules to provide a professional, clear and easily understood presentation. (Total 291 pts) 1. Complete watching the assigned videos: Excel is Fun Basics Video 26, and https://www.youtube.com/watch?v=VTKLHVchL7M re Formulas, Slope, and Intercept() fns 2. Using the data provided on the following page complete the following in Excel: a. For worksheet 1: i. Use the data worksheet provided on Canvas but save using filename per #3 below. Format to show cents, and Direct Labor Hours to 2 decimal places. ii. Use the SUMO and IFO) functions to check your data entry. (Use IF fn to ensure surn of columns is equal to sum of rows, with "Add Error" as message if they don't). (37 pts) Ill. Format the columns using appropriate formats. (35 pts) 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 - costs associated with operation of the plant and its equipment that are not directly associated with finished goods shipped out of the plant Each schedule should be in alphabetical onder and have a total, and there should be a grand total to ensure total expensestie in de worksheet 1, and not equal" message if they don't. (54 pts) il 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 (ie, has both Fixed and Variable components) Document this in the column to the right of the annual amount (18 pts) m. In the two columns to the night of your initial judgement (from ii), use the Slope (to 2 decimal nees which is in the center Du t Internet the functions to determine the five MacBook Air 31-Excels3 W20-3.12 Design Layout References Malings Review - 12 AA AA EE View 9. T ube Alte AaBCD DE AaBb C b. For worksheet 2 you will be performing an analysis of the data 1. 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 -costs associated with operation of the plant and its equipment that are not directly associated with finished goods shipped out of the plant Each schedule should be in alphabetical onder and have a total, and there should be a grand total to ensure total expenses tie in de worksheet 1, and not equal message if they don't. (54 pts) ii. Review the quarterly cost behavior in worksheet land use your judgement to estimate whether each expense is 1. Fixed I 2Variable (based on direct labor hours), or 3. Mixed (ie, has both Fixed and Variable components) Document this in the column to the right of the annual amount (18 pts) it. In the two columns to the right of your initial judgement (from in, use the Slope (to 2 decimal places which is to the cent per DLH and Intercept (to the cent) functions to determine the fixed and variable components of each cost type and category (14 pts) iv. In one (or three columns to the right of these for use IF and AND functions based on(i) to determine if type of cost is fixed variable, or mixed. Do the results of (m) change your classification of any of the expenses from (NOTE: ignore fixed costs of less than 500 per qua n d variable costs less than (54 pts) If so, Note the revised category in the column to the right of the columns) for (iv) (10 pts) V. Using results of your analysis in create a cost function car for each expense in a new column. It must display the formula (not a number) in the following format: (18 pts) Cost - Fixed Cost + Variable Cost per DLH e Delivery Expense S200.00+ 45 DLH vi. Format your columns and outputs appropriately. (21 pts) 3. Upload your worksheet using the following aming convention: UNIQUENAME Excel3.XLSX on Canvas. MacBook Air on . AutoSaver GE D Home Insert Draw Page Layout Formulas X Times New Roman 12 A A Ib BTU DA Data 3 Review = Wrap Text Merge & Center H23 F G Advertising Stickers Apprentice Carpenter Labor Carpenter Labor Cleaning supplies Depreciation Painting finishing Supplies al Supplies Hardware Indirect Sales G Quarterly Costs 01 02 03 04 Annual Total $ 4352 50 S509750 S 6,075 75 57.146.25 $ 22.625 22.463 50 27.357 50 31,543.75 40,931.25 124 325 35 132 50 49 817 50 52 54.75 64225.75 194.925 5.102 60117004311313 91 275 275 91275 275.00 365,100 88052 50 107 397 131,577 154.596.25 481.625 9.115.00 9 115.00 9,11500 115.00 37,460 21.552 50 25197 50 375 7965 116.925 TIX 500.00 11x 500.00 500.00 TIR 00.00 474.000 2,426 25 109.75 12.619 18 15.4 .13 46.13 3,115.00 3.115.00 11500 115.00 12,400 21.523.75 25,4635 41301938 2 3 70125 4.523.75 5.551 7 7663 419.5 4969.75 1 18 5.65.13 20.273 1175 0,75 00 61.1941 1942 11.27.00 15.112.00 12.451.00 21.610.00 19.27500 19.275.00 19.275.00 19.275.00 5422 50667.50 14.03.75 995,0.25 BOX 125 51040SO SE 32035144117 20170455,402,716 Master Cat her Finished Gods Package Equipe Parts and Rap Shipping Costs Utilities Warehouse Rent Total Expenses ( HD | TH Du harus Lav 7.996 6.544 207 MacBook Ai