Cox Electric makes electronic components and has estimated the following for a new design of one of its products:Fixed Cost = $3,000Material cost per unit = $0.15Labor cost per unit = $0.10Revenue per unit = $0.65Production Volume = 12,000Per-unit material and labor cost together make up the variable cost per unit. Assuming that Cox Electric sells all it produces, build aspreadsheet model that calculates the profit by subtracting the fixed cost and total variable cost from total revenue, and answer thefollowing questions.(a) Construct a one-way data table with production volume as the column input and profit as the output. Breakeven occurs whenprofit goes from a negative to a positive value; that is, breakeven is when total revenue = total cost, yielding a profit of zero.Vary production volume from 5,000 to 50,000 in increments of 5,000. In which interval of production volume does breakevenoccur?tounits

We have to solve the given problem using the excel because excel give best spreadsheet table as…

Answered: Cox Electric makes electronic…

Advanced Engineering Mathematics

10th Edition

ISBN:9780470458365

Author:Erwin Kreyszig

Publisher:Erwin Kreyszig

Chapter2: Second-order Linear Odes

Section: Chapter Questions

Problem 1RQ

See similar textbooks

Similar questions

Agnes, a General Manager in XXX Company, estimated a multiplicative demand function of the form: using a cross-section data collected in the company sales on 30th June, 2019. The estimation results are as follows: (SEE IMAGE) Write down the estimated demand equation Interpret the coefficients and R2 value Describe any three managerial decisions that can be applied by the manager from the estimated demand function
Consider following relations on the set of positive integer: R₁ = {(a,b) | a> b} R₂ = {(a,b) | a = b+3} R3 = {(a,b) | a+b>4} a) Which of these relations are symmetric and why? If not symmetric give counter example. b) Which of these relations are reflexive and why? If not symmetric give counter example.
Yaster Breakfast Supplies is planning to manufacture and market a new toaster. After conducting extensive market surveys, the research department provides the following estimates: • a weekly demand of 302 at a price of $14 per toaster • a weekly demand of 196 at a price of $17 per toaster The financial department estimates that weekly fixed costs will be $1,438 and variable costs (cost per unit) will be $5. Assume: • the relationship between price and demand is linear • the cost function in linear Use your models to predict the marginal profit when Yaster is producing and selling 265 toasters per week. Round to the nearest cent. $ per toaster
3. The chief economist for Argus Corporation, a large appliance manufacturer, estimated the firm's short-run cost function for vacuum cleaners using an average variable cost function of the form AVC = a + bQ + cQ² where AVC = dollars per vacuum cleaner and Q = number of vacuum cleaners pro- duced each month. Total fixed cost each month is $180,000. The following results were obtained: DEPENDENT VARIABLE: AVC R-SQUARE F-RATIO P-VALUE ON F OBSERVATIONS: 19 VARIABLE INTERCEPT Q Q2 Show Transcribed Text PARAMETER ESTIMATE 191.93 -0.0305 0.0000024 Ĵ 0.7360 STANDARD ERROR 54.65 39.428 T-RATIO 3.512 0.00789 23.866 0.00000098 2.449 0.0001 P-VALUE 0.0029 0.0014 0.0262 a. Are the estimates â, b, and ĉ statistically significant at the 2 percent level of significance? b. Do the results indicate that the average variable cost curve is U-shaped? How do you know? c. If Argus Corporation produces 8,000 vacuum cleaners per month, what is the estimated average variable cost? Marginal cost? Total…
The supply and demand curves for a product are given in the figure below. p($/unit) Supply 20 16 12 8 4. Demand q (quantity) 160 320 480 640 800 Estimate the equilibrium price and quantity and the consumer and producer surplus. Equilibrium price = units Equilibrium quantity = $ i at equilibrium. Consumer surplus = $ i at equilibrium. Producer surplus = %24
The cost of goods sold for Veltron International last year amounted to $561,000, and the average inventory at cost was $374,000. The published inventory turnover at cost is 6.6. Calculate the inventory turnover at cost, and if it is less than the published rate, calculate the target average inventory at cost (in $). (If the actual turnover is greater than the published rate, enter "above" for target average inventory.) Inventory turnover at cost: Target average inventory at cost:
need comprehensive and correct answers.This question is about optimization.
Suppose demand is given by p = 1600 − x. Find the maximum revenue.
Q-1 A manufacturer of microcomputers produces three different models. The following table summarizes whole sale process material cost per unit, and labor cost per unit. The annual fixed cost is Rs. 10 Million. But manufacturer decided that fifty percent more annual costs would be include in its sanarios and the fixed cost 4400, 8000 and 3500 are also included each of three models. Product Туре 1 Туре 2 Туре 3 Whole Sale Price/ Unit Rs. 950 1000 1500 Material Cost/Unit 200 300 230 Labor Cost/Unit 175 150 450 Required: i) Determine a joint total revenue function for the sales of the three different microcomputer models. ii) iii) iv) Determine a total cost function for manufacturing the three models. Determine the profit function for sale of the three models. What is annual profit, if the firm sells 60,000, 13000 and units of three models? 100400 v) Also graphically present all functions.
Suppose you are the marketing manager of a firm, and you plan to introduce a new product to the market. You have to estimate the first year net profit, which depends on several variables • Sales volume (in units) • Price per unit • Unit cost . Fixed costs Your net profit is net profit = sales volume x (price per unit-unit cost) - fixed cost The fixed cost is $120, 000, but other factors have some uncertainty. Based on your market research, there are equal chance that the market will be slow, ok, or hot. • Slow market the sales volume follows Poisson distribution with mean 50,000 units product, and the average price per unit is $11.00 ● Ok market the sales volume follows Poisson distribution with mean 75,000 units product, the average price per unit is $10.00 Hot market: the sales volume follows Poisson distribution with mean 100,000 units product, but the competition is severe so you expect the average price per unit is just $8.00 No matter what the market type is, your average unit…
Yaster Breakfast Supplies is planning to manufacture and market a new toaster. After conducting extensive market surveys, the research department provides the following estimates: • a weekly demand of 318 at a price of $13 per toaster • a weekly demand of 201 at a price of $16 per toaster The financial department estimates that weekly fixed costs will be $1,399 and variable costs (cost per unit) will be $3. Assume: • the relationship between price and demand is linear • the cost function in linear Use your models to predict the marginal profit when Yaster is producing and selling 271 toasters per week. Round to the nearest cent. $ per toaster
A manufacturer of microcomputers produces three different models. The following table summarizes wholesale prices, materials cost per unit, and labor cost per unit. Annual fixed costs are $20 million. Model-1Model-2Model-3 Wholesale price / Unit (in dollars)$700$8000$1000 Material cost / Unit(in dollars)185500850 Labor cost / unit(in dollars)150200325 Determine a joint total revenue function for sale of the three different microcomputers models.Determine an annual total cost function for the manufacturing the three models.Determine the profit function for sales of the three models.What is the annual profit if the firm sells 20,000, 40,000, and 10,000 units, respectively, of the three models RubricsUses information appropriately: 0.5Applies appropriate procedures: 0.5Answers the problem: 0.25

