Our Services

Get 15% Discount on your First Order

[rank_math_breadcrumb]

A linear programming computer package is needed

EN

[email protected] Sign out

BUS-660-O500_071725_091025_ZwanzigerElsinger, Summer 2 2025

Topic 2 Assignment (Homework)
INSTRUCTOR

Summer Zwanziger Elsinger
Grand Canyon University, AZ

Home My Assignments

Grades Communication

Calendar

Current Score:  2 / 84 POINTS | 2.4 %

Scoring and Assignment Information

Due Date:  THU, JUL 31, 2025 4:00 AM CDT REQUEST EXTENSION

CammIMS16 4.E.001.

A linear programming computer package is needed.

The Westchester Chamber of Commerce periodically sponsors public service seminars and programs.
Currently, promotional plans are under way for this year’s program. Advertising alternatives include
television, radio, and online. Audience estimates, costs, and maximum media usage limitations are as
shown.

Constraint Television Radio Online

Audience per advertisement 400,000 72,000 160,000

Cost per advertisement $2,000 $300 $600

Maximum media usage 10 20 10

To ensure a balanced use of advertising media, radio advertisements must not exceed 50% of the total
number of advertisements authorized. In addition, television should account for at least 10% of the total
number of advertisements authorized.

(a) If the promotional budget is limited to $22,800, how many commercial messages should be run on
each medium to maximize total audience contact?

Television 6

Radio 3

Online 10

What is the allocation of the budget among the three media, and what is the total audience reached?

Television Budget 12,000

Radio Budget 900

Online Budget 6000

Total Audience 3936000

(b) By how much would audience contact increase if an extra $100 were allocated to the promotional
budget? (Round your answer to the nearest whole number.)

267

1. [2 / 8 Points]

DETAILS MY NOTES PREVIOUS ANSWERS ASK YOUR TEACHER

PRACTICE ANOTHER

CammIMS16 4.E.003.

A linear programming computer package is needed.

The employee credit union at State University is planning the allocation of funds for the coming year. The
credit union makes four types of loans to its members. In addition, the credit union invests in risk-free
securities to stabilize income. The various revenue-producing investments together with annual rates of
return are as follows.

Type of Loan/Investment Annual Rate of Return (%)

Automobile loans 9

Furniture loans 11

Other secured loans 12

Signature loans 13

Risk-free securities 10

The credit union will have $2,200,000 available for investment during the coming year. State laws and
credit union policies impose the following restrictions on the composition of the loans and investments.

Risk-free securities may not exceed 30% of the total funds available for investment.
Signature loans may not exceed 10% of the funds invested in all loans (automobile,
furniture, other secured, and signature loans).
Furniture loans plus other secured loans may not exceed the automobile loans.
Other secured loans plus signature loans may not exceed the funds invested in risk-free
securities.

How should the $2,200,000 be allocated to each of the loan/investment alternatives to maximize total
annual return?

Automobile loans $ 660000

Furniture loans $ 220000

Other secured loans $ 440000

Signature loans $ 220,000

Risk-free securities $ 660,000

What is the projected total annual return?

2. [0 / 6 Points]

DETAILS MY NOTES PREVIOUS ANSWERS ASK YOUR TEACHER

PRACTICE ANOTHER

$ 231,000

CammIMS16 4.E.005.

A linear programming computer package is needed.

Kilgore’s Deli is a small delicatessen located near a major university. Kilgore does a large walk-in carry-out
lunch business. The deli offers two luncheon chili specials, Wimpy and Dial 911. At the beginning of the day,
Kilgore needs to decide how much of each special to make (he always sells out of whatever he makes). The
profit on one serving of Wimpy is $0.44, on one serving of Dial 911, $0.57. Each serving of Wimpy requires
0.25 pound of beef, 0.25 cup of onions, and 5 ounces of Kilgore’s special sauce. Each serving of Dial 911
requires 0.25 pound of beef, 0.4 cup of onions, 2 ounces of Kilgore’s special sauce, and 5 ounces of hot
sauce. Today, Kilgore has 18 pounds of beef, 13 cups of onions, 86 ounces of Kilgore’s special sauce, and 58
ounces of hot sauce on hand.

