The relationship between marketing expenditures (x) and sales (y is given by the following formula, y= 6x-0.40x+7. (Hint: Use the Nonlinear Solver tool). a. What level of marketing expenditure will maximize sales? (Round your answer to 2 decimal places.) Marketing expenditure b. What is the maximum sales value? (Round your answer to 2 decimal places.) Maximum sales value
Q: Consider a market with the following supply and demand. (It may help to draw a graph for these…
A: Below is the solution:-
Q: The fixed costs of Chun Company are $309,000 and the total variable costs for its only product are…
A: The question is related to Cost Volume Profit Analysis. First we will calculate Profit under present…
Q: Oxicon Inc. manufactures several different types of candy for various retail stores. The…
A:
Q: CA Corporate has an available funds of $200,000 is considering for new investment opportunities. The…
A: Investment portfolio of stocks is given as follows:
Q: Sarah Meeham blends coffee for tasti-delight. She needs to prepare 150 pounds of blended coffee…
A: Given - Total required quantity = 150 pounds Selling price = $4.05 per pound High-quality been cost…
Q: Following paragraph is extracted from (Kumar, Lall & Mane, 2017) research paper. Read the paragraph…
A: Since you have posted a question with multiple sub-parts, we will solve first three subparts for…
Q: Train an ID3 decision tree for a dataset shown in the following table. The table contains 2…
A: The following is the python code for ID3 decision tree and predict values.
Q: After entering the data shown below in cells B2, B3, B6, and B10, what values should appear in the…
A: Below is the solution:-
Q: For this equation. Daniel and his family recently moved to California. Daniel wants to know which…
A: given,
Q: What sales price will be necessary to achieve a target profit of $1 million?
A: The unit variable cost, fixed cost, target profit, and target volume, sales price to accomplish the…
Q: Using MAD as the criterion, which of the following models would you use for the given time series…
A: THE ANSWER IS AS BELOW:
Q: Explore the websites of Iasta, IBM-Emptoris, and SciQuest; then explain what you feel each provides…
A: Iasta, IBM-Emptoris, and SciQuest are software that helps in decision optimization in the…
Q: Evaluate the following given the following values: 1. The price of pair of socks is Php 200. How…
A: The above questions are from the topic: Profit and Loss The answer to the questions are given below:
Q: The political pollster Canter is preparing for a national election. It would like to poll at least…
A: Given Information:
Q: t in dollars per month? What is the expected number of meals each day if
A: Given, Fixed cost = $1,800 Fixed cost for entertainment = $2,000 Therefore, the total fixed cost =…
Q: In Example 9.2, the fixed costs are split $4 million for development and $2 million for marketing.…
A: Open dominate New Product Decision-Technological Uncertainty Finished.xlsx. To perform affectability…
Q: A publisher prints copies of a popular weekly tabloid for distribution and sale. The fixed costs are…
A: Cost function indicating the sum value of the cost. Here, we develop the cost function by…
Q: The following statements concern the competitive market equilibrium. Wh C. following is true? The…
A: Perfect competetion is a type of market wherein there is free entry and exit for the marketers which…
Q: Assume we have data demonstrating a strong linear link between the amount of fertilizer applied to…
A: The research process can be defined as the process of choosing a problem, gathering information,…
Q: Home price y is estimated as a function of the square footage of a house x and a dummy variable d…
A: Given: y = 118.90 +0.12x + 52.60d i.) For a house with mountain views, d = 1 For a house with…
Q: ne of your staff members developed the following excel optimal production plan. You must now review…
A: MEMORANDUM To: VP of Operations, Mr. Monroe From: Plant Manager Date: XXXX XX, 2021 Subject: Utility…
Q: An analyst is constructing a simple model to determine the gross and net profit of a product, given…
A: Given that - Profit per unit $5 Quantity 18,200 Gross profit ? Total costs 8,300 Net…
Q: Highline Financial Services provides three categories of service to its clients. Managing partner…
A: Service A: Formula:
Q: What is the maximum profit? What is the value of X? * What is the objective function? (write the…
A: First, let me formulate the linear programming problem, this LP formulation is done below: Here,…
Q: Note: This problem requires Excel. A firm offers two different prices on its products, depending…
A: Let, P1 = Number of units of product 1 to be produced Q1 = Number of units of product 1 to be…
Q: For the following problem, provide an objective in words, data definition, variable definition, and…
A: Given data is Profit by small size soft drink = $42 Profit by medium-size soft drink = $45 Profit by…
Q: Write “True” if the statement is true and write “False” if the statement is false. 1. With the…
A: 1. This statement is True. As after the emergence of the information era, most of the companies are…
Q: A restaurant borrows $15,200 from a local bank for 10 months. The local bank charges simple…
A: Given that: Principal(P) = $15200 For months (t) = 10 Interest rate annually = 4.55%
Q: The following data pertain to the operating budget of a certain manufacturing company Capacity per…
A: Given data, Sales- $681,00 Fixed cost- $294,000 Variable cost- $313,260
Q: What should be the production volume for that quarter?
A: Material requirement plan will helps the management to identify the timely ordering of items with…
Q: Which of the following situations is feasible to use Solver? O A. Create a production a plan to…
A: Solver is a program used to solve Linear programming problems using Excel. Linear programming…
Q: Hello, Below is the question from Statistic Chapter Linear Programming and the solution is required…
A: Following is the excel model:
Q: An investment company manages portfolios of stocks, bonds, and other investment alternatives. One of…
A: AS PART ONE IS ALREADY SOLVED. I AM JUMPING DIRECTLY TO QUESTION 2. Now we solve the above problem…
Q: Bullseye Shirt Company makes three types of shirts: athletic, varsity, and surfer. The shirts are…
A: Decision Variable: Suppose- Xij be the yards of fabric of the ith ingredient used in the jth…
Q: As a prospective owner of a club known as the Red Rose, you are interested in determining the…
A: ANSWER IS GIVEN BELOW:
Q: A Make-or-Buy DecisionTriple X Company manufactures and sells refrigerators. It makes some of the…
A: If part has been manufactured: Fixed cost: $50,000 Labor cost: $1,25,000 Factory overhead: $60,000…
Q: G z Product Mix Example Product 3 P01 P02 P03 P04 Profit/unit: 26 35 25 37 Hours : Machine available…
A: The question is related to optimum product mix. The limiting factor is machine hours. First we have…
Q: XYZ Corporation manufactures two products, Simple and Complex. The following annual information was…
A: Profit maximization is a cycle business firms go through to guarantee the best result and cost…
Q: A company has production costs of $15 per item and can produce 270 items for a total cost of $6,925.…
A: Slope intercept form = ax + b where x = slope b = intercept Given: Cost to make 270 units…
Q: An appliance manufacturer produces two models of microwave ovens: H and W. Both modelsrequire…
A: Given Information: Oven – H Oven-W Total Fabrication (hours) 4 2 600…
Q: Taxes The function T(x) represents the tax bill T of a single person whose adjusted gross income is…
A: Since you have posted a question with multiple sub-parts, we will solve first three sub-parts for…
Q: Well Water Inc. wants to produce and sell a new flavored water. In order to penetrate the market,…
A: Given, Annual sales = 50000 bottles Selling cost = $2 Sales revenue = $2*50000 = $100,000 Desired…
Q: Evaluate the following given the following values: 1. The price of pair of socks is Php 200. How…
A: The above questions are from the topic: Profit and Loss. The answer to the questions are given…
Q: Three different objectives relate to a firm's profit, which is often measured in terms of return on…
A: The profit of the organization which is set by the board of directors is known as target return. It…
Q: Suppose the company could acquire 1,000 pounds more of either nitrogen or phosphorous. Which should…
A: The problem can be setup in excel.
Q: The relationship between marketing expenditures (x) and sales () is given by the following formula,…
A: Setting a marketing budget refers to keeping or making a budget for the marketing expenditures…
Q: The following table represents sales data for milk (in hundred liters) sold by a grocery. Do the…
A: Note: - Since the exact question that has to be answered is not specified we will answer the…
Q: How much is the total sales? b. What is your break-even point in pesos per month
A: Breakeven point indicating the quantity of item of value of revenue which facilitate the no loss no…
Q: Explain the following CATEGORIES OF SPREADSHEET ANALYSIS 1-Base-case analysis 2-What-if analysis…
A: An Excel Modelling uses an Excel spreadsheet to make quantitative estimates or predictions based on…
Non-linear programming
Trending now
This is a popular solution!
Step by step
Solved in 2 steps
- If a monopolist produces q units, she can charge 400 4q dollars per unit. The variable cost is 60 per unit. a. How can the monopolist maximize her profit? b. If the monopolist must pay a sales tax of 5% of the selling price per unit, will she increase or decrease production (relative to the situation with no sales tax)? c. Continuing part b, use SolverTable to see how a change in the sales tax affects the optimal solution. Let the sales tax vary from 0% to 8% in increments of 0.5%.The relationship between marketing expenditures (x) and sales (y) is given by the following formula, y = 9x − 0.05x2 + 9. (Hint: Use the Nonlinear Solver tool). What level of marketing expenditure will maximize sales? (Round your answer to 2 decimal places.) What is the maximum sales value? (Round your answer to 2 decimal places.)You have an idea for a new web service that offers customized workouts for subscribers. Build a spreadsheet to calculate 1) the number of new customers each month and 2) the total customer base (cumulative number of customers signed up) each month. Mimic what we did in the class to project the subscription volumes for 60 months under the following sets of assumptions. a)Total market potential is 1,000,000 customers. Each month, you sign up 2% of customers in the market that have not yet signed up. b)Total market potential is initially 1,000,000 customers, but grows at 1% per month. Each month, you sign up 2% of customers in the market that have not yet signed up. Use the graph wizard to make a graph comparing total customer base under each of the two scenarios. Which type of graph is appropriate?
- XYZ Corporation manufactures two products, Simple and Complex. The following annual information was gathered: Simple Complex Selling price per unit P47.00 P26.00 Variable cost per unit 42.00 22.00 Total annual fixed costs are P18,000. Assume XYZ Corporation can produce and sell any mix of Simple or Complex at full capacity. It takes 1.5 hours to make one unit of Complex. However, Simple takes 50% longer to manufacture when compared to Complex. Only 120,000 hours of plant capacity are available. How many units of Simple and Complex should XYZ Corporation produce and sell in a year to maximize profits?Finally, due to budget constraint, your inititial budget of $100,000 has been reduced to $75,000. SET YOUR CONSTRAINTS, DECIDE WHICH AREAS/TASKS BUDGET TO BE ADJUSTED AND USE EXCEL SOLVER TO CREATE YOUR FINAL BUDGET. Submit your plan and your reasoning behind the decisions and why your plan will make the event a success. Excel spreadsheet must show the distribution of your initial budget of $100,000 and your final budget of $75,000 with the constraints you set. Use the the excel spreadsheet image and show constraints.A goldsmith makes two types of jewelry. A model A ring is made with 1 g of gold and 1.5 g of silver and sells for 25 UM.Another model B ring sells for 30 UM and is made of 1.5 g of gold and 1 g of silver. If you only have 750 gof each metal, how many rings should be made of each type to obtain maximum profit?Requested:- Make Initial Table of the problem.- Obtain the Case Variables- Obtain the Objective Function- Get Restrictions- Create the Simplex Table- Obtain the Optimal Solution and the Slack Variables.Solve this operational research exercise.
- One of your staff members developed the following excel optimal production plan. You must now review this optimal plan and write a memo to the VP of Operations (Mr. Monroe) with recommendations as to how this optimal production plan can be improved to increase the Total Profit. What are three recommendations you have to the VP of operations based on the attached optimal production plan? These three options must be based only on information present in the excel production plan and components of LP modeling [decision variables, objective function (prices and variable cost), and resource constraints].XYZ Corporation manufactures two products, Simple and Complex. The following annual information was gathered: Simple Complex Selling price per unit P47.00 P26.00 Variable cost per unit 42.00 22.00 Total annual fixed costs are P18,000. Assume XYZ Corporation can produce and sell any mix of Simple or Complex at full capacity. It takes one hour to make one unit of Complex. However, Simple takes 50% longer to manufacture when compared to Complex. Only 120,000 hours of plant capacity are available. How many units of Simple and Complex should XYZ Corporation produce and sell in a year to maximize profits?For a table manufacturing company, selling price for a table is $183.00 per Unit, Variable cost is $25.00 per Unit, rent is $3,380.00 per month and insurance is $296.00 per month. Company wants to expand its business and improve the table quality, it wants to increase the selling price for a table to $254.00 per Unit, Variable cost to $43.00 per Unit, bigger area will have rent $5,235.00 per month and insurance is $362.00 per month At what point will the company be indifferent between the current mode of operation and the new option?
- The cost data for Evencoat Paint for the year 2019 is as follows: Month Gallons ofPaintProduced EquipmentMaintenanceExpenses January 110,000 $70,700 February 68,000 66,800 March 71,000 67,000 April 77,000 68,100 May 95,000 69,200 June 101,000 70,300 July 125,000 70,400 August 95,000 68,900 September 95,000 69,500 October 89,000 68,600 November 128,000 72,800 December 122,000 71,450 A. Using the high-low method, express the company’s maintenance costs as an equation where x represents the gallons of paint produced. Then estimate the fixed and variable costs. Fixed cost $ Variable cost $A person sells and installs A, B and C. The table shows, for example, that it takes 3 hours to sell a unit of B, it takes 4 hours to install it, and net profit per unit is $ 40. Product No. of Units Selling Hours per Unit Installation Hours per Unit Profit per Unit A x 1 1 $10 B y 3 4 40 C z 2 1 10 During a 38-hour week, the person allots no more than 18 hours to selling and no more than 20 hours to installation. Find the combination of number of units of A, B, C that would yield maximum profit.Analyse how the Wiig KM model compares and contrasts with the SECI model. Explain the role that each factor plays in making your solution a success. If not, have you considered expanding the models to include the components that are now absent? If any of these suggestions were to be implemented, what challenges do you foresee and how would you plan to overcome them?