Logo
Home Study Material Contact Search
AI Chat FREE
  1. business
  2. accounting
  3. use excel 1. the energetic company needs to make

use excel 1. The Energetic company needs to make plans for the energy...

80.2K

Verified Solution

Question

Accounting

image

use excel

1. The Energetic company needs to make plans for the energy systems for a new building. The energy needs in the building fall into three categories: (1) electricity, (2) heating water, and (3) heating space in the building. The daily requirements for these three categories (all measured in the same units) are 20 electricity units, 10 heating water units, and 30 space heating units. The three possible sources of energy to meet these needs are electricity, natural gas, and a solar heating unit that can be installed on the roof. The size of the roof limits the largest possible solar heater to 30 units, but there is no limit to the electricity and natural gas available. Electricity needs can be met only by purchasing electricity (at a cost of 50KWD per unit). Both other energy needs can be met by any source or combination of sources. The unit costs are given in the following table. The objective is to minimize the total cost of meeting the energy needs. a. Define the decision variables. (3 points) b. Formulate and solve a linear|program to minimize the energy costs of meeting the energy needs. (12 points)) c. Which heating requirement (water or space) would you consider reducing to lower cost? Explain. (5 points)

Answer & Explanation Solved by verified expert
Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:
  • Unlimited Question Access with detailed Answers
  • Zin AI - 3 Million Words
  • 10 Dall-E 3 Images
  • 20 Plot Generations
  • Conversation with Dialogue Memory
  • No Ads, Ever!
  • Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
Become a Member

Other questions asked by students