Cj- Si= ¡= B= N= unit cost of item/ cost per order placed for item/ inventory carrying charge as a percentage of the cost per unit the maximum amount of investment in goods number of items In the objective function, the first term is the annual cost of goods, the second is the annual ordering cost (D)/Q) is the number of orders) and the last term is the annual inventory holding cost (Q/2 is the average amount of inventory). Set up a spreadsheet model for the following data: Item Item 1 2 2000 2000 Item 3 1.500 Annual Demand Item Cost Order Cost B-$25,000 /= 0.3 Solve the problem using Excel Solver. Hint: You will need to start with decision variable values that are greater than O for Solver to find a solution. If required, round your answers to two decimal places. Optimal Solution: $80 $50 $70 $160 $135 $125 Q2= 03- If required, round your answer to the nearest dollar. Total cost = $

Cj- Si= ¡= B= N= unit cost of item/ cost per order placed for item/ inventory carrying charge as a percentage of the cost per unit the maximum amount of investment in goods number of items In the objective function, the first term is the annual cost of goods, the second is the annual ordering cost (D)/Q) is the number of orders) and the last term is the annual inventory holding cost (Q/2 is the average amount of inventory). Set up a spreadsheet model for the following data: Item Item 1 2 2000 2000 Item 3 1.500 Annual Demand Item Cost Order Cost B-$25,000 /= 0.3 Solve the problem using Excel Solver. Hint: You will need to start with decision variable values that are greater than O for Solver to find a solution. If required, round your answers to two decimal places. Optimal Solution: $80 $50 $70 $160 $135 $125 Q2= 03- If required, round your answer to the nearest dollar. Total cost = $

ENGR.ECONOMIC ANALYSIS

14th Edition

ISBN:9780190931919

Author:NEWNAN

Publisher:NEWNAN

Chapter1: Making Economics Decisions

Section: Chapter Questions

Problem 1QTC

See similar textbooks

Similar questions

