Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

How do you find the numbers that are highlighted in orange on the excel? The Martinez Model Car Company produces four sifferent radio-controlled model cars

How do you find the numbers that are highlighted in orange on the excel?

image text in transcribedimage text in transcribed The Martinez Model Car Company produces four sifferent radio-controlled model cars based on exotic rioduction models: Ferrari, BMW, Lotus, and Tesla. ach model requires production in five departments: a. How many of each type of car should be produced to maximize profit? b. If marketing requires that at least 40 units of each be produced each day, what is the optimal production plan and profit? Before you solve this, how would you expect the profit to compare with = your answer to part a? c. What happens if marketing requires that at least 8) 50 units of each be produced each day? \begin{tabular}{|c|c|c|c|c|c|c|} \hline \multirow[t]{2}{*}{ Martinez Model Cars } & & \multicolumn{2}{|c|}{ Problem 13.26a, Evans } & \multirow[b]{2}{*}{ X4 } & & \multirow[b]{2}{*}{Max3501+3302+2703+2554} \\ \hline & X1 & X2 & X3 & & & \\ \hline Minutes/Unit & Ferrari & BMW & Lotus & Tesla & Minutes Available & 51+3.502+13+34=0 \\ \hline Price & $350.00 & $330.00 & $270.00 & $255.00 & & \\ \hline & & & & & & \\ \hline & & & & & & \\ \hline & & & & & Total & \\ \hline Cars Manufactured & 0.00 & 56.01 & 103.06 & 58.81 & 217.88 & \\ \hline Profit & $0.00 & $18,483.08 & $27,825.44 & $14,996.50 & $61,305.02 & 61305.02 \\ \hline Minutes/Unit & Ferrari & BMW & Lotus & Tesla & Minutes Used & \\ \hline Mold & 5.00 & 3.50 & 1.00 & 3.00 & 475.52 & \\ \hline Sand & 4.00 & 3.20 & 2.00 & 3.65 & 600.00 & \\ \hline Polish & 3.50 & 2.00 & 3.00 & 1.00 & 480.00 & \\ \hline Paint & 3.75 & 3.25 & 1.75 & 2.00F & 480.00 & \\ \hline Finsih & 4.00 & 1.00 & 2.00 & 3.00 & 438.55 & \\ \hline & & & & & & \\ \hline & & & & & & \\ \hline & & & & & & \\ \hline \end{tabular}

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

Portfolio Performance Measurement And Benchmarking

Authors: Jon Christopherson, David Carino, Wayne Ferson

1st Edition

0071496653, 978-0071496650

More Books

Students also viewed these Finance questions

Question

4. Identify cultural variations in communication style.

Answered: 1 week ago

Question

9. Understand the phenomenon of code switching and interlanguage.

Answered: 1 week ago

Question

8. Explain the difference between translation and interpretation.

Answered: 1 week ago