
Algebra and Trigonometry (6th Edition)
6th Edition
ISBN: 9780134463216
Author: Robert F. Blitzer
Publisher: PEARSON
expand_more
expand_more
format_list_bulleted
Question

Transcribed Image Text:26) A production manager wants to determine how many
units of each product to produce weekly to maximize
weekly profits. Production requirements for the products
are shown in the following table. What is the optimal
number of units for each product and the maximum
profit?. Complete the Excel spreadsheet provided and
run Solver to calculate the solution and answer the
following questions.
A. How many units of Product A should be produced?
B How many units of Product B should be produced?
C. How many units of Product C should be produced?
D. What is the Maximum Profit?
Material
1
Material
2
Product
A
Material
Cost per
unit
3
pounds
per unit
2
pounds
per unit
Selling
Price per $101
unit
$31
Product
B
1
pounds
per unit
4
pounds
per unit
$67
$27
Product
C
5
pounds
per unit
0
pounds
per unit
$97.50
$35
Maximum
Available
300
pounds
400
pounds
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by stepSolved in 3 steps with 1 images

Knowledge Booster
Similar questions
- Use excel to make the calculations One product has a holding cost of $250 per year. This product can be shipped in either 3 or 8 day shipping, with the faster shipping costing $2 more per product. Using the slower method would be how much more expensive per product than the faster method? Auto sales over a 4-month period were forecasted as follows: 89, 98, 105, and 97. The actual results over the 4-month period were as follows: 92, 96, 101, and 100. What was the MAD of the 4-month forecast? The errors in a particular forecast are as follows: 3, -3, 4, 0, -2. What is the tracking signal for each period of the forecast?arrow_forwardA certain city's power company charges their residents for electricity usage on a daily basis. There is a basic charge of 11.57 cents. For each day the first 10 kWh cost 4.81 cents per kWh and any additional kWhs are 9.69 per kWh. (A kWh, or kilowatt-hour, is a unit of energy.) (a) Complete the following table using the information provided above. kWhkWh 0 5 10 15 20 cost (dollars)cost (dollars) kWhkWh 25 30 35 40 cost (dollars)cost (dollars) (b) We can define a piecewise function f(x)f(x) where xx is the kWh used in a day and f(x)f(x) is the cost, in dollars. This function would have the form f(x)={g(x)h(x)ififx∈Ax∈Bf(x)={g(x)ifx∈Ah(x)ifx∈B What functions g(x)g(x) and h(x)h(x) make up the piecewise function f(x)f(x)? g(x)=g(x)= for A = h(x)=h(x)= for B = Hint: A and B are intervals. If an interval uses ±∞±∞ write inf or -inf . (c) Using the above function, what is the cost of 26 kWh? dollars. (d) For 3 dollars, what is the maximum kWh usage for one…arrow_forwardStep 3: Assess the Evidence (Calculate the test statistic for the observed sample mean. Sketch the T-distribution and identify the position of the observed test statistic. Shade the area that represents the P-value. Use the test statistic to find the P-value.)arrow_forward
- (B) What price should the company charge for the phones, and how many phones should be produced to maximize the weekly profit? What is the maximum weekly profit? phones each week at a price of $ The company should produce (Round to the nearest cent as needed.)arrow_forward5 Imagine that a company sells portable walkie-talkie radios to construction crews. The batteries for these radios last for an average of 55 hours. The purchasing manager for this company receives a brochure in the mail that advertises a new brand of batteries. This new brand of batteries is cheaper than the brand that the company currently uses. However, the purchasing manager is concerned that the cheaper batteries may have a shorter average battery life than the current brand. (Note: The number of hours that batteries last is called their battery life.) The pricing manager installs 40 randomly selected batteries of the cheaper brand in the company's walkie-talkie radios. He finds that the mean battery life for the sample is 52 hours, with a standard deviation of 10 hours. He wants to perform a statistical test at the 1% level of significance to determine whether the cheaper batteries have a shorter average battery life span than the average life span of the brand of batteries the…arrow_forward14 Joe wants to know his annual salary when he works for a certain number of hours at a constant hourly rate. Identify the input and output. andu DRAG & DROP THE ANSWER Output Annual salary Number of hoursarrow_forward
arrow_back_ios
arrow_forward_ios
Recommended textbooks for you
Algebra and Trigonometry (6th Edition)AlgebraISBN:9780134463216Author:Robert F. BlitzerPublisher:PEARSON
Contemporary Abstract AlgebraAlgebraISBN:9781305657960Author:Joseph GallianPublisher:Cengage Learning
Linear Algebra: A Modern IntroductionAlgebraISBN:9781285463247Author:David PoolePublisher:Cengage Learning
Algebra And Trigonometry (11th Edition)AlgebraISBN:9780135163078Author:Michael SullivanPublisher:PEARSON
Introduction to Linear Algebra, Fifth EditionAlgebraISBN:9780980232776Author:Gilbert StrangPublisher:Wellesley-Cambridge Press
College Algebra (Collegiate Math)AlgebraISBN:9780077836344Author:Julie Miller, Donna GerkenPublisher:McGraw-Hill Education

Algebra and Trigonometry (6th Edition)
Algebra
ISBN:9780134463216
Author:Robert F. Blitzer
Publisher:PEARSON

Contemporary Abstract Algebra
Algebra
ISBN:9781305657960
Author:Joseph Gallian
Publisher:Cengage Learning

Linear Algebra: A Modern Introduction
Algebra
ISBN:9781285463247
Author:David Poole
Publisher:Cengage Learning

Algebra And Trigonometry (11th Edition)
Algebra
ISBN:9780135163078
Author:Michael Sullivan
Publisher:PEARSON

Introduction to Linear Algebra, Fifth Edition
Algebra
ISBN:9780980232776
Author:Gilbert Strang
Publisher:Wellesley-Cambridge Press

College Algebra (Collegiate Math)
Algebra
ISBN:9780077836344
Author:Julie Miller, Donna Gerken
Publisher:McGraw-Hill Education