Late submissions will not be graded. Projects should be submitted in Meskanas (Linear Programming Group Assignment...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Late submissions will not be graded. Projects should be submitted in Meskanas (Linear Programming Group Assignment link). You will submit two files per group: 1. One Word Document with a report outlining your recommendations for the issues listed in the case. The document should also include an appendix for each of the issues showing your algebraic equations and decisions, and a readable screen clip of your Excel output, including the Solver dialogue box (see parts a & b below). This is especially important to show how you used Solver. 2. One Excel Spreadsheet with clearly labeled worksheets (one worksheet for each of the issues in the assignment). The work in the worksheets needs to be well organized and clearly labeled, with formulas used appropriately. Examples of potential formats can be found in the course materials for linear programming. The general approach for solving each of the issues should be: a. Formulate the linear programming model for the issue algebraically. Group this into three sections: 1) Definition of Decision Variables, 2) Objective Function Equation, and 3) Constraints Equations. This should go in the appendix of your memo. (6 marks for each issue) b. Set up and solve this problem using Excel. Include screenshots of this in the appendix to the memo or report. (6 marks for each issue) C. Provide your answers and recommendations to the Manager of the company (include your recommendations for all issues in a single report). (2 marks for each issue). See the basic structure of the report and memo on pages 5 & 6. d. General organization and formatting (over entire assignment) - 4 marks. Richelieu Specialty Paints Richelieu Specialty Paints is a company run by Amanda Richelieu. She is an artist and earned a BA degree with a major in Art and Design. The company was founded by Amanda's father and he recently asked her to take over managing it so that he could retire. Amanda agreed and left her interior design job with an architecture firm to assume the role. She is keen to develop the business further. The company makes a wide variety of paints, mostly targeted at fine artists. However, since Amanda has had experience in interior design she has determined that the company could apply its skills to develop new products for that industry and others. She knows that she hasn't yet developed her quantitative analysis skills to the point they need to be to run a company, so she is seeking assistance with four decisions that she needs to make. She would like to have a report from you providing recommendations for each decision, along with the background calculations that support your decisions. Decision 1: Marketing - Advertising Placement Amanda has a yearly advertising and promotions budget of $51,340. Her goal is to maximize the reach (the number of customers that see her company's ads or other marketing efforts). She is considering a mix of placing ads on art websites and in printed art magazines, as well as using targeted social media ad placements and appearances at art tradeshows. She wants to make sure that the company has an online presence, so would like to see at least 180 ads placed on any combination of websites and social media per year. However, she has data that suggests that if she advertises on the websites more than once per week she will be wasting money. There are seven art tradeshows that the company could attend, but Amanda feels it is mandatory to attend at least the three most popular tradeshows. There are four major art magazines, each published monthly, that Amanda would like to advertise in. She could advertise in each of these once per month but would be comfortable reducing the frequency to a minimum of once every other month in each magazine and rotating the placements between the magazines. The reach and cost of each type of ad placement or event are shown below: Art Websites Social Media Art Print Magazine Tradeshows Ads Reach (number of people) 15,000 12,000 5,000 8,000 Cost (dollars) 100 250 1,000 440 a. Recommend the appropriate mix of advertising and promotions for the company. b. Also, comment on what would change if Amanda doubled her advertising and promotions budget. Estimate the increased reach. Late submissions will not be graded. Projects should be submitted in Meskanas (Linear Programming Group Assignment link). You will submit two files per group: 1. One Word Document with a report outlining your recommendations for the issues listed in the case. The document should also include an appendix for each of the issues showing your algebraic equations and decisions, and a readable screen clip of your Excel output, including the Solver dialogue box (see parts a & b below). This is especially important to show how you used Solver. 2. One Excel Spreadsheet with clearly labeled worksheets (one worksheet for each of the issues in the assignment). The work in the worksheets needs to be well organized and clearly labeled, with formulas used appropriately. Examples of potential formats can be found in the course materials for linear programming. The general approach for solving each of the issues should be: a. Formulate the linear programming model for the issue algebraically. Group this into three sections: 1) Definition of Decision Variables, 2) Objective Function Equation, and 3) Constraints Equations. This should go in the appendix of your memo. (6 marks for each issue) b. Set up and solve this problem using Excel. Include screenshots of this in the appendix to the memo or report. (6 marks for each issue) C. Provide your answers and recommendations to the Manager of the company (include your recommendations for all issues in a single report). (2 marks for each issue). See the basic structure of the report and memo on pages 5 & 6. d. General organization and formatting (over entire assignment) - 4 marks. Richelieu Specialty Paints Richelieu Specialty Paints is a company run by Amanda Richelieu. She is an artist and earned a BA degree with a major in Art and Design. The company was founded by Amanda's father and he recently asked her to take over managing it so that he could retire. Amanda agreed and left her interior design job with an architecture firm to assume the role. She is keen to develop the business further. The company makes a wide variety of paints, mostly targeted at fine artists. However, since Amanda has had experience in interior design she has determined that the company could apply its skills to develop new products for that industry and others. She knows that she hasn't yet developed her quantitative analysis skills to the point they need to be to run a company, so she is seeking assistance with four decisions that she needs to make. She would like to have a report from you providing recommendations for each decision, along with the background calculations that support your decisions. Decision 1: Marketing - Advertising Placement Amanda has a yearly advertising and promotions budget of $51,340. Her goal is to maximize the reach (the number of customers that see her company's ads or other marketing efforts). She is considering a mix of placing ads on art websites and in printed art magazines, as well as using targeted social media ad placements and appearances at art tradeshows. She wants to make sure that the company has an online presence, so would like to see at least 180 ads placed on any combination of websites and social media per year. However, she has data that suggests that if she advertises on the websites more than once per week she will be wasting money. There are seven art tradeshows that the company could attend, but Amanda feels it is mandatory to attend at least the three most popular tradeshows. There are four major art magazines, each published monthly, that Amanda would like to advertise in. She could advertise in each of these once per month but would be comfortable reducing the frequency to a minimum of once every other month in each magazine and rotating the placements between the magazines. The reach and cost of each type of ad placement or event are shown below: Art Websites Social Media Art Print Magazine Tradeshows Ads Reach (number of people) 15,000 12,000 5,000 8,000 Cost (dollars) 100 250 1,000 440 a. Recommend the appropriate mix of advertising and promotions for the company. b. Also, comment on what would change if Amanda doubled her advertising and promotions budget. Estimate the increased reach.
Expert Answer:
Answer rating: 100% (QA)
Decision 1 Marketing Advertising Placement a Recommended Mix of Advertising and Promotions We can solve this problem using linear programming to maxim... View the full answer
Related Book For
Auditing Cases An Interactive Learning Approach
ISBN: 978-0132423502
4th Edition
Authors: Steven M Glover, Douglas F Prawitt
Posted Date:
Students also viewed these accounting questions
-
see below questions and provide me adjusted coding by using my coding. I share my coding and test failure message at the end. 1. BST.java 2.BSTNode.java Binary Search Tree you will be coding the...
-
List three specific parts of the Case Guide, Objectives and Strategy Section (See below) that you had the most difficulty understanding. Describe your current understanding of these parts. Provide...
-
Determine whether the following code fragment takes linear time, quadratic time, or cubic time (as a function of \(n\) ). for (int i = 0; i < n; i++) for (int j = 0; j < n; j++) j) C[i][j] 1.0; if (i...
-
Discuss the implications of outsourcing in supply chain strategy and give an example of how this has improved a particular business's economic position. Also, what are some ethical implications of...
-
For the designs obtained in part (a) of Problem 35, use a computer method to plot the actuator torque versus time. Compare the peak torque values for each case. In Problem 35(a) Compute the required...
-
The force transmissibility of a damped single-degree-of-freedom system with base motion is given by Eq. (9.106): \[T_{f}=\frac{F_{t}}{k Y}=r^{2}\left\{\frac{1+(2 \zeta r)^{2}}{\left(1-r^{2}...
-
Chicos has sales of 15,000 units at a price of $20 per unit. The firm incurs fixed operating costs of $30,000 and variable operating costs of $12 per unit. What is Chicos degree of operating leverage...
-
Show workings ( 1 ) You visited Port's Auto Parts and purchased the following items: a . 2 control arm bushings @ $ 1 0 0 0 each b . 2 park lamps RH Toy / Camry LHD @ $ 3 7 5 0 each ( 2 ) Compute...
-
If 15.0 ml of 0.1 normal KMNO, solution is used to titrate 0.12 g of an unknown, the equivalent weight of the unknown will be O a. 0.8 O b. 0.08 O c. 12.5 O d. 80
-
Without mentioning payment, Mary accepts the services of Razi, a contractor, and is pleased with the work. Is there a contract between them? a. Yes, there is an express contract. b. Yes, there is an...
-
Show that decimation is a time-varying, but periodically time-invariant, operation and that interpolation is a time-invariant operation.
-
Joe England sold equipment on May 10,2017 for \(\$ 100,000\). He bought the equipment on November 7, 2015 for \(\$ 140,000\), and accumulated depreciation at the date of sale was \(\$ 60,000\). Joe...
-
Equity classifications for nongovernment not-for-profit hospitals include all of the following except a. invested in capital assets, net of related debt. b. unrestricted net assets. c. permanently...
-
The sequence \[x=0.125,0.25,0.5,1,2,4\] is filtered by a filter with transfer function \[H(z)=\frac{1}{3}\left(1+z^{-1}+z^{-2} ight)\] and the result is decimated by 2 . The output is then upsampled...
-
The heat capacity of object B is 11-times that of object A. Initially A is at 500 K and B is at 375 K. They are placed in thermal contact and the combination is isolated. The final temperature of...
-
How has the too-big-to-fail policy been limited in the FDICIA legislation? How might limiting the too-big-to-fail policy help reduce the risk of a future banking crisis?
-
The accounting firm of Barnes and Fischer, LLP, is a medium-sized, national CPA firm. The partnership, formed in 1954, now has over 6,000 professionals on the payroll. The firm mainly provides...
-
Dell Computer Corporation (Dell) is a worldwide provider of products and services that enable customers to build information-technology and internet infrastructures. Dell offers a broad range of...
-
Dont ever tell yourself, that wont happen to me. Just ask Cynthia Cooper, former Vice President of Internal Audit at WorldCom. Cynthia Cooper was a typical accounting student as an undergrad at...
-
There are three general categories of capital budget scenarios: replacement, expansion, and investment in a NewCo. Describe the overall decision-making context for each. How do they draw on similar...
-
The overall process of creating a capital budget proposal has a lot of similarities to writing a business plan for a start-up company. Describe three aspects of the similarities between a budget...
-
In analysis, some focus seems to be on the need for NPV equations to be applied to projects that are mutually exclusive. But in practice we find that the lines are blurred in capital budgeting....
Study smarter with the SolutionInn App