solve it via excel solver 3. Drexel Office Supply makes two types of staplers: manual and electric. Both staplers use the samespring mechanism, but the manual stapler uses a red cover and a solid metal base, whereas the electricstapler uses a black cover and a clear plastic base. Drexel expects to sell 7,000 manual staplers and5,000 electric staplers during the next quarter, which is an unusually high demand for them. To meetthe demand for the next quarter, Drexel has 500 manufacturing hours available. To meet demand,they will need to outsource some parts. During in-house production, Drexel incurs a fixed cost forsetup and a variable cost for manufacturing. For outsourced units, Drexel only incurs a purchase cost.These costs, as well as the manufacturing time per unit for in-house production as given in the tablebelow:PartFixed CostVariable Cost Purchase Cost ManufacturingTime per Unit(min.)Spring Mechanism$1,000$0.40$0.650.9Red Cover$1,200$2.90$3.452.2Black Cover$1,900$3.15$3.703Solid Metal Base$1,500$0.30$0.500.8Clear Plastic Base$1,500$0.55$0.701Help Drexel minimize their total cost of meeting demand.

REQUIRED: The Task: Drexel Office Supply needs to minimize total cost while meeting demand for…

Answered: 3. Drexel Office Supply makes two types…

Linear Algebra: A Modern Introduction

4th Edition

ISBN:9781285463247

Author:David Poole

Publisher:David Poole

Chapter2: Systems Of Linear Equations

Section2.4: Applications

Problem 28EQ

See similar textbooks

Similar questions

