Business, 16.10.2020 14:01, mima851

Acme Inc. produces computers for the PC market. They can produce four types of computers at their factory. These are discount desktops, discount laptops, premium desktops, and premium laptops. Acme Inc. would like your assistance in using Excel’s Solver function in determining how many of each type of computer they should produce in order to maximize profit. You are provided information about the number of hours required to make each type of computer as well as the unit revenue on each type of computer.

Hours Unit Revenue
Discount desktops 2 $600
Discount laptops 3 $800
Premium desktops 3 $1000
Premium laptops 5 $1300

You are also provided with the market demand for various categories of computers. In performing the analysis, the number of each type of computer produced should not exceed the demand for that type of computer.

Total demand for desktop computers: 800 Total demand for laptop computers: 900
Total demand for discount computers: 700 Total demand for premium computers: 1000

You are also told that the hourly labor cost is $20 and the total labor-hours available are 4500. The total labor hours used should not exceed the total labor hours available.

Required:
Determine the optimal number of each type of computer to produce while maximizing profit (total revenue-labor cost).

Answers: 2

Show answers

Other questions on the subject: Business

Business, 22.06.2019 11:10, Emmaxox715

Yowell company granted a sales discount of $360 to a customer when it collected the amount due on account. yowell uses the perpetual inventory system. which of the following answers reflects the effects on the financial statements of only the discount? assets = liab. + equity rev. − exp. = net inc. cash flow a. (360 ) = na + (360 ) (360 ) − na = (360 ) (360 ) oa b. na = (360 ) + 360 360 − na = 360 na c. (360 ) = na + (360 ) (360 ) − na = (360 ) na d. na = (360 ) + 360 360 − na = 360 na

Answers: 1

continue

Business, 22.06.2019 11:20, leshayellis1591

Lusk corporation produces and sells 14,300 units of product x each month. the selling price of product x is $25 per unit, and variable expenses are $19 per unit. a study has been made concerning whether product x should be discontinued. the study shows that $72,000 of the $102,000 in monthly fixed expenses charged to product x would not be avoidable even if the product was discontinued. if product x is discontinued, the annual financial advantage (disadvantage) for the company of eliminating this product should be:

Answers: 1

continue

Business, 22.06.2019 11:30, avhobby3

Which of the following is not an example of one of the four mail advantages of prices on a free market economy

Answers: 1

continue

Business, 22.06.2019 12:30, bcarri4073

M. cotteleer electronics supplies microcomputer circuitry to a company that incorporates microprocessors into refrigerators and other home appliances. one of the components has an annual demand of 235 units, and this is constant throughout the year. carrying cost is estimated to be $1.25 per unit per year, and the ordering (setup) cost is $21 per order. a) to minimize cost, how many units should be ordered each time an order is placed? b) how many orders per year are needed with the optimal policy? c) what is the average inventory if costs are minimized? d) suppose that the ordering cost is not $21, and cotteleer has been ordering 125 units each time an order is placed. for this order policy (of q = 125) to be optimal, determine what the ordering cost would have to be.

Answers: 1

continue

Do you know the correct answer?

Acme Inc. produces computers for the PC market. They can produce four types of computers at their fa...