Use Excel with solver and show formulas 5. The police chief of Thidwick City, ho

Question

Use Excel with solver and show formulas

5. The police chief of Thidwick City, home of Tidwick State University, is trying to develop a schedule for patrol officers for Thursday, Friday, Saturday, and Sunday of each week. Heir full-time officers work 8-hour shifts and her part-time officers only 4-hour shifts. She divides each day into six four-hour time buckets and has developed forecasts for needed officers for each time bucket. This information is given in the table below Formulate and solve a math optimization model which will Minimize the total number of officers employed in the four-day window Make certain in each time bucket there are at least twice as many full-time officers on duty as part-time officers. Make certain in each time bucket that part-time officers make up no less than 20% of patrolling officers a. b. C. Officers Needed in Each Time Bucket Thursda 35 20 50 35 Saturda 65 35 20 35 20 50 T1 Sun 00:00 - 04:00 04:00-08:00 08:00 - 12:00 12:00 -16:00 16:00- 20:00 20:00- 00:00 75 45 15 25 35 35 25 50 35 40 50 Note: This formulation will be larger than any other in this problem set. Though there can be several ways of building the formulation, when your professor formulated the model for this problem it had 48 variables and 72 constraints

Explanation / Answer

Hi,

Thanks for the question.

4 P's define the marketing strategy for any company or for a particular brand. This is the strategy to reach and market the product to the customers.

The 4 P's will be:

Product: As mentioned, the product for this particular scenario will be McChicken and Big Mac.
Price: Price generally should be according to the perception of the customers to see its worth. They should consider to price the product moderately not on a low price because that would give the feel as the quality compromised.
Place: That should be very evenly distributed across the outlets in the US. The product will be very popular so the company should be very efficient in the distribution.
Promotions: Mcdonald's is very aggressive in terms of the advertising mostly in the Tv advertisement or OOH branding.

Related Questions

Navigate

• Browse (All)
• Browse U
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.