Please do not give solution in image format thanku )Your boss would like you to estimate the fixed and variable components of a particular cost. Actual data for this cost over four recent periods appear below.Activity22Cost$121$132Period 1Period 2Period 3Period 4282129$117$134Using the least-squares regression method, what is the cost formula for this cost?Multiple ChoiceY-$75.50 $2.02XY $72.64 $2.13XY-$0.00 $5.04XY-$75.89 $1.02X

As per the given information: ActivityCostPeriod 122$121Period 228$132Period 321$117Period 429$134…

Your boss would like you to estimate the fixed and variable components of a particular cost. Actual data for this cost over four recent periods appear below. Activity 22 Cost $121 28 21 29 Period 1 Period 2 Period 3 Period 4 $132 $117 $134 Using the least-squares regression method, what is the cost formula for this cost? Multiple Choice Y-$75.50+$2.02X Y-$72.64 $2.13X Y-$0.00 $5.04X Y-$75.89 $102X

Your boss would like you to estimate the fixed and variable components of a particular cost. Actual data for this cost over four recent periods appear below. Activity 22 Cost $121 28 21 29 Period 1 Period 2 Period 3 Period 4 $132 $117 $134 Using the least-squares regression method, what is the cost formula for this cost? Multiple Choice Y-$75.50+$2.02X Y-$72.64 $2.13X Y-$0.00 $5.04X Y-$75.89 $102X

Principles of Cost Accounting

17th Edition

ISBN:9781305087408

Author:Edward J. Vanderbeck, Maria R. Mitchell

Publisher:Edward J. Vanderbeck, Maria R. Mitchell

Chapter4: Accounting For Factory Overhead

Section: Chapter Questions

Problem 4E: Using the data in E4-2 and spreadsheet software, determine: The variable cost per unit, the total...

See similar textbooks

Related questions

Q: Can you explain the answer without excel please? Thanks.

A: Cost of Car is $52000 Interest rate is 6% Time period is 5 years Monthly Interest rate "rate" is…

Q: Which of the following files is a temporary file? a. transaction file b. master file c. reference…

Q: Kate has put a lot of time and effort into streamlining the process to design and produce a greet-…

A: Since you have asked multiple question, we will solve the first question for you. If you want any…

Q: i need details explanatio

A: Under FIFO method, unit purchase first, sold first. Cost of goods sold means we need calculate cost…

Q: Please provide me the solution with explanation of d,e,f and G

A: “Since you have posted a question with multiple sub-parts, we will solve first three sub-parts for…

Q: Can you please enter the information clearly without so many spaces? The information is hard to…

A: The ratio of inventory turnover measures how effectively the business uses its inventory through…

Q: Please answer G part with explanation

A: Workings: Market Capitalization=No. of shares outstanding×Price per share=542-14×$35.90=$18,955.20…

Q: Choose the term that best describes static data? O Static data does not change once it is created. O…

A: Solution:Correct answer : (a) Static data does not change once it is created.

Q: Can you verify step 2 from the answer with error?Thanks

A: Solution b: Contribution margin per unit = Selling price per unit - Variable cost per unit = $15 -…

Q: Please don't use chat gpt and other ai other wise I give multiplie downvote Which of the following…

A: The currently attainable standard represents the level of performance that can be achieved under…

Q: Monty Company expects to produce 1,176,000 units of Product XX in 2025. Monthly production is…

A: Variable Cost - Variable cost is the cost which is per unit fixed and vary with the level of…

Question

Please do not give solution in image format thanku

)
Your boss would like you to estimate the fixed and variable components of a particular cost. Actual data for this cost over four recent periods appear below.
Activity
22
Cost
$121
$132
Period 1
Period 2
Period 3
Period 4
28
21
29
$117
$134
Using the least-squares regression method, what is the cost formula for this cost?
Multiple Choice
Y-$75.50 $2.02X
Y $72.64 $2.13X
Y-$0.00 $5.04X
Y-$75.89 $1.02X

Expert Solution

This question has been solved!

Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.

This is a popular solution!

SEE SOLUTION Check out a sample Q&A here

Step 1: Given

VIEW

Step 2: Solution

