An engineer collected average cost and revenue data for Arenson’s FC1 handheld financial calculator. Fixed cost = $ 300,000 per year Cost per unit = $40 Revenue per unit = $70 Show the sensitivity of profit to variation in revenue from $55 to $75 per unit using a $5 increment. Perform this analysis at two sales quantities: (1) the breakeven quantity for the collected data, and (2) 20% greater than this breakeven quantity. (Note: Be sure to use the original estimates for FC and cost per unit.)

An engineer collected average cost and revenue data for Arenson’s FC1 handheld financial calculator. Fixed cost = $ 300,000 per year Cost per unit = $40 Revenue per unit = $70 Show the sensitivity of profit to variation in revenue from $55 to $75 per unit using a $5 increment. Perform this analysis at two sales quantities: (1) the breakeven quantity for the collected data, and (2) 20% greater than this breakeven quantity. (Note: Be sure to use the original estimates for FC and cost per unit.)

Essentials of Business Analytics (MindTap Course List)

2nd Edition

ISBN:9781305627734

Author:Jeffrey D. Camm, James J. Cochran, Michael J. Fry, Jeffrey W. Ohlmann, David R. Anderson

Publisher:Jeffrey D. Camm, James J. Cochran, Michael J. Fry, Jeffrey W. Ohlmann, David R. Anderson

Chapter7: Linear Regression

Section: Chapter Questions

Problem 3P: Jensen Tire Auto is deciding whether to purchase a maintenance contract for its new computer wheel...

See similar textbooks

Similar questions

An auditor uses regression analysis to evaluate relationship between utility cost and machine hours. The following information is available based from monthly cost and machine hours of the company:· Intercept: 3,000 · Regression is .90· Correlation coefficient is .80· SD error 2,000· No of observations: 1,000What is the expected annual utility cost of the company if it has 150 machines, and it will use 5,000 hours for next year?
Jensen Tire Auto is deciding whether to purchase a maintenance contract for its new computer wheel alignment and balancing machine. Managers feel that maintenance expense should be related to usage, and they collected the following information on weekly usage (hours) and annual maintenance expense (in hundreds of dollars). a. Develop a scatter chart with weekly usage hours as the independent variable. What does the scatter chart indicate about the relationship between weekly usage and annual maintenance expense? b. Use the data to develop an estimated regression equation that could be used to predict the annual maintenance expense for a given number of hours of weekly usage. What is the estimated regression model? c. Test whether each of the regression parameters 0 and 1 is equal to zero at a 0.05 level of significance. What are the correct interpretations of the estimated regression parameters? Are these interpretations reasonable? d. How much of the variation in the sample values of annual maintenance expense does the model you estimated in part (b) explain? e. If the maintenance contract costs 3,000 per year, would you recommend purchasing it? Why or why not?
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.
Isaiah Company uses a regression equation to analyze the behavior of its transportation costs (T) as function of travel time (H). They developed the following equation using two years' observation with a related coefficient of 85: T = 100,000 + P50HIf 500 hours of travel time were logged in one period, the related point estimate of total transportation costs would be __________ 121,250 106,250 125,000 110,000
Golden Goodness (GG) has an investment center that had the following data: Operating Income $28,000 Sales $350,000 Invested assets $175,000 PMB has set a minimum acceptable rate of return at 14%. Using the information, answer the following questions. You must include what type of number it is (%, $, etc.) Part A: What is the residual income? Part B: Show calcualtions on how you got answer
Research on a new laptop case indicates that the product can be sold for $40 per unit. Cost analysis provides the following information. Fixed cost per period = $5500 Variable cost per unit = $25 Production capacity per period = 956 units What is the revenue function?
P Company has provided the following data: Sales Price per unit: $50. Variable Cost per unit: $30; Fixed Cost: $135,000 Expected Sales: 20,000 units. c. Calculate the expected profit.
Solve the following independent cases and label your supporting computations properly. A) The company's projected profit for the coming year is as follows: Total P 200,000' 120,000 80,000 64,000 16,000 Per Unit P 20 Sales Less: Variable Costs 12 P 8 Contribution Margin P Less: Fixed Costs Net Income 1. Compute the additional profit that the company would earn if sales were P25,000 more than expected. B) KTA sells a special type of health food at a price of P16 per pound. Last year, it purchases this food from its supplier at a cost of P12 per pound. The supplier informed KTA that its cost increases and that this product will now be priced at P14 a pound. Over the years, KTA established a steady market and intends to pass the cost increase along to its customers and also add a P1 per unit to the price for additional profit. Fixed cost for the year are not expected to change and will remain at P34,000. Income tax rate is 32%. The net income after tax last year was P24,000. 2. If KTA can…
For the coming year, Bepis Inc. anticipates fixed costs of $700,000, a unit variable cost of $85, and a unit selling price of $105. The maximum sales within the relevant range are $2,500,000. a. Construct a cost-volume-profit chart. b.Estimate the break-even sales (dollars) by using the cost-volume-profit chart constructed in part (A). c. What is the main advantage of presenting the cost-volume-profit analysis in graphic form rather than equation form?
Your company has reviewed its new product that it introduced last year, and it has been found that the annual salesIt amounts to (8,000) units, the unit selling price is (140) dinars, and annual fixed costs are (27,000)dinars and the variable cost of the unit (60) dinars. You are asked to answer the following, using an analysisTie level at it:1- What is the current break-even size, calculate it algebraically and graphically.2- Calculate the profit under the current sales volume.3- To what extent can the sales volume be increased if the company wants to achieve net profits that increase?(25%) of the profit achieved under the current prevailing situation, that is, in light of the current sales volume?4- To what extent can fixed costs be reduced, if the company wants to achieve net profits that increase?(20) percent of the profit achieved under the current prevailing situation, that is, in light of the current sales volume?
ABC Company manufactures the product XE-17. The product is sold at a unit price of $70.Variable expenses are $13.50 per unit and fixed expenses are $220,000 per year.Required :a. What should be the product’s CM ratio? b. Calculate the BEP is sales dollars and in units for ABC Company. c. The manager of ABC company estimates that in the coming year, the company’s sales willincrease by $80,000 (from the current sales). How much should the net profit / loss increase/decrease if the fixed costs remain constant? d. The manager of ABC company predicts that by spending an additional $80,000 per year onadvertising and using higher quality raw material (which will in turn increase the raw materialcost per unit by $3), and increasing selling price per unit by 2% (to compensate for theincreased costs), unit sales will increase by two- thirds of the current sales units. Should thecompany go with the manager’s proposed plan? Explain your answer. (Assume that in thecurrent year, the company sold…
ABC Company manufactures the product XE-17. The product is sold at a unit price of $70.Variable expenses are $13.50 per unit and fixed expenses are $220,000 per year.Required :a. What should be the product’s CM ratio? b. Calculate the BEP is sales dollars and in units for ABC Company. c. The manager of ABC company estimates that in the coming year, the company’s sales willincrease by $80,000 (from the current sales). How much should the net profit / loss increase/decrease if the fixed costs remain constant? d. The manager of ABC company predicts that by spending an additional $80,000 per year onadvertising and using higher quality raw material (which will in turn increase the raw materialcost per unit by $3), and increasing selling price per unit by 2% (to compensate for theincreased costs), unit sales will increase by two- thirds of the current sales units. Should thecompany go with the manager’s proposed plan? Explain your answer. (Assume that in thecurrent year, the company sold…