Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Problem Harold Finch is the owner of Finch Computer Parts which produces two types of video cards. The manufacture of each card requires processing on

image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
Problem Harold Finch is the owner of Finch Computer Parts which produces two types of video cards. The manufacture of each card requires processing on each of three machines with the following processing times (in hours). Video Card Machine 1 2 3 A 1.5 2 2.2 B 3 2 1 Each machine is available 12 hours per day. The unit profit for video card A and B are $25 and $30 respectively. You want to determine the maximum daily profit from manufacturing these video cards. Formulate this problem on the Excel printout below (you do not need to enter formulas) and answer the questions 4), 5), and 6). A B D E F 1 2 3 4 5 6 7 8 ant 9 10 4) The symbol in the cell D6 should be: a) X+Y b) PFT c) LHS d) RHS 5) The value in the cell F9 should be: a) 12 b) 25 c) 30 d) x 6) What is the excel function and arguments for calculating the amount of Machine 1 resources that are used? 6) What is the excel function and arguments for calculating the amount of Machine 1 resources that are used? a) PRODUCT($B$3:$C$3;B7:07) b) SUMPRODUCT($B$3:$C$3;B7:C7) c) SUM(SB$4:$C$4;B7:07) d) SUMPRODUCT($B$4:$C$4;B7:07)

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

More Books

Students also viewed these Finance questions