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 teenagersand children. Their Production Supervisor analyzed each of the operations and concluded that if the company produces apps for children, each appwould require 7 hours in the theme creation department, 11 hours in the graphics and imaging department, 4 hours in the educational contentdepartment, 7 hours in the coding department, and 4 hours in the testing and launching department. On the other hand, each app for teenagerswould require 6 hours in the theme creation department, 14 hours in the graphics and imaging department, 12 hours in the educational contentdepartment, 10 hours in the coding department, and 1 hour in the testing and launching department. After studying the departmental workloadprojections, the Production Supervisor estimates that 100 hours for theme creation, 250 hours for graphics and imaging, 200 hours for theeducational content creation, 150 hours of coding and 50 hours for the testing and launching are available for the production of the new appsduring 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 aprofit 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, atleast 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 theylaunch 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 wouldbe.Write out the Linear Program (equations) in the space given below. DO NOT refer me to "see the excel file".Edit ViewInsert Format Tools Table12pt vParagraph vB I U AT? v|

Name: Can someone please help me on the following problem using excel. Refer
Uploaded: 2024-03-20T07:07:26.000Z
Channel: Bartleby
Description: 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 teenagersand children. Their Production Supervis

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 teenagersand children. Their Production Supervisor analyzed each of the operations and concluded that if the company produces apps for children, each appwould require 7 hours in the theme creation department, 11 hours in the graphics and imaging department, 4 hours in the educational contentdepartment, 7 hours in the coding department, and 4 hours in the testing and launching department. On the other hand, each app for teenagerswould require 6 hours in the theme creation department, 14 hours in the graphics and imaging department, 12 hours in the educational contentdepartment, 10 hours in the coding department, and 1 hour in the testing and launching department. After studying the departmental workloadprojections, the Production Supervisor estimates that 100 hours for theme creation, 250 hours for graphics and imaging, 200 hours for theeducational content creation, 150 hours of coding and 50 hours for the testing and launching are available for the production of the new appsduring 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 aprofit 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, atleast 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 theylaunch 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 wouldbe.Write out the Linear Program (equations) in the space given below. DO NOT refer me to &#34;see the excel file&#34;.Edit ViewInsert Format Tools Table12pt vParagraph vB I U AT? v|

Accepted Answer

Let the number of apps made for children = x
Let the number of apps made for teenagers = y
For each…