general business data bank
PROBLEM
1. A snack food manufacturer buys corn for tortilla chips from two cooperatives, one in Iowa and one in Illinois. The price per unit of the Iowa corn is $5.50 and the price per unit of the Illinois corn is $6.00.
a. 
Define variables that would tell how many units to purchase from each source. 
b. 
Develop an objective function that would minimize the total cost. 
c. 
The manufacturer needs at least 12000 units of corn. The Iowa cooperative can supply up to 8000 units, and the Illinois cooperative must supply at least 6000 units. Develop constraints for these conditions. 
2. The relationship d = 5000 25p describes what happens to demand (d) as price (p) varies. Here, price can vary between $10 and $50.
a. 
How many units can be sold at the $10 price? How many can be sold at the $50 price? 
b. 
Model the expression for total revenue. 
c. 
Consider prices of $20, $30, and $40. Which price alternative will maximize total revenue? What are the values for demand and revenue at this price? 
3. There is a fixed cost of $50,000 to start a production process. Once the process has begun, the variable cost per unit is $25. The revenue per unit is projected to be $45.
a. 
Write an expression for total cost. 
b. 
Write an expression for total revenue. 
c. 
Write an expression for total profit. 
d. 
Find the breakeven point. 
4. An author has received an advance against royalties of $10,000. The royalty rate is $1.00 for every book sold in the United States, and $1.35 for every book sold outside the United States. Define variables for this problem and write an expression that could be used to calculate the number of books to be sold to cover the advance.
5. A university schedules summer school courses based on anticipated enrollment. The cost for faculty compensation, laboratories, student services, and allocated overhead for a computer class is $8500. If students pay $420 to enroll in the course, how large would enrollment have to be for the university to break even?
6. As part of their application for a loan to buy Lakeside Farm, a property they hope to develop as a bedandbreakfast operation, the prospective owners have projected:
Monthly fixed cost (loan payment, taxes, insurance, maintenance) 
$6000 
Variable cost per occupied room per night 
$ 20 
Revenue per occupied room per night 
$ 75 
a. 
Write the expression for total cost per month. Assume 30 days per month. 
b. 
Write the expression for total revenue per month. 
c. 
If there are 12 guest rooms available, can they break even? What percentage of rooms would need to be occupied, on average, to break even? 
7. Organizers of an Internet training session will charge participants $150 to attend. It costs $3000 to reserve the room, hire the instructor, bring in the equipment, and advertise. Assume it costs $25 per student for the organizers to provide the course materials.
a. 
How many students would have to attend for the company to break even? 
b. 
If the trainers think, realistically, that 20 people will attend, then what price should be charged per person for the organization to break even? 
8. In this portion of an Excel spreadsheet, the user has given values for selling price, the costs, and a sample volume. Give the cell formula for
a. 
cell E12, breakeven volume. 
b. 
cell E16, total revenue. 
c. 
cell E17, total cost. 
d. 
cell E19, profit/loss. 
A 
B 
C 
D 
E 

1 

2 

3 

4 
Breakeven calculation 

5 

6 
Selling price per unit 
10 

7 

8 
Costs 

9 
Fix cost 
8400 

10 
Variable cost per unit 
4.5 

11 

12 
Breakeven volume 

13 

14 
Sample calculation 

15 
Volume 
2000 

16 
Total revenue 

17 
Total cost 

18 

19 
Profit loss 
9. A furniture store has set aside 800 square feet to display its sofas and chairs. Each sofa utilizes 50 sq. ft. and each chair utilizes 30 sq. ft. At least five sofas and at least five chairs are to be displayed.
a. 
Write a mathematical model representing the store's constraints. 

b. 
Suppose the profit on sofas is $200 and on chairs is $100. On a given day, the probability that a displayed sofa will be sold is .03 and that a displayed chair will be sold is .05. Mathematically model each of the following objectives: 

1. 
Maximize the total pieces of furniture displayed. 

2. 
Maximize the total expected number of daily sales. 

3. 
Maximize the total expected daily profit. 

Rating:
5/
Solution: general business data bank