solution

Individual Excel Solver Computer Project

Natural Furniture Company manufactures three outdoor products, chairs, benches, and tables. Each product must pass through the following departments before it is shipped: sawing, sanding, assembly, and painting. The production time available in each department each week and the minimum weekly production requirement to fulfill contracts are as shown in the table below

Weekly production time and quantities

Department

Capacity

(In hours)

Product

Minimum production level

Sawing

450

Chairs

100

Sanding

400

Benches

50

Assembly

625

Tables

50

Painting

550

The production time requirements (in hours) and profit per unit of each product are summarised in the table below.

Production time and profit per single product

Hours required

Product

Sawing

Sanding

Assembly

Painting

Unit profit

Chairs

1.5

1.0

2.0

1.5

$15

Benches

1.5

1.5

2.0

2.0

$10

Table

2.0

2.0

2.5

2.0

$20

The production manager has the responsibility of specifying production levels for each product for the coming week.

(a) Formulate a linear programming model for this problem.

(b) Set up a spreadsheet model for this problem and use the Excel Solver to find the optimal solution.

(c) State the optimal solution and the value of the objective function.

 
"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"

solution

Group of answer choices
Secretary of the Interior who tried to sell off 1 million acres of Federal land in Alaska to coal mine companies.
[ Choose ] Frank B. Kellogg John Hay Charles Gates Dawes William Howard Taft Richard Achilles Ballinger Jacob H. Smith Emilio Aguinaldo Frederick Winslow Taylor Andrew Mellon Upton Sinclair Theodore Roosevelt Jane Addams Charles Evans Hughes
Made the Supreme Court a truly separate branch of government and more efficient at handling the nation’s legal cases.
[ Choose ] Frank B. Kellogg John Hay Charles Gates Dawes William Howard Taft Richard Achilles Ballinger Jacob H. Smith Emilio Aguinaldo Frederick Winslow Taylor Andrew Mellon Upton Sinclair Theodore Roosevelt Jane Addams Charles Evans Hughes
While governor of the Philippines he oversaw a policy of “Attraction and Chastisement” which won the conflict. As president he exercised a foreign policy which emphasized US overseas investment.
[ Choose ] Frank B. Kellogg John Hay Charles Gates Dawes William Howard Taft Richard Achilles Ballinger Jacob H. Smith Emilio Aguinaldo Frederick Winslow Taylor Andrew Mellon Upton Sinclair Theodore Roosevelt Jane Addams Charles Evans Hughes
Fought a war of independence against the United States.
[ Choose ] Frank B. Kellogg John Hay Charles Gates Dawes William Howard Taft Richard Achilles Ballinger Jacob H. Smith Emilio Aguinaldo Frederick Winslow Taylor Andrew Mellon Upton Sinclair Theodore Roosevelt Jane Addams Charles Evans Hughes
 
"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"

solution

Name a TV commercial or print ad you would rate as the “most outstanding” one you have seen lately. If you do not have a link to the ad, provide a brief description or indicate where and when it can be viewed. Apply the guidelines for creative evaluation (textbook, page 219) to that ad or campaign to see whether or not it fulfills all the criteria. Share your thinking after you have completed your evaluation.

High Involvement-Transformational Emotional portrayal of motive Authenticity Paramount; must reflect lifestyle of target audience Necessary Like ad Execution style Unique; target audience must identify with product, people, or consumption situation shown Benefit claim of brand message Number of benefits Acceptable number to provide key information Very accurate claim, may overclaim but do not underclaim Intensity of benefit claim Repetition of benefit claim Many are required to support informational message LO5 IMC Planning: Guidelines for Creative Evaluation While the creative specialists have much responsibility for determining the message appeal and execution style to be used in a campaign, the marketer must evaluate and approve the creative approach before any ads are produced. A number of people may be involved in evaluating the creative recommendation, including the advertising or communications manager, product or brand managers, marketing director or vice-president, representatives from the legal department, and even senior managers if required. Top management is involved in selecting an ad agency and must approve the theme and creative strategy for the campaign. Evaluation and approval of individual ads proposed by the agency is often the responsibility of advertising and product managers. The account executive and a member of the creative team present the creative concept to the client’s advertising and product managers for their approval before beginning production. A careful evaluation should be made before the campaign actually enters production, since this stage requires considerable time and money. Basic criteria for evaluating the creative approach focus on a number of questions requiring managerial judgment: • Is the creative approach consistent with the brand’s marketing and advertising objectives? Advertisers must consider whether the creative strategy and tactics recommended by the agency are consistent with the marketing strategy for the brand and the role advertising and promotion have been assigned in the overall marketing program (i.e., brand image marketing positioning strategy). • Is the creative approach consistent with the communication objectives? The creative strategy and tactics must meet the established communication objectives. Creative specialists can lose sight of what the advertising message is supposed to be and come up with an approach that fails to execute the advertising strategy. Individuals responsible for approving the ad should ask the creative specialists to explain how the creative strategy and tacties achieve the creative and communications objectives. Is the creative approach appropriate for the target audience? Careful consideration should be given to whether the creative strategy and tactics recommended will appeal to be understood by, and communicate effectively with the target audience. This involves studying all elements of the ad and how the audience will respond to them. Advertisers do not want to approve advertising that they believe will receive a negative reaction from the target audience. Does the creative approach communicate a clear and convincing message to the customer? Most ads are supposed to communicate a message that will help sell the brand. While creativity is important in advertising, it is also important that the advertising communicate information attributes, features and benefits, and/or images that give consumers a reason to buy the brand.

 
"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"

solution

A firm draws twelve samples of size 200 from a production process and counts the number of defects. The values are: 0.3.3, 1.2, 2.3, 1.1, 8, 2, and 6. Produce a two-sigma p-chart. Use that control chart to answer the questions below. Round all values to four decimal points.

Listen What is the upper control limit? Your Answer: Answer
Listen What is the center line? Your Answer: Answer
Listen What is the lower control limit? Your Answer: Answer
Listen Sample 1 is out of control. True False
Listen Sample 2 is out of control. True
Listen Sample 3 is out of control. True False
Listen Sample 4 is out of control. True False
Listen Sample 5 is out of control. True False Sample 6 is out of control. True False
Listen Sample 7 is out of control. True False
Listen Sample 8 is out of control. True False
Sample 9 is out of control. True False
Listen Sample 10 is out of control. True False
Listen Sample 11 is out of control. True False

 
"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"