O SWP-Ence Tell me what you want to do Formu Duta Page Layout de DE X T. Condkanal formada Tale Paste A. S. Sie 20 10000 0 Reporting Period Mb Jawy Fery March Al MY Total Cous 5920.000 600.000 300.000 1 100.000 L180.000 620.000 350.000 910.000 1060,000 960 000 1-400 000 950,000 H Anwer for Answer for Machine Total Costs Machine Hea Hours 15000 Correct Correct 15.000 Correct Care 20.000 Correct Corred 90.000 Cond Comed 95,000 Correct Correct 30.000 Corect Contact 38.000 Correct Canea 18,000 Correct Core 78000 Care Core 31000 Connect Correct 36.000 Core Corea 54,000 Core Cortet You are not required to draw the best thing line below. Informations en on the next worksheet to enable you to finish the exercise without complete this step Wahy Sairman October Nowada December Step 2 Vially lit a line to the data pents and make sure the line toeges or data poat. . To - en O * O DELL mert File Page Layout Formules Data Review View Tell me what you want to do Testemu States Conditional or Ft 319 D CH N 0 F R 5 U Round to the nearest cent and a other amounts to the rest 37. Scattergal Method Cod Step 3: Estimate the total facts Asume your estimate for total cost is $450,000 Sup 4. Calcate the table cost performs are credinci bers Trompetasve, me your time for total cost is $450,000, and that your line is step went through the data point with total costs of $1.000.000 and 7,000 machine hour tomber data pe Caleate the we couternit rounded to the nearest stand input your Vecot E Meals --x 5450.000 het boven for X for Y Y 5450.000 X 50000 hours loco the wors found for Y Y 5450000 15.000) 13 2 DELL 37 Scattergraph Method. Castilla Company produces smartphones Management wants to estimate the cost of production equipment used to produce smartphones. The company reported the following monthly cost data related to production equipment (this is the same data as the previous exercise) Reporting Period (Month) Total Costs Machine Hours January 5920,000 45,000 February 600,000 25,000 March 500,000 20,000 April 1,100,000 90.000 May 1.140,000 95,000 June 620,000 30 000 July 880,000 38,000 August 910,000 48.000 September 1,060,000 78,000 October 960,000 51,000 November 1.400 000 96,000 December 980,000 54,000 Required: a. Use the five steps of the scattergraph method to estimate the total fixed cost per month and the variable cost per machine hour State your results in the cost equation form Y = 1+vX by filling in the dollar amounts for fand v What would Castila Company's estimated costs be if it used 50,000 machine hours next month? What would Castilla Company's estimated costs be it it used 15,000 machine hours next month 38 Regression Analysis. Regression analysis was run for Castilla Company, resulting in the following output (this is based on the same data as the previous two exercises) Coefficients Wintercept 445 639 x vanable 8.54 Required: a Use the regression output given to develop the cost equation Ya.X by Iding in the dolar amounts for fand v What would Castilla Company's estimated costs be if it used 50.000 machine hours next month What would Castilla Company is estimated costs be ilitused 15 000 machine hours next DOLL X PC Fate Time HU S. Com A Formatting A for 0 0 ALE LE LKL G H Round to the nearest cent and all other mounts to the nearest dotar 37 3. Seatter Method ( ced) Step 3: Estimate the total fized costs Assume your estimate for total fed costs a $450,000 Step & Calculate the variable cost per altres nits are measured is machine hours. From partsbove, tume your estimate for total fed costs is $450,000, and that your leis step 2 went through the data point with total costs of 51,060,000 and 78,000 machine hours September data point). Calculate the con pornit rounded to the nearestent and input your answer Tricot Vaible cost peded to Step State the results is from Y-X Y - 5450.000 X Ung the foot machine board for for Y - $450,000 + Y aconte the patchbox for Y = S450.000 15000 to Second OSE ET EXT 0
