50.1K

Verified Solution

Link Copied!

can anyone please help me with it? why it is not giving me full credit? I do not know if I did it correctly or not. anyway, thanks in advance.

File Home inert Draw Page Layout Formules Data Review View Help 12 ' ' 28 Wrap Text Liberation Sans 1 Accounting 5. % int Delle Format a A- + Merge Center - Conditioral Cel Formatting Table Styles Styles Clipboard F Cri Alignment Number 1 K19 SLOPE011:016,C21:16) Function: SLOPE. INTERCEPT:Cell Referencing Using Excel to Determine a Cost Equation Using the 4 High-Low Method 5 PROBLEM Markowi Corp has collected the following data concerning its maintenance costs for the past 6 months 0 9 Units 10 Produced Total Cost July 18,000 $36.000 August 32,000 45,000 September 36.000 55,000 October 22.000 38,000 November 40.000 74,500 December 38.000 62.000 Student Work Area Required: Provide input into cells shaded in yollow in this template Use coll references to the Problem area in the input cells in part a In part b, use the SLOPE and the INTERCEPT function with coll referencing to the work area a Select the data to use under high low method High Low Units Total Cost 38,000S 62,000 18,000 36.000 b. Compute the variable and fixed-cost elements using Excel's SLOPE and INTERCEPT functions Variable cost Answer FM Function: SLOPE Coli reference Total fixed costs $ 4,830 Use the SLOPE function with references to this work area to calculate the variable cost per unit 251 rue of your secure Enter Answer 19 note by Author o Question 12 of 14 0.54/3 E Ort Artempt in Progress Your answer is partially correct Instructions You will be using Microsoft Bed to answer this question. Follow the steps below to complete the question Click here to view a brief Video demonstrating downloading the Excel file, completine your work in either Excel or Google Shots, and uploading your response le successfully with troubleshooting Alternatively see written instruction here Download graded Excel document for this attempt STEP 1 STEP 2 Download Save the Excel file to your computer and complete this problem Upload completed file Drag and drop your completed Excel document here or browse files on your computer then submit your answer Select Filia to Upload Download Excel file Chapter Homework Question 12.xix Mon Oct 4, 2021. 11.02.54 PM America/New York-04.00 No Fue Selected

Answer & Explanation Solved by verified expert

See Answer