### Free Educational Resources

• > 1) Furrel’s Ice Cream Company ships ice cream in bulk from its manufacturing
+

# 1) Furrel’s Ice Cream Company ships ice cream in bulk from its manufacturing

(0)
##### Description:

1) Furrel’s Ice Cream Company ships ice cream in bulk from its manufacturing facility to its 25 retail outlets

1) Furrel’s Ice Cream Company ships ice cream in bulk from its manufacturing facility to its 25 retail outlets. Furrel’s has categorized its retail outlets into four types, each of which sells a certain level of ice cream per week, measured in pounds. Furrel’s ships its ice cream in two different size reusable containers: a 6-pound container and a 10-pound container. The company currently has 200 6-pound containers and 25 10-pound containers. The company would like to minimize the amount of excess ice cream shipped to each store while making use of its existing reusable containers.  For example, store type 1 needs 25 pounds of ice cream a week. Furrel’s could ship this in one 10-pound container and three 6-pound containers for a total of 28 pounds (3 pounds excess) or in two 10-pound containers and one 6-pound containers (1 pound excess).  However, with only 25 10-pound containers available, it is not clear that this is the best choice for this type of store.

Store Type

Type 1

Type 2

Type 3

Type 4

Pounds of Ice Cream needed

25

40

50

100

Number of Stores

10

5

4

6

a) Given this current store configuration and the number of reusable containers available, how many 6-pound and 10-pound containers should be used to ship to each store in order to minimize the excess ice cream? How much excess ice cream will this lead to each week?
b) Should Furrel’s purchase more 6-pound containers or more 10-pound containers? Why?
2) Arizona Semiconductor is trying to determine which R&D projects to fund for the upcoming fiscal year. The company has a limit of \$200,000 and 10 researchers available for R&D to be spread between several projects. The table below shows the resources required for each project for the upcoming year and the expected annual profit from each project.

Project

1

2

3

4

5

6

Expense (\$)

75

100

25

43

55

12

Number of Researchers

7

4

4

6

2

1

Profit (\$)

92

85

4

72

50

15

a. Which projects should the company choose to maximize expected annual profit? How much is that profit? Set this up as a spreadsheet using Solver.
b. Suppose the company determines that that it must select either project 5 or 6 but not both. Does this change the list of projects the companies should undertake? How?
c. If the company wants to increase the amount of R&D it does in the upcoming year, should it allocate more funding or hire more researchers?

(more)
##### Try a College Course Free

Sophia’s self-paced online courses are a great way to save time and money as you earn credits eligible for transfer to over 2,000 colleges and universities.*

No credit card required

26 Sophia partners guarantee credit transfer.

226 Institutions have accepted or given pre-approval for credit transfer.

* The American Council on Education's College Credit Recommendation Service (ACE Credit®) has evaluated and recommended college credit for 21 of Sophia’s online courses. More than 2,000 colleges and universities consider ACE CREDIT recommendations in determining the applicability to their course and degree programs.

Tutorial