Question

NEED TO ACTUALLY HAVE THE EXCEL DOCUMENT OR I WILL FAIL THE QUESTION. CANT BE SCREENSHOT...

NEED TO ACTUALLY HAVE THE EXCEL DOCUMENT OR I WILL FAIL THE QUESTION. CANT BE SCREENSHOT

Attach the excel document please

1. Create the model and use Excel Solver to answer the following: A computer company manufactures two types of computers. Each type of computer will require assembly time, inspection time, and storage space. The amounts of each of these resources that can be devoted to the production of the computers is limited. The manager wants to determine the quantity of each computer to produce to maximize the profit generated by sales of these computers.

In order to develop a suitable model of the problem, the manager has met with design and manufacturing personnel. As a result of those meetings, the manager has obtained the following information:

Type 1 Type 2

Profit per unit $60 $75

Assembly time per unit 4 hours 10 Hours

Inspection time per unit 30 minutes 20 minutes

Storage space per unit 3 cubic feet 3 cubic feet

The manager has also acquired information on the availability of resources. These daily amounts are:

Resource Amount  available

Assembly time 100 hours

Inspection time 22 hours

Storage Space 39 cubic units

The manager also met with the firm's marketing manager and learned that demand for the microcomputers was such that whatever combination of these two types of computers is produced, all the output can be sold.

a. What is the mix of computers that the company should produce if they want to maximize profits?

b. What is the optimal value for profit using the mix from part a.?

c. If type 2 computer became twice as profitable (i.e. profit rose from $75 each to $150 each), would the solution change? If so, what is the new solution (please state the mix and the new profit amount)?

Homework Answers

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
A computer company manufactures two types of computers. Each type of computer will require assembly time,...
A computer company manufactures two types of computers. Each type of computer will require assembly time, inspection time, and storage space. The amounts of each of these resources that can be devoted to the production of the computers is limited. The manager wants to determine the quantity of each computer to produce to maximize the profit generated by sales of these computers. In order to develop a suitable model of the problem, the manager has met with design and manufacturing...
Harriet is trying to determine how many units of two types of lawn mowers to produce...
Harriet is trying to determine how many units of two types of lawn mowers to produce each day. One of these is the Standard model, while the other is the Deluxe model. The profit per unit on the Standard model is $60, while the profit per unit on the Deluxe model is $40. The Standard model requires 20 minutes of assembly time, while the Deluxe model requires 35 minutes of assembly time. The Standard model requires 10 minutes of inspection...
Complete in Excel: A manufacturer produces four parts: XJ201, XM897, TR29, and BR788. The net profit...
Complete in Excel: A manufacturer produces four parts: XJ201, XM897, TR29, and BR788. The net profit per unit are $9, $12, $15, and $11 respectively. The products are each processed in the wiring and drilling departments then go to assembly. The final step in the plant is a final inspection. The time in minutes spent at each of the four departments is listed in the following table:                         Wiring             Drilling            Assembly        Inspection XJ201             30                    180                  120                  30 XM897           90                    60                   ...
A manufacturer produces four parts: XJ201, XM897, TR29, and BR788. The net profit per unit are...
A manufacturer produces four parts: XJ201, XM897, TR29, and BR788. The net profit per unit are $9, $12, $15, and $11 respectively. The products are each processed in the wiring and drilling departments then go to assembly. The final step in the plant is a final inspection. The time in minutes spent at each of the four departments is listed in the following table:                         Wiring             Drilling            Assembly        Inspection XJ201             30                    180                  120                  30 XM897           90                    60                    240                  60 TR29              ...
Ahmadi, Inc. manufactures laptop and desktop computers. In the upcoming production period, Ahmadi needs to decide...
Ahmadi, Inc. manufactures laptop and desktop computers. In the upcoming production period, Ahmadi needs to decide how many of each type of computers should be produced to maximize profit. Each computer goes through two production processes. Process I, involves assembling the circuit boards and process II is the installation of the circuit boards into the casing. Each laptop requires 24 minutes of process I time and 16 minutes of process II time. Each desktop requires 8 minutes of process I...
The sandwich company, Alamo Lone Star (ALS) prepares sandwiches for sale in vending machines in a...
The sandwich company, Alamo Lone Star (ALS) prepares sandwiches for sale in vending machines in a large number of locations in an urban area. The four types of sandwich that are now provided are those that have been found to sell well. The following information is available on each type: Type of sandwhich Decision Variables Min. No of units sold Preparation time per unit (minutes) Profit per unit ($) Tuna Mayo T 200 0.40 0.42 Ham and Cheese H 200...
Question 1 Activity Based Costing for Kota Mills (25 marks) Kota Mills supply Divine Denim with...
Question 1 Activity Based Costing for Kota Mills Kota Mills supply Divine Denim with the organic denim used in their production. After discussions with Helen about the service she was getting from Good Numbers, the manager of Kota Mills decided to use Good Numbers to assist with their management decision making. Kota Mills produces three different weights of denim using two departments. In Department 1, machines weave the cloth. In Department 2 the cloth is dyed a variety of colours....
Notes: Requested info from Excel file must be copied/pasted (as picture) to Word File. Neatness matters,...
Notes: Requested info from Excel file must be copied/pasted (as picture) to Word File. Neatness matters, the sloppy presentation will be penalized even if your answers are correct.             Snow White and the Seven Dwarfs Snow White Corporation makes is well known for making children’s toy products. Presently the firm is planning to develop an optimal production schedule to manufacture seven of their popular products - Grumpy, Dopey, Doc, Happy, Bashful, Sneezy, and Sleepy. Relevant product information is provided below....
**This is the full question, but I only need the Contribution Margin, Sales Mix and Target...
**This is the full question, but I only need the Contribution Margin, Sales Mix and Target Profit. Cover-to-Cover Company is a manufacturer of shelving for books. The company has compiled the following cost data, and wants your help in determining the cost behavior. After reviewing the data, complete requirements (1) and (2) that follow. Units Total Total Total Machine Produced Lumber Cost Utilities Cost Depreciation Cost 13,000 shelves $156,000 $15,950 $145,000 26,000 shelves 312,000 30,900 145,000 52,000 shelves 624,000 60,800...
Need to see step by step solutions Please: Solve Problem and Applications: ch 13- prob 7...
Need to see step by step solutions Please: Solve Problem and Applications: ch 13- prob 7 [Klein Industries manufactures three types of portable air compressors] in page 451 at the end of chapter 13 in your textbook, USA 5th edition. The data is given as part of the question. There is no external data set provided. Use what is given by the problem. You need to submit a formal APA paper to explain all your findings together with your Excel...