Can someone please help me on the following problem

Advanced Engineering Mathematics
10th Edition
ISBN:9780470458365
Author:Erwin Kreyszig
Publisher:Erwin Kreyszig
Chapter2: Second-order Linear Odes
Section: Chapter Questions
Problem 1RQ
icon
Related questions
Topic Video
Question

Can someone please help me on the following problem using excel. 

Refer to the Par Insights, Inc. example in your textbook. A competitor firm DLS Apps, Inc. decides to enter the market for apps made for teenagers
and children. Their Production Supervisor analyzed each of the operations and concluded that if the company produces apps for children, each app
would require 7 hours in the theme creation department, 11 hours in the graphics and imaging department, 4 hours in the educational content
department, 7 hours in the coding department, and 4 hours in the testing and launching department. On the other hand, each app for teenagers
would require 6 hours in the theme creation department, 14 hours in the graphics and imaging department, 12 hours in the educational content
department, 10 hours in the coding department, and 1 hour in the testing and launching department. After studying the departmental workload
projections, the Production Supervisor estimates that 100 hours for theme creation, 250 hours for graphics and imaging, 200 hours for the
educational content creation, 150 hours of coding and 50 hours for the testing and launching are available for the production of the new apps
during the next four months.
The accounting department analyzed the costs based on the production data and overheads and arrived at prices for the apps that will result in a
profit contribution of $12,000 per children's app and $16,000 per teenager app produced. The CEO asserts that to be successful in the long run, at
least 4 children's apps must be launched in the next four months. The management is trying to identify how many apps of each type should they
launch in the next four months and have hired you to help them figure out what the optimal solution would be and what the expected profits would
be.
Write out the Linear Program (equations) in the space given below. DO NOT refer me to "see the excel file".
Edit View
Insert Format Tools Table
12pt v
Paragraph v
B I U A
T? v
|
Transcribed Image Text:Refer to the Par Insights, Inc. example in your textbook. A competitor firm DLS Apps, Inc. decides to enter the market for apps made for teenagers and children. Their Production Supervisor analyzed each of the operations and concluded that if the company produces apps for children, each app would require 7 hours in the theme creation department, 11 hours in the graphics and imaging department, 4 hours in the educational content department, 7 hours in the coding department, and 4 hours in the testing and launching department. On the other hand, each app for teenagers would require 6 hours in the theme creation department, 14 hours in the graphics and imaging department, 12 hours in the educational content department, 10 hours in the coding department, and 1 hour in the testing and launching department. After studying the departmental workload projections, the Production Supervisor estimates that 100 hours for theme creation, 250 hours for graphics and imaging, 200 hours for the educational content creation, 150 hours of coding and 50 hours for the testing and launching are available for the production of the new apps during the next four months. The accounting department analyzed the costs based on the production data and overheads and arrived at prices for the apps that will result in a profit contribution of $12,000 per children's app and $16,000 per teenager app produced. The CEO asserts that to be successful in the long run, at least 4 children's apps must be launched in the next four months. The management is trying to identify how many apps of each type should they launch in the next four months and have hired you to help them figure out what the optimal solution would be and what the expected profits would be. Write out the Linear Program (equations) in the space given below. DO NOT refer me to "see the excel file". Edit View Insert Format Tools Table 12pt v Paragraph v B I U A T? v |
Expert Solution
steps

Step by step

Solved in 2 steps

Blurred answer
Knowledge Booster
Optimization
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, advanced-math and related others by exploring similar questions and additional content below.
Recommended textbooks for you
Advanced Engineering Mathematics
Advanced Engineering Mathematics
Advanced Math
ISBN:
9780470458365
Author:
Erwin Kreyszig
Publisher:
Wiley, John & Sons, Incorporated
Numerical Methods for Engineers
Numerical Methods for Engineers
Advanced Math
ISBN:
9780073397924
Author:
Steven C. Chapra Dr., Raymond P. Canale
Publisher:
McGraw-Hill Education
Introductory Mathematics for Engineering Applicat…
Introductory Mathematics for Engineering Applicat…
Advanced Math
ISBN:
9781118141809
Author:
Nathan Klingbeil
Publisher:
WILEY
Mathematics For Machine Technology
Mathematics For Machine Technology
Advanced Math
ISBN:
9781337798310
Author:
Peterson, John.
Publisher:
Cengage Learning,
Basic Technical Mathematics
Basic Technical Mathematics
Advanced Math
ISBN:
9780134437705
Author:
Washington
Publisher:
PEARSON
Topology
Topology
Advanced Math
ISBN:
9780134689517
Author:
Munkres, James R.
Publisher:
Pearson,