Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Spacey, a lithium battery manufacturer, produces two kinds of batteries. It uses the same raw material to manufacture those batteries, called RW. Each unit
Spacey, a lithium battery manufacturer, produces two kinds of batteries. It uses the same raw material to manufacture those batteries, called RW. Each unit of RW can be used to make 4 units of the first and 5 units of the second type of battery, respectively. The price of these batteries is dependent on the units of batteries produced. For example, if an n1 unit of the first battery is produced, the price would be $(4500 - 2*n1). Similarly, if an n2 unit of the second battery is produced, the price would be $(3000 - 3*n2). Obviously, battery prices cannot be negative. The cost of one unit of raw material is $2000. The company can decide how many units of raw material to be used for production. Assume that there are no costs other than raw material costs. Develop a spreadsheet model for this problem and solve it. What is the maximum profit?
Step by Step Solution
★★★★★
3.45 Rating (158 Votes )
There are 3 Steps involved in it
Step: 1
To solve this problem and find the maximum profit we can use a spreadsheet model with the following steps Step 1 Set up the spreadsheet Create a colum...Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started