The investment cost of the fruit juice business was determined as 3,200,000 TL. The depreciation rate of the enterprise is determined as 10%. Fruit juice and concentrate are produced in equal amounts at the facility. The business operates 300 days a year and 12 hours a day. The maintenance and repair expenses of the enterprise are determined as 65,000 TL/year, the unexpected expenses are 36.000 TL/year, the fixed tax total is 82.000 TL/year, and the total personnel salaries are 300.000 TL/year. Fruit juice production cost was calculated as 2.6 TL/kg product and concentrate production cost as 6.8 TL/kg product. Fruit dry matter rate was 16%, fruit juice dry matter rate was 6%, and concentrated dry matter rate was 72%. Since the raw material price is 3.5 TL/kg of raw material, fruit juice and concentrate sales prices are 5.8 TL/kg and 32 TL/kg, what is the minimum raw material amount that must be processed per hour for the business to make a profit?

The investment cost of the fruit juice business was determined as 3,200,000 TL. The depreciation rate of the enterprise is determined as 10%. Fruit juice and concentrate are produced in equal amounts at the facility. The business operates 300 days a year and 12 hours a day. The maintenance and repair expenses of the enterprise are determined as 65,000 TL/year, the unexpected expenses are 36.000 TL/year, the fixed tax total is 82.000 TL/year, and the total personnel salaries are 300.000 TL/year. Fruit juice production cost was calculated as 2.6 TL/kg product and concentrate production cost as 6.8 TL/kg product. Fruit dry matter rate was 16%, fruit juice dry matter rate was 6%, and concentrated dry matter rate was 72%. Since the raw material price is 3.5 TL/kg of raw material, fruit juice and concentrate sales prices are 5.8 TL/kg and 32 TL/kg, what is the minimum raw material amount that must be processed per hour for the business to make a profit?

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 35P

See similar textbooks

Similar questions

