o pick from. The data for each package is as shown, each is expected to have a useful life of 8 yr.s and the company MARR is 6%. Using RoR analysis, which package should be selected? IC O&M/yr. A B с D $6,500.00 $5,000.00 $7,000.00 $4,000.00 $1,068.62 $ 839.31 $ 835.35 $949.31

o pick from. The data for each package is as shown, each is expected to have a useful life of 8 yr.s and the company MARR is 6%. Using RoR analysis, which package should be selected? IC O&M/yr. A B с D $6,500.00 $5,000.00 $7,000.00 $4,000.00 $1,068.62 $ 839.31 $ 835.35 $949.31

Name: help me solve this in excel please!!! show all steps/screenshot excel
Uploaded: 2024-03-20T06:50:59.000Z
Channel: Bartleby
Description: help me solve this in excel please!!! show all steps/screenshot excel please will give thumbs up ASAP Joe's Sales & Service LLC is considering buying new software and has four packagesto pick from. The data for each package is as shown, each is expec

Principles of Accounting Volume 2

19th Edition

ISBN:9781947172609

Author:OpenStax

Publisher:OpenStax

Chapter3: Cost-volume-profit Analysis

Section: Chapter Questions

Problem 8EB: Shonda & Shonda is a company that does land surveys and engineering consulting. They have an...

See similar textbooks

Similar questions

A start up business is considering two types of equipment - data are as follows: TYPE A ΤΥΡE Β First Cost P200,000.00 P300,000.00 Annual operating cost 32,000.00 24,000.00 Annual labor cost 50,000.00 32,000.00 Insurance and property taxes 3% 3% Payroll taxes 4% 4% Estimated life 10 10 The minimum required rate of return is 15%. Using present worth cost method, determine the value of alternative A and alternative B: ANSWER for ALTERNATIVE A: Blank 1 ANSWER for ALTERNATIVE B: Blank 2
Grove Audio is considering the introduction of a new model of wireless speakers with the following price and cost characteristics. Sales price $ 439.00 per unit Variable costs 199.00 per unit Fixed costs 687,000 per year Assume that the projected number of units sold for the year is 4,200. Consider requirements (b), (c), and (d) independently of each other. Required: What will the operating profit be? What is the impact on operating profit if the sales price decreases by 20 percent? Increases by 10 percent? What is the impact on operating profit if variable costs per unit decrease by 10 percent? Increase by 20 percent? Suppose that fixed costs for the year are 20 percent lower than projected, and variable costs per unit are 10 percent higher than projected. What impact will these cost changes have on operating profit for the year? Will profit go up? Down? By how much?
A new product's chief uncertainty is its annual net revenue. So far, $23K has been spent on development, but an additional $30K is required to license a patent. The firm's interest rate is 10%. What is the expected PW for deciding whether to proceed? Use an economic decision tree. State Bad OK Great Probability .4 .1 Net revenue -$3K $10K $25K Life (years) 5 10
Lipsion Ltd company is thinking about investing in one of two potential new productsfor sale. The projections are as follows: year revenue/ product s revenue/ product v0 (150,000) outlay (150000) outlay1 14000 150002 24000 253333 44000 520004 84000 63333 Calculate the IRR for Product V only using 1% and 17% to 2 d.p.
A retail company is considering the two mutually exclusive projects glven in the following table. Selling toys $350.000 Yoar Selling kitchenware -$300,000 1 240,000 230,000 265,000 210,000 30% Find the range of MARR for which the company would invest in selling kitchenware over selling toys with do-nothing altemative. (choose the closest range) IRR 28% MAAR s 15% O 15% SMAARS30% MAARS28% O 5% SMAARS28% O None of the above
“Happy Your Self" ( HYS) Co. is evaluating an investment proposal to manufacture GB pen drives, which has performed well in test marketing trials conducted recently by the company’s research and development division. The following information relating to this investment proposal has now been prepared. Initial investment GH¢ 2 million Selling price (current price terms) GH¢ 20 per unit Expected selling price inflation 3% per year Variable operating costs (current price terms) GH¢ 8 per unit Fixed operating costs (current price terms) GH¢ 170,000 per year Expected operating cost inflation 4% per year The research and development division has prepared the following demand forecast as a result of its test marketing trials. The forecast reflects expected technological change and its effect on the anticipated life-cycle of GB pen drives. Year 1 2 3 4 Demand (units) 60,000 70,000 120,000 45,000 It is expected that all units of GB pen drives produced will be sold, in line with…
¿How much is the Customer Lifetime Value? (Select best answer) Assumptions: Retention Rate= 75%, Average annual customer purchase $20,000, 30.2% Contribution Margin, Annual Fixed costs $100,000 ($5,000 por customer), i=Cost of Capital=.10, Growth=0, no new cash investments. Seleccione una: a. 0 or less (Negative value) b. 100 c. 500 d. 750 e. 1000 f. 2000 g. 3000 h. 4000 i. 5000 j. 6000 k. 7000 l. 8000 m. 9000 n. 9500 o. 10000 or over
HELP ME
Suppose that you want to buy an equipment for their plant. The following two options are available (see below). If the price of electricity is 0.6 OR/kW-hr and the Ac's are expected to work 4320 hr/yr, which A/C do you recommend to buy if MARR is 16%. Use PW method Offer A Offer B Investment Power consumption (kW) 50,000 55,000 1.6 1.2 Annual revenues 19,000 19,400 (RO/year) Life time (yr) Salvage value (RO) 8 2,000 1,300
ssume that Cane expects to produce and sell pplier has offered to manufacture and deliver 80,000 Alphas to Cane for a price of SH0 per unit. What is the financial advantage (disadvantage) of buying 80,000 units from the supplier instead of making those units? 10. Assume that Cane expects to produce and sell 50,000 Alphas during the current year A plher has offered to manufacture and deliver 50,000 Alphas to Cane for a price of S80p- unit. What is the financial advantage (disadvantage) of buying 50,000 units from the supplier instead of making those units? 11. How many pounds of raw material pre needed to make one unit of each of the two produeee 12. What contribution margin per pound of raw material is earned by each of the two produeten 13. Assume that Cane's customers would buy a maximum of 80,000 units of Alpha and 60 units of Beta. Also assume that the raw material available for production is limited to 160,000 pounds, How many units of each product should Cane produce to maximize…
Given two alternatives, A and B; you have performed the cost analysis below. Your company has an MARR of 10%, which option should you choose? A B А-B Initial Cost $125,000 $105,000 $20,000 Annual $30,500 $27,000 $3,500 Benefits Annual $2,900 $4,000 ($1,100) Costs Salvage $0 $7,000 ($7,000) Value Life 7 7 7 IRR 12.2% 12.9% 7.8% A Neither Either could be chosen, they are equally as good
1. Multiplicationtable: (No need the explanation just the answer pls)A manufacturer has invested P750,000 in a new product and wants to set a price to earn a 15 percent ROI. The cost per unit is P18 and the company expects to sell 50,000 units in the first year. The company's target-return price for this product is P ______. a. 18.23 b.20.25 c.20.70 d.18.10 e.25.202. A ballpen manufacturer have the following costs and expected sales: Variable cost P 10.00 Fixed cost P300,000.00Expected unit sales 50,000 Break-even volume will be P______. a. 30,000 b. 35,000 c. 20,000 d. 25,000 3. If the cost of manufacturing a product is P30 and the item sells for P50, the markup percentage is _____ %. a. 67.7 b. 67.6 c. 66.7 d. 66.8