(a) Develop a linear programming model that will tell Kilgore how many servings of Wimpy and Dial 911
to make in order to maximize his profit today. (Let W = the number of servings of Wimpy to make
and let D = the number of servings of Dial 911 to make.)

Max

s.t.
Beef

Onions

Special Sauce

Hot Sauce

(b) Find an optimal solution. (Round your answers to two decimal places.)

3. [– / 14 Points]

DETAILS MY NOTES ASK YOUR TEACHER PRACTICE ANOTHER

W, D ≥ 0

Profit = $

(c) What is the dual value for special sauce? (Round your answer to two decimal places.)

$

Interpret the dual value.

For every 1 ounce increase in —Select— , the profit will —Select— by $ .

(d) Increase the amount of special sauce available by 1 ounce and re-solve. (Round your answers to two
decimal places.)

Profit = $

Does the solution confirm the answer to part (c)?

Yes

No

(W, D) =

(W, D) =

CammIMS16 4.E.007.

A linear programming computer package is needed.

As part of the settlement for a class action lawsuit, Hoxworth Corporation must provide sufficient cash to
make the following annual payments (in thousands of dollars).

Year 1 2 3 4 5 6

Payment 200 225 250 295 325 470

The annual payments must be made at the beginning of each year. The judge will approve an amount that,
along with earnings on its investment, will cover the annual payments. Investment of the funds will be
limited to savings (at 4% annually) and government securities, at prices and rates currently quoted in The
Wall Street Journal.

Hoxworth wants to develop a plan for making the annual payments by investing in the following securities
(par value = $1,000). Funds not invested in these securities will be placed in savings.

Security Current Price Rate (%) Years to Maturity

1 $1,055 6.750 3

2 $1,000 5.125 4

Assume that interest is paid annually. The plan will be submitted to the judge and, if approved, Hoxworth
will be required to pay a trustee the amount that will be required to fund the plan.

(a) Use linear programming to find the minimum cash settlement necessary (in $) to fund the annual
payments. (Round your answer to the nearest dollar.)

$

(b) Use the dual value to determine how much more (in $) Hoxworth should be willing to pay now to
reduce the payment at the beginning of year 6 to $400,000. (Round your answer to the nearest
dollar.)

$

(c) Use the dual value to determine how much more (in $) Hoxworth should be willing to pay to reduce
the year 1 payment to $150,000. (Round your answer to the nearest dollar.)

$

(d) Suppose that the annual payments are to be made at the end of each year. Reformulate the model to
accommodate this change. How much would Hoxworth save (in $) if this change could be negotiated?

4. [– / 4 Points]

DETAILS MY NOTES ASK YOUR TEACHER PRACTICE ANOTHER

(Round your answer to the nearest dollar.)

$

CammIMS16 4.E.009.

A linear programming computer package is needed.

Epsilon Airlines services predominately the eastern and southeastern United States. A vast majority of
Epsilon’s customers make reservations through Epsilon’s website, but a small percentage of customers
make reservations via phone. Epsilon employs call-center personnel to handle these reservations along with
any problems with the website reservation system and for the rebooking of flights for customers if their
plans change or their travel is disrupted. Staffing the call center appropriately is a challenge for Epsilon’s
management team. Having too many employees on hand is a waste of money, but having too few results in
very poor customer service and the potential loss of customers.

Epsilon analysts have estimated the minimum number of call-center employees needed by day of week for
the upcoming vacation season (June, July, and the first two weeks of August). These estimates are given in
the following table.

Day
Minimum Number of
Employees Needed

Monday 85

Tuesday 60

Wednesday 55

Thursday 75

Friday 105

Saturday 85

Sunday 55

The call-center employees work five consecutive days and then have two consecutive days off. An employee
may start work any day of the week. Each call-center employee receives the same salary. Assume that the
schedule cycles and ignore start-up and stopping of the schedule. Develop a model that will minimize the
total number of call-center employees needed to meet the minimum requirements. (Let = the number of
call-center employees who start work on day i where etc).

