Answered step by step
Verified Expert Solution
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
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 20Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started