SEE MORE QUESTIONS

Recommended textbooks for you

Advanced Engineering Mathematics

Advanced Math

ISBN:

9780470458365

Author:

Erwin Kreyszig

Publisher:

Wiley, John & Sons, Incorporated

Numerical Methods for Engineers

Advanced Math

ISBN:

9780073397924

Author:

Steven C. Chapra Dr., Raymond P. Canale

Publisher:

McGraw-Hill Education

Introductory Mathematics for Engineering Applicat…

Advanced Math

ISBN:

9781118141809

Author:

Nathan Klingbeil

Publisher:

WILEY

Advanced Engineering Mathematics

Advanced Math

ISBN:

9780470458365

Author:

Erwin Kreyszig

Publisher:

Wiley, John & Sons, Incorporated

Numerical Methods for Engineers

Advanced Math

ISBN:

9780073397924

Author:

Steven C. Chapra Dr., Raymond P. Canale

Publisher:

McGraw-Hill Education

Introductory Mathematics for Engineering Applicat…

Advanced Math

ISBN:

9781118141809

Author:

Nathan Klingbeil

Publisher:

WILEY

Mathematics For Machine Technology

Advanced Math

ISBN:

9781337798310

Author:

Peterson, John.

Publisher:

Cengage Learning,

Basic Technical Mathematics

Advanced Math

ISBN:

9780134437705

Author:

Washington

Publisher:

PEARSON

Topology

Advanced Math

ISBN:

9780134689517

Author:

Munkres, James R.

Publisher:

Pearson,

SEE MORE TEXTBOOKS