Min

5. [– / 10 Points]

DETAILS MY NOTES ASK YOUR TEACHER PRACTICE ANOTHER

Xi
i = 1 = Monday, i = 2 = Tuesday,

s.t.
Monday

Tuesday

Wednesday

Thursday

Friday

Saturday

Sunday

Find the optimal solution.

X , X , X , X , X , X , X ≥ 01 2 3 4 5 6 7

Give the number of call-center employees that exceed the minimum required.

(X , X , X , X , X , X , X ) =

1 2 3 4 5 6 7

(M, Tu, W, Th, F, Sa, Su) =

CammIMS16 4.E.011.

A linear programming computer package is needed.

Edwards Manufacturing Company purchases two component parts from three different suppliers. The
suppliers have limited capacity, and no one supplier can meet all the company’s needs. In addition, the
suppliers charge different prices for the components. Component price data (in price per unit) are as
follows.

Component
Supplier

1 2 3

1 $13 $14 $15

2 $11 $12 $11

Each supplier has a limited capacity in terms of the total number of components it can supply. However, as
long as Edwards provides sufficient advance orders, each supplier can devote its capacity to component 1,
component 2, or any combination of the two components, if the total number of units ordered is within its
capacity. Supplier capacities are as follows.

Supplier 1 2 3

Capacity 700 1,100 900

(a) If the Edwards production plan for the next period includes 1,100 units of component 1 and 900 units
of component 2, what purchases do you recommend? That is, how many units of each component
should be ordered from each supplier?

Component 1, Supplier 1 units

Component 1, Supplier 2 units

Component 1, Supplier 3 units

Component 2, Supplier 1 units

Component 2, Supplier 2 units

Component 2, Supplier 3 units

(b) What is the total purchase cost (in $) for the components?

$

6. [– / 7 Points]

DETAILS MY NOTES ASK YOUR TEACHER PRACTICE ANOTHER

CammIMS16 4.E.017.

A linear programming computer package is needed.

Frandec Company manufactures, assembles, and rebuilds material-handling equipment used in warehouses
and distribution centers. One product, called a Liftmaster, is assembled from four components: a frame, a
motor, two supports, and a metal strap. Frandec’s production schedule calls for 4,500 Liftmasters to be
made next month. Frandec purchases the motors from an outside supplier, but the frames, supports, and
straps may be either manufactured by the company or purchased from an outside supplier. Manufacturing
and purchase costs per unit are shown.

Component Manufacturing Cost Purchase Cost

Frame $39.00 $52.00

Support $12.50 $16.00

Strap $7.50 $8.50

Three departments are involved in the production of these components. The time (in minutes per unit)
required to process each component in each department and the available capacity (in hours) for the three
departments are as follows.

Component
Department

Cutting Milling Shaping

Frame 3.5 2.2 3.1

Support 1.3 1.7 2.6

Strap 0.8 — 1.7

Capacity (hours) 350 420 680

(a) Formulate and solve a linear programming model for this make-or-buy application. (Let FM = number
of frames manufactured, FP = number of frames purchased, SM = number of supports manufactured,
SP = number of supports purchased, TM = number of straps manufactured, and TP = number of
straps purchased. Express time in minutes per unit.)

Min

7. [– / 16 Points]

DETAILS MY NOTES ASK YOUR TEACHER PRACTICE ANOTHER

Cutting constraint

Milling constraint

Shaping constraint

Frame constraint

Support constraint

Strap constraint

How many of each component should be manufactured and how many should be purchased? (Round
your answers to the nearest whole number.)

(FM, FP, SM, SP, TM, TP) =

(b) What is the total cost (in $) of the manufacturing and purchasing plan?

$

FM, FP, SM, SP, TM, TP ≥ 0

(c) How many hours of production time are used in each department? (Round your answers to two
decimal places.)

Cutting hrs

Milling hrs

Shaping hrs

