An ad campaign for a new snack chip will be conducted in a limited geographical area and can use TV time, radio time, and newspaper ads. Information about each medium is shown below. If the number of TV ads cannot exceed the number of radio ads by more than 4, and if the advertising budget is $10000, develop the LP model that will maximize the number reached and achieve an exposure quality if at least 1000. Create the LP in Tab # 12 Medium Cost Per Ad # Reached Exposure Quality TV 500 10000 30 Radio 200 3000 40 Newspaper 400 5000 25 I am requesting the answer back using excel and data solver step by step answers

An ad campaign for a new snack chip will be conducted in a limited geographical area and can use TV time, radio time, and newspaper ads. Information about each medium is shown below. If the number of TV ads cannot exceed the number of radio ads by more than 4, and if the advertising budget is $10000, develop the LP model that will maximize the number reached and achieve an exposure quality if at least 1000. Create the LP in Tab # 12 Medium Cost Per Ad # Reached Exposure Quality TV 500 10000 30 Radio 200 3000 40 Newspaper 400 5000 25 I am requesting the answer back using excel and data solver step by step answers

FINANCIAL ACCOUNTING

10th Edition

ISBN:9781259964947

Author:Libby

Publisher:Libby

Chapter1: Financial Statements And Business Decisions

Section: Chapter Questions

Problem 1Q

See similar textbooks

Similar questions

An urban transit holds 4000 passengers daily in a big city. The price to ride the transit is $1.50 a person. The CEO realizes that 100 less people ride the bus for each 0.25 increase in price, and 100 more people ride for each $0.25 decrease in price. If the transit can hold 5000 people, what should be the price to produce most revenue possible? Need to state interval. (Business revenue optimization, need equation and test values with test the values, etc and if possible an interval or boundary. I believe a therefore sentence is also required. Didnt use any fancy math methods)
A multimodal logit mode choice model is calibrated for 10, 000 persons. The resulting utility function is given below: U = a – 0.015C – 0.03T Where: C – out – of - pocket cost, pesos T - Travel time, min a = -0.25 for cars, -0.33 for aircon bus, and 0.40 for jeepney %3D For a particular OD pair, three modes are available, with charactersitics as follows: Travel time, Ave. occupancy Out-of-pocket cost, pesos 50 Mode person/veh 2 min 30 Car 10 45 40 Aircon Bus 5 50 14 Jeepney Determine the following: Percentage share of each mode. No. of vehicles of each mode. 2.
A furniture's store is considering tow marketing strategies: a loyalty program that would cost $3,000 and increase revenue by $15,000, or a seasonal sale that would cost $5,000 and increase revenue by $25,000. The store's contribution margin is 30%. Which strategy should they pursue if the goal is to maximize ROMI? What about if the goal is to maximize revenue growth?
Please answer it as soon as possible! Thank you!
The cost of introducing the products in selected geographic areas for gauging consumer response is $150K. If the company decides to introduce the product this way, it would need to see the responses to the products before they decide to launch the product line nationally. The probability of a favorable response in the selected geographical areas is estimated at O.60. La Comida can also decide not to go for the launching in the product in selected geographical areas and go ahead with the nationwide launch or not. If La Comida Foods decides to go full-blast in launching the products nationally and are a success, the company estimates that they will gain an annual income of $1.6 million. If the products are not a hit, the company will realize losses to the tune of $700K. La Comida estimates the probability of success for the sauces and marinades to be 0.50, if these are introduced without gauging consumer response.
Q.1 ChemCo has developed a new product, and has consulted with its marketing department, who have determined that the market share will be 20,000 units, and have recommended that a selling price of $60.00 per unit would be app- ropriate. ChemCo has been able to keep the cost per unit at $50.00. The company has spent a total of $900,000 to design and develop this product. Required: Use the above information to compute as follows: 1. Compute the expected margin for ChemCo 2. Compute the expected turnover 3. Compute the ROI Explain why it is necessary to do the above computations, and show how management can use this information for managing operations
Mesa Cheese Company has developed a new cheese slicer called Slim Slicer. The company plans to sell this slicer through its online website. Given market research, Mesa believes that it can charge $20 for the Slim Slicer. Prototypes of the Slim Slicer, however, are costing $22. By using cheaper materials and gaining efficiencies in mass production, Mesa believes it can reduce Slim Slicer's cost substantially. Mesa wishes to earn a return of 40% of the selling price. (b) When is target costing particularly helpful in deciding whether to produce a given product?
Refer to the original data ($30 ticket price per person). Prepare a Cost –Volume – Price (CVP) graph for the Extravaganza from a zero level of activity up to 600 tickets sold. Number of persons should be placed on the horizontal (X) axis, and dollars should be placed on the vertical (Y) axis4. Write two pros and two cons associated with the use of the Break even analysis as a planning tool.
Gamin Inc. produces various GPS devices with a wide assortment of different models for its customers. One item, RC1 is very popular. Keen of keeping its stock under control, a decision is taken to order only the optimum economic quantity, for this item, each time. You have the following information. Annual demand (units) 115,200 Purchase price per unit $ 300 Carrying/Holding costs per unit $ 8 Cost per order $ 200 Required: Determine the EOQ using the equation method. Fill the blanks in the following table using the above data. No. of orders 1 10 20 30 90 120 Order size Average stock Carrying (Holding) costs Order costs Total costs Calculate the holding, ordering cost & their total cost at the EOQ level. Plot the graph at the EOQ level showing the…
Whitmore Glassware makes a variety of drinking glasses and mugs. The company's designers have discovered a market for a 16 ounce mug with college logos. Market research indicates that a mug like this would sell well in the market priced at $26.65. Whitmore only introduces a product if they can an operating profit of 30 percent of costs. Required: What is the highest acceptable manufacturing cost for which Whitmore would be willing to produce the mugs? (Round your answer to 2 decimal places.) Highest acceptable manufacturing costs