Identify data cells changing cells and objective cell also

Assignment Help Mathematics
Reference no: EM13589548

Giacomi & Jackowitz suggests giving consideration to running commercials for Crunchy Start on nationally syndicated radio programs. Giacomi & Jackowitz estimates that cost of development each radio commercial would be $50,000. And exposures per commercial would be $90,000. The firm has determine that 10 spots are available or different radio commercials, and each one would cost $200,000 for normal run.

A. formulates and solve spreadsheet model for revised advertising mix-problem that includes this fourth advertising medium. Identify data cells, changing cells, and objective cell. Also show the Excel equation for each output cell expressed as a SUMPRODUCT function.

B. indicates why spreadsheet model is a linear programming model.

Express this model in algebraic form.

Reference no: EM13589548

Questions Cloud

Several years ago penston company purchased 90 percent of : several years ago penston company purchased 90 percent of the outstanding shares of swansan corporation. penston made
Thomas corporation recorded sales of 108300 during march : thomas corporation recorded sales of 108300 during march. management expects sales to increase 5 in april another 2 in
If a power plant burning 10000 metric tons of coal per day : if a power plant burning 10000 metric tons of coal per day with 6 excess air emits stack gas containing 222 ppm by
Slagle corporation is a large manufacturing organization : slagle corporation is a large manufacturing organization. over the past several years it has obtained an important
Identify data cells changing cells and objective cell also : giacomi amp jackowitz suggests giving consideration to running commercials for crunchy start on nationally syndicated
A credit balance exists in the accounts receivable 60-90 : presented below is information related to the accounts receivable accounts of gulistan inc. during the current year
Prepare the 2012 form 1040 and all other required federal : 1. prepare the 2012 form 1040 and all other required federal forms and schedules for brett simons. the returns
Pedict the percentage of each of these products in the : question predict the percentage of each of these products in the mixture secondary hydrogens are 4.5 times more
Shelley wants to cash in her winning lottery ticket she can : present and future value tables of 1 at 3 are presented belownfv 1pv 1fva 1pva 1fvad 1pvad 111.030000.970871.0000

Reviews

Write a Review

Mathematics Questions & Answers

  Draw a network diagram for problem

Draw a network diagram for problem - Label all nodes appropriately with either numbers or town names. Note: if you use numbers, please provide a mapping guide to equate your numbers to towns.

  Vertex of a parabola-maximum height

An arrow is accidentally shot into the air. The formula y = - 14x2 + 56x + 18 models the arrow's height above the ground, y, in feet, x seconds after it was released.

  How many of each were ordered

A student submits an order for 23 pizza making kits with a check for 187 dollars. He doesn't remember how many pepperoni and cheese he ordered, just that pepperoni is 9 bucks and the cheese is 7. How many of each were ordered?

  Information about rings and ideals

Let I be an ideal of R and let S be a subring of R. prove that I(intersection)S is an ideal of S. ALSO, show by some example that not every ideal of a subring S of a ring R

  Explain why the normal distribution can be used to binomial

Explain why the normal distribution can be used as an approximation to the binomial distribution. What conditions must be met to use the normal distribution to approximate

  Draw a diagram of the balls flight

While walking along at a constant speed, project a ball vertically into the air. If you continue to walk without changing your speed or direction, where will the ball land? Draw a diagram of the balls flight, indicating the forces acting on it.

  Find the original price

If the price of an item drops 10 cents per dozen, it becomes possible to buy 2 dozen more items for $6.00 than was possible at the original price. Find the original price.

  What is the expected mean number of failures

The probability of failure for taking the bar exam in Philadelphia is 41%.  If 375 people take the bar exam, what is the expected mean number of failures?

  What percentage of the total capacity is being used

A water storage tank has the shape of a cylinder with diameter 22 ft. It is mounted so that the circular cross-sections are vertical. If the depth of the water is 20 ft, what percentage of the total capacity is being used? (Round the answer to one..

  Describe two real-life examples

Describe two real-life examples where the order of operations and basic math principles are used either at home or on the job.

  Define the pile is in the shape of an inverted cone

Gravel is being poured onto a pile at the rate of 180 cubic meters per minute. The pile is in the shape of an inverted cone whose diameter is always three times its height.

  What is the proablity of randomly generating nine digits

each social security number is a sequence of nine digits. what is the proablity of randomly generating nine digits and getting your social security number?

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd