HW Unit 1: Introduction (60 points)
1. “Give Fees an Inch and They’ll Take a Mile” from the Wall Street Journal, 3/14/2014 - corresponds to Ex 1 in Unit 1
In a recent bulletin the Securities & Exchange Commission (S.E.C.) noted that, while investment fees may seem inconsequential at first, “over time they can have a very profound impact on investment returns.” To illustrate, the S. E. C. considered the impact of fees in a simple situation: a 1% annual fee on a $100,000 portfolio that grew 4% annually over 20 years. The S. E. C. claimed that this investment would grow to about $180,000 over 20 years, whereas without fees it would have grown to about $220,000. Use Excel to answer the following:
(a) What exactly does the investment grow
…show more content…
(another 5 points)
3. The Break Even Company (20 points)
The Break Even Company hopes to break even in the first year producing their new product. The price of its product is $10 per pound; its variable cost is $5 per pound; and its fixed cost is $50 per day.
(a) Give the algebraic expression for profit. Be sure to define your variables. (5 points)
(b) Using your model in part (a), how many pounds per day does it need to sell to break even? (5 points)
(c) Construct an Excel model for this problem and use it to find the profit for 20 pounds per day. (5 points)
(d) Using your Excel model, use GOAL SEEK to find how many pounds per day that the company needs to sell to break even? (5 points)
4. One Product Company - corresponds to Ex 3 in Unit 1 (15 points)
Suppose that the quantity sold of a product at the One Product Company depends on the price that it charges for the product. Specifically, as its price gets higher its sales decreases according to the following Sales Response Curve:
# units sold = 115 – price/40 (This is valid for prices between 0 and $4600.) The variable cost for making the product is $1,000 per unit and its fixed cost is $10,000.
(a) Give the algebraic expression for profit. Be sure to define your variables. (5 points)
(b) Using your algebraic model in part (a), what profit will the Company make if it sells at a price of $2000? (for practice only – don’t hand in)
(c) Using your algebraic model, what price should the company
Determine the unit break-even point, assuming fixed costs are $60,000 per period, variable costs are $16.00 per unit, and the sales price is $25.00 per unit.
Assume that next year management wants the company to earn a minimum profit of $162,000. How many units be sold to meet this target profit figure? [3 points]
5. Determine the necessary sales in unit and dollars to break-even or attain desired profit using the break-even formula.
In our second assumption, instead of using the cost of goods per cases in 1986, we try to use the percentage it counts in the total expenses which is 50.4% and to find the sales needed to break-even. The detail of the calculation is shown in the answer for questions d. The result is that 95,635, a little bit higher than the estimated sales of 90,000.
1. The local Mastermind store sells innovative educational toys. Part of their service is giving advice to customers about the best toys for a particular age group, which requires having more customer service representatives in the store. During the month long Christmas buying season, it makes half of its $500,000 yearly sales. Its contribution margin on average is 40% and its fixed costs for the year are about $150,000. The owner believes that she could make even higher sales, if she had more customer service representatives on the floor during the peak season. She plans on hiring four more people for 200 hours each at $20 per hour. How much additional revenue does she have earn to the nearest dollar
Total Sales Dollars (for covering each incremental dollar of advertising) = $200,000 / $150,000 = $1.33
21. Determine the profit of each book sold to Jake Lucas, using the actual price the customer
2.) For each expense that is variable with respect to revenue hours, calculate the cost per revenue hour.
(d) What will Yabba’s market share have to be for it to generate a profit of $700,000?
The variable cost per unit is $25 and the revenue per unit is projected to be $45. Find the break-even point.Answer
Based on the Excel Problem of chapter one, if the total capacity for this business is 725 will you stay in it? If you want to stay in it what price you need to obtain a break even point of 725?
2. a. According to the simulation spreadsheet, 4 hours of investment in creation maximizes daily profit at $371.33.
a. Assuming the most current operational cost levels, what sales must it generate to recoup the above investment?
2- The per unit profit for 1 Kg of "complete meal" = Price to DM - Total unit cost= 4.40 - 4.92 = (0.52).
* Use the profit maximization rule MR = MC to determine your optimal price and optimal output level now that you have market power. Compare these values with the values you generated in Assignment 1. Determine whether your price higher is or lower.)