(d) How much (in $) should Frandec be willing to pay for an additional hour of time in the shaping
department?

$

(e) Another manufacturer has offered to sell frames to Frandec for $45 each. Could Frandec improve its
position by pursuing this opportunity? Why or why not? (Round your answer to three decimal places.)

—Select— . From the results of the model in part (a), the variable FP has a reduced cost of
, which indicates that the solution —Select— be improved if the purchase cost of

frames can be lowered to $45 each.

CammIMS16 5.E.007.

A linear programming computer package is needed.

Hanson Inn is a 96-room hotel located near the airport and convention center in Louisville, Kentucky. When
a convention or a special event is in town, Hanson increases its normal room rates and takes reservations
based on a revenue management system. A large profesional organization has scheduled its annual
convention in Louisville for the first weekend in June. Hanson Inn agreed to make at least 50% of its rooms
available for convention attendees at a special convention rate in order to be listed as a recommended hotel
for the convention. Although the majority of attendees at the annual meeting typically request a Friday and
Saturday two-night package, some attendees may select a Friday night only or a Saturday night only
reservation. Customers not attending the convention may also request a Friday and Saturday two-night
package, or make a Friday night only or Saturday night only reservation. Thus, six types of reservations are
possible: Convention customers/two-night package; convention customers/Friday night only; convention
customers/Saturday night only; regular customers/two-night package; regular customers/Friday night only;
and regular customers/Saturday night only. The cost for each type of reservation is shown below.

Two-Night
Package

Friday Night
Only

Saturday Night
Only

Convention $225 $123 $130

Regular $295 $146 $152

The anticipated demand for each type of reservation is as follows.

Two-Night
Package

Friday Night
Only

Saturday Night
Only

Convention 40 20 15

Regular 20 30 25

Hanson Inn would like to determine how many rooms to make available for each type of reservation in
order to maximize total revenue.

(a) Formulate a linear programming model for this revenue management application. (Let CT = number
of convention two-night rooms, CF = number of convention Friday only rooms, CS = number of
convention Saturday only rooms, RT = number of regular two-night rooms, RF = number of regular
Friday only rooms, RS = number of regular Saturday only rooms.)

Max

8. [– / 19 Points] DETAILS MY NOTES ASK YOUR TEACHER

s.t.
anticipated demand for convention two-night rooms

anticipated demand for convention Friday night only rooms

anticipated demand for convention Saturday night only rooms

anticipated demand for regular two-night rooms

anticipated demand for regular Friday night only rooms

anticipated demand for regular Saturday night only rooms

Friday night rooms available for convention attendees only

Saturday night rooms available for convention attendees only

total rooms available for Friday night

total rooms available for Saturday night

(b) What is the optimal allocation?

CT =

CF =

CS =

RT =

RF =

RS =

From this allocation, what is the anticipated total revenue (in dollars)?

$

(c) Suppose that one week before the convention the number of regular customers/Saturday night only
rooms that were made available sell out. If another nonconvention customer calls and requests a
Saturday night only room, what is the value (in dollars) of accepting this additional reservation?

If the hotel accepts this additional reservation, then the total profit would increase by
$ .

Home My Assignments Request Extension

Copyright © 1998 – 2025 Cengage Learning, Inc. All Rights Reserved TERMS OF USE PRIVACY

CT, CF, CS, RT, RF, RS ≥ 0

Share This Post

Email
WhatsApp
Facebook
Twitter
LinkedIn
Pinterest
Reddit

Order a Similar Paper and get 15% Discount on your First Order

Related Questions

MGMT 410

SEE ATTACHMENTS This week, you are required to submit a company evaluation. Your paper analysis should be between 3 – 5 pages, not counting the title and reference page. No submission should be fewer than 1050 words. Include a clear and concise introduction. Format your paper so that the three

Capstone Assessment Minimum Lifestyle on Minimum Wage

Introduction: For many of us our first job consists of an entry level, minimum wage job. This type of job is great for spending money, but could we support ourselves? What does it look like to live by ourselves, pay all our own bills, and supply our own needs? In