The following data pertain to products A and B, both of which are purchased by Madame X. Initially, the prices of the products and quantities consumed are: PA = $10, QA = 3, PB = $10, QB = 7. Madame X has $100 to spend per time period. After a reduction in price of B, the prices and quantities consumed are: PA = $10, QA = 2.5, PB = $5, QB = 15. Assume that Madame X maximizes utility under both price conditions above. Also, note that if after the price reduction enough income were taken away from Madame X to put her back on the original indifference curve, she would consume this combination of A and B: QA = 1.5, QB = 9 Determine the change in consumption rate of good B due to (1) the substitution effect and (2) the income effect. Determine if product B is a normal, inferior, or Giffen good. Explain.
List the chief advantages and shortcomings of using breakeven analysis in pricing decisions. Breakeven analysis is a means of determining the number of goods or services that must be sold at a given price to generate revenue sufficient for covering total costs. It is easily understood by managers and may help them decide whether required sales levels for a certain price are realistic goals. Its shortcomings are as follows. First, the model assumes cost can be divided into fixed and variable categories and ignores the problems of arbitrarily making some allocations. Second, it assumes that per-unit variable costs do not change at different levels of operation, ignoring the possibility of quantity discounts, more efficient use of the workforce, and other possible economies. Third, the basic breakeven model does not consider demand. It is a cost-based model and fails to directly address the crucial question of whether consumers will actually purchase the product at the specified price and…
ATV is a price-setting firm and estimates the demand for its cement using a demand function in the linear form: Q = f( P, M, PR) where Qc = demand for cement/month (in yards) Pc = the price of cement per yard, M = country’s tax revenues per capita, and PR = the price of asphalt per yard. DEPENDENT VARIABLE Qc R- SQUARE P- VALUE ON F 64 0.8093 0.0001 INDEPENDENTVARIABLE PARAMETER ESTIMATE STANDARD ERROR T-RATIO P-VALUE INTERCEPT 8.20 4.01 2.04 0.0461 PC -3.54 1.64 -2.16 0.0357 M 0.64287 0.19 3.38 0.0014 PA 0.7854 0.38 2.07 0.0439 10. Write the resulting regression equation.
The quantity demanded each month of Russo Espresso Makers is 250 when the unit price is $140. The quantity demanded each month is 1000 when the unit price is $110. The suppliers will market 750 espresso makers when the unit price is $76 or higher. At a unit price of $96, they are willing to market 2250 units. Both the supply and demand equations are known to be linear. (a) Find the demand equation. P = (b) Find the supply equation. p= (c) Find the equilibrium quantity and the equilibrium price. units $
Using a linear specification, you estimate your demand curve to equal Q=10-5P+20C+2A, where • Q = the quantity demanded of your product • P = the price of your product • C = college-ratio, which is the percentage of the local population that attends college. For instance, C=0.10 would indicate 10% of the local population attends a college. • A = digital advertising spend (in thousands of dollars) What is your demand elasticity with respect to the college-ratio when your price is $5, your digital advertising spend is $100,000 (i.e. A=100), and the college-ratio equals 0.25? a. εQ,C=0.0013 b. εQ,C=0.0263 c. εQ,C=20 d. εQ,C=15200
The demand function for a car manufacturing firm is presented as follows:- Q=−500P+210Px+200P+20pop-1,000,000i+600A Where, Q =Demand for firm′s car; P = Price of Domestic Manufacturers; PX = Price of New Luxury Cars; I = Disposable Income per Household; Pop = Population; I = Interest Rates; A = Advertising Campaign Explain the extent to which demand changes when any of the independent variables changes.
Demand function: Qdt = 160 − 0.8PtSupply function: Qst = -20 + 0.4Pt−1and when P0 = 160a) A good should be designed in accordance with demand and supply,The equilibrium price is 160. Find the time path of the equilibrium price of this good.b) Comment on the use of this time path. Draw the passage of the time path.
Mattel has conducted studies to determine the best price to set for their Barbie doll figures. Based on data received through these studies, it was calculated that Mattel could sell 3,000 Barbie dolls at a set price of $17.99. However, it was also determined that if the price per doll was reduced to $9.99, they could sell an additional 2,000 Barbie dolls. Find the linear demand equation (price function, y) as a function of the quantity, x, sold.
The demand and supply of pizza is defined by the following equations: Qd = D(P, Y ) = 1 + Y − 2P Qs = D(P, PM) = 2 P/PM where, Qd is quantity demand, P is the price of each pizza sold, Y is the average income of consumers, Qs is the quantity supplied, and Pm is the price of inputs used in the production of pizza. (a) List the endogenous and exogenous variables of this model (b) Find the equilibrium price Pe and quantity Qe of pizza as a function of the exogenous variables. (c) Use a simple demand and supply diagram to show what happens to the equilibrium price and quantity when there is an increase in one of the exogenous variables.
A firm orders 12, 30 and 25 items of goods G1, G2 and G3. The cost of each item of G1, G2 and G3 is $8, $30 and $15, respectively.(a) Write down suitable price and quantity vectors, and use matrix multiplication to work out the total cost of the order.(b) Write down the new price vector when the cost of G1 rises by 20%, the cost of G2 falls by 10% and the cost of G3 is unaltered. Use matrix multiplication to work out the new cost of the order and hence find the overall percentage change in total cost.
Hasbro conducted market research to determine the optimal price to set for their Furby toys. Through many focus groups, they determined they could sell 5,000 furbies at a price of $29.99. However, if they lowered their price to $19.99, they could sell 4,000 more furbies. Find the linear demand equation (price function, y) as a function of the quantity, x, sold. (round to 4 decimal places if necessary)
The demand function for a certain product is determined by the fact that the product of the price and the quantity demanded equals 8000. The product currently sells for $2.20 per unit. Suppose manufacturing costs are increasing over time at a rate of 18% and the company plans to increase the price p at this rate as well. Find the rate of change of demand over time. Find the demand function represented in this problem where p is the price of the product and q is the quantity demanded for the product. (Type an equation.)