Problem 3Ana Lee has just been appointed director of recreation programs forHighland Park, a rapidly growing community in Connecticut. In the past, thecity has sponsored a number of softball leagues in the summer months. Fromthe city's cost records, Ana has found the following total costs associatedwith the softball leagues over the last several years:Number ofLeaguesYearTotal CostP13,0007,00010,50014,00010,0002017..............2018.2201920202021463Each league requires its own paid supervisor and paid umpires as well asprinted schedules and other copy work. Therefore, Ana knows that somevariable costs are associated with the leagues. She would like to know theamount of variable cost per league and the total fixed cost per year associatedwith the softball program. This information would help her for planningpurposes.1. Using the least-squares regression method, compute the variable cost perleague and the total fixed cost per year for the softball program.2. Express the cost data derived in (1) above in the linear equation form Y -a + bx.3. Assume that Ana would like to expand the softball program during thecoming year to involve a total of seven leagues. Compute the expectedtotal cost for the softball program. Can you see any problem with usingthe cost formula from (2) above to derive this total cost figure?4. Prepare a scattergraph, and fit a regression line to the plotted points usingthe cost formula expressed in (2) above.

As per our protocol we provide solution to the first three sub-parts or upto first three sub-parts…

1. Using the least-squares regression method, compute the variable cost per league and the total fixed cost per year for the softball program. 2. Express the cost data derived in (1) above in the linear equation form Y- a+ bX. 3. Assume that Ana would like to expand the softball program during the coming year to involve a total of seven leagues. Compute the expected total cost for the softball program. Can you see any problem with using the cost formula from (2) above to derive this total cost figure?

1. Using the least-squares regression method, compute the variable cost per league and the total fixed cost per year for the softball program. 2. Express the cost data derived in (1) above in the linear equation form Y- a+ bX. 3. Assume that Ana would like to expand the softball program during the coming year to involve a total of seven leagues. Compute the expected total cost for the softball program. Can you see any problem with using the cost formula from (2) above to derive this total cost figure?

FINANCIAL ACCOUNTING

10th Edition

ISBN:9781259964947

Author:Libby

Publisher:Libby

Chapter1: Financial Statements And Business Decisions

Section: Chapter Questions

Problem 1Q

See similar textbooks

Similar questions

1 We learned how to use the Scenario Manager to view the results of a model when multiple 2 assumptions are changed. Using the Assumptions below, build the pro forma (in yellow) model and then run the 3 Scenarios using the the inputs in green below the pro forma. Your answer should show the After Tax Profits per Year (Summary range should be B25:F25). 4 5 6 Assumption 7 Tax Rate 8 Unit Sales 9 Sales Growth 10 Year 1 Price 11 Year 1 Cost 12 Cost Growth Rate 13 Price Growth Rate 14 15 16 17 Unit Sales 18 unit price 19 unit cost 20 21 Revenues 22 Costs 23 Before Tax Profits 24 Tax 25 After Tax Profits 26 27 28 Scenario 29 Accelerated Growth 30 Sustainable Growth 31 Moderate Growth 32 Moderate Decline 33 Accelerated Decline 34 35 Range name taxes Year1 units salesgrowth Year1 price Year1 cost costgrowth pricegrowth 1 200,000 $75.00 $60.00 $0 $0 Unit Sales 300,000 250,000 225,000 180,000 165,000 18.0% 200,000 3.5% $75.00 $60.00 2 3.0% 5.0% $0 $0 Year 3 $0 $0 Sales Growth Cost Growth 10.0%…
Harry is trying to evaluate a two year project using NPV. There is uncertainty as to the level of sales (in units) in each of the two years: Year 1 Sales units Probability Year 2 Sales units Probability 10,000 0.3 8,000 0.2 10,000 0.8 15,000 0.7 20,000 0.6 10,000 0.4 Required: (a) On what expected level of sales in Year 1 and 2 should Harry base his NPV calculation? (b) Imagine that the project outlay is £230,000 and each unit sold has a contribution of £10. If Harry’s cost of capital is 10%, what is the project’s…
For the following two alternatives, if the MARR is 10% per year (a)which one has a shorter payback period (b) which one do you select if you use the PW analysis. (c) is your selection different in (a) and (b)? Why? (d) use Spreadsheet to solve a and b. Alternative A: initial cost = $300,000 Revenue = $60,000 Alternative B: initial costs = $300,000 Revenue starts from n=1 at $10,000 and increases by $15,000 per year The expected life is 10 years for each alternative.
Develop an equation for total monthly production costs. Total Monthly Production costs = Fixed Costs + Variable Costs = _____________ + ($ per unit X Number of units) Predict total costs for a monthly production volume of 9,000 units.
The Gargus Company, which manufactures projection equipment, is ready to introduce a new line of portable projectors. The following data are available for a proposed model: Variable manufacturing costs Applied fixed manufacturing overhead Variable selling and administrative costs Applied fixed selling and administrative costs $ 380 190 145 160 What price will the company charge if the firm uses cost-plus pricing based on total variable cost and a markup percentage of 205%?
As the operator of XYZ Fitness gym, you calculate your demand equation to be x = -0 .0 6 p + 8 4 where x is the number of members in the club and p is the annual membership fee you charge per member. Your annual operating costs are a fixed cost of $20,000 per year plus a variable cost of $20 per member. Find the annual revenue function, in terms of p. Find the annual cost function, in terms of p Find a simplified expression for the annual profit function, in terms of p At what price should you set the annual membership fee to obtain the maximum revenue? What is the maximum possible revenue?
The following graph shows the daily demand curve for bikes in New York City. Use the green rectangle (triangle symbols) to compute total revenue at various prices along the demand curve. Note: You will not be graded on any changes made to this graph. 300 275 250 Total Revenue 225 200 175 150 125 100 75 50 25 Demand 10 20 30 40 50 60 70 80 90 100 110 120 QUANTITY (Bikes) PRICE (Dollars per bike)
QUANTITATIVE. Fill in the following statements based on the below project financial analysis. a. The Net Present Value is b. The Return on Investment is c. The project will break even (make back its costs) in Year d. This project Created by: Praju Manageski Note: Change the inputs, such as discount rate, number of years, costs, and benefits. Be sure to Discount rate Costs Discount factor Discounted costs Benefits Discount factor Discounted benefits profitable because the ROI and NPV are both Financial Analysis for Project GGU Assume the project is completed in Year 0 Discounted benefits -costs Cumulative benefits - costs ROI 5% 10,000 1.00 10,000 0 1.00 0 (10,000) (10,000) 16% 0 0.95 2,000 0.95 1,905 Year 0 0.91 5000 0.91 4,535 1,905 4,535 (8,095) (3,560) 0 0.86 . 6000 0.86 5,183 5,183 1,623 10,000 11,623 1,623 NPV
1. Using the high-low method of cost estimation, estimate the behavior of the maintenance costs incurred by Nation’s Capital Fitness, Incorporated. Express the cost behavior pattern in equation form. Note: Round coefficient of X to 2 decimal places and other answer to the nearest whole dollar amount. 2. 2. Using your answer to requirement 1, what is the variable component of the maintenance cost? Note: Round your answer to 2 decimal places.