Running head: PROBLEM SET I
Problem Set I Problem Set I
4-20
Juan’s Taco Company has restaurants in five college towns. Juan wants to expand into Austin and College Station and needs a bank loan to do this. Mr. Bryan, the banker, will finance construction if Juan can present an acceptable three-month financial plan for January through March. The following are actual and forecasted sales figures:
Table 1
Actual
November $120,000
December 140,000
Forecast
January $190,000
February 210,000
March 230,000
April $230,000
Of Juan’s sales, 30 percent are for cash and the remaining 70 percent are on credit. Of credit sales, 40 percent are paid in the month after sale and 60 percent are paid in the second month after the sale.
…show more content…
Table 4
Cash Budget Total Cash Receipts Total Cash Payments Net Cash Flow Beginning Cash Balance Cumulative Cash Balance Monthly Loan or (repayment) Cumulative Loan Balance Ending Cash Balance
January $146,600 154,500 (7,900) 70,000 62,100 2,900 2,900 $ 65,000
February $175,000 169,500 5,500 65,000 70,500 (2,900) -0- $ 67,600
March
$207,600 220,500 (12,900) 67,600 54,700 10,300 10,300 $ 65,000
5-2. Hazardous Toys Company produces boomerangs that sell for $8 each and have a variable cost of $7.50. Fixed costs are $15,000.a. Compute the break-even point in units. b. Find the sales (in units) needed to earn a profit of $25,000.
Table 5 Total Fixed Costs ÷ (Selling Price - Variable Cost) = Break-even sales $15,000 Break-even ÷ ($8 Per Unit -
.. 50 $7.50) Variable Cost = 30,000 Units
($25,000 Profit +
$40,000 $15,000) Break-even ÷ ($8 Per Unit -
.. 50 $7.50) Variable Cost = 80,000 Units
7-3. City Farm Insurance has collection centers across the country to speed up collections. The company also makes its disbursements from remote disbursement centers so checks written by City Farm take longer to clear the bank. Collection time has been reduced by two and disbursement time increased by one day because of
1- The total unit cost = Total Variable Cost + Production Fixed Expenses + Advertising Expense + Selling and Administrative Expense = 3.23 + 1.20 + 0.30 + 0.19 = 4.92.
Breakeven Analysis for Product Tylenol Approach 1 - Same price as Tylenol Approach 2a - Cheaper than Tylenol Approach 2b - Cheaper w/lowered trade cost $ $ $ $ Unit Cost (Variable Cost) 0.60 0.60 0.60 0.60 Trade Cost (Selling Price to Retailers) $ 1.69 $ 1.69 $ 1.05 $ 0.70 Fixed Cost (Advertising) 2,000,000 6,000,000 6,000,000 6,000,000 Break-Even Quantity [Fixed Cost/(Trade Cost-Unit Cost)] 1,834,862 5,504,587 13,333,333 60,000,000 Contribution Margin (Unit) 64% 64% 43% 14%
There would still be a net loss in 2006 due to the increase of break-even point, which increased from $7,505 to $8,640.
This is a report which has been created to introduce new childcare practitioners to safeguarding within a childcare setting. This will help new practitioners to understand current legislations within the United Kingdom.
5. Determine the necessary sales in unit and dollars to break-even or attain desired profit using the break-even formula.
2. Statements (1) and (2) refer to water volumes. Are these Net or Gross volumes? (1) Crop water use (cu-ft) = Seasonal ET (ft) x Crop area (acres) x 43,560 sq-ft/acre (2) Volume applied by system (ac-in) = Application rate (in/hr) x Irrigation time (hr) x Area (acres)
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.
= Unit Selling Price – Unit Variable Cost = $9.00 – ($1.25 + $0.35 + $1.00) = $6.40
The revenue is $600,600*1.2= $720,720. The variable cost changes as sales increases and fixed cost stays the same, the gross profit is $175,500. After tax, the net income is $100,557.
4. Evergreen Fertilizer Company produces fertilizer. The company’s fixed monthly cost is $25,000, and its variable cost per pound of fertilizer is $0.15. Evergreen sells the fertilizer for $0.40 per pound. Determine the monthly break-even volume for the
Question 4: Calculate each of the three products’ break even points using the data. Why is the sum of these three volumes not equal to the 1,100,000 unit’s aggregate break-even volume?
The semi-annual compounded interest rate is 5.2% (a six-month discount rate of 5.2/2 = 2.6%). (15 points)
b) What is the firm’s forecasted average daily sales for the first three months of operations? For the entire half-year?
As an example, if fixed costs are $100, price per unit is $10, and variable costs per unit are $6, then the break-even quantity is 25 ($100 ÷ [$10 − $6] = $100 ÷$4). When 25 units are produced and sold, each of these units will not only have covered its own marginal (variable) costs, but will have also have contributed enough in total to have covered all associated fixed costs. Beyond these 25 units, all fixed costs have been paid, and each unit contributes to profits by the excess of price over variable costs, or the contribution margin. If demand is estimated to be at least 25 units, then the company will not experience a loss. Profits will grow with each unit demanded above this 25-unit break-even level.
When price is $20.6, the quantity is 1,242,425 and profit is $101, we come near to break even point.