Answered step by step
Verified Expert Solution
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?
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
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started