Question: Spreadsheet Modeling and Decision Analysis (7th Edition) Chapter 7 question 14 : in solution part d) how come the value of goal is 100000, while

Spreadsheet Modeling and Decision Analysis (7th Edition) Chapter 7 question 14 : in solution part d)

how come the value of goal is 100000, while actual cost is 176000, under =0, over =0.

formula used for goal is = actual cost + under -over , so shouldn't it be 176000? Is the solution 4.93 % given, correct?

Spreadsheet Modeling and Decision Analysis (7th

d If the manager wants to spend less on advertising than the solution suggests. Consider that the manager wants to spend only $100000 on the advertising. Consider the following excel model 1 2 The Olive Grove 3 4 Problem Data: Magazine TV 5 Number 6 Exposures (in 1000s) 250 1,200 7 Cost $2,000 $12,000 8 Min 10 5 9 10 Goal Constraints: Exposures Cost 11 Actual 18,100 $1,76 000 12 Under 0 SO 13 - Over 850 SO 14 - Goal 17.250 $1,00.000 15 Target 17.250 $1,00,000 16 17 Percentage Deviation: 18 Under 0.00% 0.00% 19 Over 4.93% 0.00% 20 21 Objective: 4.93% 22 If the manager wants to spend $100000 on the advertising then it must produce 13 TV commercials and 10 magazine ads

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!

Please answer parts 'a' through 'd' for Question-14 on Page-422 of the Spreadsheet Modelling by Kros book Please submit both this word file and the excel files Spreadsheet Modeling and Decision...

Spreadsheet Modeling and Decision Analysis (7th Edition) Chapter 7 question 14 : in solution part d) how come the value of goal is 100000, while actual cost is 176000, under =0, over =0. formula used...

Spreadsheet Modeling and Decision Analysis (7th Edition) Chapter 7 question 14 : in solution part b : what are the formulas used in the excel? what is the formula used for objective function? How did...

Spreadsheet Modeling and Decision Analysis (7th Edition) Chapter 7 question 14 : A new iTalian restaurant........ Could you explain for part a , could you explain in detail the logic behind the...

I need help with case study 6.1 on pages 307 to 308 on Optimizing a Timber Harvest in the book spreadsheet modeling and decision analysis edition 7. There is a partial solution on chegg but I'm not...

ACCT 5131 Spreadsheet Project Summer 2019 Guidelines Please read the guidelines in the Identifying Elements of a Financial Model section in Chapter 12 of the Hilton (2008) textbook (now...

Controller, Judy Koch, in a recent speech said, "I rarely see a real variable cost or a truly fixed cost." What did she mean? Include in your response an explanation of the difference in behavior of...

ACTIVITY DESCRIPTION The financial statements of The North West Company Inc. and Sobeys Inc. are presented in Appendix A and B in your Financial Accounting Tools for Business Decision- Making 7th...

Briefly discuss the cost-volume-profit analysis model and how it is used. Use the attached PDF. APA Citation. 300 words. REVISED PAGES 3 Chapter Three 1 Fundamentals of Cost-Volume-Prot Analysis...

Lecture Notes DL MGT 5100 - Distribution Management Spring 2017 1.0. Day one, Monday, Monday, 9 Jan 17 1.1. Reading Assignments: Chapters 1 and 2 1.1.1. I intend to follow the book so as to provide a...

Why is tone at the top so important to corporate governance?

A billet of stainless steel, AISI 316, with a diameter of 150 mm and a length of 500 mm emerges from a heat treatment process at 200C and is placed in an unstirred oil bath maintained at 20C. (a)...

Question 3 John Thompson, CEO of WVU, Inc., wants to raise $ 5 million in a private equity in his early - stage venture. Thompson projects net income of $ 1 8 million in year five ( five years from...

atch the compensation objectives with their meanings. Efficiency Efficiency drop zone empty. Fairness Fairness drop zone empty. Compliance Compliance drop zone empty. Improving performance and...