Question

The Hard Rock Mining Company is developing cost formulas for management planning and decision-making purposes. The company's cost analyst has concluded that utilities cost is a mixed cost, and he is attempting to find a base that correlates with the cost. The controller has suggested that tons mined might be a good base to use in developing a cost formula. The production superintendent disagrees; she thinks that direct labor-hours would be a better base. The cost analyst has decided to try both bases and has assembled the following information: Direct Labor- Utilities Hours Cost Tons Mined Quarter Year 1: First Second Third Fourth Year 2: First Second Third Fourth 16,000 12,000 21,000 13,000 5,100 3,100 4,100 6,100 $ 51,000 $ 46,000 $ 61,000 $ 76,000 19,000 26,000 31,000 29,000 10,500 9,500 8,500 11,500 $ 105,000 $110,000 $ 86,000 $122,000 Required: 1-a. Using tons mined as the independent variable, prepare a scattergraph that plots tons mined on the horizontal axis and utilities cos on the vertical axis. Instructions: 1. On the graph below, use the point tool (Year 1-1st quarter) to plot tons mined on the horizontal axis and utilities cost on the Vertical axis. 2. Repeat the same process for the plotter tools (Year 1-2nd quarter to Year 2-4th quarter). 3. To enter exact coordinates, click on the point and enter the values of x and y. 4. To remove a point from the graph, click on the point and select delete option. Utilities Cost 140000 Tools 120000 Year 1 - 1st ql Year 1 - 2nd q 100000 80000 Year 1 - 3rd al Year 1 - 4th au

Answer 1

XI H. 2020-09(3) SEP.xlsx - Microsoft Excel ? X FILE HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW DEVELOPER Sign in > Calibri - 11 AA Wrap Text General AY A * Cut ED Copy Format Painter H Insert Delete Format Paste .00 BI U - E 6 3 Merge & Center - $ % Σ AutoSum και Z Fill- Sort & Find & Clear Filter - Select- Editing Conditional Format as Cell Formatting Table Styles Styles 00 Clipboard Font Г Alignment Number [5 Cells C18 : X fx D E F G Н. 1 K L M N O P. y = 2.70x + 25684 $140,000 • $122,000 $120,000 • $110,000 • $105,000 $100,000 $86,000 $80,000 • $ 76,000 А B с 1 Quarter Tone mined Utilities costs 2 1 16,000 $ 51,000 3 2 12,000 $ 46,000 4. 3 21,000 $ 61,000 5 4 13,000 $ 76,000 6 5 19,000 $ 105,000 7 6 26,000 $ 110,000 8 7 31,000 $ 86,000 9 8 29,000 $ 122,000 10 11 Fixed cost per quarter 25,684 12 Variable cost per tone 2.70 13 14 Y= 25,684 15 16 17 18 19 Utilities costs $60,000 $61,000 $51,000 • $46,000 $40,000 $20,000 + 2.70 X $- 5,000 10,000 15,000 20,000 25,000 30,000 35,000 Tone mined Activate Windows Go to Settings to activate Windows, Sheet7 Sheets Sheet Sheet 10 Sheet11 Sheet12 Sheet13 Sheet14 Sheet15 READY + 120% i Search the web and Windows O ENG IN 06:54 24-09-20