Assume the demand for a companys drug Wozac during the current year is 50,000, and assume demand will grow at 5% a year. If the company builds a plant that can produce x units of Wozac per year, it will cost 16x. Each unit of Wozac is sold for 3. Each unit of Wozac produced incurs a variable production cost of 0.20. It costs 0.40 per year to operate a unit of capacity. Determine how large a Wozac plant the company should build to maximize its expected profit over the next 10 years.
It costs a pharmaceutical company 75,000 to produce a 1000-pound batch of a drug. The average yield from a batch is unknown but the best case is 90% yield (that is, 900 pounds of good drug will be produced), the most likely case is 85% yield, and the worst case is 70% yield. The annual demand for the drug is unknown, with the best case being 20,000 pounds, the most likely case 17,500 pounds, and the worst case 10,000 pounds. The drug sells for 125 per pound and leftover amounts of the drug can be sold for 30 per pound. To maximize annual expected profit, how many batches of the drug should the company produce? You can assume that it will produce the batches only once, before demand for the drug is known.
Jasmine is a mother of three children, ages 6 months, 2 years, and 3 and a half. Jasmine makes $24,000 a year at her full-time job, while her husband, Jamal, makes $45,000 a year. The daycare their children attend currently costs them $18,000 a year for all three children, but next year the cost is going up to $21,000. Jasmine wonders whether it’s even worth working, when she spends so much of her salary on childcare, and is considering quitting her job completely or working part-time instead. Jasmine’s dilemma is an example of a gendered process that occurs in the point of overlap of which two institutional arenas? the market and the family the family and the state the family and religion the state and the market
A plant operation has fixed cost of $2,000,000 per year, and its output capacity is 100,000 electrical appliances per year. The variable cost is $70 per unit, and the product sells for $120 per unit. a) What is the annual break even volume of this product? b) Compare annual profit when the plant is operating at 90% capacity with the plant operation at 100% capacity. Assume that the first 90% of capacity output is sold at $120 per unit and that the remaining 10% of production is sold at $100 per unit. Show handwritten solutions
Aurillo Equipment Company (AEC) projected that its ROE for next year would be just 6 percent.However, the financial staff has determined that the firm can increase its ROE by refinancing somehigh interest bonds currently outstanding. The firm’s total debt will remain at $200,000 and the debtratio will hold constant at 80 percent, but the interest rate on the refinanced debt will be 10 percent.The rate on the old debt is 14 percent. Refinancing will not affect sales, which are projected to be$300,000. EBIT will be 11 percent of sales and the firm’s tax rate is 40 percent. If AEC refinances itshigh interest bonds, what will be its projected new ROE?
Pastureland Dairy makes cheese, which it sells at local supermarkets. The fixed monthly cost of production is $4,000, and the variable cost per pound of cheese is $0.21. The cheese sells for $0.75 per pound; however, the dairy is considering raising the price to $0.95 per pound. The dairy currently produces and sells 9,000 pounds of cheese per month, but if it raises its price per pound, sales will decrease to 5,700 pounds per month. Should the dairy raise the price?
McGwire Aerospace expects to have net cash flow of $12 million. The company forecasts that its operating costs excluding depreciation and amortization will equal 75 percent of the company’s sales. Depreciation and amortization expenses are expected to be $5 million and the company has no interest expense. All of McGwire’s sales will be collected in cash, costs other than depreciation and amortization will be paid in cash during the year, and the company’s tax rate is 40 percent. What is the company’s expected sales?
Scott Power produces batteries. The company has determined its contribution margin to be $8 perbattery and its contribution margin ratio to be 0.4. What is the effect on profits of the sale of oneadditional battery? Of one additional dollar of sales?
The Rio Credit Union has $250,000 available to invest in a 12-month commitment and wants to invest all of it. The money can be placed in Brazilian treasury notes yielding an 8% return or in riskier high-yield bonds at an average rate of return of 9%. Credit union regulations require diversification to the extent that at least 50% of the investment be placed in Treasury notes. It is also decided that no more than 40% of the investment be placed in bonds. The aim of the objective function for Rio Credit Union should be to Maximize the objective value. Decision variables: X = $ invested in Treasury notes Y = $ invested in Bonds Objective function (in decimals, eg., .07, NOT 7%): The optimal ROI occurs when: X = Y = (enter your response as a whole number). Optimal ROI value 'Z' = (enter your response as a whole number)
The owner of a greenhouse and nursery is considering whether to spend $6,000 to acquire the licensing rights to grow a new variety of rosebush, which she could then sell for $6 each. Per-unit variable cost would be $3. How many rosebushes would she have to produce and sell in order to break even?
A local canning company sells canned vegetables to a supermarket chain in the Minneapolis area. A typical case of canned vegetables requires an average of 0.2 day of labor to produce. The aggregate inventory on hand at the end of June is 800 cases. The demand for the vegetables can be accurately predicted for about 18 months based on orders received by the firm. The predicted demands for the next 18 months are as follows: (given) The firm currently has 25 workers. The cost of hiring and training a new worker is $1,000, and the cost to lay off one worker is $1,500. The firm estimates a cost of $2.80 to store a case of vegetables for a month. They would like to have 1,500 cases in inventory at the end of the 18-month planning horizon. a. Develop a spreadsheet to find a plan that hires and fires workers monthly in order to minimize inventory costs. Determine the total cost of that plan as well.
Hudson Corporation is considering three options for managing its data processing operation: continuing with its own staff, hiring an outside vendor to do the managing (referred to as outsourcing), or using a combination of its own staff and an outside vendor. The cost of the operation depends on future demand. The annual cost of each option (in thousands of dollars) depends on demand as follows: Demand Staffing Options High Medium Low Own staff 650 650 600 Outside vendor 900 600 300 Combination 800 650 500 If the demand probabilities are 0.2, 0.5, and 0.3, which decision alternative will minimize the expected cost of the data processing operation? What is the expected annual cost associated with that recommendation? Expected annual cost = $fill in the blank 2 Construct a risk profile for the optimal decision in part (a). The input in the box below will not be graded, but may be reviewed and considered by your instructor.