VIEW

Solution

VIEW

Trending now

This is a popular solution!

Step by step

Solved in 3 steps

SEE SOLUTION Check out a sample Q&A here

Similar questions

Your boss would like you to estimate the fixed and variable components of a particular cost Actual data for this cost over four recent periods appear below. Activity Cost Period 1 22 235 Period 2 23 243 Period 3 25 255 Period 4 20 227 Using the least-squares regression method, what is the cost formula for this cost? Y = P107.45 + P5.89X O Y = P0.00 + P10.67X O Y = P111.92 + P5.69X O Y = P120.81 + P3.56X
Answer quickly
Choose the correct letter of answer On a scattergrap, the diagonal line cuts across two sets of observations, namely: 600:200, and 900:500 which refer to costs and units, respectively. The fixed costs is plotted in the graph at P400. In this case, the variable cost per unit is equal to: a. P1.00b. P1.25c. P1.50d. P1.12
Exercises + Suppose that we made an AHP analysis based on the following comparison tables Value R1 R2 R3 R1 1 9. R2 1 R3 1 Cost R1 R2 R3 R1 1 1/7 1/5 R2 1 1/9 R3 1 1) Draw the value cost diagram from these tables 2) From the diagram, rank the requirements according to their priorities starting from the highest priority Dr. Quta Shambour PArt Requirciments Analy
The McGraw Company is accumulating data to be used in preparing its annual profit plan for the coming year. The cost behavior pattern of the maintenance costs must be determined. The accounting staff has suggested that linear regression be employed to derive an equation in the form of y = a + bx for maintenance costs. Data regarding the maintenance hours and costs for last year and the results of the regression analysis are as follows: (CMA adapted) Hours of January February March April May June July August September October November December Sum Average A coefficient B coefficient Standard error of the a coefficient Standard error of the b coefficient Standard error of the estimate R² T-value a T-value b Activity 480 320 400 300 500 310 320 520 490 470 350 340 4,800 400 49.515 0.12126 Maintenance Costs 4,200 3,000 3,600 2,820 4,350 2,960 3,030 4,470 4,260 4,050 3,300 3,160 $ $ 43,200 3,600 684.65 7.2884 34.469 0.99724 13.827 60.105 What is the variable cost per hour using the high-low…
Using the data in E4-2 and spreadsheet software, determine: The variable cost per unit, the total fixed cost, and R2. The plotted data points using the graphing function. Compare the results to your solutions in E4-2 and E4-3 and explain the reasons for the results.
Your manager would like you to conduct sensitivity analysis to see how changing both the price and unit cost of a product affect profits. The following data is provided to you. Which of the following actions needs to be completed before building a data table? 26 27 Price 28 Demand 29 Unit cost 30 Fixed cost 31 Revenue 32 Variable cost 33 Profit B с 50.00 28,000.0 12.00 D E Copied Cells 50.0 62,000.0 1,400,000.0=C28 C27 336,000.0=C28 C29 1,798,000.0 SUM(C31,C32.C30) Select one: The incorrect cells have been 'copied' and this will result in a 12.0
(a) Build a spreadsheet model to calculate the profit/loss for a given demand. What is the demand? (b) Use Goal Seek to calculate the price that results in breakeven. If required, round your answer to two decimal places. c) Use a data table that varies price from 350 to 3400 in increments of 325 to find the price that maximizes profit.
Tom uses his computer to calculate the following regression formula:Weekly total costs = $18,791 + ($19.97 * Number of orders per week) Draw the regression line on your graph. Use your graph to evaluate the regression line using the criteria of economic plausibility, goodness of fit, and significance of the independent variable. Is the cost function estimated using the high-low method a close approximation of the cost function estimated using the regression method? Explain briefly.
Given the mixed cost function y = $6.50x + $3,000. What does the $6.50 represent? a.Total cost per unit of the cost driver b.The fixed cost per unit c.The slope of the cost function d.Total fixed costs
Assume that the situation can be expressed as a linear cost function. Find the cost function in this case. Marginal cost: $60; 120 items cost $8000 to produce. The linear cost function is C(x)= FEE
How do you solve for contribution margin? For general accounting question