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

Cornerstones of Cost Management (Cornerstones Series)

4th Edition

ISBN:9781305970663

Author:Don R. Hansen, Maryanne M. Mowen

Publisher:Don R. Hansen, Maryanne M. Mowen

Chapter16: Cost-volume-profit Analysis

Section: Chapter Questions

Problem 8E

See similar textbooks

Similar questions

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
Derby Phones is considering the introduction of a new model of headphones with the following price and cost characteristics. Sales price $ 22 per unit Variable costs 5 per unit Fixed costs 25,000 per month Assume that the projected number of units sold for the month is 7,000. Consider requirements (b), (c), and (d) independently of each other. Required: a. What will the operating profit be? b. What is the impact on operating profit if the sales price decreases by 10 percent? Increases by 20 percent? c. What is the impact on operating profit if variable costs per unit decrease by 10 percent? Increase by 20 percent? d. Suppose that fixed costs for the year are 10 percent lower than projected, and variable costs per unit are 10 percent higher than projected. What impact will these cost changes have on operating profit for the year? Will profit go up? Down? By how much?
A Company wants to introduce new product. The estimated price of each mobile phone is RO 60. The company requires a profit margin of 20% on sales. The estimated cost of manufacturing the product is : Material cost : RO 9.500 Labour Cost : RO 12.750 Other Direct Expenses : RO 7.500 Administrative Costs : RO 5.000 Marketing and Selling expenses : RO 15.000 Calculate the Target Cost of the product and the Target Cost Gap.
Derby Phones is considering the introduction of a new model of headphones with the following price and cost characteristics. Sales price $ 21 per unit Variable costs 7 per unit Fixed costs 27,000 per month Assume that the projected number of units sold for the month is 7,000. consider requirements (b), (c), and (d) independently of each other. Required: a. What will the operating profit be? B. What is the impact on operating profit if the sales price decreases by 10 percent? Increases by 20 percent? c. What is the impact on operating profit if variable costs per unit decrease by 10 percent? Increase by 20 percent? d. suppose that fixed costs for the year are 10 percent lower than projected, and variable costs per unit are 10 percent higher than projected. What impact will these cost changes have on operating profit for the year? Will profit go up? Down? By how much? complete this question by entering your…
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.
Derby Phones is considering the introduction of a new model of headphones with the following price and cost characteristics. Sales price $ 21 per unit Variable costs 7 per unit Fixed costs 27,000 per month Assume that the projected number of units sold for the month is 7,000. consider requirements (b), (c), and (d) independently of each other. Required: a. What will the operating profit be? B. What is the impact on operating profit if the sales price decreases by 10 percent? Increases by 20 percent? c. What is the impact on operating profit if variable costs per unit decrease by 10 percent? Increase by 20 percent? d. suppose that fixed costs for the year are 10 percent lower than projected, and variable costs per unit are 10 percent higher than projected. What impact will these cost changes have on operating profit for the year? Will profit go up? Down? By how much? complete this question by entering your…
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…
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
The marketing department is considering a shift to internet-based advertising. The advertising rates and demographics of several different options are shown below. The marketing campaign goal is to reach the following audiences: Age 18 to 25 - 1,000,000 impressions Age 26 to 35- 1,500,000 impressions Age 36 to 45-750,000 impressions What mix of advertising investment will be most economical while still meeting the goals? Source A B Cost per thousand impressions (dollars) 30 20 Demographic breakdown 18-25 (30%), 26-35 (50%), 36-45 (20%) 18-25 (10 %), 26-35 (60%), 36-45 (30%) Note: Round your answer to the nearest whole number value. Investment in Source A (S) Investment in Source B ($)
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.
A firm plans to use three different types of ads to attract potential customers to its product. The three ad choices are TV ads, Magazine ads, and Sunday Supplement. The following table shows the number of potential customers one ad can reach: TV Ads (TV) - Number of Potential Customers Attracted per Ad 1,500 Magazine Ads (M) - Number of Potential Customers Attracted per Ad 500 Sunday Supplement - (SS)Number of Potential Customers Attracted per Ad 500 There are two categories of spending per ad as below ($, Thousands): Cost Per Ad ($Thousands) TV Ads (TV) Magazine Ads (M) Sunday Supplement (SS) Ad Budget 250 100 100 Planning Budget 100 50 50 There are following constraints: Total Ad Budget <= 3,500 Total Planning Budget <= 1,500 Total number of TV ads <= 5 The question is to find the optimal numbers of TV ads, Magazine ads, and Sunday Supplement, so that the total number of the potential customers attracted by these ads can be MAXIMIXZED.
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.