Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Hi can some one help me two question and show work on excel, please show on excel calculation. I need it by 12 pm today

image text in transcribed

Hi can some one help me two question and show work on excel, please show on excel calculation. I need it by 12 pm today (3 hrs left from now)

image text in transcribed 1/. Juki Mara is Dallas based company specializing in climate-controlled pet houses. According to the company's VP of Operations, their market segments basically compromise of high-end customers who are either dog or cat owners and who want to pamper their pets. To reach these groups of dog and cat owners, the VP of Operations is considering placing one-minute commercials on the following national TV shows: \"Houston Dog and Cat Show\" and \"Texan's Best Friend\". A one-minute commercial on \"Houston Dog and Cat Show\" costs $200,000, and a one-minute commercial on \"Texan's Best Friend\" costs $50,000. The VP would like the commercials to be seen by at least 60 million high-income dog and at least 36 million high-income cat owners. Marketing studies show the following: -Each one-minute commercial on \"Houston Dog and Cat Show\" is seen by six million high-income dog and two million high-income cat owners. -Each one-minute commercial on \"Texan's Best Friend\" is seen by three million high-income dog and three million high-income cat owners. Formulate LP problem (constraints and objective functions) for Juki Mara that minimizes objective function Solve the LP problem that minimizes the marketing expenditure 2/ Car Wash Intl. is considering four possible sites for its new operation in Houston area. In the past three years, they had witnessed growth in demand for car washes from 2 thousand vehicles a year, to 6 thousand. With a purchase of new automated machine, they expect to wash 10,000 vehicles. Based on the information provided below, use break even analysis (15 points), plot break-even graph with breakeven points (15 points), and recommend best location for different range of demands for vehicle cleaning (5 points). Location Pearland(A) SUGARLAND(B0 WOODLAND Katy(D) Fixed Cost ($) 350,0 00 170,0 00 100,0 00 250,0 00 Variable Cost($) 5 25 40 20

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

International Business The Challenges Of Globalization

Authors: John J. Wild, Kenneth L. Wild

9th Edition

0134729226, 978-0134729220

More Books

Students also viewed these Finance questions