2.Irwin textile produce 2 cloth - denim and corduroy. Corduroy requires 7.5 pounds cotton and denim requires 5 pounds of cotton. Corduroy needs 3.2 hours processing time and denim needs 3 hours processing time. Maximum Demand of denim is 510 yards per month. The manufacturer has 6500 pounds of cotton and 3000 hours of processing time. The manufacturer makes profit of $2.25 from denim and $3.1 from corduroy. A. To maximize profit, formulate the linear programming model B.Solve the problem using computer soluton
The Lawson Fabric Mill Produces five different fabrics. Each fabric can be woven on one or more of the mill’s 36 looms. The sales department’s forecast of demand for the next month is shown in below Table 1, along with data on the selling price per yard, variable cost per yard, and purchase price per yard. The mill operates 24 hours a day and is scheduled for 30 days during the coming month. The mill has two types of looms: draw and regular. The draw looms are more versatile and can be used for all five fabrics. The regular looms can produce only three of the fabrics. The mill has a total of 36 looms: 8 are draw and 28 are regular. The rate of production for each fabric on each type of loom is given in below Table 2. The time required to change over from producing one fabric to another is negligible and does not have to be considered. The Lawson Fabric Mill satisfies all demand with either its own fabric or fabric purchased from another mill. Fabrics that cannot be woven at the…
3. Tamir has recently begun a new job of selling custom bracelets! Tamir's sales have been growing every week and now he is looking to analyze his profit. Specifically, Tamir is looking to find how much his cost of goods is for his business of selling bracelets. Luckily, Tamir sells each bracelet for the same price and has recorded that when he sold 4 bracelets he made a $39 profit, when he sold 9 bracelets he made a $94 profit. a. Write an equation in point slope form that could model this scenario. b. Which of the following could be the graph of Tamir's profit? Explain how you know. Graph 1: Graph 2: + +
If a $15 billion reduction in taxation produces an increase of $20 billion in output, the value of the government taxation multiplier is.. O0.75 O 0.33 O 0.75 O 1.33
Please read the case below. Smyrna University is a private university which is based in İzmir. Smyrna University has gained an excellent reputation for its post-graduate courses, and thus the University has attracted a large number of students who are interested in postgraduate studies and located in Southern and North-Western parts of Turkey. The fees paid by these students make an important contribution to the University’s annual budgeted income. To support the recruitment of students from North-Western and Southern Turkey, the University has established a small department to promote its courses and to liaise with education institutions in Southern and North-Western cities. However, this year there has been a noticeable reduction in the number of applications from Southern and North-Western parts of Turkey. The University authorities are unsure if this is because of the global economic downturn, or if there are other factors causing this reduction. They have decided to conduct…
Telefonika is a telecommunication company, located in the Accra Mall, selling mobile phones and accessories. Most of their new phones are ordered. But, Telefonika stocks three main phones for walk-in customers. Every week, they generate profit of GH¢600 from selling Galaxy S2, GH¢400 from Galaxy S3 and GH¢300 from Galaxy S4. The overall weekly cost of these types of phones are GH¢1,800, GH¢2,100 and GH¢1,200 respectively. This week, Telefonika has a budget of GH¢12,000 available to buy these three types of phones. During sales, each phone type must be unpacked, leading to 8 hours of unpacking time for S2 phones, 12 hours for S3 phones and 16 hours for S4 phones. The manager estimates that he and his workers have 120 labour hours available to unpack the three types of phones. Telefonika has enough space to order 20 phones this week. The manager also wants to stock at least twice as many S4 as S2 and S3 phones because S4 phones sell better.a) Formulate a linear programming model for this…
Formulate an IP that can be used to maximize Highland’s profit. How much more profit could be attained if Highland rented another 50 sq. ft. of floor space? How much should Highland be willing to pay for this extra footage? How much more profit could be attained if marketing changed their requirement so that only 40% of all appliances in stock be radios (keeping the floor space at 200 sq. ft.)? How much more profit could be attained if Highland was willing to have $3500 worth of capital tied-up (keeping the floor space at 200 sq. ft. and the marketing requirement at 40%)? How should Highland decide if it is worthwhile to increase this value?
Southeastern Oklahoma State University's business program has the facilities and faculty to handle an enrollment of 2,100 new students per semester. However, in an effort to limit class sizes to a "reasonable" level (under 200, generally), Southeastern's dean, Holly Lutze, placed a ceiling on enrollment of 1,800 new students. Although there was ample demand for business courses last semester, conflicting schedules allowed only 1,450 new students to take business courses. The utilization rate for Southeastern =% (enter your response as a percentage rounded to one decimal place). The efficiency rate for Southeastern =% (enter your response as a percentage rounded to one decimal place).
Dave Fletcher, the general manager of North Carolina Engineering Corporation (NCEC), thinks that his firm’s engineer-ing services contracted to highway construction firms are directly related to the volume of highway construction business contractedwith companies in his geographic area. He wonders if this is reallyso, and if it is, can this information help him plan his operationsbetter by forecasting the quantity of his engineering servicesrequired by construction firms in each quarter of the year? Thefollowing table presents the sales of his services and total amountsof contracts for highway construction over the past eight quarters: a) Using this data, develop a regression equation for predictingthe level of demand of NCEC’s services. b) Determine the coefficient of correlation and the standard errorof the estimate.
Happy Pet, Inc., is a large pet store located in Long Beach Mall. Although the store specializes in dogs, it also sells fish, turtle, and bird supplies. The Everlast Leader, a leather lead for dogs, costs Happy Pet $11 each. There is an annual demand for 4,000 Everlast Leaders. The manager, Stephan Wagner, has determined that the ordering cost is $40 per order and the carrying cost, as a percentage of unit cost, is 11%. Happy Pet is now considering a new supplier of Everlast Leaders. Each lead would cost only $10.45, but, in order to get this discount, Happy Pet would have to buy shipments of 3,000 at a time. Should Happy Pet use the new supplier and take this discount for quantity buying? The total cost without the discount is $ (round your response to the nearest whole number) The total cost with the discount is s (round your response to the nearest whole number). Should Happy Pet use the new supplier and take this discount for quantity buying? O No • Yes
Bruno Fruscalzo decided to start a small production facility in Sydney to sell gelato to the local restaurants. His local milk supplier charges $0.50 per kilogram of milk plus a $15 delivery fee (the $15 fee is independent of the amount ordered). Bruno's holding cost is $0.03 per kilogram per month. He needs 8,250 kilograms of milk per month. Suppose Bruno orders 10,000 kilograms each time. What is his average inventory (in kilograms)? Suppose Bruno orders 6,250 kilograms each time. How many orders does he place with his supplier each year? Note: Round your answer to 1 decimal place. How many kilograms should Bruno order from his supplier with each order to minimize the sum of the ordering and holding costs? If Bruno's storage vessel can hold only 2,000 kilograms of milk, what would be Bruno's annual ordering and holding costs if he orders this amount? If Bruno's storage vessel can hold only 7, 000 kilograms of milk, what would be Bruno's annual ordering and holding costs if he orders…
A publishing company sells 400,000 copies of a certain book each year. Ordering the entire amount printed at the beginning of the year ties up valuable storage space and capital. However, printing the copies in several partial runs throughout the year results in added costs for setting up each printing run, which costs $1000. The carrying costs, figured on the average number of books in storage, are $.50 per book. Find the most economical lot size, that is, the production run size that minimizes the total setting up andcarrying costs.

SEE MORE QUESTIONS

Recommended textbooks for you

Linear Algebra: A Modern Introduction

Algebra

ISBN:

9781285463247

Author:

David Poole

Publisher:

Cengage Learning

College Algebra (MindTap Course List)

Algebra

ISBN:

9781305652231

Author:

R. David Gustafson, Jeff Hughes

Publisher:

Cengage Learning

Linear Algebra: A Modern Introduction

Algebra

ISBN:

9781285463247

Author:

David Poole

Publisher:

Cengage Learning

College Algebra (MindTap Course List)

Algebra

ISBN:

9781305652231

Author:

R. David Gustafson, Jeff Hughes

Publisher:

Cengage Learning

SEE MORE TEXTBOOKS