Answered step by step
Verified Expert Solution
Link Copied!

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... blur-text-image

Get Instant Access to Expert-Tailored 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

Recommended Textbook for

Accounting

Authors: Carl S. Warren, James M. Reeve, Jonathan E. Duchac

22nd Edition

324401841, 978-0-324-6250, 0-324-62509-X, 978-0324401844

More Books

Students also viewed these Mathematics questions