Reference no: EM133041028
PC Production
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.
Using Solver, determine the optimal number of each type of computer to produce while maximizing profit (total revenue-labor cost). Pay special attention to constructing a well designed worksheet with a clear and logical layout, appropriately labeled. Be sure to specify all the constraints listed in a Constraints section in the worksheet. In addition, keep in mind that the number of computers produced should be greater than or equal to zero and these should be integers since we cannot produce fractional numbers of computers. Label your worksheet 5-PC Production. On completing the exercise, create an Answer Report as well for your solution.
Note: please make work on excel be as clear as possible and show solver constraints and steps utilized
|
Resolve a dispute between confrontational stakeholders
: Read the extract below and answer all questions that follow. According to the (PMBOK) Project Management Body of Knowledge Guide (2017:359) "Project Communicati
|
|
Determine what is Red Corporation expected rate of return
: Red Corporation is a holding company with four main subsidiaries. Determine what is Red Corporation expected rate of return on these portfolios
|
|
Manufacturing presence in numerous countries
: You were recently hired by ThunderCat Corporation, a major aircraft producer with a manufacturing presence in numerous countries.
|
|
Calculate the net present value
: The investment in net working capital will amount to R475 000,00. Calculate the net present value
|
|
Find pc production
: Acme Inc. produces computers for the PC market. They can produce four types of computers at their factory. These are discount desktops, discount laptops, premiu
|
|
Different between swot analysis and portfolio analysis
: What is the different between swot analysis and portfolio analysis? Mention reference
|
|
Calculate the current price
: Calculate the current price of a $5,000 par value bond that has a coupon rate of 10 percent, pays coupon interest quarterly
|
|
Explain the regulatory and organisational obligations
: Identify and explain the regulatory and organisational obligations and requirements do you need to consider when preparing your presentation?
|
|
Five core processes in a firm
: Course text: Krajewski, L., Malhotra, M., & Ritzman, L. (2019). Operations management: processes and supply chains (12th ed.). Upper Saddle River, NJ: Pears
|