Business, 05.05.2020 05:37 puppylover72

The Sea Wharf Restaurant would like to determine the best way to allocate a monthly advertising budget of $1,000 between newspaper advertising and radio advertising. Management decided that at least 25% of the budget must be spent on each type of media and that the amount of money spent on local newspaper advertising must be at least twice the amount spent on radio advertising. A marketing consultant developed an index that measures audience exposure per dollar of advertising on a scale from 0 to 100, with higher values implying greater audience exposure. Given the value of the index for local newspaper advertising is 50 and the value of the index for spot radio advertising is 80, the restaurant wants to allocate its advertising budget to maximize the value of total audience exposure.
Required:
a. Formulate a linear programming model that can be used to determine how the restaurant should allocate its advertising budget in order to maximize the value of total audience exposure.
b. Develop a spreadsheet model and solve the problem using Excel Solver.

Answers: 1

Show answers

Another question on Business

Business, 21.06.2019 21:00

12. nelson corporation, which has only one product, has provided the following data concerning its most recent month of operations: selling price $ 115 units in beginning inventory 380 units produced 5,900 units sold 6,070 units in ending inventory 210 variable costs per unit: direct materials $ 46 direct labor $ 27 variable manufacturing overhead $ 3 variable selling and administrative $ 12 fixed costs: fixed manufacturing overhead $ 112,100 fixed selling and administrative $ 36,420 the company produces the same number of units every month, although the sales in units vary from month to month. the company's variable costs per unit and total fixed costs have been constant from month to month. a. prepare a contribution format income statement for the month using variable costing. unit product cost under variable costing direct materials direct labor variable manufacturing overhead variable costing unit product cost (formula)

Answers: 3

Answer

Business, 22.06.2019 04:10

An outside manufacturer has offered to produce 60,000 daks and ship them directly to andretti's customers. if andretti company accepts this offer, the facilities that it uses to produce daks would be idle; however, fixed manufacturing overhead costs would be reduced by 75%. because the outside manufacturer would pay for all shipping costs, the variable selling expenses would be only two-thirds of their present amount. what is andretti's avoidable cost per unit that it should compare to the price quoted by the outside manufacturer?

Answers: 3

Answer

Business, 22.06.2019 06:40

As a finance manager at allsports communication, charlie worries about the firm's borrowing requirements for the upcoming year. he knows the benefit of estimating allsports' cash disbursements and short-term investment expectations. facing these concerns, a(n) would provide charlie with valuable information by providing a good estimation of whether the firm will need to do short-term borrowing. capital budget cash budget operating budget line item budget

Answers: 3

Answer

Business, 22.06.2019 10:00

Carrie works at a canned food production factory. the government wanted to give a boost to the salt industry, so it lined up numerous subsidies and tax exemptions for the sector. this lead to a decrease in production costs. this also meant that consumers could access canned foods at a lower price, which lead to an increase in demand for the product. which kind of economic system is carrie’s company dealing with? carrie’s company is dealing with a/an economy.

Answers: 2

Answer

You know the right answer?

The Sea Wharf Restaurant would like to determine the best way to allocate a monthly advertising budg...

Questions