How do you construct and implement the model? What does it look like? The Camera Shop sells two popular models of digital SLR cameras (Camera A Price: 220, Camera B Price: 310). The sales of these products are not independent of each other, but rather if the price ofone increase, the sales of the other will increase. In economics, these two camera models are called substitutable products. The store wishes to establish a pricing policy to maximize revenue fromthese products. A study of price and sales data shows the following relationships between the quantity sold (N) and prices (P) of each model:NA 196 0.5PA+ 0.35PBNB = 301 + 0.06PA - 0.6PBConstruct a model for the total revenue and implement it on a spreadsheet. Develop a two-way data table to estimate the optimal prices for each product in order to maximize the total revenue. Varyeach price from $250 to $500 in increments of $10.Max profit occurs at Camera A price of $Max profit occurs at Camera B price of $

Answered: Image /qna-images/answer/1d65a7a5-dd48-4cc8-a334-746323d3efe8.jpg

Answered: How do you construct and implement the…

Business

Operations Management

How do you construct and implement the model? What does it look like?

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...

See similar textbooks

Similar questions

A firm wants to stop its sales agents from pricing too aggressively to make sales by requiring the agent to obtain a marketing manager’s permission to reduce price below a specific threshold. This solution would only work if a) The marketing manager has no information about the matter at hand b) The marketing manager can only get all the information on the case from the sales agent c) Enough unbiased information is transferred to the manager to prevent an unprofitable price reduction d) All of the above Please clearly explain your answer
The following are the criteria for evaluating price metrics except: a. tracks with differences in value across segments b. is easy to measure and enforce c. offering economic value and design d. tracks with differences in cost to serve
In pricing models, elasticity of demand is an input which specifies the: A. range of demand B. level of demand C. sensitivity of price to changes in demand D. sensitivity of demand to changes in price
Misu Sheet, owner of the Bedspread Shop, knows his customers will pay no more than $120 for a comforter. Misu wants a 30% markup on selling price. What is the most that Misu can pay for a comforter? Assume Misu Sheet wants a 30% markup on cost instead of on selling price. What is Misu's cost? Round to the nearest cent.
The third question free food from your distributor. The annual -A commercial company orders a type of gluten demand is 5,000 packages, the price of one package is $8, the cost of maintaining one unit is $1, and the cost of preparing the order is $25. If the distributor offers some selling temptations to this company in the form of a discount as follows: 5% discount if the quantity purchased at one time is at least 3000 packs. 6% discount if the quantity purchased at one time is at least 4000 units Decide on the quantity to be purchased so that the total cost of inventory is as low as possible.
The availability of alternative entertainment methods has resulted in a large decrease in theme-park visitors. To help the theme-park operators, the government is contemplating imposing a price floor for theme-park tickets. Appraise the welfare effects of these policy with suitable theme-mark market diagrams. Your diagrams should take into consideration of the price elasticity of demand and supply of theme-park in general.
Implementing Price Strategy is the firm readiness to sell the product which would be effective if given an attractive price strategy listed below: a. Customary pricing is when one price is maintained over an extended period of time. Normally the price of the product will not be easily changed. The entrepreneur must consider the price of the product which is affordable to the majority of buyers. ex. A 1-peso candy. b. Variable pricing is when the price responds to cost fluctuations or differences in demand. The entrepreneur must consider the law of demand and supply. If there are sufficient supplies and few demands, the price will increase and vice versa. c. One-price policy is when the price is charged to all customers buying the product or service under similar conditions. The entrepreneur will set one price for all products available for sale even though they differ in design. d. Flexible pricing is based on the customer's ability to negotiate or buying power of the customer. The…
Jacqueline Mulvaney makes bespoke corsages. She is about to attend an important show in London. She thinks that if the market is favorable, she can sell deluxe corsages at $75 each. However, if the market is not good, she will only sell 35 at $65 each. Jacqueline also makes a simple-range of corsages. If the market is positive, she can sell 80 simple corsages at $45 each, whereas if the market is not good, she will only sell 60 at $38 each. To produce either set of corsages costs about the same and she only has time to make one range. If Jacqueline feels that there is a 0.5 chance of the show going well, which range of corsages should she make based on the EMV?
Pricing Q: What are different factors that should be considered by marketers before deciding price of the product? Q: How the total cost is determined/calculated by company for deciding price of the product? Q: What is breakeven point? How is it calculated? Q: How the net profit is calculated? Q: Consult your book and write the following procedures and formulas for calculating price? Cost Plus pricing Breakeven pricing Return on investment pricing Value based pricing Q: Write the methods for determining pricing of new products?
Pricing Q: What are different factors that should be considered by marketers before deciding price of the product? Q: How the total cost is determined/calculated by company for deciding price of the product? Q: What is breakeven point? How is it calculated? Q: How the net profit is calculated? Q: write the following procedures and formulas for calculating price? a. Cost Plus pricing b. Breakeven pricing c. Return on investment pricing d. Value based pricing Q: Write the methods for determining pricing of new products?
Please read below scenario in which a consumer explains how she made purchasing decision for a car. First of all, I decided on the price and security features of car. Then, I determined my criteria about other features such as the oil amount consumed per 100 km, diesel or gasoline and so on. When I searched for information on the Internet, I felt that Brand X can offer me favorable alternatives. I visited one of the showrooms of Brand X. I loved this red car and purchased it. Please select the name of Hierarchy of Effects that the consumer likely used. a) The Standard Learning Hierarchy b) The Low-Involvement Hierarchy c) The Experiential Hierarchy d) All the above
Hair Zone manufactures a brand of hair-styling gel. It is considering adding a modifiedversion of the product—a foam that provides stronger hold. Hair Zone’s variable costs and prices to wholesalers are: Current Hair Gel New Foam Product Unit selling price 2.00 2.25 Unit variable costs . 85 1.25Hair Zone expects to sell 1 million units of the new styling foam in the first year after introduction, but it expects that 60% of those sales will come from buyers who normally purchase Hair Zone’s styling gel. Hair Zone estimates that it would sell 1.5 million units of the gel if it did not introduce the foam. If the fixed cost of launching the new foam will be $100,000 during the first year, should Hair Zone add the newproduct to its line? Why or why not?