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

Can you please reveiw and answer questions 1-3?  Thank you.

What is the highest acceptable manufacturing cost for hwich Domingo would be willing to produce the headphones?

Ortega Company manufactures computer hard drives. The market for hard drives is very competitive. The current market price for a computer hard drive is $54. Ortega would like a profit of $14 per drive. What target cost Ortega should set to accomplish this objective? Target cost $ per hard drive

Red Grass Company produces high definition television sets. The following information is available for this product: Fixed cost per unit $250 Variable cost per unit $750 Total cost per unit $1,000 Desired ROI per unit 30 % The target selling price for this television is Group of answer choices $550. $1,000. $1,050. $1,300.

I need help figuring out how the Break Even units. You have conducted some market research for style and size of products you want to use to launch your business. The market research has indicated the following sales price ranges will be optimal for your area depending on style of products you choose to sell: ● Collars o With pricing at $20 per collar, you can expect to sell 30 collars per day. o With pricing at $24 per collar, you can expect to sell 25 collars per day. o With pricing at $28 per collar, you can expect to sell 20 collars per day ● Leashes o With pricing at $22 per leash, you can expect to sell 28 leashes per day. o With pricing at $26 per leash, you can expect to sell 23 leashes per day. o With pricing at $30 per leash, you can expect to sell 18 leashes per day. ● Harnesses o With pricing at $25 per harness, you can expect to sell 25 harnesses per day. o With pricing at $30 per harness, you can expect to sell 22 harnesses per day. o With pricing at $35 per harness, you…

Sheen Co. manufactures a standard cabinet for a Blu-ray player. The variable cost per unit is $16. The fixed cost per unit is $9. The desired ROI per unit is $6. Compute the markup percentage on total unit cost and the target selling price for the cabinet.

International Paper is trying to find the best paper rolling machine to maximize sales volume. There are three machine options: Machine A, Machine B, and Machine C. Annual revenue is expected to be at one of three possible levels, High, $6 million; Medium, $3 million; or Low, $2 million; but is impacted by machine selection as the probabilities show in the table below: High Revenue Medium Revenue Low Revenue Machine A .1 .3 .6 Machine B .4 .4 .2 Machine C .5 .4 .1 Which machine should International Paper purchase to maximize the expected revenue, and wh sthe expected revenue? Group of answer choices Machine A, $2.7 million Machine B, $4.0 million Machine B, S4.6 million Machine C, $4.4 million none of the answers provided are correct

A Company wants to introduce new mobile phone into the market. The estimated price of each mobile phone is RO 800. The company requires a profit margin of 15% on sales.  Calculate a target cost for the new mobile phone.

Eastman Publishing Company is considering publishing an electronic textbook about spreadsheet applications for business. The fixed cost of manuscript preparation, textbook design, and web-site construction is estimated to be $175,000. Variable processing costs are estimated to be $8 per book. The publisher plans to sell single-user access to the book for $54. (a) Build a spreadsheet model in Excel to calculate the profit/loss for a given demand. What profit can be anticipated with a demand of 3,300 copies? For subtractive or negative numbers use a minus sign. -23,200 (b) Use a data table to vary demand from 1,000 to 6,000 in increments of 200 to test the sensitivity of profit to demand. Breakeven occurs where profit goes from a negative to a positive value, that is, breakeven is where total revenue = total cost yielding a profit of zero. In which interval of demand does breakeven occur? (i) Breakeven appears in the interval of 3,400 to 3,600 copies. (ii) Breakeven appears in the…