Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Please use Excel. The XYZ Company produces two products. The total revenue achieved from these products is described by the following equation: Total revenue =0.2X120.4X22+8X1+12X2+1500

image text in transcribed

Please use Excel.

The XYZ Company produces two products. The total revenue achieved from these products is described by the following equation: Total revenue =0.2X120.4X22+8X1+12X2+1500 where X1= thousands of units of product 1 X2= thousands of units of product 2 Every 1,000 units of X1 requires 1 hour of time in the shipping department, and every 1,000 units of X2 requires 30 minutes in the shipping department. Each unit of each product requires 2 pounds of a special ingredient, the cost of special ingredient is $1 per 1,000 units. Additionally, each hours of shipping labor costs $1. Demand for X1 and X2 is unlimited. Range X1, X2 between 10 and 15 with 0.1 increment. Use 2-way data table to find the optimal quantities to maximize profit

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Accounting questions