35. A company .manufactures two types of trucks: 1 and 2. each truck must go through the painting shop and assembly shop. if the painting shop were completely devoted to painting type 1 truck, 800 per day could be painted, whereas if the painting shop were completely devoted to painting type 2 trucks, 700 per day could be painted. if the assembly shop were completely devoted to assembling truck 1 engines, 1500 per day could be assembled, and if the assembly shop were completely devoted to assembling truck 2 engines, 1200 per day could be assembled. Each type 1 truck contributes 1000$ TO PROFIT; EACH TYPE 2 TRUCK CONTRIBUTES $1500. use solver to MAXIMIZE company profit. i need to be done in the excel file i sent and with the data there. (35)
33- A manufacturing company makes two products. Each product can be made on either of two machines. The time in hours required to make each product on each machine is listed in the file. P03.33.XSLX. Each month 500 hours are available on each machine. Each month, customers are willing to buy up to the quantities of each group with the prices also given in the same file. The company goal is to maximize the revenue obtained from selling units during the next two months.
a. Determine how the company can meet this goal. assume that it will not produce any units in a month
that it can not sell in that month.
b. use solver table to see what happens if customer demands for each product on each month simultaneoulsy change by as much as plus or minus 30% in increments of 10% from their current values. Revise the model so you can use solver table to investigate the effect of these changes on total revenue. Does revenue change on this linear manner over this range? Can you explain intuitively and why it changes in the way it does. I need it to be done in the file i sent
Essay Writing Service Features
Our ExperienceNo matter how complex your assignment is, we can find the right professional for your specific task. My Essay Gram is an essay writing company that hires only the smartest minds to help you with your projects. Our expertise allows us to provide students with high-quality academic writing, editing & proofreading services.
Free revision policy$10
Free bibliography & reference$8
Free title page$8
How Our Essay Writing Service Works
First, you will need to complete an order form. It's not difficult but, in case there is anything you find not to be clear, you may always call us so that we can guide you through it. On the order form, you will need to include some basic information concerning your order: subject, topic, number of pages, etc. We also encourage our clients to upload any relevant information or sources that will help.Complete the order form
Once we have all the information and instructions that we need, we select the most suitable writer for your assignment. While everything seems to be clear, the writer, who has complete knowledge of the subject, may need clarification from you. It is at that point that you would receive a call or email from us.Writer’s assignment
As soon as the writer has finished, it will be delivered both to the website and to your email address so that you will not miss it. If your deadline is close at hand, we will place a call to you to make sure that you receive the paper on time.Completing the order and download