Write a paragraph to explain to your CEO that based on using regression analysis, through using the solver tool of excel, recalculate the optimum units to produced this month is 800 pro 200 mini to have the maximize revenue of $174,400.00. Explain what/why would it be if you make any changes in the units to stay within the constraints that you have it would produce less money. FileLA From AccessFrom WebFrom TextF102Home Insert Page Layout3From OtherSourcesGet External Data5A4 Number to Make⠀6 Required Inputs7 Labor Hours8 Ship setsX1011 Unit Profit121314Formulas DataShow QueriesFrom Table##NewExistingConnections Query Recent SourcesGet & Transform9 Electronic Componentsfxx =B11*B4+C11*C4ProBсDMini800200Used692000111510$182.00 $139.00ReviewConnectionsPropertiesRefreshAll-Edit LinksConnectionsEView6600 <=1000 <=14000 <=FTell me what you want to do...x ClearAvailable222Sort7000100014000TOTAL PROFIT $173,400.00GFilterSort & FilterReapplyAdvancedHE88FlashText toRemove Data Consolidate Relationships ManageColumns Fill Duplicates ValidationData ModelCEAIJData ToolsKLMtottBY18:3418+What-If Forecast Group Ungroup SubtotalAnalysis SheetForecastΣΓΕNOOutlinePSign in Share?, SolverAnalyzeQ

In order to maximize revenue, it is important to consider the impact of changes made to the units…

Write a paragraph to explain to your CEO that based on using regression analysis, through using the solver tool of excel, recalculate the optimum units to produced this month is 800 pro 200 mini to have the maximize revenue of $174,400.00. Explain what/why would it be if you make any changes in the units to stay within the constraints that you have it would produce less money.

Write a paragraph to explain to your CEO that based on using regression analysis, through using the solver tool of excel, recalculate the optimum units to produced this month is 800 pro 200 mini to have the maximize revenue of $174,400.00. Explain what/why would it be if you make any changes in the units to stay within the constraints that you have it would produce less money.

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

What are their implications for cost and return?
The change in fotal costjof production as the output or total product of the business is expanded is: LOTHE Marginal cost (b) The Total variable cost (c) Average variable cost ( Average fixed cost
c) What is the monthly profit or loss if the company stays with Clunker and sells 90,000 bags per month? The monthly profit or loss if the company stays with Clunker and sells 90,000 bags per month is $enter your response here. (Round your response to the nearest dollar and include a minus sign if necessary.)
Please help me
5. Costs in the short run versus in the long run Ike's Bikes is a major manufacturer of bicycles. Currently, the company produces bikes using only one factory. However, it is considering expanding production to two or even three factories. The following table shows the company's short-run average total cost (SRATC) each month for various levels of production if it uses one, two, or three factories. (Note: Q equals the total quantity of bikes produced by all factories.) Number of Factories 1 2 3 Q = 100 Q 200 440 280 380 480 620 800 Average Total Cost (Dollars per bike) Q = 300 Q = 400 240 320 240 240 320 240 Q = 500 480 380 280 Q = 600 800 620 440 Suppose Ike's Bikes is currently producing 100 bikes per month in its only factory. Its short-run average total cost is $ per bike. Suppose Ike's Bikes is expecting to produce 100 bikes per month for several years. In this case, in the long run, it would choose to produce bikes using On the following graph, plot the three SRATC curves for…
SuProse a liim hus revenue R=15t- 5q2 und (Ost (= 93-13.5e+ 50+ 40. Make a sketch of average Variable cOst, marginal (ost and maigina fevenue.
Assume you were hired as a Production Engineer in a global Bearing Manufacturer company and given the following inputs: Equipment Maintenance Cost per Month Utilities Cost per Month Material Cost per Unit Labor Cost per Unit Selling Price per Unit S60,000.00 $12.000.00 $12.00 $3.00 $24.00 Calculate Total Fixed Cost per Month Calculate Total Variable Cost per Unit = Calculate number of Units to be sold to reach Break-Even Point = Calculate number of Units that must be sold to eam profit of $90,000.00
Ike's Bikes is a major manufacturer of bicycles. Currently, the company produces bikes using only one factory. However, it is considering expanding production to two or even three factories. The following table shows the company's short-run average total cost each month for various levels of production if it uses one, two, or three factories. (Note: Q equals the total quantity of bikes produced by all factories.) Number of Factories Q = 100 Q = 200 520 400 660 480 800 560 1 2 3 Average Total Cost (Dollars per bike) Q = 300 Q = 400 320 400 320 320 400 320 Q = 500 560 480 400 Q = 600 800 660 520 Suppose Ike's Bikes is currently producing 100 bikes per month in its only factory. Its short-run average total cost is $ per bike. Suppose Ike's Bikes is expecting to produce 100 bikes per month for several years. In this case, in the long run, it would choose to produce bikes using On the following graph, plot the three short-run average total cost curves (SRATC) for Ike's Bikes from the…
Assume you were hired as a Production Engineer in a global Bearing Manufacturer company and given the following inputs: Equipment Maintenance Cost per Month Utilities Cost per Month Material Cost per Unit Labor Cost per Unit Selling Price per Unit S60,000.00 $12,000.00 $12.00 $3.00 $24.00 Calculate Total Fixed Cost per Month = Calculate Total Variable Cost per Unit = Calculate number of Units to be sold to reach Break-Even Point = Calculate number of Units that must be sold to eam profit of $90,000.00 =
(a) What do you mean by inventory carrying cost and ordering cost? Explain with examples. 2(b) Mr Mahmud operates a cosmetics shop at Dhanmondi. The annual demand for soap is 2,500 units. The setup cost is Tk.15 per order. The material cost per unit Tk.3 and the holding cost 10% of average inventory.. a) What is the optimum number of units per order? (Use EOQ formula)b) What is the expected number of orders per year if management considers the followings units for order placement: 100 units, 250 units, 500 units and 1250 units?(Use comparative tabular format)
How do I determine variable cost? Only typed solution
Only typed answer