Business, 18.02.2021 21:30 natalie2sheffield

A manufacturing firm has discontinued production of a certain unprofitable product line. Considerable excess production capacity was created as a result. Management is considering devoting this excess capacity to one or more of three products: X1, X2, and X3. Machine hours required per unit are:
Machine Type X1 X2 X3
Milling Machine 8 2 3
Lathe 4 3 0
Grinder 2 0 1
The available time in machine hours per week is
Machine Hours per Week
Milling Machine 800
Lathe 480
Grinder 320
The salespeople estimate they can sell all the units of X1 and X2 that can be made. But the sales potential of X3 is 80 units per week maximum. Unit profits for the three products are Unit Profits X1 $20 X2 6 X3 8 Set up the equations that can be solved to maximize the profit per week.
a) Write the mathematical formulation to maximize the profit per week (Decision variables: Production amount of X1, X2, and X3) )b) Solve the mathematical formulation using Excel Solver. Show your work in Sheet "Problem 4b."c) What is the optimal solution?

Answers: 2

Show answers

Another question on Business

Business, 22.06.2019 11:50

The following are the current month's balances for abc financial services, inc. before preparing the trial balance. accounts payable $ 10,000 revenue 6,000 cash 3,000 expenses 17,500 furniture 10,000 accounts receivable 14,000 common stock ? notes payable 6,500 what amount should be shown for common stock on the trial balance? a. $48.000b. $12.500c. $27.000d. $28.000

Answers: 3

Answer

Business, 22.06.2019 20:30

The smelting department of kiner company has the following production and cost data for november. production: beginning work in process 3,700 units that are 100% complete as to materials and 23% complete as to conversion costs; units transferred out 10,500 units; and ending work in process 8,100 units that are 100% complete as to materials and 41% complete as to conversion costs. compute the equivalent units of production for (a) materials and (b) conversion costs for the month of november.

Answers: 3

Answer

Business, 22.06.2019 21:20

Rediger inc., a manufacturing corporation, has provided the following data for the month of june. the balance in the work in process inventory account was $28,000 at the beginning of the month and $20,000 at the end of the month. during the month, the corporation incurred direct materials cost of $56,200 and direct labor cost of $29,800. the actual manufacturing overhead cost incurred was $53,600. the manufacturing overhead cost applied to work in process was $52,200. the cost of goods manufactured for june was:

Answers: 2

Answer

Business, 23.06.2019 02:20

Required information lansing company’s 2017 income statement and selected balance sheet data (for current assets and current liabilities) at december 31, 2016 and 2017, follow. lansing company income statement for year ended december 31, 2017 sales revenue $130,200 expenses cost of goods sold 53,000 depreciation expense 17,500 salaries expense 29,000 rent expense 10,100 insurance expense 4,900 interest expense 4,700 utilities expense 3,900 net income $7,100 lansing company selected balance sheet accounts at december 31 2017 2016 accounts receivable $6,700 $8,000 inventory 3,080 2,090 accounts payable 5,500 6,800 salaries payable 1,100 810 utilities payable 440 270 prepaid insurance 370 500 prepaid rent 440 290 required: prepare the cash flows from operating activities section only of the company’s 2017 statement of cash flows using the indirect method. (amounts to be deducted should be indicated with a minus sign.)

Answers: 1

Answer

You know the right answer?

A manufacturing firm has discontinued production of a certain unprofitable product line. Considerabl...

Questions