7-2 Final Project (Ethical & Legal)

Overview Healthcare institutions are responsible for the quality of care that is provided within their settings. Institutions need to ensure that the healthcare professionals they employ have a strong working knowledge of ethics and law to be competent and successful. A qualified professional knows how to provide safe, quality healthcare

Statistical Analysis I

Must follow instructions and grading Rubic!! Module 7 Assessment.html Submit your complete assignment by clicking the blue submit button at the bottom of the page. We recommend that you submit your work on Sunday of the week that you start the module. HOMEWORK Assignment Instructions Mini- Study Part II Answer

Statistical Analysis I

Must follow Grading Rubic!! Module 4 Assessment.html Submit your complete assignment by clicking the blue submit button at the bottom of the page. We recommend that you submit your work on Sunday of the week that you start the module. HOMEWORK Assignment Instructions Mini- Study Part I In this course

Business Communication

Communication Strategies Assessment Code and Task RRM3 Multimedia Proposal Potential D268 Task 3 Topics PAGE 1 PAGE 2 Potential D268 Task 3 Topics General: · workplace unions · neighborhood parks · neighborhood watch association Teachers: · technology upgrades · yearly classroom spending allowance · free after-school programs Information Technology: ·

Do you wish to show your own style with the beauty of Flower Jewelry?

 Enter a world of natural elegance of hand decoration Flower Jewelry, where the story is beauty and grace. Flower jewelry is inspired by nature, the finest details of floral petals, bringing together the old-fashioned and modern design elements. These pieces of jewelry made of flowers can be a vibrant floral

wk8rep

see attached Review the 2 Peer answers: Cite Scholarly Authors, in APA formate * Find an Executive Overview, posted by a classmate, for which you did not entirely understand the conclusions and one strategic direction for the company and one that you completely agreed with. * Ask a question or

Week VIII

See attached This journal measures your mastery of ULOs 2.8, 2.9, and 4.2.  ABC Corporation has 3 plants across the United States in 3 different regions consisting of East, Central, and West. Last year, each plant purchased new equipment for their plants, and each plant earns the same income of

Business Finance – Operations Management Week 7 assignment

This assignment should reflect 2 weeks’ worth of work. For this assignment, the business analyst tools Microsoft Excel, Survey Monkey, draw tools, decision trees, chart of KPIs, SWOT analysis, 10k annual reports, PADIO, and EQ will accompany your paper. Criteria: The final report on the Course Project will support the

Unit III Es

see attachment This 3-to-5-page essay measures your mastery of ULOs 1.1, 1.2, 2.1, 6.1, 6.2, and 7.1. Elasticity Assignment objective: Unit I introduced the benefits of markets to improving outcomes for producers and consumers. Unit II examined the role of costs and prices in decision-making. For this assignment, you will

Successful Leadership

   Select a book about a specific leader who demonstrates successful leadership as a vocation. 

What is Juti

 Juti for women is a specific initiative aimed at empowering women in the workplace by offering tailored AI-driven solutions. It focuses on creating a more inclusive environment where women can excel in their careers through personalized tools, mentorship opportunities, and career growth pathways. By providing accessible technology and support, Juti

MGMT 410

SEE ATTACHMENT 250-300 WORDS ANWERING THE FOLLOWING QUESTION 1. What is the FAIR cycle regarding performance? Explain each of the four elements.

MGMT 314

SEE ATTACHMENT 250-300 WORDS ANSWERING THE FOLLOWING QUESTIONS 1. What are a few of the types of social responsibilities that businesses have? How might different types of leaders view the importance of socially responsible programs? 2. Discuss a few of the ethical pros of implementing social responsibility programs in organizations.

Real-World Financial Statement Analysis

SEE THE ATTACHED FOR INSTRUCTIONS AND DETAILS YES WE HAVE TO DISCUSS TERMS DUE SEPTEMBER 27 Additional resources: This final assignment will consist of two parts. Note that you will have two attachments to Waypoint to complete this assignment in full. You can refer to Summary vs. Analysis. to understand