Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

naterial cost per unit is $175.00 and the labor cost per unit is $40.00. The company expects that the revenue per unit will be $750.00.

image text in transcribed

naterial cost per unit is $175.00 and the labor cost per unit is $40.00. The company expects that the revenue per unit will be $750.00. Note: the material cost and labor cost together make up the variable cost per unit. Assuming that after the sales, profit is calculated based the difference in the revenue and total cos nvested, answer the below - a Build an influence diagram that illustrates the profit. (10 pts) Define mathematical notations for each node. (5 pts) . From a and b, show the mathematical model that calculates profit. (10 pts) 1. From a, b and c; implement the model in excel using the principles of good spreadsheet design. (15 pts) . If the company makes and sells 2,000 phones what is the resulting profit? (5 pts) nterval does the breakeven occur. (10 pts) g. Use goal seek to find the exact breakeven point for the quantity of units to be produced (5 pts) . Use scenario manager to generate the profit for the below three scenarios (15 pts) naterial cost per unit is $175.00 and the labor cost per unit is $40.00. The company expects that the revenue per unit will be $750.00. Note: the material cost and labor cost together make up the variable cost per unit. Assuming that after the sales, profit is calculated based the difference in the revenue and total cos nvested, answer the below - a Build an influence diagram that illustrates the profit. (10 pts) Define mathematical notations for each node. (5 pts) . From a and b, show the mathematical model that calculates profit. (10 pts) 1. From a, b and c; implement the model in excel using the principles of good spreadsheet design. (15 pts) . If the company makes and sells 2,000 phones what is the resulting profit? (5 pts) nterval does the breakeven occur. (10 pts) g. Use goal seek to find the exact breakeven point for the quantity of units to be produced (5 pts) . Use scenario manager to generate the profit for the below three scenarios (15 pts)

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

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

International Corporate Finance

Authors: Mark R. Eaker, Frank J. Fabozzi, Dwight Grant

1st Edition

0030693063, 9780030693069

More Books

Students also viewed these Finance questions

Question

please dont use chat gpt or other AI 1 8 5 . mRNA

Answered: 1 week ago

Question

differentiate the function ( x + 1 ) / ( x ^ 3 + x - 6 )

Answered: 1 week ago