Question: 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

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)

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
Get step-by-step solutions from verified subject matter experts
