Fill in order details

  • Submit your instructions
    to writers for free!

Chat with the writer

  • Chat with preferred expert writers
  • Request a preview of your paper
    from them for free


  • Project edited by the quality evaluation department

Download Your Completed Project

  • Download the completed project from your account or have it sent to your email address

NatBike is a bicycle manufacturer. Its customer demand curve

MS5313 Homework 1: Optimization Models


  1. There are 4 questions. For each question, please present the mathematical formulation and the final solution in this word document; submit it together with your complete Excel file, containing the solver setup and solution.
  2. Online submission at Canvas by 11:30pm Oct. 3rd 2018(Wed).Unlimited trials (upload) are allowed before the deadline; only the latest version will be graded.

Question 1 (Revenue management):

NatBike is a bicycle manufacturer. Its customer demand curve is: d=15,000-10P, where P denotes the selling price and d denotes the total demand.  Assume that the cost of manufacturing each bicycle is $200.

1.1. If NatBike charges a same price to all customers, what price should NatBike charge? What is the total profit?

1.2. If NatBike identifies two customer segments:

  1. a) one that prefers a customized bicycle and is willing to pay a higher price, and
  2. b) another that is willing to take a standardized bicycle.

Assume that the cost of manufacturing either bicycle is the same ($200).

If NatBike may charge different prices to different customer segments, what price should NatBike charge each segment? What is the total profit?

1.3. Redo question 2, with additional condition that the total bicycle supply is no more than 8000 units.

Question 2 (Advertising budget allocation):

A firm has a $1,000,000 budget per year to be allocated among three mediums. The goal is to reach the largest high-potential audiences.The audience reached per advertising (AD), cost per AD, and maximum AD allowed per year is shown in the table below. Furthermore, the firm requires that at least 100days of advertising on social media platforms be placed per year.

2.1. How many units of advertising should the firm allocate to each medium and what is the maximum number of audiences reached?

2.2. After you solve the problem, identify which constraints are binding and non-binding, and what their corresponding shadow prices are.

Medium Audience reached per AD Cost Per AD Max Ads per year
TV (1min) 5000 8000 50
Daily newspaper

(full page)

8500 9250 30
Social media platforms (1day) 6400 5000 150

Question 3 (Farm management)

A farmer can plant up to 80 acres of land with wheat and corn. He can earn $5,000 for every acre he plants with wheat and $3,000 for every acre he plants with corn. His use of a necessary pesticide is limited by government regulations to 100 gallons for his entire 80 acres. Wheat requires 2 gallons of pesticide for every acre planted and corn requires just 1 gallon per acre. How should the farmer optimally allocate farm land to wheat and corn and what is the maximum profit he can make?

Question 4 (Staffing problem)

A bus company launches a new line which will provide service 24 hours. There are 6 shifts, starting from 0am, 4am, 8am, 12pm, 4pm and 8pm, respectively. Each staff is supposed to continuouslywork exactly two shifts (total 8 hours). The minimum number of staffs needed for each shift is shown in the table below. The number of staffs to hire for each shift must be an integer number. What is the bus company’s optimal hiring plan in order to minimize the total number of staffs?

Shift No. 1 2 3 4 5 6
Starting time 0am 4am 8am 12pm 4pm 8pm
Minimum No. of StaffNeeded 60 70 50 60 20 30

Place your order now for the similar assignment and get fast, cheap and best quality work written by our expert level  assignment writers.NatBike is a bicycle manufacturer. Its customer demand curve is: d=15,000-10P, where P denotes the selling price and d denotes the total demand.  Assume that the cost of manufacturing each bicycle is $200.

Use Coupon Code: NEW30 to Get 30% OFF Your First Order

Answered Questions:

ANSWERED!! Lily is a 20-year-old student at

ANSWERED!! What details did the patient provide regarding their chief complaint and symptomology to derive your differential diagnosis? What is the duration and severity of their symptoms?

ANSWERED!! Select a family other than your own and seek permission from the family to conduct an interview. Utilize the interview questions complied in your interview questionnaire

ANSWERED!! In 4 or 5 sentences describe the anatomy of the basic unit of the nervous system

ANSWERED!! Describe measures that you would take as a nurse to assist clients with health promotion measures to incorporate exercise and physical activity into their lives

ANSWERED!! Assess the characteristics of the medical care culture that encourage the latter approach.

ANSWERED!! Identify two things that surprised you about the results and one idea you believed prior to conducting the Assessment that was confirmed.

What our customers say

Ishita M.Ishita M.
Great Job! Thank you so much for your work. You got it done faster than I imagined and everything is perfect. Will definitely be using you again!
Megan J.Megan J.
"As a wife, mother, and full-time student, I was struggling to try to go back to school and take care of my responsibilities. Sometimes you just need a little help, and I appreciate all the help I have gotten from Academic Research Bureau. My papers are on-time and the writers are easy to work with. Thanks for the support!"
Rajab M.Rajab M. has saved me a lot of time. I was tired of taking the same classes many times over again. As an ESL student, my professors were taking points off of my assignments for my grammar mistakes. It made it very hard to feel encouraged to continue with my studies. Thankful for having found an answer for better grades."
Frank N.Frank N.
As a working student, I just really don't have the time to write paper after paper and complete assignment after assignment. Working full-time and going to school was nearly impossible until I was able to feel comfortable with the writers on this site. They make me feel secure enough to trust them with my papers. While I'm busy with life, they are busy writing my papers. They always do an outstanding job!
Courtney B.Courtney B.
Thank you! You were really patient with me and my needs. This was my first time using you guys, however, I will definitely be using you again!
John H.John H.
I cannot tell you enough how amazing your company is! Your writers are superb, on time, excellent content, so very thankful you reached out to me that day! Lifesaver for sure! Couldn’t be happier with the results I’ve gotten from my first 2 papers with you, I have 4 papers left to go and I’ll be using your company for them all!
Rebecca T.Rebecca T.
After I ordered a dissertation from your writing service, the first paper that I was given did not met my professor’s demand. I set the paper on revision and the writer made the revision for free meeting all my requirements and I was very satisfied
Thomas R.Thomas R.
I was shocked by how your writers managed to deliver my paper on time, and I was among the best in our class in that paper. Thank you so much and I will never hesitate to use you
error: protected!!