Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Create a new worksheet named Q2. A company needs to buy two types of machines. Each type-A machine costs 1 million dollars and each type-B

Create a new worksheet named Q2. A company needs to buy two types of machines. Each type-A machine costs 1 million dollars and each type-B machine costs 1.5 million dollars. The company is figuring out the total cost of buying these two types of machines. (1) In worksheet Q2 build a model that calculates total cost of buying machines given two inputs: the number of type-A machine to buy, and the number of type-B machine to buy. For example, if 2 units of type-A machine and 3 units of type-B machine are purchased, then total cost is 1x2+1.5x3 million dollars. Of course, your model should be able to calculate total cost given any combination of the two inputs. (2) In the same worksheet use a two-way data-table to perform a what-if analysis. In the table, each of the two inputs (discussed above) change from 0 to 10 with an increment of 1, and the table shows the corresponding total costs. Figure below shows the data table. For example, the active cell in the figure shows 5.5 (million dollars), which is the total cost of buying 1 (highlighted in the figure for illustration purpose) unit of type-A machine and 3 (highlighted in the figure for illustration) units of type-B machine. Please note that you are required to use data table to solve this problem. When a data table is created, Excel assigns a formula to each cell inside the data table. If I couldnt find formulas inside your data table, my conclusion will be that you manually entered data and you then gain no credit.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

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_2

Step: 3

blur-text-image_3

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

Sustainable Fashion Supply Chain Management

Authors: Tsan Ming Choi, T C Edwin Cheng

1st Edition

3319127020, 978-3319127026

More Books

Students also viewed these General Management questions

Question

Explain what is meant by the click, call, face model.

Answered: 1 week ago