# Linear Programming Model Excel Solution Module 3 Complete Worksheet P3 12 P3 22 P3 18 Answer

Problem 3-12

Haven’t Found The Relevant Content? Hire a Subject Expert to Help You With
Linear Programming Model Excel Solution Module 3 Complete Worksheet P3 12 P3 22 P3 18 Answer

Advertising Medium Cost minimum Maximum Bumper stickers (thousands) \$30.00 40 100 Personal mailings (hundreds) \$81.00 500 800 Radio ads (per day) \$1,000.00 3 12 Small road side signs \$25.00 100 500 Large road side signs \$60.00 50 300

Problem 3-22

The load master for a freighter wants to determin the mix of cargo to be carried on the next trip.The ship’s volume limit for cargo is 100,000 cubic meters , and its weight capacity is 2,310 tons.The master has five different types of cargo from which to select and wishes to maximize the calue of the selected shipment. However, to make sure that none of his customers are ignored, the load master would like to make sure that at least 20% of each cargo’s available weight is selected. The specifications for the five cargoes are shown in the following table

cargo type Tons Available Value Per Ton Volume Per TONE A 970 \$1,350.00 26 B 850 \$1,675.00 54 C 1900 \$1,145.00 28 D 2300 \$850.00 45 E 3600 \$1,340.00 37

A nursing home employs attendants who are needed around the clock. Each attendant is paid the same, regardless of when his or her shift begins. Each shift is 8 consecutive hours. Shifts begin at 6 A.M., 10 A.M., 2 P.M., 6 P.M., 10 P.M., and 2 A.M. The following table showws the nursing home’s requirements for the numbers of attendants to be on duty during specifiv time periods

Problem 3-18

SHIFT TIME NUMBER OF ATTENDANTS A 2-6 A.M. 8 B 6-10 A.M. 27 C 10 A.M – 2 P.M. 12 D 2-6 P.M. 23 E 6-10 P.M. 29 F 10 P.M. – 2 A.M. 23

(a) What is the minimum number of attendants needed to satisfy the nursing home’s requirements? (b) the nursing home would like to use the same number of attendants determined in part (a) but would like to minimize the total salary paid. Attendants are paid \$16 per hour during 8 A.M.- 8 P.M.,and a 25% premium per hour during 8 P.M. – 8 A.M. How should the attendants now be scheduled?

## Calculate the price of your order

Select your paper details and see how much our professional writing services will cost.

We`ll send you the first draft for approval by at
Price: \$36
• Freebies
• Format
• Formatting (MLA, APA, Chicago, custom, etc.)
• Title page & bibliography
• Amendments to your paper when they are needed
• 275 word/double-spaced page
• 12 point Arial/Times New Roman
• Double, single, and custom spacing

Our custom human-written papers from top essay writers are always free from plagiarism.

Your data and payment info stay secured every time you get our help from an essay writer.

Your money is safe with us. If your plans change, you can get it sent back to your card.

## How it works

1. 1
You give us the details
Complete a brief order form to tell us what kind of paper you need.
2. 2
We find you a top writer
One of the best experts in your discipline starts working on your essay.
3. 3
You get the paper done

## Samples from our advanced writers

Check out some essay pieces from our best essay writers before your place an order. They will help you better understand what our service can do for you.

## Perks of our essay writing service

We offer more than just hand-crafted papers customized for you. Here are more of our greatest perks.

• Swift delivery
Our writing service can deliver your short and urgent papers in just 4 hours!
• Professional touch
We find you a pro writer who knows all the ins and outs of your subject.
• Easy order placing/tracking
Create a new order and check on its progress at any time in your dashboard.
• Help with any kind of paper
Need a PhD thesis, research project, or a two-page essay? For you, we can do it all.
• Experts in 80+ subjects
• Calculations and code
We also do math, write code, and solve problems in 30+ STEM disciplines.

• ### What if I’m dissatisfied with the paper I get?

The average quality score at our professional custom essay writing service is 8.5 out of 10. The high satisfaction rate is set by our Quality Control Department, which checks all papers before submission. The final check includes:
• Compliance with initial order details.
• Plagiarism.
• Proper referencing.
If for some reason we happen to leave a mistake unnoticed, you are invited to request unlimited revisions of your custom-written paper. For more information, check our Revision Policy. We will do our best to make your experience with Familiar Essays enjoyable.
• ### I need an essay on the same day. Is it something you can do?

Sure. Our writing company offers a fast service with an 8-hour deadline for orders up to master’s level. Make sure to specify the deadline in the order form and our writers will write a paper within the indicated timeslot. Just proceed to submit your requirements here Once you order a custom-written essay, our managers will assign your order to the well-suited writer, who has the best skills and experience for preparing your specific assignment. You can also request one of these extra features:
• Choose the Writer’s Samples option – study 3 randomly-provided pages from orders that have been written by the assigned writer.
• Request a specific writer – choose an academic writer from the dropdown list in the order’s form (optional for returning customers).
You can be sure that your custom writing order will be accomplished by one of our 400+ professional academic writers. They all pass a series of tests to prove their writing prowess and hold the reputation of being the most professional in the industry. Want to make sure writer’s skills match your needs? Get more details on how to choose the appropriate author.
• ### How can I be sure your writing service is not a scam?

We understand that a shade of mistrust has covered the paper writing industry, and we want to convince you of our loyalty. Apart from high-quality writing services, we offer:
• The chances of students to boost writing skills in a quick and effective way.
• The opportunity to manage studies and free time in an enjoyable manner.
• The possibilities to improve overall academic performance.
Our custom writing company has been working for more than 12 years and always puts quality and clients’ needs first. Our operations are legally documented, we are easily accessible online and offline,
• ### Is it legal to use your professional writing service?

Yes. Custom writing help is not prohibited by any university or college. It’s a 100% legal way of getting professional assistance with paper writing. Hiring writers from an essay writing company is in many ways similar to consulting a tutor – we help you solve the writing issues at hand.