Purchase Solution

Spreadsheet model to find the optimal number

Not what you're looking for?

Ask Custom Question

Problem 1:
Market Survey Inc (MSI) specializes in evaluating consumer reaction to new products. A client has recently asked MSI to conduct 1000 door-to-door personal interviews to obtain response from households with children and households without children to a new product. MSI can do both day and evening interviews with the following costs per interview:

Day Evening
Children $20 $25
No Children $18 $20
Interview Costs
In addition, the following quota guidelines are required by the client:
1- Interview at least 300 evening interviews
2- At least 40% of the day interviews must be from households with children.
MSI should now determine the best household, time-of-day interview plan that minimizes interview costs. Develop a spreadsheet and find the optimal number of interviews of each type.

Problem 2:
Beaver Creek Pottery Company is a small crafts operation run by a Native American tribal council. The company employs skilled artisans to produce clay bowls and mugs. The three primary resources used by the company are special pottery clay, dryer machine and skilled labor. The company desires to know the daily production mix for the two products to maximize profit. The resource requirements for production and profit per item are given below:
Resource Requirements
Product Labor
(HR./UNIT) Dryer Machine
(HR./UNIT) Clay
(LB/UNIT) Profit
($/UNIT)
Bowl 1 0.1 4 40
Mug 2 0.3 3 50

There are 40 hours of labor, 120 pounds of clay and 12 hours of dryer-machine time available each day for production.
Use spreadsheet modeling and find the optimal number of bowls and mugs to produce in order to maximize total profit.

Attachments
Purchase this Solution

Solution Summary

This response provides guidelines for how to develop a spreadsheet model to find the optimal number using linear programming methods.

Solution Preview

Dear Student,

Please find guidelines related to developing a spreadsheet model to find the optimal number.

The content below has been written ...

Purchase this Solution


Free BrainMass Quizzes
Six Sigma for Process Improvement

A high level understanding of Six Sigma and what it is all about. This just gives you a glimpse of Six Sigma which entails more in-depth knowledge of processes and techniques.

Organizational Behavior (OB)

The organizational behavior (OB) quiz will help you better understand organizational behavior through the lens of managers including workforce diversity.

Business Processes

This quiz is intended to help business students better understand business processes, including those related to manufacturing and marketing. The questions focus on terms used to describe business processes and marketing activities.

Employee Orientation

Test your knowledge of employee orientation with this fun and informative quiz. This quiz is meant for beginner and advanced students as well as professionals already working in the HR field.

Lean your Process

This quiz will help you understand the basic concepts of Lean.